meta user
network profile
| bio | website | |
|---|---|---|
| location | Florida | |
| age | 38 | |
| visits | member for | 2 years, 4 months |
| seen | Sep 4 '12 at 18:26 | |
| stats | profile views | 15 |
|
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 |
