CHAPTER 5Loading, Transporting, and Validating Spatial Data

To run the examples in this chapter, you need to import a dataset as shown in the following spatial schema. Please refer to the introduction for instructions on creating the spatial schema and other setup details.

imp spatial/spatial FILE=app_with_loc.dmp FULL=Y INDEXES=N imp spatial/spatial FILE=city.dmp FULL=Y INDEXES=N

In the previous chapter, we introduced a new data type called SDO_GEOMETRY to store spatial data. This data type can store a variety of spatial objects: points (including those obtained by geocoding address strings), line strings, polygons, or more complex shapes. Points primarily represent the locations of application-specific entities such as businesses, customers, ...

Get Pro Oracle Spatial for Oracle Database 11g now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial