Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
YYes, I read that document in order to install a production
environment with Geonetwork in tomcat..... very useful...... Before
get awareness about that document, I didn't have any idea about the
use of Postgis as data model for Geonetwork
Can you explain why Geonetwork uses shapefile and spatial indexes???
I thought that Geonetwork manages only metadata about geographic
information and not data....... So, why shapefile or other geographic
data store are used in Geonetwork???
There are some internal Shapefile used as Spatial indexes???
Use Postgis in place of Shapefile can improve the performance of Geonetwork???
Thank you Garcia for your help and your time....
2010/10/7 jose garcia <josegar74@anonymised.com>:
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
This is trhe information about the Spatial indexes in the document
that you was referred to:
"Spatial index
Stores metadata geographic extents
◦ Used in spatial queries
By default, stored in shapefile format
◦ Simple, no configuration needed
Can be also stored in Postgis
◦ Improve perfomance in queries (big catalogs)
◦ Need additional configuration"
That means an internal use of Shapefile in Geonetwork???
2010/10/7 Francesco D'Amore <damore@anonymised.com>:
YYes, I read that document in order to install a production
environment with Geonetwork in tomcat..... very useful...... Before
get awareness about that document, I didn't have any idea about the
use of Postgis as data model for Geonetwork
Can you explain why Geonetwork uses shapefile and spatial indexes???
I thought that Geonetwork manages only metadata about geographic
information and not data....... So, why shapefile or other geographic
data store are used in Geonetwork???
There are some internal Shapefile used as Spatial indexes???
Use Postgis in place of Shapefile can improve the performance of Geonetwork???
Thank you Garcia for your help and your time....
2010/10/7 jose garcia <josegar74@anonymised.com>:
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
--
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
I ask my self...
WEB-INF/lucene/spatial..
Here there is the spatialindexes.shp........
2010/10/7 Francesco D'Amore <damore@anonymised.com>:
This is trhe information about the Spatial indexes in the document
that you was referred to:
"Spatial index
Stores metadata geographic extents
◦ Used in spatial queries
By default, stored in shapefile format
◦ Simple, no configuration needed
Can be also stored in Postgis
◦ Improve perfomance in queries (big catalogs)
◦ Need additional configuration"
That means an internal use of Shapefile in Geonetwork???
2010/10/7 Francesco D'Amore <damore@anonymised.com>:
YYes, I read that document in order to install a production
environment with Geonetwork in tomcat..... very useful...... Before
get awareness about that document, I didn't have any idea about the
use of Postgis as data model for Geonetwork
Can you explain why Geonetwork uses shapefile and spatial indexes???
I thought that Geonetwork manages only metadata about geographic
information and not data....... So, why shapefile or other geographic
data store are used in Geonetwork???
There are some internal Shapefile used as Spatial indexes???
Use Postgis in place of Shapefile can improve the performance of Geonetwork???
Thank you Garcia for your help and your time....
2010/10/7 jose garcia <josegar74@anonymised.com>:
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
--
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
--
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
Hi Francesco,
2010/10/7 Francesco D'Amore <damore@anonymised.com>:
YYes, I read that document in order to install a production
environment with Geonetwork in tomcat..... very useful...... Before
get awareness about that document, I didn't have any idea about the
use of Postgis as data model for Geonetwork
Can you explain why Geonetwork uses shapefile and spatial indexes???
I thought that Geonetwork manages only metadata about geographic
information and not data....... So, why shapefile or other geographic
data store are used in Geonetwork???
There are some internal Shapefile used as Spatial indexes???
Use Postgis in place of Shapefile can improve the performance of Geonetwork???
Here is some numbers about GeoNetwork 2.4.x / 2.6.0 and
PostGreSQL+Shapefile / PostGIS insert time (look at the end of the
post)
http://www.neogeo-online.net/blog/archives/428/
Unfortunately this is in french.
Francois
Thank you Garcia for your help and your time....
2010/10/7 jose garcia <josegar74@anonymised.com>:
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
Thank you Francois.
It seems that the time of insertion is improved with Postgis and in
general with Geonetwork 2.6.0. Good.... It would be very interesting
to check also about the time of metadata research.
However, I'm trying to move my geonetwork on Postgis....at moment I'm
using a Postgres data model.
When a change my database, in a database completely new and empty, a
get this error:
2010-10-08 16:15:18,118 ERROR [jeeves.apphand] - Failed to create
datastore for jdbc:postgis://127.0.0.1/g_metadata. Will use shapefile
instead.
2010-10-08 16:15:18,118 ERROR [jeeves.apphand] - String index out of range: -1
Any suggestions???
P.S.
A posted this question in another mail in the mail list. Sorry for duplication.
2010/10/10 Francois Prunayre <fx.prunayre@anonymised.com>:
Hi Francesco,
2010/10/7 Francesco D'Amore <damore@anonymised.com>:
YYes, I read that document in order to install a production
environment with Geonetwork in tomcat..... very useful...... Before
get awareness about that document, I didn't have any idea about the
use of Postgis as data model for Geonetwork
Can you explain why Geonetwork uses shapefile and spatial indexes???
I thought that Geonetwork manages only metadata about geographic
information and not data....... So, why shapefile or other geographic
data store are used in Geonetwork???
There are some internal Shapefile used as Spatial indexes???
Use Postgis in place of Shapefile can improve the performance of Geonetwork???
Here is some numbers about GeoNetwork 2.4.x / 2.6.0 and
PostGreSQL+Shapefile / PostGIS insert time (look at the end of the
post)
http://www.neogeo-online.net/blog/archives/428/
Unfortunately this is in french.
Francois
Thank you Garcia for your help and your time....
2010/10/7 jose garcia <josegar74@anonymised.com>:
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
2010/10/11 Francesco D'Amore <damore@anonymised.com>:
Thank you Francois.
It seems that the time of insertion is improved with Postgis and in
general with Geonetwork 2.6.0. Good.... It would be very interesting
to check also about the time of metadata research.
However, I'm trying to move my geonetwork on Postgis....at moment I'm
using a Postgres data model.
When a change my database, in a database completely new and empty, a
get this error:
2010-10-08 16:15:18,118 ERROR [jeeves.apphand] - Failed to create
datastore for jdbc:postgis://127.0.0.1/g_metadata. Will use shapefile
instead.
Let's try using
jdbc:postgis://127.0.0.1:5432/g_metadata
I think postgis setup is based on this jdbc url format.
This could be improved for sure. If you confirmed that that works, we
should probably open a ticket for enhancement on trac then.
Francois
2010-10-08 16:15:18,118 ERROR [jeeves.apphand] - String index out of range: -1
Any suggestions???
P.S.
A posted this question in another mail in the mail list. Sorry for duplication.
2010/10/10 Francois Prunayre <fx.prunayre@anonymised.com>:
Hi Francesco,
2010/10/7 Francesco D'Amore <damore@anonymised.com>:
YYes, I read that document in order to install a production
environment with Geonetwork in tomcat..... very useful...... Before
get awareness about that document, I didn't have any idea about the
use of Postgis as data model for Geonetwork
Can you explain why Geonetwork uses shapefile and spatial indexes???
I thought that Geonetwork manages only metadata about geographic
information and not data....... So, why shapefile or other geographic
data store are used in Geonetwork???
There are some internal Shapefile used as Spatial indexes???
Use Postgis in place of Shapefile can improve the performance of Geonetwork???
Here is some numbers about GeoNetwork 2.4.x / 2.6.0 and
PostGreSQL+Shapefile / PostGIS insert time (look at the end of the
post)
http://www.neogeo-online.net/blog/archives/428/
Unfortunately this is in french.
Francois
Thank you Garcia for your help and your time....
2010/10/7 jose garcia <josegar74@anonymised.com>:
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
Thank you!!!!!! It works fine!!!
A changed "jdbc:postgis://127.0.0.1/g_metadata" with
"jdbc:postgis://127.0.0.1:5432/g_metadata" and ant think go very
well....
The only strange behaviour is about the use of te port (e.g. 5432...)
only in the postgis url string and why the port is not mandatory in
the simple postgres url string.......but......never mind, is doesn't
matter...it works!!
Thank you.
2010/10/11 Francois Prunayre <fx.prunayre@anonymised.com>:
2010/10/11 Francesco D'Amore <damore@anonymised.com>:
Thank you Francois.
It seems that the time of insertion is improved with Postgis and in
general with Geonetwork 2.6.0. Good.... It would be very interesting
to check also about the time of metadata research.
However, I'm trying to move my geonetwork on Postgis....at moment I'm
using a Postgres data model.
When a change my database, in a database completely new and empty, a
get this error:
2010-10-08 16:15:18,118 ERROR [jeeves.apphand] - Failed to create
datastore for jdbc:postgis://127.0.0.1/g_metadata. Will use shapefile
instead.
Let's try using
jdbc:postgis://127.0.0.1:5432/g_metadata
I think postgis setup is based on this jdbc url format.
This could be improved for sure. If you confirmed that that works, we
should probably open a ticket for enhancement on trac then.
Francois
2010-10-08 16:15:18,118 ERROR [jeeves.apphand] - String index out of range: -1
Any suggestions???
P.S.
A posted this question in another mail in the mail list. Sorry for duplication.
2010/10/10 Francois Prunayre <fx.prunayre@anonymised.com>:
Hi Francesco,
2010/10/7 Francesco D'Amore <damore@anonymised.com>:
YYes, I read that document in order to install a production
environment with Geonetwork in tomcat..... very useful...... Before
get awareness about that document, I didn't have any idea about the
use of Postgis as data model for Geonetwork
Can you explain why Geonetwork uses shapefile and spatial indexes???
I thought that Geonetwork manages only metadata about geographic
information and not data....... So, why shapefile or other geographic
data store are used in Geonetwork???
There are some internal Shapefile used as Spatial indexes???
Use Postgis in place of Shapefile can improve the performance of Geonetwork???
Here is some numbers about GeoNetwork 2.4.x / 2.6.0 and
PostGreSQL+Shapefile / PostGIS insert time (look at the end of the
post)
http://www.neogeo-online.net/blog/archives/428/
Unfortunately this is in french.
Francois
Thank you Garcia for your help and your time....
2010/10/7 jose garcia <josegar74@anonymised.com>:
Hi Francesco
In http://geonetwork-opensource.org/docs.html in the presentation *Mastering
Advanced GeoNetwork tutorial* you can find some information about the
postgis installation and configuration in GeoNetwork.
But unless you want to store the spatial indexes in postgis instead of a
shapefile (as default) you can use with postgres database model, no need to
move to postgis datamodel.
Regards,
Jose García
On Thu, Oct 7, 2010 at 12:21 PM, Francesco D'Amore <damore@anonymised.com>wrote:
Hi all....
I would like to migrate from the data model used for Postgres databae
to the datamodel used for Postgis....
In the web I don't found any documentation bout this migration, but I
think that a tool or sql script that perform this migration my be very
usefull.
I don't wont to rewrite any metadata information....... this is the
step that a would perform in order to migrate the data model...
1) add to to old postgres databases the function and the facilities
needed to postgis (functions, geometry_column and reference_systems
table....)
2) add the table related to spatial_index....
The difference between the two data model are, I thinks, three tables
and the postgis functions..........
Any suggestions about this plan??? Some advice???
Thank you a lot....
--
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today.
http://p.sf.net/sfu/beautyoftheweb
_______________________________________________
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