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] 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] 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,

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

/7/2009 5:55 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] The Old Who is using PostGIS survey again? > 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

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

> 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, that's something FME can cure. Paul's on the money. I

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

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, that's something FME can cure. P. On Wed, Jan 7, 2009 at 12:

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

We're not there yet but one of the developers and I just started a project to migrate our Flood zone data from Oracle spacial to postGIS. I am a systems engineer; the other guy is a C and Java developer and neither of us has a deep knowledge of GIS and database management. Right now I'd snap

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

1) I am an independant student who in trying to prepare for sociological changes due to globalization is becoming proficient in mapping. I have read manuals for Postgis, PROJ4, Mapserver, and the associated softwares and languages, and so I subscribe to the associated mail lists. 2) Because I am i

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

03 AM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] The Old Who is using PostGIS > survey again? > > > > --- Paragon Corporation escribió: > > > Leo and I have a good portion of a PostGIS book > > written. Ideally we would > > like to get

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

--- Paragon Corporation escribió: > Leo and I have a good portion of a PostGIS book > written. Ideally we would > like to get a publisher to publish it, but seem to > be running into the same > obstacles. No publisher seems to think people use > PostGIS to warrant enough > demand for a book de

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

Hi list, Hi Regina, find answers inline. Bye, Marc Paragon Corporation schrieb: > Leo and I have a good portion of a PostGIS book written. Ideally we would > like to get a publisher to publish it, but seem to be running into the same > obstacles. No publisher seems to think people use PostGIS

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

On Tue, Dec 30, 2008 at 1:21 PM, Paragon Corporation wrote: > Leo and I have a good portion of a PostGIS book written. Ideally we would > like to get a publisher to publish it, but seem to be running into the same > obstacles. No publisher seems to think people use PostGIS to warrant > enough >

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

My 2 cents... It's very exciting to hear that you are working on a book. If you get stuck with publishers, have you considered publishing on lulu.com? No idea how good it is, but it is mentioned at the end of http://www.macresearch.org/realities-writing-technical-books Without a solid book

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

1) How you use PostGIS? I use PostGIS to store time series land use data captured with remote sensing for the whole watershed in the country and relate them to hydrologic characteristics of the watersheds such as water quality, flooding and base flow. We have around 400 watersheds to moni

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

> 1) How you use PostGIS? We (at Camptocamp) extensively use PostGIS in almost all our GIS-related projects. It is the core component of the Spatial Data Infrastructures we set up, providing a central, easy to manage spatial repository. It is coupled with MapServer to deliver on-demand maps and wi

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

> 1) How you use PostGIS? Mainly to gain valuable experience in developing solutions that cross multiple spatial SQL databases so that I am ready to provide services of value to customers. > 2) What you find useful about it over anything else? PostGIS's range of additional functions is the de

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

1) How you use PostGIS? We use it to: a) get a list of the Ham Radio operators and trained spotters within a 20 mile buffer of a Tornado Watch polygon, b) to determine the Voronoi polygons surrounding each weather surveillence radar so as to find which radar is closest to a given rain gauge.

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

Paragon Corporation wrote: Leo and I have a good portion of a PostGIS book written. Ideally we would like to get a publisher to publish it, but seem to be running into the same obstacles. No publisher seems to think people use PostGIS to warrant enough demand for a book dedicated to it. So to

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

Regina, 1) How you use PostGIS? Storage and analysis of fisheries and endangered species data. 2) What you find useful about it over anything else? Fast, Standards Compliant, straightforward 3) Why you think there should be any book written focused on its use and of course if such a thing were t

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

1) How you use PostGIS? We use it in our university courses (bachelor degree) about databases and we are giving courses about it (next one in January, see http://gis.hsr.ch/wiki/Agenda). 2) What you find useful about it over anything else? * It's more compatible to SQL than others in the same le

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

Jay Cummins wrote: <...> > > 2) What you find useful about it over anything else? > It's cheaper than therapy and it doesn't impair my ability to drive > afterwards. SBOBNL* ! This ought to be an (un)official slogan, or perhaps a pull quote ... made this person's day. I want to send an answer

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

1) How you use PostGIS? I use it at home for self-teaching of spatial databases and for trying GIS software such as uDIG and QGIS. Using PostGIS relaxes me. If I have a bad day at work on the ESRI stack, I'll either have a beer or play with PostGIS (sometimes both). 2) What you find useful about

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

On Dec 30, 2008, at 4:21 AM, Paragon Corporation wrote: 1) How you use PostGIS? As a platform for terrain and hydrological modeling, a database backend for web sites developed using GeoDjango, and as a datasource for rendering with Mapnik. 2) What you find useful about it over anything

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

> 1) How you use PostGIS? Primarily as a backend for MapServer. My applications serve public, county government data for several Northern Rockies counties. > 2) What you find useful about it over anything else? Obviously a spatially enabled database is handy in that spatial and attribute data ar

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

We use PostGIS to store, manipulate and display soil moisture & salinity data plus associated weather etc data for irrigators across southern Australia. Mapserver is used to display maps and metrics (and Grace for associated plots). The database currently contains several million readings. As a

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

for potential users to search the list archives to locate others who have successfully used POstGIS in their own areas of interest. Thanks, Brent Wood --- On Wed, 12/31/08, Obe, Regina wrote: > From: Obe, Regina > Subject: RE: [postgis-users] The Old Who is using PostGIS survey a

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

1) I use PostGIS to create topographic maps for http://www.gpsfiledepot.com. I also suggest other people use it by writing about it extensively in my tutorial on how to create Garmin compatible topo maps. In addition; I've started using it for a program I'm writing to help make topo maps. 2)

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

...@postgis.refractions.net] On Behalf Of Chetan Tiwari Sent: Tuesday, December 30, 2008 3:06 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] The Old Who is using PostGIS survey again? It would be nice to have an introductory book - it can be something I could use in some of the classes I

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

1) In the City of Uster (Kanton Zurich, Switzerland) we use PostgreSQL/Postgis as a central (geo)-data-warehouse. We import survey data, data on energy supply (electricity, water, gaz) and waste-water management and all additional geodata the city manages (urban planning, nature, agriculture, t

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

It would be nice to have an introductory book - it can be something I could use in some of the classes I teach. Are you planning to have a section on 'Applications'? Looking at some of the diverse examples of how people use PostGIS, maybe people on this list (and others) can contribute towards a ch

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

> > So to make a decent case for a book, can each of you in > your own words > describe > > 1) How you use PostGIS? Several ways/reasons/purposes in a research organisation (NIWA New Zealand) We use PostGIS for: managing a national topo vector database as a back end for a Mapserver site usi

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

1) How you use PostGIS? a.) Monthly transfer of County ESRI SDE/MSSQL Geodatabase to County PostGIS Database b.) from which many manipulations, extractions, calculations, and updates are performed with greater ease and automation than from the ArcGIS tools. Some of our uses include: c.) PA Ac

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

1) Use for: shared data storage, adding basic spatial functionality to websites, automating some spatial processes with scripting, and as a mapserver back-end. 2) Find useful over others: well-established, great documentation & active support community, easy entry 3) Why a book: there is good docum

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

Paragon Corporation wrote: Leo and I have a good portion of a PostGIS book written. Ideally we would like to get a publisher to publish it, but seem to be running into the same obstacles. No publisher seems to think people use PostGIS to warrant enough demand for a book dedicated to it. So to

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

To answer the question some of you have asked. Our planned break down was as follows (though given input we may change our concentration of effort in certain areas) 1) Basic Beginner stuff -- A) a lot of time spent on how to load and dump data from-to various data sources using shp2pgsql, pgsql2

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

tgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Stephen Woodbridge Sent: Tuesday, December 30, 2008 12:04 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] The Old Who is using PostGIS survey again? Regina, Are you aware of the that has

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

Regina, Are you aware of the that has been done with SpatiaLite? It is a postGIS like extension to SQLite database. It is almost equivalent functionality to PostGIS and my guess is that mush or all of what you have written probably also pertains to SpatiaLite which might widen the value of you

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

Paragon Corporation wrote: Leo and I have a good portion of a PostGIS book written. Ideally we would like to get a publisher to publish it, but seem to be running into the same obstacles. No publisher seems to think people use PostGIS to warrant enough demand for a book dedicated to it. So to

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

> 1) How you use PostGIS? We use it to store and query data about routes that the users of our ridesharing system make. In the beginning of the project, matching similar routes was the part we were most clueless about, and we were surprised to see how easy it was to accomplish with PostGIS. Also,

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

...@postgis.refractions.net] On Behalf Of Andreas Neumann Sent: Tuesday, December 30, 2008 10:02 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] The Old Who is using PostGIS survey again? Regina - do you want respondents to your survey send the information directly to you or to the Postgis list (potentially

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

On Tue, Dec 30, 2008 at 4:21 AM, Paragon Corporation wrote: > Leo and I have a good portion of a PostGIS book written. Ideally we would > like to get a publisher to publish it, but seem to be running into the same > obstacles. No publisher seems to think people use PostGIS to warrant enough > de

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

Regina - do you want respondents to your survey send the information directly to you or to the Postgis list (potentially creating a lot of traffic on the list) - or would it be better to have a online poll/form, which would allow you better evaluate and process the results of your survey. I would

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

Paragon Corporation wrote: 1) How you use PostGIS? I'm using it as a backend database for our GPS track sharing site http://timatio.com/ All the GPS data that users upload is stored in PostGIS - very useful for finding relations between different tracks, calculating length, intersection