Tagged Questions

4
votes
2answers
65 views

What are the benefits of using ArcGIS with Postgresql over simply ArcSDE?

I understand that in order to benefit from ArcGIS spatial datatypes (ST_GEOMETRY, versioned geodatabases etc.) ArcSDE needs to be installed - and with the 10.1 client it is automatically installed ...
2
votes
0answers
51 views

How to Create database using OGC compliant geometries and Custom type Geometries?

I am interested in storing geometry attributes in a PostGis database, so that it would be OGC compliant, along with OGC compliant geometry types like point,line, linestring, etc. I also wanted to ...
7
votes
1answer
139 views

Is there a significantly faster way to buffer than arcmap?

I hope this question is appropriate here and I apologize if it is more of a discussion question than a specific technical problem. I have to buffer 150,000 polygons for a real estate project. While ...
2
votes
1answer
52 views

point of intersection issues

I have a table containing a set of points of intersections. Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of ...
2
votes
2answers
70 views

Where can I find the freeware ST-Links PgMap?

I am trying to connect to a PostGIS database from ArcGIS Desktop 9.3.1 Some web-searching suggested that zigGIS would be useful. Unfortunately zigGIS has reached the end of life, and the author of ...
1
vote
0answers
27 views

Creation of 3d terrain from real data [duplicate]

Possible Duplicate: 3d terrain from data in postgres I am pretty new to spatial database and 3D data. I have a project where i have to create a 3d terrain from data being taken by me by a ...
10
votes
1answer
202 views

Open-source software for managing terabytes of different formats of geospatial data?

I have a problem that I am sure many GIS Teams or Departments have which is how to find, keep track of and manage multiple different datasets from multiple sources. I have read the responses from a ...
6
votes
1answer
822 views

Postgresql for Qgis and Arcgis - What to do/What not to do

Is it possible to use postgresql with QGIS and ArcGIS? One database for different clients. Is it anything that I have worry or any problems to use the DBMS from two different software? I know that I ...
2
votes
1answer
237 views

accessing postgis raster data using Query layer in ArcGIS

I tried to load raster file (jpg) into post gis using the syntax provided here "C:\Program Files (x86)\PostgreSQL\9.1\bin>raster2pgsql -I -C -e -Y -F -s 102003 -t 300x300 ras_test.tif ras_test1 | psql ...
3
votes
2answers
280 views

How to determine Parcel Neighbors?

i like to get the neighbors of the Parcels "P1" like following : From B1 to B2 => P5 B2 => P4 From B2 to B3 => P3 From B3 to B4 => P2 From B4 to B1 => P6 i like to make this process automatic ...
1
vote
1answer
1k views

How to connect ArcGIS Destkop 10 with PostGIS [duplicate]

Possible Duplicate: How can I connect to a PostGIS database from ArcMap 9.3 and 10.0? I've installed postGIS 1.5.3, and would like to connect it from ArcGIS Destkop v10. Which is the best ...
5
votes
1answer
633 views

Why do simplify polygon results differ between ArcGIS and PostGIS?

I am mainly interested in why and how the Simplify Polygons tool in ArcGIS handles the simplification process, including preventing and resolving topological errors better than the equivalent ...
1
vote
0answers
126 views

I am getting a blank layer preview from geoserver after Quick Exporting my shapefile to postgis and then getting postgis to point to geoserver

What could be the potential problems? Looking at the layer's data fields/form the one thing that isn't filled is the Native SRS and its source, but I have already passed in the projection info as it ...
16
votes
3answers
2k views

How can I calculate the average width of a polygon?

I'm interested in examining the average width of a polygon that represents the road surface. I also have the road centerline as a vector (which is sometimes not exactly in the center). In this example ...
1
vote
1answer
115 views

How Do I Debug QuickExport Parameters in the Data Interoperability Extension for ArcGIS 10 to Exporting to Postgres

I tried to configure the QuickExport parameters by examining the log file after I used the QuickExport tool itself. The only things I changed from the log file are the parameters as I want the user to ...
4
votes
1answer
175 views

Migrating Feature Datasets from ArcSDE to postgis

I am currently planning the migration of a database from ArcSDE/ Arcmap to postgis / Qgis. The data is stored in raster catalogues and feature datasets. Is there an equivalent to feature datasets ...
2
votes
1answer
169 views

Automated correction of parcel geometry based on area measure

i have a set of parcels in DWG file and i have the areas that should be in these parcels in an excel file, so i have to modify each parcel to match the area specified in the excel file with a moving ...
2
votes
1answer
210 views

exporting lat/long points from shp file gives crazy results

i downloaded a shape file from the dept of city planning of NYC I use shp2pgsql to create a table (nybb) I use http://prj2epsg.org/search to determine my srid is 2263. which i then set. select ...
5
votes
1answer
477 views

Memory leak in ArcGIS aggregate points/buffer/Addfield/cursor

I am starting to have concerns about the ability of ArcGIS 10 to fulfill a deliverable of mine. It got me to wondering what exactly else there is, that can perform similar functionality? ET ...
1
vote
2answers
298 views

bulk upload shp to postgis [duplicate]

Possible Duplicate: Bulk load multiple shapefiles into PostGIS Is it possible to bulk upload shp files into postgis. Im currently playing around with postgis, qgis and geoserver (as a ...
12
votes
3answers
888 views

Future of spatial databases

It may be a bit off-topic. I am eager to know the industry specific importance of Spatial Databases. Is Spatial Database a very important part of any GIS system? Or will we use other technologies to ...
1
vote
1answer
445 views

Circle features missing in PostGIS after import from ArcGIS using ogr2ogr

I have a ArcGIS feature class of geometry type polygon. It was created as a convex hull with a 200 meter buffer on a point dataset, aggregating rows on a particular field. The number of points used to ...
23
votes
5answers
5k views

ArcGIS and PostGIS

Has anyone successfully used PostgreSQL with PostGIS successfully? I am a semi-experienced ArcGIS user and want to build out a database and connect it to ArcCatalog. I've scoured the internet for ...
3
votes
1answer
526 views

ArcGIS Flex Polygon to PostGIS Polygon

ArcGIS supports building polygons within the flex component that contain self-intersecting rings, as well as rings that touch at multiple points (breaking the "arbitrary" rules here: ...
22
votes
9answers
9k views

How can I connect to a PostGIS database from ArcMap 9.3 and 10.0?

How can I connect to a PostGIS database from ArcMap 9.3 or 10.0? Ideally, I would like to be able to perform spatially enabled queries and receive the results back (e.g. spatial and non-spatial ...