1,220 reputation
1414
bio website walkercivil.com
location Tuscaloosa, AL
age 42
visits member for 2 years, 2 months
seen 5 hours ago

GIS Manager for a civil engineering firm -- Currently doing most of my work with QGIS, postGIS, spatiaLite. Working to bring GIS to smalltown, USA.


Mar
6
comment How create geographic column in postgis table?
Use row_number() OVER () AS rowid in your SELECT clause.
Mar
6
answered Free website host for embedding tilemill/mapbox web map
Feb
19
comment Loading Shapefiles into PostGIS using shapefile import/export manager
In OpenGeo suite install, it is here: C:\Program Files (x86)\Boundless\OpenGeo\pgsql\bin
Feb
19
comment Loading Shapefiles into PostGIS using shapefile import/export manager
@Catlover While the version of pgAdmin that you have is strange (my fresh install has 1.18), I don't have the plugin in pgAdmin nor is it enabled from the opengeo dashboard. Just confirming that it is not enabled as part of the default Windows install.
Feb
18
reviewed No Action Needed Eastings/Northings OSGB36 Grid origin
Feb
17
comment Homogeneous vs Heterogeneous schema in Postgis
That is what I was trying to impart... Have an "id" field that you do not populate manually. Thanks.
Feb
17
revised Get geometry column back when counting points in polygon using PostGIS
Punctuation
Feb
17
comment Get geometry column back when counting points in polygon using PostGIS
@robintw Don't forget to add "geom" to your SELECT clause . If you try both solutions, I'd be interested to know the query times.
Feb
17
answered Get geometry column back when counting points in polygon using PostGIS
Feb
13
awarded  Yearling
Feb
13
answered Homogeneous vs Heterogeneous schema in Postgis
Feb
12
comment Homogeneous vs Heterogeneous schema in Postgis
What version of Postgres/PostGIS? Table inheritance might be a good solution.
Feb
12
awarded  Custodian
Feb
12
reviewed No Action Needed Checking if an attribute matches a lookup table
Feb
7
comment What do these curly graphics represent on this map?
Another term for them is "land hooks".
Jan
28
comment How to export QGIS contour attributes in a DXF file?
Note that my answer was revised to address missing attributes. If that (or any other) answer solves your problem, please mark it as the correct answer.
Jan
25
revised How to export QGIS contour attributes in a DXF file?
Added comment as noted
Jan
24
comment How to export QGIS contour attributes in a DXF file?
Well, that would be another question. It's well documented. You're looking for the GDAL command line utilities.
Jan
24
answered How to export QGIS contour attributes in a DXF file?
Jan
15
comment How can I add an index to a CartoDB table?
According to docs at developers.cartodb.com/documentation/using-cartodb.html indices are automatically created on "cartodb_id" and "the_geom" columns.