{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "CORMAP.dbo.ASSESSOR_PARCELINFO_MKT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "StreetName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "Assessor_ParcelInfoID", "type": "esriFieldTypeDouble", "alias": "Assessor_ParcelInfoID", "domain": null }, { "name": "AccountNumber", "type": "esriFieldTypeOID", "alias": "AccountNumber", "domain": null }, { "name": "CardNumber", "type": "esriFieldTypeSmallInteger", "alias": "CardNumber", "domain": null }, { "name": "ParcelID", "type": "esriFieldTypeString", "alias": "ParcelID", "length": 65, "domain": null }, { "name": "StreetNumber", "type": "esriFieldTypeString", "alias": "StreetNumber", "length": 10, "domain": null }, { "name": "AlternateNumber", "type": "esriFieldTypeString", "alias": "AlternateNumber", "length": 10, "domain": null }, { "name": "StreetName", "type": "esriFieldTypeString", "alias": "StreetName", "length": 35, "domain": null }, { "name": "ParcelID1", "type": "esriFieldTypeString", "alias": "ParcelID1", "length": 12, "domain": null }, { "name": "ParcelID2", "type": "esriFieldTypeString", "alias": "ParcelID2", "length": 12, "domain": null }, { "name": "ParcelID3", "type": "esriFieldTypeString", "alias": "ParcelID3", "length": 12, "domain": null }, { "name": "ParcelID4", "type": "esriFieldTypeString", "alias": "ParcelID4", "length": 12, "domain": null }, { "name": "ParcelID5", "type": "esriFieldTypeString", "alias": "ParcelID5", "length": 12, "domain": null }, { "name": "LandUseCode", "type": "esriFieldTypeString", "alias": "LandUseCode", "length": 4, "domain": null }, { "name": "NBC", "type": "esriFieldTypeString", "alias": "NBC", "length": 4, "domain": null }, { "name": "Image_", "type": "esriFieldTypeString", "alias": "Image_", "length": 75, "domain": null }, { "name": "Sketch", "type": "esriFieldTypeString", "alias": "Sketch", "length": 75, "domain": null }, { "name": "CurrentOwner", "type": "esriFieldTypeString", "alias": "CurrentOwner", "length": 120, "domain": null }, { "name": "Owner2", "type": "esriFieldTypeString", "alias": "Owner2", "length": 120, "domain": null }, { "name": "Owner3", "type": "esriFieldTypeString", "alias": "Owner3", "length": 120, "domain": null }, { "name": "CuOState", "type": "esriFieldTypeString", "alias": "CuOState", "length": 10, "domain": null }, { "name": "CuOPostal", "type": "esriFieldTypeString", "alias": "CuOPostal", "length": 16, "domain": null }, { "name": "CuOLegalRef", "type": "esriFieldTypeString", "alias": "CuOLegalRef", "length": 20, "domain": null }, { "name": "CuOSaleDate", "type": "esriFieldTypeDate", "alias": "CuOSaleDate", "length": 8, "domain": null }, { "name": "CurrentBuildingValue", "type": "esriFieldTypeDouble", "alias": "CurrentBuildingValue", "domain": null }, { "name": "CurrentYardItems", "type": "esriFieldTypeDouble", "alias": "CurrentYardItems", "domain": null }, { "name": "CurrentLandValue", "type": "esriFieldTypeDouble", "alias": "CurrentLandValue", "domain": null }, { "name": "CurrentAcres", "type": "esriFieldTypeDouble", "alias": "CurrentAcres", "domain": null }, { "name": "CurrentSF", "type": "esriFieldTypeDouble", "alias": "CurrentSF", "domain": null }, { "name": "CurrentTotal", "type": "esriFieldTypeDouble", "alias": "CurrentTotal", "domain": null }, { "name": "PrevYear", "type": "esriFieldTypeSmallInteger", "alias": "PrevYear", "domain": null }, { "name": "PrevBuildingValue", "type": "esriFieldTypeDouble", "alias": "PrevBuildingValue", "domain": null }, { "name": "PrevYardItems", "type": "esriFieldTypeDouble", "alias": "PrevYardItems", "domain": null }, { "name": "PrevLandValue", "type": "esriFieldTypeDouble", "alias": "PrevLandValue", "domain": null }, { "name": "PrevAcres", "type": "esriFieldTypeDouble", "alias": "PrevAcres", "domain": null }, { "name": "FinArea", "type": "esriFieldTypeDouble", "alias": "FinArea", "domain": null }, { "name": "SizeAdjArea", "type": "esriFieldTypeDouble", "alias": "SizeAdjArea", "domain": null }, { "name": "TotalGrossArea", "type": "esriFieldTypeDouble", "alias": "TotalGrossArea", "domain": null }, { "name": "NumofUnits", "type": "esriFieldTypeSmallInteger", "alias": "NumofUnits", "domain": null }, { "name": "NumofRooms", "type": "esriFieldTypeSmallInteger", "alias": "NumofRooms", "domain": null }, { "name": "Units", "type": "esriFieldTypeSmallInteger", "alias": "Units", "domain": null }, { "name": "Grade", "type": "esriFieldTypeString", "alias": "Grade", "length": 10, "domain": null }, { "name": "YearBlt", "type": "esriFieldTypeSmallInteger", "alias": "YearBlt", "domain": null }, { "name": "EffYearBlt", "type": "esriFieldTypeSmallInteger", "alias": "EffYearBlt", "domain": null }, { "name": "Unit", "type": "esriFieldTypeString", "alias": "Unit", "length": 10, "domain": null }, { "name": "CondoFloor", "type": "esriFieldTypeString", "alias": "CondoFloor", "length": 4, "domain": null }, { "name": "AlternateLUC", "type": "esriFieldTypeString", "alias": "AlternateLUC", "length": 4, "domain": null }, { "name": "AltLUCPercentage", "type": "esriFieldTypeSmallInteger", "alias": "AltLUCPercentage", "domain": null }, { "name": "Fullbath", "type": "esriFieldTypeSmallInteger", "alias": "Fullbath", "domain": null }, { "name": "HalfBath", "type": "esriFieldTypeSmallInteger", "alias": "HalfBath", "domain": null }, { "name": "OtherFixtures", "type": "esriFieldTypeSmallInteger", "alias": "OtherFixtures", "domain": null }, { "name": "Kitchens", "type": "esriFieldTypeSmallInteger", "alias": "Kitchens", "domain": null }, { "name": "FirePlaces", "type": "esriFieldTypeSmallInteger", "alias": "FirePlaces", "domain": null }, { "name": "PercentSprinkled", "type": "esriFieldTypeSmallInteger", "alias": "PercentSprinkled", "domain": null }, { "name": "TotalUnits", "type": "esriFieldTypeInteger", "alias": "TotalUnits", "domain": null }, { "name": "SaleDate", "type": "esriFieldTypeDate", "alias": "SaleDate", "length": 8, "domain": null }, { "name": "SalePrice", "type": "esriFieldTypeDouble", "alias": "SalePrice", "domain": null }, { "name": "Book", "type": "esriFieldTypeString", "alias": "Book", "length": 20, "domain": null }, { "name": "Page", "type": "esriFieldTypeString", "alias": "Page", "length": 20, "domain": null }, { "name": "NALCode", "type": "esriFieldTypeString", "alias": "NALCode", "length": 4, "domain": null }, { "name": "LUCatsale", "type": "esriFieldTypeString", "alias": "LUCatsale", "length": 4, "domain": null }, { "name": "SoldAsVacant", "type": "esriFieldTypeSmallInteger", "alias": "SoldAsVacant", "domain": null }, { "name": "AssociatedValue", "type": "esriFieldTypeDouble", "alias": "AssociatedValue", "domain": null }, { "name": "Sales_Notes", "type": "esriFieldTypeString", "alias": "Sales_Notes", "length": 200, "domain": null }, { "name": "DeedType", "type": "esriFieldTypeString", "alias": "DeedType", "length": 7, "domain": null }, { "name": "RecordingDate", "type": "esriFieldTypeDate", "alias": "RecordingDate", "length": 8, "domain": null }, { "name": "CertNumber", "type": "esriFieldTypeString", "alias": "CertNumber", "length": 20, "domain": null }, { "name": "DocStamps", "type": "esriFieldTypeDouble", "alias": "DocStamps", "domain": null }, { "name": "OwnOcc", "type": "esriFieldTypeString", "alias": "OwnOcc", "length": 4, "domain": null }, { "name": "Census", "type": "esriFieldTypeString", "alias": "Census", "length": 20, "domain": null }, { "name": "FloodHarzard", "type": "esriFieldTypeString", "alias": "FloodHarzard", "length": 20, "domain": null }, { "name": "AssessorsMap", "type": "esriFieldTypeString", "alias": "AssessorsMap", "length": 20, "domain": null }, { "name": "Street", "type": "esriFieldTypeString", "alias": "Street", "length": 35, "domain": null }, { "name": "Way", "type": "esriFieldTypeString", "alias": "Way", "length": 10, "domain": null }, { "name": "LocDirection", "type": "esriFieldTypeString", "alias": "LocDirection", "length": 10, "domain": null }, { "name": "LocationState", "type": "esriFieldTypeString", "alias": "LocationState", "length": 20, "domain": null }, { "name": "District_Ward", "type": "esriFieldTypeString", "alias": "District_Ward", "length": 15, "domain": null }, { "name": "TIFDistrict", "type": "esriFieldTypeString", "alias": "TIFDistrict", "length": 20, "domain": null }, { "name": "BidDistrict", "type": "esriFieldTypeString", "alias": "BidDistrict", "length": 20, "domain": null }, { "name": "Legal_Desc", "type": "esriFieldTypeString", "alias": "Legal_Desc", "length": 1073741822, "domain": null }, { "name": "LandUseDisplay", "type": "esriFieldTypeString", "alias": "LandUseDisplay", "length": 100, "domain": null }, { "name": "LandSizeInAcres", "type": "esriFieldTypeDouble", "alias": "LandSizeInAcres", "domain": null }, { "name": "CuO1OwnerType", "type": "esriFieldTypeString", "alias": "CuO1OwnerType", "length": 50, "domain": null }, { "name": "CuO2OwnerType", "type": "esriFieldTypeString", "alias": "CuO2OwnerType", "length": 50, "domain": null }, { "name": "CuO3OwnerType", "type": "esriFieldTypeString", "alias": "CuO3OwnerType", "length": 50, "domain": null }, { "name": "CuO1LastName", "type": "esriFieldTypeString", "alias": "CuO1LastName", "length": 120, "domain": null }, { "name": "CuO1FirstName", "type": "esriFieldTypeString", "alias": "CuO1FirstName", "length": 120, "domain": null }, { "name": "CuO2FirstName", "type": "esriFieldTypeString", "alias": "CuO2FirstName", "length": 120, "domain": null }, { "name": "CuO2LastName", "type": "esriFieldTypeString", "alias": "CuO2LastName", "length": 120, "domain": null }, { "name": "CuO3FirstName", "type": "esriFieldTypeString", "alias": "CuO3FirstName", "length": 120, "domain": null }, { "name": "CuO3LastName", "type": "esriFieldTypeString", "alias": "CuO3LastName", "length": 120, "domain": null }, { "name": "BillingAddress", "type": "esriFieldTypeString", "alias": "BillingAddress", "length": 120, "domain": null }, { "name": "BillingAddress2", "type": "esriFieldTypeString", "alias": "BillingAddress2", "length": 120, "domain": null }, { "name": "CurrentOwnerBillingAddress", "type": "esriFieldTypeString", "alias": "CurrentOwnerBillingAddress", "length": 120, "domain": null }, { "name": "CuOCity", "type": "esriFieldTypeString", "alias": "CuOCity", "length": 50, "domain": null }, { "name": "ExtType", "type": "esriFieldTypeString", "alias": "ExtType", "length": 50, "domain": null }, { "name": "CondoLocation", "type": "esriFieldTypeString", "alias": "CondoLocation", "length": 50, "domain": null }, { "name": "LegalReference", "type": "esriFieldTypeString", "alias": "LegalReference", "length": 50, "domain": null }, { "name": "GrantorLastName", "type": "esriFieldTypeString", "alias": "GrantorLastName", "length": 100, "domain": null }, { "name": "AltLocations", "type": "esriFieldTypeString", "alias": "AltLocations", "length": 1073741822, "domain": null }, { "name": "RouteNumber", "type": "esriFieldTypeString", "alias": "RouteNumber", "length": 50, "domain": null }, { "name": "OwnersMailingLabel", "type": "esriFieldTypeString", "alias": "OwnersMailingLabel", "length": 1073741822, "domain": null }, { "name": "LastUpdatedDate", "type": "esriFieldTypeDate", "alias": "LastUpdatedDate", "length": 8, "domain": null }, { "name": "Image", "type": "esriFieldTypeString", "alias": "Image", "length": 75, "domain": null }, { "name": "SitePostalCode", "type": "esriFieldTypeString", "alias": "SitePostalCode", "length": 5, "domain": null } ], "indexes": [ { "name": "FDO_AccountNumber", "fields": "AccountNumber", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "d90f8219bc774e37bf388f7d9dee036f" }