[GeoNetwork-users] postgis spatial index setup

GeoNetwork GeoNetwork User
,
1

Dear all,

Thanks to the last post, I have been able to create and load initial data into PostGIS. At least, it seems that is working fine. However, I have realized that spatial index bounding boxes are still written in the shapefile located at geonetwork/WEB-INF/lucene/spatial/spatialindex.shp. And any data is written in 'spatialindex' table from PostGIS. I'm wondering if we have missed any additional step to configure Geonetwork to write the spatial indexe in Postgis rather in the shapefile. Any tip on this will be very welcome!

Thanks!
David

--
David March Morlà
PhD candidate
Fisheries-GIS Spatial Ecologist
Email: david@anonymised.com

IMEDEA
Instituto Mediterraneo de Estudios Avanzados (UIB-CSIC)
C/Miquel Marquès 21, 07190 Esporles, Balearic Islands. Spain
www.imedea.uib.es

SOCIB
Balearic Islands Coastal Observing and Forecasting System
Strategic Issues and Applications for Society (SIAS Division)
Parc Bit, Naorte, Bloc A 2ºp. pta. 3, 07121 Palma de Mallorca. Spain
Tel: +034 971 43 99 98
www.socib.es

2

This is may Resource tag in config.xml locate at WEB-INF in geonetwork WAR.

<resource enabled="true">
      <name>main-db</name>
      <provider>jeeves.resources.dbms.DbmsPool</provider>
      <config>
        <user>myuser</user>
        <password>mypassword</password>
        <driver>org.postgresql.Driver</driver>
        <!--
          jdbc:postgresql:database
          jdbc:postgresql://host/database
          jdbc:postgresql://host:port/database
        -->
               <!--<url>jdbc:postgresql://127.0.0.1/mydb</url>-->
               <url>jdbc:postgis://127.0.0.1:5432/mydb</url>

        <poolSize>10</poolSize>
      </config>
    </resource>

Get a look at url.... for postgis the url is different.

2011/3/15 David March Morla <david@anonymised.com>:

Dear all,

Thanks to the last post, I have been able to create and load initial
data into PostGIS. At least, it seems that is working fine. However, I
have realized that spatial index bounding boxes are still written in the
shapefile located at geonetwork/WEB-INF/lucene/spatial/spatialindex.shp.
And any data is written in 'spatialindex' table from PostGIS. I'm
wondering if we have missed any additional step to configure Geonetwork
to write the spatial indexe in Postgis rather in the shapefile. Any tip
on this will be very welcome!

Thanks!
David

--
David March Morlà
PhD candidate
Fisheries-GIS Spatial Ecologist
Email: david@anonymised.com

IMEDEA
Instituto Mediterraneo de Estudios Avanzados (UIB-CSIC)
C/Miquel Marquès 21, 07190 Esporles, Balearic Islands. Spain
www.imedea.uib.es

SOCIB
Balearic Islands Coastal Observing and Forecasting System
Strategic Issues and Applications for Society (SIAS Division)
Parc Bit, Naorte, Bloc A 2ºp. pta. 3, 07121 Palma de Mallorca. Spain
Tel: +034 971 43 99 98
www.socib.es

------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

--
Ing. Francesco D'Amore
blog: www.marinajonica.org
linkedin: http://www.linkedin.com/in/francescodamore
Consiglio Nazionale delle Ricerche - Istituto di Inquinamento Atmosferico (IIA)
Ph. D. Student at University of Calabria - DEIS