{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 7, "name": "CountyService.DBO.GISSALESDATA", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PARCEL", "type": "esriFieldTypeString", "alias": "PARCEL", "length": 26, "domain": null }, { "name": "SALE_DATE", "type": "esriFieldTypeInteger", "alias": "SALE_DATE", "domain": null }, { "name": "SALE_YEAR", "type": "esriFieldTypeSmallInteger", "alias": "SALE_YEAR", "domain": null }, { "name": "SEQUENCE", "type": "esriFieldTypeInteger", "alias": "SEQUENCE", "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 25, "domain": null }, { "name": "SUBLOCATION", "type": "esriFieldTypeString", "alias": "SUBLOCATION", "length": 25, "domain": null }, { "name": "TAXING_DISTRICT", "type": "esriFieldTypeString", "alias": "TAXING_DISTRICT", "length": 6, "domain": null }, { "name": "SCHOOL_DISTRICT", "type": "esriFieldTypeString", "alias": "SCHOOL_DISTRICT", "length": 4, "domain": null }, { "name": "SECTION_", "type": "esriFieldTypeString", "alias": "SECTION_", "length": 3, "domain": null }, { "name": "TOWNSHIP", "type": "esriFieldTypeString", "alias": "TOWNSHIP", "length": 4, "domain": null }, { "name": "RANGE", "type": "esriFieldTypeString", "alias": "RANGE", "length": 3, "domain": null }, { "name": "SELLERS_NAME", "type": "esriFieldTypeString", "alias": "SELLERS_NAME", "length": 30, "domain": null }, { "name": "BUYERS_NAME", "type": "esriFieldTypeString", "alias": "BUYERS_NAME", "length": 30, "domain": null }, { "name": "RECORD_NUMBER", "type": "esriFieldTypeString", "alias": "RECORD_NUMBER", "length": 25, "domain": null }, { "name": "INSTRUMENT_TYPE", "type": "esriFieldTypeString", "alias": "INSTRUMENT_TYPE", "length": 1, "domain": null }, { "name": "BOOK", "type": "esriFieldTypeString", "alias": "BOOK", "length": 5, "domain": null }, { "name": "PAGE", "type": "esriFieldTypeString", "alias": "PAGE", "length": 5, "domain": null }, { "name": "SALE_TYPE", "type": "esriFieldTypeSmallInteger", "alias": "SALE_TYPE", "domain": null }, { "name": "SALE_PRICE", "type": "esriFieldTypeInteger", "alias": "SALE_PRICE", "domain": null }, { "name": "TRANSFER_FEE", "type": "esriFieldTypeDouble", "alias": "TRANSFER_FEE", "domain": null }, { "name": "REJECT_CODE", "type": "esriFieldTypeString", "alias": "REJECT_CODE", "length": 1, "domain": null }, { "name": "PROPERTY_CLASS", "type": "esriFieldTypeString", "alias": "PROPERTY_CLASS", "length": 3, "domain": null }, { "name": "ASSESSED_LAND_VALUE", "type": "esriFieldTypeInteger", "alias": "ASSESSED_LAND_VALUE", "domain": null }, { "name": "ASSESSED_BLDG_VALUE", "type": "esriFieldTypeInteger", "alias": "ASSESSED_BLDG_VALUE", "domain": null }, { "name": "ACRES", "type": "esriFieldTypeSingle", "alias": "ACRES", "domain": null }, { "name": "LEGAL_DESCRIPTION", "type": "esriFieldTypeString", "alias": "LEGAL_DESCRIPTION", "length": 21, "domain": null }, { "name": "COMMENT1", "type": "esriFieldTypeString", "alias": "COMMENT1", "length": 70, "domain": null }, { "name": "COMMENT2", "type": "esriFieldTypeString", "alias": "COMMENT2", "length": 70, "domain": null }, { "name": "YEAR_BUILT", "type": "esriFieldTypeSmallInteger", "alias": "YEAR_BUILT", "domain": null }, { "name": "BASEMENT", "type": "esriFieldTypeString", "alias": "BASEMENT", "length": 6, "domain": null }, { "name": "SQUARE_FEET", "type": "esriFieldTypeString", "alias": "SQUARE_FEET", "length": 9, "domain": null }, { "name": "ACERE_LOT_SIZE", "type": "esriFieldTypeString", "alias": "ACERE_LOT_SIZE", "length": 20, "domain": null }, { "name": "CONSTRUCTION", "type": "esriFieldTypeString", "alias": "CONSTRUCTION", "length": 15, "domain": null }, { "name": "A_C", "type": "esriFieldTypeString", "alias": "A_C", "length": 1, "domain": null }, { "name": "BEDROOMS", "type": "esriFieldTypeString", "alias": "BEDROOMS", "length": 4, "domain": null }, { "name": "FIREPLACE", "type": "esriFieldTypeString", "alias": "FIREPLACE", "length": 4, "domain": null }, { "name": "BATH", "type": "esriFieldTypeString", "alias": "BATH", "length": 6, "domain": null }, { "name": "GARAGE_CODE", "type": "esriFieldTypeString", "alias": "GARAGE_CODE", "length": 2, "domain": null }, { "name": "GARAGE_SIZE", "type": "esriFieldTypeString", "alias": "GARAGE_SIZE", "length": 2, "domain": null }, { "name": "GRADE", "type": "esriFieldTypeString", "alias": "GRADE", "length": 6, "domain": null }, { "name": "SALES_RATIO", "type": "esriFieldTypeSingle", "alias": "SALES_RATIO", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "length": 30, "domain": null }, { "name": "ADDRESS_1", "type": "esriFieldTypeString", "alias": "ADDRESS_1", "length": 30, "domain": null }, { "name": "ADDRESS_2", "type": "esriFieldTypeString", "alias": "ADDRESS_2", "length": 30, "domain": null }, { "name": "ADDRESS_3", "type": "esriFieldTypeString", "alias": "ADDRESS_3", "length": 30, "domain": null }, { "name": "ZIP_CODE", "type": "esriFieldTypeInteger", "alias": "ZIP_CODE", "domain": null }, { "name": "SITE_HOUSE", "type": "esriFieldTypeString", "alias": "SITE_HOUSE", "length": 10, "domain": null }, { "name": "SITE_PREDIRECTION", "type": "esriFieldTypeString", "alias": "SITE_PREDIRECTION", "length": 2, "domain": null }, { "name": "SITE_STREET", "type": "esriFieldTypeString", "alias": "SITE_STREET", "length": 28, "domain": null }, { "name": "SITE_SUFFIX", "type": "esriFieldTypeString", "alias": "SITE_SUFFIX", "length": 4, "domain": null }, { "name": "SITE_DIRECTION", "type": "esriFieldTypeString", "alias": "SITE_DIRECTION", "length": 2, "domain": null }, { "name": "SITE_UNIT_DESC", "type": "esriFieldTypeString", "alias": "SITE_UNIT_DESC", "length": 4, "domain": null }, { "name": "SITE_UNIT", "type": "esriFieldTypeString", "alias": "SITE_UNIT", "length": 8, "domain": null } ], "indexes": [ { "name": "R347_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,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": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }