Reputation
7,775
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
6 72 158
Impact
~814k people reached

Jul
8
asked Optimizing a nearest neighbor calculation using PostGIS
Jul
8
comment Nearest Neighbor calculation in PostGIS
Thanks for your answer Mike. I used it, and now understand what is going on. Maybe I should ask this as a new question, but is there a way of optimizing the calculation? For example if I have 100 polygons that is 10,000 calculations. I happen to have 1,000,000 polygons and am wondering how to scale down the calculation.
Jul
8
comment arcpy taking longer and longer in a loop
I agree with @blord - where your del row is now, it just deletes the last row, rather than each iteration of the loop.
Jul
7
accepted How do you cite ArcGIS?
Jul
7
comment Error importing Shapefile to PostGIS using Importer GUI
I'm not certain what I was doing wrong previously, but I followed the steps here: workshops.opengeo.org/stack-intro/postgis.html and managed to import data succesfully.
Jul
7
asked Nearest Neighbor calculation in PostGIS
Jul
7
comment How to find the minimum edge to edge distance of polygons?
@Paul I just tried using QGIS to load data from a PostGIS database. There is a SQL query builder in it; do you know how I would run your code using this structure?
Jul
7
comment Error importing Shapefile to PostGIS using Importer GUI
When I try the line \i /usr/share/pgsql/contrib/postgis-1.5/postgis.sql; I get the error message 'No such file or directory'. Where can I check if this exists? I'm not sure if it makes a difference that I'm using windows. I was able to run the two GRANT lines.
Jul
7
revised Error importing Shapefile to PostGIS using Importer GUI
added 10 characters in body
Jul
7
revised Error importing Shapefile to PostGIS using Importer GUI
added 968 characters in body
Jul
6
comment Error importing Shapefile to PostGIS using Importer GUI
it seems that geography() is not a term I can use in my import query. How can I check if I installed all the postgis parts correctly?
Jul
6
revised Where to get raster files of Earth, united states
added 119 characters in body
Jul
6
answered Where to get raster files of Earth, united states
Jul
6
comment Error importing Shapefile to PostGIS using Importer GUI
I did tick this box - I'm using PostGIS 1.5.2 so I assume it is an error on my part. I was able to import a shapefile when I choose just to import the attributes.
Jul
6
comment Error importing Shapefile to PostGIS using Importer GUI
Should I be using a different Column Geometry to geog? I'm not familiar with the different types.
Jul
6
comment Error importing Shapefile to PostGIS using Importer GUI
I just installed PostGIS and I think it is the most recent version, so I assumed it supports geography columns. Where do I paste the code that you wrote above? Is it in the PGAdmin SQL window? (Thanks for the comprehensive answer).
Jul
6
revised Error importing Shapefile to PostGIS using Importer GUI
added 770 characters in body
Jul
6
asked Error importing Shapefile to PostGIS using Importer GUI
Jun
29
answered Code to convert WGS84 coordinates to British National Grid Easting/Northings
Jun
28
comment Populating field with max M value of feature using Python in ArcGIS Field Calculator?
You are also able to use VBA in ArcGIS 10 also, if you want too. You just tick the box VBA, instead of Python when in the field calculator.