Christopher Fricke bmoregeo

## arc2pgrouting
-- PG_Geometry Line feature class -> PG Routing

-- Add Required Fields
ALTER TABLE way ADD COLUMN "source" integer;
ALTER TABLE way ADD COLUMN "target" integer;

-- Build Topology (3D)
SELECT sde.pgr_createTopology3d('way', 0.01, 'shape', 'objectid')

-- Add Indices

## csv2shp.py
import arcpy
import os


def csv2shp(csv_file, field_x, field_y, shape_file):
    """
    Convert a CSV file with x/y fields into a Shapefile
    """
    table_view = 'csv_file_as_view'
    layer = 'xy_event_layer'

## geojson.json

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                bmoregeo
                / geojson.json
            
            
              Created
              April 10, 2015 15:15
            
          
      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
	-- PG_Geometry Line feature class -> PG Routing

	-- Add Required Fields
	ALTER TABLE way ADD COLUMN "source" integer;
	ALTER TABLE way ADD COLUMN "target" integer;

	-- Build Topology (3D)
	SELECT sde.pgr_createTopology3d('way', 0.01, 'shape', 'objectid')

	-- Add Indices
	import arcpy
	import os


	def csv2shp(csv_file, field_x, field_y, shape_file):
	"""
	Convert a CSV file with x/y fields into a Shapefile
	"""
	table_view = 'csv_file_as_view'
	layer = 'xy_event_layer'