topic Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures). in Python Questions

The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DimasPerceka — Sat, 17 Jul 2021 05:24:54 GMT

I want to learn automatic update real time data with python in ESRI training (https://learn.arcgis.com/en/projects/update-real-time-data-with-python/) but i have some trouble. Here I attach the error and the script that was made. Here my script

import sys, os, tempfile, json, logging, arcpy, shutil import datetime as dt from urllib import request from urllib.error import URLError def feedRoutine (url, workGDB, liveGDB): # Log file logging.basicConfig(filename="coral_reef_exercise.log", level=logging.INFO) log_format = "%Y-%m-%d %H:%M:%S" # Create workGDB and default workspace print("Starting workGDB...") logging.info("Starting workGDB... {0}".format(dt.datetime.now().strftime(log_format))) arcpy.env.workspace = workGDB gdb_name = os.path.basename(workGDB) if arcpy.Exists(arcpy.env.workspace): for feat in arcpy.ListFeatureClasses ("alert_*"): arcpy.management.Delete(feat) else: arcpy.management.CreateFileGDB(os.path.dirname(workGDB), os.path.basename(workGDB)) # Download and split json file print("Downloading data...") logging.info("Downloading data... {0}".format(dt.datetime.now().strftime(log_format))) temp_dir = tempfile.mkdtemp() filename = os.path.join(temp_dir, 'latest_data.json') try: response = request.urlretrieve(url, filename) except URLError: raise Exception("{0} not available. Check internet connection or url address".format(url)) with open(filename) as json_file: data_raw = json.load(json_file) data_stations = dict(type=data_raw['type'], features=[]) data_areas = dict(type=data_raw['type'], features=[]) for feat in data_raw['features']: if feat['geometry']['type'] == 'Point': data_stations['features'].append(feat) else: data_areas['features'].append(feat) # Filenames of temp json files stations_json_path = os.path.join(temp_dir, 'points.json') areas_json_path = os.path.join(temp_dir, 'polygons.json') # Save dictionaries into json files with open(stations_json_path, 'w') as point_json_file: json.dump(data_stations, point_json_file, indent=4) with open(areas_json_path, 'w') as poly_json_file: json.dump(data_areas, poly_json_file, indent=4) # Convert json files to features print("Creating feature classes...") logging.info("Creating feature classes... {0}".format(dt.datetime.now().strftime(log_format))) arcpy.conversion.JSONToFeatures(stations_json_path, os.path.join(gdb_name, 'alert_stations')) arcpy.conversion.JSONToFeatures(areas_json_path, os.path.join(gdb_name, 'alert_areas')) # Add 'alert_level ' field arcpy.management.AddField(os.path.join(gdb_name, "alert_stations"), "alert_level", "SHORT", field_alias="Alert Level") arcpy.management.AddField(os.path.join(gdb_name, "alert_areas"), "alert_level", "SHORT", field_alias="Alert Level") # Calculate 'alert_level ' field arcpy.management.CalculateField(os.path.join(gdb_name, "alert_stations"), "alert_level", "int(!alert!)") arcpy.management.CalculateField(os.path.join(gdb_name, "alert_areas"), "alert_level", "int(!alert!)") # Deployment Logic print("Deploying...") logging.info("Deploying... {0}".format(dt.datetime.now().strftime(log_format))) deployLogic(workGDB, liveGDB) # Close Log File logging.shutdown() # Return print("Done!") logging.info("Done! {0}".format(dt.datetime.now().strftime(log_format))) return True def deployLogic(workGDB, liveGDB): for root, dirs, files in os.walk(workGDB, topdown=False): files = [f for f in files if '.lock' not in f] for f in files: shutil.copy2(os.path.join(workGDB, f), os.path.join(liveGDB, f)) if __name__ == "__main__": [url, workGDB, liveGDB] = sys.argv[1:] feedRoutine (url, workGDB, liveGDB)

Here the error message :

(arcgispro-py3) C:\Users\User\Documents>python coral_reef_exercise_local.py https://downloads.esri.com/LearnArcGIS/update-real-time-data-with-python/vs_polygons.json C:\Temp\Work.gdb C:\Temp\Live.gdb Starting workGDB... Downloading data... Creating feature classes... Traceback (most recent call last): File "coral_reef_exercise_local.py", line 80, in <module> feedRoutine (url, workGDB, liveGDB) File "coral_reef_exercise_local.py", line 50, in feedRoutine arcpy.conversion.JSONToFeatures(stations_json_path, os.path.join(gdb_name, 'alert_stations')) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\conversion.py", line 576, in JSONToFeatures raise e File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\conversion.py", line 573, in JSONToFeatures retval = convertArcObjectToPythonObject(gp.JSONToFeatures_conversion(*gp_fixargs((in_json_file, out_features, geometry_type), True))) File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda> return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds. CreateFeatureClassName: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

I'm very happy if someone can help me with this problem. Thank you

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DavidPike — Sat, 17 Jul 2021 01:47:09 GMT

have you created a workspace under that name?

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DimasPerceka — Sat, 17 Jul 2021 01:49:04 GMT

can you give me an example?

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DimasPerceka — Sat, 17 Jul 2021 01:50:56 GMT

Here my script :

import sys, os, tempfile, json, logging, arcpy, shutil

import datetime as dt

from urllib import request

from urllib.error import URLError

def feedRoutine (url, workGDB, liveGDB😞

# Log file

logging.basicConfig(filename="coral_reef_exercise.log", level=logging.INFO)

log_format = "%Y-%m-%d %H:%M:%S"

# Create workGDB and default workspace

print("Starting workGDB...")

logging.info("Starting workGDB... {0}".format(dt.datetime.now().strftime(log_format)))

arcpy.env.workspace = workGDB

gdb_name = os.path.basename(workGDB)

if arcpy.Exists(arcpy.env.workspace):

for feat in arcpy.ListFeatureClasses ("alert_*"😞

arcpy.management.Delete(feat)

else:

arcpy.management.CreateFileGDB(os.path.dirname(workGDB), os.path.basename(workGDB))

# Download and split json file

print("Downloading data...")

logging.info("Downloading data... {0}".format(dt.datetime.now().strftime(log_format)))

temp_dir = tempfile.mkdtemp()

filename = os.path.join(temp_dir, 'latest_data.json')

try:

response = request.urlretrieve(url, filename)

except URLError:

raise Exception("{0} not available. Check internet connection or url address".format(url))

with open(filename) as json_file:

data_raw = json.load(json_file)

data_stations = dict(type=data_raw['type'], features=[])

data_areas = dict(type=data_raw['type'], features=[])

for feat in data_raw['features']:

if feat['geometry']['type'] == 'Point':

data_stations['features'].append(feat)

else:

data_areas['features'].append(feat)

# Filenames of temp json files

stations_json_path = os.path.join(temp_dir, 'points.json')

areas_json_path = os.path.join(temp_dir, 'polygons.json')

# Save dictionaries into json files

with open(stations_json_path, 'w') as point_json_file:

json.dump(data_stations, point_json_file, indent=4)

with open(areas_json_path, 'w') as poly_json_file:

json.dump(data_areas, poly_json_file, indent=4)

# Convert json files to features

print("Creating feature classes...")

logging.info("Creating feature classes... {0}".format(dt.datetime.now().strftime(log_format)))

arcpy.conversion.JSONToFeatures(stations_json_path, os.path.join(gdb_name, 'alert_stations'))

arcpy.conversion.JSONToFeatures(areas_json_path, os.path.join(gdb_name, 'alert_areas'))

# Add 'alert_level ' field

arcpy.management.AddField(os.path.join(gdb_name, "alert_stations"), "alert_level", "SHORT", field_alias="Alert Level")

arcpy.management.AddField(os.path.join(gdb_name, "alert_areas"), "alert_level", "SHORT", field_alias="Alert Level")

# Calculate 'alert_level ' field

arcpy.management.CalculateField(os.path.join(gdb_name, "alert_stations"), "alert_level", "int(!alert!)")

arcpy.management.CalculateField(os.path.join(gdb_name, "alert_areas"), "alert_level", "int(!alert!)")

# Deployment Logic

print("Deploying...")

logging.info("Deploying... {0}".format(dt.datetime.now().strftime(log_format)))

deployLogic(workGDB, liveGDB)

# Close Log File

logging.shutdown()

# Return

print("Done!")

logging.info("Done! {0}".format(dt.datetime.now().strftime(log_format)))

return True

def deployLogic(workGDB, liveGDB😞

for root, dirs, files in os.walk(workGDB, topdown=False😞

files = [f for f in files if '.lock' not in f]

for f in files:

shutil.copy2(os.path.join(workGDB, f), os.path.join(liveGDB, f))

if __name__ == "__main__":

[url, workGDB, liveGDB] = sys.argv[1:]

feedRoutine (url, workGDB, liveGDB)

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DavidPike — Sat, 17 Jul 2021 01:54:32 GMT

You've specified a workspace path via sys args for main() with what looks like c:\Temp\Work.gdb , maybe it has to be created first (I'm not a fan of reading screenshotted code so I can't tell).

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DimasPerceka — Sat, 17 Jul 2021 02:04:14 GMT

But Work.gdb is automatically appear when i run the previous script :

import sys, arcpy, os, tempfile, json

from urllib import request

def feedRoutine (url, workGDB😞

# workGDB and default workspace

print("Creating workGDB...")

arcpy.env.workspace = os.path.dirname(workGDB)

gdb_name = os.path.basename(workGDB)

arcpy.management.CreateFileGDB(arcpy.env.workspace, gdb_name)

# Download and split json file

print("Downloading data...")

temp_dir = tempfile.mkdtemp()

filename = os.path.join(temp_dir, 'latest_data.json')

response = request.urlretrieve(url, filename)

with open(filename) as json_file:

data_raw = json.load(json_file)

data_stations = dict(type=data_raw['type'], features=[])

data_areas = dict(type=data_raw['type'], features=[])

for feat in data_raw['features']:

if feat['geometry']['type'] == 'Point':

data_stations['features'].append(feat)

else:

data_areas['features'].append(feat)

# Filenames of temp json files

stations_json_path = os.path.join(temp_dir, 'points.json')

areas_json_path = os.path.join(temp_dir, 'polygons.json')

# Save dictionaries into json files

with open(stations_json_path, 'w') as point_json_file:

json.dump(data_stations, point_json_file, indent=4)

with open(areas_json_path, 'w') as poly_json_file:

json.dump(data_areas, poly_json_file, indent=4)

# Convert json files to features

print("Creating feature classes...")

arcpy.conversion.JSONToFeatures(stations_json_path, os.path.join(gdb_name, 'alert_stations'))

arcpy.conversion.JSONToFeatures(areas_json_path, os.path.join(gdb_name, 'alert_areas'))

# Add 'alert_level ' field

arcpy.management.AddField(os.path.join(gdb_name, "alert_stations"), "alert_level", "SHORT", field_alias="Alert Level")

arcpy.management.AddField(os.path.join(gdb_name, "alert_areas"), "alert_level", "SHORT", field_alias="Alert Level")

# Calculate 'alert_level ' field

arcpy.management.CalculateField(os.path.join(gdb_name, "alert_stations"), "alert_level", "int(!alert!)")

arcpy.management.CalculateField(os.path.join(gdb_name, "alert_areas"), "alert_level", "int(!alert!)")

# Deployment Logic

print("Deploying...")

deployLogic()

# Return

print("Done!")

return True

def deployLogic():

pass

if __name__ == "__main__":

[url, workGDB] = sys.argv[1:]

feedRoutine (url, workGDB)

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DavidPike — Sat, 17 Jul 2021 02:14:39 GMT

It's still a mess to read, look at code formatting options.

at this moment I can only guess at

arcpy.conversion.JSONToFeatures(stations_json_path, os.path.join(gdb_name, 'alert_stations')) arcpy.conversion.JSONToFeatures(areas_json_path, os.path.join(gdb_name, 'alert_areas'))

being a potential issue, as you already have a workspace set, and gdb_name isn't a full path.

also Exists(workGDB) may be more logical and mitigates unintended effects such as env.workspace defaulting to something if workGDB doesn''t exist, messing up your logic.

if arcpy.Exists(arcpy.env.workspace):

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DimasPerceka — Sat, 17 Jul 2021 02:35:12 GMT

I'm sorry because I'm a beginner in understanding programming languages, especially python. When I follow your suggestion, the result is still an error

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

Luke_Pinner — Sat, 17 Jul 2021 04:20:51 GMT

Can you add your script and the error as code formatted text, not as screenshots please:

How to insert code in your post

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DimasPerceka — Sat, 17 Jul 2021 05:28:40 GMT

Thank you for your suggestion, i already modify my post.
Here my script

and here the error message

I'm very happy if you take the time to help me solve this problem. Thank you

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DavidPike — Sat, 17 Jul 2021 13:09:56 GMT

I'm not sure why you're creating a path such as

os.path.join(gdb_name, 'alert_stations')

when gdb_name is already set as your workspace. just try writing to the workspace without specifying the workspace.

arcpy.conversion.JSONToFeatures(stations_json_path, 'alert_stations')

and do the same for any similar lines, i.e. stop joining gdb_name to a path.

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

MichaelVolz — Sat, 17 Jul 2021 14:18:44 GMT

Try putting in some print statements of variables to see what they are returning at various steps within your code, as this is a useful troubleshooting technique.

I would also suggest breaking down the script into smaller components and get each component to work and add back code as you work out the errors that exist in your current code.

Re: The workspace Work.gdb does not exist. Failed to execute (JSONToFeatures).

DimasPerceka — Sun, 18 Jul 2021 01:54:56 GMT

Thank you for your help, now the problem is solved.