{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "datesInUnknownTimezone": false, "infoInEstimates": [ "extent", "count" ], "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "camajoinid", "role": "esriRelRoleDestination", "composite": false, "name": "SALE", "relatedTableId": 3, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "camajoinid", "role": "esriRelRoleDestination", "composite": false, "name": "SALE", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.7.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "PTD_Sales", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "exclusioncomment": null, "taxyear": 0, "bookin": null, "assessedvaluebuilding": null, "priorratio": null, "saleprice": null, "assessedvaluemisc": null, "priorassessedvaluetotal": null, "camalinkstatus": " ", "pagein": null, "stateexclusioncode": null, "accountnumber_sale": null, "assessedvalueland": null, "statecamaid": " ", "camajoinid": " ", "saledate": null, "saleratio": null, "exclusioncode": null, "exclusioncodename": null, "affidavityn": 0, "saleid": " ", "salevalidyn": 0, "countyfips": " ", "priorassessedvalueland": null, "assessedvaluetotal": null, "bookpage": null, "priorassessedvaluebuilding": null, "priorassessedvaluemisc": null, "name": null, "supplementalyn": 0, "upc_sale": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "PTD_Sales", "displayField": "name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "name", "length": 50, "alias": "Name", "type": "esriFieldTypeString" }, { "modelName": "bookpage", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bookpage", "length": 50, "alias": "BookPage", "type": "esriFieldTypeString" }, { "modelName": "StateCamaId", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "statecamaid", "length": 36, "alias": "StateCamaId", "type": "esriFieldTypeString" }, { "modelName": "CamaJoinId", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "camajoinid", "length": 49, "alias": "CamaJoinId", "type": "esriFieldTypeString" }, { "modelName": "SaleId", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "saleid", "length": 35, "alias": "SaleId", "type": "esriFieldTypeString" }, { "modelName": "CountyFIPS", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "countyfips", "length": 5, "alias": "CountyFIPS", "type": "esriFieldTypeString" }, { "modelName": "CamaLinkStatus", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "camalinkstatus", "length": 3, "alias": "CamaLinkStatus", "type": "esriFieldTypeString" }, { "modelName": "accountnumber_sale", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accountnumber_sale", "length": 255, "alias": "AccountNumber_Sale", "type": "esriFieldTypeString" }, { "modelName": "upc_sale", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "upc_sale", "length": 255, "alias": "UPC_Sale", "type": "esriFieldTypeString" }, { "modelName": "TaxYear", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "taxyear", "alias": "TaxYear", "type": "esriFieldTypeInteger" }, { "modelName": "SupplementalYN", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "supplementalyn", "alias": "SupplementalYN", "type": "esriFieldTypeSmallInteger" }, { "modelName": "saledate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "saledate", "length": 29, "alias": "SaleDate", "type": "esriFieldTypeDate" }, { "modelName": "saleprice", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "saleprice", "alias": "SalePrice", "type": "esriFieldTypeInteger" }, { "modelName": "bookin", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bookin", "length": 50, "alias": "BookIn", "type": "esriFieldTypeString" }, { "modelName": "pagein", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pagein", "length": 50, "alias": "PageIn", "type": "esriFieldTypeString" }, { "modelName": "AffidavitYN", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "affidavityn", "alias": "AffidavitYN", "type": "esriFieldTypeSmallInteger" }, { "modelName": "SaleValidYN", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "salevalidyn", "alias": "SaleValidYN", "type": "esriFieldTypeSmallInteger" }, { "modelName": "exclusioncode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exclusioncode", "alias": "ExclusionCode", "type": "esriFieldTypeInteger" }, { "modelName": "exclusioncodename", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exclusioncodename", "length": 255, "alias": "ExclusionCodeName", "type": "esriFieldTypeString" }, { "modelName": "stateexclusioncode", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stateexclusioncode", "length": 1, "alias": "StateExclusionCode", "type": "esriFieldTypeString" }, { "modelName": "exclusioncomment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exclusioncomment", "length": 255, "alias": "ExclusionComment", "type": "esriFieldTypeString" }, { "modelName": "priorassessedvalueland", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priorassessedvalueland", "alias": "PriorAssessedValueLand", "type": "esriFieldTypeInteger" }, { "modelName": "priorassessedvaluebuilding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priorassessedvaluebuilding", "alias": "PriorAssessedValueBuilding", "type": "esriFieldTypeInteger" }, { "modelName": "priorassessedvaluemisc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priorassessedvaluemisc", "alias": "PriorAssessedValueMisc", "type": "esriFieldTypeInteger" }, { "modelName": "priorassessedvaluetotal", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priorassessedvaluetotal", "alias": "PriorAssessedValueTotal", "type": "esriFieldTypeInteger" }, { "modelName": "priorratio", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priorratio", "alias": "PriorRatio", "type": "esriFieldTypeDouble" }, { "modelName": "assessedvalueland", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessedvalueland", "alias": "AssessedValueLand", "type": "esriFieldTypeInteger" }, { "modelName": "assessedvaluebuilding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessedvaluebuilding", "alias": "AssessedValueBuilding", "type": "esriFieldTypeInteger" }, { "modelName": "assessedvaluemisc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessedvaluemisc", "alias": "AssessedValueMisc", "type": "esriFieldTypeInteger" }, { "modelName": "assessedvaluetotal", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessedvaluetotal", "alias": "AssessedValueTotal", "type": "esriFieldTypeInteger" }, { "modelName": "saleratio", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "saleratio", "alias": "SaleRatio", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g577camajoinid", "isUnique": false, "description": "", "fields": "camajoinid", "isAscending": true }, { "name": "r493_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "f9520b7bcb754479936979b2aceccea1", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }