{ "currentVersion": 10.81, "id": 61, "name": "Clean Marinas", "type": "Feature Layer", "description": "FDEP Clean Marina Program DatasetData from the Excel spreadsheet \u201cAll DEP CVA CMP LatLong Jan2011\u201d was imported into SPSS. To prepare data for merging with the FWRI \u201cMarine Facilities Florida\u201d 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 \u201cType of Project\u201d 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 \u201cClean Vessel\u201d 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\u2019s \u201cobjectid\u201d 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 \u201cexisting\u201d facilities was imported using the \u201cAdd Variable\u201d procedure in SPSS, matched on objectid. The facility name and address from the FDEP dataset were retained, but renamed to \u201cfacility2\u201d and \u201cAddress2.\u201d The FDEP SE Clean Marina dataset for new records was imported into the FWRI dataset using the \u201cAdd Cases\u201d procedure. The \u201cnew\u201d 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.", "geometryType": "esriGeometryPoint", "sourceSpatialReference": {"wkt": "PROJCS[\"PCS_Albers\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Albers\"],PARAMETER[\"False_Easting\",400000.0],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",-84.0],PARAMETER[\"Standard_Parallel_1\",24.0],PARAMETER[\"Standard_Parallel_2\",31.5],PARAMETER[\"Latitude_Of_Origin\",24.0],UNIT[\"Meter\",1.0]]"}, "copyrightText": "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.", "parentLayer": { "id": 58, "name": "Marine Infrastructure" }, "subLayers": [], "minScale": 0, "maxScale": 0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 197, 255, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": -9106797.78667192, "ymin": 2816081.5665705907, "xmax": -8907204.13899463, "ymax": 3159864.4804145643, "spatialReference": { "wkid": 102100, "latestWkid": 3857 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FACILITY", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID_1", "type": "esriFieldTypeOID", "alias": "OBJECTID_1", "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeInteger", "alias": "OBJECTID", "domain": null }, { "name": "FACILITY", "type": "esriFieldTypeString", "alias": "FACILITY", "length": 37, "domain": null }, { "name": "FACILITY2", "type": "esriFieldTypeString", "alias": "FACILITY2", "length": 72, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "length": 50, "domain": null }, { "name": "ADDRESS2", "type": "esriFieldTypeString", "alias": "ADDRESS2", "length": 33, "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 20, "domain": null }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "COUNTY", "length": 14, "domain": null }, { "name": "FL", "type": "esriFieldTypeString", "alias": "FL", "length": 2, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 9, "domain": null }, { "name": "PHONE", "type": "esriFieldTypeString", "alias": "PHONE", "length": 14, "domain": null }, { "name": "DEC_LAT", "type": "esriFieldTypeDouble", "alias": "DEC_LAT", "domain": null }, { "name": "DEC_LON", "type": "esriFieldTypeDouble", "alias": "DEC_LON", "domain": null }, { "name": "SITETYPE", "type": "esriFieldTypeString", "alias": "SITETYPE", "length": 9, "domain": null }, { "name": "SITE_DESCR", "type": "esriFieldTypeString", "alias": "SITE_DESCR", "length": 50, "domain": null }, { "name": "BANKBRIDGE", "type": "esriFieldTypeString", "alias": "BANKBRIDGE", "length": 5, "domain": null }, { "name": "BOATRAMP", "type": "esriFieldTypeString", "alias": "BOATRAMP", "length": 5, "domain": null }, { "name": "FISHCAMP", "type": "esriFieldTypeString", "alias": "FISHCAMP", "length": 5, "domain": null }, { "name": "JETTY", "type": "esriFieldTypeString", "alias": "JETTY", "length": 5, "domain": null }, { "name": "MARINA", "type": "esriFieldTypeString", "alias": "MARINA", "length": 5, "domain": null }, { "name": "OTHER", "type": "esriFieldTypeString", "alias": "OTHER", "length": 5, "domain": null }, { "name": "PARK", "type": "esriFieldTypeString", "alias": "PARK", "length": 5, "domain": null }, { "name": "PIER", "type": "esriFieldTypeString", "alias": "PIER", "length": 5, "domain": null }, { "name": "COUNTY2", "type": "esriFieldTypeSingle", "alias": "COUNTY2", "domain": null }, { "name": "CLNVSSL", "type": "esriFieldTypeString", "alias": "CLNVSSL", "length": 8, "domain": null }, { "name": "CLNMARINA", "type": "esriFieldTypeString", "alias": "CLNMARINA", "length": 8, "domain": null }, { "name": "CLNBTYRD", "type": "esriFieldTypeString", "alias": "CLNBTYRD", "length": 8, "domain": null }, { "name": "CLNRTLR", "type": "esriFieldTypeString", "alias": "CLNRTLR", "length": 8, "domain": null }, { "name": "WATERBODY", "type": "esriFieldTypeString", "alias": "WATERBODY", "length": 22, "domain": null }, { "name": "COASTALINL", "type": "esriFieldTypeString", "alias": "COASTALINL", "length": 7, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "FDO_OBJECTID_1", "fields": "OBJECTID_1", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I2692FACILITY", "fields": "FACILITY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_Shape", "fields": "Shape", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": false, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "supportsCoordinatesQuantization": true }