[postgis-users] FOSS4G NA

2013-02-05 Thread David Fawcett
I just saw Regina's great post on new PostGIS raster features. It would be great to see some presentations at FOSS4G NA on PostGIS raster and other PostGIS goodness. Hopefully you are all just waiting to submit at the last moment to keep us in suspense... If not, please consider submitting an ab

[postgis-users] FOSS4G NA 2013 Presentation Abstract Deadline Extended

2013-02-18 Thread David Fawcett
The deadline for submitting presentation abstracts for FOSS4G North America 2013 presentations has been extended to Friday, February 22nd. We have received many great abstracts, but we could use some more to put together the best program for all of you. We are looking for all kinds of presentation

[postgis-users] FOSS4G NA 2013 Community Review Now Open!

2013-02-25 Thread David Fawcett
The FOSS4G North America Conference is a community event. That doesn’t just mean that we all get together in May, it means that you get a voice in shaping the conference program. We have received a lot of great abstracts, please help us now pull them together to create the conference that you wan

Re: [postgis-users] Applying symbology to a raster

2013-04-05 Thread David Fawcett
I have found the dialogs in QGIS to not be so intuitive for symbolizing rasters. To get it to work in the past, I have had to use the options to classify the data first and the I have been able to apply a color ramp. Definitely worth following up on the QGIS list if you can't figure it out. Davi

Re: [postgis-users] Cut lat/lon to six decimal digits

2013-04-16 Thread David Fawcett
Take a look at the postgres round() function: http://www.postgresql.org/docs/8.1/static/functions-math.html round(ST_Y(geom),6) David. On Tue, Apr 16, 2013 at 8:50 AM, Carsten Hogertz wrote: > Hi everyone, > I've got the following SQL to extract the lat/lon of a polygone: > > SELECT > ROW_NUM

Re: [postgis-users] Old question resurfacing

2013-12-11 Thread David Fawcett
For the PostGIS, processing, and visualization parts, you may want to look at the presentations that Howard Butler and Paul Ramsey have done in the last year at FOSS4G NA and FOSS4G. David. On Wed, Dec 11, 2013 at 11:33 AM, Gerry Creager - NOAA Affiliate < gerry.crea...@noaa.gov> wrote: > I'll

Re: [postgis-users] PostGIS on a Raspberry Pi

2014-02-24 Thread David Fawcett
Richard, Did you use the DebianGIS repo or compile everything yourself? I have been thinking of using GEOS via Shapely in combination with a GPS chip on my Pi in a geo-fence type application. David. On Mon, Feb 24, 2014 at 7:16 PM, MICHAEL FENE wrote: > Greg...This is a great post and an exce

Re: [postgis-users] PostGIS supported by which ArcGIS

2014-10-08 Thread David Fawcett
I assume that on the server side, your dba has 'Esrified' the database by using a one of the ArcGIS desktop tools to convert your existing Postgres database into an 'ESRI Enterprise Geodatabase", which creates the sde schema and all of the sde functions, etc. This costs an ArcGIS Server license.

Re: [postgis-users] PostGIS supported by which ArcGIS

2015-01-15 Thread David Fawcett
Adrian, I think that Regina is correct and that the layer that you loaded is using the ESRI st_geometry. I am using PostGIS with ESRI products (10.2) and I am able to create a feature class in the 'esrified' postgres table with ESRI tools and then manipulate it using PostGIS and QGIS (2.4, I don'

Re: [postgis-users] Need help on basic concepts, I just need really simple calculations

2015-03-23 Thread David Fawcett
Brent Great, informative answer. On Sun, Mar 22, 2015 at 3:14 PM, Brent Wood wrote: > Hi Aaron, > > Hopefully this (simplistic) description helps. > > Setting a SRID value for a feature tells Postgis what coordinate reference > system (CRS) the coordinates are in. This includes the unit, which

[postgis-users] Different results in datum transform pg v2 vs pg v1

2015-06-05 Thread David Fawcett
We are finally able to retire one of our older servers running an old version of PostGIS and we are migrating everything over to a new install. One thing that I am noticing is that I am getting different behavior between the two versions when transforming some values from 4267 to 4326. The Old Se

Re: [postgis-users] Different results in datum transform pg v2 vs pg v1

2015-06-05 Thread David Fawcett
.8.2 r3921" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.2, released 2012/10/08" LIBXML="2.7.6" LIBJSON="UNKNOWN" RASTER" On Fri, Jun 5, 2015 at 10:55 AM, David Fawcett wrote: > We are finally able to retire one of our older servers running an ol

Re: [postgis-users] error adding data into ArcGIS

2015-06-08 Thread David Fawcett
Mark, I ran into this recently, but can't remember what caused it. I will look back and see if I can remember. Maybe wrong SRS, null geometries? David > On Jun 8, 2015, at 4:29 PM, Mark Volz wrote: > > Hello, > > All the sudden I am getting an error loading data into ArcGIS: “One or mor

Re: [postgis-users] Using string variables with PGScript

2015-09-23 Thread David Fawcett
Bob, I haven't ever used PGScript, but I wonder one of the postgres quote functions found on this page might work: http://www.postgresql.org/docs/9.1/static/functions-string.html I would try quote_literal() David. On Wed, Sep 23, 2015 at 4:26 PM, Bistrais, Bob wrote: > I am having trouble usi