Latest Contributions by AlexP_

I noticed this now. The county did change the GIS format of the data we are getting to update our SDE database for properties. I need to transform the actual process to work with the new format. How can I automate and import the new data into the SDE? Here is the code blocker below. Please advise. Thanks. ... View more

Rebecca, Someone else has created it and it is working.  This existing python script is already running from FTP shapefile convert to SDE in Database Connection weekly that screenshot SDE GDB. It is working fine. The new part now in FTP is zip file that is compressed.  I need compressed zip file to unzip and get it into SDE as previous screenshot. I will try to use that zip file script you provided and get it back to you. Also, I will add code blocker here when I wipe out some info.  Thank you for your time and assist. ... View more

Would join table work??  Please advise.  ... View more

Rebecca, Thank you for your reply. I posted it last week but no one has answer yet. I can't post full script because it is not public. Is there a way to show private to someone and someone might know what I am talking about?  I posted this question on geonet: There is a zip file (“TEST.gbd.zip”) containing a File Geodatabase with both feature classes from FTP County and I need it to download. What is the python script for this case? Please advise. Thank you.   For example, I pulled this part of script like this:  but what about zip file? It has compressed zip file.  # List of Other files to download # Syntax: County file name with extension separated by colon, then # the FTP Folder name CountyOtherFiles = { 'pa_parceldata.dat':r'GISdata/Pa_data/', 'pa_parceldata.txt':r'GISdata/Pa_data/', 'pa_legal_ln.dat':r'GISdata/Pa_data/', 'pa_legal_ln.txt':r'GISdata/Pa_data/', } I am new to python script. I have been researched thru here and having difficult to find a right answer. I have compressed zipfile in FTP WinSCP. I am trying to extract or unzip in python from FTP Winscp? It has compressed zip file in FTP. I have Winscp connect to FTP. I am not sure what is the right script for this case. I already have script set up that has been created by someone else. Please advise. Thank you. I tried to use this script but I got an error.  ZipFile.extractall(path='GISData/Pubshp', members= 'PaFiles.gdb.zip')NameError: name 'ZipFile' is not defined ... View more

On the web map is the viewer purposes only. However, someone in other department needs to add new address on CSV file that connect to SDE feature class on web map.  Is that make sense? ... View more

Yes, that is correct. Is it map service or feature service? I am not sure how it is work. Is it required AGOL service credit for addresses or LON/LAT as well?   ... View more

Is there a opposite way? I am trying to write a python script about zip file (“TEST.gbd.zip”) containing a File Geodatabase with both feature classes from FTP County and I need it to download. ... View more

I figured it out the correct python script. It is working now.   # Name: FeatureClassToFeatureClass_Example2.py # Description: Use FeatureClassToFeatureClass with an expression to create a subset # of the original feature class. # Import system modules import arcpy arcpy.env.overwriteOutput = True # Set environment settings arcpy.env.workspace = "N:\_Alexis\GISData\Pubshp\CityHall.shp" # Set local variables inFeatures = "CityHall" outLocation = "Database Connections\SDE.sde" outFeatureClass = "CityHall2" # Execute FeatureClassToFeatureClass arcpy.FeatureClassToFeatureClass_conversion(inFeatures, outLocation, outFeatureClass) ... View more

I recent run again and it gave me an error. Traceback (most recent call last): File "N:\_Alexis\GIS ArcPy\TEST_CityHall2.py", line 6, in <module> "CityHall2") File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\conversion.py", line 1790, in FeatureClassToFeatureClass raise e ExecuteError: ERROR 000258: Output Database Connections\SDE.sde\CityHall2 already exists Failed to execute (FeatureClassToFeatureClass). I added it.   import arcpy arcpy.env.overwriteOutput = True arcpy.env.workspace = "N:\_Alexis\GISData\Pubshp\CityHall.shp" arcpy.FeatureClassToFeatureClass_conversion("CityHall",  "Database Connections\SDE.sde",  "CityHall2") ... View more

I added it and there is no error message. I think it is working.  Thanks! import arcpy arcpy.env.overwriteOutput = True arcpy.env.workspace = "N:\_Alexis\GISData\Pubshp\CityHall.shp" arcpy.FeatureClassToFeatureClass_conversion("CityHall", "Database Connections\SDE.sde", "CityHall2") This is what I got result:  It seems working.  >>> ================================ RESTART ================================ >>> >>> Do you know what script is it? What do you recommend to set up python script that included whole feature class like drawing and tables? ... View more