Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 151751 | 151751 | 200344 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 40 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015132.05324 | 2097828.30985 | 37.74108723188171 | -122.390248699517 | (37.7410872318817, -122.390248699517) | |||
| 159507 | 159507 | 200343 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 39 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6015141.18947 | 2097840.20057 | 37.741120388109294 | -122.39021794000799 | (37.7411203881093, -122.390217940008) | |||
| 111666 | 111666 | 49232 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 144578 | 144578 | 49226 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 42998 | 42998 | 200342 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 25 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015273.793930001 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | |||
| 76523 | 76523 | 200341 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 24 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015282.07626 | 2098027.6206799997 | 37.74164281866221 | -122.389743887597 | (37.7416428186622, -122.389743887597) | |||
| 72490 | 72490 | 200340 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 23 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015300.13853 | 2098052.9717 | 37.7417134289277 | -122.38968320401399 | (37.7417134289277, -122.389683204014) | |||
| 116184 | 116184 | 49225 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 137367 | 137367 | 200339 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6015308.33502 | 2098065.1650799997 | 37.741747363937606 | -122.389655714464 | (37.7417473639376, -122.389655714464) | |||
| 57768 | 57768 | 200357 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6014316.3111 | 2096732.3588400001 | 37.73803269625021 | -122.392992601233 | (37.7380326962502, -122.392992601233) | |||
| 160126 | 160126 | 200338 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 21 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6015318.39191 | 2098076.99567 | 37.7417804059521 | -122.389621766852 | (37.7417804059521, -122.389621766852) | |||
| 136918 | 136918 | 200356 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014331.3129900005 | 2096752.73935 | 37.7380894902424 | -122.39294215736601 | (37.7380894902424, -122.392942157366) | |||
| 88835 | 88835 | 49214 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 134636 | 134636 | 200355 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 19 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6014345.08354 | 2096773.3910700001 | 37.7381469605042 | -122.392895989784 | (37.7381469605042, -122.392895989784) | |||
| 164517 | 164517 | 200354 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014359.7983 | 2096791.80766 | 37.7381983459865 | -122.392846401168 | (37.7381983459865, -122.392846401168) | |||
| 11610 | 11610 | 35704 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 133126 | 133126 | 200353 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 17 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6014392.43301 | 2096834.63166 | 37.738317744462 | -122.392736560653 | (37.738317744462, -122.392736560653) | |||
| 15799 | 15799 | 35703 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 57963 | 57963 | 200352 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 16 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 6014405.80816 | 2096853.92235 | 37.7383714555731 | -122.392691664697 | (37.7383714555731, -122.392691664697) | |||
| 1981 | 1981 | 35702 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 135542 | 135542 | 200351 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6014421.213330001 | 2096874.8296 | 37.73842971815 | -122.39263986285 | (37.73842971815, -122.39263986285) | |||
| 5612 | 5612 | 35700 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 14850 | 14850 | 35701 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 75153 | 75153 | 49224 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 4102 | 4102 | 253611 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6012712.81893 | 2119514.81479 | 37.8004989968021 | -122.400136271497 | (37.8004989968021, -122.400136271497) | ||||
| 146537 | 146537 | 200350 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6014508.81125 | 2096991.75117 | 37.738755625282394 | -122.39234516490299 | (37.7387556252824, -122.392345164903) | |||
| 10284 | 10284 | 35699 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 25573 | 25573 | 129783 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012712.81893 | 2119514.81479 | 37.8004989968021 | -122.400136271497 | (37.8004989968021, -122.400136271497) | |||
| 31300 | 31300 | 200349 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6014526.629869999 | 2097016.7538700001 | 37.738825266977294 | -122.392285304228 | (37.7388252669773, -122.392285304228) | |||
| 99398 | 99398 | 49230 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 127590 | 127590 | 27659 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014051.97429 | 2116162.8349200003 | 37.7913698260154 | -122.395267279985 | (37.7913698260154, -122.395267279985) | |||
| 8272 | 8272 | 35698 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 14159 | 14159 | 15120 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014101.62567 | 2116233.31764 | 37.791566116339204 | -122.395100425058 | (37.7915661163392, -122.395100425058) | |||
| 40723 | 40723 | 200348 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 10 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6014546.28219 | 2097041.8855599998 | 37.738895364638 | -122.39221911232599 | (37.738895364638, -122.392219112326) | |||
| 72647 | 72647 | 200369 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 650 Townsend St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011472.2786 | 2108553.20224 | 37.7703317423487 | -122.403657370911 | (37.7703317423487, -122.403657370911) | |||
| 180399 | 180399 | 129782 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6012716.05958 | 2119492.7044900004 | 37.800438467927606 | -122.40012350379601 | (37.8004384679276, -122.400123503796) | |||
| 15690 | 15690 | 35690 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 16130 | 16130 | 15119 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014087.04677 | 2116219.82682 | 37.7915282629576 | -122.395149922854 | (37.7915282629576, -122.395149922854) | |||
| 34338 | 34338 | 129793 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6011934.29934 | 2120106.56325 | 37.8020803556973 | -122.402871921008 | (37.8020803556973, -122.402871921008) | |||
| 85027 | 85027 | 96326 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 89939 | 89939 | 108657 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
| 92402 | 92402 | 17639 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 6 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 105063 | 105063 | 200347 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6014556.031830001 | 2097054.78425 | 37.7389313231291 | -122.392186304173 | (37.7389313231291, -122.392186304173) | |||
| 112760 | 112760 | 200367 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 17 | Width 5ft | 6014030.85339 | 2096351.6806400002 | 37.7369715717905 | -122.393952936896 | (37.7369715717905, -122.393952936896) | |||
| 170047 | 170047 | 129781 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012720.0769 | 2119456.93183 | 37.8003404688016 | -122.40010708848 | (37.8003404688016, -122.40010708848) | |||
| 181981 | 181981 | 129801 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011895.86595 | 2120414.05559 | 37.8029225087266 | -122.40302656033701 | (37.8029225087266, -122.403026560337) | |||
| 185785 | 185785 | 200337 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 9 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6015484.2575199995 | 2098301.13552 | 37.742405043569796 | -122.389063899405 | (37.7424050435698, -122.389063899405) | |||
| 7342 | 7342 | 35697 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 14190 | 14190 | 15118 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014060.69419 | 2116194.6265 | 37.7914576032294 | -122.395239337045 | (37.7914576032294, -122.395239337045) | |||
| 19672 | 19672 | 96325 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2011 12:00:00 AM | 5 | 4x4 | Permit Number 768012 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |
| 25127 | 25127 | 200366 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014047.106269999 | 2096372.4575200002 | 37.7370295240776 | -122.393898196954 | (37.7370295240776, -122.393898196954) | |||
| 28250 | 28250 | 129809 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6010417.7029 | 2116870.15869 | 37.7931091785103 | -122.40789173971399 | (37.7931091785103, -122.407891739714) | |||
| 34108 | 34108 | 129780 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012726.999559999 | 2119408.50299 | 37.800207880833895 | -122.400079730213 | (37.8002078808339, -122.400079730213) | |||
| 76914 | 76914 | 129776 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012790.20467 | 2119250.54506 | 37.7997776901326 | -122.39984991653601 | (37.7997776901326, -122.399849916536) | |||
| 83164 | 83164 | 17638 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 100107 | 100107 | 100701 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 124448 | 124448 | 108656 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
| 131138 | 131138 | 129792 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011937.51445 | 2120075.46294 | 37.8019951413282 | -122.402858606545 | (37.8019951413282, -122.402858606545) | |||
| 149570 | 149570 | 129755 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003208.43493 | 2116180.994 | 37.7908106615232 | -122.432786962347 | (37.7908106615232, -122.432786962347) | |||
| 166431 | 166431 | 200336 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511002 | (37.7424425848476, -122.38903282511) | |||
| 2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
| 11246 | 11246 | 35705 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15920 | 15920 | 15117 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014044.26076 | 2116180.71375 | 37.7914184881275 | -122.39529522181401 | (37.7914184881275, -122.395295221814) | |||
| 38087 | 38087 | 129808 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6010404.49438 | 2116867.87948 | 37.7931021808659 | -122.40793728139201 | (37.7931021808659, -122.407937281392) | |||
| 40999 | 40999 | 129775 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012820.869469999 | 2119255.17116 | 37.799792101768396 | -122.399744129295 | (37.7997921017684, -122.399744129295) | |||
| 47233 | 47233 | 129800 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011900.25036 | 2120353.89385 | 37.802757564074604 | -122.40300715386101 | (37.8027575640746, -122.403007153861) | |||
| 63351 | 63351 | 200365 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6014060.81183 | 2096393.5404700001 | 37.7370881751809 | -122.39385228564801 | (37.7370881751809, -122.393852285648) | |||
| 65614 | 65614 | 228852 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004131.71858 | 2104545.14122 | 37.7589137859482 | -122.428762589748 | (37.7589137859482, -122.428762589748) | |||
| 91499 | 91499 | 96324 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 104908 | 104908 | 17662 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 116186 | 116186 | 108655 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
| 128611 | 128611 | 103111 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 300 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010691.0 | 2115198.3 | 37.7885339521538 | -122.40682822806002 | (37.7885339521538, -122.40682822806) | ||||
| 129389 | 129389 | 97178 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774483 | 6004147.2 | 2104574.7 | 37.75899582353679 | -122.428711154895 | (37.7589958235368, -122.428711154895) | |
| 132351 | 132351 | 129779 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012731.79119 | 2119371.92723 | 37.800107719749604 | -122.400060579146 | (37.8001077197496, -122.400060579146) | |||
| 139348 | 139348 | 100700 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 152362 | 152362 | 129754 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003179.18897 | 2116177.33789 | 37.7907989640458 | -122.43288789058902 | (37.7907989640458, -122.432887890589) | |||
| 169005 | 169005 | 129791 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011942.54079 | 2120045.79904 | 37.801913972121895 | -122.402839125451 | (37.8019139721219, -122.402839125451) | |||
| 174249 | 174249 | 129833 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012379.779080001 | 2117177.7039400004 | 37.794063275551295 | -122.40112441775601 | (37.7940632755513, -122.401124417756) | |||
| 12226 | 12226 | 35696 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 15272 | 15272 | 15116 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6014033.6168599995 | 2116167.8327099998 | 37.7913825278275 | -122.39533114703 | (37.7913825278275, -122.39533114703) | |||
| 23670 | 23670 | 129807 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6010390.20829 | 2116866.53247 | 37.793097682469394 | -122.407986617304 | (37.7930976824694, -122.407986617304) | |||
| 35845 | 35845 | 129762 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2222 Polk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6006368.54903 | 2118610.8656 | 37.797661199562995 | -122.422025790757 | (37.797661199563, -122.422025790757) | |||
| 40031 | 40031 | 129832 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012451.480280001 | 2117191.95794 | 37.7941064133197 | -122.400877324536 | (37.7941064133197, -122.400877324536) | |||
| 75415 | 75415 | 129774 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012849.953480001 | 2119259.82939 | 37.7998065134132 | -122.39964381442499 | (37.7998065134132, -122.399643814425) | |||
| 84349 | 84349 | 96323 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 85032 | 85032 | 17636 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 85402 | 85402 | 100699 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 87807 | 87807 | 17661 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 91400 | 91400 | 49223 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 500 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46300 | 6013774.5913005 | 2115138.38416874 | 37.7885414925604 | -122.39615519799999 | (37.7885414925604, -122.396155198) | |||
| 94447 | 94447 | 17645 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 10 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 114000 | 114000 | 108654 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
| 131059 | 131059 | 129790 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011945.5166 | 2120015.1346299998 | 37.8018299412604 | -122.40282666982401 | (37.8018299412604, -122.402826669824) | |||
| 131468 | 131468 | 129753 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003149.59406 | 2116175.6254 | 37.790792583373104 | -122.43299016506901 | (37.7907925833731, -122.432990165069) | |||
| 146016 | 146016 | 108433 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222x Cumberland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774483 | 6004156.2455400005 | 2104544.03717 | 37.758912142621206 | -122.428677685352 | (37.7589121426212, -122.428677685352) | |
| 151732 | 151732 | 228851 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004146.65332 | 2104546.1831400003 | 37.7589174920696 | -122.42871101271002 | (37.7589174920696, -122.42871101271) | |||
| 157215 | 157215 | 200364 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6014077.799769999 | 2096412.7772 | 37.7371419393345 | -122.393794896313 | (37.7371419393345, -122.393794896313) | |||
| 165053 | 165053 | 129799 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6011905.71705 | 2120324.1253400003 | 37.8026761322601 | -122.4029861412 | (37.8026761322601, -122.4029861412) | |||
| 11560 | 11560 | 35695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 13924 | 13924 | 15115 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014020.20981 | 2116155.23725 | 37.7913471979732 | -122.395376652733 | (37.7913471979732, -122.395376652733) | |||
| 35454 | 35454 | 129838 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 733 Front St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012789.03405 | 2118594.11911 | 37.797975236527904 | -122.39980784898 | (37.7979752365279, -122.39980784898) |
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");