Re: [postgis-users] electronic GIS data scale

Kristian, I also disagree with your comments on the issue of scale with respect to vector data. Data (vector or otherwise) that is captured with the intent to be useful at a given scale can become less so when used at a different scale. Polygons digitized from a 1:250.000 map and polygons dig

Re: [postgis-users] The Old Who is using PostGIS survey again?

One of the things I would hope for - maybe THE thing I would hope for - is along the lines of a cookbook. As in, a sample problem is stated, and a solution in PostGIS is developed. By way of an example: you have a continuous land cover theme (polygons with no spaces between them). You have s

Re: [postgis-users] Help with Bad Query Plan

Oliver Snowden wrote: Dear all, I am having some problems with a bad query plan. Essentially, I have two tables. A table of many different types of geography and another table (reports) linking to those geographies. We want to select a small subset of reports (e.g. 30 reports) based on date a

Re: [postgis-users] The Old Who is using PostGIS survey again?

Another option is ogr2ogr which should allow you to do flat table transfers. P. On Jan 8, 2009, at 10:30 AM, Stephen Carville wrote: On Wednesday 07 January 2009 15:34, Paul Ramsey wrote: Fastest way to migrate: drop a couple thousand bucks on an FME license and

Re: [postgis-users] The Old Who is using PostGIS survey again?

On Thu, Jan 08, Stephen Carville wrote: > If the GIS migration works out I might get the go ahead to test the > transactional DB on Postgresql next year. That will be a bigger "challenge" > because of the number of stored procedures involved. If there is a tool that > will make migrating thos

Re: [postgis-users] Help with Bad Query Plan

Is there a Step 6, where your run your final query, but you haven't created an index yet? Because step 5 is functionally the same as Step 8, which you note doesn't return. On Jan 8, 2009, at 11:30 AM, Oliver Snowden wrote: Dear all, I am having some problems with a bad query plan. Essenti

[postgis-users] Help with Bad Query Plan

Dear all, I am having some problems with a bad query plan. Essentially, I have two tables. A table of many different types of geography and another table (reports) linking to those geographies. We want to select a small subset of reports (e.g. 30 reports) based on date and intersect those report

Re: [postgis-users] The Old Who is using PostGIS survey again?

They do (or did) offer evaluation versions of the FME. For your Oracle stored proc problem all I can offer is yet more costly software. :) The EnterpriseDB "PostgresPlus" includes a complete Oracle compatibility layer, which allows you to run PL/SQL in the database and even connect using o

Re: [postgis-users] The Old Who is using PostGIS survey again?

On Wednesday 07 January 2009 15:34, Paul Ramsey wrote: > Fastest way to migrate: drop a couple thousand bucks on an FME license > and run it once. :) If you understand Oracle Spatial, you understand > PostGIS, conceptually. Just a few function names different. The > drudgery of a migration though,

[postgis-users] Reminder: Call for Papers FOSSGIS 2009 - the largest german-language conference for free open source software and free geodata

sorry for crossposting: The following is the official reminder of "Call for Paper" announcement for the german speaking FOSSGIS conference (NOT FOSS4G !!!), which will take place in Hannover, 17.-19. of March 2009. Sorry for german language only but everybody is invited to join the conference.