{ "preferredTimeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" }, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": "This layer contains a data of Permits exported from the SmartGov permitting and licensing software. The permit pull is filtered by \"Status IS NOT Cancelled\" and by \"Date Range\". The intention is to pull annual closed permit data in January for the previous year. This layer has three (3) relationship classes associated with it (Permits to Contractors, Permits to Inspections, and Parcels to Permits). The purpose of this layer is for staff to be able to easily search parcels to find any related permits and then from the permit number - find the associated archived permit folder.", "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [ { "keyField": "PermitNum", "role": "esriRelRoleOrigin", "catalogID": "{FAAB2DA2-D625-4FEF-9601-90690AEF90E8}", "composite": false, "name": "SDE.SmartGovHistoricalContractors", "relatedTableId": 6, "id": 5, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "PermitNum", "role": "esriRelRoleOrigin", "catalogID": "{8E1A6A33-81C9-4E72-AE31-E1A4A3B44E29}", "composite": false, "name": "SDE.SmartGovHistoricalInspections", "relatedTableId": 7, "id": 6, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "ParcelNumb", "role": "esriRelRoleDestination", "catalogID": "{B4F91F54-D575-48C7-BCB8-25923FFF9994}", "composite": false, "name": "SDE.TaxParcel", "relatedTableId": 1, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "indexes": [ { "name": "R1922_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "PermitNumber", "isUnique": false, "description": "", "fields": "PermitNum", "isAscending": true }, { "name": "ParcelNumber", "isUnique": false, "description": "", "fields": "ParcelNum", "isAscending": true }, { "name": "SiteAddress", "isUnique": false, "description": "", "fields": "Siteaddress", "isAscending": true }, { "name": "GDB_34341_Parcel", "isUnique": false, "description": "", "fields": "ParcelNumb", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": false, "id": 5, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "capabilities": "Map,Query,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": true, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "SmartGovHistoricalPermits", "displayField": "PermitNum", "copyrightText": "City of Liberty - GIS Division", "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "ObjectID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "PermitNum", "length": 255, "alias": "Permit Number", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DateSub", "length": 8, "alias": "Date Submitted", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DateIssue", "length": 8, "alias": "Date Issued", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DateFinish", "length": 8, "alias": "Date Finished", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DateClose", "length": 8, "alias": "Date Closed", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DateExp", "length": 8, "alias": "Date Expiration", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DateLstInsp", "length": 8, "alias": "Date Last Inspected", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "ParcelNum", "alias": "Parcel Num", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Siteaddress", "length": 255, "alias": "Site Address", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ProjectName", "length": 255, "alias": "Project Name", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PrimCont", "length": 255, "alias": "Primary Contact", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PrimContAdd", "length": 255, "alias": "Primary Contact Address", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PrimContCity", "length": 255, "alias": "Primary Contact City", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Applicant", "length": 255, "alias": "Applicant", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ApplicantAdd", "length": 255, "alias": "Applicant Address", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PermitStatus", "length": 255, "alias": "Permit Status", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PermitType", "length": 255, "alias": "Permit Type", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PermitDesc", "length": 255, "alias": "Permit Description", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WorkClass", "length": 255, "alias": "WorkClass", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "SUBDIVISION", "length": 255, "alias": "Subdivision", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LotNum", "alias": "Lot Number", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "SqFt", "alias": "Square Fee", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "ConstTotalCst", "alias": "Construction Total Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "ElectTotalCst", "alias": "Electrical Total Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "MechTotalCst", "alias": "Mechanical Total Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "PlumTotalCst", "alias": "Plumbing Total Cost", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "ParcelNumb", "length": 255, "alias": "Parcel Number", "type": "esriFieldTypeString" } ], "dateFieldsTimeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" } }