Spatial Analytics Made Easy: Oracle Spatial Studio (2023)

Let's say we need to understand where our company needs to open a new shop. Most of the time the decision is driven by gut feeling and some knowledge of the market and client base, but what if we could have visual insights about where are the high density zones with customers not covered by a shop nearby like in the map below?

Spatial Analytics Made Easy: Oracle Spatial Studio (1)

Well... welcome Oracle Spatial Studio!

Spatial Studio is Oracle's new tool for creating spatial analytics with a visual GUI. It uses Oracle Spatial database functions in the backend exposed with an interface in line with the Oracle Analytics Cloud one. Let's see how it works!

QuickStart Installation

First of all we need to download Spatial Studio from the Oracle web page, for this initial test I downloaded the "Quick Start", a self contained version pre-deployed in a lightweight application server. For more robust applications you may want to download the EAR file deployable in Weblogic.

Spatial Analytics Made Easy: Oracle Spatial Studio (2)

Once downloaded and unzipped the file, we just need to verify we have a Java JDK 8 (update 181 or higher) under the hood and we can immediately start Oracle Spatial Studio with the ./ command.

The command will start the service on the local machine that can be accessed at https://localhost:4040/spatialstudio. By default Oracle Spatial Studio Quickstart uses HTTPS protocol with self-signed certificates, thus the first time you access the URL you will need to add a security exception in your browser. The configurations such as port, JVM parameters, host and HTTP/HTTPS protocol can be changed in the conf/server.json file.

We can then login with the default credentials admin/welcome1

Spatial Analytics Made Easy: Oracle Spatial Studio (3)

The first step in the Spatial Studio setup is the definition of the metadata connection type. This needs to point to an Oracle database with the spatial option. For my example I initially used an Oracle Autonomous Data Warehouse, for which I had to drop the wallet and specify the schema details.

Spatial Analytics Made Easy: Oracle Spatial Studio (4)

Once logged in, the layout and working flows are very similar to Oracle Analytics Cloud making the transition between the two very easy (more details on this later on). In the left menu we can access, like in OAC, Projects (visualizations), Data, Jobs and the Console.

Spatial Analytics Made Easy: Oracle Spatial Studio (5)

In order to do Spatial Analysis we need to start from a Dataset, this can be existing tables or views, or we can upload local files. To create a Dataset, click on Create and Dataset

Spatial Analytics Made Easy: Oracle Spatial Studio (6)

We have then three options:

  • Upload a Spreadsheet containing spatial information (e.g. Addresses, Postcodes, Regions, Cities etc)
  • Upload a Shapefile containing geometric locations and associated attributes.
  • Use spatial data from one of the existing connections, this can point to any connection containing spatial information (e.g. a table in a database containing customer addresses)
Spatial Analytics Made Easy: Oracle Spatial Studio (7)

Sample Dataset with Mockaroo

I used Mockaroo, a realistic data generator service, to create two excel files: one containing customers with related locations and a second one with shops and related latitude and longitude. All I had to do was to select which fields I wanted to include in my file and the related datatype.

Spatial Analytics Made Easy: Oracle Spatial Studio (8)

For example, the list of shop dataset contained the following columns:

  • Id: as row number
  • Shop Name: as concatenation of Shop and the Id
  • Lat: Latitude
  • Long: Longitude
  • Dept: the Department (e.g. Grocery, Books, Health&Beauty)

Mockaroo offers a perfect service and has a free tier of datasets with less than 1000 rows which can be useful for demo purposes. For each column defined, you can select between a good variety of column types. You can also define your own type using regular expressions!

Spatial Analytics Made Easy: Oracle Spatial Studio (9)

Adding the Datasets to Oracle Spatial Studio

Once we have the two datasources in Excel format, it's time to start playing with Spatial Studio. We first need to upload the datasets, we can do it via Create and Dataset. Starting with the Customer.xlsx one. Once selected the file to upload Spatial Studio provides (as OAC) an overview of the dataset together with options to change configurations like dataset name, target destination (metadata database) and column names.

Spatial Analytics Made Easy: Oracle Spatial Studio (10)

Once modified the table name to TEST_CUSTOMERS and clicked on Submit Spatial Studio starts inserting all the rows into the SPATIAL_STUDIO connection with a routine that could take seconds or minutes depending on the dataset volume. When the upload routine finishes I can see the TEST_CUSTOMERS table appearing in the list of datasets.

Spatial Analytics Made Easy: Oracle Spatial Studio (11)

We can immediately see the yellow warning sign next to the dataset name, it's due to the fact that we have a dataset with no geo-coded information, we can solve this problem by clicking on the option button and then Prepare and Geocode Addresses

Spatial Analytics Made Easy: Oracle Spatial Studio (12)

Oracle Spatial Studio will suggest, based on the column content, some geo-type matching e.g. City Name, Country and Postal Code. We can use the defaults or modify them if we feel they are wrong.

Spatial Analytics Made Easy: Oracle Spatial Studio (13)

Once clicked on Apply the geocoding job starts.

Spatial Analytics Made Easy: Oracle Spatial Studio (14)

Once the job ends, we can see the location icon next to our dataset name

Spatial Analytics Made Easy: Oracle Spatial Studio (15)

We can do the same for the Shops.xlsx dataset, starting by uploading it and store it as TEST_SHOPS dataset.

Spatial Analytics Made Easy: Oracle Spatial Studio (16)

Once the dataset is uploaded I can geo-locate the information based on the Latitude and Longitude, I can click on the option button and the selecting Prepare and Create Lon/Lat Index. Then I'll need to assign the Longitude and Latitude column correctly and click on Ok.

Spatial Analytics Made Easy: Oracle Spatial Studio (17)

Spatial Analytics

Now it's time to do some Spatial Analysis so I can click on Create and Project and I'll face an empty canvas by default

Spatial Analytics Made Easy: Oracle Spatial Studio (18)

The first step is to add a Map, I can do that by selecting the visualizations menu and then dragging the map to the canvas.

Spatial Analytics Made Easy: Oracle Spatial Studio (19)

Next step is to add some data by clicking on Data Elements and then Add Dataset

Spatial Analytics Made Easy: Oracle Spatial Studio (20)

I select the TEST_CUSTOMERS dataset and add it to the project, then I need to drag it on top of the map to visualize my customer data.

Spatial Analytics Made Easy: Oracle Spatial Studio (21)

Oracle Spatial Studio Offers several options to change the data visualizations like color, opacity, blur etc.

Spatial Analytics Made Easy: Oracle Spatial Studio (22)

Now I can add the TEST_SHOPS dataset and visualize it on the map with the same set of steps followed before.

Spatial Analytics Made Easy: Oracle Spatial Studio (23)

It's finally time for spatial analysis! Let's say, as per initial example, that I want to know which of my customers doesn't have any shops in the nearest 200km. In order to achieve that I need to first create buffer areas of 200km around the shops, by selecting the TEST_SHOPS datasource and then clicking on the Spatial Analysis.

Spatial Analytics Made Easy: Oracle Spatial Studio (24)

This will open a popup window listing a good number of spatial analysis, by clicking on the Transform tab I can see the Add a buffer of a specified distance option.

Spatial Analytics Made Easy: Oracle Spatial Studio (25)

Unfortunately the buffer function is not available in ADW at the moment.

Spatial Analytics Made Easy: Oracle Spatial Studio (26)

I had to rely on an Oracle Database Cloud Service 18c Enterprise Edition - High Performance (which includes the Spatial option) to continue for my metadata storage and processing. Few Takeaways:

  • Select 18c (or anything above 12.2): I hit an issue ORA-00972: identifier is too long when importing the data in a 12.1 Database, which (thanks StackOverflow) is fixed as of 12.2.
  • High Performance: This includes the Spatial Option

Once I used the DBCS as metadata store, I can finally use the buffer function and set the parameter of 200km around the shops.

Spatial Analytics Made Easy: Oracle Spatial Studio (27)

The TEST_SHOPS_BUFFER is now visible under Analysis and can be added on top of the Map correctly showing the 200km buffer zone.

Spatial Analytics Made Easy: Oracle Spatial Studio (28)

I can understand which customers have a shop in the nearest 200k by creating an analysis and select the option "Return shapes within a specified distance of another"

Spatial Analytics Made Easy: Oracle Spatial Studio (29)

In the parameters I can select the TEST_CUSTOMERS as Layer to be filtered, the TEST_SHOPS as the Layer to be used as filter and the 200Km as distance.

Spatial Analytics Made Easy: Oracle Spatial Studio (30)

I can then visualize the result by adding the TEST_CUSTOMERS_WITHIN_DISTANCE layer in the map.

Spatial Analytics Made Easy: Oracle Spatial Studio (31)

TEST_CUSTOMERS_WITHIN_DISTANCE contains the customers already "covered" by a shop in the 200km range, what I may want to do now is remove them from my list of customers in order to do analysis on the remaining ones, how can I do that? Unfortunately in the first Spatial Studio version there is no visual way of doing DATASET_A MINUS DATASET_B but, hey, it's just the first incarnation and we can expect that type of functions and many others to be available in future releases!

The following paragraph is an in-depth analysis in the database of functions that will probably be exposed in Spatial Studio's future version, so if not interested, progress directly to the section named "Progressing in the Spatial Analysis".

A Look in the Database

Since we want to achieve our goal of getting the customers not covered by a shop now, we need to look a bit deeper where the data is stored: in the database. This gives us two opportunities: check how Spatial Studio works under the covers and freely use SQL to achieve our goals (DATASET_A MINUS DATASET_B).

First let's have a look at the tables created by Spatial Studio: we can see some metadata tables used by studio as well as the database representation of our two excel files TEST_CUSTOMERS and TEST_SHOPS.

Spatial Analytics Made Easy: Oracle Spatial Studio (32)

Looking in depth at the metadata we can also see a table named SGTECH$TABLE followed by an ID. That table collects the information regarding the geo-coding job we executed against our customers dataset which were located starting from zip-codes and addresses. We can associate the table to the TEST_CUSTOMERS dataset with the following query against the SGTECH_OBJECTS metadata table.

Spatial Analytics Made Easy: Oracle Spatial Studio (33)

The SGTECH$TABLEA004AA549110B928755FC05F01A3EF89 table contains, as expected, a row for each customer in the dataset, together with the related geometry if the geo-coding was successful and some metadata flags like GC_ATTEMPTED, GC_STATUS and GC_MATCH_CODE stating the accuracy of the geo-coding match.

Spatial Analytics Made Easy: Oracle Spatial Studio (34)

What about all the analysis like the buffer and the customers within distance? For each analysis Spatial Studio creates a separate view with the SGTECH$VIEW prefix followed by an ID.

Spatial Analytics Made Easy: Oracle Spatial Studio (35)

To understand which view is referring to which analysis we need to query the metadata table SGTECH_OBJECTS with a query like


With the following result

Spatial Analytics Made Easy: Oracle Spatial Studio (36)

We know then that the TEST_CUSTOMERS_WITHIN_DISTANCE can be accessed by the view SGTECH$VIEW0B2B36785A28843F74B58B3CCF1C51E3 and when checking its SQL we can clearly see that it executes the SDO_WITHIN_DISTANCE function using the TEST_CUSTOMERS.GC_GEOMETRY, the TEST_SHOPS columns LONGITUDE and LATITUDE and the distance=200 unit=KILOMETER parameters we set in the front-end.

CREATE OR replace force editionable view "SPATIAL_STUDIO"."SGTECH$VIEW0B2B36785A28843F74B58B3CCF1C51E3"SELECT ...FROM "TEST_CUSTOMERS" "t1", "TEST_SHOPS" "t2"WHERE sdo_within_distance("t1"."GC_GEOMETRY", spatial_studio.sgtech_ptf("t2"."LONGITUDE", "t2"."LATITUDE"), 'distance=200 unit=KILOMETER' ) = 'TRUE';

Ok, we now understood which view contains the data, thus we can create a new view containing only the customers which are not within the 200km distance with

CREATE VIEW TEST_CUSTOMERS_NOT_WITHIN_DISTANCE ASSELECT AS id, t1.first_name AS first_name, t1.last_name AS last_name, AS email, t1.gender AS gender, t1.postal_code AS postal_code, t1.street AS street, AS COUNTRY, AS city, t1.studio_id AS studio_id, t1.gc_geometry AS gc_geometryFROM test_customers t1WHERE id NOT IN ( SELECT id FROM spatial_studio.sgtech$view0b2b36785a28843f74b58b3ccf1c51e3 );

Progressing in the Spatial Analysis

In the previous paragraph we created a view in the database named TEST_CUSTOMERS_NOT_WITHIN_DISTANCE containing the customer without a shop in a 200km radius. We can now import it into Spatial Studio by creating a new dataset, selecting the connection to the database (in our case named SPATIAL_STUDIO) as source and then the newly created TEST_CUSTOMERS_NOT_WITHIN_DISTANCE view.

Spatial Analytics Made Easy: Oracle Spatial Studio (37)

The dataset is added, but it has a yellow warning icon next to it

Spatial Analytics Made Easy: Oracle Spatial Studio (38)

Spatial Studio requests us to define a primary key, we can do that by accessing the properties of the dataset, select the Columns tab, choosing which column acts as primary key and validate it. After this step I can visualize this customer in a map.

Spatial Analytics Made Easy: Oracle Spatial Studio (39)

What's next? Well If I want to open a new shop, I may want to do that where there is a concentration of customers, which is easily visualizable with Spatial Studio by changing the Render Style to Heatmap.

Spatial Analytics Made Easy: Oracle Spatial Studio (40)

With the following output

Spatial Analytics Made Easy: Oracle Spatial Studio (41)

We can clearly see some major concentrations around Dallas, Washington and Minneapolis. Focusing more on Dallas, Spatial Studio also offers the option to simulate a new shop in the map and calculate the 200km buffer around it. I can clearly see that adding a shop halfway between Oklahoma City and Dallas would allow me to cover both clients within the 200km radius.

Spatial Analytics Made Easy: Oracle Spatial Studio (42)

Please remember that this is a purely demonstrative analysis, and some of the choices, like the 200km buffer are expressly simplistic. Other factors could come into play when choosing a shop location like the revenue generated by some customers. And here it comes the second beauty of Oracle Spatial Studio, we can export datasets as GeoJSON or CSV and include them in Data Visualization.

Spatial Analytics Made Easy: Oracle Spatial Studio (43)

For example I can export the data of TEST_CUSTOMERS_NOT_WITHIN_DISTANCE from Spatial Studio and include then in a Data Visualization Project blending them with the Sales related to the same customers.

Spatial Analytics Made Easy: Oracle Spatial Studio (44)

I can now focus not only on the customer's position but also on other metrics like Profit or Sales Amount that I may have in other datasets. For another example of Oracle Spatial Studio and Data Visualization interoperability check out this video from Oracle Analytics Senior Director Philippe Lions.


Spatial analytics made easy: this is the focus of Oracle Spatial Studio. Before spatial queries were locked down at database level with limited access from an analyst point of view. Now we have a visual tool with a simple GUI (in line with OAC) that easily enables spatial queries for everybody!

But this is only the first part of the story: the combination of capabilities achievable when mixing Oracle Spatial Studio and Oracle Analytics Cloud takes any type of analytics to the next level!


Which three options can developers use to access spatial features? ›

Spatial Data Option supports three geometric primitive types and geometries composed of collections of these types. The three primitive types are: 2-D Point and Point Cluster. 2-D Line Strings.

Is Oracle Spatial Studio free? ›

Spatial Studio is a free web-based tool for use with Oracle Autonomous Database, Oracle Database Cloud Service, and Oracle Database on premises.

What is Oracle Spatial used for? ›

Use Oracle Spatial Studio, a self-service application, to create interactive maps and perform spatial analysis on business data quickly and easily. Users can visualize, explore, and analyze geospatial data stored in and managed by Oracle in the cloud or on-premises.

What are the spatial capabilities of Oracle? ›

Spatial Features

Oracle Database includes advanced spatial analysis and processing. It supports all major spatial data types and models, addressing business-critical requirements from many industries, including transportation, utilities, energy, public sector, defense and commercial location intelligence.

What are the 3 components of spatial data? ›

1.4 Data Model. The Spatial data model is a hierarchical structure consisting of elements, geometries, and layers, which correspond to representations of spatial data.

What are the three 3 components of spatial data define? ›

There are three main types of vector data: points, lines and polygons. The points help create lines, and the connecting lines form enclosed areas or polygons.

What is the difference between Oracle spatial and locator? ›

Oracle Locator is a subset of Oracle Spatial, which is included in Oracle Database Enterprise Edition, and which adds high-end spatial functionality, including functions such as buffer generation, spatial aggregates, area calculations, and more; linear referencing; coordinate systems transformations; geocoding; a ...

What are the most common tools we use for spatial organization? ›

In this section, a range of tools associated with the collection and distribution of spatial data are presented as well as recommendations for further reading.
  • Geographic Information Systems (GIS) ...
  • Surveying. ...
  • Remote Sensing. ...
  • Maps. ...
  • Cartography. ...
  • Geovisualization. ...
  • Digital Globes. ...
  • Volunteered Geographic Information (VGI)

What are the types of Oracle spatial? ›

  • Coordinate System (Spatial Reference System)
  • Cartesian Coordinates.
  • Geodetic Coordinates (Geographic Coordinates)
  • Projected Coordinates.
  • Local Coordinates.
  • Geodetic Datum.
  • Transformation.

What are the three types of spatial objects? ›

These data types are usually called spatial data types, such as point, line, and region but also include more complex types like partitions and graphs (networks).

What are the three 3 major components of Oracle Database? ›

An Oracle instance consists of three main parts: System Global Area (SGA), Program Global Area (PGA), and background processes.

What are the list of spatial abilities? ›

There are four common types of spatial abilities which include spatial or visuo-spatial perception, spatial visualization, mental folding and mental rotation. Each of these abilities have unique properties and importance to many types of tasks whether in certain jobs or everyday life.

What is an example of a spatial database? ›

Example. A road map is a visualization of geographic information. A road map is a 2-dimensional object which contains points, lines, and polygons that can represent cities, roads, and political boundaries such as states or provinces. Rastor data: This data is represented as a matrix of square cells.

What are the types of spatial data? ›

Spatial data are of two types according to the storing technique, namely, raster data and vector data.

Can I practice Oracle Database for free? ›

It offers a full-featured experience and is packaged for ease of use and simple download—for free. Whether you are a developer, a data scientist, a DBA, an educator, or just interested in databases, Oracle Database 23c Free—Developer Release is the ideal way to get started.

What are the 5 types of spatial analysis? ›

Six types of spatial analysis are queries and reasoning, measurements, transformations, descriptive summaries, optimization, and hypothesis testing.

What are the two main types of spatial data? ›

The two primary spatial data types are Geometric and Geographic data. Geographic data is data that can be mapped to a sphere (the sphere in question is usually planet earth). Geographic data typically refers to longitude and latitude related to the location of an object on earth.

What is an example of a spatial analysis? ›

Examples of spatial analysis include measuring distances and shapes, setting routes and tracking transportations, establishing correlations between objects, events, and places via referring their locations to geographical positions (both live and historical).

What are 4 key data standard components for spatial data? ›

The elements include an overview describing the purpose and usage, as well as specific quality elements reporting on the lineage, positional accuracy, attribute accuracy, logical consistency and completeness.

What are the three basic patterns of spatial distribution? ›

Types of dispersion patterns include random, uniform, and clumped, and there are two main methods used to identify each of the dispersion patterns.

What is the difference between spatial database and geodatabase? ›

Note: the terms “geodatabase”, “spatial database”, and “database” are used interchangeably. The preferred format for storing data in the ArcGIS environment is the File Geodatabase. Another format, the Personal Geodatabase, is obsolete. non-spatial tables.

What is spatial data in Oracle? ›

Oracle's spatial database is included in Oracle's converged database, allowing developers and analysts to get started easily with location intelligence analytics and mapping services. It enables Geographic Information System (GIS) professionals to successfully deploy advanced geospatial applications.

What is Oracle spatial component? ›

Oracle Spatial is an integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly and efficiently in an Oracle9i database.

What are 3 examples of GIS? ›

GIS Applications Examples:
  • Mapping.
  • Network Services.
  • Accident Analysis and Hot Spot Analysis.
  • Urban Planning.
  • Transportation Planning.
  • Environmental Impact Analysis.
  • Agricultural Planning.
  • Disaster Management and Mitigation.
Feb 16, 2023

What is a spatial analysis also called? ›

Spatial analysis is often referred to as modeling.

What are the 3 tools used to collect geographic data? ›

GIS data collection hardware can be broken into three basic categories: digitizers, GPS units, and mobile devices. With a broad range of capabilities and price points, each type of device has it's own ideal use case.

What are 4 types of spatial patterns? ›

Types of spatial patterns represented on maps include absolute and relative distance and direction, clustering, dispersal, and elevation.

What are the six categories in an Oracle application? ›

It makes the following enterprise applications available as part of Oracle eBusiness Suite:
  • Asset Lifecycle Management.
  • Customer Relationship Management (CRM)
  • Enterprise Resource Planning (ERP)
  • Human Capital Management (HCM)
  • Procurement.
  • Product Life-cycle Management.
  • Supply Chain Management.
  • Manufacturing.

What are the 3 types of Oracle cloud? ›

There are three types of clouds: public, private, and hybrid. Each type requires a different level of management from the customer and provides a different level of security.

What are the major components of spatial data? ›

The options for the question – Key components of 'spatial data' quality include
  • Positional accuracy.
  • Temporal accuracy.
  • Lineage and completeness.
  • Logical consistency.
  • All of the above.
Apr 29, 2022

Which is the smallest unit of storage in an Oracle database? ›

Oracle data blocks are the smallest units of storage that Oracle can use or allocate.

What is the basic architecture of Oracle database? ›

An Oracle Real Application Clusters (Oracle RAC) database architecture consists of multiple instances that run on separate server machines. All of them share the same database. The cluster of server machines appear as a single server on one end, and end users and applications on the other end.

What are the 2 important components of Oracle responsibility? ›

When you define a responsibility, you assign to it some or all of the components described below:
  • Data Group (required) A Data Group defines the mapping between Oracle Applications products and ORACLE IDs. ...
  • Request Security Group (optional) ...
  • Menu (required) ...
  • Function and Menu Exclusions (optional) ...
  • See Also.

What are the 4 spatial properties? ›

Spatial properties include location, size, distance, direction, separation and connection, shape, pattern, and movement.

How do I learn spatial ability? ›

Try out these suggestions below:
  1. Pick up a new hobby. Some hobbies help promote spatial awareness, such as photography and drawing.
  2. Try video games. Focus on games where you manipulate and move objects. ...
  3. Take time to play. ...
  4. Stay active.
Apr 21, 2020

What are the 10 core concepts of spatial information? ›

The concepts include location, neighborhood, field, object, network, event, granularity, accuracy, meaning, and value.

What are the 3 types of spatial patterns? ›

clustering, dispersal, and elevation.

What are the 3 types of spatial objects in GIS? ›

The spatial information and the attribute information for these models are linked via a simple identification number that is given to each feature in a map. Three fundamental vector types exist in geographic information systems (GISs): points, lines, and polygons (Figure 4.8 "Points, Lines, and Polygons").

What are the 3 properties of a feature class spatial reference? ›

The properties of a spatial reference
  • Coordinate system.
  • Resolution.
  • Tolerance.

What are the names of the 3 types of spatial objects in GIS? ›

The three types of GIS Data are -spatial, –attribute, & —metadata
  • Point Data — layers containing by points (or “events”) described by x,y (lat,long; easting, northing)
  • Line/Polyline Data — layers that are described by x,y points (nodes, events) and lines (arcs) between points (line segments and polylines)

What are the six categories of spatial analysis? ›

Six types of spatial analysis are queries and reasoning, measurements, transformations, descriptive summaries, optimization, and hypothesis testing.

What are the 4 basic types of spatial relationships? ›

Spatial Relationships Types. Adjacency, contiguity, overlap, and proximity are the four ways of describing the relationship between two or more entities.

What are the basic types of spatial data models? ›

There are two broad categories of spatial data models. These are vector data model and raster data models.

What are the key features of spatial data? ›

Important characteristics of spatial data are its measurement level, map scale and associated topological information. Nominal, ordinal, interval and ratio are the four levels of measurement for populating the spatial data matrix; they hold different amounts of information and determine what analysis can be performed.

What is spatial data types in SQL? ›

Spatial data represents information about the physical location and shape of geometric objects. These objects can be point locations or more complex objects such as countries/regions, roads, or lakes. SQL Server supports two spatial data types: the geometry data type and the geography data type.


Top Articles
Latest Posts
Article information

Author: Gov. Deandrea McKenzie

Last Updated: 02/07/2023

Views: 5931

Rating: 4.6 / 5 (66 voted)

Reviews: 81% of readers found this page helpful

Author information

Name: Gov. Deandrea McKenzie

Birthday: 2001-01-17

Address: Suite 769 2454 Marsha Coves, Debbieton, MS 95002

Phone: +813077629322

Job: Real-Estate Executive

Hobby: Archery, Metal detecting, Kitesurfing, Genealogy, Kitesurfing, Calligraphy, Roller skating

Introduction: My name is Gov. Deandrea McKenzie, I am a spotless, clean, glamorous, sparkling, adventurous, nice, brainy person who loves writing and wants to share my knowledge and understanding with you.