Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4120 | 4120 | 139116 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1501 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004490.8408 | 2114272.6601 | 37.7856435047825 | -122.42821383671101 | (37.7856435047825, -122.428213836711) | ||||
| 6613 | 6613 | 12417 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1691 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004447.0274 | 2114613.1852 | 37.786576022340604 | -122.428389697922 | (37.7865760223406, -122.428389697922) | ||
| 16936 | 16936 | 19796 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY21 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40ST | ||||||||
| 17381 | 17381 | 10116 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 842 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6005634.91055 | 2104075.87142 | 37.7577102430435 | -122.42353048064501 | (37.7577102430435, -122.423530480645) | |||
| 18064 | 18064 | 4209 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004325.38397 | 2100415.60352 | 37.747586001896 | -122.427798564152 | (37.747586001896, -122.427798564152) | |||
| 21869 | 21869 | 22856 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 140 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5999949.39722 | 2099144.09084 | 37.743846215245796 | -122.44283912645099 | (37.7438462152458, -122.442839126451) | |||
| 25106 | 25106 | 52648 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 542@ ANZA 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/24/2010 12:00:00 AM | 2 | Permit Number 48732 | 5993472.644230001 | 2111791.25598 | 37.778200659528295 | -122.466152920318 | (37.7782006595283, -122.466152920318) | ||
| 25559 | 25559 | 60074 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1275 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 4 | Permit Number 19575 | 5988921.6846 | 2106672.1231 | 37.7638813163914 | -122.481521155686 | (37.7638813163914, -122.481521155686) | |
| 26844 | 26844 | 238541 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 31 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6005390.57049 | 2103524.3903200002 | 37.7561822103525 | -122.424336286693 | (37.7561822103525, -122.424336286693) | |||
| 26847 | 26847 | 35161 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 515 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | 6 | Permit Number 38692 | 6002615.109 | 2110357.4935 | 37.7747871313025 | -122.434423295825 | (37.7747871313025, -122.434423295825) | |
| 27673 | 27673 | 65516 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 159 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/1990 12:00:00 AM | 5 | Permit Number 28402 | 5990823.47806 | 2114342.11962 | 37.7850514269176 | -122.47550355958299 | (37.7850514269176, -122.475503559583) | ||
| 32670 | 32670 | 60083 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1270 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1982 12:00:00 AM | 3 | Permit Number 19584 | 5988965.7237 | 2106688.207 | 37.763928038973106 | -122.481370017438 | (37.7639280389731, -122.481370017438) | |
| 33410 | 33410 | 50351 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 658 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.87041 | 2111242.23948 | 37.776005259128794 | -122.50693811767201 | (37.7760052591288, -122.506938117672) | |
| 34078 | 34078 | 238570 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1474 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003271.44835 | 2099657.0265900004 | 37.745443449856 | -122.43138886550699 | (37.745443449856, -122.431388865507) | |||
| 34271 | 34271 | 196527 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 333 Texas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013792.65149 | 2105531.32389 | 37.7621636768226 | -122.395419411895 | (37.7621636768226, -122.395419411895) | |||
| 35989 | 35989 | 181654 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1270 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986485.9791 | 2106605.5895 | 37.763556707763705 | -122.489940517963 | (37.7635567077637, -122.489940517963) | |||
| 36853 | 36853 | 40939 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2011 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/2000 12:00:00 AM | 4 | Permit Number 42024 | 6003842.4279 | 2115465.9547 | 37.7888832815445 | -122.43054233468 | (37.7888832815445, -122.43054233468) | ||
| 37295 | 37295 | 238548 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 76 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010523.51123 | 2100011.17861 | 37.7468242140742 | -122.406337213897 | (37.7468242140742, -122.406337213897) | |||
| 40073 | 40073 | 196528 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 400 Texas St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013752.07769 | 2105195.9474400003 | 37.7612405497197 | -122.395536244627 | (37.7612405497197, -122.395536244627) | |||
| 40214 | 40214 | 238559 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 358 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004157.57388 | 2100161.2554200003 | 37.746878126628204 | -122.42836071599899 | (37.7468781266282, -122.428360715999) | |||
| 40780 | 40780 | 120407 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 647 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5988776.18848 | 2110908.47629 | 37.7755047148615 | -122.48233478645399 | (37.7755047148615, -122.482334786454) | |||
| 41456 | 41456 | 218233 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 365 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5991919.11048 | 2097078.05412 | 37.737712321755 | -122.470455286603 | (37.737712321755, -122.470455286603) | |||
| 42239 | 42239 | 238567 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 638 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002382.79124 | 2100064.9515299997 | 37.7465131116006 | -122.434490857486 | (37.7465131116006, -122.434490857486) | |||
| 42348 | 42348 | 238550 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 263 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004819.40708 | 2098979.89063 | 37.7436717980264 | -122.425988074184 | (37.7436717980264, -122.425988074184) | |||
| 42874 | 42874 | 138762 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1508 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000175.6546 | 2114135.1395 | 37.7850208059477 | -122.443133211033 | (37.7850208059477, -122.443133211033) | |||
| 44776 | 44776 | 122127 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990810.49016 | 2114703.81512 | 37.7860437889569 | -122.47557491276699 | (37.7860437889569, -122.475574912767) | |||
| 49306 | 49306 | 238560 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3329 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6007360.6242 | 2105555.31734 | 37.7618697145455 | -122.417667096959 | (37.7618697145455, -122.417667096959) | |||
| 51617 | 51617 | 238566 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 621 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6002444.337069999 | 2100031.09777 | 37.7464236506235 | -122.43427561915001 | (37.7464236506235, -122.43427561915) | |||
| 51635 | 51635 | 185053 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2719 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983670.2351 | 2096626.4658 | 37.735991973866 | -122.498941812175 | (37.735991973866, -122.498941812175) | |||
| 52859 | 52859 | 137918 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1914 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003425.977000001 | 2115322.684 | 37.7884662960967 | -122.43197296209499 | (37.7884662960967, -122.431972962095) | |||
| 53745 | 53745 | 35587 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3600 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1998 12:00:00 AM | 5 | Permit Number 38951 | 6002200.57544 | 2120594.56512 | 37.8028719650354 | -122.436590150328 | (37.8028719650354, -122.436590150328) | ||
| 54491 | 54491 | 182113 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2462 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5988005.6699 | 2098548.963 | 37.7415239963656 | -122.484093600478 | (37.7415239963656, -122.484093600478) | |||
| 55281 | 55281 | 246183 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 789 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999949.17 | 2108240.0487 | 37.7688214743495 | -122.443493165297 | (37.7688214743495, -122.443493165297) | |||
| 55284 | 55284 | 63544 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1457 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 5 | Permit Number 24160 | 6000753.318 | 2110998.5304 | 37.776441399194 | -122.440909593922 | (37.776441399194, -122.440909593922) | |
| 55844 | 55844 | 182092 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2691 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987764.3751 | 2098252.1671 | 37.7406950216778 | -122.48490613622101 | (37.7406950216778, -122.484906136221) | |||
| 57874 | 57874 | 53440 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 62 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1969 12:00:00 AM | 5 | Permit Number 6341 | 5995913.45443 | 2114081.21839 | 37.784628805515794 | -122.45787507433701 | (37.7846288055158, -122.457875074337) | ||
| 60107 | 60107 | 60559 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 682 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 7 | Permit Number 20169 | 5985086.776269999 | 2111238.89557 | 37.7761966512901 | -122.495121529295 | (37.7761966512901, -122.495121529295) | |
| 62192 | 62192 | 238561 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 84 Richland Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6005027.1753 | 2096150.27417 | 37.735914051792896 | -122.42506837081001 | (37.7359140517929, -122.42506837081) | |||
| 62809 | 62809 | 61603 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 51 Temescal Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1984 12:00:00 AM | 5 | Permit Number 21576 | 5997451.8044 | 2111351.7774 | 37.777222737132 | -122.452355902086 | (37.777222737132, -122.452355902086) | |
| 63912 | 63912 | 196532 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1317 19th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6013654.12142 | 2105210.0397200002 | 37.761273794973 | -122.395876023757 | (37.761273794973, -122.395876023757) | |||
| 65056 | 65056 | 196533 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1301 19th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013698.905669999 | 2105212.75779 | 37.7612837495574 | -122.395721323302 | (37.7612837495574, -122.395721323302) | |||
| 65988 | 65988 | 57628 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 534 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/1990 12:00:00 AM | 7 | Permit Number 28866 | 5990653.097709999 | 2111727.01603 | 37.7778611992683 | -122.475901966903 | (37.7778611992683, -122.475901966903) | ||
| 67945 | 67945 | 123858 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 346 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994396.826309999 | 2114914.43525 | 37.7868293438726 | -122.463182538439 | (37.7868293438726, -122.463182538439) | |||
| 69424 | 69424 | 140279 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 100 COLE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997820.131 | 2110246.9364 | 37.7742102243098 | -122.451002059087 | (37.7742102243098, -122.451002059087) | |||
| 71928 | 71928 | 32263 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1027 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1997 12:00:00 AM | 6 | Permit Number 38508 | 6001961.80669 | 2101044.74865 | 37.7491794962361 | -122.436016672442 | (37.7491794962361, -122.436016672442) | ||
| 72911 | 72911 | 182859 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1830 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986931.5262 | 2102786.1611 | 37.7530956091735 | -122.48811885646299 | (37.7530956091735, -122.488118856463) | |||
| 73399 | 73399 | 185745 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2195 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987583.2114 | 2100377.5043 | 37.746520080568104 | -122.485688467617 | (37.7465200805681, -122.485688467617) | |||
| 73471 | 73471 | 67971 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2643 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 2 | Permit Number 31692 | 5987328.75308 | 2111152.2075900002 | 37.7760896301586 | -122.48735965405001 | (37.7760896301586, -122.48735965405) | |
| 73862 | 73862 | 181961 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2468 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987695.3371 | 2098486.355 | 37.741334018551996 | -122.48516201907101 | (37.741334018552, -122.485162019071) | |||
| 75037 | 75037 | 68955 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 790 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 4 | Permit Number 32944 | 5988860.14903 | 2109950.32052 | 37.7728787684605 | -122.481974145233 | (37.7728787684605, -122.481974145233) | |
| 76415 | 76415 | 185737 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2134 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986377.6988 | 2100714.0842 | 37.7473739221204 | -122.489881691592 | (37.7473739221204, -122.489881691592) | |||
| 79842 | 79842 | 13239 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 2335X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001220.6637699995 | 2119285.5724400003 | 37.799222084037396 | -122.439887231455 | (37.7992220840374, -122.439887231455) | |||
| 81134 | 81134 | 34127 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1401 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.45662648597799 | (37.7276243745144, -122.456626485978) | ||
| 81300 | 81300 | 56269 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 27 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2001 12:00:00 AM | Permit Number 44402 | 6006135.85394887 | 2104023.0641993 | 37.757593509181206 | -122.421794258753 | (37.7575935091812, -122.421794258753) | |||
| 82253 | 82253 | 64675 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1988 12:00:00 AM | Permit Number 25611 | 6005699.53822151 | 2104160.47613012 | 37.7579461954401 | -122.423312985478 | (37.7579461954401, -122.423312985478) | ||
| 83360 | 83360 | 51865 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 141 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2005 12:00:00 AM | Permit Number 48086 | 6001731.90100781 | 2108013.17914536 | 37.768300053668206 | -122.43731059058001 | (37.7683000536682, -122.43731059058) | |||
| 84815 | 84815 | 51422 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 655 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52282 | 6013199.59186321 | 2110555.37408537 | 37.7759255920049 | -122.397823019146 | (37.7759255920049, -122.397823019146) | ||
| 85015 | 85015 | 63672 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 370 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/2015 12:00:00 AM | 3 | Permit Number 24323 | 6004106.96627638 | 2100160.80457488 | 37.7468740249128 | -122.42853568027901 | (37.7468740249128, -122.428535680279) | ||
| 86250 | 86250 | 67526 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1301 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | Permit Number 31064 | 6013774.38377619 | 2105211.91246173 | 37.761285626876 | -122.395460215282 | (37.761285626876, -122.395460215282) | ||
| 90800 | 90800 | 59573 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 964 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1981 12:00:00 AM | Permit Number 18963 | 6003107.75578888 | 2102621.90086172 | 37.753575019284206 | -122.432166582864 | (37.7535750192842, -122.432166582864) | ||
| 91391 | 91391 | 63685 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1488 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24342 | 6003919.51862242 | 2099605.68059427 | 37.7453391734545 | -122.429144281616 | (37.7453391734545, -122.429144281616) | ||
| 92265 | 92265 | 63662 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24311 | 6004353.00566134 | 2100414.81780831 | 37.747585407013204 | -122.427702994 | (37.7475854070132, -122.427702994) | ||
| 92643 | 92643 | 246192 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 755 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999893.4495 | 2108060.1682 | 37.7683243897923 | -122.44367297370701 | (37.7683243897923, -122.443672973707) | |||
| 93396 | 93396 | 44237 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 415 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2001 12:00:00 AM | Permit Number 43676 | 6001527.40561887 | 2103403.09040324 | 37.755630249317 | -122.43768771219801 | (37.755630249317, -122.437687712198) | |||
| 93442 | 93442 | 60386 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1432 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19966 | 6015791.47503069 | 2094604.97930734 | 37.732273173852896 | -122.38774379220101 | (37.7322731738529, -122.387743792201) | ||
| 93729 | 93729 | 65661 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 76 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1990 12:00:00 AM | Permit Number 28581 | 5999609.85654862 | 2095526.3392082 | 37.733893364416794 | -122.44375332049101 | (37.7338933644168, -122.443753320491) | ||
| 94756 | 94756 | 64804 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1476 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25803 | 6003915.51476447 | 2099673.7745449 | 37.7455259170349 | -122.42916298071 | (37.7455259170349, -122.42916298071) | ||
| 95318 | 95318 | 64834 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 552 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1989 12:00:00 AM | Permit Number 25843 | 6002326.41169322 | 2099472.15020661 | 37.74488221778179 | -122.434643430049 | (37.7448822177818, -122.434643430049) | ||
| 95540 | 95540 | 44069 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43593 | 6002668.59972375 | 2105639.21740039 | 37.761834937896 | -122.433900935359 | (37.761834937896, -122.433900935359) | ||||
| 95757 | 95757 | 67744 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1460 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1992 12:00:00 AM | Permit Number 31363 | 5994310.57601305 | 2105578.84704093 | 37.7611913298083 | -122.462803426682 | (37.7611913298083, -122.462803426682) | ||
| 95884 | 95884 | 60515 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 255 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25818 | 6004877.54107387 | 2099860.14096955 | 37.7460920491494 | -122.42584970458401 | (37.7460920491494, -122.425849704584) | ||
| 96084 | 96084 | 65677 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 25 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28597 | 5998247.19530514 | 2097659.9759073 | 37.739674003576106 | -122.448618049723 | (37.7396740035761, -122.448618049723) | ||
| 96306 | 96306 | 63785 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 4007 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24470 | 6003796.64349499 | 2101262.51482532 | 37.7498814982247 | -122.42968731122 | (37.7498814982247, -122.42968731122) | ||
| 96568 | 96568 | 60791 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 276 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | Permit Number 20465 | 5998453.93543616 | 2112227.70718861 | 37.779685173955706 | -122.44895233828001 | (37.7796851739557, -122.44895233828) | ||
| 97595 | 97595 | 39133 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 786 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1999 12:00:00 AM | Permit Number 40812 | 6007317.12360596 | 2102737.01571967 | 37.754128859482606 | -122.417617789975 | (37.7541288594826, -122.417617789975) | ||
| 97844 | 97844 | 64368 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 416 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1988 12:00:00 AM | Permit Number 25207 | 6010971.78233994 | 2119344.22600524 | 37.7999333725763 | -122.406148966564 | (37.7999333725763, -122.406148966564) | ||
| 98138 | 98138 | 60911 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 9 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20703 | 5995767.191933099 | 2107036.52457374 | 37.7652775252135 | -122.457871132491 | (37.7652775252135, -122.457871132491) | ||
| 98780 | 98780 | 65676 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 29 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28596 | 5998246.67335369 | 2097607.91153994 | 37.7395310174996 | -122.44861610559799 | (37.7395310174996, -122.448616105598) | ||
| 99388 | 99388 | 65675 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 35 Sequoia Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1990 12:00:00 AM | Permit Number 28595 | 5998245.89042686 | 2097529.81502266 | 37.7393165384712 | -122.448613189427 | (37.7393165384712, -122.448613189427) | ||
| 99633 | 99633 | 109267 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 900 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897.0 | 2103882.5 | 37.7574189360449 | -122.40877671518999 | (37.7574189360449, -122.40877671519) | |
| 99805 | 99805 | 1641 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 859 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5995651.21865 | 2110512.9681 | 37.774816268938 | -122.45852392834499 | (37.774816268938, -122.458523928345) | |||
| 100096 | 100096 | 63655 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1987 12:00:00 AM | Permit Number 24302 | 6003882.00730683 | 2100268.96113166 | 37.747158264512 | -122.429321278666 | (37.747158264512, -122.429321278666) | ||
| 100822 | 100822 | 46606 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1166 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/2002 12:00:00 AM | Permit Number 44731 | 5990419.11281219 | 2103161.32215556 | 37.754328547559204 | -122.476085621892 | (37.7543285475592, -122.476085621892) | |||
| 101283 | 101283 | 65345 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 182 Lippard Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | Permit Number 28177 | 6001753.2001687 | 2095039.63295635 | 37.7326789990165 | -122.43630832371001 | (37.7326789990165, -122.43630832371) | ||
| 101995 | 101995 | 63684 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1477 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24341 | 6003967.42510642 | 2099676.82682244 | 37.7455372363545 | -122.428983700412 | (37.7455372363545, -122.428983700412) | ||
| 102402 | 102402 | 63680 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1290 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24335 | 6003854.79358898 | 2100760.12330994 | 37.7485053408812 | -122.42945040251001 | (37.7485053408812, -122.42945040251) | ||
| 102870 | 102870 | 30499 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2468 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778856 | 6001812.59982079 | 2117366.46102333 | 37.793986382856104 | -122.437701414239 | (37.7939863828561, -122.437701414239) | |
| 103738 | 103738 | 49555 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 71REVISED Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2003 12:00:00 AM | Permit Number 46444 | 6009365.93611768 | 2097039.29774225 | 37.7385992569024 | -122.41013023532899 | (37.7385992569024, -122.410130235329) | |||
| 103842 | 103842 | 63666 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 4019 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24316 | 6003771.80904203 | 2100383.61201619 | 37.7474668298055 | -122.42971051138001 | (37.7474668298055, -122.42971051138) | ||
| 105469 | 105469 | 23662 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 311 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453896999 | (37.7419584813283, -122.41861453897) | |||
| 105662 | 105662 | 64408 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 80 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/1988 12:00:00 AM | Permit Number 25254 | 6010509.94669729 | 2100012.34807199 | 37.7468266663579 | -122.406384201378 | (37.7468266663579, -122.406384201378) | ||
| 106268 | 106268 | 45342 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 466 Ralston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/27/2001 12:00:00 AM | Permit Number 44172 | 5992247.31717609 | 2090977.05466926 | 37.720979464776896 | -122.46887668176001 | (37.7209794647769, -122.46887668176) | ||
| 109623 | 109623 | 63670 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24320 | 6003916.84938378 | 2099651.07656136 | 37.7454636691757 | -122.429156747668 | (37.7454636691757, -122.429156747668) | ||
| 109766 | 109766 | 39615 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 41 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41016 | 5998377.05402267 | 2106536.9754029 | 37.76405548388961 | -122.44880829126001 | (37.7640554838896, -122.44880829126) | ||
| 112399 | 112399 | 40222 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 4387 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 41401 | 6001391.00854692 | 2101128.86800083 | 37.7493780241405 | -122.437996521237 | (37.7493780241405, -122.437996521237) | ||
| 112706 | 112706 | 60907 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1491 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 20697 | 5994575.4199228 | 2105392.22311625 | 37.7606941592004 | -122.461873918454 | (37.7606941592004, -122.461873918454) | ||
| 114389 | 114389 | 60381 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1350 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | Permit Number 19961 | 6016233.53392592 | 2094275.31577425 | 37.7313924611256 | -122.386192505476 | (37.7313924611256, -122.386192505476) | ||
| 114406 | 114406 | 423 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1901X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5989520.14191 | 2114679.4353400003 | 37.785901962187 | -122.480037334344 | (37.785901962187, -122.480037334344) | |||
| 114537 | 114537 | 238563 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 552 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002357.1288 | 2099469.61588 | 37.744877002880294 | -122.434537034955 | (37.7448770028803, -122.434537034955) | |||
| 114736 | 114736 | 63743 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 330 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24415 | 6002754.42754095 | 2109677.07121909 | 37.7729267674736 | -122.433892719333 | (37.7729267674736, -122.433892719333) |
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");