All Questions
112
questions
0
votes
0
answers
37
views
Preserve string field type and leading zeros when using arcpy.conversion.TableToTable to go from CSV to GDB table? [duplicate]
I'm building an ArcMap script tool that will be run on many different input table schemas for geocoding purposes. When importing from CSV to GDB table using the arcpy.conversion.TableToTable function ...
1
vote
1
answer
229
views
ArcPy - overwrite feature service with CSV
I am trying to download a CSV from our project database, and then append this to a feature service in AGOL.
import os
import requests
import csv
import arcpy
from requests.auth import HTTPBasicAuth
...
0
votes
0
answers
259
views
Loop through headers in CSV file and make shapefiles from each header
I am unable to figure a way out how to create a shapefile after looping through the csv files and matching the headers (dates in format Oct11/2018). Each shapefile should have all the fields with the ...
0
votes
0
answers
67
views
Check if field from .shp file exists in .csv file
I have an output folder with .shp files and I want to check if the fields in the .shp files exist in a CSV document (one common CSV file for all shapefiles).
I go through the fields in the .shp files ...
0
votes
1
answer
79
views
Performing near point-to-point merge with ArcPy?
I have a series of .csv datasets with points in Lat/Long mapped to Town Names:
In addition, I have a shapefile containing similar data (town names with their corresponding x/y):
I also have ...
3
votes
3
answers
880
views
Reprojecting list of latitude/longitude values in .csv to points using ArcPy
I am creating a tool using Python to convert .csv files into points. However, the points were collected in EPSG: 2274 and not WGS84 (EPSG:4326), so in order to create the points I have to convert the ...
0
votes
1
answer
856
views
Replacing zero with no data in CSV file using ArcPy cursor
I have a CSV file with zero as some of the attribute values. Trying to use cursors and replace all zeros with no data or blank values. I am able to replace any numbers. But not able to update with ...
2
votes
1
answer
46
views
ArcPy specific fields to CSV print() issue
I have made this code that extracts specific fields of feature layers into a CSV file.
Code works fine. I have an issue the way it writes to CSV. Output is as below:
(211793 '10290-03')
I actually ...
0
votes
0
answers
98
views
Setting field type when outputting CSV from table to table using ArcPy
I'm using arcpy.TableToTable_conversion() to convert a shapefile to CSV. In the shapefile, there is a field representing block group FIPS code as a string:
550791007004003
But it's getting output to ...
0
votes
0
answers
53
views
Gaps appearing in results when converting CSV to points shapefile
I'm trying to process a bunch of CSVs into point featureclass shapefiles in arcpy. The following is my code:
myCSVs = arcpy.ListFiles("*.csv") # Get all relevant CSV files
for i in myCSVs:
...
1
vote
1
answer
235
views
Using .CSV file as an external dictionary, but can't find a way to reference/make a key for Null in order to assign it a value using ArcPy
I am using ArcGIS Desktop: ArcMap 10.8.1 and using Python 2.7.18. I have a script that uses a .CSV file as an external dictionary (opposed to creating a dictionary within the script) but I cannot find ...
2
votes
0
answers
512
views
Batch geocode addresses using a REST API (ArcPy, CSV, Server)
My stand-alone Python script tries to geocode a CSV file of addresses.
The script successfully geocodes this CSV file when using the *.loc file for this locator but not the published REST API.
ArcGIS ...
0
votes
1
answer
2k
views
Python script to import CSV data to a geodatabase
I am trying to import CSV data into an existing geodatabase in ArcMap. I want to import to the existing geodatabase fields to ensure my CSV data satisfies whatever rules are set up in the geodatabase.
...
2
votes
2
answers
758
views
Getting CSV export to have different delimiter using ArcGIS Pro
ArcGIS Pro, using Table to Table tool, I want to export to CSV. But one of my fields is a description field that often has commas in the content. When that is exported to CSV that uses commas as ...
1
vote
2
answers
1k
views
Creating a Polyline from a CSV File
I am creating a shapefile based on three columns in my CSV File - Latitude, Longitude, and Laps. For the most part, I understand how to loop through the data and create the many points based on the ...