{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "Planning Applications", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "Parcels", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "PIN_NUM", "composite": false, "catalogID": "{DA97AD9B-7843-4659-B7F6-871FE55184F3}" } ], "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, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "PAName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "PermitNumber", "type": "esriFieldTypeString", "alias": "PermitNumber", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PermitNumber" }, { "name": "PAName", "type": "esriFieldTypeString", "alias": "PAName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PAName" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "PLApplicationStatuses", "description": "Application Statuses for PL module in CityView", "codedValues": [ { "name": "Administrative Decision", "code": "ADM" }, { "name": "Agreement Executed", "code": "AGRE" }, { "name": "Appeal Period", "code": "APER" }, { "name": "Approved", "code": "APPR" }, { "name": "Approved w/Conditions", "code": "APRC" }, { "name": "Board of Adjustment", "code": "BOA" }, { "name": "Canceled", "code": "CAN" }, { "name": "Complete Application", "code": "COMP" }, { "name": "Town Council", "code": "COUN" }, { "name": "Denied", "code": "DEN" }, { "name": "Document Preparation", "code": "DOCP" }, { "name": "Document Preparation", "code": "DPRE" }, { "name": "Decision Upheld", "code": "DUP" }, { "name": "Engineering Decision", "code": "ENG" }, { "name": "Expired", "code": "EXP" }, { "name": "Expired - Inactivity", "code": "EXPI" }, { "name": "File Closed", "code": "FCLS" }, { "name": "Held Over", "code": "HELD" }, { "name": "Heritage Board", "code": "HER" }, { "name": "Historical", "code": "HIST" }, { "name": "Inspections", "code": "INSP" }, { "name": "Invalid License", "code": "INVL" }, { "name": "Monitoring Conditions", "code": "MONT" }, { "name": "Open", "code": "OPEN" }, { "name": "Planning Board", "code": "PBOA" }, { "name": "Planning Commission", "code": "PCOM" }, { "name": "Pending", "code": "PEND" }, { "name": "Pending Mylar Recordation", "code": "PMR" }, { "name": "Pre-Application", "code": "PRE" }, { "name": "Recommend Approval with Conditions", "code": "RCAC" }, { "name": "Community Meeting Complete", "code": "RCOM" }, { "name": "Recorded", "code": "RCRD" }, { "name": "Recommend Approval", "code": "RECA" }, { "name": "Recommend Denial", "code": "RECD" }, { "name": "Revisions Received", "code": "REVR" }, { "name": "Scheduled", "code": "SCH" }, { "name": "Tabled", "code": "TBL" }, { "name": "Technical Review Committee", "code": "TRC" }, { "name": "Under Appeal", "code": "UNDA" }, { "name": "Under Review", "code": "UNDR" }, { "name": "VOID", "code": "VOID" }, { "name": "Waiting for Final Execution", "code": "WEX" }, { "name": "Waiting for Appeal", "code": "WFA" }, { "name": "Waiting for Conditions", "code": "WFC" }, { "name": "Waiting for Signoff", "code": "WGA" }, { "name": "Withdrawn", "code": "WITH" }, { "name": "Waiting for Revisions", "code": "WREV" }, { "name": "Waiting for Security Release", "code": "WSEC" }, { "name": "Waiting for Submittals", "code": "WSUB" }, { "name": "Zoning Board", "code": "ZBA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Status" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "Comments" }, { "name": "PublicNotSummary", "type": "esriFieldTypeString", "alias": "PublicNotSummary", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "PublicNotSummary" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "domain": { "type": "codedValue", "name": "PLApplicationTypes", "description": "Application Types for PL module in CityView.", "codedValues": [ { "name": "Address Assignment", "code": "AA" }, { "name": "Administrative Appeal", "code": "ADM" }, { "name": "Alternate Landscape Request", "code": "AL" }, { "name": "Boundary Adjustment", "code": "BDJ" }, { "name": "Town Capital Improvement Project", "code": "CIP" }, { "name": "Comprehensive Plan Amendment", "code": "CPA" }, { "name": "Conditional Use Permit", "code": "CUP" }, { "name": "Development Agreement", "code": "DA" }, { "name": "Development Master Plan Amendment Major", "code": "DMA" }, { "name": "Development Plan Multi-Family/Residential Major Amendment", "code": "DMFA" }, { "name": "Development Master Plan Amendment Minor", "code": "DMI" }, { "name": "Development Master Plan", "code": "DMP" }, { "name": "Development Master Plan - New", "code": "DMPN" }, { "name": "Development Plan", "code": "DP" }, { "name": "Development Plan Amendment", "code": "DPA" }, { "name": "Development Plan Amendment - New", "code": "DPAN" }, { "name": "Development Plan Amendment Major", "code": "DPMA" }, { "name": "Development Plan Multi-Family/Residential", "code": "DPMF" }, { "name": "Development Plan Amendment Minor", "code": "DPMI" }, { "name": "Development Plan - New", "code": "DPN" }, { "name": "Developer Agreement", "code": "DVA" }, { "name": "Exempt Plat", "code": "EP" }, { "name": "Exemption Resolution", "code": "ER" }, { "name": "Easement & Right-of-Way Plat", "code": "ERP" }, { "name": "Exempt Subdivision Plat", "code": "ESP" }, { "name": "Fire Flow Analysis", "code": "FFA" }, { "name": "Fire Flow Analysis Revision", "code": "FFAR" }, { "name": "Final Plat", "code": "FP" }, { "name": "Final Plat - New", "code": "FPN" }, { "name": "Flood Study", "code": "FS" }, { "name": "Fair Share Reimbursement Agreement", "code": "FSA" }, { "name": "Flood Study Revision", "code": "FSR" }, { "name": "Home Occupation Registration", "code": "HOP" }, { "name": "Heritage Designation", "code": "HR" }, { "name": "Lot Consolidation", "code": "LC" }, { "name": "Land Development Plan", "code": "LDP" }, { "name": "LDR Text Amendment", "code": "LDR" }, { "name": "Land Development & Subdivision Plan", "code": "LDS" }, { "name": "Land Use Plan Amendment", "code": "LUP" }, { "name": "Map Amendment", "code": "MA" }, { "name": "Minor Plat", "code": "MP" }, { "name": "Minor Subdivision Plat", "code": "MS" }, { "name": "Master Sign Plan", "code": "MSP" }, { "name": "Master Sign Plan Amendment Minor", "code": "MSPA" }, { "name": "Master Sign Plan - New", "code": "MSPN" }, { "name": "Non Specified Use", "code": "NSU" }, { "name": "Official Plan Amendment", "code": "OPA" }, { "name": "Plan Amendment", "code": "PA" }, { "name": "Plan of Condominium", "code": "PC" }, { "name": "Planned Unit Development Amendment Major", "code": "PDMA" }, { "name": "Planned Unit Development Amendment Minor", "code": "PDMI" }, { "name": "Final Plat Amendment", "code": "PLA" }, { "name": "Preliminary Plan", "code": "PP" }, { "name": "Preliminary Plan Amendment Major", "code": "PPMA" }, { "name": "Preliminary Plan Amendment Minor", "code": "PPMI" }, { "name": "Preliminary Plan - New", "code": "PPN" }, { "name": "Pre-Application Meeting", "code": "PRE" }, { "name": "Planned Unit Development", "code": "PUD" }, { "name": "Planned Unit Development - New", "code": "PUDN" }, { "name": "Laying Hens Permit", "code": "RCK" }, { "name": "Recombination Plat", "code": "RP" }, { "name": "Reclaimed Water Model", "code": "RWM" }, { "name": "Reclaimed Water Model Revision", "code": "RWMR" }, { "name": "Rezoning", "code": "RZ" }, { "name": "Rezoning - Conditional Use", "code": "RZC" }, { "name": "Rezoning - General Use", "code": "RZG" }, { "name": "Rezoning - General Use", "code": "RZN" }, { "name": "Service Agreement", "code": "SA" }, { "name": "Special Exception Use", "code": "SEU" }, { "name": "Special Exception Use - Family Child Care Home", "code": "SEUF" }, { "name": "Special Exception Use - New", "code": "SEUN" }, { "name": "Sign Permit", "code": "SGP" }, { "name": "Subdivision Plan", "code": "SP" }, { "name": "Site Plan Review", "code": "SPR" }, { "name": "Sewer Study/Pump Station Study", "code": "SPS" }, { "name": "Sewer Study/Pump Station Study Revision", "code": "SPSR" }, { "name": "Special Studies", "code": "SS" }, { "name": "Special Study Verification Letter", "code": "SSL" }, { "name": "Special Exception Use", "code": "SUP" }, { "name": "Surety", "code": "SUR" }, { "name": "Traffic Assessment Report", "code": "TAR" }, { "name": "Traffic Assessment Report Revision", "code": "TARR" }, { "name": "Traffic Impact Analysis", "code": "TIA" }, { "name": "Traffic Impact Analysis Revision", "code": "TIAR" }, { "name": "Tree Permit", "code": "TR" }, { "name": "TRC Request & Communication", "code": "TRC" }, { "name": "Temporary Sign Permit", "code": "TSG" }, { "name": "Temporary Use", "code": "TU" }, { "name": "UDO Text Amendment", "code": "UDO" }, { "name": "Annexation", "code": "VA" }, { "name": "Variance", "code": "VAR" }, { "name": "Variance - New", "code": "VRN" }, { "name": "Variance - Town Council", "code": "VTC" }, { "name": "Waiver/Alternate Compliance", "code": "WAC" }, { "name": "Wireless Small Cell Telecom", "code": "WSC" }, { "name": "Zoning Application", "code": "ZBA" }, { "name": "Minor Variance", "code": "ZNA" }, { "name": "Zoning (Meeting Type)", "code": "ZNM" }, { "name": "Zoning Verification", "code": "ZV" }, { "name": "Zoning Vested Rights", "code": "ZVR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Type" }, { "name": "dateEntered", "type": "esriFieldTypeDate", "alias": "dateEntered", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "dateEntered" }, { "name": "dateClosed", "type": "esriFieldTypeDate", "alias": "dateClosed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "dateClosed" }, { "name": "ParcelNo", "type": "esriFieldTypeString", "alias": "ParcelNo", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ParcelNo" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Source" }, { "name": "PIN_NUM", "type": "esriFieldTypeString", "alias": "PIN_NUM", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PIN_NUM" } ], "indexes": [ { "name": "R11959_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13550_PIN_NU", "fields": "PIN_NUM", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PLApplication_Parcels", "description": "", "prototype": { "attributes": { "Source": null, "PermitNumber": null, "PAName": null, "Status": null, "LegacyID": null, "Comments": null, "PublicNotSummary": null, "Type": null, "dateEntered": null, "dateClosed": null, "ParcelNo": null, "PIN_NUM": null } }, "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 }