{ "layers": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 0, "name": "Polk County Account", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsReturningGeometryEnvelope": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriIntFeet" }, "hasMetadata": true, "extent": { "xmin": 7364355.09416011, "ymin": 395319.705052495, "xmax": 7545709.353346452, "ymax": 530499.4399606287, "spatialReference": { "wkid": 2913, "latestWkid": 2913, "xyTolerance": 0.0032808398950131233, "zTolerance": 2, "mTolerance": 0.001, "falseX": -111333600, "falseY": -98152500, "xyUnits": 3.767577073100752E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 2913, "latestWkid": 2913, "xyTolerance": 0.0032808398950131233, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -111333600, "falseY": -98152500, "xyUnits": 3048, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 213, 192, 252, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 110, 110, 110, 255 ], "width": 0.4 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "AcctTable_AgentName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "TaxlotTemp_FID_Taxlot_Sample_CD", "type": "esriFieldTypeInteger", "alias": "FID_Taxlot_Sample_CDES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TaxlotTemp_FID_Taxlot_Sample_CDES" }, { "name": "TaxlotTemp_MapNumber", "type": "esriFieldTypeString", "alias": "MapNumber", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "TaxlotTemp_MapNumber" }, { "name": "TaxlotTemp_ORMapNum", "type": "esriFieldTypeString", "alias": "ORMapNum", "domain": null, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "TaxlotTemp_ORMapNum" }, { "name": "TaxlotTemp_TAXLOT", "type": "esriFieldTypeString", "alias": "TAXLOT", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "TaxlotTemp_TAXLOT" }, { "name": "TaxlotTemp_SpecialInt", "type": "esriFieldTypeString", "alias": "SpecialInt", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "TaxlotTemp_SpecialInt" }, { "name": "TaxlotTemp_MapTaxlot", "type": "esriFieldTypeString", "alias": "MapTaxlot", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TaxlotTemp_MapTaxlot" }, { "name": "TaxlotTemp_ORTaxlot", "type": "esriFieldTypeString", "alias": "ORTaxlot", "domain": null, "editable": true, "nullable": true, "length": 29, "defaultValue": null, "modelName": "TaxlotTemp_ORTaxlot" }, { "name": "TaxlotTemp_TaxlotFeet", "type": "esriFieldTypeInteger", "alias": "TaxlotFeet", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TaxlotTemp_TaxlotFeet" }, { "name": "TaxlotTemp_TaxlotAcre", "type": "esriFieldTypeDouble", "alias": "TaxlotAcre", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TaxlotTemp_TaxlotAcre" }, { "name": "TaxlotTemp_FID_taxlotpoly1", "type": "esriFieldTypeInteger", "alias": "FID_taxlotpoly1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TaxlotTemp_FID_taxlotpoly1" }, { "name": "AcctTable_OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "AcctTable_SIMapTax", "type": "esriFieldTypeString", "alias": "SIMapTax", "domain": null, "editable": true, "nullable": true, "length": 28, "defaultValue": null, "modelName": "SIMapTax" }, { "name": "AcctTable_Account_ID", "type": "esriFieldTypeDouble", "alias": "ACCOUNT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AcctTable_Account_ID" }, { "name": "AcctTable_OwnerLine1", "type": "esriFieldTypeString", "alias": "OwnerLine1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OwnerLine1" }, { "name": "AcctTable_AgentName", "type": "esriFieldTypeString", "alias": "AgentName", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "AgentName" }, { "name": "AcctTable_MailAdd1", "type": "esriFieldTypeString", "alias": "MailAdd1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailAdd1" }, { "name": "AcctTable_MailAdd2", "type": "esriFieldTypeString", "alias": "MailAdd2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailAdd2" }, { "name": "AcctTable_MailCity", "type": "esriFieldTypeString", "alias": "MailCity", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "MailCity" }, { "name": "AcctTable_MailState", "type": "esriFieldTypeString", "alias": "MailState", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MailState" }, { "name": "AcctTable_MailCntry", "type": "esriFieldTypeString", "alias": "MailCntry", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "MailCntry" }, { "name": "AcctTable_MailZip", "type": "esriFieldTypeString", "alias": "MailZip", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "MailZip" }, { "name": "AcctTable_SiteAddNam", "type": "esriFieldTypeString", "alias": "SiteAddNam", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SiteAddNam" }, { "name": "AcctTable_SiteAddCty", "type": "esriFieldTypeString", "alias": "SiteAddCty", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SiteAddCty" }, { "name": "AcctTable_SiteZip", "type": "esriFieldTypeString", "alias": "SiteZip", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SiteZip" }, { "name": "AcctTable_InstYear", "type": "esriFieldTypeSmallInteger", "alias": "InstYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InstYear" }, { "name": "AcctTable_InstMonth", "type": "esriFieldTypeSmallInteger", "alias": "InstMonth", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InstMonth" }, { "name": "AcctTable_InstId", "type": "esriFieldTypeString", "alias": "InstId", "domain": null, "editable": true, "nullable": true, "length": 24, "defaultValue": null, "modelName": "InstId" }, { "name": "AcctTable_InstType", "type": "esriFieldTypeString", "alias": "Insttype", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "InstType" }, { "name": "AcctTable_Dwelling", "type": "esriFieldTypeString", "alias": "Dwelling", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Dwelling" }, { "name": "AcctTable_PrpClass", "type": "esriFieldTypeString", "alias": "PrpClass", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PrpClass" }, { "name": "AcctTable_PrpClsDsc", "type": "esriFieldTypeString", "alias": "PrpClsDsc", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PrpClsDsc" }, { "name": "AcctTable_TaxCodeArea", "type": "esriFieldTypeString", "alias": "TaxCodeArea", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "TaxCodeArea" }, { "name": "AcctTable_AstImpVal", "type": "esriFieldTypeDouble", "alias": "ASTIMPVAL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AstImpVal" }, { "name": "AcctTable_AstLndVal", "type": "esriFieldTypeDouble", "alias": "ASTLNDVAL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AstLndVal" }, { "name": "AcctTable_AstValue", "type": "esriFieldTypeDouble", "alias": "ASTVALUE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AstValue" }, { "name": "AcctTable_SA", "type": "esriFieldTypeString", "alias": "SA", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "SA" }, { "name": "AcctTable_County", "type": "esriFieldTypeSmallInteger", "alias": "County", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "County" }, { "name": "AcctTable_MA", "type": "esriFieldTypeString", "alias": "MA", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MA" }, { "name": "AcctTable_PrimAccNum", "type": "esriFieldTypeString", "alias": "PrimAccNum", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PrimAccNum" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "Shape.STArea()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STArea()", "required": true }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "Shape.STLength()", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape.STLength()", "required": true }, { "name": "AcctTable_NH", "type": "esriFieldTypeString", "alias": "NH", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "NH" }, { "name": "AcctTable_TaxCode", "type": "esriFieldTypeString", "alias": "TaxCode", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "TaxCode" }, { "name": "AcctTable_In_Care_Of", "type": "esriFieldTypeString", "alias": "In_Care_Of", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "In_Care_Of" }, { "name": "AcctTable_Unit_ID", "type": "esriFieldTypeDouble", "alias": "UnitID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UnitID" }, { "name": "AcctTable_Acct_Acres", "type": "esriFieldTypeDouble", "alias": "Acct_Acres", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Acct_Acres" }, { "name": "AcctTable_Acct_SqFt", "type": "esriFieldTypeString", "alias": "Acct_SqFt", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Acct_SqFt" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R20_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S9_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Polk County Account", "description": "", "prototype": { "attributes": { "AcctTable_Acct_Acres": null, "AcctTable_Acct_SqFt": null, "TaxlotTemp_FID_Taxlot_Sample_CD": null, "TaxlotTemp_MapNumber": null, "TaxlotTemp_ORMapNum": null, "TaxlotTemp_TAXLOT": null, "TaxlotTemp_SpecialInt": null, "TaxlotTemp_MapTaxlot": null, "TaxlotTemp_ORTaxlot": null, "TaxlotTemp_TaxlotFeet": null, "TaxlotTemp_TaxlotAcre": null, "TaxlotTemp_FID_taxlotpoly1": null, "AcctTable_OBJECTID": null, "AcctTable_SIMapTax": null, "AcctTable_Account_ID": null, "AcctTable_OwnerLine1": null, "AcctTable_AgentName": null, "AcctTable_MailAdd1": null, "AcctTable_MailAdd2": null, "AcctTable_MailCity": null, "AcctTable_MailState": null, "AcctTable_MailCntry": null, "AcctTable_MailZip": null, "AcctTable_SiteAddNam": null, "AcctTable_SiteAddCty": null, "AcctTable_SiteZip": null, "AcctTable_InstYear": null, "AcctTable_InstMonth": null, "AcctTable_InstId": null, "AcctTable_InstType": null, "AcctTable_Dwelling": null, "AcctTable_PrpClass": null, "AcctTable_PrpClsDsc": null, "AcctTable_TaxCodeArea": null, "AcctTable_AstImpVal": null, "AcctTable_AstLndVal": null, "AcctTable_AstValue": null, "AcctTable_SA": null, "AcctTable_County": null, "AcctTable_MA": null, "AcctTable_PrimAccNum": null, "AcctTable_Unit_ID": null, "AcctTable_In_Care_Of": null, "AcctTable_NH": null, "AcctTable_TaxCode": null } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 1, "name": "PCMAPS.DBO.V_REAL_IMPROVEMENTS", "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "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": "PARK_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ACCOUNT_ID", "type": "esriFieldTypeDouble", "alias": "ACCOUNT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCOUNT_ID" }, { "name": "YEAR", "type": "esriFieldTypeDouble", "alias": "YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEAR" }, { "name": "IMPR_ID", "type": "esriFieldTypeDouble", "alias": "IMPR_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IMPR_ID" }, { "name": "CODE_AREA", "type": "esriFieldTypeString", "alias": "CODE_AREA", "domain": null, "editable": true, "nullable": false, "length": 5, "defaultValue": null, "modelName": "CODE_AREA" }, { "name": "STAT_CLASS", "type": "esriFieldTypeString", "alias": "STAT_CLASS", "domain": null, "editable": true, "nullable": false, "length": 3, "defaultValue": null, "modelName": "STAT_CLASS" }, { "name": "STAT_CLASS_TYPE", "type": "esriFieldTypeString", "alias": "STAT_CLASS_TYPE", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "STAT_CLASS_TYPE" }, { "name": "STAT_CLASS_DESC", "type": "esriFieldTypeString", "alias": "STAT_CLASS_DESC", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null, "modelName": "STAT_CLASS_DESC" }, { "name": "EFFECTIVE_YEAR_BUILT", "type": "esriFieldTypeDouble", "alias": "EFFECTIVE_YEAR_BUILT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EFFECTIVE_YEAR_BUILT" }, { "name": "YEAR_BUILT", "type": "esriFieldTypeDouble", "alias": "YEAR_BUILT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEAR_BUILT" }, { "name": "TOTAL_SQFT", "type": "esriFieldTypeDouble", "alias": "TOTAL_SQFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_SQFT" }, { "name": "RMV", "type": "esriFieldTypeDouble", "alias": "RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RMV" }, { "name": "TREND_PERCENT", "type": "esriFieldTypeDouble", "alias": "TREND_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TREND_PERCENT" }, { "name": "TREND_FLAG", "type": "esriFieldTypeString", "alias": "TREND_FLAG", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "TREND_FLAG" }, { "name": "TRENDED_RMV", "type": "esriFieldTypeDouble", "alias": "TRENDED_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TRENDED_RMV" }, { "name": "SAV", "type": "esriFieldTypeDouble", "alias": "SAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SAV" }, { "name": "MSAV", "type": "esriFieldTypeDouble", "alias": "MSAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MSAV" }, { "name": "APPRAISAL_YEAR", "type": "esriFieldTypeDouble", "alias": "APPRAISAL_YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "APPRAISAL_YEAR" }, { "name": "EXEMPT_PERCENT", "type": "esriFieldTypeDouble", "alias": "EXEMPT_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXEMPT_PERCENT" }, { "name": "IMPR_DESCRIPTION", "type": "esriFieldTypeString", "alias": "IMPR_DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "IMPR_DESCRIPTION" }, { "name": "EXEMPT_TITLE_NUMBER", "type": "esriFieldTypeString", "alias": "EXEMPT_TITLE_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EXEMPT_TITLE_NUMBER" }, { "name": "X_NUMBER", "type": "esriFieldTypeString", "alias": "X_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "X_NUMBER" }, { "name": "COUNTY_STICKER", "type": "esriFieldTypeString", "alias": "COUNTY_STICKER", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "COUNTY_STICKER" }, { "name": "TITLE_NUMBER", "type": "esriFieldTypeString", "alias": "TITLE_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "TITLE_NUMBER" }, { "name": "MS_PARK_ID", "type": "esriFieldTypeDouble", "alias": "MS_PARK_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MS_PARK_ID" }, { "name": "PARK_NAME", "type": "esriFieldTypeString", "alias": "PARK_NAME", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PARK_NAME" }, { "name": "PLUS_MINUS", "type": "esriFieldTypeString", "alias": "PLUS_MINUS", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PLUS_MINUS" }, { "name": "PHYSICAL_PERCENT", "type": "esriFieldTypeDouble", "alias": "PHYSICAL_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PHYSICAL_PERCENT" }, { "name": "FUNCTIONAL_PERCENT", "type": "esriFieldTypeDouble", "alias": "FUNCTIONAL_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FUNCTIONAL_PERCENT" }, { "name": "COMPLETE_PERCENT", "type": "esriFieldTypeDouble", "alias": "COMPLETE_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COMPLETE_PERCENT" }, { "name": "RMV_COMPUTE_FLAG", "type": "esriFieldTypeString", "alias": "RMV_COMPUTE_FLAG", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "RMV_COMPUTE_FLAG" } ], "indexes": [ { "name": "R38_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PCMAPS.DBO.V_REAL_IMPROVEMENTS", "description": "", "prototype": { "attributes": { "COMPLETE_PERCENT": null, "RMV_COMPUTE_FLAG": " ", "ACCOUNT_ID": null, "YEAR": null, "IMPR_ID": null, "CODE_AREA": " ", "STAT_CLASS": " ", "STAT_CLASS_TYPE": " ", "STAT_CLASS_DESC": " ", "EFFECTIVE_YEAR_BUILT": null, "YEAR_BUILT": null, "TOTAL_SQFT": null, "RMV": null, "TREND_PERCENT": null, "TREND_FLAG": " ", "TRENDED_RMV": null, "SAV": null, "MSAV": null, "APPRAISAL_YEAR": null, "EXEMPT_PERCENT": null, "IMPR_DESCRIPTION": null, "EXEMPT_TITLE_NUMBER": null, "X_NUMBER": null, "COUNTY_STICKER": null, "TITLE_NUMBER": null, "MS_PARK_ID": null, "PARK_NAME": null, "PLUS_MINUS": null, "PHYSICAL_PERCENT": null, "FUNCTIONAL_PERCENT": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 2, "name": "PCMAPS.DBO.V_REAL_VALUES", "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "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": "CODE_AREA", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ACCOUNT_ID", "type": "esriFieldTypeDouble", "alias": "ACCOUNT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCOUNT_ID" }, { "name": "YEAR", "type": "esriFieldTypeDouble", "alias": "YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEAR" }, { "name": "CODE_AREA", "type": "esriFieldTypeString", "alias": "CODE_AREA", "domain": null, "editable": true, "nullable": false, "length": 5, "defaultValue": null, "modelName": "CODE_AREA" }, { "name": "VALUE_SOURCE", "type": "esriFieldTypeDouble", "alias": "VALUE_SOURCE", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "VALUE_SOURCE" }, { "name": "VALUE_ID", "type": "esriFieldTypeDouble", "alias": "VALUE_ID", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "VALUE_ID" }, { "name": "STAT_CLASS", "type": "esriFieldTypeString", "alias": "STAT_CLASS", "domain": null, "editable": true, "nullable": false, "length": 3, "defaultValue": null, "modelName": "STAT_CLASS" }, { "name": "RFD", "type": "esriFieldTypeString", "alias": "RFD", "domain": null, "editable": true, "nullable": false, "length": 1, "defaultValue": null, "modelName": "RFD" }, { "name": "SIZE_TYPE", "type": "esriFieldTypeString", "alias": "SIZE_TYPE", "domain": null, "editable": true, "nullable": false, "length": 1, "defaultValue": null, "modelName": "SIZE_TYPE" }, { "name": "LAND_SIZE", "type": "esriFieldTypeDouble", "alias": "LAND_SIZE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LAND_SIZE" }, { "name": "MAV", "type": "esriFieldTypeDouble", "alias": "MAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAV" }, { "name": "M5_VALUE", "type": "esriFieldTypeDouble", "alias": "M5_VALUE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "M5_VALUE" }, { "name": "SA_FLAG", "type": "esriFieldTypeSmallInteger", "alias": "SA_FLAG", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "SA_FLAG" }, { "name": "TAXABLE_AV", "type": "esriFieldTypeDouble", "alias": "TAXABLE_AV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TAXABLE_AV" }, { "name": "TRENDABLE_RMV", "type": "esriFieldTypeDouble", "alias": "TRENDABLE_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TRENDABLE_RMV" }, { "name": "RMV_TREND_PERCENT", "type": "esriFieldTypeDouble", "alias": "RMV_TREND_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RMV_TREND_PERCENT" }, { "name": "NON_TRENDABLE_RMV", "type": "esriFieldTypeDouble", "alias": "NON_TRENDABLE_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NON_TRENDABLE_RMV" }, { "name": "SAV", "type": "esriFieldTypeDouble", "alias": "SAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SAV" }, { "name": "MSAV", "type": "esriFieldTypeDouble", "alias": "MSAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MSAV" }, { "name": "TRENDED_RMV", "type": "esriFieldTypeDouble", "alias": "TRENDED_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TRENDED_RMV" }, { "name": "EXCEPTION_TRENDABLE_RMV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_TRENDABLE_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_TRENDABLE_RMV" }, { "name": "EXCEPTION_TREND_PERCENT", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_TREND_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_TREND_PERCENT" }, { "name": "EXCEPTION_TRENDED_RMV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_TRENDED_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_TRENDED_RMV" }, { "name": "RATIO_PERCENT", "type": "esriFieldTypeDouble", "alias": "RATIO_PERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATIO_PERCENT" }, { "name": "RATIO_TRENDED_RMV", "type": "esriFieldTypeDouble", "alias": "RATIO_TRENDED_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATIO_TRENDED_RMV" }, { "name": "EXCEPTION_NON_TRENDABLE_RMV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_NON_TRENDABLE_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_NON_TRENDABLE_RMV" }, { "name": "RATIO_NON_TRENDABLE_RMV", "type": "esriFieldTypeDouble", "alias": "RATIO_NON_TRENDABLE_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATIO_NON_TRENDABLE_RMV" }, { "name": "EXCEPTION_SAV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_SAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_SAV" }, { "name": "EXCEPTION_MSAV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_MSAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_MSAV" }, { "name": "TRENDABLE_EXEMPT_RMV", "type": "esriFieldTypeDouble", "alias": "TRENDABLE_EXEMPT_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TRENDABLE_EXEMPT_RMV" }, { "name": "TRENDED_EXEMPT_RMV", "type": "esriFieldTypeDouble", "alias": "TRENDED_EXEMPT_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TRENDED_EXEMPT_RMV" }, { "name": "NON_TRENDABLE_EXEMPT_RMV", "type": "esriFieldTypeDouble", "alias": "NON_TRENDABLE_EXEMPT_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NON_TRENDABLE_EXEMPT_RMV" }, { "name": "EXEMPT_SAV", "type": "esriFieldTypeDouble", "alias": "EXEMPT_SAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXEMPT_SAV" }, { "name": "EXCEPTION_TRENDABLE_EXEMPT_RMV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_TRENDABLE_EXEMPT_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_TRENDABLE_EXEMPT_RMV" }, { "name": "EXCEPTION_TRENDED_EXEMPT_RMV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_TRENDED_EXEMPT_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_TRENDED_EXEMPT_RMV" }, { "name": "RATIO_TRENDED_EXEMPT_RMV", "type": "esriFieldTypeDouble", "alias": "RATIO_TRENDED_EXEMPT_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATIO_TRENDED_EXEMPT_RMV" }, { "name": "EXCEPTION_NONTRENDABLE_EXEMPT_R", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_NONTRENDABLE_EXEMPT_R", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_NONTRENDABLE_EXEMPT_R" }, { "name": "RATIO_NONTRENDABLE_EXEMPT_RMV", "type": "esriFieldTypeDouble", "alias": "RATIO_NONTRENDABLE_EXEMPT_RMV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RATIO_NONTRENDABLE_EXEMPT_RMV" }, { "name": "EXCEPTION_EXEMPT_SAV", "type": "esriFieldTypeDouble", "alias": "EXCEPTION_EXEMPT_SAV", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXCEPTION_EXEMPT_SAV" } ], "indexes": [ { "name": "R37_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PCMAPS.DBO.V_REAL_VALUES", "description": "", "prototype": { "attributes": { "RATIO_NONTRENDABLE_EXEMPT_RMV": null, "EXCEPTION_EXEMPT_SAV": null, "ACCOUNT_ID": null, "YEAR": null, "CODE_AREA": " ", "VALUE_SOURCE": 0, "VALUE_ID": 0, "STAT_CLASS": " ", "RFD": " ", "SIZE_TYPE": " ", "LAND_SIZE": null, "MAV": null, "M5_VALUE": null, "SA_FLAG": 0, "TAXABLE_AV": null, "TRENDABLE_RMV": null, "RMV_TREND_PERCENT": null, "NON_TRENDABLE_RMV": null, "SAV": null, "MSAV": null, "TRENDED_RMV": null, "EXCEPTION_TRENDABLE_RMV": null, "EXCEPTION_TREND_PERCENT": null, "EXCEPTION_TRENDED_RMV": null, "RATIO_PERCENT": null, "RATIO_TRENDED_RMV": null, "EXCEPTION_NON_TRENDABLE_RMV": null, "RATIO_NON_TRENDABLE_RMV": null, "EXCEPTION_SAV": null, "EXCEPTION_MSAV": null, "TRENDABLE_EXEMPT_RMV": null, "TRENDED_EXEMPT_RMV": null, "NON_TRENDABLE_EXEMPT_RMV": null, "EXEMPT_SAV": null, "EXCEPTION_TRENDABLE_EXEMPT_RMV": null, "EXCEPTION_TRENDED_EXEMPT_RMV": null, "RATIO_TRENDED_EXEMPT_RMV": null, "EXCEPTION_NONTRENDABLE_EXEMPT_R": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 3, "name": "PCMAPS.DBO.V_REAL_SITUS", "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "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": "STREET_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ACCOUNT_ID", "type": "esriFieldTypeDouble", "alias": "ACCOUNT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCOUNT_ID" }, { "name": "YEAR", "type": "esriFieldTypeDouble", "alias": "YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEAR" }, { "name": "HOUSE_NUMBER", "type": "esriFieldTypeString", "alias": "HOUSE_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HOUSE_NUMBER" }, { "name": "STREET_NAME", "type": "esriFieldTypeString", "alias": "STREET_NAME", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STREET_NAME" }, { "name": "STREET_TYPE", "type": "esriFieldTypeString", "alias": "STREET_TYPE", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STREET_TYPE" }, { "name": "DIRECTION", "type": "esriFieldTypeString", "alias": "DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "DIRECTION" }, { "name": "UNIT_NUMBER", "type": "esriFieldTypeString", "alias": "UNIT_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "UNIT_NUMBER" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CITY" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "STATE" }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ZIP" }, { "name": "FRAGMENT_NUMBER", "type": "esriFieldTypeDouble", "alias": "FRAGMENT_NUMBER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FRAGMENT_NUMBER" }, { "name": "PRE_DIRECTION", "type": "esriFieldTypeString", "alias": "PRE_DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "PRE_DIRECTION" }, { "name": "MS_ACCOUNT_ID", "type": "esriFieldTypeDouble", "alias": "MS_ACCOUNT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MS_ACCOUNT_ID" } ], "indexes": [ { "name": "R42_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PCMAPS.DBO.V_REAL_SITUS", "description": "", "prototype": { "attributes": { "PRE_DIRECTION": null, "MS_ACCOUNT_ID": null, "ACCOUNT_ID": null, "YEAR": null, "HOUSE_NUMBER": null, "STREET_NAME": null, "STREET_TYPE": null, "DIRECTION": null, "UNIT_NUMBER": null, "CITY": null, "STATE": null, "ZIP": null, "FRAGMENT_NUMBER": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 4, "name": "PCMAPS.DBO.V_REAL_SALES", "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "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": "BOOK", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SALES_ID", "type": "esriFieldTypeDouble", "alias": "SALES_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SALES_ID" }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "BOOK" }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "PAGE" }, { "name": "INSTRUMENT_ID", "type": "esriFieldTypeDouble", "alias": "INSTRUMENT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSTRUMENT_ID" }, { "name": "DOCUMENT_TYPE_CODE", "type": "esriFieldTypeString", "alias": "DOCUMENT_TYPE_CODE", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "DOCUMENT_TYPE_CODE" }, { "name": "DOCUMENT_TYPE_CODE_DESC", "type": "esriFieldTypeString", "alias": "DOCUMENT_TYPE_CODE_DESC", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DOCUMENT_TYPE_CODE_DESC" }, { "name": "DOCUMENT_SOURCE", "type": "esriFieldTypeString", "alias": "DOCUMENT_SOURCE", "domain": null, "editable": true, "nullable": false, "length": 40, "defaultValue": null, "modelName": "DOCUMENT_SOURCE" }, { "name": "EFFECTIVE_DATE", "type": "esriFieldTypeDate", "alias": "EFFECTIVE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EFFECTIVE_DATE" }, { "name": "CHATTLES", "type": "esriFieldTypeDouble", "alias": "CHATTLES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CHATTLES" }, { "name": "CONFIRMATION_DATE", "type": "esriFieldTypeDate", "alias": "CONFIRMATION_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CONFIRMATION_DATE" }, { "name": "CONFIRMATION_SOURCE", "type": "esriFieldTypeString", "alias": "CONFIRMATION_SOURCE", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CONFIRMATION_SOURCE" }, { "name": "DOWN_PAYMENT", "type": "esriFieldTypeDouble", "alias": "DOWN_PAYMENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DOWN_PAYMENT" }, { "name": "EXEMPT_CROPS", "type": "esriFieldTypeDouble", "alias": "EXEMPT_CROPS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXEMPT_CROPS" }, { "name": "EXEMPT_TIMBER_GROWTH", "type": "esriFieldTypeDouble", "alias": "EXEMPT_TIMBER_GROWTH", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXEMPT_TIMBER_GROWTH" }, { "name": "FINANCING_TYPE", "type": "esriFieldTypeString", "alias": "FINANCING_TYPE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FINANCING_TYPE" }, { "name": "INTEREST_RATE", "type": "esriFieldTypeDouble", "alias": "INTEREST_RATE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INTEREST_RATE" }, { "name": "MORTGAGE_DURATION", "type": "esriFieldTypeDouble", "alias": "MORTGAGE_DURATION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MORTGAGE_DURATION" }, { "name": "OTHER_EXEMPTION", "type": "esriFieldTypeDouble", "alias": "OTHER_EXEMPTION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OTHER_EXEMPTION" }, { "name": "REJECT_CODE", "type": "esriFieldTypeString", "alias": "REJECT_CODE", "domain": null, "editable": true, "nullable": false, "length": 3, "defaultValue": null, "modelName": "REJECT_CODE" }, { "name": "REJECT_CODE_DESC", "type": "esriFieldTypeString", "alias": "REJECT_CODE_DESC", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "REJECT_CODE_DESC" }, { "name": "SALES_LETTER_DATE", "type": "esriFieldTypeDate", "alias": "SALES_LETTER_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SALES_LETTER_DATE" }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "REMARKS", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "REMARKS" }, { "name": "TOTAL_SALES_PRICE", "type": "esriFieldTypeDouble", "alias": "TOTAL_SALES_PRICE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TOTAL_SALES_PRICE" }, { "name": "VERIFIED_DATE_OF_SALE", "type": "esriFieldTypeDate", "alias": "VERIFIED_DATE_OF_SALE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "VERIFIED_DATE_OF_SALE" }, { "name": "PRIMARY_ACCOUNT", "type": "esriFieldTypeDouble", "alias": "PRIMARY_ACCOUNT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PRIMARY_ACCOUNT" }, { "name": "SALES_DATE", "type": "esriFieldTypeDate", "alias": "SALES_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SALES_DATE" }, { "name": "PRIMARY_FLAG", "type": "esriFieldTypeString", "alias": "PRIMARY_FLAG", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "PRIMARY_FLAG" }, { "name": "PROCESS_ID", "type": "esriFieldTypeString", "alias": "PROCESS_ID", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "PROCESS_ID" }, { "name": "SOURCE_ID", "type": "esriFieldTypeString", "alias": "SOURCE_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SOURCE_ID" }, { "name": "ADJUSTED_SALES_PRICE", "type": "esriFieldTypeDouble", "alias": "ADJUSTED_SALES_PRICE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ADJUSTED_SALES_PRICE" } ], "indexes": [ { "name": "R41_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PCMAPS.DBO.V_REAL_SALES", "description": "", "prototype": { "attributes": { "SOURCE_ID": null, "ADJUSTED_SALES_PRICE": null, "SALES_ID": null, "BOOK": " ", "PAGE": " ", "INSTRUMENT_ID": null, "DOCUMENT_TYPE_CODE": null, "DOCUMENT_TYPE_CODE_DESC": null, "DOCUMENT_SOURCE": " ", "EFFECTIVE_DATE": null, "CHATTLES": null, "CONFIRMATION_DATE": null, "CONFIRMATION_SOURCE": null, "DOWN_PAYMENT": null, "EXEMPT_CROPS": null, "EXEMPT_TIMBER_GROWTH": null, "FINANCING_TYPE": null, "INTEREST_RATE": null, "MORTGAGE_DURATION": null, "OTHER_EXEMPTION": null, "REJECT_CODE": " ", "REJECT_CODE_DESC": null, "SALES_LETTER_DATE": null, "REMARKS": null, "TOTAL_SALES_PRICE": null, "VERIFIED_DATE_OF_SALE": null, "PRIMARY_ACCOUNT": null, "SALES_DATE": null, "PRIMARY_FLAG": null, "PROCESS_ID": " " } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 5, "name": "PCMAPS.DBO.V_REAL_LEGAL", "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "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": "SUBDIVISION", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ACCOUNT_ID", "type": "esriFieldTypeInteger", "alias": "ACCOUNT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCOUNT_ID" }, { "name": "SUBDIVISION", "type": "esriFieldTypeString", "alias": "SUBDIVISION", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "SUBDIVISION" }, { "name": "BLOCK", "type": "esriFieldTypeString", "alias": "BLOCK", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "BLOCK" }, { "name": "LOT", "type": "esriFieldTypeString", "alias": "LOT", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LOT" }, { "name": "MB_FLAG", "type": "esriFieldTypeInteger", "alias": "MB_FLAG", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "MB_FLAG" } ], "indexes": [ { "name": "R40_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PCMAPS.DBO.V_REAL_LEGAL", "description": "", "prototype": { "attributes": { "LOT": null, "MB_FLAG": 0, "ACCOUNT_ID": null, "SUBDIVISION": null, "BLOCK": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }, { "currentVersion": 11.4, "cimVersion": "3.4.0", "id": 6, "name": "PCMAPS.DBO.V_REAL_LAND_SIZES", "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "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": "TAX_CODE_AREA", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ACCOUNT_ID", "type": "esriFieldTypeDouble", "alias": "ACCOUNT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACCOUNT_ID" }, { "name": "YEAR", "type": "esriFieldTypeDouble", "alias": "YEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YEAR" }, { "name": "TAX_CODE_AREA", "type": "esriFieldTypeString", "alias": "TAX_CODE_AREA", "domain": null, "editable": true, "nullable": false, "length": 5, "defaultValue": null, "modelName": "TAX_CODE_AREA" }, { "name": "PLAN_ZONE", "type": "esriFieldTypeString", "alias": "PLAN_ZONE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PLAN_ZONE" }, { "name": "LAND_SIZE_SQFT", "type": "esriFieldTypeDouble", "alias": "LAND_SIZE_SQFT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LAND_SIZE_SQFT" }, { "name": "LAND_SIZE_ACRES", "type": "esriFieldTypeDouble", "alias": "LAND_SIZE_ACRES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LAND_SIZE_ACRES" } ], "indexes": [ { "name": "R39_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "PCMAPS.DBO.V_REAL_LAND_SIZES", "description": "", "prototype": { "attributes": { "LAND_SIZE_SQFT": null, "LAND_SIZE_ACRES": null, "ACCOUNT_ID": null, "YEAR": null, "TAX_CODE_AREA": " ", "PLAN_ZONE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 } ] }