Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 159459 | 159459 | 234473 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 99 Elsie St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | 6007295.70063 | 2098744.01488 | 37.7431637754778 | -122.417408915989 | (37.7431637754778, -122.417408915989) | ||||
| 20409 | 20409 | 4367 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 973 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001101.12966 | 2096102.69208 | 37.7355608412513 | -122.438638832041 | (37.7355608412513, -122.438638832041) | |||
| 123604 | 123604 | 23614 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 910X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 30X30PL | 6011300.2113585 | 2104101.3880723 | 37.7580984495586 | -122.403939228694 | (37.7580984495586, -122.403939228694) | |||
| 280 | 280 | 194427 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 905 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6008110.0 | 2110227.0 | 37.774739203286295 | -122.415406037323 | (37.7747392032863, -122.415406037323) | |||
| 100574 | 100574 | 111558 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 36 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 15 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 111551 | 111551 | 111555 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 33 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 115460 | 115460 | 111557 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 35 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 126284 | 126284 | 111553 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 31 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 140665 | 140665 | 111554 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 900x BOSWORTH ST | 32 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 26 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | ||||
| 114243 | 114243 | 115834 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 900X LAKE MERCED BLVD | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 10x100 | Permit Number 777492 | 5987646.0 | 2090104.0 | 37.7183153647657 | -122.484717856844 | (37.7183153647657, -122.484717856844) | |
| 92410 | 92410 | 98278 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 500 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
| 110779 | 110779 | 98279 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 900 Brotherhood Way | 501 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 02/07/2012 12:00:00 AM | Permit Number 768594 | 5988860.9 | 2088745.5 | 37.7146559434524 | -122.48041912379101 | (37.7146559434524, -122.480419123791) | |||
| 126787 | 126787 | 23612 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | |||
| 80939 | 80939 | 114377 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 842X GONZALEZ DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988421.0 | 2089827.0 | 37.7175998975755 | -122.48201875930201 | (37.7175998975755, -122.482018759302) | ||||
| 104763 | 104763 | 105268 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 842X GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988421.0 | 2089827.0 | 37.7175998975755 | -122.48201875930201 | (37.7175998975755, -122.482018759302) | ||||
| 125758 | 125758 | 114378 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 842X GONZALEZ DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988421.0 | 2089827.0 | 37.7175998975755 | -122.48201875930201 | (37.7175998975755, -122.482018759302) | ||||
| 96125 | 96125 | 114371 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 821 GONZALEZ DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988453.0 | 2089765.0 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | ||||
| 119505 | 119505 | 114372 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 821 GONZALEZ DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988453.0 | 2089765.0 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | ||||
| 120617 | 120617 | 114370 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 821 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5988453.0 | 2089765.0 | 37.7174315222235 | -122.481903612061 | (37.7174315222235, -122.481903612061) | ||||
| 171859 | 171859 | 211005 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 5996562.64616 | 2099171.2604900002 | 37.7437271539842 | -122.454551615288 | (37.7437271539842, -122.454551615288) | |||
| 123578 | 123578 | 114260 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 800x BROTHERHOOD WAY | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 7 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 82351 | 82351 | 111514 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 12 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 85854 | 85854 | 111516 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 14 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 89050 | 89050 | 111507 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 100466 | 100466 | 111508 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 800x BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 161403 | 161403 | 118538 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7900x Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 5982472.235830001 | 2112389.87128 | 37.7792034803758 | -122.504251064408 | (37.7792034803758, -122.504251064408) | |||
| 128707 | 128707 | 27300 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1999 12:00:00 AM | 6 | 5x5 | 5982547.933540001 | 2112415.51016 | 37.7792783288562 | -122.50399109880101 | (37.7792783288562, -122.503991098801) | ||
| 177953 | 177953 | 234476 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 784 Duncan St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6001432.63511 | 2099723.41327 | 37.745521346435204 | -122.43775192962799 | (37.7455213464352, -122.437751929628) | |||
| 86601 | 86601 | 27299 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.779227117259296 | -122.503705073784 | (37.7792271172593, -122.503705073784) | ||
| 92056 | 92056 | 27295 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.779242313567295 | -122.50336180684499 | (37.7792423135673, -122.503361806845) | ||
| 111288 | 111288 | 27297 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.863919999 | 2112396.64212 | 37.7792343387449 | -122.50352984750401 | (37.7792343387449, -122.503529847504) | ||
| 114112 | 114112 | 27296 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.7930900003 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | ||
| 125546 | 125546 | 27294 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 02/12/2001 12:00:00 AM | 6 | 5X5 | 5982752.16339 | 2112399.44122 | 37.77924621575129 | -122.503283404585 | (37.7792462157513, -122.503283404585) | ||
| 143978 | 143978 | 27298 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982658.07107 | 2112395.9042 | 37.7792309725957 | -122.503608641413 | (37.7792309725957, -122.503608641413) | ||
| 117254 | 117254 | 24789 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.779435386439204 | -122.50204978501301 | (37.7794353864392, -122.502049785013) | |||
| 107898 | 107898 | 2268 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 750X Brotherhood Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 120091 | 120091 | 234474 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 72 Santa Marina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006078.82979 | 2097595.56477 | 37.739941848150394 | -122.421534992063 | (37.7399418481504, -122.421534992063) | |||
| 33946 | 33946 | 211008 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700x Bosworth St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 33 | Width 10ft | 6002060.330030001 | 2095430.49234 | 37.7337696552405 | -122.435274449372 | (37.7337696552405, -122.435274449372) | |||
| 118805 | 118805 | 2266 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/04/2014 12:00:00 AM | 22 | 14M | Permit Number 772491 | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |
| 93367 | 93367 | 2045 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X Bosworth St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 6002154.6210393 | 2095431.8532492002 | 37.733778746199796 | -122.43494855504801 | (37.7337787461998, -122.434948555048) | |||
| 18019 | 18019 | 111271 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 42 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 79179 | 79179 | 111279 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 17 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 24 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 142951 | 142951 | 111265 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700X BOSWORTH ST | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 20 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 2179 | 2179 | 252925 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 700 Sanchez St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 56596 | 56596 | 211001 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996755.5114400005 | 2099350.67627 | 37.7442308453761 | -122.45389769125 | (37.7442308453761, -122.45389769125) | |||
| 75987 | 75987 | 211004 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996822.63607 | 2099410.87592 | 37.7443999871842 | -122.453669936126 | (37.7443999871842, -122.453669936126) | |||
| 172637 | 172637 | 211002 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5996779.38475 | 2099373.51377 | 37.744294920285 | -122.45381679181801 | (37.744294920285, -122.453816791818) | |||
| 179816 | 179816 | 211003 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996800.72253 | 2099394.55039 | 37.7443539050009 | -122.453744529511 | (37.7443539050009, -122.453744529511) | |||
| 29067 | 29067 | 211025 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 95 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991234.71561 | 2092082.53367 | 37.723956281843705 | -122.472457461651 | (37.7239562818437, -122.472457461651) | |||
| 33005 | 33005 | 211017 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 49 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991258.9422 | 2092457.39845 | 37.724986969654495 | -122.47240103009399 | (37.7249869696545, -122.472401030094) | |||
| 35161 | 35161 | 211021 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991241.40021 | 2092233.4270099998 | 37.7243709844069 | -122.472445349599 | (37.7243709844069, -122.472445349599) | |||
| 41068 | 41068 | 211024 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 94 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 5991236.61569 | 2092101.4351299999 | 37.7240082905392 | -122.472452270761 | (37.7240082905392, -122.472452270761) | |||
| 44904 | 44904 | 211027 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 157 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991179.7136 | 2091396.7999900002 | 37.7220702434165 | -122.47259762098 | (37.7220702434165, -122.47259762098) | |||
| 54409 | 54409 | 211016 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 46 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991242.43895 | 2092472.66575 | 37.7250279346749 | -122.472459191965 | (37.7250279346749, -122.472459191965) | |||
| 116918 | 116918 | 211018 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 55 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991237.26366 | 2092440.87353 | 37.7249403415953 | -122.472474765495 | (37.7249403415953, -122.472474765495) | |||
| 132551 | 132551 | 211019 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 71 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991242.8983 | 2092280.74938 | 37.724501006592895 | -122.472443619273 | (37.7245010065929, -122.472443619273) | |||
| 133473 | 133473 | 211020 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 74 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991248.48231 | 2092260.69315 | 37.7244462603628 | -122.472422854829 | (37.7244462603628, -122.472422854829) | |||
| 137218 | 137218 | 211026 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 138 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991196.61305 | 2091604.8062200001 | 37.7226423552448 | -122.472554361808 | (37.7226423552448, -122.472554361808) | |||
| 146741 | 146741 | 211030 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 165 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991183.72988 | 2091349.85826 | 37.7219415855123 | -122.47258031712099 | (37.7219415855123, -122.472580317121) | |||
| 156892 | 156892 | 211023 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 83 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991239.95465 | 2092188.59606 | 37.7242478060794 | -122.472447079879 | (37.7242478060794, -122.472447079879) | |||
| 162875 | 162875 | 211022 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 80 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991230.5084 | 2092239.13983 | 37.7243860399747 | -122.47248341699101 | (37.7243860399747, -122.472483416991) | |||
| 172927 | 172927 | 211028 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 160 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991184.3391 | 2091378.75733 | 37.722020970475505 | -122.472580317131 | (37.7220209704755, -122.472580317131) | |||
| 183116 | 183116 | 211029 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 700 Junipero Serra Blvd | 162 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991185.525 | 2091363.77787 | 37.721979909226704 | -122.472575126241 | (37.7219799092267, -122.472575126241) | |||
| 80132 | 80132 | 105261 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 619 GONZALEZ DR | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988914.8 | 2089258.8 | 37.716068469533205 | -122.48027037241002 | (37.7160684695332, -122.48027037241) | |||||
| 151728 | 151728 | 200146 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 6101 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6013586.8559 | 2091305.2042 | 37.7230902914135 | -122.395134667477 | (37.7230902914135, -122.395134667477) | |||
| 66679 | 66679 | 211036 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001192.69302 | 2095737.41742 | 37.7345630902121 | -122.438296103083 | (37.7345630902121, -122.438296103083) | ||||
| 158981 | 158981 | 211037 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6001183.29295 | 2095747.84811 | 37.734591195811795 | -122.438329349227 | (37.7345911958118, -122.438329349227) | ||||
| 173673 | 173673 | 211035 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 61 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6001198.5187 | 2095714.51341 | 37.7345005324595 | -122.438274321504 | (37.7345005324595, -122.438274321504) | ||||
| 161559 | 161559 | 211006 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 600x Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 5997174.86391 | 2099677.95775 | 37.7451535147355 | -122.45247128193701 | (37.7451535147355, -122.452471281937) | |||
| 44978 | 44978 | 211007 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 600x Bosworth St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | Width 10ft | 6002197.80666 | 2095393.39137 | 37.7336755906519 | -122.43479650017001 | (37.7336755906519, -122.43479650017) | |||
| 120471 | 120471 | 2028 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 600X Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6002398.10054 | 2095366.8333154998 | 37.733614037905205 | -122.43410212847401 | (37.7336140379052, -122.434102128474) | |||
| 109599 | 109599 | 98161 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 600 Front St | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2011 12:00:00 AM | Permit Number 768589 | 6012888.4 | 2118392.6 | 37.7974274520849 | -122.39944985704099 | (37.7974274520849, -122.399449857041) | ||||
| 86719 | 86719 | 109347 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 59x BURNSIDE AVE | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6001229.7 | 2095779.3 | 37.7346801948558 | -122.438171157158 | (37.7346801948558, -122.438171157158) | ||||
| 41214 | 41214 | 211038 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6001171.81546 | 2095754.02956 | 37.7346075158123 | -122.43836947339199 | (37.7346075158123, -122.438369473392) | ||||
| 58985 | 58985 | 211040 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6001161.45161 | 2095717.9227900002 | 37.7345077855016 | -122.43840271862899 | (37.7345077855016, -122.438402718629) | ||||
| 156955 | 156955 | 211039 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 52 Burnside Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6001157.31367 | 2095726.26325 | 37.7345304511011 | -122.438417622186 | (37.7345304511011, -122.438417622186) | ||||
| 7041 | 7041 | 20305 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 11206 | 11206 | 20301 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 9922 | 9922 | 173745 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
| 9930 | 9930 | 173744 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
| 9932 | 9932 | 173746 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 500X Grand View Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000114.0 | 2102099.0 | 37.7519690677882 | -122.442482075417 | (37.7519690677882, -122.442482075417) | ||||
| 1103 | 1103 | 211013 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 44 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5991332.59313 | 2093509.69784 | 37.727880584217 | -122.47222310103399 | (37.727880584217, -122.472223101034) | |||
| 37669 | 37669 | 211009 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 25 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991341.559830001 | 2093667.8062200001 | 37.728315229259 | -122.472203623507 | (37.728315229259, -122.472203623507) | |||
| 50538 | 50538 | 211012 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 35 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991334.380059999 | 2093575.3838 | 37.7280610448729 | -122.47222170976102 | (37.7280610448729, -122.472221709761) | |||
| 148698 | 148698 | 211010 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 27 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991339.1010300005 | 2093646.61822 | 37.728256910008895 | -122.47221057976601 | (37.7282569100089, -122.472210579766) | |||
| 152330 | 152330 | 211015 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991307.93934 | 2093199.2311 | 37.727026693213794 | -122.47228570643101 | (37.7270266932138, -122.472285706431) | |||
| 156453 | 156453 | 211011 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 34 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991335.35345 | 2093583.37833 | 37.728083052188104 | -122.47221892726499 | (37.7280830521881, -122.472218927265) | |||
| 168152 | 168152 | 211014 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Junipero Serra Blvd | 53 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991322.30761 | 2093384.4785900002 | 37.7275361681597 | -122.4722495339 | (37.7275361681597, -122.4722495339) | |||
| 39138 | 39138 | 234477 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 500 Grand View Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999979.4834199995 | 2101750.0189 | 37.751003181959895 | -122.442922193204 | (37.7510031819599, -122.442922193204) | ||||
| 160510 | 160510 | 234472 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4810 17th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 2ft | 5998175.60392 | 2105685.14055 | 37.7617050378737 | -122.44944366388701 | (37.7617050378737, -122.449443663887) | |||
| 103200 | 103200 | 112912 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 480X BEACON ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 30 | 6002571.0 | 2098077.0 | 37.7410653426557 | -122.433697996676 | (37.7410653426557, -122.433697996676) | ||||
| 102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 103326 | 103326 | 96843 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 417 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | |||||
| 108306 | 108306 | 96844 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 417 Dewey Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995136.0 | 2100316.9 | 37.7467908665237 | -122.45956754031602 | (37.7467908665237, -122.459567540316) | |||||
| 135899 | 135899 | 211034 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 417 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5995115.077769999 | 2100328.51022 | 37.746821542199996 | -122.45964072765 | (37.7468215422, -122.45964072765) | |||
| 157213 | 157213 | 211033 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 417 Dewey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5995123.84893 | 2100332.4468799997 | 37.746832855650396 | -122.459610683101 | (37.7468328556504, -122.459610683101) | |||
| 96458 | 96458 | 116067 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 4150X CLEMENT ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");