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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 639 | 639 | 20004 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY46 | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | ||||||||
| 3857 | 3857 | 19783 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY19 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 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) | ||
| 6884 | 6884 | 19587 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY4 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 7112 | 7112 | 19788 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY19 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 7362 | 7362 | 19927 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY37 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 8265 | 8265 | 12418 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1691 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004450.1666 | 2114579.9986 | 37.7864850778881 | -122.42837647083799 | (37.7864850778881, -122.428376470838) | ||
| 9531 | 9531 | 19924 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY37 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 9569 | 9569 | 19774 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY17 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20ST | ||||||||
| 12606 | 12606 | 19931 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY37 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 12836 | 12836 | 20072 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY55 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 45X | ||||||||
| 13148 | 13148 | 19582 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY4 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14532 | 14532 | 19839 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY25 | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 16568 | 16568 | 20049 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 100 STAIRWAY52 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10 | ||||||||
| 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) | |||
| 20913 | 20913 | 34112 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1398 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | ||
| 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) | |||
| 24109 | 24109 | 196523 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1801 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011996.40725 | 2106050.2030700003 | 37.7634883341404 | -122.401668444652 | (37.7634883341404, -122.401668444652) | |||
| 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) | |
| 26103 | 26103 | 122126 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990812.19137 | 2114688.82235 | 37.786002721616796 | -122.47556793196001 | (37.7860027216168, -122.47556793196) | |||
| 26481 | 26481 | 238571 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1474 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003271.46405 | 2099643.8513599997 | 37.745407274630104 | -122.431387870873 | (37.7454072746301, -122.431387870873) | |||
| 26589 | 26589 | 196520 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1100 Pennsylvania Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6014495.9358 | 2101776.59314 | 37.751893084516894 | -122.392724321763 | (37.7518930845169, -122.392724321763) | ||||
| 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) | |
| 32949 | 32949 | 122123 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990814.402869999 | 2114634.30613 | 37.7858531634971 | -122.475556298764 | (37.7858531634971, -122.475556298764) | |||
| 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) | |
| 33550 | 33550 | 139117 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1501 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004494.7186 | 2114242.7456 | 37.785561586454 | -122.42819828794501 | (37.785561586454, -122.428198287945) | |||
| 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) | |||
| 34109 | 34109 | 213714 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 125 Judson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5999173.83796 | 2093468.34199 | 37.728217707656704 | -122.445112858974 | (37.7282177076567, -122.445112858974) | |||
| 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) | ||
| 37271 | 37271 | 118369 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 55 Vandewater St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 2x2 | 6009060.6253 | 2121300.7581 | 37.805198438810294 | -122.41290072218399 | (37.8051984388103, -122.412900722184) | |||
| 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) | |||
| 37383 | 37383 | 41957 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2638 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 4 | Permit Number 42313 | 5995143.69116 | 2110295.9103200003 | 37.7741911046961 | -122.460263829424 | (37.7741911046961, -122.460263829424) | |
| 37570 | 37570 | 246644 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009046.23893 | 2099176.02556 | 37.744448319452204 | -122.41138650967899 | (37.7444483194522, -122.411386509679) | ||||
| 38068 | 38068 | 138729 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1615 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000051.0937 | 2114639.9425 | 37.786399760935204 | -122.443600426882 | (37.7863997609352, -122.443600426882) | |||
| 39114 | 39114 | 218412 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 205 Castenada Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5994303.242319999 | 2100628.09542 | 37.7475974107089 | -122.46246968273199 | (37.7475974107089, -122.462469682732) | |||
| 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) | |||
| 40329 | 40329 | 111708 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 463 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5985915.33595 | 2112785.30995 | 37.780491135633 | -122.49236925923701 | (37.780491135633, -122.492369259237) | |||
| 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) | |||
| 41135 | 41135 | 140281 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 100 COLE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997882.1979 | 2110255.1754 | 37.774236399597 | -122.450787953752 | (37.774236399597, -122.450787953752) | |||
| 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) | |||
| 42461 | 42461 | 138764 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1508 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000169.3138 | 2114165.2585 | 37.7851031433792 | -122.44315731203301 | (37.7851031433792, -122.443157312033) | |||
| 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) | |||
| 44368 | 44368 | 181828 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2311 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5986682.779 | 2099487.7451 | 37.744024532877496 | -122.488736632211 | (37.7440245328775, -122.488736632211) | |||
| 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) | |||
| 46036 | 46036 | 238574 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 290 States St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000331.0714 | 2106844.5013099997 | 37.7650114214522 | -122.442072013715 | (37.7650114214522, -122.442072013715) | |||
| 47066 | 47066 | 124234 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1 Paramount Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996623.51945 | 2111013.40479 | 37.7762461678144 | -122.455196729351 | (37.7762461678144, -122.455196729351) | |||
| 47508 | 47508 | 238557 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 4014 26th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6003783.51976 | 2100724.3526 | 37.7484030872306 | -122.429694315247 | (37.7484030872306, -122.429694315247) | |||
| 48410 | 48410 | 110661 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 650 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6003108.682999999 | 2110599.6041 | 37.775479911610205 | -122.432733221791 | (37.7754799116102, -122.432733221791) | |||
| 48835 | 48835 | 246649 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009030.81997 | 2099159.0230900003 | 37.744400769587 | -122.411438624517 | (37.744400769587, -122.411438624517) | ||||
| 49097 | 49097 | 136031 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1635 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004020.9595 | 2120061.85215 | 37.8015125516123 | -122.43025265844601 | (37.8015125516123, -122.430252658446) | |||
| 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) | |||
| 50786 | 50786 | 185746 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2195 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987582.8307 | 2100358.089 | 37.746466749146705 | -122.485688359332 | (37.7464667491467, -122.485688359332) | |||
| 51171 | 51171 | 238569 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1623 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003376.357030001 | 2098716.75556 | 37.7428676287329 | -122.430959013851 | (37.7428676287329, -122.430959013851) | |||
| 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) | |||
| 51760 | 51760 | 246643 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009035.26115 | 2099177.7888599997 | 37.7444525453606 | -122.41142459327601 | (37.7444525453606, -122.411424593276) | ||||
| 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) | |||
| 53364 | 53364 | 142051 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 32 ATALAYA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998845.9761 | 2110971.5149 | 37.7762584069 | -122.447505657858 | (37.7762584069, -122.447505657858) | |||
| 53624 | 53624 | 213716 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 252 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994453.52606 | 2088731.32317 | 37.7149404380182 | -122.46108783483601 | (37.7149404380182, -122.461087834836) | |||
| 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) | ||
| 54332 | 54332 | 136034 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1798 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002280.33301 | 2120565.85402 | 37.8027976639548 | -122.43631209254801 | (37.8027976639548, -122.436312092548) | |||
| 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) | |||
| 55902 | 55902 | 141596 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1457 FULTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000792.6568 | 2111003.6819 | 37.776457784318296 | -122.440773879837 | (37.7764577843183, -122.440773879837) | |||
| 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) | |
| 61171 | 61171 | 122124 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 109 16th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990813.29617 | 2114656.20657 | 37.7859132318364 | -122.47556172729601 | (37.7859132318364, -122.475561727296) | |||
| 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) | |||
| 64692 | 64692 | 120351 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2122 Lake St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5988809.84875 | 2114710.37 | 37.7859456052715 | -122.482496990767 | (37.7859456052715, -122.482496990767) | |||
| 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) | |||
| 65771 | 65771 | 213712 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 611 Joost Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5998085.35885 | 2094959.9785200001 | 37.7322512012233 | -122.448983163356 | (37.7322512012233, -122.448983163356) | ||||
| 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) | |||
| 69911 | 69911 | 123859 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 346 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994390.43638 | 2114914.64585 | 37.7868295540161 | -122.463204661228 | (37.7868295540161, -122.463204661228) | |||
| 70655 | 70655 | 123321 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 678 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994436.02989 | 2110905.4473599996 | 37.7758240001959 | -122.462755965315 | (37.7758240001959, -122.462755965315) | |||
| 71754 | 71754 | 238573 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 414 Collingwood St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6002098.58859 | 2103426.99001 | 37.755728332420794 | -122.435714094642 | (37.7557283324208, -122.435714094642) | ||||
| 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) | ||
| 72171 | 72171 | 120349 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2122 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5988820.20378 | 2114710.2762700003 | 37.785945950300295 | -122.48246115875799 | (37.7859459503003, -122.482461158758) | |||
| 72430 | 72430 | 246645 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009048.821140001 | 2099170.00785 | 37.7444319409756 | -122.411377155852 | (37.7444319409756, -122.411377155852) | ||||
| 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) |
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");