geodatabase数据导入MongoDB
工具:arcpy,pymongo(MongoDB的python驱动)软件版本:arcpy(10.1),MongoDB(2.4 支持点线面)
导入脚本:
# -*- coding: cp936 -*-
import arcpy
import pymongo
from pymongo import MongoClient
def main():
client = MongoClient('localhost', 27017)
path="D:/mlxc.gdb/MLXC/"
arcpy.env.workspace=path
db = client['NodeDB']
handlePolyline(db)
handlePoint(db)
#polylineList 对线的转换
def handlePolyline(db):
fcList = arcpy.ListFeatureClasses(feature_type='Polyline')
for fc in fcList:
fieldList = arcpy.ListFields(fc)
fields =
fields.pop()
fields.append("SHAPE@")
lines=db
with arcpy.da.SearchCursor(fc, fields) as cursor:
print 'Handling '+fc
for row in cursor:
line={}
i=0
for value in row:
if(isinstance(value,arcpy.Polyline)):
loc={"type" : "LineString"}
coordinates=[]
for path in value:
for point in path:
coordinates.append()
loc['coordinates']=coordinates
line['line']=loc
else:
line]=value
i=i+1
lines.insert(line)
#pointList 对点的转换
def handlePoint(db):
fcList = arcpy.ListFeatureClasses(feature_type='Point')
for fc in fcList:
fieldList = arcpy.ListFields(fc)
fields =
fields.pop()
fields.append("SHAPE@")
points=db
with arcpy.da.SearchCursor(fc, fields) as cursor:
print 'Handling '+fc
for row in cursor:
pointfc={}
i=0
for value in row:
if(isinstance(value,arcpy.PointGeometry)):
loc={"type" : "Point"}
loc['coordinates']=
pointfc['point']=loc
else:
pointfc]=value
i=i+1
points.insert(pointfc)
if __name__ == '__main__':
main()
页:
[1]