Skip to content

Instantly share code, notes, and snippets.

@guenter

guenter/HDFS.ipynb

Last active May 21, 2018 21:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save guenter/e4fb667cf68a8ecc8c2dfa18e8b78a64 to your computer and use it in GitHub Desktop.
Save guenter/e4fb667cf68a8ecc8c2dfa18e8b78a64 to your computer and use it in GitHub Desktop.
Download ZIP
Creating Pandas data frames from various file formats stored in HDFS
Display the source blob
Display the rendered blob
Raw
HDFS.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 15,
"metadata": {},
"outputs": [],
"source": [
"from hdfs3 import HDFileSystem\n",
"import pandas as pd\n",
"# Depends on pyarrow for Parquet format\n",
"\n",
"# Looks for Hadoop xml config files in well known locations including the current directory.\n",
"hdfs = HDFileSystem()"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Read CSV\n",
"\n",
"Compression such as `zip` is automatically inferred.\n",
"\n",
"Docs: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_csv.html#pandas.read_csv"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>locationid</th>\n",
" <th>Applicant</th>\n",
" <th>FacilityType</th>\n",
" <th>cnn</th>\n",
" <th>LocationDescription</th>\n",
" <th>Address</th>\n",
" <th>blocklot</th>\n",
" <th>block</th>\n",
" <th>lot</th>\n",
" <th>permit</th>\n",
" <th>...</th>\n",
" <th>Latitude</th>\n",
" <th>Longitude</th>\n",
" <th>Schedule</th>\n",
" <th>dayshours</th>\n",
" <th>NOISent</th>\n",
" <th>Approved</th>\n",
" <th>Received</th>\n",
" <th>PriorPermit</th>\n",
" <th>ExpirationDate</th>\n",
" <th>Location</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>751253</td>\n",
" <td>Pipo's Grill</td>\n",
" <td>Truck</td>\n",
" <td>5688000</td>\n",
" <td>FOLSOM ST: 14TH ST to 15TH ST (1800 - 1899)</td>\n",
" <td>1800 FOLSOM ST</td>\n",
" <td>3549083</td>\n",
" <td>3549</td>\n",
" <td>083</td>\n",
" <td>16MFF-0010</td>\n",
" <td>...</td>\n",
" <td>37.767852</td>\n",
" <td>-122.416105</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-02-04</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7678524427181, -122.416104892532)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>519938</td>\n",
" <td>Bob Johnson</td>\n",
" <td>Truck</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>Assessors Block 0733/Lot010</td>\n",
" <td>0733010</td>\n",
" <td>0733</td>\n",
" <td>010</td>\n",
" <td>14MFF-0009</td>\n",
" <td>...</td>\n",
" <td>37.782144</td>\n",
" <td>-122.430450</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Su:10AM-7PM</td>\n",
" <td>NaN</td>\n",
" <td>02/25/2014 12:00:00 AM</td>\n",
" <td>2014-02-25</td>\n",
" <td>1</td>\n",
" <td>03/15/2015 12:00:00 AM</td>\n",
" <td>(37.782143532929, -122.430449785949)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>735318</td>\n",
" <td>Ziaurehman Amini</td>\n",
" <td>Push Cart</td>\n",
" <td>30727000</td>\n",
" <td>MARKET ST: DRUMM ST intersection</td>\n",
" <td>5 THE EMBARCADERO</td>\n",
" <td>0234017</td>\n",
" <td>0234</td>\n",
" <td>017</td>\n",
" <td>15MFF-0159</td>\n",
" <td>...</td>\n",
" <td>37.794331</td>\n",
" <td>-122.395811</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2015-12-31</td>\n",
" <td>0</td>\n",
" <td>03/15/2016 12:00:00 AM</td>\n",
" <td>(37.7943310032468, -122.395811053023)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>364218</td>\n",
" <td>The Chai Cart</td>\n",
" <td>Push Cart</td>\n",
" <td>9543000</td>\n",
" <td>NEW MONTGOMERY ST: AMBROSE BIERCE ST to MISSIO...</td>\n",
" <td>79 NEW MONTGOMERY ST</td>\n",
" <td>3707014</td>\n",
" <td>3707</td>\n",
" <td>014</td>\n",
" <td>12MFF-0083</td>\n",
" <td>...</td>\n",
" <td>37.787890</td>\n",
" <td>-122.400535</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Su:7AM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2012-04-03</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7878896999061, -122.400535326777)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>519939</td>\n",
" <td>Bob Johnson</td>\n",
" <td>Truck</td>\n",
" <td>10979000</td>\n",
" <td>REVERE AVE: 03RD ST \\ BAY VIEW ST to BRIDGEVIE...</td>\n",
" <td>1709 REVERE AVE</td>\n",
" <td>5343033</td>\n",
" <td>5343</td>\n",
" <td>033</td>\n",
" <td>14MFF-0009</td>\n",
" <td>...</td>\n",
" <td>37.732560</td>\n",
" <td>-122.392063</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Su:10AM-7PM</td>\n",
" <td>NaN</td>\n",
" <td>02/25/2014 12:00:00 AM</td>\n",
" <td>2014-02-25</td>\n",
" <td>1</td>\n",
" <td>03/15/2015 12:00:00 AM</td>\n",
" <td>(37.7325595789318, -122.392063194969)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>735315</td>\n",
" <td>Ziaurehman Amini</td>\n",
" <td>Push Cart</td>\n",
" <td>4969000</td>\n",
" <td>DRUMM ST: MARKET ST to CALIFORNIA ST (1 - 6)</td>\n",
" <td>1 CALIFORNIA ST</td>\n",
" <td>0264004</td>\n",
" <td>0264</td>\n",
" <td>004</td>\n",
" <td>15MFF-0159</td>\n",
" <td>...</td>\n",
" <td>37.793214</td>\n",
" <td>-122.397043</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2015-12-31</td>\n",
" <td>0</td>\n",
" <td>03/15/2016 12:00:00 AM</td>\n",
" <td>(37.7932137316634, -122.397043036718)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>773095</td>\n",
" <td>Athena SF Gyro</td>\n",
" <td>Push Cart</td>\n",
" <td>30747000</td>\n",
" <td>MARKET ST: 11TH ST intersection</td>\n",
" <td>10 SOUTH VAN NESS AVE</td>\n",
" <td>3506004</td>\n",
" <td>3506</td>\n",
" <td>004</td>\n",
" <td>15MFF-0145</td>\n",
" <td>...</td>\n",
" <td>37.774259</td>\n",
" <td>-122.419486</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>We/Th/Fr:6AM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2015-09-01</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.77425926306, -122.419485988398)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>773105</td>\n",
" <td>Athena SF Gyro</td>\n",
" <td>Push Cart</td>\n",
" <td>417000</td>\n",
" <td>08TH ST: BRANNAN ST to TOWNSEND ST (600 - 699)</td>\n",
" <td>699 08TH ST</td>\n",
" <td>3783009</td>\n",
" <td>3783</td>\n",
" <td>009</td>\n",
" <td>15MFF-0145</td>\n",
" <td>...</td>\n",
" <td>37.771022</td>\n",
" <td>-122.403546</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-We:6AM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2015-09-01</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7710219992437, -122.403546254184)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>848184</td>\n",
" <td>Reecees Soulicious</td>\n",
" <td>Truck</td>\n",
" <td>2799106</td>\n",
" <td>BAY SHORE BLVD: END to OAKDALE AVE (185 - 299)...</td>\n",
" <td>201 BAY SHORE BLVD</td>\n",
" <td>5559021</td>\n",
" <td>5559</td>\n",
" <td>021</td>\n",
" <td>16MFF-0139</td>\n",
" <td>...</td>\n",
" <td>37.745309</td>\n",
" <td>-122.403420</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-We:7AM-7PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-09-08</td>\n",
" <td>0</td>\n",
" <td>03/15/2017 12:00:00 AM</td>\n",
" <td>(37.7453089086563, -122.403420059999)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>848185</td>\n",
" <td>Reecees Soulicious</td>\n",
" <td>Truck</td>\n",
" <td>211101</td>\n",
" <td>03RD ST: NEWCOMB AVE to OAKDALE AVE (4701 - 47...</td>\n",
" <td>4705 03RD ST</td>\n",
" <td>5311036</td>\n",
" <td>5311</td>\n",
" <td>036</td>\n",
" <td>16MFF-0139</td>\n",
" <td>...</td>\n",
" <td>37.735004</td>\n",
" <td>-122.390172</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Th/Fr/Sa:7AM-7PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-09-08</td>\n",
" <td>0</td>\n",
" <td>03/15/2017 12:00:00 AM</td>\n",
" <td>(37.7350042289514, -122.3901724697)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>812018</td>\n",
" <td>Spice Affairs</td>\n",
" <td>Truck</td>\n",
" <td>9094000</td>\n",
" <td>MISSION ST: ANNIE ST to 03RD ST (663 - 699)</td>\n",
" <td>667 MISSION ST</td>\n",
" <td>3722067</td>\n",
" <td>3722</td>\n",
" <td>067</td>\n",
" <td>16MFF-0126</td>\n",
" <td>...</td>\n",
" <td>37.786558</td>\n",
" <td>-122.401033</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-05-31</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7865580501799, -122.40103337535)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>812017</td>\n",
" <td>Spice Affairs</td>\n",
" <td>Truck</td>\n",
" <td>12320000</td>\n",
" <td>SUTTER ST: CLAUDE LN to GRANT AVE (216 - 299)</td>\n",
" <td>290 SUTTER ST</td>\n",
" <td>0287014</td>\n",
" <td>0287</td>\n",
" <td>014</td>\n",
" <td>16MFF-0126</td>\n",
" <td>...</td>\n",
" <td>37.789914</td>\n",
" <td>-122.405233</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-05-31</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7899138671344, -122.405232892524)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>837171</td>\n",
" <td>Chilifruit</td>\n",
" <td>Push Cart</td>\n",
" <td>1346000</td>\n",
" <td>24TH ST: MISSION ST to OSAGE ALY (3300 - 3322)</td>\n",
" <td>Assessors Block /Lot</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>16MFF-0135</td>\n",
" <td>...</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-08-05</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(0, 0)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>839524</td>\n",
" <td>Halal Cart of San Francisco</td>\n",
" <td>Push Cart</td>\n",
" <td>8742101</td>\n",
" <td>MARKET ST: 01ST ST \\ BUSH ST to 02ND ST (501 -...</td>\n",
" <td>555 MARKET ST</td>\n",
" <td>3708057</td>\n",
" <td>3708</td>\n",
" <td>057</td>\n",
" <td>16MFF-0136</td>\n",
" <td>...</td>\n",
" <td>37.789890</td>\n",
" <td>-122.399930</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-08-12</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7898898782098, -122.399930411351)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>839523</td>\n",
" <td>Halal Cart of San Francisco</td>\n",
" <td>Push Cart</td>\n",
" <td>8741201</td>\n",
" <td>MARKET ST: FREMONT ST \\ FRONT ST to 01ST ST \\ ...</td>\n",
" <td>1 FRONT ST</td>\n",
" <td>0266009</td>\n",
" <td>0266</td>\n",
" <td>009</td>\n",
" <td>16MFF-0136</td>\n",
" <td>...</td>\n",
" <td>37.791757</td>\n",
" <td>-122.398898</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-08-12</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7917572059444, -122.398897636892)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>334914</td>\n",
" <td>Halal Cart, LLC</td>\n",
" <td>Push Cart</td>\n",
" <td>8748101</td>\n",
" <td>MARKET ST: 05TH ST \\ CYRIL MAGNIN ST to MASON ...</td>\n",
" <td>901 MARKET ST</td>\n",
" <td>3704001</td>\n",
" <td>3704</td>\n",
" <td>001</td>\n",
" <td>11MFF-0175</td>\n",
" <td>...</td>\n",
" <td>37.783470</td>\n",
" <td>-122.408041</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Sa-Su:12AM-3AM;Mo-Su:10AM-8PM;Fr/Sa:9PM-12AM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2011-09-26</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7834700660829, -122.408040736138)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>916855</td>\n",
" <td>Los 2 Cuates</td>\n",
" <td>Truck</td>\n",
" <td>141000</td>\n",
" <td>02ND ST: STILLMAN ST to BRYANT ST (454 - 499)</td>\n",
" <td>490 02ND ST</td>\n",
" <td>3763007</td>\n",
" <td>3763</td>\n",
" <td>007</td>\n",
" <td>16MFF-0137</td>\n",
" <td>...</td>\n",
" <td>37.783046</td>\n",
" <td>-122.394067</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Tu/We/Th:7AM-8PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-08-12</td>\n",
" <td>0</td>\n",
" <td>08/12/2016 12:00:00 AM</td>\n",
" <td>(37.78304609975, -122.39406659923)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>931094</td>\n",
" <td>Swell Cream &amp; Coffee</td>\n",
" <td>Truck</td>\n",
" <td>12410000</td>\n",
" <td>TARAVAL ST: 34TH AVE to 35TH AVE (2400 - 2499)</td>\n",
" <td>2450 TARAVAL ST</td>\n",
" <td>2363022</td>\n",
" <td>2363</td>\n",
" <td>022</td>\n",
" <td>17MFF-0002</td>\n",
" <td>...</td>\n",
" <td>37.742550</td>\n",
" <td>-122.492677</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-01-30</td>\n",
" <td>0</td>\n",
" <td>01/30/2018 12:00:00 AM</td>\n",
" <td>(37.7425503735592, -122.492677082215)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>931093</td>\n",
" <td>Swell Cream &amp; Coffee</td>\n",
" <td>Truck</td>\n",
" <td>12412000</td>\n",
" <td>TARAVAL ST: 36TH AVE to SUNSET BLVD (2600 - 2649)</td>\n",
" <td>2401 36TH AVE</td>\n",
" <td>2389001</td>\n",
" <td>2389</td>\n",
" <td>001</td>\n",
" <td>17MFF-0002</td>\n",
" <td>...</td>\n",
" <td>37.741290</td>\n",
" <td>-122.494378</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-01-30</td>\n",
" <td>0</td>\n",
" <td>01/30/2018 12:00:00 AM</td>\n",
" <td>(37.7412902847707, -122.494377920435)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>934561</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>9083000</td>\n",
" <td>MISSION ST: STEUART ST to SPEAR ST (35 - 99)</td>\n",
" <td>98 MISSION ST</td>\n",
" <td>3713007</td>\n",
" <td>3713</td>\n",
" <td>007</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.793371</td>\n",
" <td>-122.394233</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:7AM-9AM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7933707169278, -122.394233280448)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>755221</td>\n",
" <td>Fruteria Serrano</td>\n",
" <td>NaN</td>\n",
" <td>9167000</td>\n",
" <td>MISSION ST: OCEAN AVE to PERSIA AVE (4650 - 4699)</td>\n",
" <td>4650 MISSION ST</td>\n",
" <td>6955044</td>\n",
" <td>6955</td>\n",
" <td>044</td>\n",
" <td>16MFF-0011</td>\n",
" <td>...</td>\n",
" <td>37.723661</td>\n",
" <td>-122.435944</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Th/Fr:11AM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2016-02-17</td>\n",
" <td>0</td>\n",
" <td>03/15/2017 12:00:00 AM</td>\n",
" <td>(37.7236612795053, -122.43594382524)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>934565</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>7173000</td>\n",
" <td>ILLINOIS ST: 24TH ST to 25TH ST (1400 - 1499)</td>\n",
" <td>1499 ILLINOIS ST</td>\n",
" <td>4244002</td>\n",
" <td>4244</td>\n",
" <td>002</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.753040</td>\n",
" <td>-122.386632</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:5PM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7530403201943, -122.386631763538)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>988643</td>\n",
" <td>Cochinita</td>\n",
" <td>Truck</td>\n",
" <td>1329000</td>\n",
" <td>24TH ST: UTAH ST to POTRERO AVE (2600 - 2699)</td>\n",
" <td>2601 24TH ST</td>\n",
" <td>4264001</td>\n",
" <td>4264</td>\n",
" <td>001</td>\n",
" <td>17MFF-0186</td>\n",
" <td>...</td>\n",
" <td>37.752822</td>\n",
" <td>-122.405532</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Tu/Sa:11AM-5PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-06-19</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7528223681215, -122.405531919216)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>934569</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>716000</td>\n",
" <td>16TH ST: HAMPSHIRE ST to BRYANT ST (2200 - 2399)</td>\n",
" <td>Assessors Block 3930A/Lot002</td>\n",
" <td>3930A002</td>\n",
" <td>3930A</td>\n",
" <td>002</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.766511</td>\n",
" <td>-122.409260</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:7PM-8PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7665109269083, -122.40926014493)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>934570</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>7037000</td>\n",
" <td>HOWARD ST: HAWTHORNE ST to 03RD ST (648 - 699)</td>\n",
" <td>661 HOWARD ST</td>\n",
" <td>3735040</td>\n",
" <td>3735</td>\n",
" <td>040</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.785346</td>\n",
" <td>-122.399455</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:8PM-9PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7853456766418, -122.399455276698)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>934568</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>6603000</td>\n",
" <td>HAIGHT ST: GOUGH ST to OCTAVIA ST (20 - 99)</td>\n",
" <td>20 HAIGHT ST</td>\n",
" <td>0853023</td>\n",
" <td>0853</td>\n",
" <td>023</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.773341</td>\n",
" <td>-122.422806</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:6PM-8PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7733408773453, -122.422806203983)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>934562</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>2110000</td>\n",
" <td>ALABAMA ST: 17TH ST to MARIPOSA ST (400 - 499)</td>\n",
" <td>400 ALABAMA ST</td>\n",
" <td>3968001</td>\n",
" <td>3968</td>\n",
" <td>001</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.763807</td>\n",
" <td>-122.412611</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:7AM-8AM/9AM-10AM/12PM-1PM/8PM-9PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7638066535277, -122.412610953897)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>934564</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>3144000</td>\n",
" <td>BROADWAY: FRONT ST to BATTERY ST (100 - 199)</td>\n",
" <td>100 BROADWAY</td>\n",
" <td>0141003B</td>\n",
" <td>0141</td>\n",
" <td>003B</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.798864</td>\n",
" <td>-122.400264</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:10AM-11AM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7988640669494, -122.400263583781)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>934362</td>\n",
" <td>Mob Dog</td>\n",
" <td>Push Cart</td>\n",
" <td>8745201</td>\n",
" <td>MARKET ST: 03RD ST \\ KEARNY ST to GRANT AVE \\ ...</td>\n",
" <td>720 MARKET ST</td>\n",
" <td>0312004</td>\n",
" <td>0312</td>\n",
" <td>004</td>\n",
" <td>17MFF-0068</td>\n",
" <td>...</td>\n",
" <td>37.787598</td>\n",
" <td>-122.404090</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Th/Fr/Sa:8AM-10PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>0</td>\n",
" <td>05/06/2018 12:00:00 AM</td>\n",
" <td>(37.7875984155546, -122.404090439434)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>934560</td>\n",
" <td>M M Catering</td>\n",
" <td>Truck</td>\n",
" <td>9206000</td>\n",
" <td>MISSISSIPPI ST: END to CESAR CHAVEZ ST (1200 -...</td>\n",
" <td>1200 MISSISSIPPI ST</td>\n",
" <td>4288003</td>\n",
" <td>4288</td>\n",
" <td>003</td>\n",
" <td>17MFF-0109</td>\n",
" <td>...</td>\n",
" <td>37.751691</td>\n",
" <td>-122.394374</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Tu/We/Th/Fr:12AM-5AM;Sa:2PM-6PM;Mo-Fr:3PM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2017-02-13</td>\n",
" <td>1</td>\n",
" <td>03/31/2018 12:00:00 AM</td>\n",
" <td>(37.7516910357229, -122.394374213263)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>586</th>\n",
" <td>1147773</td>\n",
" <td>Think is Good Inc.</td>\n",
" <td>Truck</td>\n",
" <td>10454000</td>\n",
" <td>PINE ST: FRONT ST to BATTERY ST (100 - 199)</td>\n",
" <td>100 PINE ST</td>\n",
" <td>0262020</td>\n",
" <td>0262</td>\n",
" <td>020</td>\n",
" <td>18MFF-0020</td>\n",
" <td>...</td>\n",
" <td>37.792641</td>\n",
" <td>-122.398970</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/We/Fr:10AM-3PM</td>\n",
" <td>NaN</td>\n",
" <td>04/25/2018 12:00:00 AM</td>\n",
" <td>2018-04-19</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7926407167337, -122.398970332111)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>587</th>\n",
" <td>1147775</td>\n",
" <td>Think is Good Inc.</td>\n",
" <td>Truck</td>\n",
" <td>3528000</td>\n",
" <td>CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (4...</td>\n",
" <td>430 CALIFORNIA ST</td>\n",
" <td>0239029</td>\n",
" <td>0239</td>\n",
" <td>029</td>\n",
" <td>18MFF-0020</td>\n",
" <td>...</td>\n",
" <td>37.793262</td>\n",
" <td>-122.401789</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/We/Fr:10AM-3PM</td>\n",
" <td>NaN</td>\n",
" <td>04/25/2018 12:00:00 AM</td>\n",
" <td>2018-04-19</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7932622069231, -122.401789091363)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>588</th>\n",
" <td>975273</td>\n",
" <td>Akuranvyka USA Inc</td>\n",
" <td>Truck</td>\n",
" <td>179000</td>\n",
" <td>03RD ST: BRANNAN ST to TOWNSEND ST (600 - 699)</td>\n",
" <td>601 03RD ST</td>\n",
" <td>3788020</td>\n",
" <td>3788</td>\n",
" <td>020</td>\n",
" <td>17MFF-0185</td>\n",
" <td>...</td>\n",
" <td>37.780077</td>\n",
" <td>-122.393767</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Tu/Th/Fr:12PM-1PM</td>\n",
" <td>NaN</td>\n",
" <td>03/01/2018 12:00:00 AM</td>\n",
" <td>2017-05-10</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7800771744392, -122.393767294483)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>589</th>\n",
" <td>1009768</td>\n",
" <td>Akuranvyka USA Inc</td>\n",
" <td>Truck</td>\n",
" <td>11553000</td>\n",
" <td>SANSOME ST: GOLD ST to PACIFIC AVE (705 - 799)</td>\n",
" <td>727 SANSOME ST</td>\n",
" <td>0175003</td>\n",
" <td>0175</td>\n",
" <td>003</td>\n",
" <td>17MFF-0185</td>\n",
" <td>...</td>\n",
" <td>37.796949</td>\n",
" <td>-122.402183</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Tu/Th:12PM-1PM</td>\n",
" <td>NaN</td>\n",
" <td>03/01/2018 12:00:00 AM</td>\n",
" <td>2017-05-10</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7969490060212, -122.402183431894)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>590</th>\n",
" <td>1152907</td>\n",
" <td>SPUNBYSS</td>\n",
" <td>Truck</td>\n",
" <td>9086000</td>\n",
" <td>MISSION ST: BEALE ST to FREMONT ST (300 - 399)</td>\n",
" <td>350 MISSION ST</td>\n",
" <td>3710017</td>\n",
" <td>3710</td>\n",
" <td>017</td>\n",
" <td>18MFF-0021</td>\n",
" <td>...</td>\n",
" <td>37.790885</td>\n",
" <td>-122.396686</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Mo/We/We:10AM-2PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2018-04-30</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7908854635019, -122.396685875811)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>591</th>\n",
" <td>1153604</td>\n",
" <td>SPUNBYSS</td>\n",
" <td>Truck</td>\n",
" <td>136000</td>\n",
" <td>02ND ST: TEHAMA ST to CLEMENTINA ST (224 - 273)</td>\n",
" <td>240 02ND ST</td>\n",
" <td>3735055</td>\n",
" <td>3735</td>\n",
" <td>055</td>\n",
" <td>18MFF-0021</td>\n",
" <td>...</td>\n",
" <td>37.785940</td>\n",
" <td>-122.397800</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2018-04-30</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>(37.7859403201734, -122.397799933858)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>592</th>\n",
" <td>1013320</td>\n",
" <td>Wu Wei LLC dba MoBowl</td>\n",
" <td>Truck</td>\n",
" <td>7033000</td>\n",
" <td>HOWARD ST: 01ST ST to MALDEN ALY (500 - 589)</td>\n",
" <td>500 HOWARD ST</td>\n",
" <td>3721011</td>\n",
" <td>3721</td>\n",
" <td>011</td>\n",
" <td>17MFF-0191</td>\n",
" <td>...</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Fr:10AM-2PM</td>\n",
" <td>NaN</td>\n",
" <td>05/04/2018 12:00:00 AM</td>\n",
" <td>2017-08-31</td>\n",
" <td>1</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(0, 0)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>593</th>\n",
" <td>1013322</td>\n",
" <td>Wu Wei LLC dba MoBowl</td>\n",
" <td>Truck</td>\n",
" <td>12160001</td>\n",
" <td>STEUART ST: HOWARD ST to END (200 - 299)</td>\n",
" <td>75 HOWARD ST</td>\n",
" <td>3741031</td>\n",
" <td>3741</td>\n",
" <td>031</td>\n",
" <td>17MFF-0191</td>\n",
" <td>...</td>\n",
" <td>37.791558</td>\n",
" <td>-122.391671</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/We:10AM-3PM</td>\n",
" <td>NaN</td>\n",
" <td>05/04/2018 12:00:00 AM</td>\n",
" <td>2017-08-31</td>\n",
" <td>1</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7915578641549, -122.391671499786)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>594</th>\n",
" <td>1013324</td>\n",
" <td>Wu Wei LLC dba MoBowl</td>\n",
" <td>Truck</td>\n",
" <td>4972000</td>\n",
" <td>DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299)</td>\n",
" <td>253 DRUMM ST</td>\n",
" <td>0203013</td>\n",
" <td>0203</td>\n",
" <td>013</td>\n",
" <td>17MFF-0191</td>\n",
" <td>...</td>\n",
" <td>37.796123</td>\n",
" <td>-122.397273</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Tu/Th:10AM-3PM</td>\n",
" <td>NaN</td>\n",
" <td>05/04/2018 12:00:00 AM</td>\n",
" <td>2017-08-31</td>\n",
" <td>1</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7961233802521, -122.397273204338)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>595</th>\n",
" <td>1153282</td>\n",
" <td>Wu Wei LLC dba MoBowl</td>\n",
" <td>Truck</td>\n",
" <td>5875000</td>\n",
" <td>FRONT ST: VALLEJO ST to GREEN ST (900 - 999)</td>\n",
" <td>900 FRONT ST</td>\n",
" <td>0137001</td>\n",
" <td>0137</td>\n",
" <td>001</td>\n",
" <td>17MFF-0191</td>\n",
" <td>...</td>\n",
" <td>37.800221</td>\n",
" <td>-122.399569</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Fr:10AM-3PM</td>\n",
" <td>NaN</td>\n",
" <td>05/04/2018 12:00:00 AM</td>\n",
" <td>2017-08-31</td>\n",
" <td>1</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.8002209155922, -122.399569018577)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>596</th>\n",
" <td>1013323</td>\n",
" <td>Wu Wei LLC dba MoBowl</td>\n",
" <td>Truck</td>\n",
" <td>13403000</td>\n",
" <td>WASHINGTON ST: THE EMBARCADERO to DRUMM ST (1 ...</td>\n",
" <td>370 DRUMM ST</td>\n",
" <td>0201012</td>\n",
" <td>0201</td>\n",
" <td>012</td>\n",
" <td>17MFF-0191</td>\n",
" <td>...</td>\n",
" <td>37.796914</td>\n",
" <td>-122.396651</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Su:10AM-11PM</td>\n",
" <td>NaN</td>\n",
" <td>05/04/2018 12:00:00 AM</td>\n",
" <td>2017-08-31</td>\n",
" <td>1</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7969137124835, -122.396650675264)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>597</th>\n",
" <td>1152244</td>\n",
" <td>San Francisco's Hometown Creamery</td>\n",
" <td>Truck</td>\n",
" <td>6109000</td>\n",
" <td>GEARY ST: STOCKTON ST to POWELL ST (200 - 299)</td>\n",
" <td>281 GEARY ST</td>\n",
" <td>0314013</td>\n",
" <td>0314</td>\n",
" <td>013</td>\n",
" <td>17MFF-0001</td>\n",
" <td>...</td>\n",
" <td>37.787136</td>\n",
" <td>-122.407719</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Su:11AM-11PM;Fr/Sa:6PM-11PM</td>\n",
" <td>NaN</td>\n",
" <td>04/27/2018 12:00:00 AM</td>\n",
" <td>2017-01-09</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7871364910861, -122.407718509001)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>598</th>\n",
" <td>1151023</td>\n",
" <td>Tacos Rodriguez</td>\n",
" <td>Truck</td>\n",
" <td>8958000</td>\n",
" <td>MENDELL ST: GALVEZ AVE to HUDSON AVE (600 - 699)</td>\n",
" <td>600 MENDELL ST</td>\n",
" <td>5254037</td>\n",
" <td>5254</td>\n",
" <td>037</td>\n",
" <td>18MFF-0019</td>\n",
" <td>...</td>\n",
" <td>37.739679</td>\n",
" <td>-122.386493</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Su/Fr/Sa:8AM-6PM</td>\n",
" <td>05/15/2018 12:00:00 AM</td>\n",
" <td>NaN</td>\n",
" <td>2018-04-18</td>\n",
" <td>1</td>\n",
" <td>03/15/2019 12:00:00 AM</td>\n",
" <td>(37.7396787918079, -122.386493384555)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>599</th>\n",
" <td>1157329</td>\n",
" <td>Senor Sisig</td>\n",
" <td>Truck</td>\n",
" <td>3143000</td>\n",
" <td>BROADWAY: DAVIS ST to FRONT ST (50 - 99)</td>\n",
" <td>90 BROADWAY</td>\n",
" <td>0140007</td>\n",
" <td>0140</td>\n",
" <td>007</td>\n",
" <td>18MFF-0023</td>\n",
" <td>...</td>\n",
" <td>37.799260</td>\n",
" <td>-122.399618</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Tu/Th:10AM-3PM</td>\n",
" <td>NaN</td>\n",
" <td>05/14/2018 12:00:00 AM</td>\n",
" <td>2018-05-10</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7992601135023, -122.399617948655)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>600</th>\n",
" <td>1157313</td>\n",
" <td>Senor Sisig</td>\n",
" <td>Truck</td>\n",
" <td>132000</td>\n",
" <td>02ND ST: MISSION ST to MINNA ST (100 - 130)</td>\n",
" <td>120 02ND ST</td>\n",
" <td>3722002</td>\n",
" <td>3722</td>\n",
" <td>002</td>\n",
" <td>18MFF-0022</td>\n",
" <td>...</td>\n",
" <td>37.787514</td>\n",
" <td>-122.399566</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:11AM-2PM</td>\n",
" <td>NaN</td>\n",
" <td>05/14/2018 12:00:00 AM</td>\n",
" <td>2018-05-10</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7875140607381, -122.399566331429)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>601</th>\n",
" <td>1147370</td>\n",
" <td>Tacos Rodriguez</td>\n",
" <td>Truck</td>\n",
" <td>9794000</td>\n",
" <td>OAKDALE AVE: INDUSTRIAL ST \\ SELBY ST to TOLAN...</td>\n",
" <td>2198 OAKDALE AVE</td>\n",
" <td>5590A008</td>\n",
" <td>5590A</td>\n",
" <td>008</td>\n",
" <td>18MFF-0019</td>\n",
" <td>...</td>\n",
" <td>37.740995</td>\n",
" <td>-122.401172</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:8AM-5PM</td>\n",
" <td>05/15/2018 12:00:00 AM</td>\n",
" <td>NaN</td>\n",
" <td>2018-04-18</td>\n",
" <td>1</td>\n",
" <td>03/15/2019 12:00:00 AM</td>\n",
" <td>(37.7409947350024, -122.401172335386)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>602</th>\n",
" <td>1024464</td>\n",
" <td>Senor Sisig</td>\n",
" <td>Truck</td>\n",
" <td>3525000</td>\n",
" <td>CALIFORNIA ST: DAVIS ST to FRONT ST (100 - 199)</td>\n",
" <td>101 CALIFORNIA ST</td>\n",
" <td>0263011</td>\n",
" <td>0263</td>\n",
" <td>011</td>\n",
" <td>16MFF-0143</td>\n",
" <td>...</td>\n",
" <td>37.792949</td>\n",
" <td>-122.398099</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/We/Fr:10AM-3PM</td>\n",
" <td>09/15/2017 12:00:00 AM</td>\n",
" <td>05/14/2018 12:00:00 AM</td>\n",
" <td>2016-12-02</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7929489528347, -122.398098613167)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>603</th>\n",
" <td>1161222</td>\n",
" <td>Senor Sisig</td>\n",
" <td>Truck</td>\n",
" <td>10456000</td>\n",
" <td>PINE ST: SANSOME ST to CENTURY PL (300 - 340)</td>\n",
" <td>300 PINE ST</td>\n",
" <td>0260005</td>\n",
" <td>0260</td>\n",
" <td>005</td>\n",
" <td>18MFF-0025</td>\n",
" <td>...</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:11AM-2PM</td>\n",
" <td>NaN</td>\n",
" <td>05/14/2018 12:00:00 AM</td>\n",
" <td>2018-05-14</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(0, 0)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>604</th>\n",
" <td>1147371</td>\n",
" <td>Tacos Rodriguez</td>\n",
" <td>Truck</td>\n",
" <td>5331101</td>\n",
" <td>EVANS AVE: KEITH ST to MENDELL ST (1201 - 1399...</td>\n",
" <td>1275 EVANS AVE</td>\n",
" <td>5237033</td>\n",
" <td>5237</td>\n",
" <td>033</td>\n",
" <td>18MFF-0019</td>\n",
" <td>...</td>\n",
" <td>37.739111</td>\n",
" <td>-122.382465</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Su:8AM-8PM</td>\n",
" <td>05/15/2018 12:00:00 AM</td>\n",
" <td>NaN</td>\n",
" <td>2018-04-18</td>\n",
" <td>1</td>\n",
" <td>03/15/2019 12:00:00 AM</td>\n",
" <td>(37.739111429745, -122.382464971136)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>605</th>\n",
" <td>1157312</td>\n",
" <td>Senor Sisig</td>\n",
" <td>Truck</td>\n",
" <td>5170000</td>\n",
" <td>ELLIS ST: POWELL ST to CYRIL MAGNIN ST (100 - ...</td>\n",
" <td>120 ELLIS ST</td>\n",
" <td>0326005</td>\n",
" <td>0326</td>\n",
" <td>005</td>\n",
" <td>18MFF-0022</td>\n",
" <td>...</td>\n",
" <td>37.785610</td>\n",
" <td>-122.408155</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Sa-Su:11AM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>05/14/2018 12:00:00 AM</td>\n",
" <td>2018-05-10</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7856100863691, -122.408154764345)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>606</th>\n",
" <td>1157328</td>\n",
" <td>Senor Sisig</td>\n",
" <td>Truck</td>\n",
" <td>480000</td>\n",
" <td>10TH ST: FELL ST \\ MARKET ST \\ POLK ST to END ...</td>\n",
" <td>8 10TH ST</td>\n",
" <td>3507041</td>\n",
" <td>3507</td>\n",
" <td>041</td>\n",
" <td>18MFF-0023</td>\n",
" <td>...</td>\n",
" <td>37.775826</td>\n",
" <td>-122.417250</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/We/Fr:11AM-2PM</td>\n",
" <td>NaN</td>\n",
" <td>05/14/2018 12:00:00 AM</td>\n",
" <td>2018-05-10</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7758255197583, -122.417249626643)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>607</th>\n",
" <td>955731</td>\n",
" <td>Senor Sisig</td>\n",
" <td>Truck</td>\n",
" <td>9097000</td>\n",
" <td>MISSION ST: 05TH ST to MINT ST (900 - 930)</td>\n",
" <td>901 MISSION ST</td>\n",
" <td>3725093</td>\n",
" <td>3725</td>\n",
" <td>093</td>\n",
" <td>16MFF-0143</td>\n",
" <td>...</td>\n",
" <td>37.782154</td>\n",
" <td>-122.406601</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Tu/Th:10AM-3PM</td>\n",
" <td>09/15/2017 12:00:00 AM</td>\n",
" <td>05/14/2018 12:00:00 AM</td>\n",
" <td>2016-12-02</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7821536409986, -122.406601106839)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>608</th>\n",
" <td>1147369</td>\n",
" <td>Tacos Rodriguez</td>\n",
" <td>Truck</td>\n",
" <td>11542000</td>\n",
" <td>SANSOME ST: SUTTER ST to BUSH ST (1 - 99)</td>\n",
" <td>1 SANSOME ST</td>\n",
" <td>0289003</td>\n",
" <td>0289</td>\n",
" <td>003</td>\n",
" <td>18MFF-0019</td>\n",
" <td>...</td>\n",
" <td>37.790485</td>\n",
" <td>-122.400940</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo-Fr:11AM-3PM</td>\n",
" <td>05/15/2018 12:00:00 AM</td>\n",
" <td>NaN</td>\n",
" <td>2018-04-18</td>\n",
" <td>1</td>\n",
" <td>03/15/2019 12:00:00 AM</td>\n",
" <td>(37.790485146128, -122.40094044069)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>609</th>\n",
" <td>1162115</td>\n",
" <td>Giant Burrito</td>\n",
" <td>Truck</td>\n",
" <td>6148201</td>\n",
" <td>GENEVA AVE: PRAGUE ST to LINDA VISTA STPS (150...</td>\n",
" <td>1500 GENEVA AVE</td>\n",
" <td>6418065</td>\n",
" <td>6418</td>\n",
" <td>065</td>\n",
" <td>18MFF-0026</td>\n",
" <td>...</td>\n",
" <td>37.712303</td>\n",
" <td>-122.431644</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Su:7AM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>05/15/2018 12:00:00 AM</td>\n",
" <td>2018-05-15</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7123026047444, -122.431644190373)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>610</th>\n",
" <td>1162114</td>\n",
" <td>Giant Burrito</td>\n",
" <td>Truck</td>\n",
" <td>2800102</td>\n",
" <td>BAY SHORE BLVD: FLOWER ST to CORTLAND AVE (341...</td>\n",
" <td>353 BAY SHORE BLVD</td>\n",
" <td>5598030</td>\n",
" <td>5598</td>\n",
" <td>030</td>\n",
" <td>18MFF-0026</td>\n",
" <td>...</td>\n",
" <td>37.741718</td>\n",
" <td>-122.405418</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Tu/We/Th/Fr:7AM-6PM</td>\n",
" <td>NaN</td>\n",
" <td>05/15/2018 12:00:00 AM</td>\n",
" <td>2018-05-15</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7417178307439, -122.405417977448)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>611</th>\n",
" <td>1163405</td>\n",
" <td>Julie's Hot Dogs</td>\n",
" <td>Truck</td>\n",
" <td>9121000</td>\n",
" <td>MISSION ST: 19TH ST to 20TH ST (2300 - 2399)</td>\n",
" <td>2365 MISSION ST</td>\n",
" <td>3595024</td>\n",
" <td>3595</td>\n",
" <td>024</td>\n",
" <td>17MFF-0190</td>\n",
" <td>...</td>\n",
" <td>37.759240</td>\n",
" <td>-122.418544</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Su/Fr/Sa:12AM-3AM;Th/Fr/Sa:10PM-12AM</td>\n",
" <td>NaN</td>\n",
" <td>05/17/2018 12:00:00 AM</td>\n",
" <td>2017-08-24</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7592402851502, -122.418544171117)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>612</th>\n",
" <td>1009866</td>\n",
" <td>Golden Gate Halal Food</td>\n",
" <td>Push Cart</td>\n",
" <td>4969000</td>\n",
" <td>DRUMM ST: MARKET ST to CALIFORNIA ST (1 - 6)</td>\n",
" <td>1 DRUMM ST</td>\n",
" <td>0264004</td>\n",
" <td>0264</td>\n",
" <td>004</td>\n",
" <td>16MFF-0094</td>\n",
" <td>...</td>\n",
" <td>37.793214</td>\n",
" <td>-122.397043</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/We/Fr:8AM-8PM</td>\n",
" <td>NaN</td>\n",
" <td>05/18/2018 12:00:00 AM</td>\n",
" <td>2016-04-18</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7932137316634, -122.397043036718)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>613</th>\n",
" <td>1009867</td>\n",
" <td>Golden Gate Halal Food</td>\n",
" <td>Push Cart</td>\n",
" <td>8749101</td>\n",
" <td>MARKET ST: MASON ST \\ TURK ST to 06TH ST \\ GOL...</td>\n",
" <td>979 MARKET ST</td>\n",
" <td>3704068</td>\n",
" <td>3704</td>\n",
" <td>068</td>\n",
" <td>16MFF-0094</td>\n",
" <td>...</td>\n",
" <td>37.782281</td>\n",
" <td>-122.409531</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>Mo/Tu/Th:8AM-8PM</td>\n",
" <td>NaN</td>\n",
" <td>05/18/2018 12:00:00 AM</td>\n",
" <td>2016-04-18</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(37.7822807724186, -122.40953118732)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>614</th>\n",
" <td>1163581</td>\n",
" <td>LA COCINA</td>\n",
" <td>Truck</td>\n",
" <td>8750201</td>\n",
" <td>MARKET ST: 06TH ST \\ GOLDEN GATE AVE \\ TAYLOR ...</td>\n",
" <td>1028 MARKET ST</td>\n",
" <td>0350002</td>\n",
" <td>0350</td>\n",
" <td>002</td>\n",
" <td>18MFF-0027</td>\n",
" <td>...</td>\n",
" <td>37.781883</td>\n",
" <td>-122.411323</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>We/Th/Fr:11AM-3PM</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>2018-05-16</td>\n",
" <td>0</td>\n",
" <td>07/11/2019 12:00:00 AM</td>\n",
" <td>(37.7818834680896, -122.411323335782)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>615</th>\n",
" <td>1012444</td>\n",
" <td>Golden Gate Halal Food</td>\n",
" <td>Push Cart</td>\n",
" <td>8751101</td>\n",
" <td>MARKET ST: 07TH ST \\ CHARLES J BRENHAM PL to 0...</td>\n",
" <td>1169 MARKET ST</td>\n",
" <td>3702051</td>\n",
" <td>3702</td>\n",
" <td>051</td>\n",
" <td>16MFF-0094</td>\n",
" <td>...</td>\n",
" <td>0.000000</td>\n",
" <td>0.000000</td>\n",
" <td>http://bsm.sfdpw.org/PermitsTracker/reports/re...</td>\n",
" <td>We/Fr/Sa:8AM-8PM</td>\n",
" <td>NaN</td>\n",
" <td>05/18/2018 12:00:00 AM</td>\n",
" <td>2016-04-18</td>\n",
" <td>0</td>\n",
" <td>07/15/2019 12:00:00 AM</td>\n",
" <td>(0, 0)</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>616 rows × 24 columns</p>\n",
"</div>"
],
"text/plain": [
" locationid Applicant FacilityType cnn \\\n",
"0 751253 Pipo's Grill Truck 5688000 \n",
"1 519938 Bob Johnson Truck 0 \n",
"2 735318 Ziaurehman Amini Push Cart 30727000 \n",
"3 364218 The Chai Cart Push Cart 9543000 \n",
"4 519939 Bob Johnson Truck 10979000 \n",
"5 735315 Ziaurehman Amini Push Cart 4969000 \n",
"6 773095 Athena SF Gyro Push Cart 30747000 \n",
"7 773105 Athena SF Gyro Push Cart 417000 \n",
"8 848184 Reecees Soulicious Truck 2799106 \n",
"9 848185 Reecees Soulicious Truck 211101 \n",
"10 812018 Spice Affairs Truck 9094000 \n",
"11 812017 Spice Affairs Truck 12320000 \n",
"12 837171 Chilifruit Push Cart 1346000 \n",
"13 839524 Halal Cart of San Francisco Push Cart 8742101 \n",
"14 839523 Halal Cart of San Francisco Push Cart 8741201 \n",
"15 334914 Halal Cart, LLC Push Cart 8748101 \n",
"16 916855 Los 2 Cuates Truck 141000 \n",
"17 931094 Swell Cream & Coffee Truck 12410000 \n",
"18 931093 Swell Cream & Coffee Truck 12412000 \n",
"19 934561 M M Catering Truck 9083000 \n",
"20 755221 Fruteria Serrano NaN 9167000 \n",
"21 934565 M M Catering Truck 7173000 \n",
"22 988643 Cochinita Truck 1329000 \n",
"23 934569 M M Catering Truck 716000 \n",
"24 934570 M M Catering Truck 7037000 \n",
"25 934568 M M Catering Truck 6603000 \n",
"26 934562 M M Catering Truck 2110000 \n",
"27 934564 M M Catering Truck 3144000 \n",
"28 934362 Mob Dog Push Cart 8745201 \n",
"29 934560 M M Catering Truck 9206000 \n",
".. ... ... ... ... \n",
"586 1147773 Think is Good Inc. Truck 10454000 \n",
"587 1147775 Think is Good Inc. Truck 3528000 \n",
"588 975273 Akuranvyka USA Inc Truck 179000 \n",
"589 1009768 Akuranvyka USA Inc Truck 11553000 \n",
"590 1152907 SPUNBYSS Truck 9086000 \n",
"591 1153604 SPUNBYSS Truck 136000 \n",
"592 1013320 Wu Wei LLC dba MoBowl Truck 7033000 \n",
"593 1013322 Wu Wei LLC dba MoBowl Truck 12160001 \n",
"594 1013324 Wu Wei LLC dba MoBowl Truck 4972000 \n",
"595 1153282 Wu Wei LLC dba MoBowl Truck 5875000 \n",
"596 1013323 Wu Wei LLC dba MoBowl Truck 13403000 \n",
"597 1152244 San Francisco's Hometown Creamery Truck 6109000 \n",
"598 1151023 Tacos Rodriguez Truck 8958000 \n",
"599 1157329 Senor Sisig Truck 3143000 \n",
"600 1157313 Senor Sisig Truck 132000 \n",
"601 1147370 Tacos Rodriguez Truck 9794000 \n",
"602 1024464 Senor Sisig Truck 3525000 \n",
"603 1161222 Senor Sisig Truck 10456000 \n",
"604 1147371 Tacos Rodriguez Truck 5331101 \n",
"605 1157312 Senor Sisig Truck 5170000 \n",
"606 1157328 Senor Sisig Truck 480000 \n",
"607 955731 Senor Sisig Truck 9097000 \n",
"608 1147369 Tacos Rodriguez Truck 11542000 \n",
"609 1162115 Giant Burrito Truck 6148201 \n",
"610 1162114 Giant Burrito Truck 2800102 \n",
"611 1163405 Julie's Hot Dogs Truck 9121000 \n",
"612 1009866 Golden Gate Halal Food Push Cart 4969000 \n",
"613 1009867 Golden Gate Halal Food Push Cart 8749101 \n",
"614 1163581 LA COCINA Truck 8750201 \n",
"615 1012444 Golden Gate Halal Food Push Cart 8751101 \n",
"\n",
" LocationDescription \\\n",
"0 FOLSOM ST: 14TH ST to 15TH ST (1800 - 1899) \n",
"1 NaN \n",
"2 MARKET ST: DRUMM ST intersection \n",
"3 NEW MONTGOMERY ST: AMBROSE BIERCE ST to MISSIO... \n",
"4 REVERE AVE: 03RD ST \\ BAY VIEW ST to BRIDGEVIE... \n",
"5 DRUMM ST: MARKET ST to CALIFORNIA ST (1 - 6) \n",
"6 MARKET ST: 11TH ST intersection \n",
"7 08TH ST: BRANNAN ST to TOWNSEND ST (600 - 699) \n",
"8 BAY SHORE BLVD: END to OAKDALE AVE (185 - 299)... \n",
"9 03RD ST: NEWCOMB AVE to OAKDALE AVE (4701 - 47... \n",
"10 MISSION ST: ANNIE ST to 03RD ST (663 - 699) \n",
"11 SUTTER ST: CLAUDE LN to GRANT AVE (216 - 299) \n",
"12 24TH ST: MISSION ST to OSAGE ALY (3300 - 3322) \n",
"13 MARKET ST: 01ST ST \\ BUSH ST to 02ND ST (501 -... \n",
"14 MARKET ST: FREMONT ST \\ FRONT ST to 01ST ST \\ ... \n",
"15 MARKET ST: 05TH ST \\ CYRIL MAGNIN ST to MASON ... \n",
"16 02ND ST: STILLMAN ST to BRYANT ST (454 - 499) \n",
"17 TARAVAL ST: 34TH AVE to 35TH AVE (2400 - 2499) \n",
"18 TARAVAL ST: 36TH AVE to SUNSET BLVD (2600 - 2649) \n",
"19 MISSION ST: STEUART ST to SPEAR ST (35 - 99) \n",
"20 MISSION ST: OCEAN AVE to PERSIA AVE (4650 - 4699) \n",
"21 ILLINOIS ST: 24TH ST to 25TH ST (1400 - 1499) \n",
"22 24TH ST: UTAH ST to POTRERO AVE (2600 - 2699) \n",
"23 16TH ST: HAMPSHIRE ST to BRYANT ST (2200 - 2399) \n",
"24 HOWARD ST: HAWTHORNE ST to 03RD ST (648 - 699) \n",
"25 HAIGHT ST: GOUGH ST to OCTAVIA ST (20 - 99) \n",
"26 ALABAMA ST: 17TH ST to MARIPOSA ST (400 - 499) \n",
"27 BROADWAY: FRONT ST to BATTERY ST (100 - 199) \n",
"28 MARKET ST: 03RD ST \\ KEARNY ST to GRANT AVE \\ ... \n",
"29 MISSISSIPPI ST: END to CESAR CHAVEZ ST (1200 -... \n",
".. ... \n",
"586 PINE ST: FRONT ST to BATTERY ST (100 - 199) \n",
"587 CALIFORNIA ST: SANSOME ST to LEIDESDORFF ST (4... \n",
"588 03RD ST: BRANNAN ST to TOWNSEND ST (600 - 699) \n",
"589 SANSOME ST: GOLD ST to PACIFIC AVE (705 - 799) \n",
"590 MISSION ST: BEALE ST to FREMONT ST (300 - 399) \n",
"591 02ND ST: TEHAMA ST to CLEMENTINA ST (224 - 273) \n",
"592 HOWARD ST: 01ST ST to MALDEN ALY (500 - 589) \n",
"593 STEUART ST: HOWARD ST to END (200 - 299) \n",
"594 DRUMM ST: CLAY ST to WASHINGTON ST (200 - 299) \n",
"595 FRONT ST: VALLEJO ST to GREEN ST (900 - 999) \n",
"596 WASHINGTON ST: THE EMBARCADERO to DRUMM ST (1 ... \n",
"597 GEARY ST: STOCKTON ST to POWELL ST (200 - 299) \n",
"598 MENDELL ST: GALVEZ AVE to HUDSON AVE (600 - 699) \n",
"599 BROADWAY: DAVIS ST to FRONT ST (50 - 99) \n",
"600 02ND ST: MISSION ST to MINNA ST (100 - 130) \n",
"601 OAKDALE AVE: INDUSTRIAL ST \\ SELBY ST to TOLAN... \n",
"602 CALIFORNIA ST: DAVIS ST to FRONT ST (100 - 199) \n",
"603 PINE ST: SANSOME ST to CENTURY PL (300 - 340) \n",
"604 EVANS AVE: KEITH ST to MENDELL ST (1201 - 1399... \n",
"605 ELLIS ST: POWELL ST to CYRIL MAGNIN ST (100 - ... \n",
"606 10TH ST: FELL ST \\ MARKET ST \\ POLK ST to END ... \n",
"607 MISSION ST: 05TH ST to MINT ST (900 - 930) \n",
"608 SANSOME ST: SUTTER ST to BUSH ST (1 - 99) \n",
"609 GENEVA AVE: PRAGUE ST to LINDA VISTA STPS (150... \n",
"610 BAY SHORE BLVD: FLOWER ST to CORTLAND AVE (341... \n",
"611 MISSION ST: 19TH ST to 20TH ST (2300 - 2399) \n",
"612 DRUMM ST: MARKET ST to CALIFORNIA ST (1 - 6) \n",
"613 MARKET ST: MASON ST \\ TURK ST to 06TH ST \\ GOL... \n",
"614 MARKET ST: 06TH ST \\ GOLDEN GATE AVE \\ TAYLOR ... \n",
"615 MARKET ST: 07TH ST \\ CHARLES J BRENHAM PL to 0... \n",
"\n",
" Address blocklot block lot permit \\\n",
"0 1800 FOLSOM ST 3549083 3549 083 16MFF-0010 \n",
"1 Assessors Block 0733/Lot010 0733010 0733 010 14MFF-0009 \n",
"2 5 THE EMBARCADERO 0234017 0234 017 15MFF-0159 \n",
"3 79 NEW MONTGOMERY ST 3707014 3707 014 12MFF-0083 \n",
"4 1709 REVERE AVE 5343033 5343 033 14MFF-0009 \n",
"5 1 CALIFORNIA ST 0264004 0264 004 15MFF-0159 \n",
"6 10 SOUTH VAN NESS AVE 3506004 3506 004 15MFF-0145 \n",
"7 699 08TH ST 3783009 3783 009 15MFF-0145 \n",
"8 201 BAY SHORE BLVD 5559021 5559 021 16MFF-0139 \n",
"9 4705 03RD ST 5311036 5311 036 16MFF-0139 \n",
"10 667 MISSION ST 3722067 3722 067 16MFF-0126 \n",
"11 290 SUTTER ST 0287014 0287 014 16MFF-0126 \n",
"12 Assessors Block /Lot NaN NaN NaN 16MFF-0135 \n",
"13 555 MARKET ST 3708057 3708 057 16MFF-0136 \n",
"14 1 FRONT ST 0266009 0266 009 16MFF-0136 \n",
"15 901 MARKET ST 3704001 3704 001 11MFF-0175 \n",
"16 490 02ND ST 3763007 3763 007 16MFF-0137 \n",
"17 2450 TARAVAL ST 2363022 2363 022 17MFF-0002 \n",
"18 2401 36TH AVE 2389001 2389 001 17MFF-0002 \n",
"19 98 MISSION ST 3713007 3713 007 17MFF-0109 \n",
"20 4650 MISSION ST 6955044 6955 044 16MFF-0011 \n",
"21 1499 ILLINOIS ST 4244002 4244 002 17MFF-0109 \n",
"22 2601 24TH ST 4264001 4264 001 17MFF-0186 \n",
"23 Assessors Block 3930A/Lot002 3930A002 3930A 002 17MFF-0109 \n",
"24 661 HOWARD ST 3735040 3735 040 17MFF-0109 \n",
"25 20 HAIGHT ST 0853023 0853 023 17MFF-0109 \n",
"26 400 ALABAMA ST 3968001 3968 001 17MFF-0109 \n",
"27 100 BROADWAY 0141003B 0141 003B 17MFF-0109 \n",
"28 720 MARKET ST 0312004 0312 004 17MFF-0068 \n",
"29 1200 MISSISSIPPI ST 4288003 4288 003 17MFF-0109 \n",
".. ... ... ... ... ... \n",
"586 100 PINE ST 0262020 0262 020 18MFF-0020 \n",
"587 430 CALIFORNIA ST 0239029 0239 029 18MFF-0020 \n",
"588 601 03RD ST 3788020 3788 020 17MFF-0185 \n",
"589 727 SANSOME ST 0175003 0175 003 17MFF-0185 \n",
"590 350 MISSION ST 3710017 3710 017 18MFF-0021 \n",
"591 240 02ND ST 3735055 3735 055 18MFF-0021 \n",
"592 500 HOWARD ST 3721011 3721 011 17MFF-0191 \n",
"593 75 HOWARD ST 3741031 3741 031 17MFF-0191 \n",
"594 253 DRUMM ST 0203013 0203 013 17MFF-0191 \n",
"595 900 FRONT ST 0137001 0137 001 17MFF-0191 \n",
"596 370 DRUMM ST 0201012 0201 012 17MFF-0191 \n",
"597 281 GEARY ST 0314013 0314 013 17MFF-0001 \n",
"598 600 MENDELL ST 5254037 5254 037 18MFF-0019 \n",
"599 90 BROADWAY 0140007 0140 007 18MFF-0023 \n",
"600 120 02ND ST 3722002 3722 002 18MFF-0022 \n",
"601 2198 OAKDALE AVE 5590A008 5590A 008 18MFF-0019 \n",
"602 101 CALIFORNIA ST 0263011 0263 011 16MFF-0143 \n",
"603 300 PINE ST 0260005 0260 005 18MFF-0025 \n",
"604 1275 EVANS AVE 5237033 5237 033 18MFF-0019 \n",
"605 120 ELLIS ST 0326005 0326 005 18MFF-0022 \n",
"606 8 10TH ST 3507041 3507 041 18MFF-0023 \n",
"607 901 MISSION ST 3725093 3725 093 16MFF-0143 \n",
"608 1 SANSOME ST 0289003 0289 003 18MFF-0019 \n",
"609 1500 GENEVA AVE 6418065 6418 065 18MFF-0026 \n",
"610 353 BAY SHORE BLVD 5598030 5598 030 18MFF-0026 \n",
"611 2365 MISSION ST 3595024 3595 024 17MFF-0190 \n",
"612 1 DRUMM ST 0264004 0264 004 16MFF-0094 \n",
"613 979 MARKET ST 3704068 3704 068 16MFF-0094 \n",
"614 1028 MARKET ST 0350002 0350 002 18MFF-0027 \n",
"615 1169 MARKET ST 3702051 3702 051 16MFF-0094 \n",
"\n",
" ... Latitude Longitude \\\n",
"0 ... 37.767852 -122.416105 \n",
"1 ... 37.782144 -122.430450 \n",
"2 ... 37.794331 -122.395811 \n",
"3 ... 37.787890 -122.400535 \n",
"4 ... 37.732560 -122.392063 \n",
"5 ... 37.793214 -122.397043 \n",
"6 ... 37.774259 -122.419486 \n",
"7 ... 37.771022 -122.403546 \n",
"8 ... 37.745309 -122.403420 \n",
"9 ... 37.735004 -122.390172 \n",
"10 ... 37.786558 -122.401033 \n",
"11 ... 37.789914 -122.405233 \n",
"12 ... 0.000000 0.000000 \n",
"13 ... 37.789890 -122.399930 \n",
"14 ... 37.791757 -122.398898 \n",
"15 ... 37.783470 -122.408041 \n",
"16 ... 37.783046 -122.394067 \n",
"17 ... 37.742550 -122.492677 \n",
"18 ... 37.741290 -122.494378 \n",
"19 ... 37.793371 -122.394233 \n",
"20 ... 37.723661 -122.435944 \n",
"21 ... 37.753040 -122.386632 \n",
"22 ... 37.752822 -122.405532 \n",
"23 ... 37.766511 -122.409260 \n",
"24 ... 37.785346 -122.399455 \n",
"25 ... 37.773341 -122.422806 \n",
"26 ... 37.763807 -122.412611 \n",
"27 ... 37.798864 -122.400264 \n",
"28 ... 37.787598 -122.404090 \n",
"29 ... 37.751691 -122.394374 \n",
".. ... ... ... \n",
"586 ... 37.792641 -122.398970 \n",
"587 ... 37.793262 -122.401789 \n",
"588 ... 37.780077 -122.393767 \n",
"589 ... 37.796949 -122.402183 \n",
"590 ... 37.790885 -122.396686 \n",
"591 ... 37.785940 -122.397800 \n",
"592 ... 0.000000 0.000000 \n",
"593 ... 37.791558 -122.391671 \n",
"594 ... 37.796123 -122.397273 \n",
"595 ... 37.800221 -122.399569 \n",
"596 ... 37.796914 -122.396651 \n",
"597 ... 37.787136 -122.407719 \n",
"598 ... 37.739679 -122.386493 \n",
"599 ... 37.799260 -122.399618 \n",
"600 ... 37.787514 -122.399566 \n",
"601 ... 37.740995 -122.401172 \n",
"602 ... 37.792949 -122.398099 \n",
"603 ... 0.000000 0.000000 \n",
"604 ... 37.739111 -122.382465 \n",
"605 ... 37.785610 -122.408155 \n",
"606 ... 37.775826 -122.417250 \n",
"607 ... 37.782154 -122.406601 \n",
"608 ... 37.790485 -122.400940 \n",
"609 ... 37.712303 -122.431644 \n",
"610 ... 37.741718 -122.405418 \n",
"611 ... 37.759240 -122.418544 \n",
"612 ... 37.793214 -122.397043 \n",
"613 ... 37.782281 -122.409531 \n",
"614 ... 37.781883 -122.411323 \n",
"615 ... 0.000000 0.000000 \n",
"\n",
" Schedule \\\n",
"0 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"1 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"2 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"3 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"4 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"5 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"6 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"7 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"8 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"9 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"10 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"11 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"12 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"13 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"14 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"15 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"16 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"17 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"18 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"19 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"20 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"21 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"22 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"23 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"24 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"25 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"26 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"27 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"28 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"29 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
".. ... \n",
"586 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"587 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"588 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"589 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"590 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"591 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"592 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"593 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"594 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"595 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"596 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"597 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"598 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"599 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"600 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"601 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"602 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"603 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"604 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"605 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"606 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"607 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"608 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"609 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"610 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"611 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"612 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"613 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"614 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"615 http://bsm.sfdpw.org/PermitsTracker/reports/re... \n",
"\n",
" dayshours NOISent \\\n",
"0 NaN NaN \n",
"1 Mo-Su:10AM-7PM NaN \n",
"2 NaN NaN \n",
"3 Mo-Su:7AM-6PM NaN \n",
"4 Mo-Su:10AM-7PM NaN \n",
"5 NaN NaN \n",
"6 We/Th/Fr:6AM-6PM NaN \n",
"7 Mo-We:6AM-6PM NaN \n",
"8 Mo-We:7AM-7PM NaN \n",
"9 Th/Fr/Sa:7AM-7PM NaN \n",
"10 NaN NaN \n",
"11 NaN NaN \n",
"12 NaN NaN \n",
"13 NaN NaN \n",
"14 NaN NaN \n",
"15 Sa-Su:12AM-3AM;Mo-Su:10AM-8PM;Fr/Sa:9PM-12AM NaN \n",
"16 Tu/We/Th:7AM-8PM NaN \n",
"17 NaN NaN \n",
"18 NaN NaN \n",
"19 Mo-Fr:7AM-9AM NaN \n",
"20 Mo/Th/Fr:11AM-6PM NaN \n",
"21 Mo-Fr:5PM-6PM NaN \n",
"22 Mo/Tu/Sa:11AM-5PM NaN \n",
"23 Mo-Fr:7PM-8PM NaN \n",
"24 Mo-Fr:8PM-9PM NaN \n",
"25 Mo-Fr:6PM-8PM NaN \n",
"26 Mo-Fr:7AM-8AM/9AM-10AM/12PM-1PM/8PM-9PM NaN \n",
"27 Mo-Fr:10AM-11AM NaN \n",
"28 Th/Fr/Sa:8AM-10PM NaN \n",
"29 Mo/Tu/We/Th/Fr:12AM-5AM;Sa:2PM-6PM;Mo-Fr:3PM-6PM NaN \n",
".. ... ... \n",
"586 Mo/We/Fr:10AM-3PM NaN \n",
"587 Mo/We/Fr:10AM-3PM NaN \n",
"588 Tu/Th/Fr:12PM-1PM NaN \n",
"589 Mo/Tu/Th:12PM-1PM NaN \n",
"590 Mo/Mo/We/We:10AM-2PM NaN \n",
"591 NaN NaN \n",
"592 Mo/Fr:10AM-2PM NaN \n",
"593 Mo/We:10AM-3PM NaN \n",
"594 Tu/Th:10AM-3PM NaN \n",
"595 Fr:10AM-3PM NaN \n",
"596 Su:10AM-11PM NaN \n",
"597 Su:11AM-11PM;Fr/Sa:6PM-11PM NaN \n",
"598 Su/Fr/Sa:8AM-6PM 05/15/2018 12:00:00 AM \n",
"599 Tu/Th:10AM-3PM NaN \n",
"600 Mo-Fr:11AM-2PM NaN \n",
"601 Mo-Fr:8AM-5PM 05/15/2018 12:00:00 AM \n",
"602 Mo/We/Fr:10AM-3PM 09/15/2017 12:00:00 AM \n",
"603 Mo-Fr:11AM-2PM NaN \n",
"604 Mo-Su:8AM-8PM 05/15/2018 12:00:00 AM \n",
"605 Sa-Su:11AM-6PM NaN \n",
"606 Mo/We/Fr:11AM-2PM NaN \n",
"607 Tu/Th:10AM-3PM 09/15/2017 12:00:00 AM \n",
"608 Mo-Fr:11AM-3PM 05/15/2018 12:00:00 AM \n",
"609 Su:7AM-6PM NaN \n",
"610 Mo/Tu/We/Th/Fr:7AM-6PM NaN \n",
"611 Su/Fr/Sa:12AM-3AM;Th/Fr/Sa:10PM-12AM NaN \n",
"612 Mo/We/Fr:8AM-8PM NaN \n",
"613 Mo/Tu/Th:8AM-8PM NaN \n",
"614 We/Th/Fr:11AM-3PM NaN \n",
"615 We/Fr/Sa:8AM-8PM NaN \n",
"\n",
" Approved Received PriorPermit ExpirationDate \\\n",
"0 NaN 2016-02-04 0 NaN \n",
"1 02/25/2014 12:00:00 AM 2014-02-25 1 03/15/2015 12:00:00 AM \n",
"2 NaN 2015-12-31 0 03/15/2016 12:00:00 AM \n",
"3 NaN 2012-04-03 0 NaN \n",
"4 02/25/2014 12:00:00 AM 2014-02-25 1 03/15/2015 12:00:00 AM \n",
"5 NaN 2015-12-31 0 03/15/2016 12:00:00 AM \n",
"6 NaN 2015-09-01 0 NaN \n",
"7 NaN 2015-09-01 0 NaN \n",
"8 NaN 2016-09-08 0 03/15/2017 12:00:00 AM \n",
"9 NaN 2016-09-08 0 03/15/2017 12:00:00 AM \n",
"10 NaN 2016-05-31 0 NaN \n",
"11 NaN 2016-05-31 0 NaN \n",
"12 NaN 2016-08-05 0 NaN \n",
"13 NaN 2016-08-12 0 NaN \n",
"14 NaN 2016-08-12 0 NaN \n",
"15 NaN 2011-09-26 0 NaN \n",
"16 NaN 2016-08-12 0 08/12/2016 12:00:00 AM \n",
"17 NaN 2017-01-30 0 01/30/2018 12:00:00 AM \n",
"18 NaN 2017-01-30 0 01/30/2018 12:00:00 AM \n",
"19 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
"20 NaN 2016-02-17 0 03/15/2017 12:00:00 AM \n",
"21 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
"22 NaN 2017-06-19 0 NaN \n",
"23 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
"24 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
"25 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
"26 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
"27 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
"28 NaN 2017-02-13 0 05/06/2018 12:00:00 AM \n",
"29 NaN 2017-02-13 1 03/31/2018 12:00:00 AM \n",
".. ... ... ... ... \n",
"586 04/25/2018 12:00:00 AM 2018-04-19 0 07/15/2019 12:00:00 AM \n",
"587 04/25/2018 12:00:00 AM 2018-04-19 0 07/15/2019 12:00:00 AM \n",
"588 03/01/2018 12:00:00 AM 2017-05-10 0 07/15/2019 12:00:00 AM \n",
"589 03/01/2018 12:00:00 AM 2017-05-10 0 07/15/2019 12:00:00 AM \n",
"590 NaN 2018-04-30 0 NaN \n",
"591 NaN 2018-04-30 0 NaN \n",
"592 05/04/2018 12:00:00 AM 2017-08-31 1 07/15/2019 12:00:00 AM \n",
"593 05/04/2018 12:00:00 AM 2017-08-31 1 07/15/2019 12:00:00 AM \n",
"594 05/04/2018 12:00:00 AM 2017-08-31 1 07/15/2019 12:00:00 AM \n",
"595 05/04/2018 12:00:00 AM 2017-08-31 1 07/15/2019 12:00:00 AM \n",
"596 05/04/2018 12:00:00 AM 2017-08-31 1 07/15/2019 12:00:00 AM \n",
"597 04/27/2018 12:00:00 AM 2017-01-09 0 07/15/2019 12:00:00 AM \n",
"598 NaN 2018-04-18 1 03/15/2019 12:00:00 AM \n",
"599 05/14/2018 12:00:00 AM 2018-05-10 0 07/15/2019 12:00:00 AM \n",
"600 05/14/2018 12:00:00 AM 2018-05-10 0 07/15/2019 12:00:00 AM \n",
"601 NaN 2018-04-18 1 03/15/2019 12:00:00 AM \n",
"602 05/14/2018 12:00:00 AM 2016-12-02 0 07/15/2019 12:00:00 AM \n",
"603 05/14/2018 12:00:00 AM 2018-05-14 0 07/15/2019 12:00:00 AM \n",
"604 NaN 2018-04-18 1 03/15/2019 12:00:00 AM \n",
"605 05/14/2018 12:00:00 AM 2018-05-10 0 07/15/2019 12:00:00 AM \n",
"606 05/14/2018 12:00:00 AM 2018-05-10 0 07/15/2019 12:00:00 AM \n",
"607 05/14/2018 12:00:00 AM 2016-12-02 0 07/15/2019 12:00:00 AM \n",
"608 NaN 2018-04-18 1 03/15/2019 12:00:00 AM \n",
"609 05/15/2018 12:00:00 AM 2018-05-15 0 07/15/2019 12:00:00 AM \n",
"610 05/15/2018 12:00:00 AM 2018-05-15 0 07/15/2019 12:00:00 AM \n",
"611 05/17/2018 12:00:00 AM 2017-08-24 0 07/15/2019 12:00:00 AM \n",
"612 05/18/2018 12:00:00 AM 2016-04-18 0 07/15/2019 12:00:00 AM \n",
"613 05/18/2018 12:00:00 AM 2016-04-18 0 07/15/2019 12:00:00 AM \n",
"614 NaN 2018-05-16 0 07/11/2019 12:00:00 AM \n",
"615 05/18/2018 12:00:00 AM 2016-04-18 0 07/15/2019 12:00:00 AM \n",
"\n",
" Location \n",
"0 (37.7678524427181, -122.416104892532) \n",
"1 (37.782143532929, -122.430449785949) \n",
"2 (37.7943310032468, -122.395811053023) \n",
"3 (37.7878896999061, -122.400535326777) \n",
"4 (37.7325595789318, -122.392063194969) \n",
"5 (37.7932137316634, -122.397043036718) \n",
"6 (37.77425926306, -122.419485988398) \n",
"7 (37.7710219992437, -122.403546254184) \n",
"8 (37.7453089086563, -122.403420059999) \n",
"9 (37.7350042289514, -122.3901724697) \n",
"10 (37.7865580501799, -122.40103337535) \n",
"11 (37.7899138671344, -122.405232892524) \n",
"12 (0, 0) \n",
"13 (37.7898898782098, -122.399930411351) \n",
"14 (37.7917572059444, -122.398897636892) \n",
"15 (37.7834700660829, -122.408040736138) \n",
"16 (37.78304609975, -122.39406659923) \n",
"17 (37.7425503735592, -122.492677082215) \n",
"18 (37.7412902847707, -122.494377920435) \n",
"19 (37.7933707169278, -122.394233280448) \n",
"20 (37.7236612795053, -122.43594382524) \n",
"21 (37.7530403201943, -122.386631763538) \n",
"22 (37.7528223681215, -122.405531919216) \n",
"23 (37.7665109269083, -122.40926014493) \n",
"24 (37.7853456766418, -122.399455276698) \n",
"25 (37.7733408773453, -122.422806203983) \n",
"26 (37.7638066535277, -122.412610953897) \n",
"27 (37.7988640669494, -122.400263583781) \n",
"28 (37.7875984155546, -122.404090439434) \n",
"29 (37.7516910357229, -122.394374213263) \n",
".. ... \n",
"586 (37.7926407167337, -122.398970332111) \n",
"587 (37.7932622069231, -122.401789091363) \n",
"588 (37.7800771744392, -122.393767294483) \n",
"589 (37.7969490060212, -122.402183431894) \n",
"590 (37.7908854635019, -122.396685875811) \n",
"591 (37.7859403201734, -122.397799933858) \n",
"592 (0, 0) \n",
"593 (37.7915578641549, -122.391671499786) \n",
"594 (37.7961233802521, -122.397273204338) \n",
"595 (37.8002209155922, -122.399569018577) \n",
"596 (37.7969137124835, -122.396650675264) \n",
"597 (37.7871364910861, -122.407718509001) \n",
"598 (37.7396787918079, -122.386493384555) \n",
"599 (37.7992601135023, -122.399617948655) \n",
"600 (37.7875140607381, -122.399566331429) \n",
"601 (37.7409947350024, -122.401172335386) \n",
"602 (37.7929489528347, -122.398098613167) \n",
"603 (0, 0) \n",
"604 (37.739111429745, -122.382464971136) \n",
"605 (37.7856100863691, -122.408154764345) \n",
"606 (37.7758255197583, -122.417249626643) \n",
"607 (37.7821536409986, -122.406601106839) \n",
"608 (37.790485146128, -122.40094044069) \n",
"609 (37.7123026047444, -122.431644190373) \n",
"610 (37.7417178307439, -122.405417977448) \n",
"611 (37.7592402851502, -122.418544171117) \n",
"612 (37.7932137316634, -122.397043036718) \n",
"613 (37.7822807724186, -122.40953118732) \n",
"614 (37.7818834680896, -122.411323335782) \n",
"615 (0, 0) \n",
"\n",
"[616 rows x 24 columns]"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"with hdfs.open('/tobi/Mobile_Food_Facility_Permit.csv') as f:\n",
" data = pd.read_csv(f)\n",
"\n",
"data"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Read JSON\n",
"\n",
"Compression such as `zip` is automatically inferred.\n",
"\n",
"Docs: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_json.html#pandas.read_json"
]
},
{
"cell_type": "code",
"execution_count": 17,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>_id</th>\n",
" <th>about</th>\n",
" <th>address</th>\n",
" <th>age</th>\n",
" <th>balance</th>\n",
" <th>company</th>\n",
" <th>email</th>\n",
" <th>eyeColor</th>\n",
" <th>favoriteFruit</th>\n",
" <th>friends</th>\n",
" <th>...</th>\n",
" <th>guid</th>\n",
" <th>index</th>\n",
" <th>isActive</th>\n",
" <th>latitude</th>\n",
" <th>longitude</th>\n",
" <th>name</th>\n",
" <th>phone</th>\n",
" <th>picture</th>\n",
" <th>registered</th>\n",
" <th>tags</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>5b030b795737de0d4f7c9fc9</td>\n",
" <td>Enim nisi culpa ut tempor excepteur amet qui m...</td>\n",
" <td>754 Herkimer Street, Dahlen, Vermont, 6987</td>\n",
" <td>29</td>\n",
" <td>$3,598.49</td>\n",
" <td>ANDERSHUN</td>\n",
" <td>dalebaxter@andershun.com</td>\n",
" <td>blue</td>\n",
" <td>strawberry</td>\n",
" <td>[{'id': 0, 'name': 'Tisha Heath'}, {'id': 1, '...</td>\n",
" <td>...</td>\n",
" <td>339dbe58-cb00-4eed-80d9-41ac3c41054a</td>\n",
" <td>0</td>\n",
" <td>True</td>\n",
" <td>71.085852</td>\n",
" <td>30.702629</td>\n",
" <td>Dale Baxter</td>\n",
" <td>+1 (846) 419-3274</td>\n",
" <td>http://placehold.it/32x32</td>\n",
" <td>2016-09-27T12:52:42 +07:00</td>\n",
" <td>[officia, aliquip, occaecat, dolore, et, velit...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5b030b7986923f4e1d26f606</td>\n",
" <td>Dolore minim in magna aute enim Lorem exercita...</td>\n",
" <td>516 Fairview Place, Watchtower, Wisconsin, 8872</td>\n",
" <td>40</td>\n",
" <td>$3,156.80</td>\n",
" <td>QUINEX</td>\n",
" <td>swansonvaughan@quinex.com</td>\n",
" <td>green</td>\n",
" <td>apple</td>\n",
" <td>[{'id': 0, 'name': 'Howell Cotton'}, {'id': 1,...</td>\n",
" <td>...</td>\n",
" <td>3360051b-d7c1-44d4-a01d-84617270938f</td>\n",
" <td>1</td>\n",
" <td>True</td>\n",
" <td>-26.612554</td>\n",
" <td>-127.720065</td>\n",
" <td>Swanson Vaughan</td>\n",
" <td>+1 (832) 439-3097</td>\n",
" <td>http://placehold.it/32x32</td>\n",
" <td>2016-04-14T11:10:25 +07:00</td>\n",
" <td>[ullamco, laboris, ut, excepteur, reprehenderi...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>5b030b7943f2a516aebc4b78</td>\n",
" <td>Cupidatat Lorem nisi eiusmod consectetur. Cons...</td>\n",
" <td>521 Joralemon Street, Lowgap, Kentucky, 1592</td>\n",
" <td>22</td>\n",
" <td>$3,915.97</td>\n",
" <td>KROG</td>\n",
" <td>franksconley@krog.com</td>\n",
" <td>green</td>\n",
" <td>apple</td>\n",
" <td>[{'id': 0, 'name': 'Knapp Andrews'}, {'id': 1,...</td>\n",
" <td>...</td>\n",
" <td>b3087065-2825-4d26-bd43-bb960c3fbb47</td>\n",
" <td>2</td>\n",
" <td>False</td>\n",
" <td>59.783246</td>\n",
" <td>-117.324451</td>\n",
" <td>Franks Conley</td>\n",
" <td>+1 (934) 558-3875</td>\n",
" <td>http://placehold.it/32x32</td>\n",
" <td>2018-02-01T07:47:05 +08:00</td>\n",
" <td>[minim, magna, eu, labore, pariatur, in, sit]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5b030b79035a106866b1e4ce</td>\n",
" <td>Esse velit ad officia aliquip ex labore veniam...</td>\n",
" <td>717 Bank Street, Why, Indiana, 8027</td>\n",
" <td>37</td>\n",
" <td>$1,816.63</td>\n",
" <td>ZYTRAX</td>\n",
" <td>carolinajarvis@zytrax.com</td>\n",
" <td>blue</td>\n",
" <td>banana</td>\n",
" <td>[{'id': 0, 'name': 'Marsh Kim'}, {'id': 1, 'na...</td>\n",
" <td>...</td>\n",
" <td>07e13290-3aae-4b11-9753-5e6b0e6942d9</td>\n",
" <td>3</td>\n",
" <td>True</td>\n",
" <td>60.489857</td>\n",
" <td>-17.669439</td>\n",
" <td>Carolina Jarvis</td>\n",
" <td>+1 (879) 521-3877</td>\n",
" <td>http://placehold.it/32x32</td>\n",
" <td>2014-06-11T03:06:24 +07:00</td>\n",
" <td>[ad, ea, labore, ad, qui, commodo, nostrud]</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>5b030b79d97003870c92e5a1</td>\n",
" <td>Quis duis et est eu consequat excepteur eu nul...</td>\n",
" <td>355 Brighton Avenue, Hiko, Missouri, 6892</td>\n",
" <td>30</td>\n",
" <td>$1,121.62</td>\n",
" <td>GRUPOLI</td>\n",
" <td>blevinscarver@grupoli.com</td>\n",
" <td>brown</td>\n",
" <td>banana</td>\n",
" <td>[{'id': 0, 'name': 'Whitley Kent'}, {'id': 1, ...</td>\n",
" <td>...</td>\n",
" <td>d5d66147-d359-4d58-bb9d-a2b36cd14724</td>\n",
" <td>4</td>\n",
" <td>False</td>\n",
" <td>-13.780243</td>\n",
" <td>65.207218</td>\n",
" <td>Blevins Carver</td>\n",
" <td>+1 (989) 488-2509</td>\n",
" <td>http://placehold.it/32x32</td>\n",
" <td>2015-01-03T02:20:44 +08:00</td>\n",
" <td>[elit, anim, elit, esse, fugiat, mollit, tempor]</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 22 columns</p>\n",
"</div>"
],
"text/plain": [
" _id \\\n",
"0 5b030b795737de0d4f7c9fc9 \n",
"1 5b030b7986923f4e1d26f606 \n",
"2 5b030b7943f2a516aebc4b78 \n",
"3 5b030b79035a106866b1e4ce \n",
"4 5b030b79d97003870c92e5a1 \n",
"\n",
" about \\\n",
"0 Enim nisi culpa ut tempor excepteur amet qui m... \n",
"1 Dolore minim in magna aute enim Lorem exercita... \n",
"2 Cupidatat Lorem nisi eiusmod consectetur. Cons... \n",
"3 Esse velit ad officia aliquip ex labore veniam... \n",
"4 Quis duis et est eu consequat excepteur eu nul... \n",
"\n",
" address age balance company \\\n",
"0 754 Herkimer Street, Dahlen, Vermont, 6987 29 $3,598.49 ANDERSHUN \n",
"1 516 Fairview Place, Watchtower, Wisconsin, 8872 40 $3,156.80 QUINEX \n",
"2 521 Joralemon Street, Lowgap, Kentucky, 1592 22 $3,915.97 KROG \n",
"3 717 Bank Street, Why, Indiana, 8027 37 $1,816.63 ZYTRAX \n",
"4 355 Brighton Avenue, Hiko, Missouri, 6892 30 $1,121.62 GRUPOLI \n",
"\n",
" email eyeColor favoriteFruit \\\n",
"0 dalebaxter@andershun.com blue strawberry \n",
"1 swansonvaughan@quinex.com green apple \n",
"2 franksconley@krog.com green apple \n",
"3 carolinajarvis@zytrax.com blue banana \n",
"4 blevinscarver@grupoli.com brown banana \n",
"\n",
" friends \\\n",
"0 [{'id': 0, 'name': 'Tisha Heath'}, {'id': 1, '... \n",
"1 [{'id': 0, 'name': 'Howell Cotton'}, {'id': 1,... \n",
"2 [{'id': 0, 'name': 'Knapp Andrews'}, {'id': 1,... \n",
"3 [{'id': 0, 'name': 'Marsh Kim'}, {'id': 1, 'na... \n",
"4 [{'id': 0, 'name': 'Whitley Kent'}, {'id': 1, ... \n",
"\n",
" ... \\\n",
"0 ... \n",
"1 ... \n",
"2 ... \n",
"3 ... \n",
"4 ... \n",
"\n",
" guid index isActive latitude longitude \\\n",
"0 339dbe58-cb00-4eed-80d9-41ac3c41054a 0 True 71.085852 30.702629 \n",
"1 3360051b-d7c1-44d4-a01d-84617270938f 1 True -26.612554 -127.720065 \n",
"2 b3087065-2825-4d26-bd43-bb960c3fbb47 2 False 59.783246 -117.324451 \n",
"3 07e13290-3aae-4b11-9753-5e6b0e6942d9 3 True 60.489857 -17.669439 \n",
"4 d5d66147-d359-4d58-bb9d-a2b36cd14724 4 False -13.780243 65.207218 \n",
"\n",
" name phone picture \\\n",
"0 Dale Baxter +1 (846) 419-3274 http://placehold.it/32x32 \n",
"1 Swanson Vaughan +1 (832) 439-3097 http://placehold.it/32x32 \n",
"2 Franks Conley +1 (934) 558-3875 http://placehold.it/32x32 \n",
"3 Carolina Jarvis +1 (879) 521-3877 http://placehold.it/32x32 \n",
"4 Blevins Carver +1 (989) 488-2509 http://placehold.it/32x32 \n",
"\n",
" registered \\\n",
"0 2016-09-27T12:52:42 +07:00 \n",
"1 2016-04-14T11:10:25 +07:00 \n",
"2 2018-02-01T07:47:05 +08:00 \n",
"3 2014-06-11T03:06:24 +07:00 \n",
"4 2015-01-03T02:20:44 +08:00 \n",
"\n",
" tags \n",
"0 [officia, aliquip, occaecat, dolore, et, velit... \n",
"1 [ullamco, laboris, ut, excepteur, reprehenderi... \n",
"2 [minim, magna, eu, labore, pariatur, in, sit] \n",
"3 [ad, ea, labore, ad, qui, commodo, nostrud] \n",
"4 [elit, anim, elit, esse, fugiat, mollit, tempor] \n",
"\n",
"[5 rows x 22 columns]"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"with hdfs.open('/tobi/generated.json') as f:\n",
" data = pd.read_json(f)\n",
"\n",
"data"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"## Read Parquet\n",
"\n",
"Docs: https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_parquet.html#pandas.read_parquet"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>uint8_field</th>\n",
" <th>uint16_field</th>\n",
" <th>uint32_field</th>\n",
" <th>uint64_field</th>\n",
" <th>int8_field</th>\n",
" <th>int16_field</th>\n",
" <th>required_uint8_field</th>\n",
" <th>required_uint16_field</th>\n",
" <th>required_uint32_field</th>\n",
" <th>required_uint64_field</th>\n",
" <th>required_int8_field</th>\n",
" <th>required_int16_field</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>255.0</td>\n",
" <td>65535.0</td>\n",
" <td>2.147484e+09</td>\n",
" <td>9.223372e+18</td>\n",
" <td>-1.0</td>\n",
" <td>-1.0</td>\n",
" <td>255</td>\n",
" <td>65535</td>\n",
" <td>4294967295</td>\n",
" <td>18446744073709551615</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>255.0</td>\n",
" <td>65535.0</td>\n",
" <td>4.294967e+09</td>\n",
" <td>1.844674e+19</td>\n",
" <td>0.0</td>\n",
" <td>0.0</td>\n",
" <td>255</td>\n",
" <td>65535</td>\n",
" <td>2147483647</td>\n",
" <td>9223372036854775807</td>\n",
" <td>-1</td>\n",
" <td>-1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" uint8_field uint16_field uint32_field uint64_field int8_field \\\n",
"0 255.0 65535.0 2.147484e+09 9.223372e+18 -1.0 \n",
"1 255.0 65535.0 4.294967e+09 1.844674e+19 0.0 \n",
"2 NaN NaN NaN NaN NaN \n",
"\n",
" int16_field required_uint8_field required_uint16_field \\\n",
"0 -1.0 255 65535 \n",
"1 0.0 255 65535 \n",
"2 NaN 0 0 \n",
"\n",
" required_uint32_field required_uint64_field required_int8_field \\\n",
"0 4294967295 18446744073709551615 0 \n",
"1 2147483647 9223372036854775807 -1 \n",
"2 0 0 0 \n",
"\n",
" required_int16_field \n",
"0 0 \n",
"1 -1 \n",
"2 0 "
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"with hdfs.open('/tobi/uint_types.parquet') as f:\n",
" data = pd.read_parquet(f)\n",
"\n",
"data"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.6.5"
},
"widgets": {
"application/vnd.jupyter.widget-state+json": {
"state": {},
"version_major": 2,
"version_minor": 0
}
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment