373 reputation
16
bio website
location Florida
age 39
visits member for 3 years, 10 months
seen Sep 4 '12 at 18:26

Jul
23
awarded  Yearling
Jul
23
answered To get attribute data of polygon layer by giving Lat/Lon
Jul
11
comment postgis st_linemerge based on attribute
rtfm to me. didn't see the link. asked in hopes there might be a way to avoid writing a function to loop through the name values when there are 4,000 instead of four. Perhaps a WITH RECURSIVE... preceding the UPDATE would do the trick? thanks for the feedback.
Jul
11
awarded  Commentator
Jul
11
comment postgis st_linemerge based on attribute
would something like "update line_table set the_geom = ST_LineMerge(the_geom) GROUP BY name;" accomplish the task? guess i've never considered whether or not GROUP BY works in an UPDATE, but it feels too good to be true...
Jul
11
comment How to change the geometry type from Point to Multipoint within an existing table in PostGIS?
Hi @Mike Toews (and Ulrik). I don't think your second step for PostGIS 1.x is necessary in this case, Mike. Ulrik said the table will be empty at the time of the type conversion, so there won't be any non-multi values to cause an error with something like: 1) ALTER TABLE my_table DROP CONSTRAINT enforce_geotype_the_geom; 2) ALTER TABLE my_table ADD CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'MULTIPOINT'::text OR the_geom IS NULL); then 3) UPDATE geometry_columns SET type = 'MULTIPOINT' WHERE f_table_name = 'my_table'; (perhaps the sloppiest comment ever - my bad)
Jun
22
answered Removing “the_geom” field in the .csv output of Geoserver
May
31
comment How to fix “spatial_ref_sys relation does not exist”
if it helps at all, geometry_columns is a view in 2.0, not a table
Jan
20
comment Put the author's name on maps?
I'm part of a small GIS shop in a large state agency. We agreed on a standard, fine-print note for all of our maps: "Spatial analysis and cartography by the office of..." Since there are four people in our office which belongs to a bureau which belongs to a division, we agreed it's all the credit we need AND it allows our audience to direct questions about our maps straight to the source without getting bounced around in the all-to-common game of bureaucratic apathy pinball.
Nov
28
comment Recommend topics to be included in a Computer Science for Geospatial Technologies course
introducing KML seems like a great way to draw some students in.
Nov
28
answered Recommend topics to be included in a Computer Science for Geospatial Technologies course
Nov
9
answered Join intersecting lines with PostGIS
Oct
21
revised Where can I find a shapefile of zoning for the city of Phoenix and other municipalities?
clarified initial assertion
Oct
21
answered Where can I find a shapefile of zoning for the city of Phoenix and other municipalities?
Oct
13
comment Rename postGIS table and updating the GeoServer?
The simplest way to make the change in geometry_columns is to open pgAdmin, right click the table, select view data, select view all rows, click in the cell containing the old table name and type the new table name. or, UPDATE geometry_columns SET f_table_name = 'new_table_name' WHERE f_schema_name = 'schema_name' AND f_table_name = 'old_table_name'
Oct
11
answered Rename postGIS table and updating the GeoServer?
Oct
9
answered How to emulate this grayscale basemap look+feel in Google Maps
Sep
20
answered When should I use ST_Buffer?
Aug
26
answered File paths in a PostGIS Table in QGIS
Aug
9
answered PostGIS Error: type “geography” does not exist