1,325 reputation
1617
bio website walkercivil.com
location Tuscaloosa, AL
age 43
visits member for 2 years, 8 months
seen 1 hour 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.


Oct
16
comment Postgis database query optimisation
Using ST_SetSRID(ST_MakePoint($1, $2),4326) in lieu of string concats might save you some time if there are enough iterations.
Oct
12
comment How to migrate Postgres table having Lat Lon columns to an existing PostGIS database?
Creation of geometry tables from coordinates is well documented. If you have had trouble finding information or have been unsuccessful in applying what you have found, please include that in your question.
Oct
12
comment Spatialite WITH clause issue
The same general info that you posted for DM Manager regarding the SQLite version, etc. Wait, are you referring to the SQLite Manager plugin for Firefox? If so, it likely is compiled with a recent version of SQLite. To clarify, whether or not you can use a Common Table Expression depends on the client that you are using, not the version of the database file.
Oct
12
comment Spatialite WITH clause issue
@SS_Rebelious I am unable to check the bindings at the moment. Can you append that to your answer?
Oct
12
revised Spatialite WITH clause issue
added 115 characters in body
Oct
12
answered Spatialite WITH clause issue
Oct
7
comment Why does the postGIS file lose geometry?
@kernow88 As far as I know, each row in your attribute table should represent a geometry object. A common problem is incorrect CRS. If you right-click the layer and select zoom to layer, do you see your points then?
Oct
3
comment Why does the postGIS file lose geometry?
The attribute table in QGIS does not display the geometry column.
Sep
19
comment Why does the postGIS file lose geometry?
Does the table have a primary key?
Aug
20
awarded  Constituent
Aug
12
awarded  Caucus
Jul
17
awarded  Enlightened
Jul
17
awarded  Nice Answer
May
6
awarded  Citizen Patrol
May
5
comment geoserver and its layer is pointing(base url) to other server(hosting server) not my domain url
Looks like your DNS authority is sedoparking.com. If you do not already have a handle on the DNS, then that complicates things quite a bit. Proxy is something you will have to install and configure on your server. See if you can obtain your DNS configuration.
May
5
comment geoserver and its layer is pointing(base url) to other server(hosting server) not my domain url
This looks like a DNS or proxy issue, not a GeoServer issue. How are you routing your site name to the host?
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.