Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 146212 | 146212 | 13225 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2265 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001602.67751 | 2119341.9386 | 37.799398588794 | -122.438569375951 | (37.799398588794, -122.438569375951) | |||
| 146193 | 146193 | 505 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.40764958164499 | (37.7529538159215, -122.407649581645) | |||
| 146081 | 146081 | 17316 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 86 OTIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006711.0 | 2109331.0 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | |||
| 146078 | 146078 | 120592 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3773 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003806.0 | 2105923.0 | 37.7626786166025 | -122.42998736392201 | (37.7626786166025, -122.429987363922) | ||||
| 146032 | 146032 | 108150 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2232 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 145903 | 145903 | 110993 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 145899 | 145899 | 111390 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 298x CLINTON PARK | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004911.0 | 2108307.0 | 37.7692870280045 | -122.42633530742799 | (37.7692870280045, -122.426335307428) | ||||
| 145870 | 145870 | 16897 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 385 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005198.99692 | 2110159.8088700003 | 37.7743906686767 | -122.425471016021 | (37.7743906686767, -122.425471016021) | |||
| 145865 | 145865 | 7233 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1045 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003367.24511 | 2111893.72513 | 37.779047907460296 | -122.431931222001 | (37.7790479074603, -122.431931222001) | |||
| 145862 | 145862 | 15279 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1551 MISSION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6007345.0 | 2109715.7 | 37.773292268450795 | -122.418016080506 | (37.7732922684508, -122.418016080506) | |||
| 145770 | 145770 | 106524 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 145732 | 145732 | 48866 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 129 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | Permit Number 46075 | 6006370.62112219 | 2110394.65908683 | 37.7751016387897 | -122.421434823029 | (37.7751016387897, -122.421434823029) | |||
| 145687 | 145687 | 16949 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 625 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003989.24409 | 2110039.4311599997 | 37.7739917148646 | -122.429647190447 | (37.7739917148646, -122.429647190447) | |||
| 145603 | 145603 | 97278 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 60 Palm Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768156 | 5995934.7 | 2114107.9 | 37.7847032866401 | -122.45780350364599 | (37.7847032866401, -122.457803503646) | |||
| 145586 | 145586 | 2431 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 490X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004657.78302 | 2110211.2944799997 | 37.7745014417711 | -122.427346845616 | (37.7745014417711, -122.427346845616) | |||
| 145434 | 145434 | 21726 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1942 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003284.347 | 2114523.85502 | 37.7862648839776 | -122.43240590204701 | (37.7862648839776, -122.432405902047) | |||
| 145349 | 145349 | 21654 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004474.7477955995 | 2114689.3781886003 | 37.7867867977452 | -122.428299224496 | (37.7867867977452, -122.428299224496) | |||
| 145347 | 145347 | 18454 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6010521.188939299 | 2102709.7477141004 | 37.7542337610764 | -122.40653537262699 | (37.7542337610764, -122.406535372627) | |||
| 145317 | 145317 | 21751 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1787X Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | |||
| 145245 | 145245 | 94600 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1709 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997540.0 | 2108126.0 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | |||||
| 145180 | 145180 | 110732 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3515 25TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006381.0 | 2101411.0 | 37.7504352040325 | -122.42076100913799 | (37.7504352040325, -122.420761009138) | ||||
| 145122 | 145122 | 52718 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1330on LARKIN Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2006 12:00:00 AM | Permit Number 48769 | 6007121.03491046 | 2115409.40396286 | 37.788913192487705 | -122.419194766666 | (37.7889131924877, -122.419194766666) | |||
| 145114 | 145114 | 66879 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 277 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 768127 | 6001144.84674667 | 2104743.15871911 | 37.75928799185029 | -122.439106757133 | (37.7592879918503, -122.439106757133) | ||
| 145074 | 145074 | 52838 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 795on Trenton Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48857 | 6010309.20673902 | 2118158.51574656 | 37.796640619585204 | -122.408358059553 | (37.7966406195852, -122.408358059553) | ||||
| 145063 | 145063 | 100527 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1728 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4.5x6 | 6008341.0 | 2118363.0 | 37.797091669640395 | -122.415182998934 | (37.7970916696404, -122.415182998934) | ||||
| 145043 | 145043 | 6815 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016560.821272099 | 2097522.8211505003 | 37.740327568702895 | -122.385287208511 | (37.7403275687029, -122.385287208511) | |||
| 145035 | 145035 | 26953 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376002 | (37.7859892824562, -122.43461540376) | |||
| 144847 | 144847 | 98862 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 25 OAKWOOD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005344.6 | 2105317.5 | 37.7611030726424 | -122.424622816907 | (37.7611030726424, -122.424622816907) | ||||
| 144799 | 144799 | 101726 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 144710 | 144710 | 8768 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 144697 | 144697 | 5633 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1256 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005118.39805 | 2100997.74937 | 37.749229268656 | -122.425097781596 | (37.749229268656, -122.425097781596) | |||
| 144674 | 144674 | 15260 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6007445.07805 | 2110006.6589099998 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | |||
| 144663 | 144663 | 16998 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 903 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002629.22495 | 2109872.04506 | 37.773455011589704 | -122.434339751705 | (37.7734550115897, -122.434339751705) | |||
| 144661 | 144661 | 91127 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 610 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49594 | 6012704.2 | 2110820.8 | 37.7766267904106 | -122.39955535858401 | (37.7766267904106, -122.399555358584) | |||
| 144622 | 144622 | 100051 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 144621 | 144621 | 40355 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | 8 | Permit Number 41479 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | ||
| 144612 | 144612 | 96962 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3401X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x5 | 6004198.0 | 2106595.0 | 37.764545960058605 | -122.428679481968 | (37.7645459600586, -122.428679481968) | |||
| 144446 | 144446 | 109002 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 525x BURNETT AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1x1 | 5999530.0 | 2102478.0 | 37.7529764040195 | -122.44452886107901 | (37.7529764040195, -122.444528861079) | ||||
| 144423 | 144423 | 17367 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2308X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005067.325209999 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | |||
| 144339 | 144339 | 13101 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1501 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005049.00181 | 2119804.80205 | 37.800864933484 | -122.426676850993 | (37.800864933484, -122.426676850993) | |||
| 144334 | 144334 | 111222 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3150x 19TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008324.0 | 2105048.0 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | |||
| 144303 | 144303 | 89021 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1500 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51766 | 6007445.1 | 2110006.7 | 37.7740969185595 | -122.417690449841 | (37.7740969185595, -122.417690449841) | |||
| 144249 | 144249 | 13305 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1377X Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | |||
| 144220 | 144220 | 117345 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 395 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006014.0 | 2111158.0 | 37.777177474617794 | -122.42272271458599 | (37.7771774746178, -122.422722714586) | ||||
| 144210 | 144210 | 106521 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2510 Jackson St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | ||||
| 144207 | 144207 | 11086 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1896 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.41876525798901 | (37.7982300223497, -122.418765257989) | |||
| 144198 | 144198 | 57306 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3265 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 5.5x9 | Permit Number 30983 | 6005094.29272651 | 2106604.42467206 | 37.764622522827295 | -122.42558011640699 | (37.7646225228273, -122.425580116407) | ||
| 144192 | 144192 | 114952 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 601X OCTAVIA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005348.0 | 2111368.0 | 37.7777164851071 | -122.42504156741998 | (37.7777164851071, -122.42504156742) | ||||
| 144088 | 144088 | 32648 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 379 TEHAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2005 12:00:00 AM | 8 | Permit Number 37086 | 6011447.0 | 2112547.0 | 37.7812963779039 | -122.404025912764 | (37.7812963779039, -122.404025912764) | |
| 144042 | 144042 | 18016 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000941.6382972 | 2114893.0059573003 | 37.7871453575959 | -122.440537532879 | (37.7871453575959, -122.440537532879) | |||
| 144030 | 144030 | 15159 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 895X Mission St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | Private 3 | 18 | 4x4 | 6010810.7123748 | 2113108.5528643 | 37.7828026992214 | -122.406266743907 | (37.7828026992214, -122.406266743907) | ||
| 143989 | 143989 | 110990 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 245x North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/2015 12:00:00 AM | 3 | 6009556.06624176 | 2121873.83782792 | 37.806799769840296 | -122.41122668881 | (37.8067997698403, -122.41122668881) | |||
| 143962 | 143962 | 27711 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.42011195674299 | (37.7705111956623, -122.420111956743) | |||
| 143922 | 143922 | 18445 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | |||
| 143814 | 143814 | 100470 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 5X Pearl St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6005567.3 | 2108720.4 | 37.770459201480605 | -122.424094599295 | (37.7704592014806, -122.424094599295) | |||
| 143783 | 143783 | 94217 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 246 01st St | 2 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 06/25/2010 12:00:00 AM | 2x3 | Permit Number 53568 | 6014001.8 | 2114912.7 | 37.7879344554838 | -122.395353268636 | (37.7879344554838, -122.395353268636) | ||
| 143774 | 143774 | 122713 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 855x Kearny St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011188.0 | 2117923.0 | 37.7960431220576 | -122.40530062831999 | (37.7960431220576, -122.40530062832) | ||||
| 143768 | 143768 | 20245 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1823 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 12 | 3X3 | 6002519.588541901 | 2114476.0123893 | 37.7860901257054 | -122.43504834161101 | (37.7860901257054, -122.435048341611) | ||
| 143747 | 143747 | 117401 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 75x BEACH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009846.0 | 2122112.0 | 37.80746995952921 | -122.410240137563 | (37.8074699595292, -122.410240137563) | ||||
| 143706 | 143706 | 49256 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2X Spear St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371.0 | 2116872.0 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | |||
| 143704 | 143704 | 50980 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 201 Richardson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | ||
| 143635 | 143635 | 8765 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 3360 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | |||
| 143541 | 143541 | 113007 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 700x STANYAN ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997124.0 | 2108268.0 | 37.768736698354004 | -122.453267191941 | (37.768736698354, -122.453267191941) | ||||
| 143522 | 143522 | 7892 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1187 Franklin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006000.38049 | 2113895.86172 | 37.7846942050769 | -122.422964467171 | (37.7846942050769, -122.422964467171) | |||
| 143469 | 143469 | 16872 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 259 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6005773.57352 | 2110239.8238 | 37.774642817557705 | -122.42348913494499 | (37.7746428175577, -122.423489134945) | |||
| 143445 | 143445 | 104331 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 9 Beaver St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002844.0 | 2106791.0 | 37.765007405875295 | -122.43337660406901 | (37.7650074058753, -122.433376604069) | ||||
| 143425 | 143425 | 17693 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1095X Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6002343.215339401 | 2112268.6379219 | 37.7800192180629 | -122.43550057779301 | (37.7800192180629, -122.435500577793) | |||
| 143364 | 143364 | 59665 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 993 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/1981 12:00:00 AM | 12 | 2x2 | Permit Number 19087 | 6002914.43276984 | 2111641.44659541 | 37.778329533201706 | -122.433479648258 | (37.7783295332017, -122.433479648258) | |
| 143330 | 143330 | 71507 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3100 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1988 12:00:00 AM | 12 | 6008781.55607863 | 2105099.68545767 | 37.7606985097306 | -122.41272042520201 | (37.7606985097306, -122.412720425202) | |||
| 143319 | 143319 | 9689 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 332 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6006025.5202 | 2110969.11106 | 37.7766594813407 | -122.42266943618799 | (37.7766594813407, -122.422669436188) | |||
| 143296 | 143296 | 16388 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 238 Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6006262.13214 | 2114058.51032 | 37.7851555645201 | -122.422070450769 | (37.7851555645201, -122.422070450769) | |||
| 143279 | 143279 | 18328 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | |||
| 143277 | 143277 | 112161 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1324 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013680.97327942 | 2105726.70860795 | 37.7626939483281 | -122.39581935837 | (37.7626939483281, -122.39581935837) | ||||
| 143269 | 143269 | 108106 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1990X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Port 11 | 6004838.0 | 2115780.0 | 37.7898019192352 | -122.427120168027 | (37.7898019192352, -122.427120168027) | ||||
| 143031 | 143031 | 108561 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 141 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5995170.0 | 2114629.2 | 37.786090674815604 | -122.460486880145 | (37.7860906748156, -122.460486880145) | ||||
| 142982 | 142982 | 111207 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 601X 09TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010680.0 | 2108566.0 | 37.7703225929477 | -122.406398777104 | (37.7703225929477, -122.406398777104) | ||||
| 142979 | 142979 | 113275 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 2147 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002730.25600058 | 2118492.02135193 | 37.79712901471979 | -122.43460675571 | (37.7971290147198, -122.43460675571) | |||||
| 142910 | 142910 | 5655 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1332 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005148.498851901 | 2100582.0357256 | 37.7480895150856 | -122.424964119184 | (37.7480895150856, -122.424964119184) | |||
| 142907 | 142907 | 17323 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 99X Otis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6006684.0755900005 | 2109163.0616900004 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | |||
| 142879 | 142879 | 121000 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 390 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6010815.0 | 2115725.0 | 37.7899870820688 | -122.406436332672 | (37.7899870820688, -122.406436332672) | ||||
| 142870 | 142870 | 5595 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1100 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6005095.523502599 | 2101950.1341989 | 37.75184300486389 | -122.425244643333 | (37.7518430048639, -122.425244643333) | |||
| 142801 | 142801 | 27490 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2107 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005886.29279 | 2117665.93165 | 37.795039438918295 | -122.42362731206998 | (37.7950394389183, -122.42362731207) | |||
| 142768 | 142768 | 10647 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 913 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6003471.55966 | 2110689.4075 | 37.775747062973 | -122.43148435793199 | (37.775747062973, -122.431484357932) | ||
| 142765 | 142765 | 101718 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 560 Wisconsin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6012536.0 | 2104936.0 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | |||||
| 142651 | 142651 | 97110 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1095X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003193.9 | 2101874.0 | 37.751526344012 | -122.43181528051201 | (37.751526344012, -122.431815280512) | |||
| 142606 | 142606 | 18697 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 251X Richardson Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.44738946108299 | (37.8006252370733, -122.447389461083) | |||
| 142605 | 142605 | 96409 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 3828 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995910.0 | 2115869.0 | 37.7895373746493 | -122.458016450618 | (37.7895373746493, -122.458016450618) | |||||
| 142537 | 142537 | 6788 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | |||
| 142530 | 142530 | 109332 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1321 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5998933.0 | 2105018.0 | 37.7599165333482 | -122.446776141106 | (37.7599165333482, -122.446776141106) | |||
| 142435 | 142435 | 58520 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 1486 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 7x7 | Permit Number 17697 | 5998599.14429808 | 2108320.44227206 | 37.7689651308865 | -122.448168577388 | (37.7689651308865, -122.448168577388) | ||
| 142411 | 142411 | 51793 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 65 Oakwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2005 12:00:00 AM | Permit Number 48042 | 6005279.64463313 | 2105087.60921781 | 37.760468178165105 | -122.42483111417 | (37.7604681781651, -122.42483111417) | |||
| 142321 | 142321 | 11082 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1849 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6007286.994308701 | 2118635.1241551996 | 37.79777956440321 | -122.418849434729 | (37.7977795644032, -122.418849434729) | |||
| 142235 | 142235 | 99616 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003300.0 | 2119605.0 | 37.800217292537106 | -122.432714848025 | (37.8002172925371, -122.432714848025) | |||
| 142196 | 142196 | 112108 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 699x COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6009471.0 | 2119722.0 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | |||
| 142149 | 142149 | 109294 | Significant Tree 6 | Ficus nitida :: Laurel Fig 43 | 370 27TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6004104.9 | 2100171.3 | 37.7469027259862 | -122.42854357326401 | (37.7469027259862, -122.428543573264) | ||||
| 142146 | 142146 | 120142 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 10X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007842.0 | 2111812.0 | 37.779076168386105 | -122.41644540073798 | (37.7790761683861, -122.416445400738) | ||||
| 142097 | 142097 | 15105 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 110 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6014344.937609999 | 2116565.97781 | 37.7924930511311 | -122.394281863407 | (37.7924930511311, -122.394281863407) | |||
| 142064 | 142064 | 21930 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 2347 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x5 | 6015939.394730001 | 2104425.48438 | 37.7592464441674 | -122.38791741203 | (37.7592464441674, -122.38791741203) | |||
| 142027 | 142027 | 120146 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 1X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2111839.0 | 37.77916064960021 | -122.41581078056299 | (37.7791606496002, -122.415810780563) | ||||
| 141968 | 141968 | 99046 | Undocumented 2 | Ficus nitida :: Laurel Fig 43 | 2194 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6002943.0 | 2107121.0 | 37.7659191216839 | -122.43305776743999 | (37.7659191216839, -122.43305776744) |
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");