{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "AMANDA_PERMIT_DATA", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FolderName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "length": 8, "domain": null }, { "name": "TaxAccountNumber", "type": "esriFieldTypeString", "alias": "TaxAccountNumber", "length": 50, "domain": null }, { "name": "HouseNumber", "type": "esriFieldTypeString", "alias": "HouseNumber", "length": 20, "domain": null }, { "name": "SiteAddress", "type": "esriFieldTypeString", "alias": "SiteAddress", "length": 80, "domain": null }, { "name": "SiteCity", "type": "esriFieldTypeString", "alias": "SiteCity", "length": 60, "domain": null }, { "name": "SiteState", "type": "esriFieldTypeString", "alias": "SiteState", "length": 2, "domain": null }, { "name": "SitePostal", "type": "esriFieldTypeString", "alias": "SitePostal", "length": 5, "domain": null }, { "name": "FolderRSN", "type": "esriFieldTypeInteger", "alias": "FolderRSN", "domain": null }, { "name": "ProjectFileNumber", "type": "esriFieldTypeString", "alias": "ProjectFileNumber", "length": 25, "domain": null }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "PermitType", "length": 4, "domain": null }, { "name": "PermitDescription", "type": "esriFieldTypeString", "alias": "PermitDescription", "length": 80, "domain": null }, { "name": "GroupType", "type": "esriFieldTypeString", "alias": "GroupType", "length": 80, "domain": null }, { "name": "SubType", "type": "esriFieldTypeString", "alias": "SubType", "length": 80, "domain": null }, { "name": "WorkType", "type": "esriFieldTypeString", "alias": "WorkType", "length": 80, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 80, "domain": null }, { "name": "FolderName", "type": "esriFieldTypeString", "alias": "FolderName", "length": 4000, "domain": null }, { "name": "FolderDescription", "type": "esriFieldTypeString", "alias": "FolderDescription", "length": 4000, "domain": null }, { "name": "ApplicationDate", "type": "esriFieldTypeString", "alias": "ApplicationDate", "length": 10, "domain": null }, { "name": "IssueDate", "type": "esriFieldTypeString", "alias": "IssueDate", "length": 10, "domain": null }, { "name": "FinalDate", "type": "esriFieldTypeString", "alias": "FinalDate", "length": 10, "domain": null }, { "name": "ExpiryDate", "type": "esriFieldTypeString", "alias": "ExpiryDate", "length": 10, "domain": null }, { "name": "DaysSinceCompleted", "type": "esriFieldTypeInteger", "alias": "DaysSinceCompleted", "domain": null }, { "name": "SubdivisionName", "type": "esriFieldTypeString", "alias": "SubdivisionName", "length": 20, "domain": null }, { "name": "Township", "type": "esriFieldTypeString", "alias": "Township", "length": 12, "domain": null }, { "name": "Range", "type": "esriFieldTypeString", "alias": "Range", "length": 12, "domain": null }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "length": 12, "domain": null }, { "name": "SixteenthSection", "type": "esriFieldTypeInteger", "alias": "SixteenthSection", "domain": null }, { "name": "Valuation", "type": "esriFieldTypeDouble", "alias": "Valuation", "domain": null }, { "name": "DwellingUnits", "type": "esriFieldTypeInteger", "alias": "DwellingUnits", "domain": null }, { "name": "MainFloorSqFt", "type": "esriFieldTypeString", "alias": "MainFloorSqFt", "length": 50, "domain": null }, { "name": "TotalBldgSqFt", "type": "esriFieldTypeDouble", "alias": "TotalBldgSqFt", "domain": null }, { "name": "NumberofBedrooms", "type": "esriFieldTypeString", "alias": "NumberofBedrooms", "length": 50, "domain": null }, { "name": "HeatSource", "type": "esriFieldTypeString", "alias": "HeatSource", "length": 50, "domain": null }, { "name": "HeatType", "type": "esriFieldTypeString", "alias": "HeatType", "length": 50, "domain": null }, { "name": "SepticorSewer", "type": "esriFieldTypeString", "alias": "SepticorSewer", "length": 50, "domain": null }, { "name": "PrimaryUsage", "type": "esriFieldTypeString", "alias": "PrimaryUsage", "length": 50, "domain": null }, { "name": "DevelopmentType", "type": "esriFieldTypeString", "alias": "DevelopmentType", "length": 50, "domain": null }, { "name": "NoticeRequired", "type": "esriFieldTypeString", "alias": "NoticeRequired", "length": 50, "domain": null }, { "name": "SEPARequired", "type": "esriFieldTypeString", "alias": "SEPARequired", "length": 50, "domain": null }, { "name": "FillYards", "type": "esriFieldTypeDouble", "alias": "FillYards", "domain": null }, { "name": "CutYards", "type": "esriFieldTypeDouble", "alias": "CutYards", "domain": null }, { "name": "PropertySizeAcres", "type": "esriFieldTypeDouble", "alias": "PropertySizeAcres", "domain": null }, { "name": "NumberOfLots", "type": "esriFieldTypeDouble", "alias": "NumberOfLots", "domain": null }, { "name": "DuplexLotsProposed", "type": "esriFieldTypeString", "alias": "DuplexLotsProposed", "length": 50, "domain": null }, { "name": "ExistingZoning", "type": "esriFieldTypeString", "alias": "ExistingZoning", "length": 50, "domain": null }, { "name": "LotSizeAvgUsed", "type": "esriFieldTypeString", "alias": "LotSizeAvgUsed", "length": 50, "domain": null }, { "name": "AvgLotSize", "type": "esriFieldTypeDouble", "alias": "AvgLotSize", "domain": null }, { "name": "NoLotsApproved", "type": "esriFieldTypeDouble", "alias": "NoLotsApproved", "domain": null }, { "name": "NoLotsRecorded", "type": "esriFieldTypeDouble", "alias": "NoLotsRecorded", "domain": null }, { "name": "ProjectEngineer", "type": "esriFieldTypeString", "alias": "ProjectEngineer", "length": 50, "domain": null }, { "name": "ApplicantName", "type": "esriFieldTypeString", "alias": "ApplicantName", "length": 121, "domain": null }, { "name": "ApplicantOrganization", "type": "esriFieldTypeString", "alias": "ApplicantOrganization", "length": 150, "domain": null }, { "name": "ApplicantAddress", "type": "esriFieldTypeString", "alias": "ApplicantAddress", "length": 1001, "domain": null }, { "name": "ApplicantPhone", "type": "esriFieldTypeString", "alias": "ApplicantPhone", "length": 14, "domain": null }, { "name": "ContractorName", "type": "esriFieldTypeString", "alias": "ContractorName", "length": 121, "domain": null }, { "name": "ContractorOrganization", "type": "esriFieldTypeString", "alias": "ContractorOrganization", "length": 150, "domain": null }, { "name": "ContractorAddress", "type": "esriFieldTypeString", "alias": "ContractorAddress", "length": 1001, "domain": null }, { "name": "ContractorPhone", "type": "esriFieldTypeString", "alias": "ContractorPhone", "length": 14, "domain": null }, { "name": "ContractorLicence", "type": "esriFieldTypeString", "alias": "ContractorLicence", "length": 25, "domain": null }, { "name": "PDSContactName", "type": "esriFieldTypeString", "alias": "PDSContactName", "length": 50, "domain": null }, { "name": "PDSContactPhone", "type": "esriFieldTypeString", "alias": "PDSContactPhone", "length": 32, "domain": null }, { "name": "PDSContactEmail", "type": "esriFieldTypeString", "alias": "PDSContactEmail", "length": 128, "domain": null }, { "name": "GroupCategory", "type": "esriFieldTypeString", "alias": "GroupCategory", "length": 50, "domain": null }, { "name": "GroupStatus", "type": "esriFieldTypeString", "alias": "GroupStatus", "length": 50, "domain": null }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "length": 50, "domain": null }, { "name": "RunDate", "type": "esriFieldTypeDate", "alias": "RunDate", "length": 8, "precision": 1, "domain": null }, { "name": "FolderCentury", "type": "esriFieldTypeInteger", "alias": "FolderCentury", "domain": null } ], "indexes": [ { "name": "R443_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G5541FolderRSN", "fields": "FolderRSN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "SCD_GDBA.AMANDA_POSTCARD_NOTICE", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "FolderRSN", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Query,Map,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": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "Etc/GMT+8", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "Etc/GMT+8", "respectsDaylightSaving": false }, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "cb895a7624434937a86d36b6334b9dee" }