{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 6, "name": "Permits", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "OwnerName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PermitNumber", "type": "esriFieldTypeString", "alias": "Permit number", "length": 50, "domain": null }, { "name": "AppType", "type": "esriFieldTypeString", "alias": "Application Type", "length": 25, "domain": null }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "Permit Type", "length": 50, "domain": null }, { "name": "PermitStatus", "type": "esriFieldTypeString", "alias": "Permit status", "length": 50, "domain": null }, { "name": "AppDate", "type": "esriFieldTypeDate", "alias": "Application Date", "length": 8, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "InspectionDate2", "type": "esriFieldTypeDate", "alias": "Second Inspection Date", "length": 8, "domain": null }, { "name": "DateInspected", "type": "esriFieldTypeDate", "alias": "Date of the Inspection", "length": 8, "domain": null }, { "name": "DateInspected2", "type": "esriFieldTypeDate", "alias": "Second Inspection Date", "length": 8, "domain": null }, { "name": "InspectedBy", "type": "esriFieldTypeString", "alias": "Inspected By", "length": 50, "domain": null }, { "name": "DateApproved", "type": "esriFieldTypeDate", "alias": "Date Approved", "length": 8, "domain": null }, { "name": "DateApproved2", "type": "esriFieldTypeDate", "alias": "Second Date Approved", "length": 8, "domain": null }, { "name": "ApprovedBy", "type": "esriFieldTypeString", "alias": "Approved By", "length": 50, "domain": null }, { "name": "DateDenied", "type": "esriFieldTypeDate", "alias": "Date Denied", "length": 8, "domain": null }, { "name": "IssuanceDate", "type": "esriFieldTypeDate", "alias": "Date the permit was issued", "length": 8, "domain": null }, { "name": "RefundDate", "type": "esriFieldTypeDate", "alias": "Permit Refund Date", "length": 8, "domain": null }, { "name": "DeadlineDate", "type": "esriFieldTypeDate", "alias": "Deadline Date", "length": 8, "domain": null }, { "name": "DeadlineDate2", "type": "esriFieldTypeDate", "alias": "Second Deadline Date", "length": 8, "domain": null }, { "name": "Citation", "type": "esriFieldTypeString", "alias": "Citation", "length": 10, "domain": null }, { "name": "CitationDate", "type": "esriFieldTypeDate", "alias": "Date of cititation", "length": 8, "domain": null }, { "name": "TownInputDate", "type": "esriFieldTypeDate", "alias": "Town input date", "length": 8, "domain": null }, { "name": "StatePermit", "type": "esriFieldTypeString", "alias": "State permit number", "length": 15, "domain": null }, { "name": "Conditions", "type": "esriFieldTypeString", "alias": "Conditions", "length": 255, "domain": null }, { "name": "ForDescription", "type": "esriFieldTypeString", "alias": "ForDescription", "length": 255, "domain": null }, { "name": "UserId", "type": "esriFieldTypeString", "alias": "User ID", "length": 25, "domain": null }, { "name": "OwnerName", "type": "esriFieldTypeString", "alias": "Owners Name", "length": 255, "domain": null }, { "name": "PropertyAddress", "type": "esriFieldTypeString", "alias": "Property Address", "length": 250, "domain": null }, { "name": "RelGUID", "type": "esriFieldTypeGUID", "alias": "RelGUID", "length": 38, "domain": null }, { "name": "agentId", "type": "esriFieldTypeGUID", "alias": "agentId", "length": 38, "domain": null }, { "name": "ownerId", "type": "esriFieldTypeGUID", "alias": "ownerId", "length": 38, "domain": null }, { "name": "contractorId", "type": "esriFieldTypeGUID", "alias": "contractorId", "length": 38, "domain": null }, { "name": "ConnectID", "type": "esriFieldTypeInteger", "alias": "Temp Connect ID", "domain": null }, { "name": "ConstCost", "type": "esriFieldTypeDouble", "alias": "Construction Cost", "domain": null }, { "name": "conversion", "type": "esriFieldTypeString", "alias": "Conversion of of non-residential to residential", "length": 5, "domain": null }, { "name": "CSM", "type": "esriFieldTypeString", "alias": "CSM Number", "length": 25, "domain": null }, { "name": "SiteCityState", "type": "esriFieldTypeString", "alias": "Site City State Zip", "length": 100, "domain": null }, { "name": "DeededAcres", "type": "esriFieldTypeInteger", "alias": "Deeded Acres", "domain": null }, { "name": "STR", "type": "esriFieldTypeString", "alias": "Section Townhip Range", "length": 15, "domain": null }, { "name": "SanitaryPermitNumber", "type": "esriFieldTypeString", "alias": "Sanitary Permit Number", "length": 25, "domain": null }, { "name": "SignPermitNumber", "type": "esriFieldTypeString", "alias": "Sign Permit Number", "length": 25, "domain": null }, { "name": "SpecialPermitNumber", "type": "esriFieldTypeString", "alias": "Special Permit Number", "length": 25, "domain": null }, { "name": "ConditionalPermitNumber", "type": "esriFieldTypeString", "alias": "Conditional Permit Number", "length": 25, "domain": null }, { "name": "BOAPermitNumber", "type": "esriFieldTypeString", "alias": "BOA Permit Number", "length": 25, "domain": null }, { "name": "RevokeReason", "type": "esriFieldTypeString", "alias": "Reason for revocation", "length": 255, "domain": null }, { "name": "Pin", "type": "esriFieldTypeString", "alias": "PIN", "length": 100, "domain": null }, { "name": "Volume", "type": "esriFieldTypeString", "alias": "Volume", "length": 50, "domain": null }, { "name": "Page", "type": "esriFieldTypeString", "alias": "Page(s)", "length": 50, "domain": null }, { "name": "govLots", "type": "esriFieldTypeString", "alias": "Govt. Lots", "length": 100, "domain": null }, { "name": "Lot", "type": "esriFieldTypeString", "alias": "Lot(s)", "length": 50, "domain": null }, { "name": "Block", "type": "esriFieldTypeString", "alias": "Block", "length": 50, "domain": null }, { "name": "SubdCondo", "type": "esriFieldTypeString", "alias": "Subdivision", "length": 255, "domain": null }, { "name": "quarterQuarter", "type": "esriFieldTypeString", "alias": "1/4, 1/4", "length": 255, "domain": null }, { "name": "SanitaryDate", "type": "esriFieldTypeDate", "alias": "Sanitary Date", "length": 8, "domain": null }, { "name": "MitigationRequired", "type": "esriFieldTypeString", "alias": "Mitigation Required", "length": 5, "domain": null }, { "name": "MitigationAttached", "type": "esriFieldTypeString", "alias": "Mitigation Attached", "length": 5, "domain": null }, { "name": "SubStandard", "type": "esriFieldTypeString", "alias": "Sub-Standard Lot", "length": 5, "domain": null }, { "name": "CommonOwner", "type": "esriFieldTypeString", "alias": "Common Ownership", "length": 5, "domain": null }, { "name": "NonConform", "type": "esriFieldTypeString", "alias": "Non-Conforming", "length": 5, "domain": null }, { "name": "AffidavitRequired", "type": "esriFieldTypeString", "alias": "Affidavit Required", "length": 5, "domain": null }, { "name": "AffidavitAttached", "type": "esriFieldTypeString", "alias": "Affidavit Attached", "length": 5, "domain": null }, { "name": "VarianceBOA", "type": "esriFieldTypeString", "alias": "Granted by Variance (BOA)", "length": 5, "domain": null }, { "name": "PreviousBOA", "type": "esriFieldTypeString", "alias": "Previously Granted by Variance (BOA)", "length": 5, "domain": null }, { "name": "LegallyCreated", "type": "esriFieldTypeString", "alias": "Parcel Legally Created", "length": 5, "domain": null }, { "name": "Surveyed", "type": "esriFieldTypeString", "alias": "Property Surveyed", "length": 5, "domain": null }, { "name": "ConditionsAttached", "type": "esriFieldTypeString", "alias": "Conditions Attached", "length": 50, "domain": null }, { "name": "Bedrooms", "type": "esriFieldTypeString", "alias": "Bedrooms", "length": 2, "domain": null }, { "name": "DeedOfRecord", "type": "esriFieldTypeString", "alias": "Deed of Record", "length": 25, "domain": null }, { "name": "LakesClass", "type": "esriFieldTypeString", "alias": "Lakes Classification", "length": 75, "domain": null }, { "name": "PreviousBOAPermitNumber", "type": "esriFieldTypeString", "alias": "Previous BOA Permit Number", "length": 25, "domain": null }, { "name": "CommonOwnerComments", "type": "esriFieldTypeString", "alias": "Common Ownership Comments", "length": 255, "domain": null }, { "name": "SurveyComments", "type": "esriFieldTypeString", "alias": "Survey Comments", "length": 255, "domain": null }, { "name": "OwnerLastName", "type": "esriFieldTypeString", "alias": "Owner's Last Name", "length": 40, "domain": null }, { "name": "OwnerFirstName", "type": "esriFieldTypeString", "alias": "Owner's First Name", "length": 40, "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": null }, { "name": "State", "type": "esriFieldTypeString", "alias": "State", "length": 50, "domain": null }, { "name": "Township", "type": "esriFieldTypeString", "alias": "Township", "length": 5, "domain": null }, { "name": "Range", "type": "esriFieldTypeString", "alias": "Range", "length": 5, "domain": null }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "length": 5, "domain": null }, { "name": "ConstructionCost", "type": "esriFieldTypeDouble", "alias": "ConstructionCost", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 1500, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "ParcelID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 100, "domain": null }, { "name": "OverlayDistrict", "type": "esriFieldTypeString", "alias": "OverlayDistrict", "length": 256, "domain": null }, { "name": "Classification", "type": "esriFieldTypeString", "alias": "Classification", "length": 256, "domain": null }, { "name": "Zoning", "type": "esriFieldTypeString", "alias": "Zoning", "length": 256, "domain": null }, { "name": "AfterFact", "type": "esriFieldTypeString", "alias": "After Fact", "length": 5, "domain": null }, { "name": "SepticPermit", "type": "esriFieldTypeString", "alias": "Septic Permit", "length": 5, "domain": null }, { "name": "AdditionalLegal", "type": "esriFieldTypeString", "alias": "Legal Description", "length": 1000, "domain": null }, { "name": "DeededAcres2", "type": "esriFieldTypeDouble", "alias": "DeededAcres2", "domain": null }, { "name": "ShorelandName", "type": "esriFieldTypeString", "alias": "ShorelandName", "length": 75, "domain": null }, { "name": "ShorelandIDNumber", "type": "esriFieldTypeString", "alias": "ShorelandIDNumber", "length": 75, "domain": null } ], "indexes": [ { "name": "R1619_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1619", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3433_agentId", "fields": "agentId", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3433_ownerId", "fields": "ownerId", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3433_contrac", "fields": "contractorId", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3433_RelGUID", "fields": "RelGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1619", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 5, "name": "Permits", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{D20390C1-6AE7-4C5E-B07C-60E98959B1B2}" }, { "id": 1, "name": "Structures", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "RelGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{1A06799E-7D2B-4C10-8B80-167D49423C93}" }, { "id": 4, "name": "Contractors", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "contractorId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{80A2EC5E-0DED-4D66-87BB-B033D9A75872}" }, { "id": 6, "name": "Owners", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "ownerId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{FCDD8A2E-2326-4E51-87FA-19A17FC31FCF}" }, { "id": 3, "name": "Agents", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "agentId", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AA4701E4-BF0A-4D65-A4B0-89C29B043046}" } ], "capabilities": "Query,Map,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, "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 }, "serviceItemId": "38003cf098e84820899b0afcb5b936cf" }