Spatial Projects SQL (spatialSQL)
for MapInfo Professional®
spatialSQL provides solutions to both common and complex problems
facing GIS users, data developers and software developers. Summarised here
are a list of problems with a spatialSQL solution. This page is an extract from
the help file which has the detailed explanations for each point.
Data Structuring and Cleaning
I receive data from various sources and have an
in-house requirement for topology so that our various applications will provide
Structuring Data to Consistent
I have received a very large geocoded file of
addresses of inner-urban residents. There are many duplicates from
apartment buildings. Is there a simple method of normalising my location data
but maintaining a link to this data from my DBMS, so that I have a
point table suitable for display and analysis.
Removing Duplicate Points
I use street polyline direction in conjunction with
a one-way flag to identify one-way streets. Is there a method of setting the
direction of my segmented street data so I can then apply the one-way flag?
Setting polyline direction for one-way
Spatial Rules-Based Data Filtering in Real Estate
I have a a series of rules that
I use to assist customers in selecting properties for lease or purchase.
These rules comprise simple requirements (such as price range) as well as
spatial requirements. Customers also add their own. I would like to be able to
quickly produce a map of matching properties by tailoring and rerunning the
rules on my current listings. Is there a method of doing this?
Setting up spatialSQL Batch for Rules-Based Data Filtering.
Line Network Queries - Street Networks, Bus
Routes, Water Reticulation
How can I identify all the dead-end streets on my
Using the Free Ends operator to locate line Network End Points.
I have a network comprising a water pipe
layer and a layer of junctions, valves and other network point symbols.
How do I add the pipe ID of connecting pipes to my junctions layer.
Using a MapInfo Select and Update to Intersect and Identify A
point and Linear feature layer.
I have 2 layers, bus routes and bus stops. How do I
classify my bus stops by route and direction?
Direction Qualified Line Buffer Queries.
I have a street network layer and commercial bins as
an assets layer. I wish to assign a unique street segment id to my bins based
on proximity to the street segment. I cant use standard MapInfo buffers because
of the rounded ends and overlaps with adjacent segments.
Unique Street Segment Location Using Median
Local Government Cadastral Queries
I can use thematic maps or redistricting to identify
cadastral boundaries with say, common ownership. I would like to qualify this
by common ownership and sharing a common boundary. How do I do this? (I also
have similar queries related to zoning and other cadastral attributes that I
want to rerun as mybase data changes).
Using the combine update operator and adjacency to produce aggregate maps.
1. IE 5 not supported.
Copyrightę 1998-2008 Spatial
Projects Pty Ltd ACN 085 861 310
Names used throughout this site are trademarks of their respective companies.
Last modified: Mar24, 2008