http://blog.gmane.org/gmane.comp.gis.postgis hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.gis.postgis/18824 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Victor Sterpu 2008-09-06T18:21:32 http://comments.gmane.org/gmane.comp.gis.postgis/18822 I am outputting EPSG 4326 (WGS84) polygon data as svg from postgis. I am however struggling to get anything to render as SVG. Does anyone know the correct viewBox and path transform setup to allow this type of data to render as svg. Or should I be using a different method? Here is an example of what I am currently doing. The path should render a low res polygon of Oxford, UK. Thanks for your help, Toby <?xml version="1.0"?> <!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN" "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd "> <svg width="1000px" height="1000px" viewBox="0 0 1000 1000" version="1.1" xmlns="http://www.w3.org/2000/svg"> <path transform="rotate(-90) scale(100, 100)" d="M 0.921728857893816 -51.667439178992964 -0.943648406641863 -51.632171437283979 -1.034036852747396 -51.615081510110407 -1.039191311589453 -51.598091782046289 -1.033829707386365 -51.556789304415609 -1.1425733621232 -51.557652243792148 -1.145679223489618 -51.547423329173235 -1.189737584965937 -51.5322594249 Toby Rainthorpe 2008-09-06T10:22:04 http://comments.gmane.org/gmane.comp.gis.postgis/18818 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Dowling, James Parker 2008-09-05T21:29:49 http://comments.gmane.org/gmane.comp.gis.postgis/18814 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Dylan Lorimer 2008-09-05T19:11:33 http://comments.gmane.org/gmane.comp.gis.postgis/18813 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Angel Menendez 2008-09-05T18:55:53 http://comments.gmane.org/gmane.comp.gis.postgis/18809 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Düster Horst 2008-09-05T06:31:30 http://comments.gmane.org/gmane.comp.gis.postgis/18802 Does anyone have a definition of cleanGeometry that they could post? The wiki page at http://postgis.refractions.net/support/wiki/index.php?full=geometry references the following unresponsive link: http://www.sogis1.so.ch/sogis/dl/postgis/cleanGeometry.sql Thanks, David David Jantzen 2008-09-05T01:51:04 http://comments.gmane.org/gmane.comp.gis.postgis/18800 Hi, Thinking (falsely) that I would cleverly locate where two sets of polygons did not overlap, I gave something like this a try: CREATE TABLE big_mistake as SELECT a.something, b.something FROM a JOIN b ON ST_Instersects(a,b) = FALSE; ... postgresql then proceeded to fill my harddrive with garbage! Note the self: don't try seemingly clever tricks without first *thinking* about them. Dylan Dylan Beaudette 2008-09-05T00:27:54 http://comments.gmane.org/gmane.comp.gis.postgis/18798 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users cyw< at >dls.net 2008-09-04T22:49:51 http://comments.gmane.org/gmane.comp.gis.postgis/18797 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users cyw< at >dls.net 2008-09-04T22:37:33 http://comments.gmane.org/gmane.comp.gis.postgis/18792 Hi Kevin, i send an example and hope yuo can reconstuct it. create table equal_test (name char(6)); SELECT AddGeometryColumn('','equal_test','the_geom','31466','MULTIPOLYGON',2); COPY equal_test (name, the_geom) FROM stdin; geom01 0106000020EA7A0000010000000103000000010000002B000000F18C9EFFB9B64341E314A022B1AF55 41AF0335FAB9B64341700D0F26B1AF5541C9C9D4F4B9B643418AAC8129B1AF5541B8B07CEFB9B64341F072F72C B1AF5541E2BF2CEAB9B64341D75B7030B1AF5541A3FEE4E4B9B643417162EC33B1AF55414974A5DFB9B64341EB 816B37B1AF55411A286EDAB9B643416DB5ED3AB1AF55414D213FD5B9B643411BF8723EB1AF5541106718D0B9B6 43411645FB41B1AF55418500FACAB9B643417A978645B1AF5541C3F4E3C5B9B643415EEA1449B1AF5541D34AD6 C0B9B64341D738A64CB1AF5541B609D1BBB9B64341F27D3A50B1AF55415F38D4B6B9B64341BDB4D153B1AF5541 B5DDDFB1B9B643413ED86B57B1AF55419500F4ACB9B6434178E3085BB1AF5541CFA710A8B9B643416BD1A85EB1 AF554127DA35A3B9B64341119D4B62B1AF5541579E639EB9B643416341F165B1AF55419A999999B9B643419A99 9969B1AF554166666686BAB6434152B81EB5B0AF554159EFACC7BAB64341CED465 Stüwe Rolf 2008-09-04T07:31:07 http://comments.gmane.org/gmane.comp.gis.postgis/18780 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Dylan Lorimer 2008-09-03T02:13:13 http://comments.gmane.org/gmane.comp.gis.postgis/18773 Hi, I am performing a basic intersection between two very large geometries. The resulting query plan looks like this: Nested Loop (cost=0.00..2761762.20 rows=429619 width=20202) Join Filter: _st_intersects(state_lu.wkb_geometry, m_polys.wkb_geometry) -> Seq Scan on state_lu (cost=0.00..13467.93 rows=198693 width=1158) -> Index Scan using mapunit_spatial_idx on mapunit_poly m_polys (cost=0.00..13.66 rows=3 width=19044) Index Cond: (state_lu.wkb_geometry && m_polys.wkb_geometry) Filter: (state_lu.wkb_geometry && m_polys.wkb_geometry) Both tables have spatial indices, and I am using PostgreSQL 8.3.1 and PostGIS 1.3.3. I am using the ST_Intersects() test as the join condition between these two tables. The query looks like this: SELECT m_polys.areasymbol, m_polys.mukey, Dylan Beaudette 2008-09-02T16:45:05 http://comments.gmane.org/gmane.comp.gis.postgis/18763 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Stüwe Rolf 2008-09-02T09:37:35 http://comments.gmane.org/gmane.comp.gis.postgis/18759 Dear all, A pre-release version of "GIS Virtual Machine" is available at : www.gisvm.com GISVM is intended to be a full-feature GIS Workstation based exclusively on free GIS software, including PostgreSQL/PostGIS. Please feel free to download it and enjoy!!! Regards, -- Ricardo Pinho Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara < at >ymail.com ou < at >rocketmail.com. http://br.new.mail.yahoo.com/addresses Ricardo Pinho 2008-09-01T18:14:24 http://comments.gmane.org/gmane.comp.gis.postgis/18752 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Pedro Doria Meunier 2008-08-30T11:06:38 http://comments.gmane.org/gmane.comp.gis.postgis/18750 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Broun Uganda 2008-08-29T21:23:33 http://comments.gmane.org/gmane.comp.gis.postgis/18748 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Düster Horst 2008-08-29T14:59:33 http://comments.gmane.org/gmane.comp.gis.postgis/18745 Hello, I have two tables track_points1 and track_points2 having wkb_geometry columns. I want to make a query that can do this: select * from track_points1 where wkb_geometry1 in ( select wkb_geometry2 from track_points2 where wkb_geometry1= wkb_geometry2 (+/-) a ); where a is any value (hexadecimal /integer)... [basically i want to select one geometry that is in some range of another....] Can any1 help? Cheers, Reena. S.Reena 2008-08-29T10:21:53 http://comments.gmane.org/gmane.comp.gis.postgis/18744 SELECT Max(f.ogc_fid) as newgid,ST_MakeLine(f.wkb_geometry) As newgeom FROM (SELECT ogc_fid , wkb_geometry FROM track_points where ogc_fid<1020) AS f This gives newgeom only for ogc_fid<1020. If I omit this constraint or give value above 1020 ,den newgeom column is empty....what can be the problem..Can any1 suggest something Cheers, Reena. S.Reena 2008-08-29T10:15:09 http://comments.gmane.org/gmane.comp.gis.postgis/18743 _______________________________________________ postgis-users mailing list postgis-users< at >postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Matthew Pulis 2008-08-29T09:39:31 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.gis.postgis