{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "AMANDA_PERMIT_DATA", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "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": "FolderName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "length": 8, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TaxAccountNumber", "type": "esriFieldTypeString", "alias": "TaxAccountNumber", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TaxAccountNumber" }, { "name": "HouseNumber", "type": "esriFieldTypeString", "alias": "HouseNumber", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "HouseNumber" }, { "name": "SiteAddress", "type": "esriFieldTypeString", "alias": "SiteAddress", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "SiteAddress" }, { "name": "SiteCity", "type": "esriFieldTypeString", "alias": "SiteCity", "domain": null, "editable": true, "nullable": false, "length": 60, "defaultValue": null, "modelName": "SiteCity" }, { "name": "SiteState", "type": "esriFieldTypeString", "alias": "SiteState", "domain": null, "editable": true, "nullable": false, "length": 2, "defaultValue": null, "modelName": "SiteState" }, { "name": "SitePostal", "type": "esriFieldTypeString", "alias": "SitePostal", "domain": null, "editable": true, "nullable": false, "length": 5, "defaultValue": null, "modelName": "SitePostal" }, { "name": "FolderRSN", "type": "esriFieldTypeInteger", "alias": "FolderRSN", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "FolderRSN" }, { "name": "ProjectFileNumber", "type": "esriFieldTypeString", "alias": "ProjectFileNumber", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ProjectFileNumber" }, { "name": "PermitType", "type": "esriFieldTypeString", "alias": "PermitType", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "PermitType" }, { "name": "PermitDescription", "type": "esriFieldTypeString", "alias": "PermitDescription", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "PermitDescription" }, { "name": "GroupType", "type": "esriFieldTypeString", "alias": "GroupType", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "GroupType" }, { "name": "SubType", "type": "esriFieldTypeString", "alias": "SubType", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "SubType" }, { "name": "WorkType", "type": "esriFieldTypeString", "alias": "WorkType", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "WorkType" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "Status" }, { "name": "FolderName", "type": "esriFieldTypeString", "alias": "FolderName", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "FolderName" }, { "name": "FolderDescription", "type": "esriFieldTypeString", "alias": "FolderDescription", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "FolderDescription" }, { "name": "ApplicationDate", "type": "esriFieldTypeString", "alias": "ApplicationDate", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ApplicationDate" }, { "name": "IssueDate", "type": "esriFieldTypeString", "alias": "IssueDate", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "IssueDate" }, { "name": "FinalDate", "type": "esriFieldTypeString", "alias": "FinalDate", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "FinalDate" }, { "name": "ExpiryDate", "type": "esriFieldTypeString", "alias": "ExpiryDate", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ExpiryDate" }, { "name": "DaysSinceCompleted", "type": "esriFieldTypeInteger", "alias": "DaysSinceCompleted", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DaysSinceCompleted" }, { "name": "SubdivisionName", "type": "esriFieldTypeString", "alias": "SubdivisionName", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SubdivisionName" }, { "name": "Township", "type": "esriFieldTypeString", "alias": "Township", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Township" }, { "name": "Range", "type": "esriFieldTypeString", "alias": "Range", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Range" }, { "name": "Section", "type": "esriFieldTypeString", "alias": "Section", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Section" }, { "name": "SixteenthSection", "type": "esriFieldTypeInteger", "alias": "SixteenthSection", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SixteenthSection" }, { "name": "Valuation", "type": "esriFieldTypeDouble", "alias": "Valuation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Valuation" }, { "name": "DwellingUnits", "type": "esriFieldTypeInteger", "alias": "DwellingUnits", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DwellingUnits" }, { "name": "MainFloorSqFt", "type": "esriFieldTypeString", "alias": "MainFloorSqFt", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MainFloorSqFt" }, { "name": "TotalBldgSqFt", "type": "esriFieldTypeDouble", "alias": "TotalBldgSqFt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalBldgSqFt" }, { "name": "NumberofBedrooms", "type": "esriFieldTypeString", "alias": "NumberofBedrooms", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NumberofBedrooms" }, { "name": "HeatSource", "type": "esriFieldTypeString", "alias": "HeatSource", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HeatSource" }, { "name": "HeatType", "type": "esriFieldTypeString", "alias": "HeatType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HeatType" }, { "name": "SepticorSewer", "type": "esriFieldTypeString", "alias": "SepticorSewer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SepticorSewer" }, { "name": "PrimaryUsage", "type": "esriFieldTypeString", "alias": "PrimaryUsage", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PrimaryUsage" }, { "name": "DevelopmentType", "type": "esriFieldTypeString", "alias": "DevelopmentType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DevelopmentType" }, { "name": "NoticeRequired", "type": "esriFieldTypeString", "alias": "NoticeRequired", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "NoticeRequired" }, { "name": "SEPARequired", "type": "esriFieldTypeString", "alias": "SEPARequired", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SEPARequired" }, { "name": "FillYards", "type": "esriFieldTypeDouble", "alias": "FillYards", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FillYards" }, { "name": "CutYards", "type": "esriFieldTypeDouble", "alias": "CutYards", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CutYards" }, { "name": "PropertySizeAcres", "type": "esriFieldTypeDouble", "alias": "PropertySizeAcres", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PropertySizeAcres" }, { "name": "NumberOfLots", "type": "esriFieldTypeDouble", "alias": "NumberOfLots", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NumberOfLots" }, { "name": "DuplexLotsProposed", "type": "esriFieldTypeString", "alias": "DuplexLotsProposed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DuplexLotsProposed" }, { "name": "ExistingZoning", "type": "esriFieldTypeString", "alias": "ExistingZoning", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ExistingZoning" }, { "name": "LotSizeAvgUsed", "type": "esriFieldTypeString", "alias": "LotSizeAvgUsed", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LotSizeAvgUsed" }, { "name": "AvgLotSize", "type": "esriFieldTypeDouble", "alias": "AvgLotSize", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AvgLotSize" }, { "name": "NoLotsApproved", "type": "esriFieldTypeDouble", "alias": "NoLotsApproved", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NoLotsApproved" }, { "name": "NoLotsRecorded", "type": "esriFieldTypeDouble", "alias": "NoLotsRecorded", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NoLotsRecorded" }, { "name": "ProjectEngineer", "type": "esriFieldTypeString", "alias": "ProjectEngineer", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ProjectEngineer" }, { "name": "ApplicantName", "type": "esriFieldTypeString", "alias": "ApplicantName", "domain": null, "editable": true, "nullable": true, "length": 121, "defaultValue": null, "modelName": "ApplicantName" }, { "name": "ApplicantOrganization", "type": "esriFieldTypeString", "alias": "ApplicantOrganization", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "ApplicantOrganization" }, { "name": "ApplicantAddress", "type": "esriFieldTypeString", "alias": "ApplicantAddress", "domain": null, "editable": true, "nullable": true, "length": 1001, "defaultValue": null, "modelName": "ApplicantAddress" }, { "name": "ApplicantPhone", "type": "esriFieldTypeString", "alias": "ApplicantPhone", "domain": null, "editable": true, "nullable": true, "length": 14, "defaultValue": null, "modelName": "ApplicantPhone" }, { "name": "ContractorName", "type": "esriFieldTypeString", "alias": "ContractorName", "domain": null, "editable": true, "nullable": true, "length": 121, "defaultValue": null, "modelName": "ContractorName" }, { "name": "ContractorOrganization", "type": "esriFieldTypeString", "alias": "ContractorOrganization", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "ContractorOrganization" }, { "name": "ContractorAddress", "type": "esriFieldTypeString", "alias": "ContractorAddress", "domain": null, "editable": true, "nullable": true, "length": 1001, "defaultValue": null, "modelName": "ContractorAddress" }, { "name": "ContractorPhone", "type": "esriFieldTypeString", "alias": "ContractorPhone", "domain": null, "editable": true, "nullable": true, "length": 14, "defaultValue": null, "modelName": "ContractorPhone" }, { "name": "ContractorLicence", "type": "esriFieldTypeString", "alias": "ContractorLicence", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ContractorLicence" }, { "name": "PDSContactName", "type": "esriFieldTypeString", "alias": "PDSContactName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PDSContactName" }, { "name": "PDSContactPhone", "type": "esriFieldTypeString", "alias": "PDSContactPhone", "domain": null, "editable": true, "nullable": false, "length": 32, "defaultValue": null, "modelName": "PDSContactPhone" }, { "name": "PDSContactEmail", "type": "esriFieldTypeString", "alias": "PDSContactEmail", "domain": null, "editable": true, "nullable": false, "length": 128, "defaultValue": null, "modelName": "PDSContactEmail" }, { "name": "GroupCategory", "type": "esriFieldTypeString", "alias": "GroupCategory", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GroupCategory" }, { "name": "GroupStatus", "type": "esriFieldTypeString", "alias": "GroupStatus", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "GroupStatus" }, { "name": "Active", "type": "esriFieldTypeString", "alias": "Active", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Active" }, { "name": "RunDate", "type": "esriFieldTypeDate", "alias": "RunDate", "domain": null, "editable": true, "nullable": false, "length": 8, "defaultValue": null, "precision": 1, "modelName": "RunDate" }, { "name": "FolderCentury", "type": "esriFieldTypeInteger", "alias": "FolderCentury", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FolderCentury" } ], "indexes": [ { "name": "R443_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "G5541FolderRSN", "isAscending": true, "isUnique": false, "description": "", "fields": "FolderRSN" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "Etc/GMT+8", "respectsDaylightSaving": false }, "preferredTimeReference": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "Etc/GMT+8", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "AMANDA_PERMIT_DATA", "description": "", "prototype": { "attributes": { "RunDate": -2209161600000, "FolderCentury": null, "TaxAccountNumber": null, "HouseNumber": null, "SiteAddress": null, "SiteCity": " ", "SiteState": " ", "SitePostal": " ", "FolderRSN": 0, "ProjectFileNumber": null, "PermitType": null, "PermitDescription": null, "GroupType": null, "SubType": null, "WorkType": null, "Status": null, "FolderName": null, "FolderDescription": null, "ApplicationDate": null, "IssueDate": null, "FinalDate": null, "ExpiryDate": null, "DaysSinceCompleted": null, "SubdivisionName": null, "Township": null, "Range": null, "Section": null, "SixteenthSection": null, "Valuation": null, "DwellingUnits": null, "MainFloorSqFt": null, "TotalBldgSqFt": null, "NumberofBedrooms": null, "HeatSource": null, "HeatType": null, "SepticorSewer": null, "PrimaryUsage": null, "DevelopmentType": null, "NoticeRequired": null, "SEPARequired": null, "FillYards": null, "CutYards": null, "PropertySizeAcres": null, "NumberOfLots": null, "DuplexLotsProposed": null, "ExistingZoning": null, "LotSizeAvgUsed": null, "AvgLotSize": null, "NoLotsApproved": null, "NoLotsRecorded": null, "ProjectEngineer": null, "ApplicantName": null, "ApplicantOrganization": null, "ApplicantAddress": null, "ApplicantPhone": null, "ContractorName": null, "ContractorOrganization": null, "ContractorAddress": null, "ContractorPhone": null, "ContractorLicence": null, "PDSContactName": null, "PDSContactPhone": " ", "PDSContactEmail": " ", "GroupCategory": null, "GroupStatus": null, "Active": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "810c64831e694176b3a1e12830817dc5" }