Display Name: 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:

Help URL: https://gis.drmp.com/arcgis/rest/directories/arcgisoutput/Feature_Service_to_Excel_GPServer/Feature_Service_to_Excel/ExportFeatureService.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: input_feature_layer

Data Type: GPFeatureRecordSetLayer
Display Name Input Feature Layer (Option 1)
Description:
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value:
Geometry Type: esriGeometryPoint
HasZ: false
HasM: false
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)
Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: fid )
• id ( type: esriFieldTypeInteger, alias: ID )
• date_creat ( type: esriFieldTypeString, alias: DATE_CREAT, length: 24 )
• app_type ( type: esriFieldTypeInteger, alias: APP_TYPE )
• app_type_d ( type: esriFieldTypeString, alias: APP_TYPE_D, length: 1000 )
• cap_app_id ( type: esriFieldTypeInteger, alias: CAP_APP_ID )
• full_cap_a ( type: esriFieldTypeString, alias: FULL_CAP_A, length: 254 )
• app_status ( type: esriFieldTypeInteger, alias: APP_STATUS )
• app_stat_1 ( type: esriFieldTypeString, alias: APP_STAT_1, length: 30 )
• jur_id ( type: esriFieldTypeInteger, alias: JUR_ID )
• jur_id_d ( type: esriFieldTypeString, alias: JUR_ID_D, length: 50 )
• pro_id ( type: esriFieldTypeString, alias: PRO_ID, length: 254 )
• per_name ( type: esriFieldTypeString, alias: PER_NAME, length: 254 )
• pro_name ( type: esriFieldTypeString, alias: PRO_NAME, length: 254 )
• pro_phase ( type: esriFieldTypeString, alias: PRO_PHASE, length: 254 )
• pro_sha_ag ( type: esriFieldTypeString, alias: PRO_SHA_AG, length: 254 )
• pro_org_p ( type: esriFieldTypeString, alias: PRO_ORG_P, length: 254 )
• pro_pre_na ( type: esriFieldTypeString, alias: PRO_PRE_NA, length: 254 )
• pro_addres ( type: esriFieldTypeString, alias: PRO_ADDRES, length: 254 )
• pro_city ( type: esriFieldTypeInteger, alias: PRO_CITY )
• pro_city_d ( type: esriFieldTypeString, alias: PRO_CITY_D, length: 30 )
• pro_state ( type: esriFieldTypeString, alias: PRO_STATE, length: 254 )
• pro_zip ( type: esriFieldTypeString, alias: PRO_ZIP, length: 5 )
• pro_zip4 ( type: esriFieldTypeString, alias: PRO_ZIP4, length: 4 )
• mul_id ( type: esriFieldTypeInteger, alias: MUL_ID )
• mul_id_d ( type: esriFieldTypeString, alias: MUL_ID_D, length: 30 )
• per_releas ( type: esriFieldTypeDouble, alias: PER_RELEAS )
• tot_sfa ( type: esriFieldTypeInteger, alias: TOT_SFA )
• tot_sfd ( type: esriFieldTypeInteger, alias: TOT_SFD )
• tot_mf ( type: esriFieldTypeInteger, alias: TOT_MF )
• tot_mh ( type: esriFieldTypeInteger, alias: TOT_MH )
• tot_els_s ( type: esriFieldTypeInteger, alias: TOT_ELS_S )
• tot_mls_s ( type: esriFieldTypeInteger, alias: TOT_MLS_S )
• tot_his_s ( type: esriFieldTypeInteger, alias: TOT_HIS_S )
• orig_fid ( type: esriFieldTypeInteger, alias: ORIG_FID )
• folio ( type: esriFieldTypeString, alias: FOLIO, length: 1000 )
• location ( type: esriFieldTypeString, alias: Lcation/Address, length: 256 )
• closestmajorintersection ( type: esriFieldTypeString, alias: Closest Major Intersection, length: 256 )
• mailingaddress ( type: esriFieldTypeString, alias: Mailing Address, length: 256 )
• telephonenumber ( type: esriFieldTypeString, alias: Telephone Number, length: 30 )
• email ( type: esriFieldTypeString, alias: Email, length: 100 )
• currentfuturelanduse ( type: esriFieldTypeString, alias: Current Future Land Use, length: 100 )
• currentzoning ( type: esriFieldTypeString, alias: Current Zoning, length: 50 )
• proposedfuturelanduse ( type: esriFieldTypeString, alias: Proposed Future Land Use, length: 100 )
• proposedzoning ( type: esriFieldTypeString, alias: Proposed Zoning, length: 50 )
• sfd_units ( type: esriFieldTypeInteger, alias: Single Family Detached Units )
• mf_units ( type: esriFieldTypeInteger, alias: Multi-Family Apartments )
• sfa_units ( type: esriFieldTypeInteger, alias: Single Family Attached Units )
• mh_units ( type: esriFieldTypeInteger, alias: MH_Units )
• totalacres ( type: esriFieldTypeDouble, alias: Total Acres )
• existingunits_onsite ( type: esriFieldTypeString, alias: Existing Occupied Units Onsite, length: 20 )
• numexistingunits ( type: esriFieldTypeInteger, alias: Number Of Existing Units )
• existingunittype ( type: esriFieldTypeString, alias: Existing Unit Type, length: 100 )
• schoolzones ( type: esriFieldTypeString, alias: School Zones, length: 1000 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• date_creat_converted ( type: esriFieldTypeDate, alias: date_creat_Converted, length: 8 )
• elem ( type: esriFieldTypeString, alias: Elementary, length: 256 )
• middle ( type: esriFieldTypeString, alias: Middle, length: 256 )
• high ( type: esriFieldTypeString, alias: High, length: 256 )
• eid ( type: esriFieldTypeString, alias: Elem ID, length: 256 )
• mid ( type: esriFieldTypeString, alias: Mid ID, length: 256 )
• hid ( type: esriFieldTypeString, alias: High ID , length: 256 )
• totess ( type: esriFieldTypeDouble, alias: Total ESS )
• totmss ( type: esriFieldTypeDouble, alias: Total MSS )
• tothss ( type: esriFieldTypeDouble, alias: Total HSS )
• stationelem ( type: esriFieldTypeDouble, alias: Station Elem )
• stationmid ( type: esriFieldTypeDouble, alias: Station Mid )
• stationhigh ( type: esriFieldTypeDouble, alias: Station High )
• remainingelem ( type: esriFieldTypeDouble, alias: Remaining Elem )
• remainingmid ( type: esriFieldTypeDouble, alias: Remaining Mid )
• remaininghigh ( type: esriFieldTypeDouble, alias: Remaining High )
• levelelem ( type: esriFieldTypeString, alias: Grade Level Elem, length: 256 )
• levelmid ( type: esriFieldTypeString, alias: Grade Level Mid, length: 256 )
• levelhigh ( type: esriFieldTypeString, alias: Grade Level High, length: 256 )
• per_release2020 ( type: esriFieldTypeDouble, alias: % Release 2020 )
• per_release2021 ( type: esriFieldTypeDouble, alias: % Release 2021 )
• change21vs20 ( type: esriFieldTypeDouble, alias: Change 21 vs 20 )
• per_release2022 ( type: esriFieldTypeDouble, alias: % Release 2022 )
• change22vs21 ( type: esriFieldTypeDouble, alias: Change 22 vs 21 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• pkenrolleid ( type: esriFieldTypeDouble, alias: pkenrolleid )
• pkenrollmid ( type: esriFieldTypeDouble, alias: pkenrollmid )
• pkenrollhid ( type: esriFieldTypeDouble, alias: pkenrollhid )
• k12enrolleid ( type: esriFieldTypeDouble, alias: k12enrolleid )
• k12enrollmid ( type: esriFieldTypeDouble, alias: k12enrollmid )
• k12enrollhid ( type: esriFieldTypeDouble, alias: k12enrollhid )
• fourtydayeid ( type: esriFieldTypeDouble, alias: fourtydayeid )
• fourtydaymid ( type: esriFieldTypeDouble, alias: fourtydaymid )
• fourtydayhid ( type: esriFieldTypeDouble, alias: fourtydayhid )
• fisheid ( type: esriFieldTypeDouble, alias: fisheid )
• fishmid ( type: esriFieldTypeDouble, alias: fishmid )
• fishhid ( type: esriFieldTypeDouble, alias: fishhid )
• remainingresevedeid ( type: esriFieldTypeDouble, alias: remainingresevedeid )
• remainingresevedmid ( type: esriFieldTypeDouble, alias: remainingresevedmid )
• remainingresevedehid ( type: esriFieldTypeDouble, alias: remainingresevedehid )
• totess2526 ( type: esriFieldTypeDouble, alias: totess2526 )
• totmss2526 ( type: esriFieldTypeDouble, alias: totmss2526 )
• tothss2526 ( type: esriFieldTypeDouble, alias: tothss2526 )
• per_rel_24 ( type: esriFieldTypeString, alias: per_rel_24, length: 255 )
• perrel2 ( type: esriFieldTypeDouble, alias: perrel2 )
• per_release2023 ( type: esriFieldTypeDouble, alias: per_release2023 )
• change22vs23 ( type: esriFieldTypeDouble, alias: change22vs23 )
• change24vs23 ( type: esriFieldTypeDouble, alias: change24vs23 )
• guid_official ( type: esriFieldTypeString, alias: guid_official, length: 1500 )
• unreleasedeid ( type: esriFieldTypeDouble, alias: Unreleased EID )
• unreleasedmid ( type: esriFieldTypeDouble, alias: Unreleased MID )
• unreleasedhid ( type: esriFieldTypeDouble, alias: Unreleased HID )
• sa ( type: esriFieldTypeDouble, alias: sa )
• secondchoice_sa ( type: esriFieldTypeDouble, alias: secondchoice_sa )
• secondchoice ( type: esriFieldTypeString, alias: secondchoice, length: 1500 )
• thirdchoice_sa ( type: esriFieldTypeDouble, alias: thirdchoice_sa )
• thirdchoice ( type: esriFieldTypeString, alias: thirdchoice, length: 1500 )
• ow ( type: esriFieldTypeDouble, alias: ow )
• sa_mid ( type: esriFieldTypeDouble, alias: sa_mid )
• secondchoice_mid ( type: esriFieldTypeString, alias: secondchoice_mid, length: 1500 )
• secondchoice_sa_mid ( type: esriFieldTypeDouble, alias: secondchoice_sa_mid )
• thirdchoice_mid ( type: esriFieldTypeString, alias: thirdchoice_mid, length: 1500 )
• thirdchoice_sa_mid ( type: esriFieldTypeDouble, alias: thirdchoice_sa_mid )
• sa_high ( type: esriFieldTypeDouble, alias: sa_high )
• secondchoice_high ( type: esriFieldTypeString, alias: secondchoice_high, length: 1500 )
• secondchoice_sa_high ( type: esriFieldTypeDouble, alias: secondchoice_sa_high )
• thirdchoice_high ( type: esriFieldTypeString, alias: thirdchoice_high, length: 1500 )
• thirdcoice_sa_high ( type: esriFieldTypeDouble, alias: thirdcoice_sa_high )
• secondchoice_school ( type: esriFieldTypeString, alias: secondchoice_school, length: 500 )
• thirdchoice_school ( type: esriFieldTypeString, alias: thirdchoice_school, length: 500 )
• secondchoice_mid_school ( type: esriFieldTypeString, alias: secondchoice_mid_school, length: 500 )
• thirdchoice_mid_school ( type: esriFieldTypeString, alias: thirdchoice_mid_school, length: 500 )
• secondchoice_high_school ( type: esriFieldTypeString, alias: secondchoice_high_school, length: 500 )
• thirdchoice_high_school ( type: esriFieldTypeString, alias: thirdchoice_high_school, length: 500 )
• dummy ( type: esriFieldTypeSmallInteger, alias: dummy )
• dummy2 ( type: esriFieldTypeInteger, alias: dummy2 )
• related ( type: esriFieldTypeString, alias: related, length: 1500 )
Features: None.


Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: feature_service_url

Data Type: GPString
Display Name Feature Service URL (Option 2)
Description:
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: school_level

Data Type: GPString
Display Name School Level
Description:
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value: Elementary
Parameter Type: esriGPParameterTypeRequired
Category:
Choice List: [ Elementary, Middle, High ]


Parameter: output_excel

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

Supported Operations:   Submit Job

Child Resources:   Metadata