{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "PlanningCaseFiles2022", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FileCaseNumberToAPN_csv_FileCas", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FileCaseNumberToAPN_csv_FileCas", "type": "esriFieldTypeString", "alias": "FileCaseNumber", "length": 1073741822, "domain": null }, { "name": "FileCaseNumberToAPN_csv_APNNumb", "type": "esriFieldTypeDouble", "alias": "APNNumber", "domain": null }, { "name": "Planning_Case_FIles_csv_OBJECTI", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "Planning_Case_FIles_csv_FileCas", "type": "esriFieldTypeString", "alias": "FileCaseNumber", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Text747", "type": "esriFieldTypeString", "alias": "Text747", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Project", "type": "esriFieldTypeString", "alias": "Project", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Proje_1", "type": "esriFieldTypeString", "alias": "ProjectStreetNumber", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_StreetN", "type": "esriFieldTypeString", "alias": "StreetName", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Submitt", "type": "esriFieldTypeDate", "alias": "SubmittalDate", "length": 8, "domain": null }, { "name": "Planning_Case_FIles_csv_Proje_2", "type": "esriFieldTypeString", "alias": "ProjectDescription", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Initial", "type": "esriFieldTypeDate", "alias": "Initial ReturnDate", "length": 8, "domain": null }, { "name": "Planning_Case_FIles_csv_ReasonF", "type": "esriFieldTypeString", "alias": "ReasonForReturn", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Comment", "type": "esriFieldTypeString", "alias": "Comments", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Applica", "type": "esriFieldTypeDate", "alias": "ApplicationCompleteDate", "length": 8, "domain": null }, { "name": "Planning_Case_FIles_csv_F_DaysT", "type": "esriFieldTypeInteger", "alias": "#DaysToFirstReview", "domain": null }, { "name": "Planning_Case_FIles_csv_StaffAs", "type": "esriFieldTypeString", "alias": "StaffAssignedTo:", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Environ", "type": "esriFieldTypeString", "alias": "EnvironmentalReview", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_NOI_NOD", "type": "esriFieldTypeString", "alias": "NOI/NOD", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_DateNot", "type": "esriFieldTypeString", "alias": "DateNoticeSentToPublisher", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_DateN_1", "type": "esriFieldTypeString", "alias": "DateNoticeSentToPropertyOwner", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_MapUpda", "type": "esriFieldTypeString", "alias": "MapUpdated", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Current", "type": "esriFieldTypeString", "alias": "CurrentProject", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_SortOrd", "type": "esriFieldTypeInteger", "alias": "SortOrder", "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_1", "type": "esriFieldTypeDouble", "alias": "ApplicationFee", "domain": null }, { "name": "Planning_Case_FIles_csv_Receipt", "type": "esriFieldTypeString", "alias": "ReceiptNumber", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Pre_DAB", "type": "esriFieldTypeString", "alias": "Pre-DAB", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_DAB", "type": "esriFieldTypeString", "alias": "DAB", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_DRB", "type": "esriFieldTypeString", "alias": "DRB", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_HPC", "type": "esriFieldTypeString", "alias": "HPC", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_PC", "type": "esriFieldTypeString", "alias": "PC", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_CC", "type": "esriFieldTypeString", "alias": "CC", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Propert", "type": "esriFieldTypeString", "alias": "PropertyOwner'sFirstName", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_1", "type": "esriFieldTypeString", "alias": "PropertyOwner'sLastName", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_2", "type": "esriFieldTypeString", "alias": "PropertyOwner'sAddress", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_3", "type": "esriFieldTypeString", "alias": "PropertyOwner'sCity", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_4", "type": "esriFieldTypeString", "alias": "PropertyOwner'sState", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_5", "type": "esriFieldTypeInteger", "alias": "PropertyOwner'sZip", "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_6", "type": "esriFieldTypeString", "alias": "PropertyOwner'sEmail", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_7", "type": "esriFieldTypeString", "alias": "PropertyOwner'sPhone", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_8", "type": "esriFieldTypeString", "alias": "PropertyOwner'sFax", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Prope_9", "type": "esriFieldTypeString", "alias": "PropertyOwner'sCell", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_2", "type": "esriFieldTypeString", "alias": "Applicant'sFirstName", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_3", "type": "esriFieldTypeString", "alias": "Applicant'sLastName", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_4", "type": "esriFieldTypeString", "alias": "Applicant'sCompany", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_5", "type": "esriFieldTypeString", "alias": "Applicant'sAddress", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_6", "type": "esriFieldTypeString", "alias": "Applicant'sCity", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_7", "type": "esriFieldTypeString", "alias": "Applicant'sState", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_8", "type": "esriFieldTypeInteger", "alias": "Applicant'sZipCode", "domain": null }, { "name": "Planning_Case_FIles_csv_Appli_9", "type": "esriFieldTypeString", "alias": "Applicant'sEmail", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appl_10", "type": "esriFieldTypeString", "alias": "Applicant'sphone", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appl_11", "type": "esriFieldTypeString", "alias": "Applicant'sfax", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consult", "type": "esriFieldTypeString", "alias": "Consultant'sName", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_1", "type": "esriFieldTypeString", "alias": "Consultant'sCoName", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_2", "type": "esriFieldTypeString", "alias": "Consultant'sAddress", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_3", "type": "esriFieldTypeString", "alias": "Consultant'sCity", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_4", "type": "esriFieldTypeString", "alias": "Consultant'sState", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_5", "type": "esriFieldTypeString", "alias": "Consultant'sZip", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_6", "type": "esriFieldTypeString", "alias": "Consultant'sPhone", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_7", "type": "esriFieldTypeString", "alias": "Consultant'sCellPhone", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Consu_8", "type": "esriFieldTypeString", "alias": "Consultant'sEmail", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Resolut", "type": "esriFieldTypeString", "alias": "Resolution", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Action", "type": "esriFieldTypeString", "alias": "Action", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Appl_12", "type": "esriFieldTypeString", "alias": "ApplicationAppealEndDate", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Approva", "type": "esriFieldTypeString", "alias": "ApprovalDate", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Origina", "type": "esriFieldTypeString", "alias": "OriginalExpDate", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_ExpDate", "type": "esriFieldTypeString", "alias": "ExpDateWithExtension", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_DateExt", "type": "esriFieldTypeString", "alias": "DateExtensionLetterSent", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Buildin", "type": "esriFieldTypeString", "alias": "BuildingPermitNumber", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_DatePer", "type": "esriFieldTypeString", "alias": "DatePermitIssued", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_SPR", "type": "esriFieldTypeString", "alias": "SPR", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_UnivPro", "type": "esriFieldTypeString", "alias": "UnivProjNumber", "length": 1073741822, "domain": null }, { "name": "Planning_Case_FIles_csv_Cannabi", "type": "esriFieldTypeString", "alias": "CannabisProject", "length": 1073741822, "domain": null }, { "name": "APNText", "type": "esriFieldTypeString", "alias": "APNText", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null } ], "indexes": [ { "name": "R64_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G209APNText", "fields": "APNText", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_64", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_64", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "PlanningApplications2022", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "APNText", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D0CC4070-A7CA-49D3-8873-26B2C3FAE777}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1709535701000 } }