Re: [OpenMap Users] How can I add a postgis layer in openmap

From: JayDub <justcallmejay_at_gmail.com>
Date: Wed, 2 Sep 2009 19:10:20 -0700 (PDT)

Okay... my mistake...
I needed to use 4326 as the SRID
shp2pgsql -s 4326 ... blah blah

I have another problem though. Point shows up fine. I have another geom
layer that does not show up _at_ all. Any suggestions? I get no errors.


JayDub wrote:
>
> Thanks for this... So far I'm getting somewhere it seems.
>
> Had to download the postgis driver and the jdbc driver.
> Now I get this exception... any ideas?
>
> I've put a shp file into the database using shp2pgsql -s 3344 shpfile.shp
> tablename > file.sql
> Then
> pgsql dbname -f file.sql
>
> org.postgresql.util.PSQLException: ERROR: Operation on two geometries with
> different SRIDs
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
> at
> hs.module.map.PostGISGeometryLayer.prepare(PostGISGeometryLayer.java:239)
> at
> com.bbn.openmap.layer.policy.StandardRenderPolicy.prepare(StandardRenderPolicy.java:99)
> at
> com.bbn.openmap.layer.OMGraphicHandlerLayer$LayerWorker.construct(OMGraphicHandlerLayer.java:695)
> at com.bbn.openmap.util.SwingWorker$2.run(SwingWorker.java:127)
>
>
>
> oland wrote:
>>
>> Maybe this can help
>>
>> http://openmap.bbn.com/mailArchives/openmap-users/att-5403/PostGISGeometryLayer.java___size_19066
>>
>> On 02-09-2009 18:52, JayDub wrote:
>>> I know for fact that a postgis driver was built for OpenMap about 2 or
>>> so
>>> years ago. Apparently that wasn't patched in? I'd hate to think that
>>> I'll
>>> have to reinvent the wheel for this to work. I'm about to start a
>>> project
>>> for which I was depending on this postgis driver for everything to work.
>>>
>>>
>>> Tore Halset wrote:
>>>
>>>> Hello.
>>>>
>>>> One way could be to use JTS to create geometries from WKT and then the
>>>> code I posted on the "Help with OMGraphics"-thread to convert from JTS
>>>> to OMGraphic. Another way would be to use the PostGIS jdbc driver and
>>>> create/find some code to convert their geometry-format to OMGraphic.
>>>>
>>>> - Tore.
>>>>
>>>> On Sep 1, 2009, at 16:56 , JayDub wrote:
>>>>
>>>>
>>>>> Surely there is a way to get this done???? How can I add a postgis
>>>>> layer in
>>>>> openmap?
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/How-can-I-add-a-postgis-layer-in-openmap-tp25241834p25241834.html
>>>>> Sent from the OpenMap mailing list archive at Nabble.com.
>>>>>
>>>>> --
>>>>> [To unsubscribe to this list send an email to "majdart_at_bbn.com"
>>>>> with the following text in the BODY of the message "unsubscribe
>>>>> openmap-users"]
>>>>>
>>>>>
>>>> --
>>>> [To unsubscribe to this list send an email to "majdart_at_bbn.com"
>>>> with the following text in the BODY of the message "unsubscribe
>>>> openmap-users"]
>>>>
>>>>
>>>>
>>>
>>
>> --
>> [To unsubscribe to this list send an email to "majdart_at_bbn.com"
>> with the following text in the BODY of the message "unsubscribe
>> openmap-users"]
>>
>>
>
>

-- 
View this message in context: http://www.nabble.com/How-can-I-add-a-postgis-layer-in-openmap-tp25241834p25268757.html
Sent from the OpenMap mailing list archive at Nabble.com.
--
[To unsubscribe to this list send an email to "majdart_at_bbn.com"
with the following text in the BODY of the message "unsubscribe openmap-users"]
Received on Wed Sep 02 2009 - 22:10:46 EDT

This archive was generated by hypermail 2.3.0 : Tue Mar 28 2017 - 23:25:09 EDT