Experiences with SAP HANA Geo Spatial Features Part 1. SAP HANA Geospatial processing feature was launched with SAP HANA SP6. As a developer I had no idea even what spatial processing meant but with the help of the content available over SCN and doing some hand on as a part of SAP Blue ProjectYou can see the full blog at HANA Cookbook for My. SQL Developers I have come up with a small demo of an application which highlights some of the geospatial features. The demo will look as shown below The blog will be divided into 2 parts where in I will try to highlight how the application was created from an end to end perspective. In Part 1current document I will explain some of the geospatial features available in SAP HANA and how we can write logic to store and access such data. I will also show what data was used in my application. OGC formats only support 2d geometries, and the associated SRID is neverembedded in the inputoutput representations. PostGIS extended formats are currently. I loved the speakers gift, as well This show was a lot of fun and I certainly hope to be invited back next year In the meantime, though, I am very excited to be. In PART 2 of this blog Experiences with SAP HANA Geo Spatial Features Part 2 I will show you details on how geospatial information can be access via XSJS as Geo. Json and how can we integrate Leaflet MAP client to display the data. So to start SAP HANA has brought in some new spatial data types like POINT STPOINT and Geometry STGEOMETRY to store spatial information. Not Found In Epsg Support Files' title='Not Found In Epsg Support Files' />A point is like a fixed single location in space and will be represented by X and Y co ordinates an also have a Z co ordinate in case of 3. D space. A Geometry is like a super class container and can store the below type within it. Below you can see how we can store and retrieve data from a Point or Geometry Type. So basically in a Geometry data type we can store any of the child types like Line, Polygon or Point. You can also see that we are querying the data as Geo. Json which is a special JSON format for encoding a variety of geometrical data structures and it is easily understood by most of the MAP client APIs. More information about Geo. Json can be found below here http geojson. SAP HANA also provides a list of other means to extract data from geometrical data structures apart from Geo. Json like Well Known Text WKT, Well Known Binary EKB etc. Overlay8.JPG' alt='Not Found In Epsg Support Files' title='Not Found In Epsg Support Files' />More information is available in the HANA SPATIAL reference found in the link below http help. Now coming to the application where in I am showing all the parliamentary constituencies of India ote The data regarding the parties ruling the constituencies might not be accurate as the data was collected was from 2. So first I had to collect the shape files for all the constituencies of INDIA. Finally after some amount of research here and there I finally got the data of the Indian parliamentary constituency. You can find the same in this link https drive. B3z. Snd. F4. Hyu. LVG4. 3NUJr. UHl. CLTQ uspsharing. The data was in ESRI shape file format http en. Theres a whole community to support you Open SWMM. Get answers, suggest improvements, share modifications and more with the Knowledge Base and Code Viewer. Shapefile and luckily SAP HANA supported the shape file import into it. So in order to load shape file into HANA you need to perform the 4 simple steps stated below Download Puttyhttp www. PSCPhttp www. Copy the shape filezip it first from your local machine into HANA using PSCPC lt path to PSCP directory pscp. OSUsername lt HANA server name lt destination folder You can login to you server using putty and unzip the files. You can import the shape files in HANA by running the below command        IMPORT SchemaName. TableName AS SHAPEFILE FROM path to shape file        Note Dont give the extension of the shape file in the path. AhjESooQTYiuVQxkbFKa_Screenshot%202016-03-24%2011.23.44.png' alt='Not Found In Epsg Support Files' title='Not Found In Epsg Support Files' />Just mention its name. So once I imported my shape files into HANA, the data looked like below So as you can see I had the list of all the constituencies along with the following information The state to which it belong, the ruling party, area and the color codesome of the fields were added laterThe shape information. I can also see the shape as Geo. SHPImport_Dialog.png' alt='Not Found In Epsg Support Files' title='Not Found In Epsg Support Files' />Json and the data looked like as shown below. So you can see that most of the shape are really complex and are created using polygons and multipolygons with a large number of points. In the next part of this blog, I will explain how we can expose the data out of HANA as a XSJS service and how we can visualize the data using LEAFLET. Please find the 2nd Part of the Blog in the following link Experiences with SAP HANA Geo Spatial Features Part 2. Descarga Gratis Microsoft Office Word Para Windows 7.