Thanks simon,
The app on you Tube looks interesting.
Is that GeoExt/Postgis/Geoserver/OpenLayers on linux with php backend?
Any source code available?
cheers,
Rob
________________________________
Von: Simon Appelt <[email protected]>
An: Robert Buckley <[email protected]>
Gesendet: 20:26 Dienstag, 20.September 2011
Betreff: Re: [Geoserver-users] st_intersection as new SQL view
Hi Rob,
did u try?:
http://trac.osgeo.org/postgis/wiki/UsersWikiExamplesOverlayTables
it works for me as u can see at my youtube video 1:30:
http://www.youtube.com/user/maptagsde?feature=mhee#p/a/u/0/Aw1Myp7iHbI
My PHP-Code looks like:
$sql = 'INSERT INTO ma_teilflaechen(the_geom,flurnr) SELECT
intersection(f.the_geom, c.the_geom),d.txt
FROM "alk_flurstuecke" f, "ma_flaechen" c, "alk_nummern" d
WHERE
c.gid = '.$gid.'
AND
f.the_geom && c.the_geom
AND
Intersects(f.the_geom, c.the_geom)
AND
f.alk_oid = d.r_masterid;';
maybe this,
regards,
Simon
Am 20.09.2011 19:12, schrieb Robert Buckley:
Hi,
>
>
>I have been trying to st_intersect two layers from the same postgis database
>on and off for a couple of weeks now without any success.
>
>
>Can this be done as a geoserver sql view?
>
>
>yours,
>
>
>Rob
>
>
>------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
>
>
>_______________________________________________
Geoserver-users mailing list [email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Visit me at - Blog : http://www.maptags.de - Twitter:
http://twitter.com/maptagsde - youtube: http://www.youtube.com/maptagsde ------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
