Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189012 | 189012 | 126364 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6007584.0296 | 2119571.97409 | 37.8003686400458 | -122.41788805230699 | (37.8003686400458, -122.417888052307) | |||
| 188575 | 188575 | 223004 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 671 Church St | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6004322.20484 | 2105083.5512599996 | 37.760402911294996 | -122.428142169046 | (37.760402911295, -122.428142169046) | |||
| 188442 | 188442 | 190912 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 649 Delancey St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6015785.04565 | 2113121.03731 | 37.7831139729835 | -122.38905836406799 | (37.7831139729835, -122.389058364068) | |||
| 187861 | 187861 | 206442 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 488 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 5992758.93765 | 2090436.99405 | 37.719526135091 | -122.467068932605 | (37.719526135091, -122.467068932605) | |||
| 186880 | 186880 | 206444 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 75 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 23 | 5992169.96835 | 2088350.8654599998 | 37.71376411849379 | -122.46895303206301 | (37.7137641184938, -122.468953032063) | ||||
| 186381 | 186381 | 206462 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 100x Casitas Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5995528.33875 | 2096982.8424099998 | 37.7376589218079 | -122.457969641597 | (37.7376589218079, -122.457969641597) | |||
| 186279 | 186279 | 126369 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1306x Montgomery St | 30 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6011435.17205 | 2120070.79941 | 37.801954274322206 | -122.404596630044 | (37.8019542743222, -122.404596630044) | |||
| 185520 | 185520 | 206438 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Marietta Dr | 50 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5999556.5851300005 | 2097486.39574 | 37.73927217785771 | -122.44407828610001 | (37.7392721778577, -122.4440782861) | |||
| 184948 | 184948 | 190916 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 61 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012503.648130001 | 2102901.04205 | 37.754869723572895 | -122.39969292101601 | (37.7548697235729, -122.399692921016) | ||||
| 183497 | 183497 | 222981 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1101 San Jose Ave | 65 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005028.12161 | 2096593.96399 | 37.737132377752104 | -122.42509665898899 | (37.7371323777521, -122.425096658989) | |||
| 183440 | 183440 | 126366 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 MacOndray Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 56 | 6008010.57204 | 2119080.4393700003 | 37.799043004282204 | -122.41637720656401 | (37.7990430042822, -122.416377206564) | ||||
| 182149 | 182149 | 206441 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 45 Margaret Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5997090.058680001 | 2089794.4629099998 | 37.718010942936296 | -122.45205157193001 | (37.7180109429363, -122.45205157193) | |||
| 181045 | 181045 | 223003 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 198 Corbin Pl | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000086.83847 | 2105686.0969700003 | 37.761816809226 | -122.442833562346 | (37.761816809226, -122.442833562346) | |||
| 179249 | 179249 | 206474 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 230 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 5998806.12443 | 2095305.20487 | 37.73324030618979 | -122.446516151203 | (37.7332403061898, -122.446516151203) | ||||
| 177617 | 177617 | 176070 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 700x Mansell St | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 6009191.21918 | 2089961.56598 | 37.7191555154919 | -122.410234749751 | (37.7191555154919, -122.410234749751) | |||
| 176459 | 176459 | 126358 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 2700 Larkin St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6006530.21172 | 2120848.5144700003 | 37.803814332215 | -122.42162540359301 | (37.803814332215, -122.421625403593) | |||
| 176375 | 176375 | 190910 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1802 Shoup Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6013180.92489 | 2093690.4746700001 | 37.72961717688629 | -122.396705035035 | (37.7296171768863, -122.396705035035) | ||||
| 175721 | 175721 | 108733 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 12X MacOndray Ln | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6008571.7216300005 | 2119174.99094 | 37.7993341588901 | -122.41444212811001 | (37.7993341588901, -122.41444212811) | ||||
| 175390 | 175390 | 206490 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5994866.12622 | 2099244.72495 | 37.743831420489 | -122.460423055998 | (37.743831420489, -122.460423055998) | |||
| 173579 | 173579 | 206485 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5995003.2981 | 2099247.81347 | 37.7438477908555 | -122.45994897477301 | (37.7438477908555, -122.459948974773) | |||
| 171855 | 171855 | 206448 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3804 19th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 5990608.23629 | 2090475.9757700001 | 37.7195087925673 | -122.474505889762 | (37.7195087925673, -122.474505889762) | |||
| 169745 | 169745 | 176068 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 700x Mansell St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6009458.20535 | 2090043.50806 | 37.7193954735114 | -122.409317656201 | (37.7193954735114, -122.409317656201) | |||
| 169293 | 169293 | 246769 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 Waltham St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009290.58304 | 2098917.85967 | 37.7437531542765 | -122.410523388038 | (37.7437531542765, -122.410523388038) | ||||
| 169170 | 169170 | 206464 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 171 Burnside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6001095.15632 | 2095353.3588299998 | 37.733503006263206 | -122.438605809815 | (37.7335030062632, -122.438605809815) | |||
| 167769 | 167769 | 206461 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 100x Casitas Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5995522.71914 | 2096987.57001 | 37.7376715797638 | -122.457989413181 | (37.7376715797638, -122.457989413181) | |||
| 167663 | 167663 | 206450 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 500 Junipero Serra Blvd | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991349.40355 | 2093772.6376200002 | 37.728603524012605 | -122.472184145995 | (37.7286035240126, -122.472184145995) | |||
| 167393 | 167393 | 126367 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 12 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6008558.648680001 | 2119172.9159 | 37.799327726940206 | -122.414487218323 | (37.7993277269402, -122.414487218323) | ||||
| 167246 | 167246 | 206445 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 5992171.9093 | 2088272.93373 | 37.7135502489179 | -122.46894065561001 | (37.7135502489179, -122.46894065561) | ||||
| 166602 | 166602 | 222991 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6002568.09263 | 2099485.22731 | 37.7449318417374 | -122.433808677655 | (37.7449318417374, -122.433808677655) | ||||
| 165674 | 165674 | 190920 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 895 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6011337.392000001 | 2104186.3171900003 | 37.7583337232325 | -122.40381661744499 | (37.7583337232325, -122.403816617445) | ||||
| 163403 | 163403 | 249831 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 339 Greenwich St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 0ft | 6011175.54294 | 2120361.5959799998 | 37.802738216951 | -122.40551556628999 | (37.802738216951, -122.40551556629) | |||
| 163318 | 163318 | 223000 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3949 21st St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6002182.77981 | 2103520.33537 | 37.7559894181953 | -122.435429612092 | (37.7559894181953, -122.435429612092) | ||||
| 162608 | 162608 | 206460 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 100x Casitas Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5995511.53066 | 2096986.44816 | 37.737667856597 | -122.458028015699 | (37.737667856597, -122.458028015699) | |||
| 161777 | 161777 | 206468 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999438.31164 | 2095424.2853299999 | 37.7336033624897 | -122.444339069698 | (37.7336033624897, -122.444339069698) | ||||
| 161052 | 161052 | 206473 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 55 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 10ft | 5999743.81209 | 2095477.4356 | 37.7337667261604 | -122.443286685744 | (37.7337667261604, -122.443286685744) | |||
| 160591 | 160591 | 223009 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1201 San Jose Ave | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004330.294419999 | 2095981.9805599998 | 37.7354125646335 | -122.42746577992399 | (37.7354125646335, -122.427465779924) | ||||
| 160127 | 160127 | 222990 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | 6002575.82203 | 2099485.9676200002 | 37.744934313062004 | -122.433782003739 | (37.744934313062, -122.433782003739) | ||||
| 159403 | 159403 | 126363 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6007594.767469999 | 2119573.62389 | 37.8003737742816 | -122.417851011923 | (37.8003737742816, -122.417851011923) | |||
| 159350 | 159350 | 249676 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 2400 Baker St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5999736.34659 | 2117174.55896 | 37.7933411972934 | -122.444871632924 | (37.7933411972934, -122.444871632924) | ||||
| 159155 | 159155 | 206478 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Terrace Dr | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5993823.40178 | 2096528.08405 | 37.7363121645844 | -122.463831379524 | (37.7363121645844, -122.463831379524) | ||||
| 158975 | 158975 | 222978 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 749 Dolores St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6005048.47497 | 2104094.54483 | 37.7577283976651 | -122.42555994653799 | (37.7577283976651, -122.425559946538) | |||
| 157384 | 157384 | 176071 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1x Tioga Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | Width 0ft | 6011377.4831300005 | 2088627.0408599998 | 37.7156134870441 | -122.402583833071 | (37.7156134870441, -122.402583833071) | |||
| 157242 | 157242 | 206484 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995031.51325 | 2099251.39623 | 37.7438592509066 | -122.459851673524 | (37.7438592509066, -122.459851673524) | |||
| 156869 | 156869 | 247635 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 351 Bradford St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6009489.54624 | 2096539.61504 | 37.73723416391479 | -122.409667589601 | (37.7372341639148, -122.409667589601) | ||||
| 156685 | 156685 | 206432 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1501 16th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 6ft | 5991165.77974 | 2105142.87216 | 37.759812628661706 | -122.473648022834 | (37.7598126286617, -122.473648022834) | |||
| 154448 | 154448 | 246437 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 498 Duncan St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6003348.65362 | 2099794.40948 | 37.7458250465875 | -122.43113170615801 | (37.7458250465875, -122.431131706158) | |||
| 154186 | 154186 | 176069 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 700x Mansell St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6009294.57289 | 2089991.02465 | 37.719242195742105 | -122.409879572386 | (37.7192421957421, -122.409879572386) | |||
| 153108 | 153108 | 206458 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 900 Junipero Serra Blvd | 105 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991134.51165 | 2090396.0326599998 | 37.7193197667672 | -122.472680940494 | (37.7193197667672, -122.472680940494) | |||
| 152842 | 152842 | 206476 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Terrace Dr | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 5993821.62847 | 2096518.9824599999 | 37.7362870716885 | -122.463836850114 | (37.7362870716885, -122.463836850114) | ||||
| 151900 | 151900 | 222989 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6002586.19946 | 2099486.51271 | 37.7449363986116 | -122.43374615947701 | (37.7449363986116, -122.433746159477) | ||||
| 151365 | 151365 | 206436 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Marietta Dr | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 5ft | 5999547.88846 | 2097490.32273 | 37.7392824643167 | -122.44410863729999 | (37.7392824643167, -122.4441086373) | |||
| 150733 | 150733 | 206483 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5995097.24504 | 2099302.48565 | 37.7440033097179 | -122.459628089474 | (37.7440033097179, -122.459628089474) | |||
| 150650 | 150650 | 246631 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3320 Harrison St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6009034.5576 | 2099266.31462 | 37.7446955781356 | -122.41143327894501 | (37.7446955781356, -122.411433278945) | ||||
| 150424 | 150424 | 206446 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 53 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 25 | 5992168.00552 | 2088268.19461 | 37.7135370108901 | -122.468953803676 | (37.7135370108901, -122.468953803676) | ||||
| 150355 | 150355 | 190919 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 999 Kansas St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6011651.17755 | 2103795.8209 | 37.7572790316179 | -122.40270394113001 | (37.7572790316179, -122.40270394113) | ||||
| 150202 | 150202 | 206434 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 2466 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992373.851840001 | 2098639.0417 | 37.7420246816026 | -122.468996609624 | (37.7420246816026, -122.468996609624) | |||
| 149598 | 149598 | 222992 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | 6002556.21356 | 2099484.40965 | 37.7449289225421 | -122.433849694824 | (37.7449289225421, -122.433849694824) | ||||
| 149350 | 149350 | 247902 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 377 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009819.79405 | 2098407.16553 | 37.74238055412221 | -122.40865747466499 | (37.7423805541222, -122.408657474665) | ||||
| 149266 | 149266 | 206439 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 171 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999612.35761 | 2094047.36229 | 37.7298325825057 | -122.44363846276501 | (37.7298325825057, -122.443638462765) | |||
| 148103 | 148103 | 206457 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 900 Junipero Serra Blvd | 104 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5991133.573530001 | 2090407.8832200002 | 37.719352251183 | -122.472685046772 | (37.719352251183, -122.472685046772) | |||
| 148076 | 148076 | 113495 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | 3x3 | 6011252.2338 | 2090588.8087900002 | 37.720993109219705 | -122.40315466785201 | (37.7209931092197, -122.403154667852) | |||
| 137634 | 137634 | 250505 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 55 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | 5987243.87038 | 2115583.5644400003 | 37.7882519230241 | -122.487978957983 | (37.7882519230241, -122.487978957983) | ||||
| 137496 | 137496 | 246436 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 498 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6003348.10613 | 2099802.17179 | 37.7458463290596 | -122.43113415324301 | (37.7458463290596, -122.431134153243) | |||
| 137246 | 137246 | 222984 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 4699 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000341.30715 | 2101074.37399 | 37.7491686459265 | -122.441622492977 | (37.7491686459265, -122.441622492977) | |||
| 136629 | 136629 | 206481 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995111.8827 | 2099315.2957900004 | 37.74403932487021 | -122.45957840372101 | (37.7440393248702, -122.459578403721) | |||
| 135743 | 135743 | 222993 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | 6002546.229730001 | 2099483.20236 | 37.7449250410506 | -122.43388413076 | (37.7449250410506, -122.43388413076) | ||||
| 135410 | 135410 | 206489 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994901.422809999 | 2099243.38936 | 37.7438297837176 | -122.46030091277201 | (37.7438297837176, -122.460300912772) | |||
| 135280 | 135280 | 190915 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 48 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | 6012505.66859 | 2103014.14021 | 37.7551803790787 | -122.399693874288 | (37.7551803790787, -122.399693874288) | ||||
| 134302 | 134302 | 222985 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 517 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 28 | Width 10ft | 6002550.624530001 | 2098561.77605 | 37.7423952688291 | -122.433803088343 | (37.7423952688291, -122.433803088343) | |||
| 134062 | 134062 | 206463 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 100 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6001362.70768 | 2094968.7442 | 37.732462159688 | -122.4376532749 | (37.732462159688, -122.4376532749) | |||
| 133529 | 133529 | 222986 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 21 | 6002638.36895 | 2099488.8163799997 | 37.7449456841067 | -122.43356593172399 | (37.7449456841067, -122.433565931724) | ||||
| 133440 | 133440 | 206486 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5994998.43576 | 2099244.3383299997 | 37.743837969341 | -122.45996553579901 | (37.743837969341, -122.459965535799) | |||
| 133091 | 133091 | 223010 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1201 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6004358.20734 | 2096003.62684 | 37.7354735791371 | -122.427370816017 | (37.7354735791371, -122.427370816017) | ||||
| 133034 | 133034 | 122924 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 2 11th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 5992431.96311 | 2114886.35785 | 37.7866388652474 | -122.469978400459 | (37.7866388652474, -122.469978400459) | |||
| 132915 | 132915 | 206470 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5999427.716030001 | 2095403.5068599998 | 37.733545705162705 | -122.44437420892599 | (37.7335457051627, -122.444374208926) | ||||
| 132666 | 132666 | 222988 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 502 28th St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6002598.0607 | 2099487.20989 | 37.7449389859493 | -122.433705195344 | (37.7449389859493, -122.433705195344) | ||||
| 132192 | 132192 | 190914 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 900x Carolina St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012455.864080001 | 2103644.27268 | 37.756907808551794 | -122.399910360878 | (37.7569078085518, -122.399910360878) | ||||
| 131448 | 131448 | 190921 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 875 Vermont St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 2ft | 6011349.18047 | 2104266.91512 | 37.7585556858022 | -122.403781518727 | (37.7585556858022, -122.403781518727) | |||
| 131412 | 131412 | 222997 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3955 21st St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6002162.22875 | 2103520.28848 | 37.7559881222676 | -122.435500681007 | (37.7559881222676, -122.435500681007) | ||||
| 130374 | 130374 | 206449 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3020 19th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5990639.74875 | 2095092.0751099999 | 37.7321852719367 | -122.4747337006 | (37.7321852719367, -122.4747337006) | |||
| 129598 | 129598 | 222999 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 3955 21st St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 53 | 6002171.060869999 | 2103519.51853 | 37.7559865097873 | -122.435470081578 | (37.7559865097873, -122.435470081578) | ||||
| 89215 | 89215 | 122489 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 69x Bonview St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
| 76969 | 76969 | 206469 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 747 Detroit St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999419.31958 | 2095424.67998 | 37.733603362501604 | -122.444404758876 | (37.7336033625016, -122.444404758876) | ||||
| 76073 | 76073 | 246435 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 501 Duncan St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 5ft | 6003234.36598 | 2099765.5285400003 | 37.7457392692468 | -122.431524834927 | (37.7457392692468, -122.431524834927) | |||
| 75726 | 75726 | 222979 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1001 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005237.0546 | 2097014.53451 | 37.7382989702268 | -122.424404187313 | (37.7382989702268, -122.424404187313) | ||||
| 75364 | 75364 | 176064 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011103.67645 | 2090538.55711 | 37.720846830886394 | -122.40366465540501 | (37.7208468308864, -122.403664655405) | |||
| 74817 | 74817 | 206488 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5994928.93938 | 2099242.2168 | 37.7438281469548 | -122.460205682656 | (37.7438281469548, -122.460205682656) | |||
| 74273 | 74273 | 176066 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 500x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6010525.865540001 | 2090356.25733 | 37.7203139789786 | -122.40564914889 | (37.7203139789786, -122.40564914889) | |||
| 74189 | 74189 | 206440 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 1x Minerva St | 52 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 5996572.23219 | 2088998.68039 | 37.7157962346852 | -122.45378402860399 | (37.7157962346852, -122.453784028604) | |||
| 74056 | 74056 | 126359 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1100 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 6007620.5753 | 2119577.5831299997 | 37.8003860977102 | -122.41776198712799 | (37.8003860977102, -122.417761987128) | |||
| 73947 | 73947 | 223002 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 256 Bemis St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6003028.5059400005 | 2096309.1150200001 | 37.736237086475 | -122.43198989862199 | (37.736237086475, -122.431989898622) | ||||
| 70616 | 70616 | 223011 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1201 San Jose Ave | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6004395.88546 | 2096037.5210900002 | 37.735568775981704 | -122.427242962114 | (37.7355687759817, -122.427242962114) | ||||
| 67428 | 67428 | 206465 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 423 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5998611.46189 | 2095226.7392099998 | 37.733013737293604 | -122.44718350482901 | (37.7330137372936, -122.447183504829) | |||
| 66607 | 66607 | 113503 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 200x Mansell St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6011155.5498 | 2090556.69361 | 37.7208995275826 | -122.40348661931299 | (37.7208995275826, -122.403486619313) | |||
| 66443 | 66443 | 223013 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 400 Prospect Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6006209.38075 | 2097598.06666 | 37.739956078103205 | -122.421083777917 | (37.7399560781032, -122.421083777917) | ||||
| 66206 | 66206 | 206447 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 193 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5993726.91575 | 2088448.649 | 37.7141224416834 | -122.46357878423001 | (37.7141224416834, -122.46357878423) | |||
| 65519 | 65519 | 206480 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 50 Garcia Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5995119.81246 | 2099322.2843400002 | 37.744058969658106 | -122.459551490632 | (37.7440589696581, -122.459551490632) | |||
| 65373 | 65373 | 206437 | DPW Maintained 3 | Cotoneaster SPP :: Cotoneaster 234 | 300x Marietta Dr | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 5999552.5631800005 | 2097488.9767299998 | 37.7392790352022 | -122.444092377567 | (37.7392790352022, -122.444092377567) | |||
| 65338 | 65338 | 223007 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 1200 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6004038.311369999 | 2095943.3058799999 | 37.735289853946 | -122.428472518792 | (37.735289853946, -122.428472518792) | ||||
| 64819 | 64819 | 246768 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 99 Waltham St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6009274.77295 | 2098916.84453 | 37.7437494805599 | -122.410577984112 | (37.7437494805599, -122.410577984112) |
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");