{ "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "Permits", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "PRPermitType", "description": "Permit Type for PR", "codedValues": [ { "name": "Accessory Building", "code": "AB" }, { "name": "ABC", "code": "ABC" }, { "name": "Addition", "code": "AD" }, { "name": "Alarm Permit", "code": "AL" }, { "name": "Accessory Structure", "code": "AS" }, { "name": "Accessory Dwelling Unit", "code": "AU" }, { "name": "Building Single Trade", "code": "BD" }, { "name": "Building Construction - Non-Residential", "code": "BDC" }, { "name": "Building Construction - Residential", "code": "BDR" }, { "name": "Blow Off", "code": "BO" }, { "name": "Basement Development", "code": "BS" }, { "name": "Civil Construction Drawings - Non-Residential/Sites", "code": "CDC" }, { "name": "Civil Construction Drawings - Residential", "code": "CDR" }, { "name": "Conditional Power", "code": "CP" }, { "name": "Change of Use/Occupancy", "code": "CU" }, { "name": "Disaster Build/Repair", "code": "DB" }, { "name": "Demolition", "code": "DE" }, { "name": "Deck", "code": "DK" }, { "name": "Driveway Expansion", "code": "DW" }, { "name": "Environmental Development", "code": "ED" }, { "name": "Electrical Single Trade", "code": "EL" }, { "name": "Encroachment", "code": "EN" }, { "name": "Fire Alarm System", "code": "FA" }, { "name": "Fence", "code": "FN" }, { "name": "Foundation Only", "code": "FO" }, { "name": "Fireplace", "code": "FP" }, { "name": "Fire Prevention Permit", "code": "FPP" }, { "name": "Fire Protection System", "code": "FPS" }, { "name": "Fire Sprinkler System", "code": "FSS" }, { "name": "Fire Suppression System", "code": "FSU" }, { "name": "Furnace", "code": "FU" }, { "name": "Fireworks", "code": "FW" }, { "name": "Garage", "code": "GA" }, { "name": "Early Grading", "code": "GR" }, { "name": "Gas", "code": "GS" }, { "name": "Historic Building", "code": "HB" }, { "name": "HVAC Changeout", "code": "HC" }, { "name": "Irrigation - Reclaimed Water System", "code": "IPR" }, { "name": "Irrigation - Potable Water System", "code": "IPW" }, { "name": "Land Disturbance", "code": "LD" }, { "name": "Legacy Unidentified Permit Type", "code": "LEG" }, { "name": "Mechanical Single Trade", "code": "MH" }, { "name": "New Multi-Unit Residential Apartments", "code": "MU" }, { "name": "New Non-Residential Building", "code": "NR" }, { "name": "Non-Residential Construction", "code": "NRC" }, { "name": "New Water Meter Installation or New Sewer Service Application", "code": "NWS" }, { "name": "Occupancy-Change of", "code": "OC" }, { "name": "Manufactured/Modular Home", "code": "PF" }, { "name": "Plumbing Single Trade", "code": "PL" }, { "name": "Swimming Pool, Spa & Hot Tub", "code": "PO" }, { "name": "Residential Construction", "code": "RC" }, { "name": "Roof", "code": "RF" }, { "name": "Regulatory", "code": "RG" }, { "name": "Renovation", "code": "RN" }, { "name": "Service Connection", "code": "SC" }, { "name": "Small Cell Wireless Facility(s)", "code": "SCW" }, { "name": "Special Event", "code": "SE" }, { "name": "New Home Construction: Single Family/Duplex/Townhomes", "code": "SF" }, { "name": "Sign", "code": "SG" }, { "name": "Solar Photovoltaic Systems", "code": "SO" }, { "name": "Septic", "code": "SP" }, { "name": "Stocking Prior to Occupancy", "code": "SPO" }, { "name": "Surety", "code": "SR" }, { "name": "Surety - Engineering", "code": "SURE" }, { "name": "Surety - Planning & Zoning", "code": "SURP" }, { "name": "Construction Stormwater", "code": "SW" }, { "name": "Temporary Certificate of Occupancy", "code": "TCO" }, { "name": "Timbering", "code": "TM" }, { "name": "Tent", "code": "TN" }, { "name": "Temporary Use", "code": "TU" }, { "name": "Utility Permit Application", "code": "UP" }, { "name": "Water Heater Changeout", "code": "WHC" }, { "name": "Well", "code": "WL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 255, "domain": { "type": "codedValue", "name": "PRStatus", "description": "Status for PR module in CityView.", "codedValues": [ { "name": "Canceled", "code": "C" }, { "name": "Closed", "code": "CL" }, { "name": "Closed - Incomplete Submittal", "code": "CLOI" }, { "name": "Denied", "code": "DEN" }, { "name": "Expired", "code": "EX" }, { "name": "Finaled", "code": "F" }, { "name": "Historical", "code": "HIST" }, { "name": "On Hold", "code": "HOLD" }, { "name": "Submittals Incomplete", "code": "INCS" }, { "name": "Invalid License", "code": "INVL" }, { "name": "In Progress", "code": "IP" }, { "name": "In Plan Check", "code": "IPC" }, { "name": "Issued", "code": "ISS" }, { "name": "Pending", "code": "P" }, { "name": "Permit(s) Issued", "code": "PI" }, { "name": "Ready to Process", "code": "PRC" }, { "name": "Reactivate", "code": "RA" }, { "name": "Recalled", "code": "RCL" }, { "name": "Revised", "code": "REV" }, { "name": "Returned for Correction", "code": "RFC" }, { "name": "Ready for Issuance", "code": "RFI" }, { "name": "Revision รข\u20ac\u201c Upload Documents", "code": "RVUD" }, { "name": "Stop Work", "code": "STWK" }, { "name": "VOID", "code": "VOID" }, { "name": "Withdrawn", "code": "WDRN" }, { "name": "Waiting for Revisions", "code": "WREV" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 3000, "domain": null }, { "name": "EnteredBy", "type": "esriFieldTypeString", "alias": "EnteredBy", "length": 255, "domain": null }, { "name": "RecordID", "type": "esriFieldTypeInteger", "alias": "RecordID", "domain": null }, { "name": "OccupancyCode", "type": "esriFieldTypeString", "alias": "OccupancyCode", "length": 255, "domain": { "type": "codedValue", "name": "PROccupancy", "description": "Occupancy for PR module in CityView.", "codedValues": [ { "name": "Assembly, theaters, with stage", "code": "A-1a" }, { "name": "Assembly, theaters, without stage", "code": "A-1b" }, { "name": "Assembly, nightclubs", "code": "A-2a" }, { "name": "Assembly, restaurants, bars, banquet halls", "code": "A-2b" }, { "name": "Assembly, churches", "code": "A-3a" }, { "name": "Assembly, general, community halls, libraries, museums", "code": "A-3b" }, { "name": "Assembly, arenas", "code": "A-4" }, { "name": "Group A - Division 1", "code": "A1" }, { "name": "Group A - Division 2", "code": "A2" }, { "name": "Group A - Division 3", "code": "A3" }, { "name": "Group A - Division 4", "code": "A4" }, { "name": "Business", "code": "B" }, { "name": "Group B - Division 1", "code": "B1" }, { "name": "Group B - Division 2", "code": "B2" }, { "name": "Group B - Division 3", "code": "B3" }, { "name": "Group C", "code": "C" }, { "name": "Group D", "code": "D" }, { "name": "Group E", "code": "E" }, { "name": "Educational", "code": "ED" }, { "name": "Factory and industrial, moderate hazard", "code": "F-1" }, { "name": "Factory and industrial, low hazard", "code": "F-2" }, { "name": "Group F - Division 1", "code": "F1" }, { "name": "Group F - Division 2", "code": "F2" }, { "name": "Group F - Division 3", "code": "F3" }, { "name": "High Hazard, explosives", "code": "H-1" }, { "name": "High Hazard (H-2)", "code": "H-2" }, { "name": "High Hazard (H-3)", "code": "H-3" }, { "name": "High Hazard (H-4)", "code": "H-4" }, { "name": "HPM", "code": "H-5" }, { "name": "Institutional, supervised environment", "code": "I-1" }, { "name": "Institutional, incapacitated", "code": "I-2" }, { "name": "Institutional, restrained", "code": "I-3" }, { "name": "Institutional, day care facilities", "code": "I-4" }, { "name": "Mercantile", "code": "M" }, { "name": "Not Required", "code": "NR" }, { "name": "Residential, hotels", "code": "R-1" }, { "name": "Residential, multiple family", "code": "R-2" }, { "name": "Residential, one- and two-family", "code": "R-3" }, { "name": "Residential, care/assisted living facilities", "code": "R-4" }, { "name": "Storage, moderate hazard", "code": "S-1" }, { "name": "Storage, low hazard", "code": "S-2" }, { "name": "Utility, miscellaneous", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WorkClass", "type": "esriFieldTypeString", "alias": "WorkClass", "length": 255, "domain": null }, { "name": "TotalValuation", "type": "esriFieldTypeDouble", "alias": "TotalValuation", "domain": null }, { "name": "ZoneFire", "type": "esriFieldTypeString", "alias": "ZoneFire", "length": 255, "domain": null }, { "name": "ZoneLand", "type": "esriFieldTypeString", "alias": "ZoneLand", "length": 255, "domain": null }, { "name": "ConstructionType", "type": "esriFieldTypeString", "alias": "ConstructionType", "length": 255, "domain": { "type": "codedValue", "name": "PRWorkClass", "description": "Work Class for PR module in CityView.", "codedValues": [ { "name": "Demolition", "code": "00" }, { "name": "New", "code": "001" }, { "name": "Addition", "code": "002" }, { "name": "Alteration", "code": "003" }, { "name": "Demolition", "code": "004" }, { "name": "Replacement/Repair", "code": "005" }, { "name": "Other", "code": "006" }, { "name": "New construction", "code": "01" }, { "name": "Addition to existing building non-residential & residential", "code": "02" }, { "name": "Alteration and improvements", "code": "03" }, { "name": "Foundation", "code": "04" }, { "name": "Superstructure or part of new building", "code": "05" }, { "name": "Mechanical", "code": "06" }, { "name": "Conversion from single to multiple dwelling", "code": "07" }, { "name": "Conversion from multiple to multiple dwelling", "code": "08" }, { "name": "Conversion from non-residential to residential building", "code": "09" }, { "name": "Deconversion from single to non-residential building", "code": "10" }, { "name": "Deconversion from multiple to multiple, single dwelling or non-resident.", "code": "11" }, { "name": "Installation of a pre-fabricated building", "code": "12" }, { "name": "Additional value to previous permit(s)", "code": "13" }, { "name": "Swimming pool", "code": "14" }, { "name": "Garage/Carport/Accessory Structure", "code": "15" }, { "name": "Other", "code": "16" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "flagStopWork", "type": "esriFieldTypeSmallInteger", "alias": "flagStopWork", "domain": null }, { "name": "PermitNumber", "type": "esriFieldTypeString", "alias": "PermitNumber", "length": 255, "domain": null }, { "name": "flagManualValuation", "type": "esriFieldTypeSmallInteger", "alias": "flagManualValuation", "domain": null }, { "name": "GNCommonID", "type": "esriFieldTypeInteger", "alias": "GNCommonID", "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 255, "domain": null }, { "name": "Jurisdiction", "type": "esriFieldTypeString", "alias": "Jurisdiction", "length": 255, "domain": null }, { "name": "Department", "type": "esriFieldTypeString", "alias": "Department", "length": 255, "domain": null }, { "name": "BuildingUse", "type": "esriFieldTypeString", "alias": "BuildingUse", "length": 255, "domain": { "type": "codedValue", "name": "PRBuildingUse", "description": "Buildings Use for PR module in CityView.", "codedValues": [ { "name": "Agricultural", "code": "AGR" }, { "name": "Commercial", "code": "COM" }, { "name": "Duplex", "code": "DUP" }, { "name": "Industrial", "code": "IND" }, { "name": "Institutional", "code": "INS" }, { "name": "Multi-Family", "code": "MF" }, { "name": "Residential", "code": "RES" }, { "name": "Single Family", "code": "SF" }, { "name": "Townhouse", "code": "TH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurrentSubmittalNumber", "type": "esriFieldTypeInteger", "alias": "CurrentSubmittalNumber", "domain": null }, { "name": "TotalImpactAdjustedValuation", "type": "esriFieldTypeDouble", "alias": "TotalImpactAdjustedValuation", "domain": null }, { "name": "attMPACOccupancyDate", "type": "esriFieldTypeString", "alias": "attMPACOccupancyDate", "length": 255, "domain": null }, { "name": "attMPACCancelledDate", "type": "esriFieldTypeString", "alias": "attMPACCancelledDate", "length": 255, "domain": null }, { "name": "CVDateLastModified", "type": "esriFieldTypeString", "alias": "CVDateLastModified", "length": 255, "domain": null }, { "name": "attNumberStories", "type": "esriFieldTypeDouble", "alias": "attNumberStories", "domain": null }, { "name": "flagOccupancyInspectionRequired", "type": "esriFieldTypeSmallInteger", "alias": "flagOccupancyInspectionRequired", "domain": null }, { "name": "attDateLastInspection", "type": "esriFieldTypeString", "alias": "attDateLastInspection", "length": 255, "domain": null }, { "name": "InternalNotes", "type": "esriFieldTypeString", "alias": "InternalNotes", "length": 3000, "domain": null }, { "name": "attFlagOwnerBuilder", "type": "esriFieldTypeSmallInteger", "alias": "attFlagOwnerBuilder", "domain": null }, { "name": "attFlagPermitDisclaimer", "type": "esriFieldTypeSmallInteger", "alias": "attFlagPermitDisclaimer", "domain": null }, { "name": "attTotalImprovedSQFT", "type": "esriFieldTypeDouble", "alias": "attTotalImprovedSQFT", "domain": null }, { "name": "attWaterService", "type": "esriFieldTypeString", "alias": "attWaterService", "length": 255, "domain": null }, { "name": "attSewerService", "type": "esriFieldTypeString", "alias": "attSewerService", "length": 255, "domain": null }, { "name": "attFlagPropertyHold", "type": "esriFieldTypeSmallInteger", "alias": "attFlagPropertyHold", "domain": null }, { "name": "attProjectOrBusinessName", "type": "esriFieldTypeString", "alias": "attProjectOrBusinessName", "length": 255, "domain": null }, { "name": "attEnvironmentalDevelopmentPerm", "type": "esriFieldTypeString", "alias": "attEnvironmentalDevelopmentPerm", "length": 255, "domain": null }, { "name": "NWParcelID", "type": "esriFieldTypeInteger", "alias": "NWParcelID", "domain": null }, { "name": "DTSID", "type": "esriFieldTypeInteger", "alias": "DTSID", "domain": null }, { "name": "ParcelNo", "type": "esriFieldTypeString", "alias": "ParcelNo", "length": 255, "domain": null }, { "name": "dateIssued", "type": "esriFieldTypeDate", "alias": "dateIssued", "length": 8, "domain": null }, { "name": "dateExpiration", "type": "esriFieldTypeDate", "alias": "dateExpiration", "length": 8, "domain": null }, { "name": "dateEntered", "type": "esriFieldTypeDate", "alias": "dateEntered", "length": 8, "domain": null }, { "name": "dateFinalled", "type": "esriFieldTypeDate", "alias": "dateFinalled", "length": 8, "domain": null }, { "name": "PIN_NUM", "type": "esriFieldTypeString", "alias": "PIN_NUM", "length": 100, "domain": null } ], "indexes": [ { "name": "R11960_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_13551_PIN_NU", "fields": "PIN_NUM", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_13551_Parcel_1", "fields": "ParcelNo", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Parcels", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PIN_NUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{108FE25A-3418-4F09-BA78-6E6E44FA96CF}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }