212 reputation
212
bio website
location
age
visits member for 2 years, 4 months
seen yesterday

I'm a blockhead.

"Don't get tricked into believing that what's complicated is clever. In fact, endeavor to keep things simple, which, as we all know, is the principle of good design." -gar1t


Oct
14
answered Delete all data from a PostGIS topology
Oct
14
comment Delete all data from a PostGIS topology
@Mapperz I'm looking into fiddling with the underlying topology tables manually, but I've noticed that at least the face table has a row in it when you create a new topology. Since the topology tables are something PostGIS is supposed to manage for me, I'm a bit cautious about just truncating them.
Oct
14
revised Delete all data from a PostGIS topology
added 97 characters in body
Oct
14
asked Delete all data from a PostGIS topology
Sep
24
awarded  Autobiographer
Aug
28
awarded  Curious
Aug
27
revised How can I associate a consistent polygon area with a set of attributes using a topology?
deleted 28 characters in body
Aug
27
comment Moving existing hard drive with PostGIS data directory to a new computer
Are you sure this still fails if you use the 32 bit PostgreSQL/PostGIS on the 64 bit machine? The mailing list suggests otherwise, although it does seem to suggest that dump/restore is just a better idea, anyway.
Aug
27
comment Is there any random data generator supporting geometry in PostGIS?
Have you considered generating random line boundaries and feeding them through MakeValid? I bet that would give some pretty complicated shapes. You could probably do something in the vein of a random walk to keep it in the same general area, maybe even a random walk plus some kind of sort if you want something a bit more regular.
Aug
27
revised How can I associate a consistent polygon area with a set of attributes using a topology?
Completely revised the question and made it narrower
Aug
27
asked How can I associate a consistent polygon area with a set of attributes using a topology?
Aug
27
comment Joining layers with respective elements with PostGIS Topology
I'm a bit lost on how you're supposed to leverage topologies, too, but this might help. You can cast a TopoGeometry directly to a geometry: SELECT whatever, ST_AsText(topogeom::geometry) FROM layer_tb. The thing is that if the edges get split later on, it seems that the geometry might change as a result.
Aug
18
awarded  Caucus
Aug
18
awarded  Constituent
Aug
18
comment Importing .shp to postgreSQL
@user30184 Absolutely correct, but do note that this assumes PostgreSQL 9.1 or higher. (There is very little reason to use anything older, in my opinion.)
Aug
18
comment Importing .shp to postgreSQL
-p for psql tells it the server's port, not the projection. The projection becomes embedded in the SQL script. See the fine manual for psql's behavior. In this case, the port the OP specifies is not the default port, so it is required. I would also generally advise against storing a shape without a projection. This limits your ability to change projections, which can be helpful for getting more accurate calculations.
Jul
16
awarded  Yearling
Jun
18
awarded  Citizen Patrol
Jun
18
comment Specify geoprocessing service connection at publish
I'm unclear on what exactly has to match. When I specify a connection file locally, it's essential a path, e.g. Database Connections\local.sde. What will ArcGIS look for to replace? The file path in my code? A parameter value (perhaps a workspace parameter)? What will it match on the server side? Additionally, are you saying that I need the data store to have different Publisher and Server database connections? My understanding is that this will trigger a data upload, which is not what I need. Sorry. I'm very lost on how to accomplish this, to the point that it's difficult to ask questions.
Jun
18
revised Specify geoprocessing service connection at publish
deleted 4 characters in body