Hello,
we want to set up a CSW service in combination with MySQL. There a three tables:
portal_geo_services => default information like in the GetCapabilities section
portal_geo_layers => layers from services, foreign key = id_service
portal_geo_layers_boxes => bounding boxes from layers, foreign keys => id_layer
I can see the tables from the setup page. But how to connect to the tables?
basic information service => sub information layer => sub information layer bbox
Any help would be great.
Dear Martin,
to be honest I am not completely sure about:
-a- what you are asking
-b- what you are trying to do with GeoServer
Can you elaborate a bit more?
On Fri, May 23, 2014 at 1:44 PM, TDS <tds@anonymised.com> wrote:
M. Martin
Ing. Simone Giannecchini
@simogeo
Founder/Director
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
Hello,
I want to do the following:
- set up a CSW
- use MySQL as Database
- GetCaps with default table "portal_geo_services", retrieve GetRecords with data inside this table
- GetRecord should display a SQL JOIN from "portal_geo_services" and "portal_geo_layers", maybe "portal_geo_layers_boxes" too
portal_geo_services
|-- portal_geo_layers
|-- portal_geo_layers_boxes
I want that we can access the CSW with default data from services, next level layers and next level boxes - if this is possible...
I'm very new in CSW, but experienced in reading, analyzing and displaying WMS, WFS, etc. via PHP, MySQL and OpenLayers.
MfG M. Martin
------------------------------------------------------------------------
mailto:tds@anonymised.com
------------------------------------------------------------------------
1+1=10
You have a question? - 42 or RTFM.
Am 23.05.2014 17:40, schrieb Simone Giannecchini:
Dear Martin,
to be honest I am not completely sure about:-a- what you are asking
-b- what you are trying to do with GeoServerCan you elaborate a bit more?
On Fri, May 23, 2014 at 1:44 PM, TDS <tds@anonymised.com> wrote:
M. Martin
Regards,
Simone GiannecchiniMeet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.Ing. Simone Giannecchini
@simogeo
Founder/DirectorGeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928http://www.geo-solutions.it
http://twitter.com/geosolutions_it-------------------------------------------------------