Display Name: DownloadGDB

Description: This geoprocessing script accepts an input json string and returns a zipped GDB file. The correctly formed json string can specify a main layer and related tables / layers.

Category:

Help URL: https://geoweb.sfwmd.gov/agsext1/rest/directories/arcgisoutput/GP/DownloadGDB_GPServer/GP_DownloadGDB/DownloadGDB.htm

Execution Type: esriExecutionTypeSynchronous

Parameters:

Parameter: inputJson

Data Type: GPString
Display Name Input JSON
Description: This is the key input parameter for this geoprocessing script.The json structure that the script is expecting contains two main sections, mainLayer and relatedLayers.mainLayer contains the data about the main data source for the gdb. This section will contain fields and features.relatedLayers is an array of related layers or tables. These data objects also contain fields and features, but also contain a relationshipProperties object that describes the relationship between the main layer and the related layer (like the cardinality, key field, etc.).
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value: {"mainLayer":{"features":[{"aggregateGeometries":null,"geometry":{"spatialReference":{"latestWkid":2881,"wkid":2881},"x":906197.4047991633,"y":527693.3613217399},"symbol":null,"attributes":{"OBJECTID":947,"COLLECTION_DATE":1668117600000,"FLOODING_DATE":1668117600000,"FLOOD_DEPTH":"other","FLOOD_DEPTH_OTHER":"1 foot from gate height","FLOOD_FREQUENCY":"sometimes","FLOOD_FREQUENCY_OTHER":null,"PROPERTY_TYPE":"Governmental","AFFECTED_AREA":"building_structure","OTHER_INFORMATION":null,"OBSERVATIONS":null,"AFFECTED_AGRICULTURE":null,"AFFECTED_AGRICULTURE_OTHER":null,"SURVEY_TYPE":"Public","MONTH":null,"YEAR":2022,"EVENT_TYPE":"Extreme or Heavy Rainfall with Tidal Flooding","EVENT_TYPE_OTHER":"Category 1 Hurricane","EVENT_NAME":"2022 Nov Hurricane Nicole","COUNTY":"Miami-Dade","MUNICIPALITY":"MIAMI","SPECIAL_DISTRICT_NAME":null,"FLOOD_PRONE_AREA_ID":"MIAMI","AHED_WS_NAME":"C-5","UNIQUE_ID":"000f3e59-d60e-41f2-9c03-7276066d05d8","PHOTO":"No","REVIEW_STATUS":"Complete","REVIEWER":"ccarlso","REVIEW_OUTCOME":"Pass","REVIEW_COMMENT":null,"PUBLIC_SHARE":"Yes"},"popupTemplate":null}],"fields":[{"alias":"OBJECTID","defaultValue":null,"editable":false,"name":"OBJECTID","nullable":false,"type":"esriFieldTypeOID"},{"alias":"Collection Date:","defaultValue":null,"editable":true,"length":8,"name":"COLLECTION_DATE","nullable":true,"type":"esriFieldTypeDate"},{"alias":"Date of Flooding:","defaultValue":null,"editable":true,"length":8,"name":"FLOODING_DATE","nullable":true,"type":"esriFieldTypeDate"},{"alias":"Flood Depth:","defaultValue":null,"domain":{"name":"Flood_Depth","type":"codedValue","codedValues":[{"name":"Don't know","code":"don't_know"},{"name":"Less than ankle deep","code":"less_than_ankle_deep"},{"name":"Ankle deep","code":"ankle_deep"},{"name":"Knee deep","code":"knee_deep"},{"name":"Greater than knee deep","code":"greater_than_knee_deep"},{"name":"Other","code":"other"}]},"editable":true,"length":30,"name":"FLOOD_DEPTH","nullable":true,"type":"esriFieldTypeString"},{"alias":"Other Information About Flood Depth:","defaultValue":null,"editable":true,"length":200,"name":"FLOOD_DEPTH_OTHER","nullable":true,"type":"esriFieldTypeString"},{"alias":"How Frequently Does Area Flood:","defaultValue":null,"domain":{"name":"Flood_Frequency","type":"codedValue","codedValues":[{"name":"Don't know","code":"don't_know"},{"name":"Never","code":"never"},{"name":"Whenever it rains","code":"whenever_it_rains"},{"name":"Only during tropical events","code":"only_during_tropical_events"},{"name":"Sometimes","code":"sometimes"}]},"editable":true,"length":30,"name":"FLOOD_FREQUENCY","nullable":true,"type":"esriFieldTypeString"},{"alias":"Other Information About Flood Frequency:","defaultValue":null,"editable":true,"length":200,"name":"FLOOD_FREQUENCY_OTHER","nullable":true,"type":"esriFieldTypeString"},{"alias":"Property Type:","defaultValue":null,"domain":{"name":"property_type","type":"codedValue","codedValues":[{"name":"Residential","code":"Residential"},{"name":"Commercial","code":"Commercial"},{"name":"Industrial","code":"Industrial"},{"name":"Agriculture","code":"Agriculture"},{"name":"Governmental","code":"Governmental"},{"name":"Mixed Use","code":"Mixed_Use"},{"name":"Airport","code":"Airport"},{"name":"Natural Area / Open Land / Recreational","code":"Natural_Area_Open_Land_Recreational"}]},"editable":true,"length":40,"name":"PROPERTY_TYPE","nullable":true,"type":"esriFieldTypeString"},{"alias":"Affected Area:","defaultValue":null,"domain":{"name":"Affected_Areas","type":"codedValue","codedValues":[{"name":"Building / Structure","code":"building_structure"},{"name":"Driveway / Garage","code":"driveway_garage"},{"name":"Parking Lot","code":"parking_lot"},{"name":"Road / Street","code":"road_street"},{"name":"Seawall","code":"seawall"},{"name":"Storm Drain","code":"storm_drain"},{"name":"Swale","code":"swale"},{"name":"Yard","code":"yard"},{"name":"Field / Open Area / Natural Area","code":"field_open_natural_area"},{"name":"Don't Know","code":"don't_know"},{"name":"other","code":"other"}]},"editable":true,"length":30,"name":"AFFECTED_AREA","nullable":true,"type":"esriFieldTypeString"},{"alias":"Additional Information:","defaultValue":null,"editable":true,"length":200,"name":"OTHER_INFORMATION","nullable":true,"type":"esriFieldTypeString"},{"alias":"General Observations:","defaultValue":null,"editable":true,"length":2000,"name":"OBSERVATIONS","nullable":true,"type":"esriFieldTypeString"},{"alias":"Type of Affected Agriculture:","defaultValue":null,"domain":{"name":"Agriculture_Type","type":"codedValue","codedValues":[{"name":"Citrus","code":"citrus"},{"name":"Nursery","code":"nursery"},{"name":"Pasture","code":"pasture"},{"name":"Plantation","code":"plantation"},{"name":"Row Crop","code":"row_crop"},{"name":"Other Agriculture","code":"other_ag"}]},"editable":true,"length":30,"name":"AFFECTED_AGRICULTURE","nullable":true,"type":"esriFieldTypeString"},{"alias":"Other Information About Affected Agriculture:","defaultValue":null,"editable":true,"length":200,"name":"AFFECTED_AGRICULTURE_OTHER","nullable":true,"type":"esriFieldTypeString"},{"alias":"Data Acquisition Survey Type:","defaultValue":null,"editable":true,"length":50,"name":"SURVEY_TYPE","nullable":true,"type":"esriFieldTypeString"},{"alias":"Month:","defaultValue":null,"domain":{"name":"Month","type":"codedValue","codedValues":[{"name":"January","code":"01"},{"name":"February","code":"02"},{"name":"March","code":"03"},{"name":"April","code":"04"},{"name":"May","code":"05"},{"name":"June","code":"06"},{"name":"July","code":"07"},{"name":"August","code":"08"},{"name":"September","code":"09"},{"name":"October","code":"10"},{"name":"November","code":"11"},{"name":"December","code":"12"}]},"editable":true,"length":5,"name":"MONTH","nullable":true,"type":"esriFieldTypeString"},{"alias":"Year:","defaultValue":null,"editable":true,"name":"YEAR","nullable":true,"type":"esriFieldTypeSmallInteger"},{"alias":"Event Type:","defaultValue":null,"domain":{"name":"event_type","type":"codedValue","codedValues":[{"name":"High Tide/Tidal Flooding","code":"high_tide_tidal_flooding"},{"name":"Extreme or Heavy Rainfall","code":"extreme_heavy_rainfall"},{"name":"Storm Surge","code":"storm_surge"},{"name":"Compound Flooding","code":"compound_flooding"},{"name":"Extreme or Heavy Rainfall and Storm Surge","code":"extreme_heavy_rainfall_storm_surge"},{"name":"Extreme or Heavy Rainfall with Tidal Flooding","code":"extreme_heavy_rainfall_tidal_flooding"}]},"editable":true,"length":50,"name":"EVENT_TYPE","nullable":true,"type":"esriFieldTypeString"},{"alias":"Event Type (Other):","defaultValue":null,"domain":{"name":"event_type_other","type":"codedValue","codedValues":[{"name":"Tropical Storm","code":"Tropical_Storm"},{"name":"Category 1 Hurricane","code":"Category_1_Hurricane"},{"name":"Category 2 Hurricane","code":"Category_2_Hurricane"},{"name":"Category 3 Hurricane","code":"Category_3_Hurricane"},{"name":"Category 4 Hurricane","code":"Category_4_Hurricane"},{"name":"Rain","code":"Rain"},{"name":"Tidal","code":"Tidal"},{"name":"Both_Rain_Tidal","code":"Both_Rain_Tidal"}]},"editable":true,"length":50,"name":"EVENT_TYPE_OTHER","nullable":true,"type":"esriFieldTypeString"},{"alias":"Event Name:","defaultValue":null,"editable":true,"length":50,"name":"EVENT_NAME","nullable":true,"type":"esriFieldTypeString"},{"alias":"County:","defaultValue":null,"editable":true,"length":30,"name":"COUNTY","nullable":true,"type":"esriFieldTypeString"},{"alias":"Municipality:","defaultValue":null,"editable":true,"length":50,"name":"MUNICIPALITY","nullable":true,"type":"esriFieldTypeString"},{"alias":"Special District Name:","defaultValue":null,"editable":true,"length":100,"name":"SPECIAL_DISTRICT_NAME","nullable":true,"type":"esriFieldTypeString"},{"alias":"Flood Prone Area ID:","defaultValue":null,"editable":true,"length":50,"name":"FLOOD_PRONE_AREA_ID","nullable":true,"type":"esriFieldTypeString"},{"alias":"SFWMD AHED Watershed Name:","defaultValue":null,"editable":true,"length":30,"name":"AHED_WS_NAME","nullable":true,"type":"esriFieldTypeString"},{"alias":"Unique ID:","defaultValue":null,"editable":true,"length":40,"name":"UNIQUE_ID","nullable":true,"type":"esriFieldTypeString"},{"alias":"Photo (Yes / No):","defaultValue":null,"domain":{"name":"YES_NO","type":"codedValue","codedValues":[{"name":"No","code":"No"},{"name":"Yes","code":"Yes"}]},"editable":true,"length":5,"name":"PHOTO","nullable":true,"type":"esriFieldTypeString"},{"alias":"Review Status:","defaultValue":"Pending","domain":{"name":"Review_FollowUp_Status","type":"codedValue","codedValues":[{"name":"Pending","code":"Pending"},{"name":"Ongoing","code":"Ongoing"},{"name":"Complete","code":"Complete"}]},"editable":true,"length":20,"name":"REVIEW_STATUS","nullable":true,"type":"esriFieldTypeString"},{"alias":"Reviewer:","defaultValue":null,"editable":true,"length":30,"name":"REVIEWER","nullable":true,"type":"esriFieldTypeString"},{"alias":"Review Outcome (Pass/Fail):","defaultValue":null,"domain":{"name":"Review_Outcome","type":"codedValue","codedValues":[{"name":"Pass","code":"Pass"},{"name":"Fail","code":"Fail"},{"name":"Hold","code":"Hold"}]},"editable":true,"length":10,"name":"REVIEW_OUTCOME","nullable":true,"type":"esriFieldTypeString"},{"alias":"Review Comment:","defaultValue":null,"editable":true,"length":100,"name":"REVIEW_COMMENT","nullable":true,"type":"esriFieldTypeString"},{"alias":"Approved for Public Sharing:","defaultValue":null,"domain":{"name":"YES_NO","type":"codedValue","codedValues":[{"name":"No","code":"No"},{"name":"Yes","code":"Yes"}]},"editable":true,"length":5,"name":"PUBLIC_SHARE","nullable":true,"type":"esriFieldTypeString"}],"name":"Flood Reports Observations","displayFieldName":"EVENT_NAME","geometryType":"esriGeometryPoint","spatialReference":{"wkid":2881}},"relatedLayers":[{"layer":{"fields":[{"name":"OBJECTID","type":"esriFieldTypeOID","alias":"OBJECTID","defaultValue":null,"editable":false,"nullable":false},{"name":"ATTACH_URL","type":"esriFieldTypeString","alias":"ATTACH_URL","defaultValue":null,"editable":false,"nullable":true},{"name":"AZURE_full_path","type":"esriFieldTypeString","alias":"AZURE_full_path","defaultValue":null,"editable":false,"nullable":true},{"name":"COLLECTION_DATE","type":"esriFieldTypeDate","alias":"COLLECTION_DATE","defaultValue":null,"editable":false,"nullable":true},{"name":"FLOODING_DATE","type":"esriFieldTypeDate","alias":"FLOODING_DATE","defaultValue":null,"editable":false,"nullable":true},{"name":"FLOOD_DEPTH","type":"esriFieldTypeString","alias":"FLOOD_DEPTH","defaultValue":null,"editable":false,"nullable":true},{"name":"FLOOD_DEPTH_OTHER","type":"esriFieldTypeString","alias":"FLOOD_DEPTH_OTHER","defaultValue":null,"editable":false,"nullable":true},{"name":"FLOOD_FREQUENCY","type":"esriFieldTypeString","alias":"FLOOD_FREQUENCY","defaultValue":null,"editable":false,"nullable":true},{"name":"FLOOD_FREQUENCY_OTHER","type":"esriFieldTypeString","alias":"FLOOD_FREQUENCY_OTHER","defaultValue":null,"editable":false,"nullable":true},{"name":"PROPERTY_TYPE","type":"esriFieldTypeString","alias":"PROPERTY_TYPE","defaultValue":null,"editable":false,"nullable":true},{"name":"AFFECTED_AREA","type":"esriFieldTypeString","alias":"AFFECTED_AREA","defaultValue":null,"editable":false,"nullable":true},{"name":"OTHER_INFORMATION","type":"esriFieldTypeString","alias":"OTHER_INFORMATION","defaultValue":null,"editable":false,"nullable":true},{"name":"OBSERVATIONS","type":"esriFieldTypeString","alias":"OBSERVATIONS","defaultValue":null,"editable":false,"nullable":true},{"name":"AFFECTED_AGRICULTURE","type":"esriFieldTypeString","alias":"AFFECTED_AGRICULTURE","defaultValue":null,"editable":false,"nullable":true},{"name":"AFFECTED_AGRICULTURE_OTHER","type":"esriFieldTypeString","alias":"AFFECTED_AGRICULTURE_OTHER","defaultValue":null,"editable":false,"nullable":true},{"name":"YEAR","type":"esriFieldTypeInteger","alias":"YEAR","defaultValue":null,"editable":false,"nullable":true},{"name":"EVENT_TYPE","type":"esriFieldTypeString","alias":"EVENT_TYPE","defaultValue":null,"editable":false,"nullable":true},{"name":"EVENT_TYPE_OTHER","type":"esriFieldTypeString","alias":"EVENT_TYPE_OTHER","defaultValue":null,"editable":false,"nullable":true},{"name":"EVENT_NAME","type":"esriFieldTypeString","alias":"EVENT_NAME","defaultValue":null,"editable":false,"nullable":true},{"name":"COUNTY","type":"esriFieldTypeString","alias":"COUNTY","defaultValue":null,"editable":false,"nullable":true},{"name":"MUNICIPALITY","type":"esriFieldTypeString","alias":"MUNICIPALITY","defaultValue":null,"editable":false,"nullable":true},{"name":"SPECIAL_DISTRICT_NAME","type":"esriFieldTypeString","alias":"SPECIAL_DISTRICT_NAME","defaultValue":null,"editable":false,"nullable":true},{"name":"FLOOD_PRONE_AREA_ID","type":"esriFieldTypeString","alias":"FLOOD_PRONE_AREA_ID","defaultValue":null,"editable":false,"nullable":true},{"name":"AHED_WS_NAME","type":"esriFieldTypeString","alias":"AHED_WS_NAME","defaultValue":null,"editable":false,"nullable":true},{"name":"REL_UNIQUE_ID","type":"esriFieldTypeString","alias":"REL_UNIQUE_ID","defaultValue":null,"editable":false,"nullable":true}],"features":[{"aggregateGeometries":null,"geometry":null,"symbol":null,"attributes":{"OBJECTID":965,"ATTACH_URL":"https://geospatialstorage.blob.core.windows.net/attachments/5D6BDABB-C3D3-4B01-A324-55AF786AD65F.jpeg","AZURE_full_path":"5D6BDABB-C3D3-4B01-A324-55AF786AD65F.jpeg","COLLECTION_DATE":1668117600000,"FLOODING_DATE":1668117600000,"FLOOD_DEPTH":"don't_know","FLOOD_DEPTH_OTHER":null,"FLOOD_FREQUENCY":"don't_know","FLOOD_FREQUENCY_OTHER":null,"PROPERTY_TYPE":"Natural_Area_Open_Land_Recreational","AFFECTED_AREA":"swale","OTHER_INFORMATION":null,"OBSERVATIONS":null,"AFFECTED_AGRICULTURE":null,"AFFECTED_AGRICULTURE_OTHER":null,"YEAR":2022,"EVENT_TYPE":"Extreme or Heavy Rainfall with Tidal Flooding","EVENT_TYPE_OTHER":"Category 1 Hurricane","EVENT_NAME":"2022 Nov Hurricane Nicole","COUNTY":"Palm Beach","REL_UNIQUE_ID":"ff3d9f46-14cf-4cd2-b19c-42f0c25f6129"},"popupTemplate":null}]},"relationshipProperties":{"cardinality":"esriRelCardinalityOneToMany","composite":true,"id":1,"keyField":"UNIQUE_ID","name":"egissp.EM.FLOOD_OBSERVATION_PHOTOS","relatedTableId":7,"role":"esriRelRoleOrigin"}}]}
Parameter Type: esriGPParameterTypeRequired
Category:


Parameter: outputZip

Data Type: GPDataFile
Display Name Output Zip
Description:
Direction: esriGPParameterDirectionOutput
Filter:
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeDerived
Category:

Supported Operations:   Execute Task

Child Resources:   Metadata