{ "currentVersion": 10.61, "id": 7, "name": "Improvement Value", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ACCOUNTNO", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "ACCOUNTNO", "type": "esriFieldTypeString", "alias": "ACCOUNTNO", "length": 30, "domain": null }, { "name": "MHTAGNO", "type": "esriFieldTypeString", "alias": "MHTAGNO", "length": 30, "domain": null }, { "name": "IMPINTERIORADJPCT", "type": "esriFieldTypeDouble", "alias": "IMPINTERIORADJPCT", "domain": null }, { "name": "COSTPHYSICALDEPRVALUE", "type": "esriFieldTypeDouble", "alias": "COSTPHYSICALDEPRVALUE", "domain": null }, { "name": "IMPCONDITIONTYPE", "type": "esriFieldTypeString", "alias": "IMPCONDITIONTYPE", "length": 40, "domain": null }, { "name": "INCOMEOVERRIDEVALUE", "type": "esriFieldTypeDouble", "alias": "INCOMEOVERRIDEVALUE", "domain": null }, { "name": "IMPQUALITY", "type": "esriFieldTypeString", "alias": "IMPQUALITY", "length": 15, "domain": null }, { "name": "COSTMETHOD", "type": "esriFieldTypeString", "alias": "COSTMETHOD", "length": 30, "domain": null }, { "name": "APPROACHTYPE", "type": "esriFieldTypeString", "alias": "APPROACHTYPE", "length": 15, "domain": null }, { "name": "PROPERTYTYPE", "type": "esriFieldTypeString", "alias": "PROPERTYTYPE", "length": 15, "domain": null }, { "name": "ECONOMICOBSOLESCEPCT", "type": "esriFieldTypeDouble", "alias": "ECONOMICOBSOLESCEPCT", "domain": null }, { "name": "IMPUNITTYPE", "type": "esriFieldTypeString", "alias": "IMPUNITTYPE", "length": 30, "domain": null }, { "name": "COSTMLPDEPRVALUE", "type": "esriFieldTypeDouble", "alias": "COSTMLPDEPRVALUE", "domain": null }, { "name": "IMPSVALUEOM0", "type": "esriFieldTypeString", "alias": "IMPSVALUEOM0", "length": 50, "domain": null }, { "name": "IMPSVALUEOM1", "type": "esriFieldTypeString", "alias": "IMPSVALUEOM1", "length": 50, "domain": null }, { "name": "COSTRCN", "type": "esriFieldTypeDouble", "alias": "COSTRCN", "domain": null }, { "name": "COSTCONDITIONMULTIPLIER", "type": "esriFieldTypeDouble", "alias": "COSTCONDITIONMULTIPLIER", "domain": null }, { "name": "INCOMELASTCALCDATE", "type": "esriFieldTypeDate", "alias": "INCOMELASTCALCDATE", "length": 8, "domain": null }, { "name": "INCOMEMETHOD", "type": "esriFieldTypeString", "alias": "INCOMEMETHOD", "length": 30, "domain": null }, { "name": "RECONCILEIMPVALUE", "type": "esriFieldTypeDouble", "alias": "RECONCILEIMPVALUE", "domain": null }, { "name": "COSTVALUEPER", "type": "esriFieldTypeDouble", "alias": "COSTVALUEPER", "domain": null }, { "name": "OWNEROCCUPIEDFLAG", "type": "esriFieldTypeInteger", "alias": "OWNEROCCUPIEDFLAG", "domain": null }, { "name": "IMPSVALUEOT0", "type": "esriFieldTypeString", "alias": "IMPSVALUEOT0", "length": 50, "domain": null }, { "name": "COSTVALUEBY", "type": "esriFieldTypeString", "alias": "COSTVALUEBY", "length": 10, "domain": null }, { "name": "IMPSOD1", "type": "esriFieldTypeDate", "alias": "IMPSOD1", "length": 8, "domain": null }, { "name": "IMPSOD0", "type": "esriFieldTypeDate", "alias": "IMPSOD0", "length": 8, "domain": null }, { "name": "IMPNETSF", "type": "esriFieldTypeDouble", "alias": "IMPNETSF", "domain": null }, { "name": "RECONCILELASTCALCDATE", "type": "esriFieldTypeDate", "alias": "RECONCILELASTCALCDATE", "length": 8, "domain": null }, { "name": "COSTROUGHINTOTALADJVALUE", "type": "esriFieldTypeDouble", "alias": "COSTROUGHINTOTALADJVALUE", "domain": null }, { "name": "IMPSVALUEOD1", "type": "esriFieldTypeDate", "alias": "IMPSVALUEOD1", "length": 8, "domain": null }, { "name": "IMPSVALUEOD0", "type": "esriFieldTypeDate", "alias": "IMPSVALUEOD0", "length": 8, "domain": null }, { "name": "COSTFUNCTIONALOBSVALUE", "type": "esriFieldTypeDouble", "alias": "COSTFUNCTIONALOBSVALUE", "domain": null }, { "name": "MARKETOTHERADJVALUE", "type": "esriFieldTypeDouble", "alias": "MARKETOTHERADJVALUE", "domain": null }, { "name": "MARKETACTUALVALUE", "type": "esriFieldTypeDouble", "alias": "MARKETACTUALVALUE", "domain": null }, { "name": "INCOMEACTUALVALUE", "type": "esriFieldTypeDouble", "alias": "INCOMEACTUALVALUE", "domain": null }, { "name": "IMPNO", "type": "esriFieldTypeDouble", "alias": "IMPNO", "domain": null }, { "name": "COSTAMATEURADJVALUE", "type": "esriFieldTypeDouble", "alias": "COSTAMATEURADJVALUE", "domain": null }, { "name": "IMPSOT1", "type": "esriFieldTypeString", "alias": "IMPSOT1", "length": 50, "domain": null }, { "name": "MHTITLENO", "type": "esriFieldTypeString", "alias": "MHTITLENO", "length": 30, "domain": null }, { "name": "MARKETMASSVALUE", "type": "esriFieldTypeDouble", "alias": "MARKETMASSVALUE", "domain": null }, { "name": "LANDATTRIBUTEDPCT", "type": "esriFieldTypeDouble", "alias": "LANDATTRIBUTEDPCT", "domain": null }, { "name": "COSTLASTCALCDATE", "type": "esriFieldTypeDate", "alias": "COSTLASTCALCDATE", "length": 8, "domain": null }, { "name": "IMPAMATEURADJPCT", "type": "esriFieldTypeDouble", "alias": "IMPAMATEURADJPCT", "domain": null }, { "name": "APPRAISER", "type": "esriFieldTypeString", "alias": "APPRAISER", "length": 20, "domain": null }, { "name": "MHSERIALNO", "type": "esriFieldTypeString", "alias": "MHSERIALNO", "length": 30, "domain": null }, { "name": "COSTACTUALVALUE", "type": "esriFieldTypeDouble", "alias": "COSTACTUALVALUE", "domain": null }, { "name": "IMPSVALUEOT1", "type": "esriFieldTypeString", "alias": "IMPSVALUEOT1", "length": 50, "domain": null }, { "name": "IMPSVALUEON1", "type": "esriFieldTypeDouble", "alias": "IMPSVALUEON1", "domain": null }, { "name": "IMPSVALUEON0", "type": "esriFieldTypeDouble", "alias": "IMPSVALUEON0", "domain": null }, { "name": "IMPSVALUEON2", "type": "esriFieldTypeDouble", "alias": "IMPSVALUEON2", "domain": null }, { "name": "MARKETOVERRIDEVALUE", "type": "esriFieldTypeDouble", "alias": "MARKETOVERRIDEVALUE", "domain": null }, { "name": "IMPSOM0", "type": "esriFieldTypeString", "alias": "IMPSOM0", "length": 50, "domain": null }, { "name": "IMPSOM1", "type": "esriFieldTypeString", "alias": "IMPSOM1", "length": 50, "domain": null }, { "name": "COSTQUALITYADJUSTMENT", "type": "esriFieldTypeDouble", "alias": "COSTQUALITYADJUSTMENT", "domain": null }, { "name": "CONDOIMPPERCENT", "type": "esriFieldTypeDouble", "alias": "CONDOIMPPERCENT", "domain": null }, { "name": "IMPDESIGNADJPCT", "type": "esriFieldTypeDouble", "alias": "IMPDESIGNADJPCT", "domain": null }, { "name": "COSTRCNLD", "type": "esriFieldTypeDouble", "alias": "COSTRCNLD", "domain": null }, { "name": "COSTECONOMICOBSVALUE", "type": "esriFieldTypeDouble", "alias": "COSTECONOMICOBSVALUE", "domain": null }, { "name": "PARCELNO", "type": "esriFieldTypeString", "alias": "PARCELNO", "length": 30, "domain": null }, { "name": "COSTDESIGNADJVALUE", "type": "esriFieldTypeDouble", "alias": "COSTDESIGNADJVALUE", "domain": null }, { "name": "COSTLANDSCAPINGVALUE", "type": "esriFieldTypeDouble", "alias": "COSTLANDSCAPINGVALUE", "domain": null }, { "name": "COSTPROPERTYTYPEADJUSTMENT", "type": "esriFieldTypeDouble", "alias": "COSTPROPERTYTYPEADJUSTMENT", "domain": null }, { "name": "IMPPHYSICALDEPRPCT", "type": "esriFieldTypeDouble", "alias": "IMPPHYSICALDEPRPCT", "domain": null }, { "name": "COSTOVERRIDEVALUE", "type": "esriFieldTypeDouble", "alias": "COSTOVERRIDEVALUE", "domain": null }, { "name": "TAXYEAR", "type": "esriFieldTypeInteger", "alias": "TAXYEAR", "domain": null }, { "name": "MHDECALNO", "type": "esriFieldTypeString", "alias": "MHDECALNO", "length": 30, "domain": null }, { "name": "CONDOLANDPERCENT", "type": "esriFieldTypeDouble", "alias": "CONDOLANDPERCENT", "domain": null }, { "name": "FUNCTIONALOBSOLESCEPCT", "type": "esriFieldTypeDouble", "alias": "FUNCTIONALOBSOLESCEPCT", "domain": null }, { "name": "IMPACTUALVALUE", "type": "esriFieldTypeDouble", "alias": "IMPACTUALVALUE", "domain": null }, { "name": "IMPOTHERADJPCT", "type": "esriFieldTypeDouble", "alias": "IMPOTHERADJPCT", "domain": null }, { "name": "COSTEXTERIORADJVALUE", "type": "esriFieldTypeDouble", "alias": "COSTEXTERIORADJVALUE", "domain": null }, { "name": "IMPSON1", "type": "esriFieldTypeDouble", "alias": "IMPSON1", "domain": null }, { "name": "IMPSON0", "type": "esriFieldTypeDouble", "alias": "IMPSON0", "domain": null }, { "name": "IMPSON2", "type": "esriFieldTypeDouble", "alias": "IMPSON2", "domain": null }, { "name": "MARKETLASTCALCDATE", "type": "esriFieldTypeDate", "alias": "MARKETLASTCALCDATE", "length": 8, "domain": null }, { "name": "IMPSOT0", "type": "esriFieldTypeString", "alias": "IMPSOT0", "length": 50, "domain": null }, { "name": "IMPPERIMETER", "type": "esriFieldTypeDouble", "alias": "IMPPERIMETER", "domain": null }, { "name": "CONDOIMPSF", "type": "esriFieldTypeDouble", "alias": "CONDOIMPSF", "domain": null }, { "name": "COSTPLUMBINGTOTALADJVALUE", "type": "esriFieldTypeDouble", "alias": "COSTPLUMBINGTOTALADJVALUE", "domain": null }, { "name": "MHTOTALLENGTH", "type": "esriFieldTypeDouble", "alias": "MHTOTALLENGTH", "domain": null }, { "name": "COSTOTHERADJVALUE", "type": "esriFieldTypeDouble", "alias": "COSTOTHERADJVALUE", "domain": null }, { "name": "MARKETMETHOD", "type": "esriFieldTypeString", "alias": "MARKETMETHOD", "length": 30, "domain": null }, { "name": "APPRAISALTYPE", "type": "esriFieldTypeString", "alias": "APPRAISALTYPE", "length": 30, "domain": null }, { "name": "COSTINTERIORADJVALUE", "type": "esriFieldTypeDouble", "alias": "COSTINTERIORADJVALUE", "domain": null }, { "name": "APPRAISALDATE", "type": "esriFieldTypeDate", "alias": "APPRAISALDATE", "length": 8, "domain": null }, { "name": "COSTMLPDEPRPCT", "type": "esriFieldTypeDouble", "alias": "COSTMLPDEPRPCT", "domain": null }, { "name": "COSTMLPLD", "type": "esriFieldTypeDouble", "alias": "COSTMLPLD", "domain": null }, { "name": "MKTREGRESSIONOVERRIDEVALUE", "type": "esriFieldTypeDouble", "alias": "MKTREGRESSIONOVERRIDEVALUE", "domain": null }, { "name": "INCOMEVALUEBY", "type": "esriFieldTypeString", "alias": "INCOMEVALUEBY", "length": 10, "domain": null }, { "name": "COSTMLP", "type": "esriFieldTypeDouble", "alias": "COSTMLP", "domain": null }, { "name": "IMPSF", "type": "esriFieldTypeDouble", "alias": "IMPSF", "domain": null }, { "name": "IMPCOMPLETEDPCT", "type": "esriFieldTypeDouble", "alias": "IMPCOMPLETEDPCT", "domain": null }, { "name": "COSTPHYSICALDEPRPCT", "type": "esriFieldTypeDouble", "alias": "COSTPHYSICALDEPRPCT", "domain": null }, { "name": "MARKETVALUEBY", "type": "esriFieldTypeString", "alias": "MARKETVALUEBY", "length": 10, "domain": null }, { "name": "IMPDESCRIPTION", "type": "esriFieldTypeString", "alias": "IMPDESCRIPTION", "length": 100, "domain": null }, { "name": "IMPEXTERIORADJPCT", "type": "esriFieldTypeDouble", "alias": "IMPEXTERIORADJPCT", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R24_SDE_ROWID_UK", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_24", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G15PARCELNO", "fields": "PARCELNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G15ACCOUNTNO", "fields": "ACCOUNTNO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_24", "fields": "GlobalID,OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "ImprovementValueToParcels", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PARCELNO", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }