{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 5, "name": "ParcelWeb", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Owner_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ObjectID", "type": "esriFieldTypeOID", "alias": "ObjectID", "domain": null }, { "name": "Last_Update", "type": "esriFieldTypeDate", "alias": "Last Update", "length": 8, "precision": 1, "domain": null }, { "name": "Account", "type": "esriFieldTypeString", "alias": "Account", "length": 25, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 2, "domain": null }, { "name": "Parcel_ID", "type": "esriFieldTypeString", "alias": "Parcel ID", "length": 27, "domain": null }, { "name": "Lot_Num", "type": "esriFieldTypeString", "alias": "Lot Number", "length": 4, "domain": null }, { "name": "Lot_Split", "type": "esriFieldTypeString", "alias": "Lot Split", "length": 7, "domain": null }, { "name": "Owner_name", "type": "esriFieldTypeString", "alias": "Owner Name", "length": 100, "domain": null }, { "name": "MailingAddress", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 50, "domain": null }, { "name": "MailingCity", "type": "esriFieldTypeString", "alias": "Mailing City", "length": 50, "domain": null }, { "name": "MailingState", "type": "esriFieldTypeString", "alias": "Mailing State", "length": 2, "domain": null }, { "name": "MailingZip", "type": "esriFieldTypeString", "alias": "Mailing Zip", "length": 10, "domain": null }, { "name": "LotSize", "type": "esriFieldTypeString", "alias": "Lot Size", "length": 20, "domain": null }, { "name": "StrNum", "type": "esriFieldTypeString", "alias": "Situs Number", "length": 20, "domain": null }, { "name": "SitusName", "type": "esriFieldTypeString", "alias": "Situs Street", "length": 82, "domain": null }, { "name": "SitusCity", "type": "esriFieldTypeString", "alias": "Situs City", "length": 50, "domain": null }, { "name": "SitusZIP", "type": "esriFieldTypeString", "alias": "Situs ZIP", "length": 5, "domain": null }, { "name": "YearBuilt", "type": "esriFieldTypeSmallInteger", "alias": "Year Built", "domain": null }, { "name": "BaseArea", "type": "esriFieldTypeInteger", "alias": "Base Area", "domain": null }, { "name": "TotalArea", "type": "esriFieldTypeInteger", "alias": "Total Area", "domain": null }, { "name": "GarageArea", "type": "esriFieldTypeInteger", "alias": "Garage Area", "domain": null }, { "name": "BasementArea", "type": "esriFieldTypeInteger", "alias": "Basement Area", "domain": null }, { "name": "BasementFinishedArea", "type": "esriFieldTypeInteger", "alias": "Basement Finished Area", "domain": null }, { "name": "ArchType", "type": "esriFieldTypeString", "alias": "ArchType", "length": 4, "domain": null }, { "name": "OccCode", "type": "esriFieldTypeString", "alias": "OccCode", "length": 4, "domain": null }, { "name": "Bedrooms", "type": "esriFieldTypeDouble", "alias": "Bedrooms", "domain": null }, { "name": "Bathrooms", "type": "esriFieldTypeDouble", "alias": "Bathrooms", "domain": null }, { "name": "HalfBathrooms", "type": "esriFieldTypeDouble", "alias": "HalfBathrooms", "domain": null }, { "name": "fireplaces", "type": "esriFieldTypeDouble", "alias": "Fireplaces", "domain": null }, { "name": "ExteriorWalls", "type": "esriFieldTypeString", "alias": "ExteriorWalls", "length": 255, "domain": null }, { "name": "ExteriorWallPercentage", "type": "esriFieldTypeString", "alias": "ExteriorWallPercentage", "length": 100, "domain": null }, { "name": "GarageStalls", "type": "esriFieldTypeDouble", "alias": "GarageStalls", "domain": null }, { "name": "TotalRooms", "type": "esriFieldTypeDouble", "alias": "TotalRooms", "domain": null }, { "name": "City", "type": "esriFieldTypeString", "alias": "City", "length": 6, "domain": null }, { "name": "Fire", "type": "esriFieldTypeString", "alias": "Fire", "length": 6, "domain": null }, { "name": "NbhdCode", "type": "esriFieldTypeString", "alias": "NbhdCode", "length": 4, "domain": null }, { "name": "PropType", "type": "esriFieldTypeString", "alias": "PropType", "length": 2, "domain": null }, { "name": "Legal", "type": "esriFieldTypeString", "alias": "Legal", "length": 500, "domain": null }, { "name": "TotalMarket", "type": "esriFieldTypeInteger", "alias": "Total Market", "domain": null }, { "name": "BookPage1", "type": "esriFieldTypeString", "alias": "BookPage1", "length": 12, "domain": null }, { "name": "PrevOwner1", "type": "esriFieldTypeString", "alias": "PrevOwner1", "length": 100, "domain": null }, { "name": "SaleDate1", "type": "esriFieldTypeString", "alias": "SaleDate1", "length": 10, "domain": null }, { "name": "SalePrice1", "type": "esriFieldTypeInteger", "alias": "SalePrice1", "domain": null }, { "name": "SaleAdjPrice1", "type": "esriFieldTypeInteger", "alias": "SaleAdjPrice1", "domain": null }, { "name": "SaleREACD1", "type": "esriFieldTypeString", "alias": "SaleREACD1", "length": 16, "domain": null }, { "name": "BookPage2", "type": "esriFieldTypeString", "alias": "BookPage2", "length": 12, "domain": null }, { "name": "PrevOwner2", "type": "esriFieldTypeString", "alias": "PrevOwner2", "length": 100, "domain": null }, { "name": "SaleDate2", "type": "esriFieldTypeString", "alias": "SaleDate2", "length": 10, "domain": null }, { "name": "SalePrice2", "type": "esriFieldTypeInteger", "alias": "SalePrice2", "domain": null }, { "name": "SaleAdjPrice2", "type": "esriFieldTypeInteger", "alias": "SaleAdjPrice2", "domain": null }, { "name": "SaleREACD2", "type": "esriFieldTypeString", "alias": "SaleREACD2", "length": 16, "domain": null }, { "name": "BookPage3", "type": "esriFieldTypeString", "alias": "BookPage3", "length": 12, "domain": null }, { "name": "PrevOwner3", "type": "esriFieldTypeString", "alias": "PrevOwner3", "length": 100, "domain": null }, { "name": "SaleDate3", "type": "esriFieldTypeString", "alias": "SaleDate3", "length": 10, "domain": null }, { "name": "SalePrice3", "type": "esriFieldTypeInteger", "alias": "SalePrice3", "domain": null }, { "name": "SaleAdjPrice3", "type": "esriFieldTypeInteger", "alias": "SaleAdjPrice3", "domain": null }, { "name": "SaleREACD3", "type": "esriFieldTypeString", "alias": "SaleREACD3", "length": 16, "domain": null }, { "name": "BookPage4", "type": "esriFieldTypeString", "alias": "BookPage4", "length": 12, "domain": null }, { "name": "PrevOwner4", "type": "esriFieldTypeString", "alias": "PrevOwner4", "length": 100, "domain": null }, { "name": "SaleDate4", "type": "esriFieldTypeString", "alias": "SaleDate4", "length": 10, "domain": null }, { "name": "SalePrice4", "type": "esriFieldTypeInteger", "alias": "SalePrice4", "domain": null }, { "name": "SaleAdjPrice4", "type": "esriFieldTypeInteger", "alias": "SaleAdjPrice4", "domain": null }, { "name": "SaleREACD4", "type": "esriFieldTypeString", "alias": "SaleREACD4", "length": 16, "domain": null }, { "name": "ResidentialAV", "type": "esriFieldTypeInteger", "alias": "ResidentialAV", "domain": null }, { "name": "CommercialAV", "type": "esriFieldTypeInteger", "alias": "CommercialAV", "domain": null }, { "name": "AgriculturalAV", "type": "esriFieldTypeInteger", "alias": "AgriculturalAV", "domain": null }, { "name": "TIF_District", "type": "esriFieldTypeString", "alias": "TIF_District", "length": 108, "domain": null }, { "name": "Subdivision", "type": "esriFieldTypeString", "alias": "Subdivision", "length": 100, "domain": null }, { "name": "Township", "type": "esriFieldTypeString", "alias": "Township", "length": 5, "domain": null }, { "name": "Range", "type": "esriFieldTypeString", "alias": "Range", "length": 5, "domain": null }, { "name": "QualCode", "type": "esriFieldTypeString", "alias": "QualCode", "length": 2, "domain": null }, { "name": "Style", "type": "esriFieldTypeString", "alias": "Style", "length": 100, "domain": null }, { "name": "build_style", "type": "esriFieldTypeString", "alias": "build_style", "length": 50, "domain": null }, { "name": "architectural_type", "type": "esriFieldTypeString", "alias": "architectural_type", "length": 50, "domain": null }, { "name": "land_mkt_val", "type": "esriFieldTypeInteger", "alias": "land_mkt_val", "domain": null }, { "name": "Topography", "type": "esriFieldTypeString", "alias": "Topography", "length": 50, "domain": null }, { "name": "Utilities", "type": "esriFieldTypeString", "alias": "Utilities", "length": 50, "domain": null }, { "name": "StreetSurface", "type": "esriFieldTypeString", "alias": "StreetSurface", "length": 50, "domain": null }, { "name": "SpecialInterest", "type": "esriFieldTypeString", "alias": "SpecialInterest", "length": 50, "domain": null }, { "name": "PropertyName", "type": "esriFieldTypeString", "alias": "PropertyName", "length": 50, "domain": null }, { "name": "CityName", "type": "esriFieldTypeString", "alias": "CityName", "length": 100, "domain": null }, { "name": "FireDistrictName", "type": "esriFieldTypeString", "alias": "FireDistrictName", "length": 100, "domain": null }, { "name": "SchoolDistrictId", "type": "esriFieldTypeString", "alias": "SchoolDistrictId", "length": 1, "domain": null }, { "name": "SchoolDistrictName", "type": "esriFieldTypeString", "alias": "SchoolDistrictName", "length": 100, "domain": null }, { "name": "PropTypeName", "type": "esriFieldTypeString", "alias": "PropTypeName", "length": 100, "domain": null }, { "name": "QualCodeDesc", "type": "esriFieldTypeString", "alias": "QualCodeDesc", "length": 255, "domain": null }, { "name": "OccCodeDesc", "type": "esriFieldTypeString", "alias": "OccCodeDesc", "length": 255, "domain": null }, { "name": "ArchTypeDesc", "type": "esriFieldTypeString", "alias": "ArchTypeDesc", "length": 255, "domain": null }, { "name": "LastRefreshDT", "type": "esriFieldTypeDate", "alias": "LastRefreshDT", "length": 8, "precision": 1, "domain": null }, { "name": "SitusNumberInt", "type": "esriFieldTypeInteger", "alias": "SitusNumberInt", "domain": null }, { "name": "SitusFull", "type": "esriFieldTypeString", "alias": "SitusFull", "length": 120, "domain": null }, { "name": "SaleDate1_dt", "type": "esriFieldTypeDate", "alias": "SaleDate1_dt", "length": 8, "precision": 1, "domain": null }, { "name": "SaleDate2_dt", "type": "esriFieldTypeDate", "alias": "SaleDate2_dt", "length": 8, "precision": 1, "domain": null }, { "name": "SaleDate3_dt", "type": "esriFieldTypeDate", "alias": "SaleDate3_dt", "length": 8, "precision": 1, "domain": null }, { "name": "SaleDate4_dt", "type": "esriFieldTypeDate", "alias": "SaleDate4_dt", "length": 8, "precision": 1, "domain": null }, { "name": "SaleQualifiedAny", "type": "esriFieldTypeSmallInteger", "alias": "SaleQualifiedAny", "domain": null }, { "name": "UPSF", "type": "esriFieldTypeDouble", "alias": "UPSF", "domain": null }, { "name": "SaleQualifiedAny_YN", "type": "esriFieldTypeString", "alias": "SaleQualifiedAny_YN", "length": 3, "domain": null }, { "name": "UPSF1", "type": "esriFieldTypeDouble", "alias": "UPSF1", "domain": null }, { "name": "UPSF2", "type": "esriFieldTypeDouble", "alias": "UPSF2", "domain": null }, { "name": "UPSF3", "type": "esriFieldTypeDouble", "alias": "UPSF3", "domain": null }, { "name": "UPSF4", "type": "esriFieldTypeDouble", "alias": "UPSF4", "domain": null } ], "indexes": [ { "name": "PK_ParcelWeb", "fields": "ObjectID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UX_ParcelWeb_Account", "fields": "Account", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UX_ParcelWeb_Parcel_ID", "fields": "Parcel_ID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "IX_ParcelWeb_SitusName_Num", "fields": "SitusName,SitusNumberInt,Account,StrNum,SitusFull,Owner_name,City,CityName,SitusZIP,Subdivision", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_Owner", "fields": "Owner_name,Account,SitusName,StrNum,SitusFull,City,CityName,SitusZIP", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_City", "fields": "City,CityName,Account,SitusFull,SitusZIP,Owner_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_SitusZIP", "fields": "SitusZIP,Account,SitusFull,City,CityName,Owner_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_Subdivision", "fields": "Subdivision,Account,SitusFull,Owner_name,CityName", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_NbhdCode", "fields": "NbhdCode,Account,SitusFull,Owner_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_PropType", "fields": "PropType,PropTypeName,Account,SitusFull,Owner_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_SaleDate1", "fields": "SaleDate1_dt", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_YearBuilt", "fields": "YearBuilt,Account,SitusFull,Owner_name,TotalArea", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_SchoolDistrict", "fields": "SchoolDistrictId,SchoolDistrictName,Account,SitusFull,Owner_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_OccCode", "fields": "OccCode,OccCodeDesc,Account,SitusFull", "isAscending": true, "isUnique": false, "description": "" }, { "name": "IX_ParcelWeb_QualCode", "fields": "QualCode,QualCodeDesc,Account,SitusFull", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_ObjectID", "fields": "ObjectID", "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, "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 }, "uniqueIdInfo": { "type": "simple", "fields": [ "ObjectID" ], "OIDFieldContainsHashValue": false }, "maxUniqueIDCount": 100000, "serviceItemId": "ccaff344071a4d55bbcbcebb78205965" }