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
--*********************************************
-- 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
Post a Comment