{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 11, "name": "Project_Main", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "RowNum", "globalIdField": "", "displayField": "PROJECT_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "PREFIX", "type": "esriFieldTypeString", "alias": "PREFIX", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "PREFIX" }, { "name": "YRMO", "type": "esriFieldTypeDouble", "alias": "YRMO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YRMO" }, { "name": "SEQ_NO", "type": "esriFieldTypeDouble", "alias": "SEQ_NO", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SEQ_NO" }, { "name": "PROJECT_NO", "type": "esriFieldTypeString", "alias": "PROJECT_NO", "domain": null, "editable": true, "nullable": false, "length": 30, "defaultValue": null, "modelName": "PROJECT_NO" }, { "name": "PROJECT_NAME", "type": "esriFieldTypeString", "alias": "PROJECT_NAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "PROJECT_NAME" }, { "name": "PROJECTTYPE", "type": "esriFieldTypeString", "alias": "PROJECTTYPE", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "PROJECTTYPE" }, { "name": "PROJECTSUBTYPE", "type": "esriFieldTypeString", "alias": "PROJECTSUBTYPE", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "PROJECTSUBTYPE" }, { "name": "PRIMARY_PIN", "type": "esriFieldTypeString", "alias": "PRIMARY_PIN", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PRIMARY_PIN" }, { "name": "SITE_APN", "type": "esriFieldTypeString", "alias": "SITE_APN", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SITE_APN" }, { "name": "SITE_OWNER", "type": "esriFieldTypeString", "alias": "SITE_OWNER", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SITE_OWNER" }, { "name": "SITE_ADDR", "type": "esriFieldTypeString", "alias": "SITE_ADDR", "domain": null, "editable": true, "nullable": true, "length": 85, "defaultValue": null, "modelName": "SITE_ADDR" }, { "name": "SITE_STREETID", "type": "esriFieldTypeInteger", "alias": "SITE_STREETID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SITE_STREETID" }, { "name": "SITE_NUMBER", "type": "esriFieldTypeString", "alias": "SITE_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "SITE_NUMBER" }, { "name": "SITE_STREETNAME", "type": "esriFieldTypeString", "alias": "SITE_STREETNAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "SITE_STREETNAME" }, { "name": "SITE_UNIT_NO", "type": "esriFieldTypeString", "alias": "SITE_UNIT_NO", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SITE_UNIT_NO" }, { "name": "SITE_CITY", "type": "esriFieldTypeString", "alias": "SITE_CITY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SITE_CITY" }, { "name": "SITE_STATE", "type": "esriFieldTypeString", "alias": "SITE_STATE", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "SITE_STATE" }, { "name": "SITE_ZIP", "type": "esriFieldTypeString", "alias": "SITE_ZIP", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SITE_ZIP" }, { "name": "SITE_LOT_NO", "type": "esriFieldTypeString", "alias": "SITE_LOT_NO", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SITE_LOT_NO" }, { "name": "SITE_BLOCK", "type": "esriFieldTypeString", "alias": "SITE_BLOCK", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SITE_BLOCK" }, { "name": "SITE_TRACT", "type": "esriFieldTypeString", "alias": "SITE_TRACT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SITE_TRACT" }, { "name": "SITE_SUBDIVISION", "type": "esriFieldTypeString", "alias": "SITE_SUBDIVISION", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SITE_SUBDIVISION" }, { "name": "SITE_DESCRIPTION", "type": "esriFieldTypeString", "alias": "SITE_DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "SITE_DESCRIPTION" }, { "name": "ZONING", "type": "esriFieldTypeString", "alias": "ZONING", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ZONING" }, { "name": "GENPLAN", "type": "esriFieldTypeString", "alias": "GENPLAN", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "GENPLAN" }, { "name": "LAND_USE", "type": "esriFieldTypeString", "alias": "LAND_USE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "LAND_USE" }, { "name": "FEES_CHARGED", "type": "esriFieldTypeDouble", "alias": "FEES_CHARGED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEES_CHARGED" }, { "name": "FEES_PAID", "type": "esriFieldTypeDouble", "alias": "FEES_PAID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEES_PAID" }, { "name": "BALANCE_DUE", "type": "esriFieldTypeDouble", "alias": "BALANCE_DUE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BALANCE_DUE" }, { "name": "PROJECT_LOC", "type": "esriFieldTypeString", "alias": "PROJECT_LOC", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PROJECT_LOC" }, { "name": "PLANNER", "type": "esriFieldTypeString", "alias": "PLANNER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PLANNER" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "APPLIED", "type": "esriFieldTypeDate", "alias": "APPLIED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "APPLIED" }, { "name": "APPLIED_BY", "type": "esriFieldTypeString", "alias": "APPLIED_BY", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "APPLIED_BY" }, { "name": "APPROVED", "type": "esriFieldTypeDate", "alias": "APPROVED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "APPROVED" }, { "name": "APPROVED_BY", "type": "esriFieldTypeString", "alias": "APPROVED_BY", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "APPROVED_BY" }, { "name": "CLOSED", "type": "esriFieldTypeDate", "alias": "CLOSED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CLOSED" }, { "name": "CLOSED_BY", "type": "esriFieldTypeString", "alias": "CLOSED_BY", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "CLOSED_BY" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "STATUS", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "STATUS" }, { "name": "STATUS_BY", "type": "esriFieldTypeString", "alias": "STATUS_BY", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "STATUS_BY" }, { "name": "STATUS_DATE", "type": "esriFieldTypeDate", "alias": "STATUS_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "STATUS_DATE" }, { "name": "RESOLUTION_NO", "type": "esriFieldTypeString", "alias": "RESOLUTION_NO", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "RESOLUTION_NO" }, { "name": "PARENT_PROJECT_NO", "type": "esriFieldTypeString", "alias": "PARENT_PROJECT_NO", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PARENT_PROJECT_NO" }, { "name": "EXPIRED", "type": "esriFieldTypeDate", "alias": "EXPIRED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EXPIRED" }, { "name": "EXPIRED_BY", "type": "esriFieldTypeString", "alias": "EXPIRED_BY", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "EXPIRED_BY" }, { "name": "OTHER_DATE1", "type": "esriFieldTypeDate", "alias": "OTHER_DATE1", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OTHER_DATE1" }, { "name": "OTHER_BY1", "type": "esriFieldTypeString", "alias": "OTHER_BY1", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "OTHER_BY1" }, { "name": "OWNER_NAME", "type": "esriFieldTypeString", "alias": "OWNER_NAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "OWNER_NAME" }, { "name": "APPLICANT_NAME", "type": "esriFieldTypeString", "alias": "APPLICANT_NAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "APPLICANT_NAME" }, { "name": "DEVELOPER_NAME", "type": "esriFieldTypeString", "alias": "DEVELOPER_NAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DEVELOPER_NAME" }, { "name": "RECORDID", "type": "esriFieldTypeString", "alias": "RECORDID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "RECORDID" }, { "name": "LOCKID", "type": "esriFieldTypeString", "alias": "LOCKID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LOCKID" }, { "name": "LOC_RECORDID", "type": "esriFieldTypeString", "alias": "LOC_RECORDID", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LOC_RECORDID" }, { "name": "DEPOSITTYPE", "type": "esriFieldTypeString", "alias": "DEPOSITTYPE", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DEPOSITTYPE" }, { "name": "HISTORICAL_APN", "type": "esriFieldTypeString", "alias": "HISTORICAL_APN", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HISTORICAL_APN" }, { "name": "CONTRACTOR_NAME", "type": "esriFieldTypeString", "alias": "CONTRACTOR_NAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "CONTRACTOR_NAME" }, { "name": "REFERENCE_NO", "type": "esriFieldTypeString", "alias": "REFERENCE_NO", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "REFERENCE_NO" }, { "name": "SITE_ALTERNATE_ID", "type": "esriFieldTypeString", "alias": "SITE_ALTERNATE_ID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SITE_ALTERNATE_ID" }, { "name": "SITE_GEOTYPE", "type": "esriFieldTypeString", "alias": "SITE_GEOTYPE", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "SITE_GEOTYPE" }, { "name": "Parent_Generic1_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic1_ActivityNo", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Parent_Generic1_ActivityNo" }, { "name": "Parent_Generic2_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic2_ActivityNo", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Parent_Generic2_ActivityNo" }, { "name": "Parent_Generic3_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic3_ActivityNo", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Parent_Generic3_ActivityNo" }, { "name": "Parent_Generic4_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic4_ActivityNo", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Parent_Generic4_ActivityNo" }, { "name": "Parent_Generic5_ActivityNo", "type": "esriFieldTypeString", "alias": "Parent_Generic5_ActivityNo", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Parent_Generic5_ActivityNo" }, { "name": "TSstatus", "type": "esriFieldTypeInteger", "alias": "TSstatus", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TSstatus" }, { "name": "ActivityTypeID", "type": "esriFieldTypeInteger", "alias": "ActivityTypeID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ActivityTypeID" }, { "name": "Unique_Key", "type": "esriFieldTypeGUID", "alias": "Unique_Key", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "Unique_Key" }, { "name": "RowNum", "type": "esriFieldTypeOID", "alias": "RowNum", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "RowNum" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Project_Main", "description": "", "prototype": { "attributes": { "Unique_Key": null, "PREFIX": null, "YRMO": null, "SEQ_NO": null, "PROJECT_NO": " ", "PROJECT_NAME": null, "PROJECTTYPE": null, "PROJECTSUBTYPE": null, "PRIMARY_PIN": null, "SITE_APN": null, "SITE_OWNER": null, "SITE_ADDR": null, "SITE_STREETID": null, "SITE_NUMBER": null, "SITE_STREETNAME": null, "SITE_UNIT_NO": null, "SITE_CITY": null, "SITE_STATE": null, "SITE_ZIP": null, "SITE_LOT_NO": null, "SITE_BLOCK": null, "SITE_TRACT": null, "SITE_SUBDIVISION": null, "SITE_DESCRIPTION": null, "ZONING": null, "GENPLAN": null, "LAND_USE": null, "FEES_CHARGED": null, "FEES_PAID": null, "BALANCE_DUE": null, "PROJECT_LOC": null, "PLANNER": null, "DESCRIPTION": null, "APPLIED": null, "APPLIED_BY": null, "APPROVED": null, "APPROVED_BY": null, "CLOSED": null, "CLOSED_BY": null, "STATUS": null, "STATUS_BY": null, "STATUS_DATE": null, "RESOLUTION_NO": null, "PARENT_PROJECT_NO": null, "EXPIRED": null, "EXPIRED_BY": null, "OTHER_DATE1": null, "OTHER_BY1": null, "OWNER_NAME": null, "APPLICANT_NAME": null, "DEVELOPER_NAME": null, "RECORDID": null, "LOCKID": null, "LOC_RECORDID": null, "DEPOSITTYPE": null, "HISTORICAL_APN": null, "CONTRACTOR_NAME": null, "REFERENCE_NO": null, "SITE_ALTERNATE_ID": null, "SITE_GEOTYPE": null, "Parent_Generic1_ActivityNo": null, "Parent_Generic2_ActivityNo": null, "Parent_Generic3_ActivityNo": null, "Parent_Generic4_ActivityNo": null, "Parent_Generic5_ActivityNo": null, "TSstatus": null, "ActivityTypeID": 0 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "576da40e77a843c7a093f7b549286cad" }