Tableau_in_the_Face

--<?xml version="1.0" encoding="UTF-8"?>
--*********************************************
--   Generate KML File (for use in Tableau)
--*********************************************
select to_clob('<kml>') from dual
   union all
select to_clob('<Placemark>'||XMLFOREST(district, dist_name)||
       SDO_UTIL.TO_KMLGEOMETRY(SDO_CS.TRANSFORM(geometry, 8307))||
      '</Placemark>') from districts
   union all
select to_clob('<kml>') from dual;
desc districts

or lower case name and description attributes/elements (which tableau likes to import nicely)

--<?xml version="1.0" encoding="UTF-8"?>
--*********************************************
--   Generate KML File (for use in Tableau)
--*********************************************
select to_clob('<kml>') from dual
   union all
select to_clob('<Placemark>,<name>'||DISTRICT||'</name><description>'||DIST_NAME||'</description>'||
       SDO_UTIL.TO_KMLGEOMETRY(SDO_CS.TRANSFORM(geometry, 8307))||'</Placemark>') from districts
   union all
select to_clob('<kml>') from dual;
desc districts


Comments

Popular Posts