{ "tables": [ { "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": true, "relationships": [ { "keyField": "parentglobalid", "role": "esriRelRoleDestination", "composite": true, "name": "", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "supportsTilesAndBasicQueriesMode ": true, "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "ROW Permit Comment", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "instructions": null, "parentglobalid": null, "address": null, "comments": null, "actiontaken": null, "organization": null, "name": null, "submitdate": null, "publicview": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "ROW_Permit_Comment", "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 150, "alias": "Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 255, "alias": "Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_organization_3", "type": "codedValue", "codedValues": [ { "code": "PublicWorks", "name": "Public Works" }, { "code": "ParksRec", "name": "Parks & Recreation" }, { "code": "PlanningDev", "name": "Planning & Development" }, { "code": "Transportation", "name": "Transportation" }, { "code": "WaterSewer", "name": "Water & Sewer" }, { "code": "GeneralPublic", "name": "General Public" }, { "code": "Other", "name": "Other" } ] }, "name": "organization", "length": 50, "alias": "Organization", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 1000, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "instructions", "length": 1000, "alias": "Any Instructions", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_actiontaken_3", "type": "codedValue", "codedValues": [ { "code": "UnderReview", "name": "Under Review" }, { "code": "MoreInformationRequired", "name": "More Information Required" }, { "code": "Approved", "name": "Approved" }, { "code": "Denied", "name": "Denied" } ] }, "name": "actiontaken", "length": 35, "alias": "Action Taken", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_yesno_4", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "publicview", "length": 5, "alias": "Public View", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "submitdate", "length": 29, "alias": "Submission Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parentglobalid", "length": 38, "alias": "ParentGlobalID", "type": "esriFieldTypeGUID" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "last_edited_date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "supportsTruncate": false, "indexes": [ { "name": "r41_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_41", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "23dd08e07c3944009a7da0a28d524582", "supportsValidateSql": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Editing,Sync,Extract,Uploads", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "supportsLayerOverrides ": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "uniqueIdField": { "isSystemMaintained": true, "name": "OBJECTID" }, "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "supportsLayerOverrides": true } ], "layers": [ { "extent": { "ymin": 5412637.762957121, "xmin": -1.0351432469630145E7, "ymax": 5413637.956542285, "xmax": -1.034967362167561E7, "spatialReference": {"wkid": 102100} }, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "attachmentid", "isEnabled": true, "name": "id" }, { "fieldName": "globalid", "isEnabled": true, "name": "globalId" }, { "fieldName": "att_name", "isEnabled": true, "name": "name" }, { "fieldName": "data_size", "isEnabled": true, "name": "size" }, { "fieldName": "content_type", "isEnabled": true, "name": "contentType" }, { "fieldName": "keywords", "isEnabled": true, "name": "keywords" }, { "fieldName": "exifinfo", "isEnabled": true, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "attachmentid", "alias": "attachmentid", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 38, "name": "globalid", "alias": "globalid", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 250, "name": "att_name", "alias": "att_name", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "data_size", "alias": "data_size", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "length": 150, "name": "content_type", "alias": "content_type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 2048, "name": "keywords", "alias": "keywords", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 1073741822, "name": "exifinfo", "alias": "exifinfo", "type": "esriFieldTypeString" } ], "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "hasStaticData": false, "supportsAttachmentsByUploadId": true, "syncEnabled": true, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": true, "name": "", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "hasViews": true, "supportsAttachmentsResizing": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "supportsTilesAndBasicQueriesMode ": true, "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "currentVersion": 11.3, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "ROW Permits", "displayField": "appname", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "length": 4, "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appname", "length": 150, "alias": "Applicant Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appaddr", "length": 255, "alias": "Applicant Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appcity", "length": 255, "alias": "Applicant City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_state", "type": "codedValue", "codedValues": [ { "code": "AL", "name": "AL" }, { "code": "AK", "name": "AK" }, { "code": "AZ", "name": "AZ" }, { "code": "AR", "name": "AR" }, { "code": "CA", "name": "CA" }, { "code": "CO", "name": "CO" }, { "code": "CT", "name": "CT" }, { "code": "DE", "name": "DE" }, { "code": "FL", "name": "FL" }, { "code": "GA", "name": "GA" }, { "code": "HI", "name": "HI" }, { "code": "ID", "name": "ID" }, { "code": "IL", "name": "IL" }, { "code": "IN", "name": "IN" }, { "code": "IA", "name": "IA" }, { "code": "KS", "name": "KS" }, { "code": "KY", "name": "KY" }, { "code": "LA", "name": "LA" }, { "code": "ME", "name": "ME" }, { "code": "MD", "name": "MD" }, { "code": "MA", "name": "MA" }, { "code": "MI", "name": "MI" }, { "code": "MN", "name": "MN" }, { "code": "MS", "name": "MS" }, { "code": "MO", "name": "MO" }, { "code": "MT", "name": "MT" }, { "code": "NE", "name": "NE" }, { "code": "NV", "name": "NV" }, { "code": "NH", "name": "NH" }, { "code": "NJ", "name": "NJ" }, { "code": "NM", "name": "NM" }, { "code": "NY", "name": "NY" }, { "code": "NC", "name": "NC" }, { "code": "ND", "name": "ND" }, { "code": "OH", "name": "OH" }, { "code": "OK", "name": "OK" }, { "code": "OR", "name": "OR" }, { "code": "PA", "name": "PA" }, { "code": "RI", "name": "RI" }, { "code": "SC", "name": "SC" }, { "code": "SD", "name": "SD" }, { "code": "TN", "name": "TN" }, { "code": "TX", "name": "TX" }, { "code": "UT", "name": "UT" }, { "code": "VT", "name": "VT" }, { "code": "VA", "name": "VA" }, { "code": "WA", "name": "WA" }, { "code": "WV", "name": "WV" }, { "code": "WI", "name": "WI" }, { "code": "WY", "name": "WY" } ] }, "name": "appstate", "length": 2, "alias": "Applicant State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appzip", "length": 5, "alias": "Applicant Zip", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appphone", "length": 15, "alias": "Applicant Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "appemail", "length": 100, "alias": "Applicant Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_yesno", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "sameapp", "length": 5, "alias": "Contractor Same as Applicant", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contname", "length": 150, "alias": "Contractor Company Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contaddr", "length": 255, "alias": "Contractor Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contcity", "length": 255, "alias": "Contractor City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_state", "type": "codedValue", "codedValues": [ { "code": "AL", "name": "AL" }, { "code": "AK", "name": "AK" }, { "code": "AZ", "name": "AZ" }, { "code": "AR", "name": "AR" }, { "code": "CA", "name": "CA" }, { "code": "CO", "name": "CO" }, { "code": "CT", "name": "CT" }, { "code": "DE", "name": "DE" }, { "code": "FL", "name": "FL" }, { "code": "GA", "name": "GA" }, { "code": "HI", "name": "HI" }, { "code": "ID", "name": "ID" }, { "code": "IL", "name": "IL" }, { "code": "IN", "name": "IN" }, { "code": "IA", "name": "IA" }, { "code": "KS", "name": "KS" }, { "code": "KY", "name": "KY" }, { "code": "LA", "name": "LA" }, { "code": "ME", "name": "ME" }, { "code": "MD", "name": "MD" }, { "code": "MA", "name": "MA" }, { "code": "MI", "name": "MI" }, { "code": "MN", "name": "MN" }, { "code": "MS", "name": "MS" }, { "code": "MO", "name": "MO" }, { "code": "MT", "name": "MT" }, { "code": "NE", "name": "NE" }, { "code": "NV", "name": "NV" }, { "code": "NH", "name": "NH" }, { "code": "NJ", "name": "NJ" }, { "code": "NM", "name": "NM" }, { "code": "NY", "name": "NY" }, { "code": "NC", "name": "NC" }, { "code": "ND", "name": "ND" }, { "code": "OH", "name": "OH" }, { "code": "OK", "name": "OK" }, { "code": "OR", "name": "OR" }, { "code": "PA", "name": "PA" }, { "code": "RI", "name": "RI" }, { "code": "SC", "name": "SC" }, { "code": "SD", "name": "SD" }, { "code": "TN", "name": "TN" }, { "code": "TX", "name": "TX" }, { "code": "UT", "name": "UT" }, { "code": "VT", "name": "VT" }, { "code": "VA", "name": "VA" }, { "code": "WA", "name": "WA" }, { "code": "WV", "name": "WV" }, { "code": "WI", "name": "WI" }, { "code": "WY", "name": "WY" } ] }, "name": "contstate", "length": 2, "alias": "Contractor State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contzip", "length": 5, "alias": "Contractor Zip", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contphone", "length": 15, "alias": "Contractor Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contemail", "length": 100, "alias": "Contractor Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "contlicense", "length": 50, "alias": "Contractor License #", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "project", "length": 255, "alias": "Project", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_type", "type": "codedValue", "codedValues": [ { "code": "Alterations", "name": "Surface or Sub-surface Alterations" }, { "code": "Temporary", "name": "Temporary Use" }, { "code": "Encroachment", "name": "Encroachment" } ] }, "name": "type", "length": 15, "alias": "Permit Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subtype", "length": 255, "alias": "Permit Subtype", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subtypeother", "length": 255, "alias": "Permit Subtype Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 1000, "alias": "Description of Work", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "propstartdt", "length": 29, "alias": "Proposed Start Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "propenddt", "length": 29, "alias": "Proposed Completion Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_yesno", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "laneclosure", "length": 5, "alias": "Lane Closure Required", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_status", "type": "codedValue", "codedValues": [ { "code": "Submitted", "name": "Submitted" }, { "code": "StaffReview", "name": "Staff Review" }, { "code": "BoardReview", "name": "Board Review" }, { "code": "Approved", "name": "Approved" }, { "code": "Denied", "name": "Denied" } ] }, "name": "status", "length": 35, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "submitdt", "length": 29, "alias": "Submission Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "actiondt", "length": 29, "alias": "Approved or Denied Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "apprstartdt", "length": 29, "alias": "Approved Start Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "precision": 1, "name": "apprenddt", "length": 29, "alias": "Approved Completion Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWPermits_yesno", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ] }, "name": "moreinfo", "length": 5, "alias": "More Information Required", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 1000, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "created_user", "alias": "Creator", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "created_date", "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "length": 255, "name": "last_edited_user", "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": true, "editable": false, "defaultValue": null, "domain": null, "precision": 1, "length": 29, "name": "last_edited_date", "alias": "EditDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "permit_type", "length": 50, "alias": "Permit Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_contact_person", "length": 150, "alias": "Contact Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exca_contact_add", "length": 255, "alias": "Contact Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_contact_phone", "length": 15, "alias": "Contact Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_contact_email", "length": 100, "alias": "Contact Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_is_app_owner", "length": 5, "alias": "Is Applicant the Utility Owner", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_utility_owner", "length": 100, "alias": "Utility Owner", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_utility_type", "length": 100, "alias": "Utility Type", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_utility_type_other", "length": 255, "alias": "Utility Type Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_install_purp", "length": 100, "alias": "Installation Purpose", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_install_purp_other", "length": 255, "alias": "Installation Purpose Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_install_method", "length": 100, "alias": "Installation Method", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_install_method_other", "length": 255, "alias": "Installation Method Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_material", "length": 40, "alias": "Material", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_work_descrip", "length": 1000, "alias": "Brief Description of Work", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "exca_start", "length": 29, "alias": "Start Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "exca_end", "length": 29, "alias": "Estimated Completion Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_closure_req", "length": 5, "alias": "Street Closure Required", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_detour_req", "length": 5, "alias": "Street Detour Required", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_app_name", "length": 150, "alias": "Applicant Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_app_phone", "length": 15, "alias": "Applicant Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_contact_name", "length": 150, "alias": "Contact Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_contact_phone", "length": 15, "alias": "Contact Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_contact_email", "length": 100, "alias": "Contact Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_reason", "length": 500, "alias": "Reason for Closure", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "lane_start", "length": 29, "alias": "Start Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "lane_end", "length": 29, "alias": "Estimated End Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_add_strucs", "length": 5, "alias": "Additional Structures", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_app_num", "length": 100, "alias": "List Application Numbers", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_app_name", "length": 150, "alias": "Applicant Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_company", "length": 150, "alias": "Company or Individual Performing Move", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_app_phone", "length": 15, "alias": "Applicant Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_app_cell", "length": 15, "alias": "Applicant Cell Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_app_email", "length": 100, "alias": "Applicant Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "house_date", "length": 29, "alias": "Scheduled Date of Move", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_building_moved", "length": 50, "alias": "Building to be Moved", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_building_moved_other", "length": 50, "alias": "Building to be Moved Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_location", "length": 255, "alias": "Present House Location", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_destin", "length": 255, "alias": "House Destination Location", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_contact_name", "length": 150, "alias": "Contact Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_contact_add", "length": 255, "alias": "Contact Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_contact_phone", "length": 15, "alias": "Contact Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_contact_email", "length": 100, "alias": "Contact Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_items", "length": 255, "alias": "Item(s) Being Transported", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "over_date", "length": 29, "alias": "Date of Transport", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_destin", "length": 255, "alias": "Destination of Transported Item(s)", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_contact_name", "length": 150, "alias": "Contact Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_contact_phone", "length": 15, "alias": "Contact Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_contact_email", "length": 100, "alias": "Contact Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_address", "length": 255, "alias": "Address of Dumpster", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "dump_install_date", "length": 29, "alias": "Date of Dumpster Installation", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "dump_remove_date", "length": 29, "alias": "Date of Dumpster Removal", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_company", "length": 100, "alias": "Company Providing Dumpster", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_org_name", "length": 100, "alias": "Organization Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_org_add", "length": 255, "alias": "Organization Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_contact_name", "length": 150, "alias": "Contact Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_contact_email", "length": 150, "alias": "Contact Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_contact_phone", "length": 15, "alias": "Contact Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_contact_cell", "length": 15, "alias": "Contact Cell Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_alt_name", "length": 150, "alias": "Alternate Contact Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_alt_email", "length": 150, "alias": "Alternate Contact Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_alt_phone", "length": 15, "alias": "Alternate Contact Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_alt_cell", "length": 15, "alias": "Alternate Contact Cell Phone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_title", "length": 150, "alias": "Event Title", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "event_startdt", "length": 29, "alias": "Event Start Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "event_enddt", "length": 29, "alias": "Event End Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_num", "alias": "Approximate Number of Participants", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_starttime", "length": 50, "alias": "Event Start Time", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_endtime", "length": 50, "alias": "Estimated Event End Time", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_startpt", "length": 150, "alias": "Event Starting Point", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_endpt", "length": 150, "alias": "Event End Point", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_portion", "length": 500, "alias": "Portion of Street Width", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_address", "length": 255, "alias": "Installation Address of Water Sprinkler System", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "signatureprint", "length": 255, "alias": "Print Name", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_dis_surface_other", "length": 255, "alias": "Surface to be Disturbed Other", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_size", "alias": "Size", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_install_len", "alias": "Installation Length", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_depth", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_height", "alias": "Structure Height", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_width", "alias": "Structure Width", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_length", "alias": "Structure Length", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_weight", "alias": "Structure Weight", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_axles", "alias": "Number of Axles", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_dis_surface", "length": 100, "alias": "Surface to be Disturbed", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": { "name": "ROWCOAstatus_1", "type": "codedValue", "codedValues": [ { "code": "Submitted", "name": "Submitted" }, { "code": "EngineerApproved", "name": "Engineer Approved" }, { "code": "PaymentRequested", "name": "Payment Requested" }, { "code": "CompleteSent", "name": "App Complete, Paid & Sent" }, { "code": "Denied", "name": "Denied" }, { "code": "Canceled", "name": "Canceled" } ] }, "name": "statuscoa", "length": 50, "alias": "Permit Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_contractor_person", "length": 255, "alias": "Contractor Contact Person", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_contact_city", "length": 255, "alias": "Contact City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_contact_state", "length": 2, "alias": "Contact State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "exca_contact_zip", "length": 5, "alias": "Contact Zipcode", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_contact_city", "length": 255, "alias": "Contact City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_contact_state", "length": 2, "alias": "Contact State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "over_contact_zip", "length": 5, "alias": "Contact Zipcode", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "event_org_city", "length": 255, "alias": "Organization City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_org_state", "length": 2, "alias": "Organization State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_org_zip", "length": 5, "alias": "Organization Zipcode", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "payrequest_date", "length": 29, "alias": "Payment Requested Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "permitsent_date", "length": 29, "alias": "Permit Sent Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "approvedenyby", "length": 255, "alias": "Person Approved or Denied Permit", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "permitfee", "length": 25, "alias": "Permit Fee", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_contact_add", "length": 255, "alias": "Applicant Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_contact_city", "length": 255, "alias": "Applicant City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_contact_state", "length": 2, "alias": "Applicant State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_contact_zip", "length": 5, "alias": "Applicant Zipcode", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "water_contact_email", "length": 100, "alias": "Applicant Email", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_contact_add", "length": 255, "alias": "Contact Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_contact_city", "length": 255, "alias": "Contact City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_contact_state", "length": 2, "alias": "Contact State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "lane_contact_zip", "length": 5, "alias": "Contact Zipcode", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_contact_add", "length": 255, "alias": "Contact Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_contact_city", "length": 255, "alias": "Contact City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_contact_state", "length": 2, "alias": "Contact State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "house_contact_zip", "length": 5, "alias": "Contact Zipcode", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_contact_add", "length": 255, "alias": "Contact Address", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_contact_city", "length": 255, "alias": "Contact City", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_contact_state", "length": 2, "alias": "Contact State", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "dump_contact_zip", "length": 5, "alias": "Contact Zipcode", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "permitnumber", "length": 20, "alias": "Permit Number", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_traffic", "length": 50, "alias": "Traffic Control Barricades Needed for Street/Lane Closure?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "event_traffic_needed", "length": 50, "alias": "Will Traffic Control Barricades be Provided by Applicant or City?", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "pdapprovedenyby", "length": 256, "alias": "Police Approved or Denied Permit", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "pdactiondt", "length": 29, "alias": "Police Approved or Denied Date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "pdcomments", "length": 1000, "alias": "Police Comments", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "PermitApplication", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "r39_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_39", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a15_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": true, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "serviceItemId": "23dd08e07c3944009a7da0a28d524582", "supportsValidateSql": true, "supportsValidateSQL": true, "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "App Complete, Paid & Sent", "description": "", "prototype": { "attributes": { "event_org_add": null, "lane_contact_phone": null, "house_height": null, "exca_install_len": null, "exca_contact_state": null, "over_date": null, "exca_dis_surface": null, "event_traffic": null, "pdapprovedenyby": null, "apprstartdt": null, "exca_utility_type": null, "over_contact_zip": null, "house_axles": null, "type": null, "contaddr": null, "actiondt": null, "water_contact_city": null, "contemail": null, "event_starttime": null, "house_destin": null, "exca_install_purp_other": null, "event_startdt": null, "contzip": null, "contstate": null, "pdcomments": null, "house_app_email": null, "over_contact_email": null, "house_length": null, "pdactiondt": null, "appaddr": null, "exca_material": null, "lane_contact_add": null, "exca_install_method": null, "approvedenyby": null, "exca_contact_add": null, "contphone": null, "exca_contact_person": null, "lane_contact_state": null, "over_destin": null, "exca_contact_phone": null, "exca_is_app_owner": null, "exca_contact_email": null, "house_app_cell": null, "event_contact_name": null, "house_width": null, "water_app_name": null, "water_contact_add": null, "exca_utility_owner": null, "event_endpt": null, "status": null, "event_contact_phone": null, "lane_contact_email": null, "over_contact_phone": null, "event_org_name": null, "house_building_moved": null, "over_contact_city": null, "house_app_num": null, "over_items": null, "dump_contact_add": null, "exca_contact_city": null, "event_contact_cell": null, "permitsent_date": null, "house_contact_add": null, "dump_install_date": null, "exca_detour_req": null, "exca_install_purp": null, "submitdt": null, "dump_company": null, "contlicense": null, "appphone": null, "lane_start": null, "house_contact_state": null, "house_app_phone": null, "house_location": null, "propstartdt": null, "event_traffic_needed": null, "exca_depth": null, "moreinfo": null, "house_contact_city": null, "event_org_zip": null, "appzip": null, "event_num": null, "event_alt_cell": null, "project": null, "over_contact_add": null, "event_contact_email": null, "contname": null, "subtypeother": null, "water_app_phone": null, "appname": null, "dump_contact_phone": null, "event_alt_phone": null, "payrequest_date": null, "event_startpt": null, "exca_size": null, "lane_contact_zip": null, "lane_end": null, "appstate": null, "house_company": null, "event_alt_name": null, "exca_contact_zip": null, "exca_work_descrip": null, "exca_dis_surface_other": null, "event_org_city": null, "dump_contact_city": null, "event_title": null, "apprenddt": null, "contcity": null, "event_endtime": null, "lane_reason": null, "water_contact_state": null, "appcity": null, "water_contact_zip": null, "exca_utility_type_other": null, "water_address": null, "permitfee": null, "event_enddt": null, "propenddt": null, "lane_contact_name": null, "description": null, "dump_contact_email": null, "house_building_moved_other": null, "house_weight": null, "event_portion": null, "over_contact_state": null, "dump_contact_zip": null, "subtype": null, "over_contact_name": null, "exca_closure_req": null, "dump_remove_date": null, "statuscoa": "CompleteSent", "exca_end": null, "sameapp": null, "house_contact_zip": null, "water_contact_email": null, "comments": null, "house_app_name": null, "dump_contact_state": null, "lane_contact_city": null, "signatureprint": null, "exca_contractor_person": null, "house_add_strucs": null, "permit_type": null, "dump_address": null, "exca_start": null, "exca_install_method_other": null, "event_alt_email": null, "dump_contact_name": null, "permitnumber": null, "house_date": null, "appemail": null, "laneclosure": null, "event_org_state": null } } } ], "name": "App Complete, Paid & Sent", "id": "CompleteSent" }, { "templates": [ { "name": "Payment Requested", "description": "", "prototype": { "attributes": { "event_org_add": null, "lane_contact_phone": null, "house_height": null, "exca_install_len": null, "exca_contact_state": null, "over_date": null, "exca_dis_surface": null, "event_traffic": null, "pdapprovedenyby": null, "apprstartdt": null, "exca_utility_type": null, "over_contact_zip": null, "house_axles": null, "type": null, "contaddr": null, "actiondt": null, "water_contact_city": null, "contemail": null, "event_starttime": null, "house_destin": null, "exca_install_purp_other": null, "event_startdt": null, "contzip": null, "contstate": null, "pdcomments": null, "house_app_email": null, "over_contact_email": null, "house_length": null, "pdactiondt": null, "appaddr": null, "exca_material": null, "lane_contact_add": null, "exca_install_method": null, "approvedenyby": null, "exca_contact_add": null, "contphone": null, "exca_contact_person": null, "lane_contact_state": null, "over_destin": null, "exca_contact_phone": null, "exca_is_app_owner": null, "exca_contact_email": null, "house_app_cell": null, "event_contact_name": null, "house_width": null, "water_app_name": null, "water_contact_add": null, "exca_utility_owner": null, "event_endpt": null, "status": null, "event_contact_phone": null, "lane_contact_email": null, "over_contact_phone": null, "event_org_name": null, "house_building_moved": null, "over_contact_city": null, "house_app_num": null, "over_items": null, "dump_contact_add": null, "exca_contact_city": null, "event_contact_cell": null, "permitsent_date": null, "house_contact_add": null, "dump_install_date": null, "exca_detour_req": null, "exca_install_purp": null, "submitdt": null, "dump_company": null, "contlicense": null, "appphone": null, "lane_start": null, "house_contact_state": null, "house_app_phone": null, "house_location": null, "propstartdt": null, "event_traffic_needed": null, "exca_depth": null, "moreinfo": null, "house_contact_city": null, "event_org_zip": null, "appzip": null, "event_num": null, "event_alt_cell": null, "project": null, "over_contact_add": null, "event_contact_email": null, "contname": null, "subtypeother": null, "water_app_phone": null, "appname": null, "dump_contact_phone": null, "event_alt_phone": null, "payrequest_date": null, "event_startpt": null, "exca_size": null, "lane_contact_zip": null, "lane_end": null, "appstate": null, "house_company": null, "event_alt_name": null, "exca_contact_zip": null, "exca_work_descrip": null, "exca_dis_surface_other": null, "event_org_city": null, "dump_contact_city": null, "event_title": null, "apprenddt": null, "contcity": null, "event_endtime": null, "lane_reason": null, "water_contact_state": null, "appcity": null, "water_contact_zip": null, "exca_utility_type_other": null, "water_address": null, "permitfee": null, "event_enddt": null, "propenddt": null, "lane_contact_name": null, "description": null, "dump_contact_email": null, "house_building_moved_other": null, "house_weight": null, "event_portion": null, "over_contact_state": null, "dump_contact_zip": null, "subtype": null, "over_contact_name": null, "exca_closure_req": null, "dump_remove_date": null, "statuscoa": "PaymentRequested", "exca_end": null, "sameapp": null, "house_contact_zip": null, "water_contact_email": null, "comments": null, "house_app_name": null, "dump_contact_state": null, "lane_contact_city": null, "signatureprint": null, "exca_contractor_person": null, "house_add_strucs": null, "permit_type": null, "dump_address": null, "exca_start": null, "exca_install_method_other": null, "event_alt_email": null, "dump_contact_name": null, "permitnumber": null, "house_date": null, "appemail": null, "laneclosure": null, "event_org_state": null } } } ], "name": "Payment Requested", "id": "PaymentRequested" }, { "templates": [ { "name": "Denied", "description": "", "prototype": { "attributes": { "event_org_add": null, "lane_contact_phone": null, "house_height": null, "exca_install_len": null, "exca_contact_state": null, "over_date": null, "exca_dis_surface": null, "event_traffic": null, "pdapprovedenyby": null, "apprstartdt": null, "exca_utility_type": null, "over_contact_zip": null, "house_axles": null, "type": null, "contaddr": null, "actiondt": null, "water_contact_city": null, "contemail": null, "event_starttime": null, "house_destin": null, "exca_install_purp_other": null, "event_startdt": null, "contzip": null, "contstate": null, "pdcomments": null, "house_app_email": null, "over_contact_email": null, "house_length": null, "pdactiondt": null, "appaddr": null, "exca_material": null, "lane_contact_add": null, "exca_install_method": null, "approvedenyby": null, "exca_contact_add": null, "contphone": null, "exca_contact_person": null, "lane_contact_state": null, "over_destin": null, "exca_contact_phone": null, "exca_is_app_owner": null, "exca_contact_email": null, "house_app_cell": null, "event_contact_name": null, "house_width": null, "water_app_name": null, "water_contact_add": null, "exca_utility_owner": null, "event_endpt": null, "status": null, "event_contact_phone": null, "lane_contact_email": null, "over_contact_phone": null, "event_org_name": null, "house_building_moved": null, "over_contact_city": null, "house_app_num": null, "over_items": null, "dump_contact_add": null, "exca_contact_city": null, "event_contact_cell": null, "permitsent_date": null, "house_contact_add": null, "dump_install_date": null, "exca_detour_req": null, "exca_install_purp": null, "submitdt": null, "dump_company": null, "contlicense": null, "appphone": null, "lane_start": null, "house_contact_state": null, "house_app_phone": null, "house_location": null, "propstartdt": null, "event_traffic_needed": null, "exca_depth": null, "moreinfo": null, "house_contact_city": null, "event_org_zip": null, "appzip": null, "event_num": null, "event_alt_cell": null, "project": null, "over_contact_add": null, "event_contact_email": null, "contname": null, "subtypeother": null, "water_app_phone": null, "appname": null, "dump_contact_phone": null, "event_alt_phone": null, "payrequest_date": null, "event_startpt": null, "exca_size": null, "lane_contact_zip": null, "lane_end": null, "appstate": null, "house_company": null, "event_alt_name": null, "exca_contact_zip": null, "exca_work_descrip": null, "exca_dis_surface_other": null, "event_org_city": null, "dump_contact_city": null, "event_title": null, "apprenddt": null, "contcity": null, "event_endtime": null, "lane_reason": null, "water_contact_state": null, "appcity": null, "water_contact_zip": null, "exca_utility_type_other": null, "water_address": null, "permitfee": null, "event_enddt": null, "propenddt": null, "lane_contact_name": null, "description": null, "dump_contact_email": null, "house_building_moved_other": null, "house_weight": null, "event_portion": null, "over_contact_state": null, "dump_contact_zip": null, "subtype": null, "over_contact_name": null, "exca_closure_req": null, "dump_remove_date": null, "statuscoa": "Denied", "exca_end": null, "sameapp": null, "house_contact_zip": null, "water_contact_email": null, "comments": null, "house_app_name": null, "dump_contact_state": null, "lane_contact_city": null, "signatureprint": null, "exca_contractor_person": null, "house_add_strucs": null, "permit_type": null, "dump_address": null, "exca_start": null, "exca_install_method_other": null, "event_alt_email": null, "dump_contact_name": null, "permitnumber": null, "house_date": null, "appemail": null, "laneclosure": null, "event_org_state": null } } } ], "name": "Denied", "id": "Denied" }, { "templates": [ { "name": "Engineer Approved", "description": "", "prototype": { "attributes": { "event_org_add": null, "lane_contact_phone": null, "house_height": null, "exca_install_len": null, "exca_contact_state": null, "over_date": null, "exca_dis_surface": null, "event_traffic": null, "pdapprovedenyby": null, "apprstartdt": null, "exca_utility_type": null, "over_contact_zip": null, "house_axles": null, "type": null, "contaddr": null, "actiondt": null, "water_contact_city": null, "contemail": null, "event_starttime": null, "house_destin": null, "exca_install_purp_other": null, "event_startdt": null, "contzip": null, "contstate": null, "pdcomments": null, "house_app_email": null, "over_contact_email": null, "house_length": null, "pdactiondt": null, "appaddr": null, "exca_material": null, "lane_contact_add": null, "exca_install_method": null, "approvedenyby": null, "exca_contact_add": null, "contphone": null, "exca_contact_person": null, "lane_contact_state": null, "over_destin": null, "exca_contact_phone": null, "exca_is_app_owner": null, "exca_contact_email": null, "house_app_cell": null, "event_contact_name": null, "house_width": null, "water_app_name": null, "water_contact_add": null, "exca_utility_owner": null, "event_endpt": null, "status": null, "event_contact_phone": null, "lane_contact_email": null, "over_contact_phone": null, "event_org_name": null, "house_building_moved": null, "over_contact_city": null, "house_app_num": null, "over_items": null, "dump_contact_add": null, "exca_contact_city": null, "event_contact_cell": null, "permitsent_date": null, "house_contact_add": null, "dump_install_date": null, "exca_detour_req": null, "exca_install_purp": null, "submitdt": null, "dump_company": null, "contlicense": null, "appphone": null, "lane_start": null, "house_contact_state": null, "house_app_phone": null, "house_location": null, "propstartdt": null, "event_traffic_needed": null, "exca_depth": null, "moreinfo": null, "house_contact_city": null, "event_org_zip": null, "appzip": null, "event_num": null, "event_alt_cell": null, "project": null, "over_contact_add": null, "event_contact_email": null, "contname": null, "subtypeother": null, "water_app_phone": null, "appname": null, "dump_contact_phone": null, "event_alt_phone": null, "payrequest_date": null, "event_startpt": null, "exca_size": null, "lane_contact_zip": null, "lane_end": null, "appstate": null, "house_company": null, "event_alt_name": null, "exca_contact_zip": null, "exca_work_descrip": null, "exca_dis_surface_other": null, "event_org_city": null, "dump_contact_city": null, "event_title": null, "apprenddt": null, "contcity": null, "event_endtime": null, "lane_reason": null, "water_contact_state": null, "appcity": null, "water_contact_zip": null, "exca_utility_type_other": null, "water_address": null, "permitfee": null, "event_enddt": null, "propenddt": null, "lane_contact_name": null, "description": null, "dump_contact_email": null, "house_building_moved_other": null, "house_weight": null, "event_portion": null, "over_contact_state": null, "dump_contact_zip": null, "subtype": null, "over_contact_name": null, "exca_closure_req": null, "dump_remove_date": null, "statuscoa": "EngineerApproved", "exca_end": null, "sameapp": null, "house_contact_zip": null, "water_contact_email": null, "comments": null, "house_app_name": null, "dump_contact_state": null, "lane_contact_city": null, "signatureprint": null, "exca_contractor_person": null, "house_add_strucs": null, "permit_type": null, "dump_address": null, "exca_start": null, "exca_install_method_other": null, "event_alt_email": null, "dump_contact_name": null, "permitnumber": null, "house_date": null, "appemail": null, "laneclosure": null, "event_org_state": null } } } ], "name": "Engineer Approved", "id": "EngineerApproved" }, { "templates": [ { "name": "Submitted", "description": "", "prototype": { "attributes": { "event_org_add": null, "lane_contact_phone": null, "house_height": null, "exca_install_len": null, "exca_contact_state": null, "over_date": null, "exca_dis_surface": null, "event_traffic": null, "pdapprovedenyby": null, "apprstartdt": null, "exca_utility_type": null, "over_contact_zip": null, "house_axles": null, "type": null, "contaddr": null, "actiondt": null, "water_contact_city": null, "contemail": null, "event_starttime": null, "house_destin": null, "exca_install_purp_other": null, "event_startdt": null, "contzip": null, "contstate": null, "pdcomments": null, "house_app_email": null, "over_contact_email": null, "house_length": null, "pdactiondt": null, "appaddr": null, "exca_material": null, "lane_contact_add": null, "exca_install_method": null, "approvedenyby": null, "exca_contact_add": null, "contphone": null, "exca_contact_person": null, "lane_contact_state": null, "over_destin": null, "exca_contact_phone": null, "exca_is_app_owner": null, "exca_contact_email": null, "house_app_cell": null, "event_contact_name": null, "house_width": null, "water_app_name": null, "water_contact_add": null, "exca_utility_owner": null, "event_endpt": null, "status": null, "event_contact_phone": null, "lane_contact_email": null, "over_contact_phone": null, "event_org_name": null, "house_building_moved": null, "over_contact_city": null, "house_app_num": null, "over_items": null, "dump_contact_add": null, "exca_contact_city": null, "event_contact_cell": null, "permitsent_date": null, "house_contact_add": null, "dump_install_date": null, "exca_detour_req": null, "exca_install_purp": null, "submitdt": null, "dump_company": null, "contlicense": null, "appphone": null, "lane_start": null, "house_contact_state": null, "house_app_phone": null, "house_location": null, "propstartdt": null, "event_traffic_needed": null, "exca_depth": null, "moreinfo": null, "house_contact_city": null, "event_org_zip": null, "appzip": null, "event_num": null, "event_alt_cell": null, "project": null, "over_contact_add": null, "event_contact_email": null, "contname": null, "subtypeother": null, "water_app_phone": null, "appname": null, "dump_contact_phone": null, "event_alt_phone": null, "payrequest_date": null, "event_startpt": null, "exca_size": null, "lane_contact_zip": null, "lane_end": null, "appstate": null, "house_company": null, "event_alt_name": null, "exca_contact_zip": null, "exca_work_descrip": null, "exca_dis_surface_other": null, "event_org_city": null, "dump_contact_city": null, "event_title": null, "apprenddt": null, "contcity": null, "event_endtime": null, "lane_reason": null, "water_contact_state": null, "appcity": null, "water_contact_zip": null, "exca_utility_type_other": null, "water_address": null, "permitfee": null, "event_enddt": null, "propenddt": null, "lane_contact_name": null, "description": null, "dump_contact_email": null, "house_building_moved_other": null, "house_weight": null, "event_portion": null, "over_contact_state": null, "dump_contact_zip": null, "subtype": null, "over_contact_name": null, "exca_closure_req": null, "dump_remove_date": null, "statuscoa": "Submitted", "exca_end": null, "sameapp": null, "house_contact_zip": null, "water_contact_email": null, "comments": null, "house_app_name": null, "dump_contact_state": null, "lane_contact_city": null, "signatureprint": null, "exca_contractor_person": null, "house_add_strucs": null, "permit_type": null, "dump_address": null, "exca_start": null, "exca_install_method_other": null, "event_alt_email": null, "dump_contact_name": null, "permitnumber": null, "house_date": null, "appemail": null, "laneclosure": null, "event_org_state": null } } } ], "name": "Submitted", "id": "Submitted" } ], "capabilities": "Query,Create,Update,Editing,Sync,Extract,Uploads", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "supportsLayerOverrides ": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": false, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "uniqueIdField": { "isSystemMaintained": true, "name": "OBJECTID" }, "tileMaxRecordCount": 4000, "typeIdField": "statuscoa", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "field1": "statuscoa", "defaultSymbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 170, 170, 170, 255 ], "size": 6, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "defaultLabel": "Other", "uniqueValueInfos": [ { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 0, 204, 0, 255 ], "size": 12, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "App Complete, Paid & Sent", "value": "CompleteSent" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 179, 0, 179, 255 ], "size": 12, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Payment Requested", "value": "PaymentRequested" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 255, 0, 0, 255 ], "size": 12, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Denied", "value": "Denied" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 0, 0, 255, 255 ], "size": 12, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Engineer Approved", "value": "EngineerApproved" }, { "symbol": { "outline": { "color": [ 153, 153, 153, 64 ], "width": 0.75, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 255, 255, 0, 255 ], "size": 12, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Submitted", "value": "Submitted" } ], "type": "uniqueValue" }, "transparency": 0 }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }