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

Posted on 2006-05-30
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
    LVL 1

    Accepted Solution

    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

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Suggested Solutions

    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…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now