4,525 reputation
1821
bio website boringnerdystuff.wordpress.co…
location Indiana, USA
age
visits member for 2 years, 2 months
seen 6 hours ago

Jan
5
reviewed Approve How to load shapefile in Oracle Spatial
Jan
4
reviewed Approve 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.
Jan
3
answered Install PostGIS and TIGER Data in Ubuntu 12.04
Jan
3
comment Install PostGIS and TIGER Data in Ubuntu 12.04
What version of PostGIS are you running? Is it the version packaged with 12.04 or have you upgraded? If you can you want to run the latest PostGIS, 2.1.1. The TIGER Geocoder that comes with that version is much better than the version that works with PostGIS 1.5.
Jan
2
revised Some remote sensing tutorials
Added tags
Jan
2
reviewed Approve Inaccurate result while clipping on gis data
Jan
2
comment Calculate distance of points along a route QGIS
Is the data stored in a PostGIS database?
Dec
31
answered Exporting all attributes from a GPX file
Dec
31
reviewed Approve Is there a way to keep toll_booth nodes in osm2po's output?
Dec
30
reviewed Approve Network Analyst in Arcgis to generate the network for further analysis what should the attribute table must contain?