New answers tagged spatial-database
1
Your question is almost all pandas so you could try posting it to stackoverflow and get a shorter answer. But this seems to work:
import pandas as pd
import arcpy
#I tried with csv input. Convert shapefile table to csv...
df = pd.read_csv(r'C:\somefolder\input.csv', dtype={'st_time':str,'end_time':str})
#...or use da.SearchCursor
columns = ['ID', 'Year', '...
0
The accepted response is fairly outdated for the current state of the art.
MySQL 5.6 has decent support for the OGC data types on MyISAM tables. You probably don't want to use MyISAM tables though.
MySQL 5.7 has decent support for the OGC data types on innodb tables:
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
https://www.percona.com/blog/...
Top 50 recent answers are included
