[OpenLayers-Users] Open layers with postgis

[Adam Eskreis]

Hello Aditya,

I do what you are wanting to do nearly every day at my job.  Here are a few
tips to help you get started:

1.  The first thing you need to do is set up a connection to your
PostgreSQL database.  Once this is complete, we can get started
2.  Next you are going to want to retrieve your data and pass it to the
frontend.  Assuming you already know how to do a spatial query, I would
pull whatever data you want from the database, parse it into an array and
echo it out using json.
3.  Once you have your json on the frontend, you just loop through the
array and plot the data as you need.
4.  The geo-data will come back from PostGIS as either Well Known Binary,
or Well Known Text, depending on how you chose to retrieve it.  WKB is
faster, but is harder to parse, and WKT has built in support in OpenLayers.
(have a look at the OpenLayers.Geometry.fromWKT function).  I recommend
pulling in the data as WKT for starting out, and as you get more familiar
you can work on writing a WKB parser.
5.  If you need help using spatial queries, I would consult the PostGIS
guide before continuing wiht anything, however the main functions I would
recommen dlooking up are:
distance
within
contains
intersects
astext

These functions will encompass most spatial queries you need to execute.

Hope this helps,
-Adam




On Tue, Nov 15, 2011 at 8:08 AM, Nicholas Efremov-Kendall <
n.e.kendall at gmail.com> wrote:

> I have an ajax app the querries mysql and returns the results as GML. If
> you like, I can share the code with you,
>
>
> On Tue, Nov 15, 2011 at 2:15 AM, adams <adams at terrestris.de> wrote:
>
>> Oh sorry,
>> I apologize, the correct URL is:
>>
>> http://www.openlayers-buch.de/beispiele.php
>>
>>
>> (@Bart 403 only for you - today because of the football match, thanks
>> for the hint)
>>
>> Regards, Till
>>
>> On 15.11.2011 09:08, Bart van den Eijnden (OSGIS) wrote:
>> > Hey Till,
>> >
>> > that URL gives a 403 forbidden.
>> >
>> > Best regards,
>> > Bart
>> >
>> >> Dear Aditya,
>> >>
>> >> there is postgis console, which directly displays queries in OL - this
>> >> is a tool my colleague made for a german OL manual.
>> >>
>> >> See the stuff here:
>> >> http://www.openlayers-buch.de/beispiele/
>> >>
>> >> go to chapter 9 (in germany only, sorry).
>> >>
>> >> You may also download the code from this page.
>> >>
>> >> Regards, Till
>> >>
>> >>
>> >> On 15.11.2011 08:54, Aditya Kumar wrote:
>> >>> Dear USers,
>> >>>   I want to display the result of some queries from postgis using
>> >>> php.Can
>> >>> you suggest me some documentation for this so that I can go through
>> them
>> >>> and
>> >>> make my application?
>> >>>
>> >>>
>> >>> Aditya Kumr
>> >>>
>> >>> --
>> >>> View this message in context:
>> >>>
>> http://osgeo-org.1803224.n2.nabble.com/Open-layers-with-postgis-tp6995410p6995410.html
>> >>> Sent from the OpenLayers Users mailing list archive at Nabble.com.
>> >>> _______________________________________________
>> >>> Users mailing list
>> >>> Users at lists.osgeo.org
>> >>> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>> >>>
>> >>
>> >> --
>> >>
>> >>
>> >> --> GO Mobile - jetzt WebGIS auch auf Smartphones <--
>> >>        ! Achtung - terrestris hat eine neue Adresse !
>> >>
>> >> ---------------------------------------------------------
>> >> terrestris GmbH & Co. KG
>> >> Puetzchens Chaussee 56
>> >> 53227 Bonn
>> >> Germany
>> >>
>> >> Till Adams
>> >> Geschaeftsfuehrung
>> >>
>> >> Tel:                 +49 (0)228 / 962 899-52
>> >> Mobile:      +49 (0)151 / 25394429
>> >> Fax:                 +49 (0)228 / 962 899-57
>> >>
>> >> adams at terrestris.de
>> >> http://www.terrestris.de
>> >> Amtsgericht Bonn, HRA 6835
>> >> ---------------------------------------------------------
>> >>
>> >> Komplementaerin:
>> >>
>> >> terrestris Verwaltungs GmbH
>> >>
>> >> vertreten durch:
>> >> Hinrich Paulsen, Till Adams
>> >> _______________________________________________
>> >> Users mailing list
>> >> Users at lists.osgeo.org
>> >> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>> >>
>> >
>> >
>>
>> --
>>
>>
>> --> GO Mobile - jetzt WebGIS auch auf Smartphones <--
>>       ! Achtung - terrestris hat eine neue Adresse !
>>
>> ---------------------------------------------------------
>> terrestris GmbH & Co. KG
>> Puetzchens Chaussee 56
>> 53227 Bonn
>> Germany
>>
>> Till Adams
>> Geschaeftsfuehrung
>>
>> Tel:            +49 (0)228 / 962 899-52
>> Mobile: +49 (0)151 / 25394429
>> Fax:            +49 (0)228 / 962 899-57
>>
>> adams at terrestris.de
>> http://www.terrestris.de
>> Amtsgericht Bonn, HRA 6835
>> ---------------------------------------------------------
>>
>> Komplementaerin:
>>
>> terrestris Verwaltungs GmbH
>>
>> vertreten durch:
>> Hinrich Paulsen, Till Adams
>> _______________________________________________
>> Users mailing list
>> Users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/openlayers-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20111115/f57cf633/attachment.html