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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 187663 | 187663 | 129748 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000804.68172 | 2119664.29702 | 37.800238273442396 | -122.441353858292 | (37.8002382734424, -122.441353858292) | |||
| 187504 | 187504 | 129778 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012744.14452 | 2119292.42038 | 37.7998901017986 | -122.400012245068 | (37.7998901017986, -122.400012245068) | |||
| 187275 | 187275 | 129839 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 238 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012727.894069999 | 2118536.52905 | 37.7978136994111 | -122.400015365729 | (37.7978136994111, -122.400015365729) | |||
| 186583 | 186583 | 200362 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.39349559025801 | (37.7374749933851, -122.393495590258) | |||
| 186385 | 186385 | 129789 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011950.175319999 | 2119985.5388 | 37.80174893842371 | -122.402808465741 | (37.8017489384237, -122.402808465741) | |||
| 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) | |||
| 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) | |||
| 185432 | 185432 | 129825 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012609.836569999 | 2117389.63944 | 37.79465803140361 | -122.400343282842 | (37.7946580314036, -122.400343282842) | |||
| 184232 | 184232 | 129802 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6010252.4995 | 2116845.85776 | 37.79303320378 | -122.40846164098801 | (37.79303320378, -122.408461640988) | |||
| 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) | |||
| 181097 | 181097 | 208169 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991440.6028 | 2097828.1323700002 | 37.7397441663462 | -122.472164360908 | (37.7397441663462, -122.472164360908) | |||
| 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) | |||
| 180032 | 180032 | 129815 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012587.02488 | 2117167.29458 | 37.7940462531923 | -122.400406589716 | (37.7940462531923, -122.400406589716) | |||
| 179760 | 179760 | 129847 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 103 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6012509.67235 | 2118803.01279 | 37.798533230779 | -122.40078920986099 | (37.798533230779, -122.400789209861) | |||
| 178649 | 178649 | 122998 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 42 07th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5993660.47545 | 2115225.1028 | 37.7876399054327 | -122.465752700208 | (37.7876399054327, -122.465752700208) | |||
| 178038 | 178038 | 129844 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Battery St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6012469.34241 | 2118758.9010099997 | 37.7984098608851 | -122.40092566398899 | (37.7984098608851, -122.400925663989) | |||
| 177605 | 177605 | 129841 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 238 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6012688.5511300005 | 2118531.3338 | 37.7977972409088 | -122.400151139076 | (37.7977972409088, -122.400151139076) | |||
| 176983 | 176983 | 129765 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006424.31939 | 2118660.7850599997 | 37.797801411063396 | -122.421836357588 | (37.7978014110634, -122.421836357588) | |||
| 176440 | 176440 | 62970 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1827 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1986 12:00:00 AM | 10 | Permit Number 23357 | 6008241.174219999 | 2118766.33453 | 37.7981935154844 | -122.41555699245701 | (37.7981935154844, -122.415556992457) | |
| 175699 | 175699 | 200345 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 4ft | 6014658.54117 | 2097192.95407 | 37.7393164002222 | -122.391841530176 | (37.7393164002222, -122.391841530176) | |||
| 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) | |||
| 173137 | 173137 | 227935 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 705 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6008535.61915 | 2104408.30699 | 37.7587863358342 | -122.413522114462 | (37.7587863358342, -122.413522114462) | |||
| 173134 | 173134 | 129761 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2222 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006380.65068 | 2118525.27839 | 37.797426881191896 | -122.421977832627 | (37.7974268811919, -122.421977832627) | |||
| 172062 | 172062 | 129771 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6012935.02914 | 2119270.4372 | 37.79984038189279 | -122.399350164196 | (37.7998403818928, -122.399350164196) | |||
| 171591 | 171591 | 129797 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6011917.15823 | 2120261.12287 | 37.802503781689204 | -122.402942114884 | (37.8025037816892, -122.402942114884) | |||
| 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) | |||
| 170579 | 170579 | 228847 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004213.13115 | 2104548.41319 | 37.758927377407 | -122.42848126022699 | (37.758927377407, -122.428481260227) | |||
| 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) | |||
| 169758 | 169758 | 208167 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2590 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991441.567009999 | 2097783.56953 | 37.7396218639513 | -122.47215777968201 | (37.7396218639513, -122.472157779682) | |||
| 169282 | 169282 | 200361 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.39344438196699 | (37.7375336444497, -122.393444381967) | |||
| 169203 | 169203 | 129777 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012748.89649 | 2119266.86751 | 37.79982020469429 | -122.399994005922 | (37.7998202046943, -122.399994005922) | |||
| 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) | |||
| 168945 | 168945 | 39385 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 9 | Permit Number 40925 | 6000567.4477 | 2117199.7395900004 | 37.7934577323376 | -122.441997780973 | (37.7934577323376, -122.441997780973) | ||
| 168728 | 168728 | 129828 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012548.895219999 | 2117204.8631700003 | 37.7941472812331 | -122.400541163364 | (37.7941472812331, -122.400541163364) | |||
| 168594 | 168594 | 200346 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6014640.20968 | 2097167.32462 | 37.7392450093596 | -122.391903121137 | (37.7392450093596, -122.391903121137) | |||
| 168339 | 168339 | 49588 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2333 REVISED Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2003 12:00:00 AM | 16 | Permit Number 46464 | 6003709.90767 | 2116419.2146400004 | 37.7914931831193 | -122.431068901134 | (37.7914931831193, -122.431068901134) | ||
| 168272 | 168272 | 129750 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2320 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000760.50701 | 2119657.6711 | 37.800217563850296 | -122.44150624394301 | (37.8002175638503, -122.441506243943) | |||
| 167735 | 167735 | 129788 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011956.16596 | 2119957.68161 | 37.8016727838339 | -122.402785774963 | (37.8016727838339, -122.402785774963) | |||
| 167501 | 167501 | 129749 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000782.42382 | 2119661.2506 | 37.8002286408033 | -122.44143066041599 | (37.8002286408033, -122.441430660416) | |||
| 167176 | 167176 | 200363 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6014137.38405 | 2096492.6896799998 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | |||
| 167118 | 167118 | 129840 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 238 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012708.88892 | 2118533.80702 | 37.79780516574421 | -122.400080938001 | (37.7978051657442, -122.400080938001) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 161111 | 161111 | 129785 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011966.59622 | 2119867.2001900002 | 37.8014249261853 | -122.402743314356 | (37.8014249261853, -122.402743314356) | |||
| 161074 | 161074 | 129768 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 489 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011131.656690001 | 2118977.1984099997 | 37.7989345451634 | -122.40556987367201 | (37.7989345451634, -122.405569873672) | |||
| 160462 | 160462 | 177154 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 734 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6005364.09678 | 2092392.61851 | 37.725615388036104 | -122.42363641630301 | (37.7256153880361, -122.423636416303) | |||
| 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) | |||
| 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) | |||
| 158244 | 158244 | 129814 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012557.97886 | 2117161.9578299997 | 37.7940299799473 | -122.40050671752199 | (37.7940299799473, -122.400506717522) | |||
| 157370 | 157370 | 129766 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1375 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6006461.42741 | 2118668.07402 | 37.797823517302206 | -122.42170847129199 | (37.7978235173022, -122.421708471292) | |||
| 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) | |||
| 156540 | 156540 | 129834 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 733 Front St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6012777.11642 | 2118676.9470599997 | 37.7982019978752 | -122.399854906882 | (37.7982019978752, -122.399854906882) | |||
| 156528 | 156528 | 129824 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012608.14 | 2117404.20841 | 37.794697939723704 | -122.40035017702499 | (37.7946979397237, -122.400350177025) | |||
| 155277 | 155277 | 228844 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 709 Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007473.725769999 | 2097767.91667 | 37.7404936415809 | -122.416724215363 | (37.7404936415809, -122.416724215363) | |||
| 154064 | 154064 | 208170 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1225 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 5996717.7598 | 2107182.54151 | 37.7657330159006 | -122.454593911282 | (37.7657330159006, -122.454593911282) | |||
| 153734 | 153734 | 129816 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 433 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6012609.05006 | 2117170.5257599996 | 37.7940563534572 | -122.400330606896 | (37.7940563534572, -122.400330606896) | |||
| 152581 | 152581 | 129751 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2320 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000742.15542 | 2119656.12238 | 37.8002122659526 | -122.44156963624201 | (37.8002122659526, -122.441569636242) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 151663 | 151663 | 129773 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012883.50017 | 2119263.61 | 37.799818763986295 | -122.399527995233 | (37.7998187639863, -122.399527995233) | |||
| 151570 | 151570 | 129805 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6010365.088819999 | 2116862.85785 | 37.793086186442 | -122.40807327328899 | (37.793086186442, -122.408073273289) | |||
| 151478 | 151478 | 228845 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 4526 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6001290.00365 | 2104097.6707200003 | 37.7575238972389 | -122.438558485713 | (37.7575238972389, -122.438558485713) | |||
| 151057 | 151057 | 129786 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011965.83445 | 2119897.8199 | 37.8015089579449 | -122.402748105054 | (37.8015089579449, -122.402748105054) | |||
| 149913 | 149913 | 129804 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6010351.68054 | 2116862.21581 | 37.793083672815705 | -122.408119621635 | (37.7930836728157, -122.408119621635) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 145599 | 145599 | 17635 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 145231 | 145231 | 68365 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 945 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32186 | 6010298.82314684 | 2116844.8632648997 | 37.7930330672197 | -122.40830128766501 | (37.7930330672197, -122.408301287665) | ||
| 145002 | 145002 | 17644 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 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) | |||
| 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) | |||
| 142828 | 142828 | 50615 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2004 12:00:00 AM | Permit Number 47216 | 6004288.29588296 | 2104553.28636794 | 37.7589450112214 | -122.42822165267 | (37.7589450112214, -122.42822165267) | |||
| 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) |
| 139418 | 139418 | 100697 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 4 | 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) | |||
| 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) | |||
| 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) | |||
| 138977 | 138977 | 32406 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 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) | |||
| 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) | |||
| 136849 | 136849 | 208174 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 170 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994830.69157 | 2099413.59203 | 37.7442930488025 | -122.460557814002 | (37.7442930488025, -122.460557814002) | |||
| 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) | |||
| 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) | |||
| 134397 | 134397 | 129803 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6010302.01456 | 2116853.58579 | 37.7930571958732 | -122.408290860643 | (37.7930571958732, -122.408290860643) | |||
| 134375 | 134375 | 39384 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000588.20452 | 2117202.1206900002 | 37.793465453027395 | -122.441926131987 | (37.7934654530274, -122.441926131987) | ||
| 134069 | 134069 | 124474 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 344 Willard St North | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996301.59979 | 2110522.81259 | 37.7748806555631 | -122.45627485050899 | (37.7748806555631, -122.456274850509) | |||
| 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) | |||
| 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) |
| 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) | |||
| 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) | |||
| 131803 | 131803 | 129772 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6012910.450180001 | 2119266.99952 | 37.799829572932296 | -122.39943497565099 | (37.7998295729323, -122.399434975651) | |||
| 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) | |||
| 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) |
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");