Spatially Enable Flat SQL Table Using ESRI ArcGIS 9.1 & ArcSDE 8.3

Posted on 2006-05-30
Medium Priority
Last Modified: 2012-06-27
We have loaded some Irish data into a flat table in SQL 2000 and are looking to spatially enable it for use in ESRI ArcGIS 9.1 and ArcView 3.3.  We are using ArcSDE 8.3 on the SQL server.

Can ArcGIS 9.1 or ArcSDE 8.3 spatially enable flat SQL tables?
If so, can someone please outline the steps to do this?

We do not want to create ShapeFiles and reimport the data.


Simon Instone
Question by:sinstone
1 Comment

Accepted Solution

NinetyNEIN earned 2000 total points
ID: 16908512
The Data Interoperability extension for ArcGIS will allow you read the data in it's native format directly from MS SQLServer.  Depending on how the tabular data is structured, you might be able to use this to create geometry from the attributes.  This would be done by creating a Custom Format.  This allows you to connect to the data, and process it at the same time (in a similar mannor as you would connect to ArcSDE).  If you have this extension, let me know and I can give you futher directions.


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I feel like more and more people want to know how to programmatically convert addresses into geospatial locations. So in this article, I will show you how you can do it with Bing Maps. I'm going to use PowerShell, which is a nice scripting language,…
Introduction This article is designed to assist GIS (Geographic Information System) and GPS (Global Positioning System) developers using ESRI ArcGIS and other spatial information management systems.   For the uninitiated the concept of projectio…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question