How to show parcel and buidling boundries in qlikview or qliksense

[rupalighaste]

Hi All,

How to show parcel and building boundaries in qlikview or qliksense. I've below fields in my Oracle database.

lat, lon of building with Number data type

BuidlingGeom, ParcelGeom  -    CLOB(data type)

ParcelXmin , ParcelXMax, ParcelYMin, ParcelYMax -   number(data type)

bldgeo, parcelgeo - msdsys.sdo_geometry (data type)

[Stoyan_Terziev]

Hi,

Unfortunately, there is no out-of-the-box solution for this.

You can achieve it with Qlik GeoAnalytics.

You can learn more about it here:

https://help.qlik.com/en-US/geoanalytics/Content/Qlik_GeoAnalytics/Home.htm

Kind regards,

S.T.

[rupalighaste]

Hi,

Thanks for sharing the link.  I'm going through the topics mentioned in link; unfortunately i'm unable to find the solution.  i'm able to show area/point on map using City name but not able to show parcel/building boundaries yet. I'm new to Qliksense and Geoanalytics. If you could provide some more insight or specific solution i would appreciate it. 

Thanks,

RG

[Patric_Nordstrom]

Qlik GeoAnalytics can read data from Oracle Spatial, if supplied in WKT. Specify a select statement, and retrieve the shape field as WKT and use the Qlik GeoAnalytics connector to load it.

Something like this: SELECT NAME, SDO_UTIL.TO_WKTGEOMETRY(GEOM) AS point FROM NEW_TEST;

Oracle - Converting SDO_GEOMETRY to WKT? - Stack Overflow

Note that Oracle outputs WKT in a varchar which is capped to 4000 chrs

https://help.qlik.com/en-US/geoanalytics/Subsystems/GeoConnector/Content/connector/connector-geoanal...

Thanks,
Patric

[rupalighaste]

Thanks for your detail solution on this. But we have decided to achieve this with some other application or software.