Re: [postgis-users] area and distance

Chandler, 1) As Muhammad mentioned, you want to check to make sure your geometries are in the same planar projection. First verify you brought them in with a specific projection By doing a SELECT ST_SRID(geom), ST_AsText(geom) As wkt FROM factory limit 1; SELECT ST_SRID(geom) FROM inner_a

Re: [postgis-users] JDBC SNAPSHOT postgis-2.1.0SVN.jar Not found

It's not just you. I'll see what I can do about this next week. I think it happened when we switched our jdbc build to use Maven instead of Ant and our buildbots have not been updaed yet to use the new Maven bindings. http://trac.osgeo.org/postgis/ticket/1835 Sorry about that, Regina http://

Re: [postgis-users] TIGER geocoder, Ticket #1838 (new defect)

Correct. It's just with loading tabblock data which isn't used in Geocoder. I don't have it used in any function at the moment actually though its a table a couple of people asked for for stats which is why we included it. anyrate just fixed the issue for tiger_2011 (distributed with PostGIS 2.

Re: [postgis-users] Could not add all rasters to a table

Olivier, You can use FWTools or Tamas nightly builds. http://www.postgis.org/documentation/manual-2.0/RT_FAQ.html#id2979398 Both have gdalinfo.exe. Tamas always has the latest and greatest. Hope that helps, Regina h ttp://www.postgis.us _ From: postgis

Re: [postgis-users] Merge rectangles

You don't need to do array unless you have a reason for that LIMIT. ST_Union is an overloaded function: One version is an aggregate and one takes an array of geometries. So below is a bit shorter to write: SELECT ST_Union(poly) FROM portal.catalog WHERE cat.type = 'CADRG'; -Original Me

Re: [postgis-users] Merge rectangles

Correct it will dissolve overlapping regions, though you still may end up with multipolygons if you have islands of polygons. -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of DrYSG Sent: Thursday,

Re: [postgis-users] created linear referencing system

Muni, Not sure what you are asking and maybe others have a similar problem understanding. That might be why you haven't received an answer. What do you mean by linear reference capable? All spatial data that is of linestrings can be linearly referenced. Are you talking about a specific tool

[postgis-users] Package Maintainers Please Update List

I've put together a preliminary listings of PostGIS distributions I know about. I would appreciate it if package maintainers can update it and provide links to any helpful instructions relevant to your distribution. http://trac.osgeo.org/postgis/wiki/UsersWikiPackages Thanks, Regina http://www.

Re: [postgis-users] Postgis 2.0 TopoGeo_AddPolygon

Check to make sure that topology schema is in your database search path. CREATE EXTENSION postgis_topology; adds it automatically, but if you built from a template database it won't be there. I forget if the regular topology install script automatically adds it. So something like ALTER DATAB

Re: [postgis-users] Concave hull problem & delaunay triangulation -help needed please

Brent, Is your data 2D or 3D? You might want to try out the new ST_DelaunayTriangles in 2.1 http://www.postgis.org/documentation/manual-svn/ST_DelaunayTriangles.html Right now I beleive it's just 2D, but work is going on in GEOS land to make it 3D.: http://trac.osgeo.org/geos/ticket/570 I

Re: [postgis-users] Geocode function fails when callingnormalize_address

Rob, Regarding your normalize issue, it's probably one record causing it. I thought we fixed some of these issues in 2.0.1 and 2.1.0SVN so you might want to upgrade your script to the 2.0.1 -- there is an upgrade script you can use packaged in the tar ball. If that still doesn't fix your issue,

Re: [postgis-users] Postgres 9.2

You can't use PostGIS compiled for one version of PostgreSQL on a different version of PostgreSQL. They are not compatible binaries across versions. We'll have 2.0.1 for PostgreSQL 9.2 available for Windows probably sometime next week. However -- we do have PostGIS 2.1.0SVN available for 9.2 al

Re: [postgis-users] Odd question

Eric, Did y ou want to change the default or set it to 0 or something? We were meaning to expose that but wasn't sure if anyone would be interested in changing it. The setting is on the function: interpolate_from_address Just change the hardcoded default of 10 to what you want. CREATE OR RE

[postgis-users] Automated Builds New Virtual Team Members

As some people may have noticed we've been beefing up our build and regress infrastructure currently with the creation of 2 build bots Debbie: a Debian jenkins bot that builds the PostGIS 2.0 (I just put in a job to do that so 2.0.2 branch tar balls are now being built again, PostGIS 2.0/2.1 docs

Re: [postgis-users] Odd question

Chris _ Date: Sat, 15 Sep 2012 18:46:06 -0500 From: ericas...@gmail.com To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] Odd question That's fantastic! Exactly what I was looking for. Thank you very much. On Sat, Sep 15, 2012 at 6:44 PM, Paragon Corporation wrote: Er

Re: [postgis-users] Newbie Duplicates Question

If you are looking for disk space, just delete the addrfeat tables. They are a denormalized join of addr / edges and feat and we aren't using them. I had planned to use that instead of edges but after much thinking, decided it really didn't provide any benefit and just took up a lot of disk spac

Re: [postgis-users] Tiger geocoder, Spanish street types are pushed to the end

James, Sadly this is a known issue and one we haven't settled on the best way to fix without resorting to major surgery. Here is the ticket for it: http://trac.osgeo.org/postgis/ticket/1118 If you can add your examples to the ticket and add yourself to cc for the ticket that would be great. We

Re: [postgis-users] Tiger geocoder, Spanish street types are pushed to the end

.@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of James Marca Sent: Thursday, September 27, 2012 4:06 PM To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] Tiger geocoder,Spanish street types are pushed to the end On Thu, Sep 27

Re: [postgis-users] Geocode function failswhencallingnormalize_address

ell me which are tripping me up and why? Thanks, Rob _____ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Paragon Corporation Sent: Thursday, September 06, 2012 8:14 PM To: 'PostGIS Users Discussion' Subject: Re: [postgis-u

Re: [postgis-users] Tiger geocoder, Spanish street types are pushed to the end

abbreviations in the regex compare. Regards, James On Thu, Sep 27, 2012 at 04:20:41PM -0400, Paragon Corporation wrote: > > James, > Which version are you using? I assume the 2.1.0SVN one? > > That we can probably change the structure of a bit since it hasn't > been release

[postgis-users] pgRouting Windows campaign

We've started a new campaign and hoping it will be as successful as our last windows 64-bit campaign. This campaign is to package pgRouting as part of the Windows PostGIS stackbuilder package. First we have to work out some kinks with compiling which will take some time to work out. If you want

Re: [postgis-users] finding whether an object lies in vicinity of another object

Read first chapter of our book (which is a free download). The examples at the end covers exactly what you are asking. http://www.manning.com/obe/ Also if you don't know much about SQL, the free Appendix C covers the fundamentals of SQL. Leo http://www.postgis.us _ From: postg

Re: [postgis-users] Installing 64-bit PostGIS 2.0.1 with WindowsInstaller

Could be a password issue, though that usually gets written to the log files. Does your password have any ' or " in it. I think we might still have issue with that. It sounds like it might have got passed copying over the files, so you can probably just enable PostGIS anyway in the database of

RE: [postgis-users] TIGER/Line Shapefiles released

some of these might be helpful. Best regards, -Stephen Woodbridge http://imaptools.com/ Paragon Corporation wrote: > As a side note to what you were saying in the .sh file it would be > really nice if the shp2pgsql dealt with standalone dbf files too. I > mean the logic is all

RE: [postgis-users] Cannot display postGIS layers on ms4w 4.6.1

Just a guess I think bata-admin as a schema is a bad choice of schema names. I think you have to quote it if you are going to use that. I would change it to rename your schema if I were you. To something like bata_admin If you go with what you have, I think you may need to quote it and I'm not e

RE: [postgis-users] 1.3.3 Pre-Release Notice

By the way I have been looking at that file and wrote up some code to deal with DBF only situations which I am still testing thru. For your info - all those lines contain sr_id && sr_id != "-1" And sr_id is initialized as char *sr_id =NULL I forgot all my C, but am I mistaken in saying that

RE: [postgis-users] 1.3.3 Pre-Release Notice

Notice Correct, I changed them all to strcmp(sr_id,"-1"), which should do the trick. On Tue, Apr 8, 2008 at 5:51 PM, Paragon Corporation <[EMAIL PROTECTED]> wrote: > By the way I have been looking at that file and wrote up some code to > deal with DBF only situations whic

RE: [postgis-users] 1.3.3 Pre-Release Notice

I thought about that too. If I were making minor changes (which I had hoped this would be), I wouldn't have bothered. I only reindented the sections I was working on because it was getting in my way of understanding what was going on. Most of it was indented fine but just some critical long ca

RE: [postgis-users] Does anyone have multipolygons withlarge numbersof polygons

It could be the reentry and prepare of the geom that is the culprit. I haven't looked at the code, but from thinking about it, would think there would be some repetitive setup involved in each case (even if passing were efficient) and then pulling out a single point from a reprepared array of poin

RE: [postgis-users] 2 Questions

Dylan, For question 1) Sorry not quite sure what you are asking here. Below is a guess SELECT ST_Difference(A.the_geom, B.the_geom) FROM A INNER JOIN B ON ST_Overlaps(A.the_geom,B.the_geom) UNION ALL SELECT A.the_geom FROM A LEFT JOIN B ON ST_Intersections(A.the_geom,B.the_geom) WHERE B.gid I

RE: [postgis-users] ERROR: type "postgis.geometry" is only a shell

Stefan, Did you dump and restore on the same server. From this error it looks almost as if your Geometry datatype was put in schema called postgis rather than public. I've never seen anyone install PostGIS functions and types in anything but the Public schema, although I suppose it is not a bad

RE: [postgis-users] Absolute Beginner

Bob, David is right. You are probably running an early 1.2 or 1.1 install. SELECT postgis_full_version() Is slightly better to run - it will give you details of Geos too. ST is the new naming convention. For things that use spatial indexes, it automagically includes the spatial index operat

[postgis-users] PostgreSQL Linked Server on SQL Server 2005 64-bit

Sorry for the cross-post here. I think the issue of being able to connect to PostgreSQL from a 64-bit Windows system and in particular 64-bit SQL Server 2005 has come up a couple of times on both PostGIS and PostgreSQL ODBC groups. Jeff Crumbley kindly notified us that Microsoft released this mo

RE: [postgis-users] PostgreSQL Linked Server on SQL Server 2005 64-bit

fficiently (see http://www.postgresql.org/about/news.895 - version 1.2.8 supports Linked Servers). On Fri, Apr 25, 2008 at 6:02 PM, Paragon Corporation <[EMAIL PROTECTED]> wrote: Sorry for the cross-post here. I think the issue of being able to connect to PostgreSQL from a 64-bit Windows syste

RE: [postgis-users] PostgreSQL Linked Server on SQL Server 2005 64-bit

performance and scalability of this approach. Correct me if I'm wrong but native PostgreSQL OLE DB Provider would have done work more efficiently (see http://www.postgresql.org/about/news.895 - version 1.2.8 supports Linked Servers). On Fri, Apr 25, 2008 at 6:02 PM, Paragon Corporation <[

RE: [postgis-users] ST_Contains() performance problem

I personally think we should raise the costs for all postgis functions since all postgis functions are definitely more costly than standard other functions. Actually I haven’t looked to see if there is a way to turn that off, but I think it would be preferable not to since there are so many pla

RE: [postgis-users] Line To Path

Bob, If I understand you correctly, I think you want to use one of the following SELECT somefield, ST_Union(the_geom) FROM sometable GROUP BY somefield So lets say you want to collapse 3 rows into 1 then you just need to group by some common field. E.g. if somefield = 1 for your 3 records, then

RE: [postgis-users] one to many join

If I understand you correctly, then I think the best way is to collapse the list of family members into one field using an aggregate glue function that will glue all the names together in a single field. Below is a SUM aggregate function we commonly use. You may want to change the name sum to so

RE: [postgis-users] Unique Coverage

If two geometries overlap, which one would you take? I assume you would leave all out of an overlapping set except for one or would you be taking the non-overlapping sections? Thanks, Regina _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dylan Lorimer Sent: Friday,

RE: [postgis-users] ST_Difference Perplexes Me!

Dylan, I hope you don't think that LEFT JOIN is the only trick I have in my bag of tricks although I have to admit it is my favorite. For the below I would think this query wouldn't work at all SELECT ST_Difference(A.the_geom, B.the_geom), A.country_name FROM A, B WHERE A.country_name='China'

RE: [postgis-users] ST_Difference Perplexes Me!

, A.the_geom) WHERE A.country_name = 'China' GROUP BY A.country_name ) As C ON A.country_name = C.country_name Hope that helps, Regina _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paragon Corporation Sent: Monday, May 05,

RE: [postgis-users] Points with in multiple Polygons

Chris, Just simply take out the the_geom from your SELECT part of the statement and it will still output fine. Its not terribly useful to output geometry fields with psql unless you are doing a db dump. If you wanted to output geometry fields, you may want to consider using pgsql2shp which com

RE: [postgis-users] Importing shapefiles with srid != -1

Actually the shp2pgsql loader completely ignores the prj file and the pgsql2shp doesn't create a prj file. That's one of those nice to have features that should be on the to do list if it isn't. Its of very minor importance compared to other stuff though. Regina -Original Message- From

RE: [postgis-users] Understanding speed issues

John, Might be worthwhile to post to pg-general. Regarding below - for updating about 2 million or so records - it normally takes about 10 minutes on my box running Linux dual quad Xeon 2.2 GZ or something like that. Not sure what your specs are like and also depends on type of disks you have.

[postgis-users] Does ST_AsText truncate or round

Hopefully this is a simple question. I know that ST_AsText returns a geometry that is not necessarily as prescise as what is actually stored in the geometry field. I have an editor that relies on WKT representation. Anyrate just wanted to know if the ST_AsText does a rounding of the points or it

RE: [postgis-users] couldn't get the correct projected values

You are confusing setsrid with transform. Remember setsrid - doesn't change the geometry it simple certifies that a geometry is of a particular projection - basically I am because I say I am Transform - moves a geometry from one projection to another I am not , but please make me so. Of cour

RE: [postgis-users] Does ST_AsText truncate or round

under intersecting than over intersecting. Although I probably haven't thought this out enough so maybe it's a non-issue. Thanks, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paragon Corporation Sent: Friday, May 16, 2008 12:01 AM To:

RE: [postgis-users] Does ST_AsText truncate or round

)'::geometry ~= geomfromtext(astext(snaptogrid('POINT(0.956079571507871 0.659502930939198)'::geometry, 0.001)), -1); ?column? -- t (1 row) Cheers, Kevin Paragon Corporation wrote: > Slight clarification about what I am trying to solve. > > After edits I a

RE: [postgis-users] Does ST_AsText truncate or round

It would be interesting to know what various vendors do when they get the data in WKT and when they send it back in WKT. What assumptions do they make about precision if there is no universally defined guideline for that. For example if I'm sending the data in 15 decimal precision and the other s

RE: [postgis-users] Finding/Categorizing Paths from A to B

On Sun, May 18, 2008 at 12:10 PM, Webb Sprague <[EMAIL PROTECTED]> wrote: >> That is exactly what I want to do... but first I want to find a way >> to boil down all trips to 12 or so distinct paths; without having to >> overlay every trip. But since I only have points, not streets; i >> hav

RE: [postgis-users] couldn't get the correct projected values

I think UTMs are offset to be postive, but transforming is not going to verify that it will stay positive. The transform simply does some math and if you start out with an incorrect SRID and try to transform to another you get in return something equally bogus. It doesn't validate to make sure th

RE: [postgis-users] Does ST_AsText truncate or round

all editing is performed using WKT (including updating a geometry using transform() ), then triggers should probably be constructed enforcing the model on your spatial tables. Cheers, Kevin Paragon Corporation wrote: > Kevin, > > Actually this would help me with the second phase,

RE: [postgis-users] SRID and EPSG

Antonio, I think all the spatial references used are EPSG in the spatial_ref_sys table. There used to be a time when ESRI codes were used, but I don't see those in the newer spatial_ref_sys tables. Anyrate the standard query to pull up all EPSG codes supported would be the below (it applies fo

RE: [postgis-users] How to tell if 2 geometries are spatially equal

Martin, Yes that should do it. I don't know how I missed that function. Thanks, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Davis Sent: Friday, May 30, 2008 7:54 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] How to tell

RE: [postgis-users] Attributes update

I think you are right. That's what I get for copying other peoples code assuming it was doing the right thing and reformatting it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Anderson Sent: Friday, May 30, 2008 9:50 PM To: PostGIS Users Discussi

RE: [postgis-users] Spatial Operators

Marcus, It would help if you provided the sql statement you were trying to run that gave you a problem. Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marcus C. England Sent: Friday, May 30, 2008 7:45 PM To: PostGIS Users Disc

RE: [postgis-users] Can't Call shp2pgsql.exe From "Run" or VB Program, only works with DOS prompt opened first

Dan, Could also be the VB code or run statement is being truncated. How are you escaping out your double quotes in VB. E.g. if you copy the files to root of C and then try it does it work? Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

RE: [postgis-users] Creating a Flow Diagram with PostGIS

I'm also confused how does your below query update anything - how can id be both 178 and 181? Below were some other thoughts I had about what Robert was saying. Hopefully this helps more than confuses you. 1) I would first like to say that st_x, st_y, st_z only works with points. So if you have

RE: [postgis-users] Creating a Flow Diagram with PostGIS

Bob, ST_X, ST_Y,ST_Z only work with points.You need ST_Centroid to get the centroid point of the object. Try using ST_X(ST_Centroid(the_geom)) etc. Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Pawley Sent: Sunday, Jun

[postgis-users] X3D Export

We have a client who is interested in using PostGIS for storing Engineering Lab Design models and maintaining the change of the Lab layout and equipment over time. I guess along the lines of what Bob Pawley is working on. Basically non-GIS models with a relational and spatial flavor to them. They

RE: [postgis-users] Buffer

Should be able to. I usually just do the ST_Buffer(geometry, double) Where double is the expanse in units of your spatial ref. So If I understand you correctly, you would put your buf-width in that slot. The last argument I think defaults to 8 and it basically the approximation you want to

RE: [postgis-users] Updated shapefile to update postgres database

Here is a thought, but not sure how slow this will be DELETE FROM mystreets_table WHERE street = 'N/A' AND EXISTS (SELECT n.street FROM mystreets_table n WHERE (n.street <> 'N/A' AND n.street > '') AND ST_Equals(n.the_geom, mystreets_table.the_geom)) The st_equals might be better to replace wi

RE: [postgis-users] Updated shapefile to update postgres database

explicit type casts. :confused: Thanks! Paragon Corporation-2 wrote: > > Here is a thought, but not sure how slow this will be > > DELETE FROM mystreets_table > WHERE street = 'N/A' AND > EXISTS (SELECT n.street FROM mystreets_table n WHERE

RE: [postgis-users] X3D Export

the works. It will be interesting to see the 3D aspect. My project won't need the third demension until well after I have the 2D in shape. Bob - Original Message - From: "Paragon Corporation" <[EMAIL PROTECTED]> To: "'PostGIS Users Discussion'"

RE: [postgis-users] X3d export

Thanks Milo and Randy, This is all along the line of what we are trying to do and I'm learning a lot from this thread. I checked out vterrain a couple of years ago and it was still in its infancy then. I'll have to take another look at that. Coincidentally I noticed James Fee had a blog entry

RE: [postgis-users] X3d export

Olivier, I second David's comment. I would be interested at anyrate. Not sure how many people David and I speak for but garnering from this thread there seems to be a fair amount of interest. I guess the only concern with that which Paul Ramsey or Mark Cave-Ayland can clarify on is that since

RE: [postgis-users] question about memory leak when deserialize

Chenzhen, I think most people that read the postgis dev users group probably read this one (users group) as well. Your question is more suitable to the dev group though. http://postgis.refractions.net/mailman/listinfo/postgis-devel Hope that helps, Regina -Original Message- From: [EMA

RE: [postgis-users] Getting dimensions of polygon sides

Bruce, Unfortunately I don't think I can move that into the CROSS JOIN because the generate_series would then be dependent on the other table. If PostgreSQL had a CROSS APPLY similar to SQL Server 2005, then I could implement what you are saying and it probably would be faster. Anyrate I think m

RE: [postgis-users] Circle

I usually just buffer a point So ST_Buffer(somepoint, radiusyouwant) That gives you a solid circular polygon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Pawley Sent: Friday, June 13, 2008 6:36 PM To: PostGIS Users Discussion Subject: [postgi

RE: [postgis-users] Updated shapefile to update postgres database

it should take that long then you have any other suggestion? Thanks again! Paragon Corporation-2 wrote: > > I wonder if its just called Equals in the old version. > > Try doing just ~=. If your geometries are exactly the same that will > probably be better anyway > >

RE: [postgis-users] Updated shapefile to update postgres database

you don't think it should take that long then you have any other suggestion? Thanks again! Paragon Corporation-2 wrote: > > I wonder if its just called Equals in the old version. > > Try doing just ~=. If your geometries are exactly the same that will > probably be b

RE: [postgis-users] Updated shapefile to update postgres database

tell me means! :confused: Im trying to become familiar with this but don't know much... Totally ignore btree, gist index, but I'll google it to see what I can find. As far as the configuration it is the installation's default, suggestions are welcome! =^D ... again... Thanks! P

RE: [postgis-users] export table from postgis to arcsde

I use a PostgreSQL pgagent job to do nightly dumps of a PostgreSQL view put as an ESRI shape file. I have people on the other end that have some automated routine for importing this shape file into a SQL Server ArcSDE. I'm not sure how they do that, but I assume there most be some automated tool t

RE: [postgis-users] export table from postgis to arcsde

table from postgis to arcsde If you have control of both the pgsql and the sde, you could use ogr2ogr and a windows scheduler or cron job to fire it off and directly translate from pgsql to sde. P On Wed, Jun 18, 2008 at 8:07 AM, Paragon Corporation <[EMAIL PROTECTED]> wrote: > I us

RE: [postgis-users] Problems Compiling GEOS 3.0

Yes there is a geos list its http://lists.osgeo.org/mailman/listinfo/geos-devel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Thoen Sent: Wednesday, June 18, 2008 3:40 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Problems

RE: [postgis-users] Collecting Polygons

Lee, This is a bug in 1.3.2 that was fixed in 1.3.3. I highly suggested upgrading to 1.3.3 The alternative is to work around the bug by using ST_MemCollect instead of ST_Collect. Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf O

RE: [postgis-users] Postigis self documenting code?

Dane, This sounds like a great idea. I had originally planned putting the comments in the lwpostgis.sql file, but I kind of like the idea of separating it out into a separate .sql file. The only thing I'm concerned about (which maybe you have already considered in your python script). Normally

RE: [postgis-users] Postigis self documenting code?

Dane, In response to your comments > Well, maybe this is the best place to start > And another benefit is that auxiliary meta could be added at the same time in a separate table (see below). I think its more maintainable as a separate file as the way you suggested and a separate more infor

RE: [postgis-users] Normalizing nationalatlas.gov data

Have you tried something like INSERT INTO newtable(stusps, the_geom) SELECT stusps, ST_Multi(ST_Collect(the_geom)) as singlegeom FROM somestatefield GROUP BY stusps Or INSERT INTO newtable(stusps, the_geom) SELECT stusps, ST_Multi(ST_Collect(the_geom)) as singlegeom FROM somestatefield GROUP

RE: [postgis-users] Normalizing nationalatlas.gov data

Yes. Sorry I meant use ST_Union. INSERT INTO newtable(stusps, the_geom) SELECT stusps, ST_Multi(ST_Union(the_geom)) as singlegeom FROM somestatefield GROUP BY stusps -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jantzen Sent: Sunday, June 2

RE: [postgis-users] Newbie - get total distance travelled from query ofpoints

Joe, You need to convert to some sort of foot or meter projection that is suitable for your area of interest. your measures are in degrees. Then once you've figured out the SRID of that - then transform SELECT ST_Length(St_MakeLine(ST_Transform(point,rightsridgoeshere/1000 as distance FRO

RE: [postgis-users] ShapeFile

Which version of PgAdmin are you running? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Pawley Sent: Tuesday, June 24, 2008 1:11 PM To: PostGIS Users Discussion Subject: [postgis-users] ShapeFile Hi I just downloaded and installed a shapefile into

RE: [postgis-users] Selecting an SRID

Ed, Depends of your region of interest and which analysis (mostly database or just user drawing on a map) and how much of it you will be doing. Also what kind of tool you will be using to render your maps. If you are covering the whole globe - you might be best to leave your data in long lat an

RE: [postgis-users] Selecting an SRID

ore coordinates in different regions of the world using different SRS's? Or, would simply using the Goole Projection (i.e. http://spatialreference.org/ref/user/6/) for any point/polygon on the globe be sufficient? Also, how much of these issues are non-issues given that the display in in gmap

RE: [postgis-users] makepolygon with geom info

Sorry I had a typo - try the below instead: SELECT Max(f.gid) as newgid, f.name, ST_MakePolygon(ST_MakeLine(f.the_geom)) As newgeom FROM (SELECT name, 0 as psort, gid, the_geom FROM foll UNION ALL SELECT fs.* FROM (SELECT D

RE: [postgis-users] ST_Translate

Bob, Doesn't quite make sense to me why translating before ST_Union would cause distortion if you are translating all the same amount. What is the SRID of the data you are translating and what does your translate query and union query look like? Thanks, Regina -Original Message- From: [

RE: [postgis-users] Splitting/merging linework into equal intervallinestrings

Dane, I recall doing something along 2 and 3 before and I did it in python (although I was interested in getting each measure at x distance along the line so I was collecting Points every x distance meters along the way rather than breaking up the lines. So my translation of what I did to what y

RE: [postgis-users] Splitting/merging linework into equalintervallinestrings

Duh - just realized I had one additional unnecessary sub select - I think the below is crisper SELECT gid, ST_Line_Substring(the_geom, 500*n/length , CASE WHEN 500*(n+1) < length THEN 500*(n+1)/length ELSE 1 END) As the_geom FROM(SELECT ts.gid, ST_LineMerge(ts.the_geom) As the_geom, ST_Lengt

RE: [postgis-users] Transform overlapping polygons to non-overlapping?

Brent, INSERT INTO temp3_lines (the_geom) SELECT ST_ExteriorRing( ST_GeometryN(the_geom, generate_series(1, ST_NumGeometries(the_geom AS the_geom FROM temp2_polys; Can be done more efficiently using ST_Dump INSERT INTO temp3_lines (the_geom) SELECT ST_ExteriorRing((ST_Dum

RE: [postgis-users] Transform overlapping polygons to non-overlapping?

One more question - you sure you want ST_Overlaps and not ST_Intersects. If one geometry sits completely inside another, it is not considered to overlap, but they do intersect. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paragon Corporation Sent

RE: [postgis-users] Need help with a query - resending

Pedro, It got thru the first time, I just don't think people have too many thoughts on it since it is a litte out of the ordinary. So you always want the closest upper tunnel. One thought that comes to mind is to use the overlap/above bounding box operator (but that would only work if your li

RE: [postgis-users] match line with road segment

You may be better off snapping the points to the line first before you do a make line. Take a look at Paul's blog entry. http://blog.cleverelephant.ca/2008/04/snapping-points-in-postgis.html Sounds similar to what you are trying to do. Hope that helps, Regina -Original Message- F

RE: [postgis-users] match line with road segment

Are you just looking to get back the portions of the line segments with the line segment id of the line segments that intersect your road. If so, then now that you have your single line, you can splice it with the road segments by doing SELECT r.gid As road_gid, t.tripid, ST_Intersection(r.the_ge

RE: [postgis-users] Problem sorting polygons with generate_series

Hi Birgit, This is a tricky thing to do in SQL. The easiest way I can think of of doing this (may not be the most efficient) is to use a correlated subquery. For this you don't really need the temp count table you set up. Although you do need some field that can order the records in some arbitra

RE: [postgis-users] Need Help with Postgis

Jorge, If you don't have the table registered in the geometry_columns table then that would be the problem like the error says. Alternatively you don't need to have it in geometry_columns if you use this syntax DATA "the_geom FROM pai_vec_250 USING UNIQUE gid USING SRID=4326" Where gid

RE: [postgis-users] ESRI Geodatabases, relationship classes and PostGIS

Juan, Can't say I'm even a mildly competent user of ArcGIS products, but hopefully the little I know about the topic will be of help to you. For GeoDatabase -> PostGIS - OGR2OGR has worked well for me, its free, and also can deal with other formats as well. We have some of the more common

RE: [postgis-users] makepolygon with geom info

Reena, Not quite sure what could be the problem. Hmm sorry about my comment off-list - I hadn't read this e-mail. Can you post a little bit of you Mapserver map. Could be the extent of your map is wrong, the projection doesn't match among a number of other problems. All ahrd to tell without se

RE: [postgis-users] insert .sql using script

Where are you inserting from? If from some user input might be faster to insert from your app e.g. php, .NET etc. Is your update.sql file being autogenerated every one minute? If so - I suppose you can use psql command line something like psql -h someserver -p 5432 -U someuser -d somedb -f "\so

RE: [postgis-users] encoding and german umlaute

You could also set the client encoding at the database level if setting it in Manifold is not an option and all you clients expect latin1. Although that is slightly more invasive. To set at the database level - do one of the following 1) In PgAdmin right click the database - go to variables tab

RE: [postgis-users] error in sentence sql

Strange. I never knew that X and Y ever too anything but a point. Try ST_X(ST_Centroid(the_geom)) Hope that helps, Regina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of fsalas Sent: Monday, July 28, 2008 3:17 PM To: PostGIS Users Discussion Subject:

  1   2   3   4   5   6   7   8   9   10   >