{ "currentVersion": 10.61, "id": 5, "name": "Online.SDE.FHISLog", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "PROPERTYADDRESS", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "PROPERTYADDRESS", "type": "esriFieldTypeString", "alias": "Property Address", "length": 50, "domain": null }, { "name": "APN", "type": "esriFieldTypeString", "alias": "Parcel APN", "length": 16, "domain": null }, { "name": "DATERECEIVED", "type": "esriFieldTypeDate", "alias": "Date Received", "length": 8, "domain": null }, { "name": "SFHA", "type": "esriFieldTypeString", "alias": "SFHA", "length": 4, "domain": null }, { "name": "FIRMMP1", "type": "esriFieldTypeString", "alias": "FIRM Map Panel 1", "length": 8, "domain": null }, { "name": "FIRMMP2", "type": "esriFieldTypeString", "alias": "FIRM Map Panel 2", "length": 8, "domain": null }, { "name": "FIRMMP3", "type": "esriFieldTypeString", "alias": "FIRM Map Panel 3", "length": 8, "domain": null }, { "name": "FIRMMP4", "type": "esriFieldTypeString", "alias": "FIRM Map Panel 4", "length": 8, "domain": null }, { "name": "FIRMDATE", "type": "esriFieldTypeDate", "alias": "FIRM Panel Date", "length": 8, "domain": null }, { "name": "LOMRLOMADATE", "type": "esriFieldTypeDate", "alias": "LOMR LOMA Date", "length": 8, "domain": null }, { "name": "MAINSTRUCTUREIN", "type": "esriFieldTypeString", "alias": "Main Structure IN", "length": 4, "domain": null }, { "name": "LOCALLYREGULATORYFLOODPLAIN", "type": "esriFieldTypeString", "alias": "Locally Regulatory Floodplain", "length": 4, "domain": null }, { "name": "FLOODWAY", "type": "esriFieldTypeString", "alias": "Floodway", "length": 4, "domain": null }, { "name": "EROSIONHAZARDSETBACK", "type": "esriFieldTypeString", "alias": "Erosion Hazard Setback", "length": 4, "domain": null }, { "name": "SETBACKIFGIVEN", "type": "esriFieldTypeString", "alias": "Setback if given", "length": 50, "domain": null }, { "name": "RIPARIAN", "type": "esriFieldTypeString", "alias": "Raparian", "length": 4, "domain": null }, { "name": "REVIEWREQUIRED", "type": "esriFieldTypeString", "alias": "Review Required", "length": 4, "domain": null }, { "name": "PERMITREQUIRED", "type": "esriFieldTypeString", "alias": "Permit Required", "length": 4, "domain": null }, { "name": "ALLIMPROVTOBEOUT", "type": "esriFieldTypeString", "alias": "All Improvements to be OUT", "length": 4, "domain": null }, { "name": "COMPLETIONDATE", "type": "esriFieldTypeDate", "alias": "Completion Date", "length": 8, "domain": null }, { "name": "SCANNEDDATE", "type": "esriFieldTypeDate", "alias": "Scanned Date", "length": 8, "domain": null }, { "name": "PARCELCHANGECOMENT", "type": "esriFieldTypeString", "alias": "Parcel Change Comment", "length": 200, "domain": null }, { "name": "LOCALFHISLOCATION", "type": "esriFieldTypeString", "alias": "Local Document Location", "length": 160, "domain": null }, { "name": "SCCFHISLOCATION", "type": "esriFieldTypeString", "alias": "SCC Document Location", "length": 160, "domain": null }, { "name": "ELEVATIONCERTIFICATIONLOCATION", "type": "esriFieldTypeString", "alias": "Elevation Certification Location", "length": 50, "domain": null }, { "name": "DATELASTEDIT", "type": "esriFieldTypeDate", "alias": "Date Last Edit", "length": 8, "domain": null }, { "name": "LASTEDITBY", "type": "esriFieldTypeString", "alias": "Last Edited By", "length": 50, "domain": null }, { "name": "GISCOMMENTS", "type": "esriFieldTypeString", "alias": "GIS Comments", "length": 120, "domain": null }, { "name": "DUPLICATIONCOUNT", "type": "esriFieldTypeSmallInteger", "alias": "Duplicate Count", "domain": null }, { "name": "Confirmed", "type": "esriFieldTypeSmallInteger", "alias": "Confirmed", "domain": null }, { "name": "FIRMZ1", "type": "esriFieldTypeString", "alias": "FIRMZ1", "length": 50, "domain": null }, { "name": "FIRMZ2", "type": "esriFieldTypeString", "alias": "FIRM Zone 2", "length": 50, "domain": null }, { "name": "FIRMZ3", "type": "esriFieldTypeString", "alias": "FIRM Zone 3", "length": 50, "domain": null }, { "name": "FIRMZ4", "type": "esriFieldTypeString", "alias": "FIRM Zone 4", "length": 50, "domain": null }, { "name": "FIRMZ5", "type": "esriFieldTypeString", "alias": "FIRM Zone 5", "length": 50, "domain": null }, { "name": "BFE", "type": "esriFieldTypeString", "alias": "BFE", "length": 50, "domain": null }, { "name": "RFE", "type": "esriFieldTypeString", "alias": "RFE", "length": 50, "domain": null }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "length": 255, "domain": null }, { "name": "FHIS_unique", "type": "esriFieldTypeString", "alias": "FHIS_unique", "length": 50, "domain": null } ], "indexes": [ { "name": "R23_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G33APN", "fields": "APN", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "ParcelsFHIS", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "APN", "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 }