{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 36, "name": "Owner Assessment Taxes", "type": "Table", "description": "Owner Assessment Taxes extract form AS400", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MUN", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MUN", "type": "esriFieldTypeString", "alias": "MUN CODE", "length": 3, "domain": null }, { "name": "PIN", "type": "esriFieldTypeString", "alias": "Parcel Number", "length": 17, "domain": null }, { "name": "MLNME1", "type": "esriFieldTypeString", "alias": "Owner Name 1", "length": 32, "domain": null }, { "name": "MLNME2", "type": "esriFieldTypeString", "alias": "Owner Name 2", "length": 32, "domain": null }, { "name": "ADDR1", "type": "esriFieldTypeString", "alias": "Mailing Address", "length": 32, "domain": null }, { "name": "OLSTNM1", "type": "esriFieldTypeString", "alias": "Last Owner Name 1", "length": 30, "domain": null }, { "name": "OFSTNM1", "type": "esriFieldTypeString", "alias": "First Name Owner 1", "length": 15, "domain": null }, { "name": "OMI1", "type": "esriFieldTypeString", "alias": "MI Owner 1", "length": 1, "domain": null }, { "name": "JRSR1", "type": "esriFieldTypeString", "alias": "JrSr Owner 1", "length": 3, "domain": null }, { "name": "VOLPG1", "type": "esriFieldTypeString", "alias": "Document Number", "length": 27, "domain": null }, { "name": "HSEPRE1", "type": "esriFieldTypeString", "alias": "House Number Prefix", "length": 2, "domain": null }, { "name": "HSENO1", "type": "esriFieldTypeInteger", "alias": "House Number", "domain": null }, { "name": "HALF1", "type": "esriFieldTypeString", "alias": "House Number Suffix", "length": 3, "domain": null }, { "name": "STRDIR1", "type": "esriFieldTypeString", "alias": "Street Direction", "length": 2, "domain": null }, { "name": "STREET1", "type": "esriFieldTypeString", "alias": "Street Name", "length": 25, "domain": null }, { "name": "HSUNT11", "type": "esriFieldTypeString", "alias": "Apt/Unit", "length": 4, "domain": null }, { "name": "CITY1", "type": "esriFieldTypeString", "alias": "City", "length": 20, "domain": null }, { "name": "PSTAT", "type": "esriFieldTypeString", "alias": "Status", "length": 1, "domain": null }, { "name": "TAXYRDES", "type": "esriFieldTypeSmallInteger", "alias": "Legal Year", "domain": null }, { "name": "ACRE", "type": "esriFieldTypeDouble", "alias": "Acre", "domain": null }, { "name": "DESC01", "type": "esriFieldTypeString", "alias": "Legal Description 1", "length": 28, "domain": null }, { "name": "DESC02", "type": "esriFieldTypeString", "alias": "Legal Description 2", "length": 28, "domain": null }, { "name": "TWNDST", "type": "esriFieldTypeSmallInteger", "alias": "Tax District", "domain": null }, { "name": "TAXYRASM", "type": "esriFieldTypeSmallInteger", "alias": "Assessment Year", "domain": null }, { "name": "TACRE", "type": "esriFieldTypeDouble", "alias": "Acre", "domain": null }, { "name": "TLNDV", "type": "esriFieldTypeInteger", "alias": "Land Value", "domain": null }, { "name": "TAXYR", "type": "esriFieldTypeSmallInteger", "alias": "Tax Year", "domain": null }, { "name": "GTXDUE_AMT", "type": "esriFieldTypeDouble", "alias": "Gerneral Tax", "domain": null }, { "name": "FCTAX", "type": "esriFieldTypeDouble", "alias": "FCTAX", "domain": null }, { "name": "WLTAX", "type": "esriFieldTypeDouble", "alias": "WLTAX", "domain": null }, { "name": "MFTAX", "type": "esriFieldTypeDouble", "alias": "MFTAX", "domain": null }, { "name": "MCTAX", "type": "esriFieldTypeDouble", "alias": "MCTAX", "domain": null }, { "name": "SPAMOUNT", "type": "esriFieldTypeDouble", "alias": "SPAMOUNT", "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 20, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": null }, { "name": "ZIP5", "type": "esriFieldTypeString", "alias": "Zip Code", "length": 5, "domain": null }, { "name": "TIMPV", "type": "esriFieldTypeInteger", "alias": "Total Improved Value", "domain": null }, { "name": "DELIND", "type": "esriFieldTypeString", "alias": "Delinquent", "length": 1, "domain": null }, { "name": "EFMVALUE", "type": "esriFieldTypeInteger", "alias": "Estimated Fare Market Value", "domain": null }, { "name": "DEDTYP", "type": "esriFieldTypeString", "alias": "Dead Type", "length": 2, "domain": null }, { "name": "SALAMT", "type": "esriFieldTypeInteger", "alias": "Latest Sale Amount", "domain": null }, { "name": "SALDTE", "type": "esriFieldTypeInteger", "alias": "Sale Date", "domain": null }, { "name": "SALTYP", "type": "esriFieldTypeString", "alias": "Sale Type", "length": 1, "domain": null }, { "name": "LEGAL_1_2", "type": "esriFieldTypeString", "alias": "Short Legal", "length": 57, "domain": null }, { "name": "pnmun", "type": "esriFieldTypeString", "alias": "pnmun", "length": 3, "domain": null }, { "name": "pntown", "type": "esriFieldTypeString", "alias": "pntown", "length": 2, "domain": null }, { "name": "pnrang", "type": "esriFieldTypeString", "alias": "pnrang", "length": 2, "domain": null }, { "name": "pnsect", "type": "esriFieldTypeString", "alias": "pnsect", "length": 2, "domain": null }, { "name": "pnqtr", "type": "esriFieldTypeString", "alias": "pnqtr", "length": 2, "domain": null }, { "name": "pnid", "type": "esriFieldTypeString", "alias": "pnid", "length": 3, "domain": null }, { "name": "SALDTE_Converted", "type": "esriFieldTypeDate", "alias": "Sale Date", "length": 8, "domain": null }, { "name": "LRSURL", "type": "esriFieldTypeString", "alias": "Detailed Info", "length": 200, "domain": null }, { "name": "SCHOOL_DIST", "type": "esriFieldTypeString", "alias": "School District Code", "length": 255, "domain": null }, { "name": "TECH_SCHOOL_DIST", "type": "esriFieldTypeString", "alias": "Tech School District Code", "length": 255, "domain": null }, { "name": "SANI_DIST", "type": "esriFieldTypeString", "alias": "Sanitary Sewer District Code", "length": 255, "domain": null }, { "name": "LAKE_DIST", "type": "esriFieldTypeString", "alias": "Lake District Code", "length": 255, "domain": null }, { "name": "TAX_DIST_1", "type": "esriFieldTypeString", "alias": "Tax District #1 Code", "length": 255, "domain": null }, { "name": "TID_DIST", "type": "esriFieldTypeString", "alias": "TIF District Code", "length": 255, "domain": null } ], "indexes": [ { "name": "R516_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "PIN", "fields": "PIN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 10000, "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": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }