{ "currentVersion" : 12, "id" : 0, "name" : "Flood Problem Areas", "type" : "Feature Layer", "serviceItemId" : "a50083802c1947868b0b2e579b7de847", "displayField" : "ContactName", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1728328796238, "schemaLastEditDate" : 1728328796238, "dataLastEditDate" : 1728328796238 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length", "units" : "esriMeters" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -9814687.5608624183, "ymin" : 5199174.6114598177, "xmax" : -9802308.6143416129, "ymax" : 5220675.7346239341, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,219,186,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Location", "type" : "esriFieldTypeString", "alias" : "Location Name (subdivision, street intersection, etc.)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner", "type" : "esriFieldTypeString", "alias" : "Property Owner (if known)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Floodplain", "type" : "esriFieldTypeString", "alias" : "Is this flood problem area located in the floodplain?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CauseOfFlooding", "type" : "esriFieldTypeString", "alias" : "Cause of Flooding (select primary, if mulitple see [double_quote]other causes[double_quote] below)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Flood Problem Areas_CauseOfFlooding_4080c1c2-9abc-40b8-8fe0-2d0bd6987c27", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Storm sewer backup", "code" : "Storm sewer backup" }, { "name" : "Sanitary sewer backup", "code" : "Sanitary sewer backup" }, { "name" : "Sump pump failure/power failure", "code" : "Sump pump failure/power failure" }, { "name" : "Saturated plug or standpipe", "code" : "Saturated plug or standpipe" }, { "name" : "Standing water next to house", "code" : "Standing water next to house" }, { "name" : "Depressional", "code" : "Depressional" }, { "name" : "Local Drainage Problem", "code" : "Local Drainage Problem" }, { "name" : "Overbanking Flooding", "code" : "Overbanking Flooding" }, { "name" : "Erosion Problems", "code" : "Erosion Problems" } ] }, "defaultValue" : null }, { "name" : "OtherCauses", "type" : "esriFieldTypeString", "alias" : "Other causes of flooding", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Frequency", "type" : "esriFieldTypeString", "alias" : "Frequency of flooding (select most applicable, if less frequent than every 10 years or [double_quote]other[double_quote] see below)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Flood Problem Areas_Frequency_fd762d67-d19f-455f-8c34-51015c339c43", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Annually", "code" : "Annually" }, { "name" : "2-5 yrs", "code" : "2-5 yrs" }, { "name" : "6-10 yrs", "code" : "6-10 yrs" }, { "name" : "Other", "code" : "Other" } ] }, "defaultValue" : null }, { "name" : "OtherFrequency", "type" : "esriFieldTypeString", "alias" : "If other flood frequency, please describe", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Depth", "type" : "esriFieldTypeSmallInteger", "alias" : "Depth of flooding (ft) - if known", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "StructuralDamage", "type" : "esriFieldTypeString", "alias" : "Has there been structural damage?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Flood Problem Areas_StructuralDamage_49e414c9-8883-44a8-8e25-827e7d291e17", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "HowManyBuildings", "type" : "esriFieldTypeSmallInteger", "alias" : "If yes, how many buildings have been impacted?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ResidentalBuildings", "type" : "esriFieldTypeSmallInteger", "alias" : "Number of residental buildings impacted?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CommIndusBuildings", "type" : "esriFieldTypeSmallInteger", "alias" : "Number of commericial/industrial buildings impacted?", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CriticalFacilities", "type" : "esriFieldTypeString", "alias" : "List any critical facilities impacted (police or fire stations, schools, water sanitary treatment facilities, public utility providers and nursing homes)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Transportation", "type" : "esriFieldTypeString", "alias" : "Any transportation infrastructure with damage or loss of access?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Flood Problem Areas_Transportation_770fe158-fe32-4f57-8f72-9dcc6bd5c9f5", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "Sewer", "type" : "esriFieldTypeString", "alias" : "Does the flooding result in sewer backup?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Flood Problem Areas_Sewer_b872dec7-928a-4d4d-836e-e7b3851e2fc9", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "Septic", "type" : "esriFieldTypeString", "alias" : "Does the flooding result in septic failure?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Flood Problem Areas_Septic_2eaefc63-6dca-4c17-8955-dfb5b0688629", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "OtherDamages", "type" : "esriFieldTypeString", "alias" : "Other known damages not described above (basements, 1st floor, garage/outbuilding, crawl space, utilities, erosion, etc.)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MitigationPlan", "type" : "esriFieldTypeString", "alias" : "Is there a mitigation plan for this area?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Flood Problem Areas_MitigationPlan_dec7cb28-1d01-470b-8c47-793fb04ea9e2", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "MitigationExplain", "type" : "esriFieldTypeString", "alias" : "If yes, explain (ie flood control projects, community neighborhood plans, other hazards, studies)", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CostOfHistDamage", "type" : "esriFieldTypeDouble", "alias" : "Cost of historical damages (if known)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ContactName", "type" : "esriFieldTypeString", "alias" : "Contact name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ContactEmail", "type" : "esriFieldTypeString", "alias" : "Contact email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CODE", "type" : "esriFieldTypeString", "alias" : "CODE", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "COMMENTS", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Jurisdiction", "type" : "esriFieldTypeString", "alias" : "Jurisdiction", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Subshed", "type" : "esriFieldTypeString", "alias" : "Subshed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Watershed", "type" : "esriFieldTypeString", "alias" : "Watershed", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "New", "type" : "esriFieldTypeString", "alias" : "New", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__FLOOD_PR__F4B70D8550347F7B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_9131.FLOOD_PROBLEM_AREA_FLOOD_PROBLEM_AREAS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "CauseOfFlooding_Index", "fields" : "CauseOfFlooding", "isAscending" : true, "isUnique" : false, "description" : "CauseOfFlooding_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Flood Problem Areas", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { "Watershed" : null, "Location" : null, "Owner" : null, "Floodplain" : null, "CauseOfFlooding" : null, "OtherCauses" : null, "Frequency" : null, "OtherFrequency" : null, "Depth" : null, "StructuralDamage" : null, "HowManyBuildings" : null, "ResidentalBuildings" : null, "CommIndusBuildings" : null, "CriticalFacilities" : null, "Transportation" : null, "Sewer" : null, "Septic" : null, "OtherDamages" : null, "MitigationPlan" : null, "MitigationExplain" : null, "CostOfHistDamage" : null, "ContactName" : null, "ContactEmail" : null, "CODE" : null, "COMMENTS" : null, "Jurisdiction" : null, "Subshed" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Query,Update,Editing,Extract" }