Parent Layer: Marine Infrastructure

Name: Clean Marinas

Display Field: FACILITY

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: FDEP Clean Marina Program DatasetData from the Excel spreadsheet “All DEP CVA CMP LatLong Jan2011” was imported into SPSS. To prepare data for merging with the FWRI “Marine Facilities Florida” dataset, the following transformations were undertaken:Records for Southeast Florida were extracted to create a new dataset, including only Martin, Palm Beach, Broward, Miami-Dade, and Monroe Counties.The field “Type of Project” was separated into four separate fields: Clean Marina, Clean Boatyard, Clean Retailer, and Clean Vessel (i.e., pump out).Facilities with multiple designations (i.e., multiple records) were combined into one record to eliminate duplicate records (duplicate based on facility name and location). For faculties with multiple Clean Vessel, or pumpout projects, only one “Clean Vessel” designation was retained.The FDEP Southeast Clean Marina Program dataset was then checked against the FWRI Marine Facilities Florida dataset for the Southeast to match marine facilities across datasets using FWRI’s “objectid” code (the unique data identifier). For those records in the FDEP dataset matching records in the FWRI dataset (based on facility name and address) matching object identification codes were assigned. One hundred seven records matched to records in the FWRI dataset, while forty-five records in the FDEP dataset were not matched to the FWRI data. The resulting dataset was divided into two datasets, one having only matched or existing records and the other having new or non-existing records.Combining FWRI and FDEP datasetsOnce the FDEP SE Clean Marina datasets were prepared, variable names and specifications were standardized across all three datasets. Next, each FDEP dataset was imported into the FWRI SE Marine Facilities Dataset. The FDEP SE Clean Marina dataset for “existing” facilities was imported using the “Add Variable” procedure in SPSS, matched on objectid. The facility name and address from the FDEP dataset were retained, but renamed to “facility2” and “Address2.” The FDEP SE Clean Marina dataset for new records was imported into the FWRI dataset using the “Add Cases” procedure. The “new” cases added to the FWRI SE Marine Facilities dataset were assigned an objectid code: 2338-2382. The merged dataset was renamed: FL_SE_marinefacil_Designated.sav. The file was then saved as a dBase file for import into ArcMap.

Copyright Text: Clean Marina data were provided by Brenda Leonard, Program Manager, Clean Marina Program and Clean Vessel Act Program (Contact Info: Email= Brenda.Leonard@dep.state.fl.us / Ph=850-245-2847. The FWRI data was published in 2001. The Clean Marina dataset was updated as of August 21, 2012.

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -9106797.78667192
YMin: 2816081.5665705907
XMax: -8907204.13899463
YMax: 3159864.4804145643
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 197, 255, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1 )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• FACILITY ( type: esriFieldTypeString, alias: FACILITY, length: 37 )
• FACILITY2 ( type: esriFieldTypeString, alias: FACILITY2, length: 72 )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 50 )
• ADDRESS2 ( type: esriFieldTypeString, alias: ADDRESS2, length: 33 )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 20 )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, length: 14 )
• FL ( type: esriFieldTypeString, alias: FL, length: 2 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 9 )
• PHONE ( type: esriFieldTypeString, alias: PHONE, length: 14 )
• DEC_LAT ( type: esriFieldTypeDouble, alias: DEC_LAT )
• DEC_LON ( type: esriFieldTypeDouble, alias: DEC_LON )
• SITETYPE ( type: esriFieldTypeString, alias: SITETYPE, length: 9 )
• SITE_DESCR ( type: esriFieldTypeString, alias: SITE_DESCR, length: 50 )
• BANKBRIDGE ( type: esriFieldTypeString, alias: BANKBRIDGE, length: 5 )
• BOATRAMP ( type: esriFieldTypeString, alias: BOATRAMP, length: 5 )
• FISHCAMP ( type: esriFieldTypeString, alias: FISHCAMP, length: 5 )
• JETTY ( type: esriFieldTypeString, alias: JETTY, length: 5 )
• MARINA ( type: esriFieldTypeString, alias: MARINA, length: 5 )
• OTHER ( type: esriFieldTypeString, alias: OTHER, length: 5 )
• PARK ( type: esriFieldTypeString, alias: PARK, length: 5 )
• PIER ( type: esriFieldTypeString, alias: PIER, length: 5 )
• COUNTY2 ( type: esriFieldTypeSingle, alias: COUNTY2 )
• CLNVSSL ( type: esriFieldTypeString, alias: CLNVSSL, length: 8 )
• CLNMARINA ( type: esriFieldTypeString, alias: CLNMARINA, length: 8 )
• CLNBTYRD ( type: esriFieldTypeString, alias: CLNBTYRD, length: 8 )
• CLNRTLR ( type: esriFieldTypeString, alias: CLNRTLR, length: 8 )
• WATERBODY ( type: esriFieldTypeString, alias: WATERBODY, length: 22 )
• COASTALINL ( type: esriFieldTypeString, alias: COASTALINL, length: 7 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata