{ "currentVersion": 10.81, "id": 37, "name": "ARCDBA.DAMS_EVENT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AGT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CASE_NUMBER", "type": "esriFieldTypeString", "alias": "CASE_NUMBER", "length": 30, "domain": null }, { "name": "ZONING_ORDINANCE", "type": "esriFieldTypeString", "alias": "ZONING_ORDINANCE", "length": 1, "domain": null }, { "name": "CASE_TITLE", "type": "esriFieldTypeString", "alias": "CASE_TITLE", "length": 100, "domain": null }, { "name": "CASE_STATUS", "type": "esriFieldTypeString", "alias": "CASE_STATUS", "length": 25, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 180, "domain": null }, { "name": "CASE_TYPE", "type": "esriFieldTypeString", "alias": "CASE_TYPE", "length": 10, "domain": null }, { "name": "ACCEPTED_DATE", "type": "esriFieldTypeDate", "alias": "ACCEPTED_DATE", "length": 8, "domain": null }, { "name": "STATUS_DATE", "type": "esriFieldTypeDate", "alias": "STATUS_DATE", "length": 8, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "LOCATION", "length": 120, "domain": null }, { "name": "ACRES", "type": "esriFieldTypeDouble", "alias": "ACRES", "domain": null }, { "name": "PRELIMINARY_LOTS", "type": "esriFieldTypeSmallInteger", "alias": "PRELIMINARY_LOTS", "domain": null }, { "name": "PRELIMINARY_OUT_LOTS", "type": "esriFieldTypeSmallInteger", "alias": "PRELIMINARY_OUT_LOTS", "domain": null }, { "name": "PRELIMINARY_PARCELS", "type": "esriFieldTypeSmallInteger", "alias": "PRELIMINARY_PARCELS", "domain": null }, { "name": "PRELIMINARY_OUT_PARCELS", "type": "esriFieldTypeSmallInteger", "alias": "PRELIMINARY_OUT_PARCELS", "domain": null }, { "name": "UNITS_ATTACHED", "type": "esriFieldTypeSmallInteger", "alias": "UNITS_ATTACHED", "domain": null }, { "name": "UNITS_DETACHED", "type": "esriFieldTypeSmallInteger", "alias": "UNITS_DETACHED", "domain": null }, { "name": "UNITS_MULTIFAMILY", "type": "esriFieldTypeSmallInteger", "alias": "UNITS_MULTIFAMILY", "domain": null }, { "name": "TOTAL_UNITS", "type": "esriFieldTypeSmallInteger", "alias": "TOTAL_UNITS", "domain": null }, { "name": "GROSS_FLOOR_AREA", "type": "esriFieldTypeInteger", "alias": "GROSS_FLOOR_AREA", "domain": null }, { "name": "CASE_REVIEWER", "type": "esriFieldTypeString", "alias": "CASE_REVIEWER", "length": 50, "domain": null }, { "name": "VALIDITY_DATE", "type": "esriFieldTypeDate", "alias": "VALIDITY_DATE", "length": 8, "domain": null }, { "name": "AGENT_ID", "type": "esriFieldTypeInteger", "alias": "AGENT_ID", "domain": null }, { "name": "AGT_NAME", "type": "esriFieldTypeString", "alias": "AGT_NAME", "length": 50, "domain": null }, { "name": "APP_ID", "type": "esriFieldTypeInteger", "alias": "APP_ID", "domain": null }, { "name": "APP_NAME", "type": "esriFieldTypeString", "alias": "APP_NAME", "length": 50, "domain": null }, { "name": "PARENT_CASE", "type": "esriFieldTypeString", "alias": "PARENT_CASE", "length": 30, "domain": null }, { "name": "EVENT_ID", "type": "esriFieldTypeInteger", "alias": "EVENT_ID", "domain": null }, { "name": "MAP200", "type": "esriFieldTypeString", "alias": "MAP200", "length": 7, "domain": null }, { "name": "MAPGRID", "type": "esriFieldTypeString", "alias": "MAPGRID", "length": 7, "domain": null }, { "name": "PA", "type": "esriFieldTypeString", "alias": "PA", "length": 3, "domain": null }, { "name": "COUNCILMANIC_DISTRICTS", "type": "esriFieldTypeString", "alias": "COUNCILMANIC_DISTRICTS", "length": 2, "domain": null }, { "name": "EVENT_STREET_NO", "type": "esriFieldTypeString", "alias": "EVENT_STREET_NO", "length": 10, "domain": null }, { "name": "EVENT_STREET_NM", "type": "esriFieldTypeString", "alias": "EVENT_STREET_NM", "length": 30, "domain": null }, { "name": "EVENT_CITY", "type": "esriFieldTypeString", "alias": "EVENT_CITY", "length": 20, "domain": null }, { "name": "EVENT_MUNICIPALITY_FLAG", "type": "esriFieldTypeString", "alias": "EVENT_MUNICIPALITY_FLAG", "length": 1, "domain": null }, { "name": "BULK_LOAD_FROM_P3K", "type": "esriFieldTypeString", "alias": "BULK_LOAD_FROM_P3K", "length": 1, "domain": null }, { "name": "DDS", "type": "esriFieldTypeString", "alias": "DDS", "length": 1, "domain": null }, { "name": "DSDS", "type": "esriFieldTypeString", "alias": "DSDS", "length": 1, "domain": null }, { "name": "DPLS", "type": "esriFieldTypeString", "alias": "DPLS", "length": 1, "domain": null }, { "name": "PAP", "type": "esriFieldTypeString", "alias": "PAP", "length": 1, "domain": null } ], "indexes": [ { "name": "I4804AGENT_ID", "fields": "AGENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I4804APP_ID", "fields": "APP_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I4804CASE_NUMBER", "fields": "CASE_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I4804EVENT_ID", "fields": "EVENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I4804ZONING_ORDI", "fields": "ZONING_ORDINANCE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R531_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }