نتائج البحث

I was trying to generate shapefile from postgis tables using pgsql2shp. Everything is fine except for table with no rows. When trying to create shapefile from an empty table, an error occurs: Could not determine table metadata (empty table) I checked the source code of pgsql2shp in git and it...

I've a website where I'm giving the functionality of creating and editing line features. I'm using Leaflet-Draw plugin for drawing, PostGIS for storing the data and GeoJSON to display it on map. My next task is to add the Export functionality. I've search around and found that using ogr2ogr I...

I am trying to map data by querying a table called xyz. I need to show the the_geom data on the map. I have below query in my mapserver .map file: DATA "the_geom from xyz using unique id using SRID=xxxx"I need to generate a shape file in order to get the data. I have SHAREPATH "../data"...

How to convert post gis database into shapefile, I found that I need to use pgsql2shp command on postgis database query , But how to use it and where to use it. Do I have to use it in the postgre sql database command line or in the normal command line? أكثر...

I have the PostGIS extension (postgis functions and spatial_ref_sys table) added to a specific schema called postgis. I'm wanting to run the pgsql2shp utility with a select query on geometries stored in other schemas that do not have postgis functions available within their respective schemas...

I work with Postgis. I have table CREATE TABLE centerline( gid serial NOT NULL, l_from integer, l_to integer, r_add_pre character varying(15), r_to integer ... }Export this table with PGSQL2SHP command command is pgsql2shp -f centerline.shp -h localhost -u redsky ....and when I...

I am working on a global project for which I want to use OSM data as a model input. I am looking for advice on the best way to produce 1x1 degree WGS84 shapefiles from either regional extracts or the full planet file. I am planning to produce separate road and polygon shapefiles for each 1x1...

I have a python script that i am trying to run in order to dump a postgres table and I noticed there is a pgsql2shp command in bash to perform this easily but I would like to incoperate the same command in a python script and also use parameter substitution. I thought the following would work...

I'm trying to export a table from PostGIS using pgsql2shp. The basic query to export the entire table works fine using the following format: "C:\Program Files\PostgreSQL\9.1\bin\pgsql2shp.exe" -f "D:\path\shapefile.shp" -hlocalhost -p 5432 -u postgres -P xxxx mapdata...

I try to export geographical data from a postgis database to a shapefile with pgsql2shp. Normally this works fine, but now I receive the following error. Preparing table for user query... Done. Initializing... ZMflagQuery: ERROR: function zmflag(geometry) does not existLINE 1: SELECT...

I have a database and exporting with pgsql2shp various shapefiles. But when I open the dbf the characters are displayed wrong. Example: Broeksterw أكثر...

Dear Readers: Blogging has been light recently due to the demands of reading student essay, writing exams, and grading exams as the autumn academic term comes to an end. In my two-term class on Global Human Geography at Stanford University, I give both multiple-choice and essay exams, the first...

GIS industry has OGC. What standards do CAD software have? أكثر...

I have one table with coordinates (Long/Lat) and based on this table I am creating objects (points) into the cosmetic layer. Therefore I have two questions: Is it possible to create the objects directly into the table layer? Can you please share some example? Can I have the objects copied...

I am using ArcMap 10.1 and I would like to remove all transparency from all the layers in the map at once. أكثر...

This question already has an answer here: Symbolizing using RGB values from Excel in ArcGIS for Desktop? 1 answer I would like to Convert RGB values from a CSV to a ArcMAP save as a layer file. I have...

I've just unsuccessfully tried to use ogr2ogr to convert CSV into KML like so: ogr2ogr -f "KML" output.kml input.csvThe csv has "latitude" and "longitude" columns. The attributes are all loaded but if you inspect the KML's text, the Coordinate elements are not being added so its not working...

This map shows the distribution of Hispanic populations in Georgetown and city council districts. Georgetown has 7 city council districts and a high Hispanic population (21.8%). Cities are typically racially segregated, as seen in GIS lab #18. Here, it is apparent that some council districts...

Bonjour, je cherche à représenter le tissu urbain d'une aire urbaine. Pour cela je souhaite sélectionner sur la couche contenant tout le bâti, ceux qui sont à une distance inférieur à 200 mètres à partir du centre de la plus grande ville et lorsqu'il y a une rupture et qu'un bâtiment se situe...

This Exelis blog provides an excellent overview on the topic of fusing lidar with hyperspectral data. This is not a trivial problem and in fact some are doubtful of the results in general, but for... Click Title to Continue Reading... أكثر...