{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [], "indexes": [{ "name": "FDO_id", "isUnique": true, "description": "", "fields": "id", "isAscending": true }], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 3, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsQueryWithCacheHint": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": false, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "23b631d16a564f6f9f93750945f4897c", "capabilities": "Query,Map,Data", "hasLastEditTime": true, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": false, "supportsAdvancedQueries": true, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "timeInfo": {"timeReference": { "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true, "timeZone": "Pacific Standard Time" }}, "supportedQueryFormats": "JSON, PBF", "name": "dbo.developers", "displayField": "DEV_NAME", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "id", "alias": "id", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "DEV_NAME", "length": 255, "alias": "DEV_NAME", "type": "esriFieldTypeString" }, { "nullable": true, "precision": 1, "domain": null, "name": "DATE_RECD", "length": 8, "alias": "DATE_RECD", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "APPROV_DAT", "length": 8, "alias": "APPROV_DAT", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "CLOSE_DATE", "length": 8, "alias": "CLOSE_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "DATE_UPDAT", "length": 8, "alias": "DATE_UPDAT", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "DEV_SEC", "alias": "DEV_SEC", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "DEV_SEC2", "length": 10, "alias": "DEV_SEC2", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DEV_TOWN", "alias": "DEV_TOWN", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "DEV_RANGE", "alias": "DEV_RANGE", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "PROP_OWNER", "length": 75, "alias": "PROP_OWNER", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ENTITY_NUM", "length": 1024, "alias": "ENTITY_NUM", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ENTITY", "length": 20, "alias": "ENTITY", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "REVIEW_TYP", "length": 18, "alias": "REVIEW_TYP", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CONTACT", "length": 50, "alias": "CONTACT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ENG_FIRM", "length": 50, "alias": "ENG_FIRM", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ADDRESS", "length": 500, "alias": "ADDRESS", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DEV_TYPE", "length": 50, "alias": "DEV_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CON_TYPE", "length": 50, "alias": "CON_TYPE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "UNITS", "length": 10, "alias": "UNITS", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FAX", "length": 30, "alias": "FAX", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "PHONE", "length": 30, "alias": "PHONE", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ACREAGE", "alias": "ACREAGE", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "CSTREET1", "length": 30, "alias": "CSTREET1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CSTREET2", "length": 80, "alias": "CSTREET2", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FLOODZONE", "alias": "FLOODZONE", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ADJACENT", "alias": "ADJACENT", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "CONSTRUCT", "alias": "CONSTRUCT", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ABS", "alias": "ABS", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ADJACENT_TXT", "length": 4000, "alias": "ADJACENT_TXT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FLOODZONE_TXT", "length": 20, "alias": "FLOODZONE_TXT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CONSTRUCT_TXT", "length": 500, "alias": "CONSTRUCT_TXT", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "REVIEW", "alias": "REVIEW", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "precision": 1, "domain": null, "name": "REVIEW_DATE", "length": 8, "alias": "REVIEW_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "INCOMPLETE", "alias": "INCOMPLETE", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ENG_SEAL", "alias": "ENG_SEAL", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "COMMENT", "alias": "COMMENT", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "precision": 1, "domain": null, "name": "COM_DATE", "length": 8, "alias": "COM_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "COM_COUNT", "alias": "COM_COUNT", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "ONHAND", "alias": "ONHAND", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "precision": 1, "domain": null, "name": "ONHAND_DATE", "length": 8, "alias": "ONHAND_DATE", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "PENDING", "alias": "PENDING", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "ADDINFO", "alias": "ADDINFO", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "OTHER", "alias": "OTHER", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "SCAN", "alias": "SCAN", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "plans", "alias": "plans", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "miscd", "alias": "miscd", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "finalize", "alias": "finalize", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "precision": 1, "domain": null, "name": "final_date", "length": 8, "alias": "final_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "note_date", "length": 8, "alias": "note_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "tag", "length": 10, "alias": "tag", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "code", "length": 15, "alias": "code", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "uid", "length": 50, "alias": "uid", "type": "esriFieldTypeString" }, { "nullable": true, "precision": 1, "domain": null, "name": "ti", "length": 8, "alias": "ti", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s_date", "length": 8, "alias": "s_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s_rdate", "length": 8, "alias": "s_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a1_date", "length": 8, "alias": "a1_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a1_rdate", "length": 8, "alias": "a1_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a2_date", "length": 8, "alias": "a2_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a2_rdate", "length": 8, "alias": "a2_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a3_date", "length": 8, "alias": "a3_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a3_rdate", "length": 8, "alias": "a3_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a4_date", "length": 8, "alias": "a4_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a4_rdate", "length": 8, "alias": "a4_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a5_date", "length": 8, "alias": "a5_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a6_date", "length": 8, "alias": "a6_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a7_date", "length": 8, "alias": "a7_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a8_date", "length": 8, "alias": "a8_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a9_date", "length": 8, "alias": "a9_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a10_date", "length": 8, "alias": "a10_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a5_rdate", "length": 8, "alias": "a5_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a6_rdate", "length": 8, "alias": "a6_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a7_rdate", "length": 8, "alias": "a7_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a8_rdate", "length": 8, "alias": "a8_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a9_rdate", "length": 8, "alias": "a9_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "a10_rdate", "length": 8, "alias": "a10_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s1_date", "length": 8, "alias": "s1_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s1_rdate", "length": 8, "alias": "s1_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s2_date", "length": 8, "alias": "s2_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s2_rdate", "length": 8, "alias": "s2_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s3_date", "length": 8, "alias": "s3_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s3_rdate", "length": 8, "alias": "s3_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s4_date", "length": 8, "alias": "s4_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s4_rdate", "length": 8, "alias": "s4_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s5_date", "length": 8, "alias": "s5_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s5_rdate", "length": 8, "alias": "s5_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s6_date", "length": 8, "alias": "s6_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s6_rdate", "length": 8, "alias": "s6_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s7_date", "length": 8, "alias": "s7_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s7_rdate", "length": 8, "alias": "s7_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s8_date", "length": 8, "alias": "s8_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s8_rdate", "length": 8, "alias": "s8_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s9_date", "length": 8, "alias": "s9_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s9_rdate", "length": 8, "alias": "s9_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s10_date", "length": 8, "alias": "s10_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "s10_rdate", "length": 8, "alias": "s10_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "p1_date", "length": 8, "alias": "p1_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "p1_rdate", "length": 8, "alias": "p1_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "p2_date", "length": 8, "alias": "p2_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "p2_rdate", "length": 8, "alias": "p2_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "p3_date", "length": 8, "alias": "p3_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "p3_rdate", "length": 8, "alias": "p3_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e1_date", "length": 8, "alias": "e1_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e1_rdate", "length": 8, "alias": "e1_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e2_date", "length": 8, "alias": "e2_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e2_rdate", "length": 8, "alias": "e2_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e3_date", "length": 8, "alias": "e3_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e3_rdate", "length": 8, "alias": "e3_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e_date", "length": 8, "alias": "e_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e_rdate", "length": 8, "alias": "e_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e_date2", "length": 8, "alias": "e_date2", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "e_rdate2", "length": 8, "alias": "e_rdate2", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "r_date", "length": 8, "alias": "r_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "r_rdate", "length": 8, "alias": "r_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l1_date", "length": 8, "alias": "l1_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l1_rdate", "length": 8, "alias": "l1_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l2_date", "length": 8, "alias": "l2_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l2_rdate", "length": 8, "alias": "l2_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l3_date", "length": 8, "alias": "l3_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l3_rdate", "length": 8, "alias": "l3_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l4_date", "length": 8, "alias": "l4_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l4_rdate", "length": 8, "alias": "l4_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l5_date", "length": 8, "alias": "l5_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "l5_rdate", "length": 8, "alias": "l5_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "st_date", "length": 8, "alias": "st_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "st_rdate", "length": 8, "alias": "st_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "remarks", "length": 2000, "alias": "remarks", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "email1", "length": 50, "alias": "email1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "email2", "length": 50, "alias": "email2", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "expired", "alias": "expired", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "precision": 1, "domain": null, "name": "expired_date", "length": 8, "alias": "expired_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "lx_date", "length": 8, "alias": "lx_date", "type": "esriFieldTypeDate" }, { "nullable": true, "precision": 1, "domain": null, "name": "lx_rdate", "length": 8, "alias": "lx_rdate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "comtext", "length": 2147483647, "alias": "comtext", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ltype", "length": 20, "alias": "ltype", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "assign", "alias": "assign", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "subreview", "alias": "subreview", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "precision": 1, "domain": null, "name": "email_entity", "length": 8, "alias": "email_entity", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "incomplete_reason", "length": 255, "alias": "incomplete_reason", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "apn", "length": 14, "alias": "apn", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "HasCD", "alias": "HasCD", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "Active", "alias": "Active", "type": "esriFieldTypeSmallInteger" }, { "nullable": true, "domain": null, "name": "SubbasinYear", "alias": "SubbasinYear", "type": "esriFieldTypeInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true, "timeZone": "Pacific Standard Time" } }