Hi Andrea
I have created this https://osgeo-org.atlassian.net/browse/GEOS-7369
And have switch to a ORACLE NG driver for the same data (skipping SDE
registration) .
And I looks to be the same issue for the KML output for that.
Interesting to note, that I could not compute bounds (native or latlong) unless
I explicitly set the schema.
For this test, when I explicity set the schema in the datastore, I was able to
compute the bounds no problem.
(if I switch to Oracle drivers I am hoping to leave schema blank).
Oracle driver KML Placemark test failed, request and response (switched from
SDE driver for same SDO data):
GET
http://delivery.openmaps.gov.bc.ca/geo/test/wms?service=wms&request=GetMap&version=1.1.1&format=application/vnd.google-earth.kml+xml&layers=test:WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG&styles=polygon&height=2048&width=2048&transparent=false&srs=EPSG:4326&format_options=AUTOFIT:true;KMATTR:true;KMPLACEMARK:true;KMSCORE:0;MODE:refresh;SUPEROVERLAY:false&BBOX=168.5532288763974,31.7126716688352,291.2419605711542,68.12584606065629
HTTP/1.1
Host: delivery.openmaps.gov.bc.ca
Connection: keep-alive
Accept: application/vnd.google-earth.kml+xml, application/vnd.google-earth.kmz,
image/*, */*
User-Agent: GoogleEarth/7.1.5.1557(Windows;Microsoft Windows
(6.1.7601.1);en;kml:2.2;client:Free;type:default)
Accept-Encoding: gzip,deflate
Accept-Language: en-us,en,*
Accept-Charset: iso-8859-1,*,utf-8
Cookie: GS_FLOW_CONTROL="GS_CFLOW_f110b0:152296ae8b9:-7ff6"
HTTP/1.1 200 OK
Date: Sun, 10 Jan 2016 03:28:11 GMT
Server: Apache-Coyote/1.1
X-Control-flow-delay-ms: 0
Content-Disposition: attachment;
filename=test-WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG.kml
Content-Type: application/vnd.google-earth.kml+xml
Set-Cookie: GS_FLOW_CONTROL="GS_CFLOW_f110b0:152296ae8b9:-7ff6"; Version=1
Access-Control-Allow-Methods: OPTIONS,GET,POST
Access-Control-Allow-Headers: X-Requested-With, Referer, Origin, Content-Type
Keep-Alive: timeout=5, max=100
Connection: Keep-Alive
Content-Length: 78644
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<kml xmlns="http://www.opengis.net/kml/2.2";
xmlns:ns2="http://www.google.com/kml/ext/2.2";
xmlns:ns3="http://www.w3.org/2005/Atom";
xmlns:ns4="urn:oasis:names:tc:ciq:xsdschema:xAL:2.0">
<Document>
<LookAt>
<longitude>-165.6761067729959</longitude>
<latitude>63.61249441022324</latitude>
<altitude>9217374.662677778</altitude>
<heading>0.0</heading>
<tilt>0.0</tilt>
<range>7448122.1941406075</range>
<altitudeMode>clampToGround</altitudeMode>
</LookAt>
<Folder>
<name>test:WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG</name>
<LookAt>
<longitude>-114.80358157237526</longitude>
<latitude>45.40233389539659</latitude>
<altitude>1.0372488476100594E7</altitude>
<heading>0.0</heading>
<tilt>0.0</tilt>
<range>8381514.74303516</range>
<altitudeMode>clampToGround</altitudeMode>
</LookAt>
<GroundOverlay>
<name>test:WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG</name>
<drawOrder>0</drawOrder>
<Icon>
<href>http://delivery.openmaps.gov.bc.ca/geo/test/wms?service=wms&request=GetMap&version=1.1.1&format=image%2Fpng&layers=test%3AWHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG&styles=polygon&height=608&width=2048&transparent=true&bbox=168.5532288763974%2C31.7126716688352%2C291.2419605711542%2C68.12584606065629&srs=EPSG%3A4326&format_options=AUTOFIT%3Atrue%3BKMATTR%3Atrue%3BKMPLACEMARK%3Atrue%3BKMSCORE%3A0%3BMODE%3Arefresh%3BSUPEROVERLAY%3Afalse</href>
<refreshInterval>0.0</refreshInterval>
<viewRefreshMode>never</viewRefreshMode>
<viewRefreshTime>0.0</viewRefreshTime>
<viewBoundScale>0.75</viewBoundScale>
</Icon>
<altitude>0.0</altitude>
<LatLonBox>
<north>68.12584606065629</north>
<south>31.7126716688352</south>
<east>168.5532288763974</east>
<west>291.2419605711542</west>
<rotation>0.0</rotation>
</LatLonBox>
</GroundOverlay>
<Placemark id="WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG.North
Island - Central Coast Natural Resource District">
<name>WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG.North Island -
Central Coast Natural Resource District</name>
<description><h4>WHSE_ADMIN_BOUNDARIES.ADM_NR_DISTRICTS_SPG</h4>
<ul class="textattributes">
<li><strong><span
class="atr-name">ORG_UNIT</span>:</strong> <span
class="atr-value">DNI</span></li>
<li><strong><span
class="atr-name">ORG_UNIT_NAME</span>:</strong>
<span class="atr-value">North Island - Central Coast Natural
Resource District</span></li>
<li><strong><span
class="atr-name">REGION_ORG_UNIT</span>:</strong>
<span class="atr-value">RWC</span></li>
<li><strong><span
class="atr-name">REGION_ORG_UNIT_NAME</span>:</strong>
<span class="atr-value">West Coast Natural Resource
Region</span></li>
<li><strong><span
class="atr-name">FEATURE_CODE</span>:</strong>
<span class="atr-value">FM90000020</span></li>
<li><strong><span
class="atr-name">FEATURE_NAME</span>:</strong>
<span class="atr-value">Natural Resource
District</span></li>
<li><strong><span
class="atr-name">OBJECTID</span>:</strong> <span
class="atr-value">1</span></li>
<li><strong><span
class="atr-name">FEATURE_AREA_SQM</span>:</strong>
<span class="atr-value">74999697249.8015</span></li>
<li><strong><span
class="atr-name">FEATURE_LENGTH_M</span>:</strong>
<span class="atr-value">1933321.1904</span></li>
</ul>
</description>
<LookAt>
<longitude>84.97408885837622</longitude>
<latitude>68.87518962642825</latitude>
<altitude>0.0</altitude>
<heading>0.0</heading>
<tilt>0.0</tilt>
<range>0.0</range>
<altitudeMode>clampToGround</altitudeMode>
</LookAt>
<Style>
<LabelStyle>
<color>00ffffff</color>
<scale>0.0</scale>
</LabelStyle>
<LineStyle>
<color>ff000000</color>
<width>1.0</width>
</LineStyle>
<PolyStyle>
<color>ffaaaaaa</color>
<outline>1</outline>
</PolyStyle>
</Style>
<Point>
<coordinates>905124.9740888583,737348.8751896265</coordinates>
</Point>
</Placemark>
………………………….
</Folder>
</Document>
</kml>
From: [email protected] [mailto:[email protected]] On Behalf Of Andrea
Aime
Sent: Saturday, January 9, 2016 10:37 AM
To: Douville, Michelle R GCPE:EX
Cc: [email protected]
Subject: Re: [Geoserver-users] KML Placemarks not located correct (Geoserver
2.8.1)
On Sat, Jan 9, 2016 at 7:07 PM, Douville, Michelle R GCPE:EX
<[email protected]<mailto:[email protected]>> wrote:
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.
Yep, that's a good idea, I don't have a SDE instance to perform tests.
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
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.
-------------------------------------------------------
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
