{ "name": "ExportFeatureService", "displayName": "Export Feature Service to Excel", "description": "Exports selected fields from either an ArcGIS feature layer or a feature service URL. Matching records are copied to the GP job scratch geodatabase before being written to Excel.", "category": "", "helpUrl": "https://gis.drmp.com/arcgis/rest/directories/arcgisoutput/Feature_Service_to_Excel_GPServer/Feature_Service_to_Excel/ExportFeatureService.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "input_feature_layer", "dataType": "GPFeatureRecordSetLayer", "displayName": "Input Feature Layer (Option 1)", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": { "displayFieldName": "", "geometryType": "esriGeometryPoint", "spatialReference": { "wkid": 4326, "latestWkid": 4326 }, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "fid" }, { "name": "id", "type": "esriFieldTypeInteger", "alias": "ID" }, { "name": "date_creat", "type": "esriFieldTypeString", "alias": "DATE_CREAT", "length": 24 }, { "name": "app_type", "type": "esriFieldTypeInteger", "alias": "APP_TYPE" }, { "name": "app_type_d", "type": "esriFieldTypeString", "alias": "APP_TYPE_D", "length": 1000 }, { "name": "cap_app_id", "type": "esriFieldTypeInteger", "alias": "CAP_APP_ID" }, { "name": "full_cap_a", "type": "esriFieldTypeString", "alias": "FULL_CAP_A", "length": 254 }, { "name": "app_status", "type": "esriFieldTypeInteger", "alias": "APP_STATUS" }, { "name": "app_stat_1", "type": "esriFieldTypeString", "alias": "APP_STAT_1", "length": 30 }, { "name": "jur_id", "type": "esriFieldTypeInteger", "alias": "JUR_ID" }, { "name": "jur_id_d", "type": "esriFieldTypeString", "alias": "JUR_ID_D", "length": 50 }, { "name": "pro_id", "type": "esriFieldTypeString", "alias": "PRO_ID", "length": 254 }, { "name": "per_name", "type": "esriFieldTypeString", "alias": "PER_NAME", "length": 254 }, { "name": "pro_name", "type": "esriFieldTypeString", "alias": "PRO_NAME", "length": 254 }, { "name": "pro_phase", "type": "esriFieldTypeString", "alias": "PRO_PHASE", "length": 254 }, { "name": "pro_sha_ag", "type": "esriFieldTypeString", "alias": "PRO_SHA_AG", "length": 254 }, { "name": "pro_org_p", "type": "esriFieldTypeString", "alias": "PRO_ORG_P", "length": 254 }, { "name": "pro_pre_na", "type": "esriFieldTypeString", "alias": "PRO_PRE_NA", "length": 254 }, { "name": "pro_addres", "type": "esriFieldTypeString", "alias": "PRO_ADDRES", "length": 254 }, { "name": "pro_city", "type": "esriFieldTypeInteger", "alias": "PRO_CITY" }, { "name": "pro_city_d", "type": "esriFieldTypeString", "alias": "PRO_CITY_D", "length": 30 }, { "name": "pro_state", "type": "esriFieldTypeString", "alias": "PRO_STATE", "length": 254 }, { "name": "pro_zip", "type": "esriFieldTypeString", "alias": "PRO_ZIP", "length": 5 }, { "name": "pro_zip4", "type": "esriFieldTypeString", "alias": "PRO_ZIP4", "length": 4 }, { "name": "mul_id", "type": "esriFieldTypeInteger", "alias": "MUL_ID" }, { "name": "mul_id_d", "type": "esriFieldTypeString", "alias": "MUL_ID_D", "length": 30 }, { "name": "per_releas", "type": "esriFieldTypeDouble", "alias": "PER_RELEAS" }, { "name": "tot_sfa", "type": "esriFieldTypeInteger", "alias": "TOT_SFA" }, { "name": "tot_sfd", "type": "esriFieldTypeInteger", "alias": "TOT_SFD" }, { "name": "tot_mf", "type": "esriFieldTypeInteger", "alias": "TOT_MF" }, { "name": "tot_mh", "type": "esriFieldTypeInteger", "alias": "TOT_MH" }, { "name": "tot_els_s", "type": "esriFieldTypeInteger", "alias": "TOT_ELS_S" }, { "name": "tot_mls_s", "type": "esriFieldTypeInteger", "alias": "TOT_MLS_S" }, { "name": "tot_his_s", "type": "esriFieldTypeInteger", "alias": "TOT_HIS_S" }, { "name": "orig_fid", "type": "esriFieldTypeInteger", "alias": "ORIG_FID" }, { "name": "folio", "type": "esriFieldTypeString", "alias": "FOLIO", "length": 1000 }, { "name": "location", "type": "esriFieldTypeString", "alias": "Lcation/Address", "length": 256 }, { "name": "closestmajorintersection", "type": "esriFieldTypeString", "alias": "Closest Major Intersection", "length": 256 }, { "name": "mailingaddress", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 256 }, { "name": "telephonenumber", "type": "esriFieldTypeString", "alias": "Telephone Number", "length": 30 }, { "name": "email", "type": "esriFieldTypeString", "alias": "Email", "length": 100 }, { "name": "currentfuturelanduse", "type": "esriFieldTypeString", "alias": "Current Future Land Use", "length": 100 }, { "name": "currentzoning", "type": "esriFieldTypeString", "alias": "Current Zoning", "length": 50 }, { "name": "proposedfuturelanduse", "type": "esriFieldTypeString", "alias": "Proposed Future Land Use", "length": 100 }, { "name": "proposedzoning", "type": "esriFieldTypeString", "alias": "Proposed Zoning", "length": 50 }, { "name": "sfd_units", "type": "esriFieldTypeInteger", "alias": "Single Family Detached Units" }, { "name": "mf_units", "type": "esriFieldTypeInteger", "alias": "Multi-Family Apartments" }, { "name": "sfa_units", "type": "esriFieldTypeInteger", "alias": "Single Family Attached Units" }, { "name": "mh_units", "type": "esriFieldTypeInteger", "alias": "MH_Units" }, { "name": "totalacres", "type": "esriFieldTypeDouble", "alias": "Total Acres" }, { "name": "existingunits_onsite", "type": "esriFieldTypeString", "alias": "Existing Occupied Units Onsite", "length": 20 }, { "name": "numexistingunits", "type": "esriFieldTypeInteger", "alias": "Number Of Existing Units" }, { "name": "existingunittype", "type": "esriFieldTypeString", "alias": "Existing Unit Type", "length": 100 }, { "name": "schoolzones", "type": "esriFieldTypeString", "alias": "School Zones", "length": 1000 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8 }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255 }, { "name": "date_creat_converted", "type": "esriFieldTypeDate", "alias": "date_creat_Converted", "length": 8 }, { "name": "elem", "type": "esriFieldTypeString", "alias": "Elementary", "length": 256 }, { "name": "middle", "type": "esriFieldTypeString", "alias": "Middle", "length": 256 }, { "name": "high", "type": "esriFieldTypeString", "alias": "High", "length": 256 }, { "name": "eid", "type": "esriFieldTypeString", "alias": "Elem ID", "length": 256 }, { "name": "mid", "type": "esriFieldTypeString", "alias": "Mid ID", "length": 256 }, { "name": "hid", "type": "esriFieldTypeString", "alias": "High ID ", "length": 256 }, { "name": "totess", "type": "esriFieldTypeDouble", "alias": "Total ESS" }, { "name": "totmss", "type": "esriFieldTypeDouble", "alias": "Total MSS" }, { "name": "tothss", "type": "esriFieldTypeDouble", "alias": "Total HSS" }, { "name": "stationelem", "type": "esriFieldTypeDouble", "alias": "Station Elem" }, { "name": "stationmid", "type": "esriFieldTypeDouble", "alias": "Station Mid" }, { "name": "stationhigh", "type": "esriFieldTypeDouble", "alias": "Station High" }, { "name": "remainingelem", "type": "esriFieldTypeDouble", "alias": "Remaining Elem" }, { "name": "remainingmid", "type": "esriFieldTypeDouble", "alias": "Remaining Mid" }, { "name": "remaininghigh", "type": "esriFieldTypeDouble", "alias": "Remaining High" }, { "name": "levelelem", "type": "esriFieldTypeString", "alias": "Grade Level Elem", "length": 256 }, { "name": "levelmid", "type": "esriFieldTypeString", "alias": "Grade Level Mid", "length": 256 }, { "name": "levelhigh", "type": "esriFieldTypeString", "alias": "Grade Level High", "length": 256 }, { "name": "per_release2020", "type": "esriFieldTypeDouble", "alias": "% Release 2020" }, { "name": "per_release2021", "type": "esriFieldTypeDouble", "alias": "% Release 2021" }, { "name": "change21vs20", "type": "esriFieldTypeDouble", "alias": "Change 21 vs 20" }, { "name": "per_release2022", "type": "esriFieldTypeDouble", "alias": "% Release 2022" }, { "name": "change22vs21", "type": "esriFieldTypeDouble", "alias": "Change 22 vs 21" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38 }, { "name": "pkenrolleid", "type": "esriFieldTypeDouble", "alias": "pkenrolleid" }, { "name": "pkenrollmid", "type": "esriFieldTypeDouble", "alias": "pkenrollmid" }, { "name": "pkenrollhid", "type": "esriFieldTypeDouble", "alias": "pkenrollhid" }, { "name": "k12enrolleid", "type": "esriFieldTypeDouble", "alias": "k12enrolleid" }, { "name": "k12enrollmid", "type": "esriFieldTypeDouble", "alias": "k12enrollmid" }, { "name": "k12enrollhid", "type": "esriFieldTypeDouble", "alias": "k12enrollhid" }, { "name": "fourtydayeid", "type": "esriFieldTypeDouble", "alias": "fourtydayeid" }, { "name": "fourtydaymid", "type": "esriFieldTypeDouble", "alias": "fourtydaymid" }, { "name": "fourtydayhid", "type": "esriFieldTypeDouble", "alias": "fourtydayhid" }, { "name": "fisheid", "type": "esriFieldTypeDouble", "alias": "fisheid" }, { "name": "fishmid", "type": "esriFieldTypeDouble", "alias": "fishmid" }, { "name": "fishhid", "type": "esriFieldTypeDouble", "alias": "fishhid" }, { "name": "remainingresevedeid", "type": "esriFieldTypeDouble", "alias": "remainingresevedeid" }, { "name": "remainingresevedmid", "type": "esriFieldTypeDouble", "alias": "remainingresevedmid" }, { "name": "remainingresevedehid", "type": "esriFieldTypeDouble", "alias": "remainingresevedehid" }, { "name": "totess2526", "type": "esriFieldTypeDouble", "alias": "totess2526" }, { "name": "totmss2526", "type": "esriFieldTypeDouble", "alias": "totmss2526" }, { "name": "tothss2526", "type": "esriFieldTypeDouble", "alias": "tothss2526" }, { "name": "per_rel_24", "type": "esriFieldTypeString", "alias": "per_rel_24", "length": 255 }, { "name": "perrel2", "type": "esriFieldTypeDouble", "alias": "perrel2" }, { "name": "per_release2023", "type": "esriFieldTypeDouble", "alias": "per_release2023" }, { "name": "change22vs23", "type": "esriFieldTypeDouble", "alias": "change22vs23" }, { "name": "change24vs23", "type": "esriFieldTypeDouble", "alias": "change24vs23" }, { "name": "guid_official", "type": "esriFieldTypeString", "alias": "guid_official", "length": 1500 }, { "name": "unreleasedeid", "type": "esriFieldTypeDouble", "alias": "Unreleased EID" }, { "name": "unreleasedmid", "type": "esriFieldTypeDouble", "alias": "Unreleased MID" }, { "name": "unreleasedhid", "type": "esriFieldTypeDouble", "alias": "Unreleased HID" }, { "name": "sa", "type": "esriFieldTypeDouble", "alias": "sa" }, { "name": "secondchoice_sa", "type": "esriFieldTypeDouble", "alias": "secondchoice_sa" }, { "name": "secondchoice", "type": "esriFieldTypeString", "alias": "secondchoice", "length": 1500 }, { "name": "thirdchoice_sa", "type": "esriFieldTypeDouble", "alias": "thirdchoice_sa" }, { "name": "thirdchoice", "type": "esriFieldTypeString", "alias": "thirdchoice", "length": 1500 }, { "name": "ow", "type": "esriFieldTypeDouble", "alias": "ow" }, { "name": "sa_mid", "type": "esriFieldTypeDouble", "alias": "sa_mid" }, { "name": "secondchoice_mid", "type": "esriFieldTypeString", "alias": "secondchoice_mid", "length": 1500 }, { "name": "secondchoice_sa_mid", "type": "esriFieldTypeDouble", "alias": "secondchoice_sa_mid" }, { "name": "thirdchoice_mid", "type": "esriFieldTypeString", "alias": "thirdchoice_mid", "length": 1500 }, { "name": "thirdchoice_sa_mid", "type": "esriFieldTypeDouble", "alias": "thirdchoice_sa_mid" }, { "name": "sa_high", "type": "esriFieldTypeDouble", "alias": "sa_high" }, { "name": "secondchoice_high", "type": "esriFieldTypeString", "alias": "secondchoice_high", "length": 1500 }, { "name": "secondchoice_sa_high", "type": "esriFieldTypeDouble", "alias": "secondchoice_sa_high" }, { "name": "thirdchoice_high", "type": "esriFieldTypeString", "alias": "thirdchoice_high", "length": 1500 }, { "name": "thirdcoice_sa_high", "type": "esriFieldTypeDouble", "alias": "thirdcoice_sa_high" }, { "name": "secondchoice_school", "type": "esriFieldTypeString", "alias": "secondchoice_school", "length": 500 }, { "name": "thirdchoice_school", "type": "esriFieldTypeString", "alias": "thirdchoice_school", "length": 500 }, { "name": "secondchoice_mid_school", "type": "esriFieldTypeString", "alias": "secondchoice_mid_school", "length": 500 }, { "name": "thirdchoice_mid_school", "type": "esriFieldTypeString", "alias": "thirdchoice_mid_school", "length": 500 }, { "name": "secondchoice_high_school", "type": "esriFieldTypeString", "alias": "secondchoice_high_school", "length": 500 }, { "name": "thirdchoice_high_school", "type": "esriFieldTypeString", "alias": "thirdchoice_high_school", "length": 500 }, { "name": "dummy", "type": "esriFieldTypeSmallInteger", "alias": "dummy" }, { "name": "dummy2", "type": "esriFieldTypeInteger", "alias": "dummy2" }, { "name": "related", "type": "esriFieldTypeString", "alias": "related", "length": 1500 } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "feature_service_url", "dataType": "GPString", "displayName": "Feature Service URL (Option 2)", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "school_level", "dataType": "GPString", "displayName": "School Level", "description": "", "direction": "esriGPParameterDirectionInput", "defaultValue": "Elementary", "parameterType": "esriGPParameterTypeRequired", "category": "", "choiceList": [ "Elementary", "Middle", "High" ] }, { "name": "output_excel", "dataType": "GPDataFile", "displayName": "Output Excel File", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": null, "parameterType": "esriGPParameterTypeDerived", "category": "" } ] }