Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105044 | 105044 | 108650 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
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) | ||||
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) | ||||
118847 | 118847 | 108695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 511 Alvarado St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774625 | 6003049.10666 | 2102687.45843 | 37.7537516993963 | -122.432374086122 | (37.7537516993963, -122.432374086122) | |
120360 | 120360 | 108653 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
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) | ||||
127002 | 127002 | 29755 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 532 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 6010020.30224 | 2119411.75263 | 37.800065518477 | -122.409446229453 | (37.800065518477, -122.409446229453) | |||
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) | ||||
133858 | 133858 | 38495 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1353 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/05/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40489 | 6006548.48859 | 2118678.2473299997 | 37.7978563596483 | -122.421407937635 | (37.7978563596483, -122.421407937635) |
139630 | 139630 | 108490 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1198 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773696 | 6009647.20295 | 2110306.76017 | 37.7750444852375 | -122.410094148747 | (37.7750444852375, -122.410094148747) |
144120 | 144120 | 114104 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 400x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 3x3 | 5988116.0 | 2090625.0 | 37.7197732605649 | -122.48313145165001 | (37.7197732605649, -122.48313145165) | |||
166496 | 166496 | 51593 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53890 | 5998519.8939 | 2110042.61 | 37.773689232881395 | -122.44856674553301 | (37.7736892328814, -122.448566745533) | |
13467 | 13467 | 15114 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014005.1464 | 2116140.60731 | 37.79130618976829 | -122.39542774681001 | (37.7913061897683, -122.39542774681) | |||
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) | |||
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) | |||
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) | |||
14513 | 14513 | 15112 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6013977.3910300005 | 2116114.5164400004 | 37.7912330065583 | -122.395521951701 | (37.7912330065583, -122.395521951701) | |||
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) | |||
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) | |||
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) | |||
16815 | 16815 | 15113 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6013991.513259999 | 2116128.24604 | 37.7912714903321 | -122.395474051105 | (37.7912714903321, -122.395474051105) | |||
16836 | 16836 | 15111 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6013962.82131 | 2116101.4847 | 37.79119641403479 | -122.395571449475 | (37.7911964140348, -122.395571449475) | |||
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) | |||
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) | |
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) | |||
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) | |||
88337 | 88337 | 96318 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011857.0 | 2120322.0 | 37.802667576079 | -122.403154578184 | (37.802667576079, -122.403154578184) | |||
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) | |||
107979 | 107979 | 96322 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
119723 | 119723 | 96319 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
128349 | 128349 | 96320 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
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) | |
139177 | 139177 | 96321 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
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) | |
93478 | 93478 | 115306 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1199x KEARNY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x5 | 6011157.0 | 2118940.0 | 37.7988338244478 | -122.405479555764 | (37.7988338244478, -122.405479555764) | ||||
164671 | 164671 | 64662 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2786 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1989 12:00:00 AM | 14 | 6x4 | Permit Number 26052 | 5999613.31909 | 2118454.39818 | 37.796848274496206 | -122.445389381638 | (37.7968482744962, -122.445389381638) | |
90896 | 90896 | 115305 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1199x KEARNY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x5 | 6011077.0 | 2118941.0 | 37.7988320967672 | -122.405756453764 | (37.7988320967672, -122.405756453764) | ||||
460 | 460 | 142327 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1652 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999940.0 | 2110256.0 | 37.774356244626205 | -122.44366972691601 | (37.7743562446262, -122.443669726916) | |||
30478 | 30478 | 140287 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998483.9171 | 2110037.6666 | 37.7736736024147 | -122.448690838206 | (37.7736736024147, -122.448690838206) | |||
55932 | 55932 | 143040 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1760 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6010444.0727 | 2120551.0606 | 37.8032175128046 | -122.408060206321 | (37.8032175128046, -122.408060206321) | |||
63604 | 63604 | 142487 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1527 STOCKTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6010095.4595 | 2119399.2703 | 37.800035455862606 | -122.409185274056 | (37.8000354558626, -122.409185274056) | |||
134068 | 134068 | 142927 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 501 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6011089.2103 | 2118971.3611 | 37.79891614378229 | -122.405716341604 | (37.7989161437823, -122.405716341604) | |||
146744 | 146744 | 140288 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998467.9884 | 2110034.371 | 37.7736636426957 | -122.44874570038 | (37.7736636426957, -122.44874570038) | |||
166582 | 166582 | 142921 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 546 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6009942.6265 | 2119419.3871 | 37.800082128353 | -122.409715557637 | (37.800082128353, -122.409715557637) | |||
171038 | 171038 | 142486 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1501 STOCKTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6010093.7913 | 2119417.8989 | 37.800086511961396 | -122.409192361945 | (37.8000865119614, -122.409192361945) | |||
185507 | 185507 | 140286 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998499.0219 | 2110040.6876 | 37.773682761016104 | -122.44863880622101 | (37.7736827610161, -122.448638806221) | |||
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) | |||
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) | |||
52414 | 52414 | 129846 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 485 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6011762.70539 | 2118367.67112 | 37.797296196209295 | -122.40334332133999 | (37.7972961962093, -122.40334332134) | |||
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) | |||
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) | |||
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) | |||
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) | |||
188297 | 188297 | 129845 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 485 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6011739.20457 | 2118363.85261 | 37.797284398923004 | -122.40342437184201 | (37.797284398923, -122.403424371842) | |||
2256 | 2256 | 200334 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 4 | : 4 | Tree 1 | Purchasing Dept 15 | 11/15/1992 12:00:00 AM | 8 | Width 3ft | 6015528.91481 | 2098358.82009 | 37.742565908900204 | -122.388913512973 | (37.7425659089002, -122.388913512973) | ||
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) | ||||
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) | |||
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) | |||
25678 | 25678 | 129817 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012643.50693 | 2117148.0023 | 37.793996430738 | -122.40020979915899 | (37.793996430738, -122.400209799159) | |||
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) | |||
28769 | 28769 | 129827 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012617.00039 | 2117213.20404 | 37.7941739812068 | -122.400306096749 | (37.7941739812068, -122.400306096749) | |||
29650 | 29650 | 129819 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012648.9601 | 2117092.8382099997 | 37.793845267304505 | -122.400187054399 | (37.7938452673045, -122.400187054399) | |||
30051 | 30051 | 129811 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012498.509190001 | 2117154.1734 | 37.794005289065794 | -122.40071194282801 | (37.7940052890658, -122.400711942828) | |||
31378 | 31378 | 129821 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012337.50928 | 2117203.47544 | 37.7941316797929 | -122.40127248843201 | (37.7941316797929, -122.401272488432) | |||
32083 | 32083 | 129818 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012648.53437 | 2117119.11483 | 37.79391739292829 | -122.400190373809 | (37.7939173929283, -122.400190373809) | |||
33596 | 33596 | 227938 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 25 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004713.51107 | 2103480.2352 | 37.756022715594604 | -122.426674645426 | (37.7560227155946, -122.426674645426) | |||
34082 | 34082 | 129826 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 510 Battery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012620.11049 | 2117309.3448900003 | 37.7944381345611 | -122.400302091187 | (37.7944381345611, -122.400302091187) | |||
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) | |||
35863 | 35863 | 129806 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6010377.17129 | 2116863.70379 | 37.793089185679705 | -122.40803152672702 | (37.7930891856797, -122.408031526727) | |||
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) | |||
38577 | 38577 | 129810 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012477.08259 | 2117150.1123 | 37.7939929431787 | -122.40078579605101 | (37.7939929431787, -122.400785796051) | |||
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) | |||
40130 | 40130 | 228846 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004252.08143 | 2104552.56077 | 37.758940969765 | -122.428346847525 | (37.758940969765, -122.428346847525) | |||
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) | |||
41186 | 41186 | 228842 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1010 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999127.094409999 | 2106474.67422 | 37.7639272833421 | -122.446209649681 | (37.7639272833421, -122.446209649681) | |||
43828 | 43828 | 208173 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994847.17518 | 2099430.14012 | 37.744339434016794 | -122.460502016448 | (37.7443394340168, -122.460502016448) | |||
45773 | 45773 | 129823 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Battery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012601.68821 | 2117444.3368599997 | 37.7948077631249 | -122.40037532116501 | (37.7948077631249, -122.400375321165) | |||
46581 | 46581 | 228841 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 65 Homestead St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000998.7373 | 2101290.13943 | 37.749798521207204 | -122.439364559745 | (37.7497985212072, -122.439364559745) | |||
47917 | 47917 | 129784 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1600 Montgomery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6011334.32807 | 2120989.68408 | 37.8044716700829 | -122.405010336152 | (37.8044716700829, -122.405010336152) | |||
50680 | 50680 | 129764 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.89602 | 2118659.8041 | 37.7977976222176 | -122.42190349824101 | (37.7977976222176, -122.421903498241) | |||
57959 | 57959 | 129812 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012517.23545 | 2117156.65433 | 37.794013145532 | -122.40064732203301 | (37.794013145532, -122.400647322033) | |||
59650 | 59650 | 129831 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012476.45918 | 2117195.3094900004 | 37.7941170091435 | -122.40079112993 | (37.7941170091435, -122.40079112993) | |||
62252 | 62252 | 227934 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1731 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005814.854180001 | 2107243.32997 | 37.7664174935056 | -122.423133300469 | (37.7664174935056, -122.423133300469) | |||
62703 | 62703 | 129830 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012498.4118 | 2117199.54922 | 37.794129874847606 | -122.400715469043 | (37.7941298748476, -122.400715469043) | |||
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) | |||
66960 | 66960 | 200333 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 903 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015264.35575 | 2104459.34943 | 37.7593020107061 | -122.39025440841002 | (37.7593020107061, -122.39025440841) | |||
67539 | 67539 | 129822 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012331.01864 | 2117278.3358 | 37.7943368663928 | -122.401300210056 | (37.7943368663928, -122.401300210056) | |||
68851 | 68851 | 228850 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.71901 | 2104547.0578 | 37.7589211990752 | -122.42863130311501 | (37.7589211990752, -122.428631303115) | |||
69203 | 69203 | 129829 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012523.949659999 | 2117203.16491 | 37.7941412269928 | -122.400627358876 | (37.7941412269928, -122.400627358876) | |||
72002 | 72002 | 129820 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 241 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012651.85549 | 2117070.09364 | 37.7937829775554 | -122.400175437873 | (37.7937829775554, -122.400175437873) | |||
72713 | 72713 | 208168 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991441.450619999 | 2097800.63089 | 37.7396687033598 | -122.472159425416 | (37.7396687033598, -122.472159425416) | |||
73201 | 73201 | 228843 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 707 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007452.7290199995 | 2097768.34677 | 37.7404936415683 | -122.416796844595 | (37.7404936415683, -122.416796844595) | |||
75033 | 75033 | 228849 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004184.64448 | 2104547.65023 | 37.75892367042171 | -122.42857972608499 | (37.7589236704217, -122.428579726085) | |||
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) | |||
75521 | 75521 | 228848 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004199.57922 | 2104548.6925 | 37.7589273774242 | -122.42852814905599 | (37.7589273774242, -122.428528149056) | |||
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) | |||
113875 | 113875 | 129759 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1827 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008241.72856 | 2118745.4751 | 37.7981362718366 | -122.415553596641 | (37.7981362718366, -122.415553596641) | |||
130005 | 130005 | 129813 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012536.38879 | 2117159.9438 | 37.794023245839796 | -122.400581280298 | (37.7940232458398, -122.400581280298) | |||
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) | |||
131501 | 131501 | 129770 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012963.296490001 | 2119273.7997 | 37.7998511899251 | -122.39925258414499 | (37.7998511899251, -122.399252584145) |
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");