[GIS] How to turn a python list into a table

arcgis-desktoparcpylistpythontable

I am trying to create a table of coded values so each textual description has a numerical attribute. The order of numbers is not important – they just need to be unique.

What I have so far is a python list of all unique values, so all I need to do now is add this to a table and create numbers. Is there a method in arcpy that will allow me to save my list as a table with an objectID?

Best Answer

To do this you should use a combination of ArcPy and Python.

You can use Python's enumerate function to get a number for each item in your list.

You use arcpy.da.InsertCursor() to create and populate a new row for each item in the list.

Related Solutions

[GIS] Putting coded domains into list to be created in Python script

In the Add Coded Value To Domain documentation there are code examples that show you how to do this. It looks like you are trying to submit a list of coded values to a function that is designed to take a coded value at a time. I think you should change your code to iterate through your list instead.

Python will not like 01.6530.01 being treated as a number because it is not a number. To treat it as a string I think you will need to use the str function on each value you add to the list rather than trying to turn the list as a whole into a string.

[GIS] how to create table and layer in c#

Based on pecoanddeco's answer, here is the VBA code converted to C#.

Note that you'll need to create the XYSample.txt file and add it to your map as described here

Need to add the following ArcGIS References

ESRI.ArcGIS.ArcMapUI
ESRI.ArcGIS.CartoESRI
ESRI.ArcGIS.CartoUI
ESRI.ArcGIS.Display
ESRI.ArcGIS.Framework
ESRI.ArcGIS.Geodatabase
ESRI.ArcGIS.Geometry
ESRI.ArcGIS.LoctationUI

using ESRI.ArcGIS.ArcMapUI;
using ESRI.ArcGIS.Carto;
using ESRI.ArcGIS.Framework; 
using ESRI.ArcGIS.Geodatabase;
using ESRI.ArcGIS.esriSystem;
using ESRI.ArcGIS.Geometry;
using ESRI.ArcGIS.LocationUI;

    void AddXYEventLayer()
    {
        IMxDocument mxdoc = ArcMap.Application.Document as IMxDocument;
        IMap map = mxdoc.FocusMap;

        // Get the table named XYSample.txt
        IStandaloneTableCollection stTableCollection = map as IStandaloneTableCollection;
        IStandaloneTable standaloneTable = null;
        ITable table = null;

        for (int i = 0; i < stTableCollection.StandaloneTableCount; i++)
        {
            standaloneTable = stTableCollection.StandaloneTable[i];
            if (standaloneTable.Name == "XYSample.txt")
            {
                table = standaloneTable.Table;
                break;
            }
        }

        if (table == null)
        {
            MessageBox.Show("XYSample.txt table was not found in this map.");
            return;
        }

        // Get the table name object
        IDataset dataset = table as IDataset;
        IName tableName = dataset.FullName;

        // Specify the X and Y fields
        IXYEvent2FieldsProperties xyEvent2FieldsProperties = new XYEvent2FieldsProperties() as IXYEvent2FieldsProperties;
        xyEvent2FieldsProperties.XFieldName = "x";
        xyEvent2FieldsProperties.YFieldName = "y";
        xyEvent2FieldsProperties.ZFieldName = "";

        // Specify the projection
        ISpatialReferenceFactory spatialReferenceFactory = new SpatialReferenceEnvironment() as ISpatialReferenceFactory;
        IProjectedCoordinateSystem projectedCoordinateSystem = spatialReferenceFactory.CreateProjectedCoordinateSystem((int)esriSRProjCSType.esriSRProjCS_NAD1983UTM_11N);

        // Create the XY name object as set it's properties
        IXYEventSourceName xyEventSourceName = new XYEventSourceName() as IXYEventSourceName;
        xyEventSourceName.EventProperties = xyEvent2FieldsProperties;
        xyEventSourceName.SpatialReference = projectedCoordinateSystem;
        xyEventSourceName.EventTableName = tableName;

        IName xyName = xyEventSourceName as IName;
        IXYEventSource xyEventSource = xyName.Open() as IXYEventSource;

        // Create a new Map Layer
        IFeatureLayer featureLayer = new FeatureLayer() as IFeatureLayer;
        featureLayer.FeatureClass = xyEventSource as IFeatureClass;
        featureLayer.Name = "Sample XY Event Layer";

        // Add the layer extension (this is done so that when you edit
        // the layer's Source properties and click the Set Data Source
        // button, the Add XY Events Dialog appears)
        ILayerExtensions layerExtensions = featureLayer as ILayerExtensions;
        XYDataSourcePageExtension resPageExtension = new XYDataSourcePageExtension();
        layerExtensions.AddExtension(resPageExtension);

        map.AddLayer(featureLayer);
    }

Best Answer

Related Solutions

[GIS] Putting coded domains into list to be created in Python script

[GIS] how to create table and layer in c#

Related Question