trees
356 rows where qSpecies_id = 91 sorted by PermitNotes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
82754 | 239645 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003486.01122 | 2105681.39131 | 37.7619970900117 | -122.431076844836 | (37.7619970900117, -122.431076844836) | 15 | 4 | 5 | 28862 | 3 | |||
82801 | 239584 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 863 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998665.55754 | 2107188.82134 | 37.7658617826328 | -122.447857378524 | (37.7658617826328, -122.447857378524) | 15 | 5 | 11 | 29492 | 9 | |||
83160 | 239664 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1140 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6002488.98028 | 2102184.88968 | 37.7523399882133 | -122.434275200945 | (37.7523399882133, -122.434275200945) | 2 | 4 | 5 | 28862 | 22 | |||
83952 | 109126 | Private 9 | Schinus molle :: California Pepper 91 | 890x CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6002411 | 2103002 | 37.7545791519678 | -122.434603290485 | (37.7545791519678, -122.434603290485) | 2 | 4 | 5 | 28862 | 22 | |||
84224 | 239582 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 43 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5998416.52248 | 2107203.63932 | 37.765888231668 | -122.448719802287 | (37.765888231668, -122.448719802287) | 15 | 5 | 11 | 29492 | 9 | |||
85704 | 239634 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 871 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003772.61458 | 2103201.71767 | 37.7552047327212 | -122.429908711835 | (37.7552047327212, -122.429908711835) | 2 | 4 | 5 | 28862 | 22 | |||
86380 | 173724 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1101 Connecticut St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6013424 | 2101939 | 37.7522794251173 | -122.396442635345 | (37.7522794251173, -122.396442635345) | 10 | 3 | 8 | 28856 | 1 | |||||
86523 | 179423 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 103 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6004767.82112 | 2092745.17359 | 37.7265497503523 | -122.425722776001 | (37.7265497503523, -122.425722776001) | 9 | 7 | 6 | 28861 | 5 | ||||
86676 | 214165 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 428 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 5996451.80809 | 2106977.82649 | 37.7651556637169 | -122.455498978198 | (37.7651556637169, -122.455498978198) | 15 | 5 | 11 | 29492 | 12 | |||
87375 | 187555 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6011363.78669 | 2088352.31881 | 37.714858391064 | -122.402611866762 | (37.714858391064, -122.402611866762) | 10 | 7 | 8 | 309 | 39 | ||||
87765 | 247489 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 868 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002408.5917 | 2109542.1708 | 37.7725367328675 | -122.435079355167 | (37.7725367328675, -122.435079355167) | 15 | 5 | 11 | 29492 | 9 | |||
89326 | 239635 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3691 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003778.26076 | 2103599.43748 | 37.7562970969591 | -122.429917553956 | (37.7562970969591, -122.429917553956) | 2 | 4 | 5 | 28862 | 22 | |||
89477 | 142226 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 542 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004780.8856 | 2110726.6251 | 37.7759233752217 | -122.426957720143 | (37.7759233752217, -122.426957720143) | 7 | 9 | 11 | 28852 | 10 | |||
89962 | 239567 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3435 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6006895.64188 | 2100851.73373 | 37.7489285791008 | -122.418941674643 | (37.7489285791008, -122.418941674643) | 2 | 4 | 7 | 28859 | 19 | |||
90218 | 197483 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 99 Lafayette St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6007475.11808 | 2109661.30518 | 37.7731502356402 | -122.417562127216 | (37.7731502356402, -122.417562127216) | 8 | 2 | 9 | 28853 | 19 | |||
90678 | 112684 | Undocumented 4 | Schinus molle :: California Pepper 91 | 86 STANTON ST | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000281 | 2103909 | 37.7569484049338 | -122.442034474193 | (37.7569484049338, -122.442034474193) | 2 | 4 | 5 | 28862 | 38 | ||||
91095 | 197506 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1079 Le Conte Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012767.16405 | 2089807.75284 | 37.7189329737454 | -122.397863208018 | (37.7189329737454, -122.397863208018) | 10 | 3 | 8 | 58 | 1 | |||
94236 | 239572 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 396 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003432.67407 | 2098660.37482 | 37.7427160111273 | -122.43076026277 | (37.7427160111273, -122.43076026277) | 2 | 7 | 5 | 63 | 22 | |||
94390 | 100751 | Undocumented 4 | Schinus molle :: California Pepper 91 | 767 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002451 | 2103738 | 37.7566023024977 | -122.434517581577 | (37.7566023024977, -122.434517581577) | 2 | 4 | 5 | 28862 | 3 | |||
95494 | 136372 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2005 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999418.04323 | 2115732.63691 | 37.7893638888782 | -122.445869229291 | (37.7893638888782, -122.445869229291) | 13 | 6 | 1 | 29490 | 31 | |||
95933 | 217745 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 641 Frederick St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5996420.96236 | 2107271.42438 | 37.7659600380538 | -122.45562688879 | (37.7659600380538, -122.45562688879) | 15 | 5 | 11 | 29492 | 12 | |||
95974 | 239591 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1436 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001977.64645 | 2099818.19455 | 37.7458125684911 | -122.435874148776 | (37.7458125684911, -122.435874148776) | 2 | 7 | 5 | 63 | 22 | |||
97929 | 217735 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 723 Frederick St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5996116.65034 | 2107229.99676 | 37.7658288206775 | -122.456676438985 | (37.7658288206775, -122.456676438985) | 15 | 5 | 11 | 29492 | 12 | |||
98337 | 239657 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 671 Church St | 4 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004329.6886 | 2104859.6882 | 37.7597886599416 | -122.428100332557 | (37.7597886599416, -122.428100332557) | 2 | 4 | 5 | 28862 | 3 | |||
98484 | 239610 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 342 Prospect Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 3ft | 6006341.94877 | 2097874.88988 | 37.7407236449682 | -122.420645058033 | (37.7407236449682, -122.420645058033) | 2 | 7 | 7 | 28859 | 2 | |||
98626 | 104776 | Undocumented 4 | Schinus molle :: California Pepper 91 | 767 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6002481.8 | 2103753.5 | 37.7566466101352 | -122.434412172394 | (37.7566466101352, -122.434412172394) | 2 | 4 | 5 | 28862 | 3 | |||
98903 | 239612 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 220 Esmeralda Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007237.85888 | 2098768.99356 | 37.7432291067493 | -122.417610687906 | (37.7432291067493, -122.417610687906) | 2 | 7 | 7 | 28859 | 2 | |||
98928 | 136366 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2323 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001763.72183 | 2119055.52403 | 37.7986213292711 | -122.437991580064 | (37.7986213292711, -122.437991580064) | 13 | 9 | 1 | 57 | 17 | |||
99414 | 214166 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 25 Hazelwood Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5996590.09341 | 2093838.6494 | 37.729086671304 | -122.454071648891 | (37.729086671304, -122.454071648891) | 9 | 7 | 4 | 28861 | 40 | |||
99586 | 117533 | Undocumented 4 | Schinus molle :: California Pepper 91 | 870 PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6002404 | 2109622 | 37.7727556633357 | -122.435100948925 | (37.7727556633357, -122.435100948925) | 15 | 5 | 11 | 29492 | 9 | ||||
99960 | 239625 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 811 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002472.06672 | 2103464.35538 | 37.7558521357906 | -122.434425161094 | (37.7558521357906, -122.434425161094) | 2 | 4 | 5 | 28862 | 22 | |||
99964 | 97673 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 547 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003039 | 2098885 | 37.7433104678167 | -122.43213751159 | (37.7433104678167, -122.43213751159) | 2 | 7 | 5 | 63 | 22 | |||||
100527 | 187546 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1399 Somerset St | 2 | Side Yard : Yard | Tree | Private 2 | 24 | 6011366.67431 | 2088362.22575 | 37.7148857547405 | -122.402602582141 | (37.7148857547405, -122.402602582141) | 10 | 7 | 8 | 309 | 39 | ||||
100553 | 100750 | Undocumented 4 | Schinus molle :: California Pepper 91 | 757 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6002448 | 2103795 | 37.7567586405263 | -122.434532032094 | (37.7567586405263, -122.434532032094) | 2 | 4 | 5 | 28862 | 3 | |||
102833 | 214157 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 Vista Verde Ct | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999199.91271 | 2096059.32177 | 37.7353334179866 | -122.445208921854 | (37.7353334179866, -122.445208921854) | 9 | 7 | 4 | 63 | 40 | |||
103494 | 239624 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 817 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002470.85858 | 2103435.32507 | 37.7557723569304 | -122.434427263721 | (37.7557723569304, -122.434427263721) | 2 | 4 | 5 | 28862 | 22 | |||
104806 | 12260 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 611 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004921 | 2111005 | 37.7766956463335 | -122.426492853872 | (37.7766956463335, -122.426492853872) | 7 | 9 | 11 | 28852 | 10 | |||
104997 | 245452 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2700 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6008618.5823 | 2106848.9813 | 37.7654925250272 | -122.413407794567 | (37.7654925250272, -122.413407794567) | 8 | 4 | 7 | 28853 | 19 | |||
105314 | 239626 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3885 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002499.39714 | 2103536.73091 | 37.7560524130043 | -122.434335817949 | (37.7560524130043, -122.434335817949) | 2 | 4 | 5 | 28862 | 22 | |||
107727 | 136369 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2945 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000984.79842 | 2118544.66291 | 37.7971743129098 | -122.440650232318 | (37.7971743129098, -122.440650232318) | 13 | 9 | 1 | 57 | 17 | |||
108016 | 239647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004225.35965 | 2104505.85925 | 37.7588112263749 | -122.428435935269 | (37.7588112263749, -122.428435935269) | 2 | 4 | 5 | 28862 | 3 | |||
108429 | 117357 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6004937.66325 | 2110937.75927 | 37.7765119617013 | -122.426430421921 | (37.7765119617013, -122.426430421921) | 7 | 9 | 11 | 28852 | 10 | |||
109460 | 122117 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 141 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5990819.37104 | 2114444.89613 | 37.7853333844834 | -122.475525275427 | (37.7853333844834, -122.475525275427) | 11 | 6 | 2 | 54 | 26 | |||
109994 | 15661 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005100.74203 | 2095958.24727 | 37.7353909444416 | -122.424800364285 | (37.7353909444416, -122.424800364285) | 2 | 7 | 5 | 28859 | 2 | |||
112033 | 239613 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 200 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007098.78535 | 2096984.45251 | 37.7383213273752 | -122.417965090943 | (37.7383213273752, -122.417965090943) | 2 | 7 | 7 | 28859 | 2 | |||
112273 | 179424 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 367 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6005868 | 2092014 | 37.7246042151677 | -122.421867578972 | (37.7246042151677, -122.421867578972) | 9 | 7 | 7 | 309 | 5 | |||
112280 | 239644 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4 Ford St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003494.59862 | 2105679.78343 | 37.7619931617634 | -122.431047029612 | (37.7619931617634, -122.431047029612) | 15 | 4 | 5 | 28862 | 3 | |||
112295 | 63956 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 4232 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/1992 12:00:00 AM | 6002352.24062254 | 2101234.22323777 | 37.7497219215876 | -122.434680095003 | (37.7497219215876, -122.434680095003) | 2 | 4 | 5 | 28862 | 22 | |||
113901 | 12257 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004946.44345 | 2111002.77203 | 37.7766909671748 | -122.426404678747 | (37.7766909671748, -122.426404678747) | 7 | 9 | 11 | 28852 | 10 | |||
114058 | 239648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 211 Cumberland St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004246.22251 | 2104509.47954 | 37.7588223473949 | -122.42836403987 | (37.7588223473949, -122.42836403987) | 2 | 4 | 5 | 28862 | 3 | |||
114455 | 239593 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 636 Douglass St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6001191.36102 | 2102681.58859 | 37.7536300665832 | -122.438798157734 | (37.7536300665832, -122.438798157734) | 2 | 4 | 5 | 28862 | 22 | |||
115227 | 239665 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3977 22nd St | 7 | : | Tree | Private 2 | 1 | 6001970.62949 | 2102924.44279 | 37.7543411893077 | -122.436120656556 | (37.7543411893077, -122.436120656556) | 2 | 4 | 5 | 28862 | 22 | ||||
115611 | 214163 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 274 Tara St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997748.47431 | 2090294.62139 | 37.7194219549502 | -122.449811751014 | (37.7194219549502, -122.449811751014) | 9 | 8 | 6 | 28861 | 24 | |||
116094 | 197488 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 29 | Front Yard : Yard | Tree | Private 2 | 9 | 6015374.95978 | 2102473.44448 | 37.753855273025 | -122.389733174866 | (37.753855273025, -122.389733174866) | 10 | 3 | 8 | 28856 | 29 | ||||
116574 | 239573 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 282 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6004076.80225 | 2099571.54345 | 37.7452543431158 | -122.428597987734 | (37.7452543431158, -122.428597987734) | 2 | 7 | 5 | 63 | 22 | |||
117373 | 239600 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4255 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6000853.41096 | 2102858.4973 | 37.754096582697 | -122.439979544931 | (37.754096582697, -122.439979544931) | 2 | 4 | 5 | 28862 | 22 | |||
119469 | 214167 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993435.67173 | 2102452.28847 | 37.7525561798324 | -122.465602172524 | (37.7525561798324, -122.465602172524) | 1 | 8 | 4 | 29491 | 12 | |||
119856 | 239663 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1134 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6002486.58464 | 2102202.41494 | 37.7523879724368 | -122.434284738254 | (37.7523879724368, -122.434284738254) | 2 | 4 | 5 | 28862 | 22 | |||
120041 | 197495 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013600.82032 | 2103923.07952 | 37.757737117488 | -122.39597018278 | (37.757737117488, -122.39597018278) | 10 | 3 | 8 | 28856 | 29 | ||||
120428 | 239651 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 767 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002456.2179 | 2103744.61211 | 37.7566207539655 | -122.434500008976 | (37.7566207539655, -122.434500008976) | 2 | 4 | 5 | 28862 | 3 | |||
120800 | 239577 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3961 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6004128.58692 | 2100700.88045 | 37.7483581715004 | -122.428499407621 | (37.7483581715004, -122.428499407621) | 2 | 4 | 5 | 63 | 22 | |||
121655 | 239575 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1366 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6003880.55635 | 2100301.83973 | 37.7472484593616 | -122.42932864013 | (37.7472484593616, -122.42932864013) | 2 | 7 | 5 | 63 | 22 | |||
122190 | 239601 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4315 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001018.49265 | 2103293.22516 | 37.7552996363918 | -122.439439814104 | (37.7552996363918, -122.439439814104) | 2 | 4 | 5 | 28862 | 22 | |||
122194 | 239589 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 225 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003864.64018 | 2095248.99329 | 37.7333735991966 | -122.429023476774 | (37.7333735991966, -122.429023476774) | 9 | 7 | 5 | 28861 | 25 | |||
124417 | 239608 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 149 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007254.62958 | 2098290.95874 | 37.7419174734269 | -122.417518826646 | (37.7419174734269, -122.417518826646) | 2 | 7 | 7 | 28859 | 2 | |||
125113 | 214170 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 158 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5999431.23761 | 2093723.53638 | 37.7289331003841 | -122.444241352082 | (37.7289331003841, -122.444241352082) | 9 | 7 | 4 | 63 | 40 | |||
125492 | 119663 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
126077 | 138851 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 602 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004934.5518 | 2110939.3444 | 37.7765161381936 | -122.426441298216 | (37.7765161381936, -122.426441298216) | 7 | 9 | 11 | 28852 | 10 | |||
128125 | 197491 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900x Carolina St | 23 | Median : Yard | Tree | DPW 1 | 1 | 6012477.42612 | 2103497.47149 | 37.7565059267156 | -122.399825482885 | (37.7565059267156, -122.399825482885) | 10 | 3 | 8 | 28856 | 29 | ||||
128342 | 239654 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3512 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6004884 | 2103735 | 37.7567318772846 | -122.42610317358 | (37.7567318772846, -122.42610317358) | 2 | 4 | 5 | 28862 | 3 | |||
128408 | 239640 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3627 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004151.81834 | 2103627.38126 | 37.756394971966 | -122.428627654542 | (37.756394971966, -122.428627654542) | 2 | 4 | 5 | 28862 | 22 | |||
128413 | 244460 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 690 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003277.2679 | 2109662.4318 | 37.7729162274022 | -122.432083107592 | (37.7729162274022, -122.432083107592) | 15 | 9 | 11 | 29492 | 10 | |||
129788 | 239614 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 249 Precita Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007957.74109 | 2100292.59771 | 37.7474530659031 | -122.41522934697 | (37.7474530659031, -122.41522934697) | 2 | 7 | 7 | 28859 | 2 | |||
129925 | 200733 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1462 Oakdale Ave | 3 | unknown : Yard | Tree | Private 2 | 14 | Width 0ft | 6015790.512 | 2094948.0194 | 37.7332150397253 | -122.387771048105 | (37.7332150397253, -122.387771048105) | 10 | 3 | 8 | 58 | 1 | |||
130978 | 20249 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1880 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2000 12:00:00 AM | 10 | 3X3 | 6002546.9119 | 2114591.5393 | 37.7864088846335 | -122.43496207541 | (37.7864088846335, -122.43496207541) | 13 | 9 | 11 | 29490 | 27 | ||
131779 | 4362 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 951 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001187.63557 | 2096055.63136 | 37.7354365441677 | -122.438336378342 | (37.7354365441677, -122.438336378342) | 2 | 7 | 5 | 63 | 7 | |||
131919 | 239655 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 315 Sanchez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003584.30488 | 2106480.06785 | 37.7641956329586 | -122.430793883956 | (37.7641956329586, -122.430793883956) | 8 | 4 | 5 | 28862 | 3 | |||
132442 | 239661 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1128 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 6ft | 6002484.84221 | 2102239.39907 | 37.7524894231662 | -122.434293407712 | (37.7524894231662, -122.434293407712) | 2 | 4 | 5 | 28862 | 22 | |||
132503 | 239660 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1116 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002481.9632 | 2102282.2017 | 37.7526067855982 | -122.434306423626 | (37.7526067855982, -122.434306423626) | 2 | 4 | 5 | 28862 | 22 | |||
132843 | 119662 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
133494 | 136375 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2880 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 5999802.94718 | 2117441.8408 | 37.7940788832989 | -122.44466041095 | (37.7940788832989, -122.44466041095) | 13 | 9 | 1 | 57 | 27 | |||
133977 | 187556 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 23 | 6011365.57696 | 2088364.56073 | 37.7148921048592 | -122.402606539166 | (37.7148921048592, -122.402606539166) | 10 | 7 | 8 | 309 | 39 | ||||
134061 | 239607 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 189 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6007238.5342 | 2097885.55109 | 37.7408034085529 | -122.417545753258 | (37.7408034085529, -122.417545753258) | 2 | 7 | 7 | 28859 | 2 | |||
134487 | 239620 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 455 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001841.52504 | 2103217.25207 | 37.7551378375593 | -122.436588089066 | (37.7551378375593, -122.436588089066) | 2 | 4 | 5 | 28862 | 22 | |||
135191 | 239568 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 547 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6003022.32339 | 2098879.77623 | 37.7432951790362 | -122.432194801972 | (37.7432951790362, -122.432194801972) | 2 | 7 | 5 | 63 | 22 | |||
135825 | 239592 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1643 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6002072.60016 | 2099184.21674 | 37.7440772079026 | -122.435500467872 | (37.7440772079026, -122.435500467872) | 2 | 7 | 5 | 63 | 22 | |||
135975 | 239619 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 4145 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6001541.55358 | 2103483.24744 | 37.7558511456308 | -122.437644524497 | (37.7558511456308, -122.437644524497) | 2 | 4 | 5 | 28862 | 22 | |||
136689 | 214160 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 250 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5999436.94421 | 2094022.09374 | 37.7297531948487 | -122.44424306977 | (37.7297531948487, -122.44424306977) | 9 | 7 | 4 | 63 | 40 | |||
136874 | 136371 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3518 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002669.28578 | 2120724.92735 | 37.8032565295236 | -122.434977502225 | (37.8032565295236, -122.434977502225) | 13 | 9 | 1 | 57 | 17 | |||
137040 | 104775 | Undocumented 4 | Schinus molle :: California Pepper 91 | 771 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6002522.3 | 2103728.6 | 37.7565805395296 | -122.434270328818 | (37.7565805395296, -122.434270328818) | 2 | 4 | 5 | 28862 | 3 | |||
137756 | 239587 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 105 Elsie St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 5ft | 6007266.87289 | 2098693.35025 | 37.7430230396951 | -122.417505004957 | (37.7430230396951, -122.417505004957) | 2 | 7 | 7 | 28859 | 2 | |||
137902 | 239618 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 703 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6001824.43589 | 2102039.44346 | 37.751902886217 | -122.436562889192 | (37.751902886217, -122.436562889192) | 2 | 4 | 5 | 28862 | 22 | |||
139364 | 29613 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.63654 | 2090933.64994 | 37.7207977908582 | -122.472609073865 | (37.7207977908582, -122.472609073865) | 9 | 8 | 4 | 64 | 40 | ||
139465 | 247659 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 129 Divisadero St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6001899.88473 | 2108418.65056 | 37.7694229261437 | -122.436758580761 | (37.7694229261437, -122.436758580761) | 15 | 5 | 5 | 29492 | 9 | |||
140313 | 197502 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1799 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6013459.53083 | 2101928.68892 | 37.752253090306 | -122.396319040597 | (37.752253090306, -122.396319040597) | 10 | 3 | 8 | 28856 | 1 | |||
141132 | 136380 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1023 Broadway | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 3ft | 6008680.39017 | 2118276.96424 | 37.7968745041214 | -122.414002532311 | (37.7968745041214, -122.414002532311) | 5 | 1 | 10 | 308 | 21 | |||
141927 | 197501 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1101 Connecticut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6013434.27998 | 2101904.95506 | 37.752186517095 | -122.396404699215 | (37.752186517095, -122.396404699215) | 10 | 3 | 8 | 28856 | 1 | |||
142827 | 239622 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 504 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003013.03896 | 2103315.76974 | 37.7554748476953 | -122.43254369215 | (37.7554748476953, -122.43254369215) | 2 | 4 | 5 | 28862 | 22 | |||
144402 | 187554 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3960 Somerset St | 3 | Side Yard : Yard | Tree | Private 2 | 12 | 6011368.52295 | 2088357.85007 | 37.7148738432156 | -122.402595884908 | (37.7148738432156, -122.402595884908) | 10 | 7 | 8 | 309 | 39 | ||||
145663 | 119666 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );