{ "name": "PropertyTableToExcelAGOL", "displayName": "Property Table To Excel AGOL", "description": "This tool converts the GIS.Property Table to a Microsoft Office Excel files (.xls format).", "category": "", "helpUrl": "https://maps.kamloops.ca/arcgis/rest/directories/arcgisoutput/EOC/PropertyTableToExcelAGOL_GPServer/EOC_PropertyTableToExcelAGOL/PropertyTableToExcelAGOL.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "Input_Table", "dataType": "GPFeatureRecordSetLayer", "displayName": "Input Table", "description": "Input Table", "direction": "esriGPParameterDirectionInput", "defaultValue": { "displayFieldName": "", "geometryType": "esriGeometryPolygon", "spatialReference": { "wkid": 3157, "latestWkid": 3157 }, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 12 }, { "name": "PROPERTYTAXID", "type": "esriFieldTypeString", "alias": "PROPERTYTAXID", "length": 12 }, { "name": "LOTNO", "type": "esriFieldTypeString", "alias": "LOTNO", "length": 12 }, { "name": "BLOCKNO", "type": "esriFieldTypeString", "alias": "BLOCKNO", "length": 12 }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 40 }, { "name": "STREETNO", "type": "esriFieldTypeString", "alias": "STREETNO", "length": 6 }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "STREETNAME", "length": 40 }, { "name": "STREETNAMETYPE", "type": "esriFieldTypeString", "alias": "STREETNAMETYPE", "length": 6 }, { "name": "STREETSUFFIX", "type": "esriFieldTypeString", "alias": "STREETSUFFIX", "length": 1 }, { "name": "FEATUREAREA", "type": "esriFieldTypeDouble", "alias": "FEATUREAREA" }, { "name": "GLOBALID", "type": "esriFieldTypeGUID", "alias": "GLOBALID", "length": 38 }, { "name": "PLANID", "type": "esriFieldTypeInteger", "alias": "PLANID" }, { "name": "PLANNUMBER", "type": "esriFieldTypeString", "alias": "PLANNUMBER", "length": 128 }, { "name": "PIN", "type": "esriFieldTypeInteger", "alias": "PIN" }, { "name": "PID", "type": "esriFieldTypeString", "alias": "PID", "length": 11 }, { "name": "PARCELSTATUS", "type": "esriFieldTypeString", "alias": "PARCELSTATUS", "length": 20 }, { "name": "PARCELCLASS", "type": "esriFieldTypeString", "alias": "PARCELCLASS", "length": 50 }, { "name": "ISREMAINDER", "type": "esriFieldTypeString", "alias": "ISREMAINDER", "length": 3 }, { "name": "POSITIONALERROR", "type": "esriFieldTypeDouble", "alias": "POSITIONALERROR" }, { "name": "LEGALDESCRIPTION", "type": "esriFieldTypeString", "alias": "LEGALDESCRIPTION", "length": 2000 }, { "name": "OWNERTYPE", "type": "esriFieldTypeString", "alias": "OWNERTYPE", "length": 50 }, { "name": "STATEDAREA", "type": "esriFieldTypeString", "alias": "STATEDAREA", "length": 50 }, { "name": "FOLIO", "type": "esriFieldTypeString", "alias": "FOLIO", "length": 255 }, { "name": "STREETFRONTPHOTOURL", "type": "esriFieldTypeString", "alias": "STREETFRONTPHOTOURL", "length": 100 }, { "name": "PROPERTYREPORTURL", "type": "esriFieldTypeString", "alias": "PROPERTYREPORTURL", "length": 100 }, { "name": "OBLIQUEIMAGEURL", "type": "esriFieldTypeString", "alias": "OBLIQUEIMAGEURL", "length": 100 }, { "name": "CLASSIFICATION", "type": "esriFieldTypeString", "alias": "CLASSIFICATION", "length": 25 }, { "name": "UNIT", "type": "esriFieldTypeString", "alias": "UNIT", "length": 10 }, { "name": "GISLINK", "type": "esriFieldTypeString", "alias": "GISLINK", "length": 16 }, { "name": "PROPERTYCOUNT", "type": "esriFieldTypeDouble", "alias": "PROPERTYCOUNT" }, { "name": "DWELLINGCOUNT", "type": "esriFieldTypeDouble", "alias": "DWELLINGCOUNT" }, { "name": "PROPERTYDWELLINGCOUNT", "type": "esriFieldTypeDouble", "alias": "PROPERTYDWELLINGCOUNT" }, { "name": "ACTUALUSEDESC", "type": "esriFieldTypeString", "alias": "ACTUALUSEDESC", "length": 49 }, { "name": "ACTUALUSEGROUP", "type": "esriFieldTypeString", "alias": "ACTUALUSEGROUP", "length": 50 }, { "name": "POPULATIONDWELLINGAVG", "type": "esriFieldTypeDouble", "alias": "POPULATIONDWELLINGAVG" }, { "name": "POPULATION", "type": "esriFieldTypeDouble", "alias": "POPULATION" }, { "name": "PROPERTYPOPULATION", "type": "esriFieldTypeDouble", "alias": "PROPERTYPOPULATION" }, { "name": "SURFACEPOPULATION", "type": "esriFieldTypeDouble", "alias": "SURFACEPOPULATION" }, { "name": "TIMEPOPULATION", "type": "esriFieldTypeDouble", "alias": "TIMEPOPULATION" }, { "name": "TIMEPOPULATIONDATE", "type": "esriFieldTypeDate", "alias": "TIMEPOPULATIONDATE", "length": 8 }, { "name": "FUTUREPOPULATION", "type": "esriFieldTypeDouble", "alias": "FUTUREPOPULATION" }, { "name": "SHAPE_Length", "type": "esriFieldTypeDouble", "alias": "SHAPE_Length" }, { "name": "SHAPE_Area", "type": "esriFieldTypeDouble", "alias": "SHAPE_Area" } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeRequired", "category": "" }, { "name": "Output_Excel_File", "dataType": "GPDataFile", "displayName": "Output Excel File", "description": "Output Excel File", "direction": "esriGPParameterDirectionOutput", "defaultValue": null, "parameterType": "esriGPParameterTypeRequired", "category": "" } ] }