{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 8, "name": "GIS_Web.SDE.GIS_Extract", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "l_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "pin", "type": "esriFieldTypeString", "alias": "pin", "length": 12, "domain": null }, { "name": "gis_oid", "type": "esriFieldTypeString", "alias": "gis_oid", "length": 10, "domain": null }, { "name": "levy_code", "type": "esriFieldTypeString", "alias": "levy_code", "length": 10, "domain": null }, { "name": "mainlot", "type": "esriFieldTypeString", "alias": "mainlot", "length": 10, "domain": null }, { "name": "mainblock", "type": "esriFieldTypeString", "alias": "mainblock", "length": 10, "domain": null }, { "name": "mainsub", "type": "esriFieldTypeString", "alias": "mainsub", "length": 50, "domain": null }, { "name": "lot_dims", "type": "esriFieldTypeString", "alias": "lot_dims", "length": 50, "domain": null }, { "name": "prop_segs", "type": "esriFieldTypeString", "alias": "prop_segs", "length": 100, "domain": null }, { "name": "mainacres", "type": "esriFieldTypeDouble", "alias": "mainacres", "domain": null }, { "name": "liv_sq_ft", "type": "esriFieldTypeDouble", "alias": "liv_sq_ft", "domain": null }, { "name": "tot_sq_ft", "type": "esriFieldTypeDouble", "alias": "tot_sq_ft", "domain": null }, { "name": "year_blt", "type": "esriFieldTypeDouble", "alias": "year_blt", "domain": null }, { "name": "ef_yr_blt", "type": "esriFieldTypeDouble", "alias": "ef_yr_blt", "domain": null }, { "name": "owner", "type": "esriFieldTypeString", "alias": "owner", "length": 254, "domain": null }, { "name": "owneraddy", "type": "esriFieldTypeString", "alias": "owneraddy", "length": 120, "domain": null }, { "name": "ownercity", "type": "esriFieldTypeString", "alias": "ownercity", "length": 30, "domain": null }, { "name": "ownerstat", "type": "esriFieldTypeString", "alias": "ownerstat", "length": 5, "domain": null }, { "name": "ownerzip", "type": "esriFieldTypeString", "alias": "ownerzip", "length": 10, "domain": null }, { "name": "taxpayer", "type": "esriFieldTypeString", "alias": "taxpayer", "length": 254, "domain": null }, { "name": "tpyraddy", "type": "esriFieldTypeString", "alias": "tpyraddy", "length": 120, "domain": null }, { "name": "tpyrcity", "type": "esriFieldTypeString", "alias": "tpyrcity", "length": 30, "domain": null }, { "name": "tpyrstat", "type": "esriFieldTypeString", "alias": "tpyrstat", "length": 5, "domain": null }, { "name": "tpyrzip", "type": "esriFieldTypeString", "alias": "tpyrzip", "length": 10, "domain": null }, { "name": "r_mkt_val", "type": "esriFieldTypeDouble", "alias": "r_mkt_val", "domain": null }, { "name": "r_lnd_val", "type": "esriFieldTypeDouble", "alias": "r_lnd_val", "domain": null }, { "name": "r_bld_val", "type": "esriFieldTypeDouble", "alias": "r_bld_val", "domain": null }, { "name": "r_fea_val", "type": "esriFieldTypeDouble", "alias": "r_fea_val", "domain": null }, { "name": "r_cls_val", "type": "esriFieldTypeDouble", "alias": "r_cls_val", "domain": null }, { "name": "tax_capac", "type": "esriFieldTypeDouble", "alias": "tax_capac", "domain": null }, { "name": "tif_dist", "type": "esriFieldTypeDouble", "alias": "tif_dist", "domain": null }, { "name": "orig_tax", "type": "esriFieldTypeDouble", "alias": "orig_tax", "domain": null }, { "name": "adj_tax", "type": "esriFieldTypeDouble", "alias": "adj_tax", "domain": null }, { "name": "spec_ass", "type": "esriFieldTypeDouble", "alias": "spec_ass", "domain": null }, { "name": "c_cls_val", "type": "esriFieldTypeDouble", "alias": "c_cls_val", "domain": null }, { "name": "sale_date", "type": "esriFieldTypeString", "alias": "sale_date", "length": 10, "domain": null }, { "name": "sale_price", "type": "esriFieldTypeDouble", "alias": "sale_price", "domain": null }, { "name": "l_city", "type": "esriFieldTypeString", "alias": "l_city", "length": 30, "domain": null }, { "name": "l_numb", "type": "esriFieldTypeString", "alias": "l_numb", "length": 6, "domain": null }, { "name": "l_num_suf", "type": "esriFieldTypeString", "alias": "l_num_suf", "length": 20, "domain": null }, { "name": "l_2_numb", "type": "esriFieldTypeString", "alias": "l_2_numb", "length": 10, "domain": null }, { "name": "l_2_nmbsf", "type": "esriFieldTypeString", "alias": "l_2_nmbsf", "length": 20, "domain": null }, { "name": "l_name", "type": "esriFieldTypeString", "alias": "l_name", "length": 30, "domain": null }, { "name": "l_type", "type": "esriFieldTypeString", "alias": "l_type", "length": 10, "domain": null }, { "name": "l_predir", "type": "esriFieldTypeString", "alias": "l_predir", "length": 5, "domain": null }, { "name": "l_postdir", "type": "esriFieldTypeString", "alias": "l_postdir", "length": 10, "domain": null }, { "name": "l_zip", "type": "esriFieldTypeString", "alias": "l_zip", "length": 10, "domain": null }, { "name": "l_u_type", "type": "esriFieldTypeString", "alias": "l_u_type", "length": 10, "domain": null }, { "name": "l_u_numb", "type": "esriFieldTypeString", "alias": "l_u_numb", "length": 10, "domain": null }, { "name": "mtg_code", "type": "esriFieldTypeString", "alias": "mtg_code", "length": 5, "domain": null }, { "name": "ltd_M_val", "type": "esriFieldTypeDouble", "alias": "ltd_M_val", "domain": null }, { "name": "ltd_L_val", "type": "esriFieldTypeDouble", "alias": "ltd_L_val", "domain": null }, { "name": "ltd_I_val", "type": "esriFieldTypeDouble", "alias": "ltd_I_val", "domain": null }, { "name": "pad_count", "type": "esriFieldTypeDouble", "alias": "pad_count", "domain": null }, { "name": "bedrooms", "type": "esriFieldTypeDouble", "alias": "bedrooms", "domain": null }, { "name": "bathrooms", "type": "esriFieldTypeDouble", "alias": "bathrooms", "domain": null }, { "name": "stories", "type": "esriFieldTypeDouble", "alias": "stories", "domain": null }, { "name": "base_ment", "type": "esriFieldTypeString", "alias": "base_ment", "length": 1, "domain": null }, { "name": "new_const", "type": "esriFieldTypeDouble", "alias": "new_const", "domain": null }, { "name": "demo", "type": "esriFieldTypeDouble", "alias": "demo", "domain": null }, { "name": "pca_code", "type": "esriFieldTypeString", "alias": "pca_code", "length": 4, "domain": null }, { "name": "struc_typ", "type": "esriFieldTypeString", "alias": "struc_typ", "length": 50, "domain": null }, { "name": "exempt", "type": "esriFieldTypeString", "alias": "exempt", "length": 5, "domain": null }, { "name": "chain", "type": "esriFieldTypeString", "alias": "chain", "length": 5, "domain": null }, { "name": "nbhd", "type": "esriFieldTypeString", "alias": "nbhd", "length": 50, "domain": null }, { "name": "flag1", "type": "esriFieldTypeSmallInteger", "alias": "flag1", "domain": null } ], "indexes": [ { "name": "R590_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_1778_pin", "fields": "pin", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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 } }