Re: [OpenMap Users] database connectivity

Hi Declan,

You might want to check out the OracleSpatialLayer on the OpenMap
submissions page:

http://openmap.bbn.com/submissions.html

It might be a little rusty and might not compile with the latest
version of Openmap, but it gives the general idea of retrieving code
from a database.

In the OpenMap 4.6 beta, there is a com.bbn.openmap.layer.mySQL package
that is a good example to go off of as it does, obviously, compile with
the latest version of OpenMap.

For working with PostGIS, you'll want to check out this message to the
openmap-users mailing list:

http://openmap.bbn.com/mailArchives/openmap-users/2003-08/1807.html

The WKB4J would be a good place to start for storing geometries in the
database and retrieving them (although I think you have to use
something else to store the geometries into the database). shp2pgsql
and ogr2ogr are two tools I've been told about.

Hope this helps,

Don

On Jan 23, 2004, at 12:56 PM, Declan Lynch wrote:

> Hi all,
> I am a student researching a GIS project and recently discovered
> OpenMap.
> I intend, in the long run, to connect the client to a PostgreSql db
> with the PostGIS spatial extension.
> So far I have manually transferred some city data from the cities.csv
> file to the native PostgreSql db (simple character and numeric data)
> and can now retrieve/display this data using the DBLocationHandler
> class.
> I feel the next step for me is to try to display a simple geometry
> (for example a circle, which is implemented in the native postgresql,
> no need for PostGIS for this) retrieved from the db.  However, I am
> not sure where to begin.  Are there any classes that can retrieve
> geometries from a remote db?
> What are the classes that I need to become familiar with?
>  
> Sorry if my questions are a bit newbie.
>  
> Thanks in advance
> Declan Lynch
>  
>
> --
> This message has been scanned for content and viruses by the
> DIT Information Services MailScanner Service,
> and is believed to be clean.
> http://www.dit.ie

--
[To unsubscribe to this list send an email to "majdart@bbn.com"
with the following text in the BODY of the message "unsubscribe openmap-users"]