4,403 reputation
1821
bio website boringnerdystuff.wordpress.co…
location Indiana, USA
age
visits member for 2 years, 1 month
seen Nov 8 at 6:31

Jan
9
reviewed Approve suggested edit on How to use CropCoverage Render Transformation in Geoserver SLD (WPS)?
Jan
8
answered Create Geographic Reference for X,Y Coordinates
Jan
8
comment How to get sum of table column values into Python variable?
Yep, you're right. Ignore that second example, the da.SearchCursor is a much better option.
Jan
8
revised How to get sum of table column values into Python variable?
Forgot for loop
Jan
8
answered How to get sum of table column values into Python variable?
Jan
6
reviewed Approve suggested edit on Autocorrelation: Best way to assess mixed uses and building scales?
Jan
6
reviewed Approve suggested edit on Alternatives to Business Analyst, AnySite/MapInfo, and Sites To Do Business?
Jan
6
reviewed Approve suggested edit on How do I retrieve start and end point coordinates with Python/arcpy?
Jan
5
reviewed Approve suggested edit on How to load shapefile in Oracle Spatial
Jan
4
reviewed Approve suggested edit on How to Calculate North?
Jan
3
comment SpatialLite BulkLoad and Merge
One good reason to go with PostGIS is its query planner will automatically use spatial indexes while you have to manually join to Spatialite's spatial index tables. For a dataset this large the indexes will make a world of difference.
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
let us continue this discussion in chat
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
Yes, PGBIN needs to point to the directory that psql is in. Use the command which psql to see where psql lives. Then you can set the path in the tiger.loader_platform table I believe.
Jan
3
comment ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
That fixed it and it saves some space. Thanks!
Jan
3
accepted ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
Jan
3
revised ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
deleted 7 characters in body
Jan
3
asked ArcPy: Drop fields from list of fields for arcpy.da.SearchCursor
Jan
3
revised Install PostGIS and TIGER Data in Ubuntu 12.04
Added section on setting up geocoder lookup tables, etc.
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
Double sorry! I forgot about that too! First thing to check will be your database's search path, make sure the tiger schema is in there. 2nd thing to check is in the tiger schema there are tables, tiger.loader_platform and tiger.loader_variables that tell your scripts your password and other information. Use PGAdmin to edit those. Finally, before running your loader script run the loader_generate_nation function to set up all the tables that the geocoder needs. I'll edit my answer to fill in these blanks.
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
Sorry! I forgot most people don't use their normal user accounts to run psql. You'll need to save the script somewhere that your postgres user has write permission. Easiest is to use \o /tmp/loader_script.sql which will save the file to /tmp. Then to run the file it will be sh ./tmp/loader_script.sql.