Thanks Andrea
I will proceed with that. The data is oracle Spatial type (SDO) registered with SDE. I can share the data, but I am not sure which output/dump type you would prefer. I thought perhaps I may try the oracle driver and skip SDE and see what that does.
Thanks.
Michelle
On 9 Jan 2016 9:57 a.m., Andrea Aime <andrea.aime@anonymised.com> wrote:
Hi,
hum weird, it almost seems the coordinates for the point have not been reprojected.
Can you share a bit of the source data and the WMS request generating the KML
as a new bug report at https://osgeo-org.atlassian.net/projects/GEOS/summary ?
Cheers
Andrea
On Sat, Jan 9, 2016 at 6:41 PM, Douville, Michelle R GCPE:EX <Michelle.Douville@anonymised.com<mailto:Michelle.Douville@anonymised.com>> wrote:
Hi Andrea,
Thank you for your response.
Here is an example of a placemark which isn’t in the right place:
The lookat and the point coordinates are different (I would think they should both be in the lat long range of 49->60-124->-117.
The layer config is listed below after the KML output..
Thanks again!
Michelle
KML PLACEMARK OUTPUT with KML Network Link (mode=refresh, kmscore=0, kmplacemark=true)
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2" xmlns:kml="http://www.opengis.net/kml/2.2" xmlns:atom="http://www.w3.org/2005/Atom">
<Placemark id="WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG.24">
<name>Natural Resource Districts Generalized - Colour Themed</name>
<description><![CDATA[<ul>
<li><b>District Name</b>: Cariboo-Chilcotin Natural Resource District</li>
<li><b>Org Unit</b>: DCC</li>
<li><b>Org Unit Name</b>: Cariboo-Chilcotin Natural Resource District</li>
<li><b>Region Org Unit</b>: RCB</li>
<li><b>Region Org Unit Name</b>: Cariboo Natural Resource Region</li>
<li><b>Feature Code</b>: FM90000020</li>
<li><b>Feature Name</b>: Natural Resource District</li>
<li><b>Area Square Meters</b>: 4.93381060054049E10</li>
<li><b>Length Meters</b>: 1715478.6781</li>
</ul>]]></description>
<LookAt>
<longitude>-96.60873250800569</longitude>
<latitude>-9.849147269320397</latitude>
<altitude>0</altitude>
<heading>0</heading>
<tilt>0</tilt>
<range>0.1</range>
</LookAt>
<Style>
<LabelStyle>
<color>00ffffff</color>
<scale>0</scale>
</LabelStyle>
<LineStyle>
<color>ff6e6e6e</color>
<width>0.4</width>
</LineStyle>
<PolyStyle>
<color>ff4d4fa8</color>
<outline>1</outline>
</PolyStyle>
</Style>
<gx:balloonVisibility>1</gx:balloonVisibility>
<Point>
<coordinates>32400,32400,0</coordinates>
</Point>
</Placemark>
</kml>
Layer.xml in Geoserver:
<featureType>
<id>FeatureTypeInfoImpl--4ef8d84c:152139b63b5:-7f72</id>
<name>WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG</name>
<nativeName>WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG</nativeName>
<namespace>
<id>NamespaceInfoImpl--56fcfc1b:14e20f6b441:-7ffe</id>
</namespace>
<title>Natural Resource (NR) Districts</title>
<keywords>
<string>ArcSDE</string>
<string>WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG</string>
</keywords>
<metadataLinks>
<metadataLink>
<type>text/plain</type>
<metadataType>TC211</metadataType>
<content>http://catalogue.data.gov.bc.ca/dataset/generalized-natural-resource-nr-districts</content>
</metadataLink>
</metadataLinks>
<srs>EPSG:3005</srs>
<nativeBoundingBox>
<minx>273875.663</minx>
<maxx>1870571.76</maxx>
<miny>362346.895</miny>
<maxy>1735670.856</maxy>
<crs class="projected">EPSG:3005</crs>
</nativeBoundingBox>
<latLonBoundingBox>
<minx>-142.68590291964242</minx>
<maxx>-106.84575896667096</maxx>
<miny>36.17884878108903</miny>
<maxy>72.01899273406049</maxy>
<crs>EPSG:4326</crs>
</latLonBoundingBox>
<projectionPolicy>FORCE_DECLARED</projectionPolicy>
<enabled>true</enabled>
<metadata>
<entry key="kml.regionateAttribute">SHAPE</entry>
<entry key="cachingEnabled">false</entry>
<entry key="kml.regionateStrategy">geometry</entry>
</metadata>
<store class="dataStore">
<id>DataStoreInfoImpl-ffe839e:15169916d99:-7ffe</id>
</store>
<maxFeatures>0</maxFeatures>
<numDecimals>0</numDecimals>
<overridingServiceSRS>false</overridingServiceSRS>
<skipNumberMatched>false</skipNumberMatched>
<circularArcPresent>false</circularArcPresent>
</featureType>
From: andrea.aime@anonymised.com<mailto:andrea.aime@anonymised.com> [mailto:andrea.aime@anonymised.com] On Behalf Of Andrea Aime
Sent: Saturday, January 9, 2016 1:07 AM
To: Douville, Michelle R GCPE:EX
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net>
Subject: Re: [Geoserver-users] KML Placemarks not located correct (Geoserver 2.8.1)
On Sat, Jan 9, 2016 at 1:50 AM, Douville, Michelle R GCPE:EX <Michelle.Douville@anonymised.com<mailto:Michelle.Douville@anonymised.com>> wrote:
Hi All,
I have an issue with the KML Reflector in Geoserver 2.8.1.
Is there any way to get the KML Placemarks to work properly in this instance…
The data is SDE 10.2.2 in Oracle 12c, EPSG:3005….
The raster output displays properly (zoom in as there is scale dependency) and the placemarks are returned but they are not located properly.
Can you be more specific about the location error? How big is it, does it look like a translation?
With a datum change in the middle, from NAD83 to WGS84 (used by Google Earth), some offset is to be expected, althought
normally between those two is really small.
According to epsg.io<http://epsg.io> the best transformation accuracy would be 4m:
http://epsg.io/3005
If you have some sample points to test, one can check the transformation made by GeoServer, using
the transformation console (in the demo section) with the proj4 one.
E.g., I've tried a random coordinate in the valid range of EPSG:3005 (according to the epsg.io<http://epsg.io> page),
first using cs2cs (based on libproj4, e.g., the same used by QGis):
cs2cs +init=epsg:3005 +to +init=epsg:4326 -f %2f
1000000 2000000
-126.000000 62.994224 0.000000
and then the same coordinates with the GeoServer reprojection console, which returns:
-126.0 62.99422426150637
Seems to me there is a very good match with the two tools, does not look like there is a bug here.
Sometimes a large offset is due to the data being advertised in one CRS, but actually stored in another.
Cheers
Andrea
--
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
Geosolutions' Winter Holidays from 24/12 to 6/1
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313<tel:%2B39%200584%20962313>
fax: +39 0584 1660272<tel:%2B39%200584%201660272>
mob: +39 339 8844549<tel:%2B39%20%C2%A0339%208844549>
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.
-------------------------------------------------------
--
GeoServer Professional Services from the experts! Visit
http://goo.gl/it488V for more information.
Geosolutions' Winter Holidays from 24/12 to 6/1
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
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc.
-------------------------------------------------------