Hello List,
1. I copied some OSM data with osm2pgsql to my potgresql database resulting
in 4 tables to symbolize:
osm_planet_line
osm_planet_point
osm_planet_polygon
osm_planet_roads
2. I used mapnik2geotools to translate the black and white mapnik osm style
to geoserver sld.
https://trac.openstreetmap.org/browser/subversion/applications/rendering/parking/mapnik/bw-mapnik
The Transformation is giving me back many sld style files(91).
Now my question is:
How can I associated the styles with my 4 layers?
Thanks,
Herbert Miller
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapnik2geotools-and-multiple-SLD-with-one-layer-tp5048989.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Mapnik2GeoTools can connect to GeoServer through the REST API and set up your layers and styles for you. What it does is:
- configure one layer/resource for each table
- configure one style for each sld
- configure a layergroup with all the layers and styles in the correct order (based on the layer order from the mapnik XML.)
You can of course make all these changes yourself, but for 91 styles it might take a while.
BTW, Mapnik styles for OpenStreetMap often sneak subqueries into database “table” names:
(select way, "addr:housenumber" from &prefix;_polygon where "addr:housenumber" is not null and building is not null) as housenumbers
GeoServer doesn’t allow this so Mapnik2GeoTools creates .sql files you can use to create real tables that can be used instead - if you don’t run them then you will not be able to apply all the styles.
···
On Tue, Apr 23, 2013 at 4:05 AM, Hebert_Miller <floodm@anonymised.com> wrote:
Hello List,
- I copied some OSM data with osm2pgsql to my potgresql database resulting
in 4 tables to symbolize:
osm_planet_line
osm_planet_point
osm_planet_polygon
osm_planet_roads
- I used mapnik2geotools to translate the black and white mapnik osm style
to geoserver sld.
https://trac.openstreetmap.org/browser/subversion/applications/rendering/parking/mapnik/bw-mapnik
The Transformation is giving me back many sld style files(91).
Now my question is:
How can I associated the styles with my 4 layers?
Thanks,
Herbert Miller
–
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapnik2geotools-and-multiple-SLD-with-one-layer-tp5048989.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Try New Relic Now & We’ll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
On Tue, Apr 23, 2013 at 3:01 PM, David Winslow <dwinslow@anonymised.com> wrote:
BTW, Mapnik styles for OpenStreetMap often sneak subqueries into database
"table" names:
<Parameter name="table">
(select way, "addr:housenumber" from &prefix;_polygon where
"addr:housenumber" is not null and building is not null) as housenumbers
</Parameter>
GeoServer doesn't allow this so Mapnik2GeoTools creates .sql files you can
use to create real tables that can be used instead - if you don't run them
then you will not be able to apply all the styles.
Just thinking out loud here, but wouldn't it be possible to use sql views
for this task?
Cheers
Andrea
--
GeoServer training in Milan, 6th & 7th June 2013! Visit
http://geoserver.geo-solutions.it for more information.
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
Yes, they would (either database views or the GeoServer feature with that name.) If someone is interested in implementing it I could give some pointers on how to make the changes.
···
On Tue, Apr 23, 2013 at 9:10 AM, Andrea Aime <andrea.aime@anonymised.com> wrote:
On Tue, Apr 23, 2013 at 3:01 PM, David Winslow <dwinslow@anonymised.com> wrote:
BTW, Mapnik styles for OpenStreetMap often sneak subqueries into database “table” names:
(select way, "addr:housenumber" from &prefix;_polygon where "addr:housenumber" is not null and building is not null) as housenumbers
GeoServer doesn’t allow this so Mapnik2GeoTools creates .sql files you can use to create real tables that can be used instead - if you don’t run them then you will not be able to apply all the styles.
Just thinking out loud here, but wouldn’t it be possible to use sql views for this task?
Cheers
Andrea
–
==
GeoServer training in Milan, 6th & 7th June 2013! Visit http://geoserver.geo-solutions.it for more information.
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
Ok. Thats what i was wondering about. Now things make sense. Tried to connect through the REST-API but it didnt work for me. Is there a mapnik2geotools logfile somewhere? Because the original error message is too big to be displayed correctly. Only thing i can see its about online resource of some .png symbols. Thanks again, Hebert Miller
···
Am 23.04.2013 15:01, schrieb David Winslow:
Mapnik2GeoTools can connect to GeoServer through the REST API and set up your layers and styles for you. What it does is:
- configure one layer/resource for each table
- configure one style for each sld
- configure a layergroup with all the layers and styles in the correct order (based on the layer order from the mapnik XML.)
You can of course make all these changes yourself, but for 91 styles it might take a while.
BTW, Mapnik styles for OpenStreetMap often sneak subqueries into database “table” names:
(select way, "addr:housenumber" from &prefix;_polygon where "addr:housenumber" is not null and building is not null) as housenumbers
GeoServer doesn’t allow this so Mapnik2GeoTools creates .sql files you can use to create real tables that can be used instead - if you don’t run them then you will not be able to apply all the styles.
–
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Apr 23, 2013 at 4:05 AM, Hebert_Miller <floodm@anonymised.com> wrote:
Hello List,
- I copied some OSM data with osm2pgsql to my potgresql database resulting
in 4 tables to symbolize:
osm_planet_line
osm_planet_point
osm_planet_polygon
osm_planet_roads
- I used mapnik2geotools to translate the black and white mapnik osm style
to geoserver sld.
https://trac.openstreetmap.org/browser/subversion/applications/rendering/parking/mapnik/bw-mapnik
The Transformation is giving me back many sld style files(91).
Now my question is:
How can I associated the styles with my 4 layers?
Thanks,
Herbert Miller
–
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapnik2geotools-and-multiple-SLD-with-one-layer-tp5048989.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Try New Relic Now & We’ll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-user
No, there’s no log file. You can try running it from a terminal and dumping output to a file:
java -jar mapnik2geotools-0.1.jar 2>&1 > mn2gt.log
This should work whether you are using the command-line parameters or configuring things through the GUI.
···
On Tue, Apr 23, 2013 at 10:52 AM, OZ <floodm@anonymised.com> wrote:
Am 23.04.2013 15:01, schrieb David Winslow:
Mapnik2GeoTools can connect to GeoServer through the REST API and set up your layers and styles for you. What it does is:
- configure one layer/resource for each table
- configure one style for each sld
- configure a layergroup with all the layers and styles in the correct order (based on the layer order from the mapnik XML.)
You can of course make all these changes yourself, but for 91 styles it might take a while.
BTW, Mapnik styles for OpenStreetMap often sneak subqueries into database “table” names:
(select way, "addr:housenumber" from &prefix;_polygon where "addr:housenumber" is not null and building is not null) as housenumbers
GeoServer doesn’t allow this so Mapnik2GeoTools creates .sql files you can use to create real tables that can be used instead - if you don’t run them then you will not be able to apply all the styles.
–
David Winslow
OpenGeo - http://opengeo.org/
Ok. Thats what i was wondering about. Now things make sense.
Tried to connect through the REST-API but it didnt work for me. Is there a mapnik2geotools logfile somewhere? Because the original error message is too big to be displayed correctly. Only thing i can see its about online resource of some .png symbols.
Thanks again,
Hebert Miller
On Tue, Apr 23, 2013 at 4:05 AM, Hebert_Miller <floodm@anonymised.com> wrote:
Hello List,
- I copied some OSM data with osm2pgsql to my potgresql database resulting
in 4 tables to symbolize:
osm_planet_line
osm_planet_point
osm_planet_polygon
osm_planet_roads
- I used mapnik2geotools to translate the black and white mapnik osm style
to geoserver sld.
https://trac.openstreetmap.org/browser/subversion/applications/rendering/parking/mapnik/bw-mapnik
The Transformation is giving me back many sld style files(91).
Now my question is:
How can I associated the styles with my 4 layers?
Thanks,
Herbert Miller
–
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapnik2geotools-and-multiple-SLD-with-one-layer-tp5048989.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Try New Relic Now & We’ll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-user
I tried it with the mn2gt-assembly-0.1.jar. Did you mean this jar-file? Because its giving me back the fontsetname not found failure. I read about this failure already in the google group and with the newest version of mn2gt it didn`t appear. Hebert Miller
···
Am 23.04.2013 16:55, schrieb David Winslow:
No, there’s no log file. You can try running it from a terminal and dumping output to a file:
java -jar mapnik2geotools-0.1.jar 2>&1 > mn2gt.log
This should work whether you are using the command-line parameters or configuring things through the GUI.
–
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Apr 23, 2013 at 10:52 AM, OZ <floodm@anonymised.com> wrote:
Am 23.04.2013 15:01, schrieb David Winslow:
Mapnik2GeoTools can connect to GeoServer through the REST API and set up your layers and styles for you. What it does is:
- configure one layer/resource for each table
- configure one style for each sld
- configure a layergroup with all the layers and styles in the correct order (based on the layer order from the mapnik XML.)
You can of course make all these changes yourself, but for 91 styles it might take a while.
BTW, Mapnik styles for OpenStreetMap often sneak subqueries into database “table” names:
(select way, "addr:housenumber" from &prefix;_polygon where "addr:housenumber" is not null and building is not null) as housenumbers
GeoServer doesn’t allow this so Mapnik2GeoTools creates .sql files you can use to create real tables that can be used instead - if you don’t run them then you will not be able to apply all the styles.
–
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Apr 23, 2013 at 4:05 AM, Hebert_Miller <floodm@anonymised.com> wrote:
Hello List,
- I copied some OSM data with osm2pgsql to my potgresql database resulting
in 4 tables to symbolize:
osm_planet_line
osm_planet_point
osm_planet_polygon
osm_planet_roads
- I used mapnik2geotools to translate the black and white mapnik osm style
to geoserver sld.
https://trac.openstreetmap.org/browser/subversion/applications/rendering/parking/mapnik/bw-mapnik
The Transformation is giving me back many sld style files(91).
Now my question is:
How can I associated the styles with my 4 layers?
Thanks,
Herbert Miller
–
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapnik2geotools-and-multiple-SLD-with-one-layer-tp5048989.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Try New Relic Now & We’ll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-user
Ok. Thats what i was wondering about. Now things make sense.
Tried to connect through the REST-API but it didnt work for me. Is there a mapnik2geotools logfile somewhere? Because the original error message is too big to be displayed correctly. Only thing i can see its about online resource of some .png symbols.
Thanks again,
Hebert Miller
I got the error message now: org.apache.commons.httpclient.auth.AuthChallengeProcessor selectAuthScheme You got a hint for me? Best regards, Henert Miller
···
Am 24.04.2013 10:24, schrieb OZ:
I tried it with the mn2gt-assembly-0.1.jar. Did you mean this jar-file? Because its giving me back the fontsetname not found failure. I read about this failure already in the google group and with the newest version of mn2gt it didn`t appear. Hebert Miller
Am 23.04.2013 16:55, schrieb David Winslow:
No, there’s no log file. You can try running it from a terminal and dumping output to a file:
java -jar mapnik2geotools-0.1.jar 2>&1 > mn2gt.log
This should work whether you are using the command-line parameters or configuring things through the GUI.
–
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Apr 23, 2013 at 10:52 AM, OZ <floodm@anonymised.com> wrote:
Am 23.04.2013 15:01, schrieb David Winslow:
Mapnik2GeoTools can connect to GeoServer through the REST API and set up your layers and styles for you. What it does is:
- configure one layer/resource for each table
- configure one style for each sld
- configure a layergroup with all the layers and styles in the correct order (based on the layer order from the mapnik XML.)
You can of course make all these changes yourself, but for 91 styles it might take a while.
BTW, Mapnik styles for OpenStreetMap often sneak subqueries into database “table” names:
(select way, "addr:housenumber" from &prefix;_polygon where "addr:housenumber" is not null and building is not null) as housenumbers
GeoServer doesn’t allow this so Mapnik2GeoTools creates .sql files you can use to create real tables that can be used instead - if you don’t run them then you will not be able to apply all the styles.
–
David Winslow
OpenGeo - http://opengeo.org/
On Tue, Apr 23, 2013 at 4:05 AM, Hebert_Miller <floodm@anonymised.com> wrote:
Hello List,
- I copied some OSM data with osm2pgsql to my potgresql database resulting
in 4 tables to symbolize:
osm_planet_line
osm_planet_point
osm_planet_polygon
osm_planet_roads
- I used mapnik2geotools to translate the black and white mapnik osm style
to geoserver sld.
https://trac.openstreetmap.org/browser/subversion/applications/rendering/parking/mapnik/bw-mapnik
The Transformation is giving me back many sld style files(91).
Now my question is:
How can I associated the styles with my 4 layers?
Thanks,
Herbert Miller
–
View this message in context: http://osgeo-org.1560.x6.nabble.com/mapnik2geotools-and-multiple-SLD-with-one-layer-tp5048989.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
Try New Relic Now & We’ll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-user
Ok. Thats what i was wondering about. Now things make sense.
Tried to connect through the REST-API but it didnt work for me. Is there a mapnik2geotools logfile somewhere? Because the original error message is too big to be displayed correctly. Only thing i can see its about online resource of some .png symbols.
Thanks again,
Hebert Miller
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! [http://p.sf.net/sfu/newrelic_d2d_apr](http://p.sf.net/sfu/newrelic_d2d_apr)
_______________________________________________
Geoserver-users mailing list
[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@lists.sourceforge.net)
[https://lists.sourceforge.net/lists/listinfo/geoserver-users](https://lists.sourceforge.net/lists/listinfo/geoserver-users)