Skip to content

Instantly share code, notes, and snippets.

@emiliom
Last active December 27, 2016 03:55
Show Gist options
  • Save emiliom/7622262 to your computer and use it in GitHub Desktop.
Save emiliom/7622262 to your computer and use it in GitHub Desktop.
#OWSLib #CSW #FGDC #Metadata #WCGA #Python Assess key FGDC metadata fields on the WCGA Ocean Data Portal OGC CSW endpoint. Use OWSLib to test accessing and querying the WCGA ODP CSW endpoint. Examine the FGDC metadata for each record, specially the messy and potentially duplicative fields (creator, publisher, date published). Emilio Mayorga. 11/…
Display the source blob
Display the rendered blob
Raw
{
"metadata": {
"name": "WCGACSW_owslib_md_assess"
},
"nbformat": 3,
"nbformat_minor": 0,
"worksheets": [
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Assess key FGDC metadata fields on the WCGA Ocean Data Portal OGC CSW endpoint\n",
"Use OWSLib to test accessing and querying the WCGA ODP CSW endpoint. Examine the FGDC metadata for each record, specially the messy and potentially duplicative fields (creator, publisher, date published). 11/23/2013. (11/27: Added date string parsing). Emilio Mayorga. "
]
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Accesss the CSW endpoint"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"from owslib.csw import CatalogueServiceWeb\n",
"from owslib import fes\n",
"from owslib.etree import etree"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 1
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"endpoint = 'http://portal.westcoastoceans.org/geoportal/csw'\n",
"csw = CatalogueServiceWeb(endpoint,timeout=30)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 2
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Define record filters, issue a getrecords request with those filters"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"bbox = fes.BBox([-125.244141,47.040182,-122.915039,48.487486]) # Olympic Peninsula, roughly"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 3
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# apply all the filters using the \"and\" syntax: [[filter1,filter2]]\n",
"csw.getrecords2(constraints=[bbox],maxrecords=50,esn='full')\n",
"#for rec,item in csw.records.iteritems():\n",
"# print rec,item.title"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 4
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Explore one of those records, including examining the associated FGDC metadata document"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# select and examine one of the records\n",
"recid1 = '{BED99236-D51D-443A-AFD6-6164D94A896C}'\n",
"rec1 = csw.records[recid1]"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 5
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# this is supposed to pretty print the xml (syntax coloring, indenting, etc), but doesn't\n",
"#from lxml import etree as letree\n",
"#rec1_xmlroot = letree.fromstring(rec1.xml)\n",
"#print letree.tostring(rec1_xmlroot, pretty_print=True)\n",
"\n",
"# This block adds indentation, but adds blank lines and no syntax coloring\n",
"#import xml.dom.minidom\n",
"#xml = xml.dom.minidom.parseString(rec1.xml)\n",
"#print xml.toprettyxml()\n",
"\n",
"print rec1.xml"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"<csw:Record xmlns:csw=\"http://www.opengis.net/cat/csw/2.0.2\" xmlns:dc=\"http://purl.org/dc/elements/1.1/\" xmlns:dcmiBox=\"http://dublincore.org/documents/2000/07/11/dcmi-box/\" xmlns:dct=\"http://purl.org/dc/terms/\" xmlns:gml=\"http://www.opengis.net/gml\" xmlns:ows=\"http://www.opengis.net/ows\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">\n",
"<dc:identifier scheme=\"urn:x-esri:specification:ServiceType:ArcIMS:Metadata:DocID\">{BED99236-D51D-443A-AFD6-6164D94A896C}</dc:identifier>\n",
"<dc:title>Documented Subtidal Geoduck Clam areas in Washington's inside marine waters</dc:title>\n",
"<dc:type scheme=\"urn:x-esri:specification:ServiceType:ArcIMS:Metadata:ContentType\">ESRI ArcINFO coverage (If it is an .E00 file, then it has been exported. Use the IMPORT command to convert to a coverage.)Projection information and Metadata: atlas_tracts.metadata.htm</dc:type>\n",
"<dc:subject>Geoduck tracts</dc:subject>\n",
"<dc:subject>subtidal</dc:subject>\n",
"<dc:subject>commercial tracts</dc:subject>\n",
"<dct:modified>2013-04-30T01:13:16-07:00</dct:modified>\n",
"<dct:abstract>This layer contains geoduck TRACTS which are areas of commercial geoduck density, between -18 ft MLLW and -70 ft MLLW, and are of interest for commercial harvest. This layer does not represent a comprehensive distribution of geoduck populations in Washington State. These geoduck tract polygons have updates into 2010, including updating 97 tracts (of \"commercial\" status in 2005) from the nearshore biomass project from July of 2005. Tract boundary updates are done yearly for those tracts surveyed each field season or that had an Site Assessment (SA) prepared. Many geoduck tract polygons in this layer remain as older polygons \"hand-fitted\" with a digitizer and are intended to represent general tract vicinity. Some tract polygons are fitted to NOAA water depth contours, with estimated \"side\" boundaries. Some tracts which have been biologically surveyed since 1994 have contour lines plotted by DNR or WDFW using GPS and fathometer equipment. Tract boundaries generally fall between the -18' MLLW and -70' MLLW contours, but tracts surveyed pre-1990 were only surveyed to the -60' MLLW contour. Some tract areas have restricted nearshore contours which range between -18' and -35' (MLLW) due to eelgrass beds and/or herring spawning habitat. Please request a current description of a tract from WDFW if interested in the exact description and current restrictions. Boundaries are updated during the winter when WDFW receives survey information from state and tribal geoduck managers, and the Washington Dept. of Health (DOH). DOH should be consulted for current geoduck tract health classifications, openings and closures. An X-bed marks a location where geoducks have been reported, but the boundaries are not accurate as those tracts have never been surveyed.</dct:abstract>\n",
"<dct:references scheme=\"urn:x-esri:specification:ServiceType:ArcIMS:Metadata:Document\">http://wcgardf.sdsc.edu/geoportal/csw?getxml=%7BBED99236-D51D-443A-AFD6-6164D94A896C%7D</dct:references>\n",
"<ows:WGS84BoundingBox>\n",
"<ows:LowerCorner>-124.575377 47.089712</ows:LowerCorner>\n",
"<ows:UpperCorner>-122.295678 48.829626</ows:UpperCorner>\n",
"</ows:WGS84BoundingBox>\n",
"<ows:BoundingBox>\n",
"<ows:LowerCorner>-124.575377 47.089712</ows:LowerCorner>\n",
"<ows:UpperCorner>-122.295678 48.829626</ows:UpperCorner>\n",
"</ows:BoundingBox>\n",
"<dc:source>{5A96678F-8FFB-4F11-BF9D-83E6017C965C}</dc:source>\n",
"<dct:isPartOf>Category|Biological</dct:isPartOf>\n",
"<dct:isPartOf>Category|Biological|Species_And_Taxa</dct:isPartOf>\n",
"</csw:Record>\n",
"\n"
]
}
],
"prompt_number": 6
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Note that the dataset FGDC metadata record is available from the Registry/Geoportal here:\n",
"# As a styled, human-readable version of the metadata doc:\n",
"# http://wcgardf.sdsc.edu/geoportal/catalog/search/resource/details.page?uuid={BED99236-D51D-443A-AFD6-6164D94A896C}\n",
"# As the raw metadata xml:\n",
"# http://wcgardf.sdsc.edu/geoportal/rest/document?id={BED99236-D51D-443A-AFD6-6164D94A896C}\n",
"# The raw XML could be parsed directly with etree -- though one would have to know first if it's ISO vs FGDC ...\n",
"\n",
"# -- ACTUALLY, LOOKS LIKE THE METADATA DOC *IS* ACCESSIBLE AFTER ALL, BUT THRU A DIFFERENT URL, HERE\"\n",
"#<dct:references scheme=\"urn:x-esri:specification:ServiceType:ArcIMS:Metadata:Document\">\n",
"# http://wcgardf.sdsc.edu/geoportal/csw?getxml=%7BBED99236-D51D-443A-AFD6-6164D94A896C%7D\n",
"#</dct:references>"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 7
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import urllib2\n",
"import datetime\n",
"import owslib.fgdc as fgdc\n",
"from owslib import util"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 8
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# hardwired base path for metadata XML request; the URL should be within the CSW record response, but is not\n",
"metadataxml_url_tmplt = \"http://wcgardf.sdsc.edu/geoportal/rest/document?id=%s\"\n",
"# -- ACTUALLY, LOOKS LIKE THE METADATA DOC *IS* ACCESSIBLE AFTER ALL, BUT THRU A DIFFERENT URL, HERE\"\n",
"#<dct:references scheme=\"urn:x-esri:specification:ServiceType:ArcIMS:Metadata:Document\">\n",
"# http://wcgardf.sdsc.edu/geoportal/csw?getxml=%7BBED99236-D51D-443A-AFD6-6164D94A896C%7D\n",
"#</dct:references>"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 9
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"def get_sel_fields(el):\n",
" val = el.find('idinfo/citation/citeinfo/origin')\n",
" creator = util.testXMLValue(val)\n",
" val = el.find('idinfo/citation/citeinfo/pubdate')\n",
" dtpub1 = util.testXMLValue(val)\n",
" val = el.find('idinfo/timeperd/timeinfo/sngdates/caldate')\n",
" dtpub2 = util.testXMLValue(val)\n",
" val = el.find('distinfo/distrib/cntinfo/cntorgp/cntorg')\n",
" pub1 = util.testXMLValue(val)\n",
" val = el.find('idinfo/citation/citeinfo/pubinfo/publish')\n",
" pub2 = util.testXMLValue(val)\n",
" \n",
" return (creator, dtpub1, dtpub2, pub1, pub2)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 10
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"rec1xmlmeta = urllib2.urlopen(metadataxml_url_tmplt % recid1).read()\n",
"e=etree.XML(rec1xmlmeta)\n",
"type(e)"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 11,
"text": [
"lxml.etree._Element"
]
}
],
"prompt_number": 11
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"m=fgdc.Metadata(e)\n",
"mi = m.idinfo"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 12
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# probe the idinfo/citation block\n",
"mi.citation.citeinfo"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 13,
"text": [
"{'geoform': 'vector digital data',\n",
" 'onlink': [],\n",
" 'origin': 'WDFW, Marine Resources, Shellfish Dive Team',\n",
" 'pubdate': '06/21/2009',\n",
" 'publish': None,\n",
" 'pubplace': None,\n",
" 'title': \"Documented Subtidal Geoduck Clam areas in Washington's inside marine waters\"}"
]
}
],
"prompt_number": 13
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# extract citation/publication date\n",
"citpubdate_str = mi.citation.citeinfo['pubdate']\n",
"citpubdate_dt = datetime.datetime.strptime(citpubdate_str, '%m/%d/%Y')\n",
"print citpubdate_str, '||', citpubdate_dt"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"06/21/2009 || 2009-06-21 00:00:00\n"
]
}
],
"prompt_number": 14
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"m.idinfo.citation.citeinfo.viewkeys()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 15,
"text": [
"dict_keys(['origin', 'pubdate', 'title', 'pubplace', 'publish', 'geoform', 'onlink'])"
]
}
],
"prompt_number": 15
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# HMM, looks like OWSLib FGDC Distinfo class is incomplete, needs an overhaul?\n",
"# m.distinfo does not have the child I'm looking for (distrib)\n",
"\n",
"# maybe best to use e.find(xpath), to be 100% safe\n",
"#dtpub1 = m.idinfo.citation.citeinfo['pubdate']\n",
"fldstup = get_sel_fields(e)\n",
"print fldstup"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"('WDFW, Marine Resources, Shellfish Dive Team', '06/21/2009', None, 'WDFW', None)\n"
]
}
],
"prompt_number": 16
},
{
"cell_type": "heading",
"level": 3,
"metadata": {},
"source": [
"Ingest, process and examine the FGDC metadata XML document for all the CSW records returned by the request"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Loop through all returned CSW records, read FGDC metadata doc, pull out these fields, and build a __pandas dataframe__ to create the comparison. Later, expand this analysis to all records in a CSW endpoint, then to all WCDOP \"sources\" (catalogs) having FGDC metadata."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"recdat_dct = {'id':[], 'title':[], 'creator':[], \n",
" 'dtpub1':[], 'dtpub2':[], 'pub1':[], 'pub2':[], 'source':[]}\n",
"for recid,item in csw.records.iteritems():\n",
" recfgdcxml = urllib2.urlopen(metadataxml_url_tmplt % recid).read()\n",
" e=etree.XML(recfgdcxml)\n",
" fldstup = get_sel_fields(e)\n",
" recdat_dct['id'].append(recid)\n",
" recdat_dct['title'].append(item.title)\n",
" recdat_dct['creator'].append(fldstup[0])\n",
" recdat_dct['dtpub1'].append(fldstup[1])\n",
" recdat_dct['dtpub2'].append(fldstup[2])\n",
" recdat_dct['pub1'].append(fldstup[3])\n",
" recdat_dct['pub2'].append(fldstup[4])\n",
" recdat_dct['source'].append(item.source)\n",
" #print recid, item.title, fldstup\n",
" #print fldstup[1:3], '\\t', item.title"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 17
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import pandas as pd"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 18
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"recmddf = pd.DataFrame(recdat_dct, columns=['id','title','creator','dtpub1','dtpub2','pub1','pub2','source'])\n",
"recmddf"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>id</th>\n",
" <th>title</th>\n",
" <th>creator</th>\n",
" <th>dtpub1</th>\n",
" <th>dtpub2</th>\n",
" <th>pub1</th>\n",
" <th>pub2</th>\n",
" <th>source</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> {8A236ABD-AD5F-482E-96D0-33F58741B029}</td>\n",
" <td> AQUATIC PARCEL</td>\n",
" <td> Washington Department of Natural Resources</td>\n",
" <td> Unknown</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> {FE0C794A-4B9A-46E8-A352-092DC4CF1515}</td>\n",
" <td> Net Shore-Drift in Washington State</td>\n",
" <td> Shorelands and Environmental Assistance Progra...</td>\n",
" <td> 20020901</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> {B8125FE1-5C8F-4F38-AE0D-9AC8CD81C958}</td>\n",
" <td> Public Utility Districts (PUD)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> {7898CD0A-B435-41BE-8B1E-A8D8FBB60825}</td>\n",
" <td> Dams</td>\n",
" <td> Washington State Department of Fish and Wildlife</td>\n",
" <td> 20100716</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> {00334042-8F29-4B5A-A602-C93B25E1F9A9}</td>\n",
" <td> Washington State Marine Bathymetry Mosaic - Bs...</td>\n",
" <td> Washington Department of Fish and Wildlife, Wi...</td>\n",
" <td> 1997</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Fish and Wildli...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> {D5A23478-55D6-4FF8-B074-0374C6B1C648}</td>\n",
" <td> Sea Urchins - urchin</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 199204</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> {14B5E343-33DF-4A6A-8346-02A2344740BF}</td>\n",
" <td> Ferry Districts (FRY)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> {C5CBDA5B-1586-4A38-B4BD-7C4CBEF4D4EB}</td>\n",
" <td> Military Reservations of Washington State, at ...</td>\n",
" <td> GIS/Cartography Section, Washington State Depa...</td>\n",
" <td> 19990518</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Transportation,...</td>\n",
" <td> Washington State Department of Transportation</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> {7A127EAD-6907-465B-B19A-AF2700871B51}</td>\n",
" <td> Coastal Washington Canopy Forest 2006</td>\n",
" <td> Department of Commerce (DOC), National Oceanic...</td>\n",
" <td> 20081222</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA's Ocean Service, Coastal Services Center ...</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> {614548B9-DC2B-4C01-94A9-76742D2338D1}</td>\n",
" <td> Commercial Vessel Density October 2009-2010 AI...</td>\n",
" <td> Department of Commerce (DOC), National Oceanic...</td>\n",
" <td> 201209</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA's Ocean Service, Coastal Services Center ...</td>\n",
" <td> {A8C44A63-CDA1-44CA-941C-F02018D3BF88}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> {5C1CD50C-9BE1-49B8-BD9E-7E4213C81E17}</td>\n",
" <td> Watershed Administrative Units (Washington Sta...</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> April 2006</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Natural Resources</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> {C6920E4F-FCF6-4CF9-B759-7492DE0C0CEA}</td>\n",
" <td> Herring Spawning Areas in Washington - HerrSpwn</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> {B19D5945-ED94-4268-B202-A63CFE397982}</td>\n",
" <td> Forest Practices Wetlands</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> c. 1995</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> {7A3BCA83-00EA-451D-BB2C-9E0521E875D5}</td>\n",
" <td> Coastal Washington Land Cover 2006</td>\n",
" <td> Department of Commerce (DOC), National Oceanic...</td>\n",
" <td> 20081222</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA's Ocean Service, Coastal Services Center ...</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> {1828B630-EFD5-4A7F-9893-AB7FF5DB6AA6}</td>\n",
" <td> National Wetlands Inventory for Washington Sta...</td>\n",
" <td> United States Fish and Wildlife Service</td>\n",
" <td> 1989</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> {744135E5-3BA1-477C-852A-9CFE2966242F}</td>\n",
" <td> Forage Fish Surveys</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 08/01/2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> 6e5d6e7b-12ff-49bb-8a82-8f008eea06fa</td>\n",
" <td> Brookings, Gold Beach All Fishing Sectors Fish...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> {419786C1-D481-45A8-A66B-F952B1DB6934}</td>\n",
" <td> Rivers and Streams of Washington State 1:24,00...</td>\n",
" <td> Washington Department of Fish and Wildlife, Fi...</td>\n",
" <td> 20040101</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish &amp; Wildlife - Pri...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td> 5fd367b4-a823-4c32-a617-92837d5d529e</td>\n",
" <td> Offshore sand, gravel and shell deposits off O...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> {2990B35D-7EFF-4B07-A4E8-6867E3E06659}</td>\n",
" <td> Indian Reservations of Washington State</td>\n",
" <td> Cartography Section, Washington State Departme...</td>\n",
" <td> 19980130</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Transportation,...</td>\n",
" <td> Washington State Department of Transportation</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> 9bb6d77e-23b0-4d43-910e-9ed89b0c4fa2</td>\n",
" <td> SOORC Commercial Fishing Fisheries Uses and Va...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> e274b8bc-7788-4631-ad32-74467087b16d</td>\n",
" <td> Tow Boat Lanes, WA Sea Grant, 2007</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> {BED99236-D51D-443A-AFD6-6164D94A896C}</td>\n",
" <td> Documented Subtidal Geoduck Clam areas in Wash...</td>\n",
" <td> WDFW, Marine Resources, Shellfish Dive Team</td>\n",
" <td> 06/21/2009</td>\n",
" <td> None</td>\n",
" <td> WDFW</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> {56004969-19E4-4540-B0AE-E230159FA9D5}</td>\n",
" <td> Washington State Marine Shoreline (polygon)</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> 20010830</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> {21C5EA2B-14CE-4617-AAB5-A25DD218DB65}</td>\n",
" <td> Washington Shoreline Public Access Project</td>\n",
" <td> Jessica Archer</td>\n",
" <td> 20091013</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> {9FA999EA-2891-4355-9439-4668CDE8FDE6}</td>\n",
" <td> Digital Offshore Cadastre (DOC) - Pacific83 \u0096 ...</td>\n",
" <td> Bureau of Ocean Energy Management, Mapping and...</td>\n",
" <td> 20060210</td>\n",
" <td> None</td>\n",
" <td> Bureau of Ocean Energy Management, Mapping and...</td>\n",
" <td> Bureau of Ocean Energy Management, Mapping and...</td>\n",
" <td> {8D54230F-726E-460C-9F30-ECAC9B714DF5}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td> {9107C899-8BEB-45F0-AFB0-87163BFDFA78}</td>\n",
" <td> Puget Sound Abalone - abalone</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 1992</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> 18c65f46-3e97-46ba-b50c-d9e2efcea466</td>\n",
" <td> Ocean Recreation Shore Activities, Last Trip P...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> {ADCC280D-8D7E-4985-9F3E-945F91EE8653}</td>\n",
" <td> Impervious Surfaces Washington 2006</td>\n",
" <td> NOAA (National Oceanographic and Atmospheric A...</td>\n",
" <td> 20090403</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA Coastal Change Analysis Program (C-CAP)</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> 59a0d964-33f2-401a-ae5e-6c6314f98dd5</td>\n",
" <td> Garibaldi All Fishing Sectors Fisheries Uses a...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> {DA51DF18-CB4E-4AB9-9B5B-E389E1148D3E}</td>\n",
" <td> GRP Potential Spill Origin locations</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> 20091012</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> {6C1A1432-179A-46EE-A296-8319135E9417}</td>\n",
" <td> Washington Department of Fish and Wildlife own...</td>\n",
" <td> Washington Department of Fish and Wildlife, Wi...</td>\n",
" <td> 20100601</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> {26831785-DDD4-490B-8F18-47EE5C6857D1}</td>\n",
" <td> Documented Rocksole (Lepidopsetta bilineata) s...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 199204</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> {B2820417-B331-4012-8B9D-497D81784743}</td>\n",
" <td> Priority Habitats and Species - PHSREGION</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 2010</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> {38B7F747-3AD2-4ACD-B670-EA7F46799349}</td>\n",
" <td> Marine Water Quality Sampling Stations</td>\n",
" <td> DOH</td>\n",
" <td> 01/27/2010</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Health</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> {F75C75A0-DFFC-4B80-9E0D-D6901D2A8762}</td>\n",
" <td> Fish Culture and Misc Facilities - Facility</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 19990101</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> {1CFE3397-2827-410E-BFD3-91ECA6A30CE6}</td>\n",
" <td> Washington State Marine Shorelines (arc)</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> 20010830</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> {CD53B7B1-8233-4C6B-8D00-D419EDED71E9}</td>\n",
" <td> Documented Sand Lance Spawning</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 08/01/2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td> af79ecb7-4d55-4c42-86db-4dd9ac0acb85</td>\n",
" <td> Astoria All Fishing Sectors Fisheries Uses and...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td> {1A1A2433-D5F6-4DC0-A749-40127719BFB2}</td>\n",
" <td> Cities (Sales and Use Tax)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2013-10-01</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td> {09317F9A-0156-4B4C-965A-D5836044D083}</td>\n",
" <td> Washington State Levee Inventory</td>\n",
" <td> Western Washington University, Huxley College ...</td>\n",
" <td> 20120502</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td> 931fb31c-9757-451e-8a19-ff39f164037d</td>\n",
" <td> Newport All Sector Fisheries Uses Grid, Ecotru...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> {187CE5A6-716C-4912-A7A0-ED0C30B023C0}</td>\n",
" <td> Parks and Recreation Districts (PKR)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> {881B2DEE-BD3A-47CE-B33B-3DC639231FA5}</td>\n",
" <td> Documented Smelt Spawning</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 08/01/2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> {85207800-4B2C-4315-AA90-0B1A58D6E51A}</td>\n",
" <td> Port DIstricts (PRT)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> {15E330B1-DDEC-4B44-B26A-2F2ED69506E6}</td>\n",
" <td> Washington Department of Fish and Wildlife Are...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 20120305</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> {789E2C0C-F9F9-4520-875F-30C1C80C89C3}</td>\n",
" <td> Stream Temperature</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> 19950228</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> Washington Department of Natural Resources</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> {358C3206-4455-4F2E-A211-60A0F9916957}</td>\n",
" <td> Polygons showing documented Pacific Oyster (Cr...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 199204</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> {856F5F1A-3EE4-4D7F-9134-55B03F2AB2F3}</td>\n",
" <td> Atlas of Seal and Sea Lion Haulout Sites in Wa...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 2000</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and WildlifeFW</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> {E7A40C02-48D4-4676-9777-CCE2BFC41A1B}</td>\n",
" <td> AQUATIC BOUNDARY</td>\n",
" <td> Washington Department of Natural Reources</td>\n",
" <td> December 2005</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 19,
"text": [
" id \\\n",
"0 {8A236ABD-AD5F-482E-96D0-33F58741B029} \n",
"1 {FE0C794A-4B9A-46E8-A352-092DC4CF1515} \n",
"2 {B8125FE1-5C8F-4F38-AE0D-9AC8CD81C958} \n",
"3 {7898CD0A-B435-41BE-8B1E-A8D8FBB60825} \n",
"4 {00334042-8F29-4B5A-A602-C93B25E1F9A9} \n",
"5 {D5A23478-55D6-4FF8-B074-0374C6B1C648} \n",
"6 {14B5E343-33DF-4A6A-8346-02A2344740BF} \n",
"7 {C5CBDA5B-1586-4A38-B4BD-7C4CBEF4D4EB} \n",
"8 {7A127EAD-6907-465B-B19A-AF2700871B51} \n",
"9 {614548B9-DC2B-4C01-94A9-76742D2338D1} \n",
"10 {5C1CD50C-9BE1-49B8-BD9E-7E4213C81E17} \n",
"11 {C6920E4F-FCF6-4CF9-B759-7492DE0C0CEA} \n",
"12 {B19D5945-ED94-4268-B202-A63CFE397982} \n",
"13 {7A3BCA83-00EA-451D-BB2C-9E0521E875D5} \n",
"14 {1828B630-EFD5-4A7F-9893-AB7FF5DB6AA6} \n",
"15 {744135E5-3BA1-477C-852A-9CFE2966242F} \n",
"16 6e5d6e7b-12ff-49bb-8a82-8f008eea06fa \n",
"17 {419786C1-D481-45A8-A66B-F952B1DB6934} \n",
"18 5fd367b4-a823-4c32-a617-92837d5d529e \n",
"19 {2990B35D-7EFF-4B07-A4E8-6867E3E06659} \n",
"20 9bb6d77e-23b0-4d43-910e-9ed89b0c4fa2 \n",
"21 e274b8bc-7788-4631-ad32-74467087b16d \n",
"22 {BED99236-D51D-443A-AFD6-6164D94A896C} \n",
"23 {56004969-19E4-4540-B0AE-E230159FA9D5} \n",
"24 {21C5EA2B-14CE-4617-AAB5-A25DD218DB65} \n",
"25 {9FA999EA-2891-4355-9439-4668CDE8FDE6} \n",
"26 {9107C899-8BEB-45F0-AFB0-87163BFDFA78} \n",
"27 18c65f46-3e97-46ba-b50c-d9e2efcea466 \n",
"28 {ADCC280D-8D7E-4985-9F3E-945F91EE8653} \n",
"29 59a0d964-33f2-401a-ae5e-6c6314f98dd5 \n",
"30 {DA51DF18-CB4E-4AB9-9B5B-E389E1148D3E} \n",
"31 {6C1A1432-179A-46EE-A296-8319135E9417} \n",
"32 {26831785-DDD4-490B-8F18-47EE5C6857D1} \n",
"33 {B2820417-B331-4012-8B9D-497D81784743} \n",
"34 {38B7F747-3AD2-4ACD-B670-EA7F46799349} \n",
"35 {F75C75A0-DFFC-4B80-9E0D-D6901D2A8762} \n",
"36 {1CFE3397-2827-410E-BFD3-91ECA6A30CE6} \n",
"37 {CD53B7B1-8233-4C6B-8D00-D419EDED71E9} \n",
"38 af79ecb7-4d55-4c42-86db-4dd9ac0acb85 \n",
"39 {1A1A2433-D5F6-4DC0-A749-40127719BFB2} \n",
"40 {09317F9A-0156-4B4C-965A-D5836044D083} \n",
"41 931fb31c-9757-451e-8a19-ff39f164037d \n",
"42 {187CE5A6-716C-4912-A7A0-ED0C30B023C0} \n",
"43 {881B2DEE-BD3A-47CE-B33B-3DC639231FA5} \n",
"44 {85207800-4B2C-4315-AA90-0B1A58D6E51A} \n",
"45 {15E330B1-DDEC-4B44-B26A-2F2ED69506E6} \n",
"46 {789E2C0C-F9F9-4520-875F-30C1C80C89C3} \n",
"47 {358C3206-4455-4F2E-A211-60A0F9916957} \n",
"48 {856F5F1A-3EE4-4D7F-9134-55B03F2AB2F3} \n",
"49 {E7A40C02-48D4-4676-9777-CCE2BFC41A1B} \n",
"\n",
" title \\\n",
"0 AQUATIC PARCEL \n",
"1 Net Shore-Drift in Washington State \n",
"2 Public Utility Districts (PUD) \n",
"3 Dams \n",
"4 Washington State Marine Bathymetry Mosaic - Bs... \n",
"5 Sea Urchins - urchin \n",
"6 Ferry Districts (FRY) \n",
"7 Military Reservations of Washington State, at ... \n",
"8 Coastal Washington Canopy Forest 2006 \n",
"9 Commercial Vessel Density October 2009-2010 AI... \n",
"10 Watershed Administrative Units (Washington Sta... \n",
"11 Herring Spawning Areas in Washington - HerrSpwn \n",
"12 Forest Practices Wetlands \n",
"13 Coastal Washington Land Cover 2006 \n",
"14 National Wetlands Inventory for Washington Sta... \n",
"15 Forage Fish Surveys \n",
"16 Brookings, Gold Beach All Fishing Sectors Fish... \n",
"17 Rivers and Streams of Washington State 1:24,00... \n",
"18 Offshore sand, gravel and shell deposits off O... \n",
"19 Indian Reservations of Washington State \n",
"20 SOORC Commercial Fishing Fisheries Uses and Va... \n",
"21 Tow Boat Lanes, WA Sea Grant, 2007 \n",
"22 Documented Subtidal Geoduck Clam areas in Wash... \n",
"23 Washington State Marine Shoreline (polygon) \n",
"24 Washington Shoreline Public Access Project \n",
"25 Digital Offshore Cadastre (DOC) - Pacific83 \u0096 ... \n",
"26 Puget Sound Abalone - abalone \n",
"27 Ocean Recreation Shore Activities, Last Trip P... \n",
"28 Impervious Surfaces Washington 2006 \n",
"29 Garibaldi All Fishing Sectors Fisheries Uses a... \n",
"30 GRP Potential Spill Origin locations \n",
"31 Washington Department of Fish and Wildlife own... \n",
"32 Documented Rocksole (Lepidopsetta bilineata) s... \n",
"33 Priority Habitats and Species - PHSREGION \n",
"34 Marine Water Quality Sampling Stations \n",
"35 Fish Culture and Misc Facilities - Facility \n",
"36 Washington State Marine Shorelines (arc) \n",
"37 Documented Sand Lance Spawning \n",
"38 Astoria All Fishing Sectors Fisheries Uses and... \n",
"39 Cities (Sales and Use Tax) \n",
"40 Washington State Levee Inventory \n",
"41 Newport All Sector Fisheries Uses Grid, Ecotru... \n",
"42 Parks and Recreation Districts (PKR) \n",
"43 Documented Smelt Spawning \n",
"44 Port DIstricts (PRT) \n",
"45 Washington Department of Fish and Wildlife Are... \n",
"46 Stream Temperature \n",
"47 Polygons showing documented Pacific Oyster (Cr... \n",
"48 Atlas of Seal and Sea Lion Haulout Sites in Wa... \n",
"49 AQUATIC BOUNDARY \n",
"\n",
" creator dtpub1 dtpub2 \\\n",
"0 Washington Department of Natural Resources Unknown None \n",
"1 Shorelands and Environmental Assistance Progra... 20020901 None \n",
"2 Washington State Department of Revenue 2012-10-02 None \n",
"3 Washington State Department of Fish and Wildlife 20100716 None \n",
"4 Washington Department of Fish and Wildlife, Wi... 1997 None \n",
"5 Washington Department of Fish and Wildlife 199204 None \n",
"6 Washington State Department of Revenue 2012-10-02 None \n",
"7 GIS/Cartography Section, Washington State Depa... 19990518 None \n",
"8 Department of Commerce (DOC), National Oceanic... 20081222 None \n",
"9 Department of Commerce (DOC), National Oceanic... 201209 None \n",
"10 Washington State Department of Natural Resourc... April 2006 None \n",
"11 Washington Department of Fish and Wildlife 2008 None \n",
"12 Washington State Department of Natural Resourc... c. 1995 None \n",
"13 Department of Commerce (DOC), National Oceanic... 20081222 None \n",
"14 United States Fish and Wildlife Service 1989 None \n",
"15 Washington Department of Fish and Wildlife 08/01/2008 None \n",
"16 None None None \n",
"17 Washington Department of Fish and Wildlife, Fi... 20040101 None \n",
"18 None None None \n",
"19 Cartography Section, Washington State Departme... 19980130 None \n",
"20 None None None \n",
"21 None None None \n",
"22 WDFW, Marine Resources, Shellfish Dive Team 06/21/2009 None \n",
"23 Washington State Department of Ecology 20010830 None \n",
"24 Jessica Archer 20091013 None \n",
"25 Bureau of Ocean Energy Management, Mapping and... 20060210 None \n",
"26 Washington Department of Fish and Wildlife 1992 None \n",
"27 None None None \n",
"28 NOAA (National Oceanographic and Atmospheric A... 20090403 None \n",
"29 None None None \n",
"30 Washington State Department of Ecology 20091012 None \n",
"31 Washington Department of Fish and Wildlife, Wi... 20100601 None \n",
"32 Washington Department of Fish and Wildlife 199204 None \n",
"33 Washington Department of Fish and Wildlife 2010 None \n",
"34 DOH 01/27/2010 None \n",
"35 Washington Department of Fish and Wildlife 19990101 None \n",
"36 Washington State Department of Ecology 20010830 None \n",
"37 Washington Department of Fish and Wildlife 08/01/2008 None \n",
"38 None None None \n",
"39 Washington State Department of Revenue 2013-10-01 None \n",
"40 Western Washington University, Huxley College ... 20120502 None \n",
"41 None None None \n",
"42 Washington State Department of Revenue 2012-10-02 None \n",
"43 Washington Department of Fish and Wildlife 08/01/2008 None \n",
"44 Washington State Department of Revenue 2012-10-02 None \n",
"45 Washington Department of Fish and Wildlife 20120305 None \n",
"46 Washington State Department of Natural Resourc... 19950228 None \n",
"47 Washington Department of Fish and Wildlife 199204 None \n",
"48 Washington Department of Fish and Wildlife 2000 None \n",
"49 Washington Department of Natural Reources December 2005 None \n",
"\n",
" pub1 \\\n",
"0 None \n",
"1 Washington State Department of Ecology \n",
"2 Washington State Department of Revenue \n",
"3 None \n",
"4 Washington State Department of Fish and Wildli... \n",
"5 Washington Department of Fish and Wildlife - P... \n",
"6 Washington State Department of Revenue \n",
"7 Washington State Department of Transportation,... \n",
"8 NOAA Coastal Services Center \n",
"9 NOAA Coastal Services Center \n",
"10 Washington State Department of Natural Resources \n",
"11 Washington Department of Fish and Wildlife - P... \n",
"12 None \n",
"13 NOAA Coastal Services Center \n",
"14 Washington Department of Fish and Wildlife - P... \n",
"15 Washington Department of Fish and Wildlife \n",
"16 None \n",
"17 Washington Department of Fish & Wildlife - Pri... \n",
"18 None \n",
"19 Washington State Department of Transportation,... \n",
"20 None \n",
"21 None \n",
"22 WDFW \n",
"23 Washington State Department of Ecology \n",
"24 Washington State Department of Ecology \n",
"25 Bureau of Ocean Energy Management, Mapping and... \n",
"26 Washington Department of Fish and Wildlife - P... \n",
"27 None \n",
"28 NOAA Coastal Services Center \n",
"29 None \n",
"30 Washington State Department of Ecology \n",
"31 None \n",
"32 Washington Department of Fish and Wildlife - P... \n",
"33 Washington Department of Fish and Wildlife - P... \n",
"34 Washington State Department of Health \n",
"35 Washington Department of Fish and Wildlife - P... \n",
"36 Washington State Department of Ecology \n",
"37 Washington Department of Fish and Wildlife \n",
"38 None \n",
"39 Washington State Department of Revenue \n",
"40 Washington State Department of Ecology \n",
"41 None \n",
"42 Washington State Department of Revenue \n",
"43 Washington Department of Fish and Wildlife \n",
"44 Washington State Department of Revenue \n",
"45 None \n",
"46 Washington State Department of Natural Resourc... \n",
"47 Washington Department of Fish and Wildlife - P... \n",
"48 Washington Department of Fish and WildlifeFW \n",
"49 None \n",
"\n",
" pub2 \\\n",
"0 None \n",
"1 Washington State Department of Ecology \n",
"2 Washington State Department of Revenue \n",
"3 Washington State Department of Fish and Wildlife \n",
"4 Washington Department of Fish and Wildlife \n",
"5 Washington Department of Fish and Wildlife \n",
"6 Washington State Department of Revenue \n",
"7 Washington State Department of Transportation \n",
"8 NOAA's Ocean Service, Coastal Services Center ... \n",
"9 NOAA's Ocean Service, Coastal Services Center ... \n",
"10 None \n",
"11 Washington Department of Fish and Wildlife \n",
"12 None \n",
"13 NOAA's Ocean Service, Coastal Services Center ... \n",
"14 None \n",
"15 Washington Department of Fish and Wildlife \n",
"16 None \n",
"17 Washington Department of Fish and Wildlife \n",
"18 None \n",
"19 Washington State Department of Transportation \n",
"20 None \n",
"21 None \n",
"22 None \n",
"23 Washington State Department of Ecology \n",
"24 None \n",
"25 Bureau of Ocean Energy Management, Mapping and... \n",
"26 Washington Department of Fish and Wildlife \n",
"27 None \n",
"28 NOAA Coastal Change Analysis Program (C-CAP) \n",
"29 None \n",
"30 None \n",
"31 Washington Department of Fish and Wildlife \n",
"32 Washington Department of Fish and Wildlife \n",
"33 None \n",
"34 None \n",
"35 Washington Department of Fish and Wildlife \n",
"36 Washington State Department of Ecology \n",
"37 Washington Department of Fish and Wildlife \n",
"38 None \n",
"39 Washington State Department of Revenue \n",
"40 None \n",
"41 None \n",
"42 Washington State Department of Revenue \n",
"43 Washington Department of Fish and Wildlife \n",
"44 Washington State Department of Revenue \n",
"45 None \n",
"46 Washington Department of Natural Resources \n",
"47 Washington Department of Fish and Wildlife \n",
"48 None \n",
"49 None \n",
"\n",
" source \n",
"0 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"1 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"2 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"3 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"4 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"5 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"6 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"7 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"8 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"9 {A8C44A63-CDA1-44CA-941C-F02018D3BF88} \n",
"10 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"11 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"12 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"13 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"14 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"15 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"16 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"17 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"18 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"19 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"20 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"21 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"22 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"23 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"24 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"25 {8D54230F-726E-460C-9F30-ECAC9B714DF5} \n",
"26 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"27 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"28 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"29 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"30 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"31 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"32 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"33 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"34 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"35 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"36 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"37 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"38 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"39 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"40 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"41 {AAE7292A-8726-44A7-BA01-989E49D04A93} \n",
"42 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"43 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"44 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"45 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"46 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"47 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"48 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} \n",
"49 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} "
]
}
],
"prompt_number": 19
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"List the unique catalog sources in the csw results, and corresponding metadata record counts"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# The first one must be the WA State Geospatial Clearinghouse\n",
"# How can one query the CSW endpoint to get the catalog source name/title for each of source ID?\n",
"recmddf.source.value_counts()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 20,
"text": [
"{5A96678F-8FFB-4F11-BF9D-83E6017C965C} 40\n",
"{AAE7292A-8726-44A7-BA01-989E49D04A93} 8\n",
"{A8C44A63-CDA1-44CA-941C-F02018D3BF88} 1\n",
"{8D54230F-726E-460C-9F30-ECAC9B714DF5} 1\n",
"dtype: int64"
]
}
],
"prompt_number": 20
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Examine the variability in creator/publisher name strings across the 3 different fields (creator, pub1, pub2). For each of these fields, do a unique value count."
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# creator: idinfo/citation/citeinfo/origin\n",
"# unique strings and counts ('None'/null entries are probably excluded)\n",
"print \"Number of non-null entries: \", recmddf.creator.count()\n",
"pd.DataFrame(recmddf.creator.fillna('MISSING').value_counts().sort_index())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"Number of non-null entries: 42\n"
]
},
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Bureau of Ocean Energy Management, Mapping and Boundary Branch</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Cartography Section, Washington State Department of Transportation</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>DOH</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Department of Commerce (DOC), National Oceanic and Atmospheric Administration (NOAA), National Ocean Service (NOS), Coastal Services Center (CSC)</th>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>GIS/Cartography Section, Washington State Department of Transportation</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Jessica Archer</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MISSING</th>\n",
" <td> 8</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOAA (National Oceanographic and Atmospheric Administration) CSC (Coastal Services Center)/Coastal Change Analysis Program (C-CAP)</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Shorelands and Environmental Assistance Program (SEA), Washington State Department of Ecology</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>United States Fish and Wildlife Service</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WDFW, Marine Resources, Shellfish Dive Team</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife</th>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife, Fish Program Science Division, Biological Data Systems</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife, Wildlife Program, Science Division, Spatial Data Management Section</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife, Wildlife Program, Science Division, Spatial Data Mangement Unit</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Natural Reources</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Natural Resources</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Ecology</th>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Fish and Wildlife</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Natural Resources Forest Practices Division</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Natural Resources, Forest Practices Division</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Natural Resources, Forest Practices Division reselect of USFWS National Wetlands Inventory (NWI) data</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Revenue</th>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Western Washington University, Huxley College of the Environment</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 21,
"text": [
" 0\n",
"Bureau of Ocean Energy Management, Mapping and Boundary Branch 1\n",
"Cartography Section, Washington State Department of Transportation 1\n",
"DOH 1\n",
"Department of Commerce (DOC), National Oceanic and Atmospheric Administration (NOAA), National Ocean Service (NOS), Coastal Services Center (CSC) 3\n",
"GIS/Cartography Section, Washington State Department of Transportation 1\n",
"Jessica Archer 1\n",
"MISSING 8\n",
"NOAA (National Oceanographic and Atmospheric Administration) CSC (Coastal Services Center)/Coastal Change Analysis Program (C-CAP) 1\n",
"Shorelands and Environmental Assistance Program (SEA), Washington State Department of Ecology 1\n",
"United States Fish and Wildlife Service 1\n",
"WDFW, Marine Resources, Shellfish Dive Team 1\n",
"Washington Department of Fish and Wildlife 12\n",
"Washington Department of Fish and Wildlife, Fish Program Science Division, Biological Data Systems 1\n",
"Washington Department of Fish and Wildlife, Wildlife Program, Science Division, Spatial Data Management Section 1\n",
"Washington Department of Fish and Wildlife, Wildlife Program, Science Division, Spatial Data Mangement Unit 1\n",
"Washington Department of Natural Reources 1\n",
"Washington Department of Natural Resources 1\n",
"Washington State Department of Ecology 3\n",
"Washington State Department of Fish and Wildlife 1\n",
"Washington State Department of Natural Resources Forest Practices Division 1\n",
"Washington State Department of Natural Resources, Forest Practices Division 1\n",
"Washington State Department of Natural Resources, Forest Practices Division reselect of USFWS National Wetlands Inventory (NWI) data 1\n",
"Washington State Department of Revenue 5\n",
"Western Washington University, Huxley College of the Environment 1"
]
}
],
"prompt_number": 21
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# pub1: idinfo/citation/citeinfo/origin\n",
"# unique strings and counts ('None'/null entries are probably excluded)\n",
"print \"Number of non-null entries: \", recmddf.pub1.count()\n",
"pd.DataFrame(recmddf.pub1.fillna('MISSING').value_counts().sort_index())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"Number of non-null entries: 36\n"
]
},
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Bureau of Ocean Energy Management, Mapping and\\nBoundary Branch</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MISSING</th>\n",
" <td> 14</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOAA Coastal Services Center</th>\n",
" <td> 4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>WDFW</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish &amp; Wildlife - Priority Habitat and Species</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife</th>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife - Priority Habatat and Species</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife - Priority Habitats and Species.</th>\n",
" <td> 7</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and WildlifeFW</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Ecology</th>\n",
" <td> 6</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Fish and Wildlife, Wildlife Program, Science Division, Spatial Data Management Unit</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Health</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Natural Resources</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Natural Resources, Forest Practices Division</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Revenue</th>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Transportation, Office of Information Technology</th>\n",
" <td> 2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 22,
"text": [
" 0\n",
"Bureau of Ocean Energy Management, Mapping and\\nBoundary Branch 1\n",
"MISSING 14\n",
"NOAA Coastal Services Center 4\n",
"WDFW 1\n",
"Washington Department of Fish & Wildlife - Priority Habitat and Species 1\n",
"Washington Department of Fish and Wildlife 3\n",
"Washington Department of Fish and Wildlife - Priority Habatat and Species 1\n",
"Washington Department of Fish and Wildlife - Priority Habitats and Species. 7\n",
"Washington Department of Fish and WildlifeFW 1\n",
"Washington State Department of Ecology 6\n",
"Washington State Department of Fish and Wildlife, Wildlife Program, Science Division, Spatial Data Management Unit 1\n",
"Washington State Department of Health 1\n",
"Washington State Department of Natural Resources 1\n",
"Washington State Department of Natural Resources, Forest Practices Division 1\n",
"Washington State Department of Revenue 5\n",
"Washington State Department of Transportation, Office of Information Technology 2"
]
}
],
"prompt_number": 22
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# pub2: idinfo/citation/citeinfo/origin\n",
"# unique strings and counts ('None'/null entries are probably excluded)\n",
"print \"Number of non-null entries: \", recmddf.pub2.count()\n",
"pd.DataFrame(recmddf.pub2.fillna('MISSING').value_counts().sort_index())"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"Number of non-null entries: 29\n"
]
},
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>0</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>Bureau of Ocean Energy Management, Mapping and Boundary Branch</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>MISSING</th>\n",
" <td> 21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOAA Coastal Change Analysis Program (C-CAP)</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>NOAA's Ocean Service, Coastal Services Center (CSC)</th>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Fish and Wildlife</th>\n",
" <td> 12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington Department of Natural Resources</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Ecology</th>\n",
" <td> 3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Fish and Wildlife</th>\n",
" <td> 1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Revenue</th>\n",
" <td> 5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>Washington State Department of Transportation</th>\n",
" <td> 2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 23,
"text": [
" 0\n",
"Bureau of Ocean Energy Management, Mapping and Boundary Branch 1\n",
"MISSING 21\n",
"NOAA Coastal Change Analysis Program (C-CAP) 1\n",
"NOAA's Ocean Service, Coastal Services Center (CSC) 3\n",
"Washington Department of Fish and Wildlife 12\n",
"Washington Department of Natural Resources 1\n",
"Washington State Department of Ecology 3\n",
"Washington State Department of Fish and Wildlife 1\n",
"Washington State Department of Revenue 5\n",
"Washington State Department of Transportation 2"
]
}
],
"prompt_number": 23
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"First shot at parsing multiple kinds of date strings into a Python datetime object, in the metadata document"
]
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"import dateutil.parser as duparser\n",
"def parse_date(s):\n",
" if s is None:\n",
" return s\n",
" elif s.isdigit() and len(s) == 6:\n",
" retd = duparser.parse(s+'15').date() # eg: 199904\n",
" elif s.isdigit() and len(s) == 4:\n",
" retd = duparser.parse(s+'0615').date() # eg: 1999\n",
" else:\n",
" try:\n",
" retd = duparser.parse(s).date()\n",
" except ValueError:\n",
" retd = None\n",
" return retd"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 24
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"print parse_date('199904'), '|', parse_date('2012-10-02'), '|', parse_date('Nov. 2011')"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "stream",
"stream": "stdout",
"text": [
"1999-04-15 | 2012-10-02 | 2011-11-28\n"
]
}
],
"prompt_number": 25
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"recmddf['dtpub1_parsed'] = recmddf['dtpub1'].map(parse_date)"
],
"language": "python",
"metadata": {},
"outputs": [],
"prompt_number": 26
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"recmddf['dtpub1_parsed'].head()"
],
"language": "python",
"metadata": {},
"outputs": [
{
"output_type": "pyout",
"prompt_number": 27,
"text": [
"0 None\n",
"1 2002-09-01\n",
"2 2012-10-02\n",
"3 2010-07-16\n",
"4 1997-06-15\n",
"Name: dtpub1_parsed, dtype: object"
]
}
],
"prompt_number": 27
},
{
"cell_type": "code",
"collapsed": false,
"input": [
"# Data Frame with the new parsed date field added at the end (last column)\n",
"recmddf"
],
"language": "python",
"metadata": {},
"outputs": [
{
"html": [
"<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>id</th>\n",
" <th>title</th>\n",
" <th>creator</th>\n",
" <th>dtpub1</th>\n",
" <th>dtpub2</th>\n",
" <th>pub1</th>\n",
" <th>pub2</th>\n",
" <th>source</th>\n",
" <th>dtpub1_parsed</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0 </th>\n",
" <td> {8A236ABD-AD5F-482E-96D0-33F58741B029}</td>\n",
" <td> AQUATIC PARCEL</td>\n",
" <td> Washington Department of Natural Resources</td>\n",
" <td> Unknown</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1 </th>\n",
" <td> {FE0C794A-4B9A-46E8-A352-092DC4CF1515}</td>\n",
" <td> Net Shore-Drift in Washington State</td>\n",
" <td> Shorelands and Environmental Assistance Progra...</td>\n",
" <td> 20020901</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2002-09-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2 </th>\n",
" <td> {B8125FE1-5C8F-4F38-AE0D-9AC8CD81C958}</td>\n",
" <td> Public Utility Districts (PUD)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2012-10-02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3 </th>\n",
" <td> {7898CD0A-B435-41BE-8B1E-A8D8FBB60825}</td>\n",
" <td> Dams</td>\n",
" <td> Washington State Department of Fish and Wildlife</td>\n",
" <td> 20100716</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2010-07-16</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4 </th>\n",
" <td> {00334042-8F29-4B5A-A602-C93B25E1F9A9}</td>\n",
" <td> Washington State Marine Bathymetry Mosaic - Bs...</td>\n",
" <td> Washington Department of Fish and Wildlife, Wi...</td>\n",
" <td> 1997</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Fish and Wildli...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1997-06-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5 </th>\n",
" <td> {D5A23478-55D6-4FF8-B074-0374C6B1C648}</td>\n",
" <td> Sea Urchins - urchin</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 199204</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1992-04-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6 </th>\n",
" <td> {14B5E343-33DF-4A6A-8346-02A2344740BF}</td>\n",
" <td> Ferry Districts (FRY)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2012-10-02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7 </th>\n",
" <td> {C5CBDA5B-1586-4A38-B4BD-7C4CBEF4D4EB}</td>\n",
" <td> Military Reservations of Washington State, at ...</td>\n",
" <td> GIS/Cartography Section, Washington State Depa...</td>\n",
" <td> 19990518</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Transportation,...</td>\n",
" <td> Washington State Department of Transportation</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1999-05-18</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8 </th>\n",
" <td> {7A127EAD-6907-465B-B19A-AF2700871B51}</td>\n",
" <td> Coastal Washington Canopy Forest 2006</td>\n",
" <td> Department of Commerce (DOC), National Oceanic...</td>\n",
" <td> 20081222</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA's Ocean Service, Coastal Services Center ...</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2008-12-22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9 </th>\n",
" <td> {614548B9-DC2B-4C01-94A9-76742D2338D1}</td>\n",
" <td> Commercial Vessel Density October 2009-2010 AI...</td>\n",
" <td> Department of Commerce (DOC), National Oceanic...</td>\n",
" <td> 201209</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA's Ocean Service, Coastal Services Center ...</td>\n",
" <td> {A8C44A63-CDA1-44CA-941C-F02018D3BF88}</td>\n",
" <td> 2012-09-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td> {5C1CD50C-9BE1-49B8-BD9E-7E4213C81E17}</td>\n",
" <td> Watershed Administrative Units (Washington Sta...</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> April 2006</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Natural Resources</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2006-04-28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td> {C6920E4F-FCF6-4CF9-B759-7492DE0C0CEA}</td>\n",
" <td> Herring Spawning Areas in Washington - HerrSpwn</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2008-06-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td> {B19D5945-ED94-4268-B202-A63CFE397982}</td>\n",
" <td> Forest Practices Wetlands</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> c. 1995</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td> {7A3BCA83-00EA-451D-BB2C-9E0521E875D5}</td>\n",
" <td> Coastal Washington Land Cover 2006</td>\n",
" <td> Department of Commerce (DOC), National Oceanic...</td>\n",
" <td> 20081222</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA's Ocean Service, Coastal Services Center ...</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2008-12-22</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td> {1828B630-EFD5-4A7F-9893-AB7FF5DB6AA6}</td>\n",
" <td> National Wetlands Inventory for Washington Sta...</td>\n",
" <td> United States Fish and Wildlife Service</td>\n",
" <td> 1989</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1989-06-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td> {744135E5-3BA1-477C-852A-9CFE2966242F}</td>\n",
" <td> Forage Fish Surveys</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 08/01/2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2008-08-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td> 6e5d6e7b-12ff-49bb-8a82-8f008eea06fa</td>\n",
" <td> Brookings, Gold Beach All Fishing Sectors Fish...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td> {419786C1-D481-45A8-A66B-F952B1DB6934}</td>\n",
" <td> Rivers and Streams of Washington State 1:24,00...</td>\n",
" <td> Washington Department of Fish and Wildlife, Fi...</td>\n",
" <td> 20040101</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish &amp; Wildlife - Pri...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2004-01-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td> 5fd367b4-a823-4c32-a617-92837d5d529e</td>\n",
" <td> Offshore sand, gravel and shell deposits off O...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td> {2990B35D-7EFF-4B07-A4E8-6867E3E06659}</td>\n",
" <td> Indian Reservations of Washington State</td>\n",
" <td> Cartography Section, Washington State Departme...</td>\n",
" <td> 19980130</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Transportation,...</td>\n",
" <td> Washington State Department of Transportation</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1998-01-30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td> 9bb6d77e-23b0-4d43-910e-9ed89b0c4fa2</td>\n",
" <td> SOORC Commercial Fishing Fisheries Uses and Va...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td> e274b8bc-7788-4631-ad32-74467087b16d</td>\n",
" <td> Tow Boat Lanes, WA Sea Grant, 2007</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td> {BED99236-D51D-443A-AFD6-6164D94A896C}</td>\n",
" <td> Documented Subtidal Geoduck Clam areas in Wash...</td>\n",
" <td> WDFW, Marine Resources, Shellfish Dive Team</td>\n",
" <td> 06/21/2009</td>\n",
" <td> None</td>\n",
" <td> WDFW</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2009-06-21</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td> {56004969-19E4-4540-B0AE-E230159FA9D5}</td>\n",
" <td> Washington State Marine Shoreline (polygon)</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> 20010830</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2001-08-30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td> {21C5EA2B-14CE-4617-AAB5-A25DD218DB65}</td>\n",
" <td> Washington Shoreline Public Access Project</td>\n",
" <td> Jessica Archer</td>\n",
" <td> 20091013</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2009-10-13</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td> {9FA999EA-2891-4355-9439-4668CDE8FDE6}</td>\n",
" <td> Digital Offshore Cadastre (DOC) - Pacific83 \u0096 ...</td>\n",
" <td> Bureau of Ocean Energy Management, Mapping and...</td>\n",
" <td> 20060210</td>\n",
" <td> None</td>\n",
" <td> Bureau of Ocean Energy Management, Mapping and...</td>\n",
" <td> Bureau of Ocean Energy Management, Mapping and...</td>\n",
" <td> {8D54230F-726E-460C-9F30-ECAC9B714DF5}</td>\n",
" <td> 2006-02-10</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td> {9107C899-8BEB-45F0-AFB0-87163BFDFA78}</td>\n",
" <td> Puget Sound Abalone - abalone</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 1992</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1992-06-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td> 18c65f46-3e97-46ba-b50c-d9e2efcea466</td>\n",
" <td> Ocean Recreation Shore Activities, Last Trip P...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td> {ADCC280D-8D7E-4985-9F3E-945F91EE8653}</td>\n",
" <td> Impervious Surfaces Washington 2006</td>\n",
" <td> NOAA (National Oceanographic and Atmospheric A...</td>\n",
" <td> 20090403</td>\n",
" <td> None</td>\n",
" <td> NOAA Coastal Services Center</td>\n",
" <td> NOAA Coastal Change Analysis Program (C-CAP)</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2009-04-03</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td> 59a0d964-33f2-401a-ae5e-6c6314f98dd5</td>\n",
" <td> Garibaldi All Fishing Sectors Fisheries Uses a...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td> {DA51DF18-CB4E-4AB9-9B5B-E389E1148D3E}</td>\n",
" <td> GRP Potential Spill Origin locations</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> 20091012</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2009-10-12</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td> {6C1A1432-179A-46EE-A296-8319135E9417}</td>\n",
" <td> Washington Department of Fish and Wildlife own...</td>\n",
" <td> Washington Department of Fish and Wildlife, Wi...</td>\n",
" <td> 20100601</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2010-06-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td> {26831785-DDD4-490B-8F18-47EE5C6857D1}</td>\n",
" <td> Documented Rocksole (Lepidopsetta bilineata) s...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 199204</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1992-04-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td> {B2820417-B331-4012-8B9D-497D81784743}</td>\n",
" <td> Priority Habitats and Species - PHSREGION</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 2010</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2010-06-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td> {38B7F747-3AD2-4ACD-B670-EA7F46799349}</td>\n",
" <td> Marine Water Quality Sampling Stations</td>\n",
" <td> DOH</td>\n",
" <td> 01/27/2010</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Health</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2010-01-27</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td> {F75C75A0-DFFC-4B80-9E0D-D6901D2A8762}</td>\n",
" <td> Fish Culture and Misc Facilities - Facility</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 19990101</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1999-01-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td> {1CFE3397-2827-410E-BFD3-91ECA6A30CE6}</td>\n",
" <td> Washington State Marine Shorelines (arc)</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> 20010830</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2001-08-30</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td> {CD53B7B1-8233-4C6B-8D00-D419EDED71E9}</td>\n",
" <td> Documented Sand Lance Spawning</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 08/01/2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2008-08-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td> af79ecb7-4d55-4c42-86db-4dd9ac0acb85</td>\n",
" <td> Astoria All Fishing Sectors Fisheries Uses and...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td> {1A1A2433-D5F6-4DC0-A749-40127719BFB2}</td>\n",
" <td> Cities (Sales and Use Tax)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2013-10-01</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2013-10-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td> {09317F9A-0156-4B4C-965A-D5836044D083}</td>\n",
" <td> Washington State Levee Inventory</td>\n",
" <td> Western Washington University, Huxley College ...</td>\n",
" <td> 20120502</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Ecology</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2012-05-02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td> 931fb31c-9757-451e-8a19-ff39f164037d</td>\n",
" <td> Newport All Sector Fisheries Uses Grid, Ecotru...</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {AAE7292A-8726-44A7-BA01-989E49D04A93}</td>\n",
" <td> None</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td> {187CE5A6-716C-4912-A7A0-ED0C30B023C0}</td>\n",
" <td> Parks and Recreation Districts (PKR)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2012-10-02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td> {881B2DEE-BD3A-47CE-B33B-3DC639231FA5}</td>\n",
" <td> Documented Smelt Spawning</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 08/01/2008</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2008-08-01</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td> {85207800-4B2C-4315-AA90-0B1A58D6E51A}</td>\n",
" <td> Port DIstricts (PRT)</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> 2012-10-02</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> Washington State Department of Revenue</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2012-10-02</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td> {15E330B1-DDEC-4B44-B26A-2F2ED69506E6}</td>\n",
" <td> Washington Department of Fish and Wildlife Are...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 20120305</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2012-03-05</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td> {789E2C0C-F9F9-4520-875F-30C1C80C89C3}</td>\n",
" <td> Stream Temperature</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> 19950228</td>\n",
" <td> None</td>\n",
" <td> Washington State Department of Natural Resourc...</td>\n",
" <td> Washington Department of Natural Resources</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1995-02-28</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td> {358C3206-4455-4F2E-A211-60A0F9916957}</td>\n",
" <td> Polygons showing documented Pacific Oyster (Cr...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 199204</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and Wildlife - P...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 1992-04-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td> {856F5F1A-3EE4-4D7F-9134-55B03F2AB2F3}</td>\n",
" <td> Atlas of Seal and Sea Lion Haulout Sites in Wa...</td>\n",
" <td> Washington Department of Fish and Wildlife</td>\n",
" <td> 2000</td>\n",
" <td> None</td>\n",
" <td> Washington Department of Fish and WildlifeFW</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2000-06-15</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td> {E7A40C02-48D4-4676-9777-CCE2BFC41A1B}</td>\n",
" <td> AQUATIC BOUNDARY</td>\n",
" <td> Washington Department of Natural Reources</td>\n",
" <td> December 2005</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> None</td>\n",
" <td> {5A96678F-8FFB-4F11-BF9D-83E6017C965C}</td>\n",
" <td> 2005-12-28</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"output_type": "pyout",
"prompt_number": 28,
"text": [
" id \\\n",
"0 {8A236ABD-AD5F-482E-96D0-33F58741B029} \n",
"1 {FE0C794A-4B9A-46E8-A352-092DC4CF1515} \n",
"2 {B8125FE1-5C8F-4F38-AE0D-9AC8CD81C958} \n",
"3 {7898CD0A-B435-41BE-8B1E-A8D8FBB60825} \n",
"4 {00334042-8F29-4B5A-A602-C93B25E1F9A9} \n",
"5 {D5A23478-55D6-4FF8-B074-0374C6B1C648} \n",
"6 {14B5E343-33DF-4A6A-8346-02A2344740BF} \n",
"7 {C5CBDA5B-1586-4A38-B4BD-7C4CBEF4D4EB} \n",
"8 {7A127EAD-6907-465B-B19A-AF2700871B51} \n",
"9 {614548B9-DC2B-4C01-94A9-76742D2338D1} \n",
"10 {5C1CD50C-9BE1-49B8-BD9E-7E4213C81E17} \n",
"11 {C6920E4F-FCF6-4CF9-B759-7492DE0C0CEA} \n",
"12 {B19D5945-ED94-4268-B202-A63CFE397982} \n",
"13 {7A3BCA83-00EA-451D-BB2C-9E0521E875D5} \n",
"14 {1828B630-EFD5-4A7F-9893-AB7FF5DB6AA6} \n",
"15 {744135E5-3BA1-477C-852A-9CFE2966242F} \n",
"16 6e5d6e7b-12ff-49bb-8a82-8f008eea06fa \n",
"17 {419786C1-D481-45A8-A66B-F952B1DB6934} \n",
"18 5fd367b4-a823-4c32-a617-92837d5d529e \n",
"19 {2990B35D-7EFF-4B07-A4E8-6867E3E06659} \n",
"20 9bb6d77e-23b0-4d43-910e-9ed89b0c4fa2 \n",
"21 e274b8bc-7788-4631-ad32-74467087b16d \n",
"22 {BED99236-D51D-443A-AFD6-6164D94A896C} \n",
"23 {56004969-19E4-4540-B0AE-E230159FA9D5} \n",
"24 {21C5EA2B-14CE-4617-AAB5-A25DD218DB65} \n",
"25 {9FA999EA-2891-4355-9439-4668CDE8FDE6} \n",
"26 {9107C899-8BEB-45F0-AFB0-87163BFDFA78} \n",
"27 18c65f46-3e97-46ba-b50c-d9e2efcea466 \n",
"28 {ADCC280D-8D7E-4985-9F3E-945F91EE8653} \n",
"29 59a0d964-33f2-401a-ae5e-6c6314f98dd5 \n",
"30 {DA51DF18-CB4E-4AB9-9B5B-E389E1148D3E} \n",
"31 {6C1A1432-179A-46EE-A296-8319135E9417} \n",
"32 {26831785-DDD4-490B-8F18-47EE5C6857D1} \n",
"33 {B2820417-B331-4012-8B9D-497D81784743} \n",
"34 {38B7F747-3AD2-4ACD-B670-EA7F46799349} \n",
"35 {F75C75A0-DFFC-4B80-9E0D-D6901D2A8762} \n",
"36 {1CFE3397-2827-410E-BFD3-91ECA6A30CE6} \n",
"37 {CD53B7B1-8233-4C6B-8D00-D419EDED71E9} \n",
"38 af79ecb7-4d55-4c42-86db-4dd9ac0acb85 \n",
"39 {1A1A2433-D5F6-4DC0-A749-40127719BFB2} \n",
"40 {09317F9A-0156-4B4C-965A-D5836044D083} \n",
"41 931fb31c-9757-451e-8a19-ff39f164037d \n",
"42 {187CE5A6-716C-4912-A7A0-ED0C30B023C0} \n",
"43 {881B2DEE-BD3A-47CE-B33B-3DC639231FA5} \n",
"44 {85207800-4B2C-4315-AA90-0B1A58D6E51A} \n",
"45 {15E330B1-DDEC-4B44-B26A-2F2ED69506E6} \n",
"46 {789E2C0C-F9F9-4520-875F-30C1C80C89C3} \n",
"47 {358C3206-4455-4F2E-A211-60A0F9916957} \n",
"48 {856F5F1A-3EE4-4D7F-9134-55B03F2AB2F3} \n",
"49 {E7A40C02-48D4-4676-9777-CCE2BFC41A1B} \n",
"\n",
" title \\\n",
"0 AQUATIC PARCEL \n",
"1 Net Shore-Drift in Washington State \n",
"2 Public Utility Districts (PUD) \n",
"3 Dams \n",
"4 Washington State Marine Bathymetry Mosaic - Bs... \n",
"5 Sea Urchins - urchin \n",
"6 Ferry Districts (FRY) \n",
"7 Military Reservations of Washington State, at ... \n",
"8 Coastal Washington Canopy Forest 2006 \n",
"9 Commercial Vessel Density October 2009-2010 AI... \n",
"10 Watershed Administrative Units (Washington Sta... \n",
"11 Herring Spawning Areas in Washington - HerrSpwn \n",
"12 Forest Practices Wetlands \n",
"13 Coastal Washington Land Cover 2006 \n",
"14 National Wetlands Inventory for Washington Sta... \n",
"15 Forage Fish Surveys \n",
"16 Brookings, Gold Beach All Fishing Sectors Fish... \n",
"17 Rivers and Streams of Washington State 1:24,00... \n",
"18 Offshore sand, gravel and shell deposits off O... \n",
"19 Indian Reservations of Washington State \n",
"20 SOORC Commercial Fishing Fisheries Uses and Va... \n",
"21 Tow Boat Lanes, WA Sea Grant, 2007 \n",
"22 Documented Subtidal Geoduck Clam areas in Wash... \n",
"23 Washington State Marine Shoreline (polygon) \n",
"24 Washington Shoreline Public Access Project \n",
"25 Digital Offshore Cadastre (DOC) - Pacific83 \u0096 ... \n",
"26 Puget Sound Abalone - abalone \n",
"27 Ocean Recreation Shore Activities, Last Trip P... \n",
"28 Impervious Surfaces Washington 2006 \n",
"29 Garibaldi All Fishing Sectors Fisheries Uses a... \n",
"30 GRP Potential Spill Origin locations \n",
"31 Washington Department of Fish and Wildlife own... \n",
"32 Documented Rocksole (Lepidopsetta bilineata) s... \n",
"33 Priority Habitats and Species - PHSREGION \n",
"34 Marine Water Quality Sampling Stations \n",
"35 Fish Culture and Misc Facilities - Facility \n",
"36 Washington State Marine Shorelines (arc) \n",
"37 Documented Sand Lance Spawning \n",
"38 Astoria All Fishing Sectors Fisheries Uses and... \n",
"39 Cities (Sales and Use Tax) \n",
"40 Washington State Levee Inventory \n",
"41 Newport All Sector Fisheries Uses Grid, Ecotru... \n",
"42 Parks and Recreation Districts (PKR) \n",
"43 Documented Smelt Spawning \n",
"44 Port DIstricts (PRT) \n",
"45 Washington Department of Fish and Wildlife Are... \n",
"46 Stream Temperature \n",
"47 Polygons showing documented Pacific Oyster (Cr... \n",
"48 Atlas of Seal and Sea Lion Haulout Sites in Wa... \n",
"49 AQUATIC BOUNDARY \n",
"\n",
" creator dtpub1 dtpub2 \\\n",
"0 Washington Department of Natural Resources Unknown None \n",
"1 Shorelands and Environmental Assistance Progra... 20020901 None \n",
"2 Washington State Department of Revenue 2012-10-02 None \n",
"3 Washington State Department of Fish and Wildlife 20100716 None \n",
"4 Washington Department of Fish and Wildlife, Wi... 1997 None \n",
"5 Washington Department of Fish and Wildlife 199204 None \n",
"6 Washington State Department of Revenue 2012-10-02 None \n",
"7 GIS/Cartography Section, Washington State Depa... 19990518 None \n",
"8 Department of Commerce (DOC), National Oceanic... 20081222 None \n",
"9 Department of Commerce (DOC), National Oceanic... 201209 None \n",
"10 Washington State Department of Natural Resourc... April 2006 None \n",
"11 Washington Department of Fish and Wildlife 2008 None \n",
"12 Washington State Department of Natural Resourc... c. 1995 None \n",
"13 Department of Commerce (DOC), National Oceanic... 20081222 None \n",
"14 United States Fish and Wildlife Service 1989 None \n",
"15 Washington Department of Fish and Wildlife 08/01/2008 None \n",
"16 None None None \n",
"17 Washington Department of Fish and Wildlife, Fi... 20040101 None \n",
"18 None None None \n",
"19 Cartography Section, Washington State Departme... 19980130 None \n",
"20 None None None \n",
"21 None None None \n",
"22 WDFW, Marine Resources, Shellfish Dive Team 06/21/2009 None \n",
"23 Washington State Department of Ecology 20010830 None \n",
"24 Jessica Archer 20091013 None \n",
"25 Bureau of Ocean Energy Management, Mapping and... 20060210 None \n",
"26 Washington Department of Fish and Wildlife 1992 None \n",
"27 None None None \n",
"28 NOAA (National Oceanographic and Atmospheric A... 20090403 None \n",
"29 None None None \n",
"30 Washington State Department of Ecology 20091012 None \n",
"31 Washington Department of Fish and Wildlife, Wi... 20100601 None \n",
"32 Washington Department of Fish and Wildlife 199204 None \n",
"33 Washington Department of Fish and Wildlife 2010 None \n",
"34 DOH 01/27/2010 None \n",
"35 Washington Department of Fish and Wildlife 19990101 None \n",
"36 Washington State Department of Ecology 20010830 None \n",
"37 Washington Department of Fish and Wildlife 08/01/2008 None \n",
"38 None None None \n",
"39 Washington State Department of Revenue 2013-10-01 None \n",
"40 Western Washington University, Huxley College ... 20120502 None \n",
"41 None None None \n",
"42 Washington State Department of Revenue 2012-10-02 None \n",
"43 Washington Department of Fish and Wildlife 08/01/2008 None \n",
"44 Washington State Department of Revenue 2012-10-02 None \n",
"45 Washington Department of Fish and Wildlife 20120305 None \n",
"46 Washington State Department of Natural Resourc... 19950228 None \n",
"47 Washington Department of Fish and Wildlife 199204 None \n",
"48 Washington Department of Fish and Wildlife 2000 None \n",
"49 Washington Department of Natural Reources December 2005 None \n",
"\n",
" pub1 \\\n",
"0 None \n",
"1 Washington State Department of Ecology \n",
"2 Washington State Department of Revenue \n",
"3 None \n",
"4 Washington State Department of Fish and Wildli... \n",
"5 Washington Department of Fish and Wildlife - P... \n",
"6 Washington State Department of Revenue \n",
"7 Washington State Department of Transportation,... \n",
"8 NOAA Coastal Services Center \n",
"9 NOAA Coastal Services Center \n",
"10 Washington State Department of Natural Resources \n",
"11 Washington Department of Fish and Wildlife - P... \n",
"12 None \n",
"13 NOAA Coastal Services Center \n",
"14 Washington Department of Fish and Wildlife - P... \n",
"15 Washington Department of Fish and Wildlife \n",
"16 None \n",
"17 Washington Department of Fish & Wildlife - Pri... \n",
"18 None \n",
"19 Washington State Department of Transportation,... \n",
"20 None \n",
"21 None \n",
"22 WDFW \n",
"23 Washington State Department of Ecology \n",
"24 Washington State Department of Ecology \n",
"25 Bureau of Ocean Energy Management, Mapping and... \n",
"26 Washington Department of Fish and Wildlife - P... \n",
"27 None \n",
"28 NOAA Coastal Services Center \n",
"29 None \n",
"30 Washington State Department of Ecology \n",
"31 None \n",
"32 Washington Department of Fish and Wildlife - P... \n",
"33 Washington Department of Fish and Wildlife - P... \n",
"34 Washington State Department of Health \n",
"35 Washington Department of Fish and Wildlife - P... \n",
"36 Washington State Department of Ecology \n",
"37 Washington Department of Fish and Wildlife \n",
"38 None \n",
"39 Washington State Department of Revenue \n",
"40 Washington State Department of Ecology \n",
"41 None \n",
"42 Washington State Department of Revenue \n",
"43 Washington Department of Fish and Wildlife \n",
"44 Washington State Department of Revenue \n",
"45 None \n",
"46 Washington State Department of Natural Resourc... \n",
"47 Washington Department of Fish and Wildlife - P... \n",
"48 Washington Department of Fish and WildlifeFW \n",
"49 None \n",
"\n",
" pub2 \\\n",
"0 None \n",
"1 Washington State Department of Ecology \n",
"2 Washington State Department of Revenue \n",
"3 Washington State Department of Fish and Wildlife \n",
"4 Washington Department of Fish and Wildlife \n",
"5 Washington Department of Fish and Wildlife \n",
"6 Washington State Department of Revenue \n",
"7 Washington State Department of Transportation \n",
"8 NOAA's Ocean Service, Coastal Services Center ... \n",
"9 NOAA's Ocean Service, Coastal Services Center ... \n",
"10 None \n",
"11 Washington Department of Fish and Wildlife \n",
"12 None \n",
"13 NOAA's Ocean Service, Coastal Services Center ... \n",
"14 None \n",
"15 Washington Department of Fish and Wildlife \n",
"16 None \n",
"17 Washington Department of Fish and Wildlife \n",
"18 None \n",
"19 Washington State Department of Transportation \n",
"20 None \n",
"21 None \n",
"22 None \n",
"23 Washington State Department of Ecology \n",
"24 None \n",
"25 Bureau of Ocean Energy Management, Mapping and... \n",
"26 Washington Department of Fish and Wildlife \n",
"27 None \n",
"28 NOAA Coastal Change Analysis Program (C-CAP) \n",
"29 None \n",
"30 None \n",
"31 Washington Department of Fish and Wildlife \n",
"32 Washington Department of Fish and Wildlife \n",
"33 None \n",
"34 None \n",
"35 Washington Department of Fish and Wildlife \n",
"36 Washington State Department of Ecology \n",
"37 Washington Department of Fish and Wildlife \n",
"38 None \n",
"39 Washington State Department of Revenue \n",
"40 None \n",
"41 None \n",
"42 Washington State Department of Revenue \n",
"43 Washington Department of Fish and Wildlife \n",
"44 Washington State Department of Revenue \n",
"45 None \n",
"46 Washington Department of Natural Resources \n",
"47 Washington Department of Fish and Wildlife \n",
"48 None \n",
"49 None \n",
"\n",
" source dtpub1_parsed \n",
"0 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} None \n",
"1 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2002-09-01 \n",
"2 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2012-10-02 \n",
"3 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2010-07-16 \n",
"4 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1997-06-15 \n",
"5 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1992-04-15 \n",
"6 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2012-10-02 \n",
"7 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1999-05-18 \n",
"8 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2008-12-22 \n",
"9 {A8C44A63-CDA1-44CA-941C-F02018D3BF88} 2012-09-15 \n",
"10 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2006-04-28 \n",
"11 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2008-06-15 \n",
"12 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} None \n",
"13 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2008-12-22 \n",
"14 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1989-06-15 \n",
"15 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2008-08-01 \n",
"16 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"17 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2004-01-01 \n",
"18 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"19 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1998-01-30 \n",
"20 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"21 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"22 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2009-06-21 \n",
"23 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2001-08-30 \n",
"24 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2009-10-13 \n",
"25 {8D54230F-726E-460C-9F30-ECAC9B714DF5} 2006-02-10 \n",
"26 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1992-06-15 \n",
"27 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"28 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2009-04-03 \n",
"29 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"30 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2009-10-12 \n",
"31 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2010-06-01 \n",
"32 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1992-04-15 \n",
"33 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2010-06-15 \n",
"34 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2010-01-27 \n",
"35 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1999-01-01 \n",
"36 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2001-08-30 \n",
"37 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2008-08-01 \n",
"38 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"39 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2013-10-01 \n",
"40 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2012-05-02 \n",
"41 {AAE7292A-8726-44A7-BA01-989E49D04A93} None \n",
"42 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2012-10-02 \n",
"43 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2008-08-01 \n",
"44 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2012-10-02 \n",
"45 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2012-03-05 \n",
"46 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1995-02-28 \n",
"47 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 1992-04-15 \n",
"48 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2000-06-15 \n",
"49 {5A96678F-8FFB-4F11-BF9D-83E6017C965C} 2005-12-28 "
]
}
],
"prompt_number": 28
}
],
"metadata": {}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment