[postgis-users] GIN index?

Wasn't PostGIS 2.0 supposed to support GIN indexes? Seems like there was talk of that many moons ago, but I don't see anything about GIN in the 2.0 documentation. Aren ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.r

Re: [postgis-users] Upgrading to postgres/postgis 64 bit Windows 7.

I think you will have to do a complete backup and restore, just as if you're upgrading from anything but a minor Postgis release. Aren On Mon, Apr 23, 2012 at 1:59 AM, george wash wrote: > I am currently running Postgresql 9.1 and postgis 2.0 beta3 both 32-bit > under windows 7 64-bit. I would

[postgis-users] OK to have polygon and multipolygon in same geometry field?

I have a PostGIS dataset imported from a TIGER places SHP for Texas (gz_2010_48_160_00_500k). I imported using QGIS's supposedly-soon-to-be-deprecated SPIT tool. The import causes the the_geom field to have both polygon and multipolygon types. Any harm with this? I ultimately want to use this tab

Re: [postgis-users] Bogus unknown geometry error from ST_Transform

uld expect. You have > outlined what might be considered a legitimate enhancement, but it's on the > edge, because do-what-I-mean-not-what-I-say behavior can cause other people > problems from time to time. > > P. > > > On Sun, Feb 19, 2012 at 12:29 PM, Aren Cambre wrote:

Re: [postgis-users] Bogus unknown geometry error from ST_Transform

ST_Transform should use whatever's specified in *public.geometry_columns*. I should not be getting errors about SRID of -1 if something is specified in *public.geometry_columns*. Aren On Sun, Feb 19, 2012 at 9:13 AM, Aren Cambre wrote: > Nope. BTW, there is an extraneous parenthesis in your

Re: [postgis-users] Bogus unknown geometry error from ST_Transform

ven the srid? > > Even if there is a bug, this may work for you until fixed? > > Brent Wood > > --- On *Sun, 2/19/12, René Romero Benavides * wrote: > > > From: René Romero Benavides > Subject: Re: [postgis-users] Bogus unknown geometry error from ST_Tran

Re: [postgis-users] Bogus unknown geometry error from ST_Transform

his may work for you until fixed? >> >> Brent Wood >> >> --- On *Sun, 2/19/12, René Romero Benavides //* >> wrote: >> >> >> From: René Romero Benavides >>Subject: Re: [postgis-users] Bogus unknown geometry error from >>ST_Transform

[postgis-users] Bogus unknown geometry error from ST_Transform

ST_Transform is returning a bogus error of* Input geometry has unknown (-1) SRID*. Here's the query: *UPDATE gis."gz_2010_48_160_00_500k"* *SET "the_geom_3081" = ST_Transform(the_geom, 3081);* I said "bogus" because the database's *public.geometry_columns* table has valid values for these two col

Re: [postgis-users] postgis removed from latest postgres' stack builder?

technical reasons for this limitation, just a packaging issue. > I think Postgis 2.0x will also ship in 64bit versions on Windows. > > So if you are on 64bit Windows, you should install 32bit PostgreSQL with > the spatial extensions. > > Andreas > > > > > On Wed, 28

Re: [postgis-users] postgis removed from latest postgres' stack builder?

Did you install the 64 bit version? PostGIS is 32 bit only. Aren On Wed, Dec 28, 2011 at 9:37 PM, Daniel Montenegro wrote: > Why there isn't anymore the field SPATIAL EXTENSIONS (wich have postgis) > in the latest version of Postgres' STACK BUILDER? This is weird... I mean, > I had to download a

Re: [postgis-users] How to look up state highways with geocoder?

logic to fix. > > Thanks, > Leo and Regina > http://www.postgis.us > > > -- > *From:* postgis-users-boun...@postgis.refractions.net [mailto: > postgis-users-boun...@postgis.refractions.net] *On Behalf Of *Aren Cambre > *Sent:* Monday, De

Re: [postgis-users] How to look up state highways with geocoder?

nton Tap', 'TX');* Argh. Aren On Mon, Dec 19, 2011 at 8:54 PM, Aren Cambre wrote: > Here's the query I'm using: > *SELECT * FROM geocode_intersection('SH 121', 'Denton Tap', 'TX', > 'Coppell');* > > Aren > > > On

Re: [postgis-users] How to look up state highways with geocoder?

Here's the query I'm using: *SELECT * FROM geocode_intersection('SH 121', 'Denton Tap', 'TX', 'Coppell');* Aren On Mon, Dec 19, 2011 at 7:56 PM, Aren Cambre wrote: > I am trying to find an intersection that includes a state highway.

[postgis-users] How to look up state highways with geocoder?

I am trying to find an intersection that includes a state highway. It's TX 121 and Denton Tap Rd. in Coppell, TX. This corresponds to here

Re: [postgis-users] tiger data pain

Or how about a wiki page somewhere that we can all contribute to? I had to consult a lot of references to get this installed. On Tue, Dec 13, 2011 at 9:16 PM, Andy Colson wrote: > I downloaded PostGis 2 to play around with, and tried out the tiger stuff. > I have to say, that's kinda painful. >

Re: [postgis-users] How to update your SVN copy of PostGIS

proc.prolang = lang.oid* *WHERE proname LIKE '%geocode%'* *ORDER BY proname;* Definitely no *geocode.** functions there. Aren On Sat, Dec 10, 2011 at 5:18 PM, Stephen Woodbridge wrote: > Try right click on database and/or function list and refresh it. > > > On 12/10/201

Re: [postgis-users] How to update your SVN copy of PostGIS

created many versions ago and upgraded > to this point. > > -Steve W > > > On 12/10/2011 5:46 PM, Aren Cambre wrote: > >> Thanks. Yup, I see it now. My mind was stuck in 3rd generation languages >> where things stop when you get an exception. >> >> The scr

Re: [postgis-users] How to update your SVN copy of PostGIS

the raster world, so I just ran with the > raster upgrade. Sorry about that. > > If you're getting an error, you'll want to scroll up past the > transaction error message as the very first error message should be > related to the actual statement that is failing. > &g

Re: [postgis-users] How to update your SVN copy of PostGIS

in your checkout's > directory at: > > raster/rt_pg > > -bborie > > On Fri, Dec 9, 2011 at 7:53 PM, Aren Cambre wrote: > > Thanks. I got the latest SVN snapshot. I was able to configure, make, and > > make install. The problem is there seems to be missing steps betwee

Re: [postgis-users] How to update your SVN copy of PostGIS

: > If you used something like... > > svn check out https://svn.osgeo.org/postgis/trunk > > You can safely run... > > svn update > > If that works, I'd recommend doing... > > svn cleanup > > -bborie > > On Fri, Dec 9, 2011 at 7:19 PM, Aren Cambre wr

[postgis-users] How to update your SVN copy of PostGIS

I admit this is a dumb question, but here it is. I installed PostGIS on my Ubuntu 11.10 environment a few weeks ago using the excellent instructions at http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data. Since then, the *geocode_intersection* function was added, and I need it. I'm n

Re: [postgis-users] Geocoding cross streets?

My question is already answered: someone committed changes at http://trac.osgeo.org/postgis/ticket/1333#comment:3. Are these already in the SVN trunk? Aren On Wed, Nov 30, 2011 at 6:29 PM, Aren Cambre wrote: > Based on the conversation below, it appears there is already a solution, &g

Re: [postgis-users] Geocoding cross streets?

Based on the conversation below, it appears there is already a solution, and people well-versed with PostGIS may be helping with this already. Given that, are my n00b skillz of much use? Second question--when might this cross street feature be available? I am asking for selfish reasons--I am worki

Re: [postgis-users] Geocoding cross streets?

>>> postgis-users-bounces@postgis.**refractions.net >>> [mailto:postgis-users-bounces@**postgis.refractions.net] >>> On >>> Behalf Of Stephen Woodbridge >>> Sent: Monday, November 28, 2011 5:39 PM >>> To: >>> postgis-users@po

Re: [postgis-users] Geocoding cross streets?

'm not sure how much unnecessary > processing that would add if people know they aren't dealing with cross > street addresses. > > Thanks, > Leo and Regina > http://www.postgis.us > > > ------ > *From:* postgis-users-boun...@postgis.r

Re: [postgis-users] Geocoding cross streets?

GIS and geocoder you are using? > > Johnathan > > On Mon, Nov 28, 2011 at 9:26 AM, Aren Cambre wrote: > >> I have the TIGER geocoder running with PostGIS 2.0 as per >> http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data. >> >> It seems to do well find

[postgis-users] Geocoding cross streets?

I have the TIGER geocoder running with PostGIS 2.0 as per http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data. It seems to do well finding street addresses, but it can't seem to find cross streets. For example, if I geocode *sagecanyon and sagegreen, houston, tx*, I get a location on

Re: [postgis-users] Building GEOS 3.3.1 on Ubuntu

SVN (that's > what the instructions say). Here are your steps for Ubuntu from the > geos-3.3.1 directory: > > ./configure > make > make check > sudo make install > sudo ldconfig > > > -Mike > > On 27 November 2011 18:47, Aren Cambre wrote: > > I realize thi

[postgis-users] Building GEOS 3.3.1 on Ubuntu

I realize this is not the GEOS email group, but 3.3.1 appears to be a prereq for running PostGIS 2.0? Ubuntu's most recent GEOS package is 3.2.2. I can't get the builds to work. Below is a copy of the documentation bug report I filed with the GEOS developers. What can be suggested to them to get t

Re: [postgis-users] When will the PostGIS 2.0 be released?

Isn't the opposite being said here by Paragon staff? http://old.nabble.com/forum/ViewPost.jtp?post=32553824&framed=y Aren On Tue, Oct 25, 2011 at 9:45 AM, Sandro Santilli wrote: > On Tue, Oct 25, 2011 at 09:11:03AM -0500, Aren Cambre wrote: > > On Tue, Oct 25, 2011 at 1:09 A

Re: [postgis-users] When will the PostGIS 2.0 be released?

Is this where support for Postgres 9.1 will be introduced? Aren On Tue, Oct 25, 2011 at 1:09 AM, Sandro Santilli wrote: > On Tue, Oct 25, 2011 at 05:58:31AM +, Bart Chen wrote: > > > > When will the PostGIS 2.0 be released? > > http://trac.osgeo.org/postgis/milestone/PostGIS%202.0.0 > > Rel

Re: [postgis-users] OT Understanding slow queries

32 bit Windows is actually limited to 2 GB processes, or 3 GB if you start Windows with a special */3GB* option. Aren On Thu, Sep 1, 2011 at 6:45 PM, Paragon Corporation wrote: > ** > Charles, > > Honestly I have little idea. In theory you should fair better with Linux, > but I think it depend

Re: [postgis-users] Reducing geometry type's dimensions

Thank you! Aren On Mon, Aug 29, 2011 at 2:14 PM, Fred Lehodey wrote: > http://postgis.refractions.net/docs/ST_Force_2D.html > > Fred > > > On Mon, Aug 29, 2011 at 7:51 PM, Aren Cambre wrote: > >> Did I stump everybody? :-) >> >> Aren >> >&

Re: [postgis-users] Reducing geometry type's dimensions

Did I stump everybody? :-) Aren On Sun, Aug 28, 2011 at 3:05 PM, Aren Cambre wrote: > I was trying to copy a geometry data type from one table to another, but I > got a *enforce_dims_the_geom* error. > > I looked at the *geometry_columns* table, and turns out the source tab

[postgis-users] Reducing geometry type's dimensions

I was trying to copy a geometry data type from one table to another, but I got a *enforce_dims_the_geom* error. I looked at the *geometry_columns* table, and turns out the source table has a 4-dimensional field and the destination table has a 2-dimensional field. Both fields have srid 3081, and th

Re: [postgis-users] Calculate variance of a multipoint

named "str1" (what a descriptive name!!) that provided the highway designation more clearly. After getting that fixed, the upper end of the variance on my geocoding dropped sharply. Aren On Sat, May 28, 2011 at 8:09 AM, Aren Cambre wrote: > Thank you! > > > On Fri, May 2

Re: [postgis-users] Where does Postgres end and PostGIS begin?

itional support from PostGIS to handle GIST indexes on geometry objects? Aren On Mon, Jul 25, 2011 at 2:39 PM, Aren Cambre wrote: > Will PostGIS have a release that supports Postgres 9.1 and the new GIST > index when 9.1 comes out? > > Aren > > > On Mon, Jul 25, 2011 at 2:34 PM,

Re: [postgis-users] Where does Postgres end and PostGIS begin?

Will PostGIS have a release that supports Postgres 9.1 and the new GIST index when 9.1 comes out? Aren On Mon, Jul 25, 2011 at 2:34 PM, forkandwait wrote: > Ragi Burhum gmail.com> writes: > > > Brent and Sean are correct. Nevertheless, it is worth noting that if you > are > trying to do k near

Re: [postgis-users] Calculate variance of a multipoint

select 88 as gid, 'MULTIPOINT(1 2,2 3,3 4,4 5,3 5,9 > 9)'::geometry as the_geom >) as a >) as b >) as c > group by gid order by variance desc; > > You should be able to replace the select...union all select ... with your > table of m

Re: [postgis-users] Calculate variance of a multipoint

ints... relative to their total size (area / > number?), or relative to some defined area? > > cheers > > Ben > > > On 28/05/2011, at 6:19 AM, Aren Cambre wrote: > > Did anyone have thoughts on this? :-) > > Aren > > On Wed, May 4, 2011 at 2:12 PM, Aren Ca

Re: [postgis-users] Calculate variance of a multipoint

Did anyone have thoughts on this? :-) Aren On Wed, May 4, 2011 at 2:12 PM, Aren Cambre wrote: > The more I think about it, is this a job for R? I know I need to start > using R at some point, just haven't begun yet. > > Aren > > > On Wed, May 4, 2011 at 1

Re: [postgis-users] Calculate variance of a multipoint

The more I think about it, is this a job for R? I know I need to start using R at some point, just haven't begun yet. Aren On Wed, May 4, 2011 at 1:42 PM, Aren Cambre wrote: > Suppose you have a geometry type with a multipoint. How would you calculate > the variance of the poi

[postgis-users] Calculate variance of a multipoint

Suppose you have a geometry type with a multipoint. How would you calculate the variance of the points in that multipoint? I looked through the PostGIS 1.5 function reference and am not coming up with any easy way. A hard way seems to be using st_centroid(multipoint) to find the multipoint's cen

Re: [postgis-users] Calculating variance of a set of points

t ref_mark_id, >setsrid(makepoint(avg(x(location)), > avg(y(location))),4326) as avg_location > group by ref_mark_id as foo) a > where l.ref_mark_id - a.ref_mark_id > group by ref_mark_id; > > Should work. ie: generate a virtual table as a que

[postgis-users] Calculating variance of a set of points

I have a table with events. Each event happened at a listed reference marker on a highway, and it also has latitude and longitude as recorded by an observer of the event. There are many events at each reference marker. I want to check the precision of the latitude and longitude for events recorde

Re: [postgis-users] Unprojected lat/long to 3081?

gt; Cheers, > > Francis > > On 4 February 2011 09:33, Aren Cambre wrote: > >> I have a database containing a Postgres native point data type *event*that >> has the latitude and longitude for certain events. An example value of >> *event* is *(32.7748777996749,-96.

[postgis-users] Unprojected lat/long to 3081?

I have a database containing a Postgres native point data type *event* that has the latitude and longitude for certain events. An example value of * event* is *(32.7748777996749,-96.7680574022233)*. Note: this is *not* a PostGIS data type. It's a native Postgres type. I tried to convert this into

Re: [postgis-users] Inefficient query with QGIS?

Thanks. Would you recommend QGIS do that instead of the expensive query on the view? BTW, turns out there was a QGIS option to limit the expensive query to 100 rows, but it was kind of buried. On Sun, Jan 30, 2011 at 11:40 PM, Bruno Friedmann wrote: > On 01/30/2011 09:43 PM, Aren Cambre wr

Re: [postgis-users] Inefficient query with QGIS?

it appears there's no way to know what a kind of geometry is in a view's geometry column without inspecting it. Aren On Sun, Jan 30, 2011 at 2:03 PM, Ivan Mincik wrote: > On Sun, Jan 30, 2011 at 4:59 PM, Aren Cambre wrote: > > I noticed this really inefficient query when

Re: [postgis-users] Inefficient query with QGIS?

Thanks. Further investigation suggests a QGIS bug. It's trying to determine geometry type on views. This is a problem for me since one of my views has almost 12,000,000 rows. Bug report filed with QGIS: http://trac.osgeo.org/qgis/ticket/3453 It seems there is no way to find a geometry type of a v

[postgis-users] Inefficient query with QGIS?

I noticed this really inefficient query when QGIS was importing a Postgis layer: *select distinct case when geometrytype("the_geom") IN ('POINT','MULTIPOINT') THEN 'POINT' when geometrytype("the_geom") IN ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when geometrytype("the_geom") IN ('POLYGON'

Re: [postgis-users] Creating density map

to > get the data into R - but it could either be as a data frame using spatial > SQL to return attributes, or using readOGR if you need spatial objects in R > > cheers > > Ben > > > > > On 10/01/2011, at 2:50 PM, Aren Cambre wrote: > > I have three dataset

[postgis-users] Creating density map

I have three datasets: 1. Routes 2. Event type A that occurs along the routes (points) 3. Event type B that occurs along the routes (points) Both event types have several attributes, including a date/timestamp, sub-classes of each event type, and other meaningful attributes. I'm trying

Re: [postgis-users] How to reproject data with custom projection?

Just want to confirm that it was 3082. Reprojecting from 3082 to 3081 makes it mes well with within my existing data. Thank you so much! Aren On Sun, Jan 9, 2011 at 9:10 PM, Aren Cambre wrote: > Ben and Paul, > > Thank you! > > I didn't know about http://prj2epsg.org.

Re: [postgis-users] How to reproject data with custom projection?

psg/3082/gml/> >- ESRI WKT <http://spatialreference.org/ref/epsg/3082/esriwkt/> >- .PRJ File <http://spatialreference.org/ref/epsg/3082/prj/> > > options will help. > > Good luck (from the antipodes, so take your chances) > > cheers > > B

[postgis-users] How to reproject data with custom projection?

I have a SHP with this in its PRJ file: * PROJCS["Custom",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",150.

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

Does it cause a regression for 32-bit users? Aren On Sat, Jan 1, 2011 at 11:16 AM, Paul Ramsey wrote: > On 64bit machines it works. > > P. > > On 2011-01-01, at 5:33 AM, Aren Cambre wrote: > > It was raised there 4.5 years ago: > <http://bugzilla.maptools.org/s

Re: [postgis-users] shp2pgsql with DBF >= 2 GB?

It was raised there 4.5 years ago: http://bugzilla.maptools.org/show_bug.cgi?id=1463. Might be nice if PostGIS maintainers could "bug" that developer about resolution? The proposed local patch is changing int to long on three variables. While that may not be graceful, could it work as a temporary

[postgis-users] shp2pgsql with DBF >= 2 GB?

I have a DBF that's almost exactly 2 GB. I get the fseek errors as per http://trac.osgeo.org/postgis/ticket/393 when I run *shp2pgsql* on the SHP that includes this DBF. Are there any workarounds? This 2 GB DBF is the result of opening *StratMap Trans FGDB* from http://www.tnris.org/datadownload/

Re: [postgis-users] Traverse set distance along a multiline?

s border). Aren On Sun, Dec 26, 2010 at 6:35 PM, Aren Cambre wrote: > I am trying to determine mile markers along Texas highways. My starting > point is the ShapeFile TxDOT Roadways 2010 at > http://www.tnris.state.tx.us/datadownload/download.jsp. I've used > shp2pgsql to get

Re: [postgis-users] Traverse set distance along a multiline?

just another column in spatially > enabled database. If you really don't need to keep the original column, you > can always drop it from the table after creating the 3081 version. > > Having a second table also works, but I figured I'd mention this > alternative. > > C

Re: [postgis-users] Traverse set distance along a multiline?

rred to me how easy it can be to reproject GIS data. Aren On Mon, Dec 27, 2010 at 6:15 PM, Paul Ramsey wrote: > Right, use 4269, that's a good NAD83-geographic-coordinates number. > Import with shp2pgsql -s 4269 and go from there. > > P > > On Mon, Dec 27, 2010 at 3:54 PM,

Re: [postgis-users] Traverse set distance along a multiline?

t the units are meters, so perform the appropriate linear > transformations when looking for mile markers. > > Paul > > On Sun, Dec 26, 2010 at 4:35 PM, Aren Cambre wrote: > > I am trying to determine mile markers along Texas highways. My starting > > point is the ShapeFi

[postgis-users] Traverse set distance along a multiline?

rd the points at the end of each mile? I reviewed the functions available at http://postgis.refractions.net/documentation/manual-1.5/reference.html and am not seeing anything clear. In case it matters, the SHP's PRJ file says NAD83. Aren Cambre