trees
332 rows where qSpecies_id = 121 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4089 | 260964 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
4630 | 261689 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
6430 | 260967 | Significant Tree 6 | Fraxinus spp :: Ash Spp 121 | 1100x Vermont St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010509 | 2103658 | 37.7568367689384 | -122.406644345083 | (37.7568367689384, -122.406644345083) | 10 | 4 | 8 | 28859 | 19 | ||||
51889 | 33479 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
53565 | 92547 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 99 Santa Marina St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52890 | 6006207.5 | 2097640.2 | 37.740071660795 | -122.421093271685 | (37.740071660795, -122.421093271685) | 2 | 7 | 7 | 28859 | 2 | |||
56172 | 41689 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | Permit Number 42143 | 6001812.4652313 | 2096668.95095007 | 37.7371560974157 | -122.436219989049 | (37.7371560974157, -122.436219989049) | 2 | 7 | 5 | 63 | 7 | |||
64625 | 64914 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1989 12:00:00 AM | 4x4 | Permit Number 25941 | 6005478.3629861 | 2099307.48712071 | 37.7446085231046 | -122.42373284962 | (37.7446085231046, -122.42373284962) | 2 | 7 | 5 | 28859 | 22 | |
71855 | 251708 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 239 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2005 12:00:00 AM | 3x3 | Permit Number 776109 | 6008639.31193 | 2109768.77693 | 37.7735107666471 | -122.413542618094 | (37.7735107666471, -122.413542618094) | 8 | 2 | 9 | 28853 | 34 | ||
87961 | 33480 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
107520 | 113749 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 459 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998867 | 2109101 | 37.7711236529318 | -122.447298272426 | (37.7711236529318, -122.447298272426) | 15 | 5 | 11 | 29492 | 9 | ||||
124022 | 98345 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998016 | 2107622 | 37.767014032658 | -122.45013527715 | (37.767014032658, -122.45013527715) | 15 | 5 | 11 | 29492 | 9 | ||||
131691 | 56260 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 238 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | Permit Number 12386 | 5997570.92464879 | 2106477.05534424 | 37.7638448267197 | -122.451592119849 | (37.7638448267197, -122.451592119849) | 15 | 5 | 11 | 29492 | 9 | |||
145418 | 33476 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
161506 | 33474 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
162422 | 115825 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 403 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 5998362 | 2109233 | 37.7714572219689 | -122.449054588277 | (37.7714572219689, -122.449054588277) | 15 | 5 | 11 | 29492 | 9 | ||||
171708 | 56058 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 2858 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/2007 12:00:00 AM | 3x3 | Permit Number 49940 | 6009112.81160157 | 2103362.97509043 | 37.7559484836074 | -122.411452058073 | (37.7559484836074, -122.411452058073) | 2 | 4 | 7 | 28859 | 19 | ||
180942 | 33477 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
186776 | 33478 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.7428610132017 | -122.420369801641 | (37.7428610132017, -122.420369801641) | 2 | 7 | 7 | 28859 | 2 | |||
190161 | 252991 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 65 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005528 | 2099293 | 37.7445715466522 | -122.423560184697 | (37.7445715466522, -122.423560184697) | 2 | 7 | 5 | 28859 | 22 | ||||
14434 | 225800 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 839 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 6003765.43327 | 2103426.88271 | 37.7558225759747 | -122.429949607592 | (37.7558225759747, -122.429949607592) | 2 | 4 | 5 | 28862 | 22 | |||
33336 | 192346 | Planning Code 138.1 required 2 | Fraxinus spp :: Ash Spp 121 | 118 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2014 12:00:00 AM | 1 | Width 3ft | Permit Number 770901 | 6007994.19176 | 2110350.54528 | 37.7750719195804 | -122.415815392882 | (37.7750719195804, -122.415815392882) | 8 | 2 | 9 | 28853 | 34 | |
48965 | 192240 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009484.38016 | 2108422.4744 | 37.7698615480128 | -122.41052430446 | (37.7698615480128, -122.41052430446) | 8 | 2 | 9 | 28853 | 34 | |||
82148 | 192345 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007899.18679 | 2110450.27855 | 37.7753404220484 | -122.416151101713 | (37.7753404220484, -122.416151101713) | 8 | 2 | 9 | 28853 | 34 | |||
103636 | 192343 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007880.06697 | 2110469.37964 | 37.7753917940266 | -122.416218594918 | (37.7753917940266, -122.416218594918) | 8 | 2 | 9 | 28853 | 34 | |||
109256 | 225789 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 409 Dellbrook Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997048.20072 | 2102795.35511 | 37.7537058578562 | -122.453134258532 | (37.7537058578562, -122.453134258532) | 1 | 5 | 4 | 63 | 38 | |||
122862 | 192251 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009321.46168 | 2108343.14872 | 37.769634603179 | -122.411082233959 | (37.769634603179, -122.411082233959) | 8 | 2 | 9 | 28853 | 34 | |||
156154 | 192341 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007845.73397 | 2110504.26388 | 37.7754856472738 | -122.416339832511 | (37.7754856472738, -122.416339832511) | 8 | 2 | 9 | 28853 | 34 | |||
162930 | 192247 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1192 Bryant St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009385.61181 | 2108329.66334 | 37.7696011726904 | -122.410859387372 | (37.7696011726904, -122.410859387372) | 8 | 2 | 9 | 28853 | 34 | |||
165605 | 192342 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007873.4377 | 2110478.31059 | 37.7754159435306 | -122.416242159861 | (37.7754159435306, -122.416242159861) | 8 | 2 | 9 | 28853 | 34 | |||
175702 | 192274 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009024.55442 | 2108760.36704 | 37.7707635329468 | -122.412138720645 | (37.7707635329468, -122.412138720645) | 8 | 2 | 9 | 28853 | 34 | |||
175898 | 192288 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009225.94574 | 2108950.58791 | 37.7712971330939 | -122.411455542555 | (37.7712971330939, -122.411455542555) | 8 | 2 | 9 | 28853 | 34 | |||
177007 | 192344 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007890.6883 | 2110458.72798 | 37.7753631443241 | -122.416181098592 | (37.7753631443241, -122.416181098592) | 8 | 2 | 9 | 28853 | 34 | |||
179230 | 192340 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 10 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007835.15686 | 2110517.07341 | 37.7755202244095 | -122.416377328869 | (37.7755202244095, -122.416377328869) | 8 | 2 | 9 | 28853 | 34 | |||
179894 | 192217 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009459.54264 | 2108818.21129 | 37.7709467572235 | -122.410638167623 | (37.7709467572235, -122.410638167623) | 8 | 2 | 9 | 28853 | 34 | |||
182350 | 192222 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 340 10th St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009520.50113 | 2108752.11009 | 37.7707686761527 | -122.410422641486 | (37.7707686761527, -122.410422641486) | 8 | 2 | 9 | 28853 | 34 | |||
54804 | 192303 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2250 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011758.17653 | 2102347.83114 | 37.7533091435026 | -122.402232092032 | (37.7533091435026, -122.402232092032) | 10 | 3 | 8 | 28856 | 29 | |||
81032 | 225806 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 363 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001815.68909 | 2103737.40207 | 37.7565645760008 | -122.43671466866 | (37.7565645760008, -122.43671466866) | 2 | 4 | 5 | 28862 | 3 | |||
85835 | 225818 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 98 Hill St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005774.11943 | 2103465.5032 | 37.7560421706386 | -122.423005656989 | (37.7560421706386, -122.423005656989) | 2 | 4 | 5 | 28859 | 19 | |||
87845 | 218968 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 150 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5993617.45125 | 2101661.58733 | 37.7503955999976 | -122.464916133678 | (37.7503955999976, -122.464916133678) | 1 | 8 | 4 | 29491 | 40 | |||
104963 | 96698 | Undocumented 4 | Fraxinus spp :: Ash Spp 121 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5997732 | 2108845 | 37.7703558220967 | -122.451205793491 | (37.7703558220967, -122.451205793491) | 15 | 5 | 11 | 29492 | 9 | |||
120312 | 218971 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 736 Myra Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5997513.55349 | 2097982.45512 | 37.7405174763054 | -122.451177906656 | (37.7405174763054, -122.451177906656) | 9 | 7 | 4 | 59 | 40 | |||
132736 | 59144 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 690 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 10 | Permit Number 18451 | 5992269.28731 | 2110774.72924 | 37.7753400527011 | -122.470241689466 | (37.7753400527011, -122.470241689466) | 11 | 6 | 2 | 54 | 11 | ||
150760 | 116066 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 40 MALTA DR | Median : Cutout | Tree | DPW 1 | 10 | 5999623 | 2096071 | 37.7353896244756 | -122.443746996044 | (37.7353896244756, -122.443746996044) | 9 | 7 | 4 | 63 | 40 | |||||
151521 | 192354 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1400 Quint St | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6013388.36583 | 2096606.99697 | 37.7376368893361 | -122.39619220742 | (37.7376368893361, -122.39619220742) | 10 | 3 | 8 | 58 | 1 | |||
158413 | 45645 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1020 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2001 12:00:00 AM | 10 | Permit Number 44346 | 6011201.47957 | 2118401.58307 | 37.7973579490636 | -122.40528770509 | (37.7973579490636, -122.40528770509) | 3 | 1 | 10 | 308 | 23 | ||
159188 | 68672 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 260 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32580 | 5993093.46375 | 2113748.31872 | 37.7835523382358 | -122.467606994541 | (37.7835523382358, -122.467606994541) | 11 | 6 | 2 | 54 | 11 | |
182398 | 244215 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1849 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5997712.0535 | 2108841.8253 | 37.7703459631123 | -122.451274559097 | (37.7703459631123, -122.451274559097) | 15 | 5 | 11 | 29492 | 9 | |||
193605 | 192254 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009288.06087 | 2108377.07949 | 37.7697258960749 | -122.411200163874 | (37.7697258960749, -122.411200163874) | 8 | 2 | 9 | 28853 | 34 | |||
193731 | 192258 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009238.32682 | 2108428.66995 | 37.7698647621884 | -122.411375838327 | (37.7698647621884, -122.411375838327) | 8 | 2 | 9 | 28853 | 34 | |||
9452 | 225805 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 367 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001818.89494 | 2103707.75244 | 37.7564833474558 | -122.436701459403 | (37.7564833474558, -122.436701459403) | 2 | 4 | 5 | 28862 | 3 | |||
32820 | 192262 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 450 11th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009184.59268 | 2108480.10836 | 37.7700029861676 | -122.41156533899 | (37.7700029861676, -122.41156533899) | 8 | 2 | 9 | 28853 | 34 | |||
43782 | 192315 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6011711.98857 | 2107614.42243 | 37.7677674532432 | -122.402762177653 | (37.7677674532432, -122.402762177653) | 8 | 2 | 8 | 28853 | 20 | |||
45266 | 192356 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1400 Quint St | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6013361.05471 | 2096570.45075 | 37.7375350213353 | -122.396284074954 | (37.7375350213353, -122.396284074954) | 10 | 3 | 8 | 58 | 1 | |||
48366 | 225804 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 4433 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001581.80688 | 2104063.4307 | 37.7574464772949 | -122.437546862602 | (37.7574464772949, -122.437546862602) | 2 | 4 | 5 | 28862 | 3 | |||
70514 | 192325 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6011700.9501 | 2107853.89642 | 37.7684243783132 | -122.402817202662 | (37.7684243783132, -122.402817202662) | 8 | 2 | 8 | 28853 | 20 | |||
98908 | 218975 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 25 Lakewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993599.79076 | 2092994.21987 | 37.7265961562865 | -122.464347997761 | (37.7265961562865, -122.464347997761) | 9 | 8 | 4 | 59 | 40 | |||
119103 | 225798 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3000X 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008119.80842 | 2103888.79141 | 37.7573365081987 | -122.414923414683 | (37.7573365081987, -122.414923414683) | 2 | 4 | 7 | 28859 | 19 | |||
126267 | 192283 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009158.56943 | 2108886.63938 | 37.7711177659971 | -122.411684081879 | (37.7711177659971, -122.411684081879) | 8 | 2 | 9 | 28853 | 34 | |||
142474 | 225801 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 4201 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001928.34635 | 2105251.90853 | 37.7607294461137 | -122.43643345245 | (37.7607294461137, -122.43643345245) | 2 | 4 | 5 | 28862 | 3 | |||
154444 | 128809 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 2798 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000135.50576 | 2117439.15627 | 37.7940904836317 | -122.443509534145 | (37.7940904836317, -122.443509534145) | 13 | 9 | 1 | 57 | 27 | |||
174707 | 192296 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 551 Utah St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010697.50187 | 2105678.84279 | 37.7623960949381 | -122.406134800806 | (37.7623960949381, -122.406134800806) | 8 | 4 | 8 | 28859 | 19 | |||
6276 | 11636 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
14901 | 75920 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6011822.33856 | 2118769.30011 | 37.7984023029841 | -122.403165240278 | (37.7984023029841, -122.403165240278) | 3 | 1 | 10 | 308 | 23 | |||
25853 | 225384 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004767.45942 | 2101889.24161 | 37.7516572687753 | -122.426374799776 | (37.7516572687753, -122.426374799776) | 2 | 4 | 5 | 28862 | 22 | |||
32271 | 128824 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 600 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011998.07084 | 2115236.96461 | 37.7887131646294 | -122.402308656723 | (37.7887131646294, -122.402308656723) | 4 | 2 | 10 | 28854 | 6 | |||
34565 | 25983 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1901 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6013395.85675 | 2096673.78587 | 37.7378206945684 | -122.396170987024 | (37.7378206945684, -122.396170987024) | 10 | 3 | 8 | 58 | 1 | |||
49083 | 192307 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011941.53927 | 2107440.75625 | 37.7673034192378 | -122.40195597501 | (37.7673034192378, -122.40195597501) | 8 | 3 | 8 | 28853 | 20 | |||
52573 | 225803 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 378 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001778.51091 | 2103657.66309 | 37.7563435190568 | -122.436837535831 | (37.7563435190568, -122.436837535831) | 2 | 4 | 5 | 28862 | 3 | |||
54925 | 56313 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 229 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12447 | 5993040.18993 | 2113916.11955 | 37.7840099974474 | -122.467803508187 | (37.7840099974474, -122.467803508187) | 11 | 6 | 2 | 54 | 11 | ||
62371 | 25984 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1901 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2x2 | 6013408.21183 | 2096665.53237 | 37.7377987196205 | -122.396127690947 | (37.7377987196205, -122.396127690947) | 10 | 3 | 8 | 58 | 1 | |||
66004 | 192322 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011704.56892 | 2107781.11389 | 37.7682247360183 | -122.402799566063 | (37.7682247360183, -122.402799566063) | 8 | 2 | 8 | 28853 | 20 | |||
75708 | 192287 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1490 Harrison St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009214.87169 | 2108937.93629 | 37.7712617735482 | -122.41149295434 | (37.7712617735482, -122.41149295434) | 8 | 2 | 9 | 28853 | 34 | |||
79918 | 192317 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011711.332 | 2107662.3671 | 37.7678990618091 | -122.402767820894 | (37.7678990618091, -122.402767820894) | 8 | 2 | 8 | 28853 | 20 | |||
89514 | 11634 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 499X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | 9 | 8 | 4 | 59 | 40 | |||
93940 | 16628 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 147 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2006 12:00:00 AM | 12 | 3X3 | 6002889.82891 | 2107449.635 | 37.7668184571199 | -122.433265159761 | (37.7668184571199, -122.433265159761) | 15 | 5 | 5 | 28862 | 3 | ||
100357 | 11657 | Permitted Site 7 | Fraxinus spp :: Ash Spp 121 | 699X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 12 | 3 | 5991405.9818619 | 2093130.1790735 | 37.7268427672434 | -122.471941747662 | (37.7268427672434, -122.471941747662) | 9 | 8 | 4 | 59 | 40 | |||
119932 | 192321 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011705.72913 | 2107757.93723 | 37.7681611629347 | -122.402793922805 | (37.7681611629347, -122.402793922805) | 8 | 2 | 8 | 28853 | 20 | |||
139494 | 225779 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1559 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999770.51083 | 2107118.59811 | 37.7657320617173 | -122.444030542889 | (37.7657320617173, -122.444030542889) | 15 | 5 | 5 | 29492 | 9 | |||
150506 | 192308 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6011941.9905 | 2107419.77079 | 37.7672458230764 | -122.401952938871 | (37.7672458230764, -122.401952938871) | 8 | 3 | 8 | 28853 | 20 | |||
156488 | 59101 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 654 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 12 | Permit Number 18403 | 5993502.53489 | 2111016.0685 | 37.7760739276641 | -122.465993175595 | (37.7760739276641, -122.465993175595) | 11 | 6 | 2 | 54 | 11 | ||
158333 | 192295 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 551 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6010700.61238 | 2105651.26498 | 37.7623205464704 | -122.406122099663 | (37.7623205464704, -122.406122099663) | 8 | 4 | 8 | 28859 | 19 | |||
179954 | 192318 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6011708.94846 | 2107685.56864 | 37.7679626349073 | -122.402777697245 | (37.7679626349073, -122.402777697245) | 8 | 2 | 8 | 28853 | 20 | |||
190745 | 225802 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 372 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001775.08554 | 2103686.11524 | 37.7564214471208 | -122.436851418666 | (37.7564214471208, -122.436851418666) | 2 | 4 | 5 | 28862 | 3 | |||
590 | 75888 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 13 | 6011802.87578 | 2118766.0417 | 37.7983922692391 | -122.403232358505 | (37.7983922692391, -122.403232358505) | 3 | 1 | 10 | 308 | 23 | |||
18685 | 225385 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004766.71932 | 2101872.10114 | 37.7516101631948 | -122.426376138857 | (37.7516101631948, -122.426376138857) | 2 | 4 | 5 | 28862 | 22 | |||
47711 | 192324 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 193 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011702.91759 | 2107830.29721 | 37.7683596900813 | -122.40280873733 | (37.7683596900813, -122.40280873733) | 8 | 2 | 8 | 28853 | 20 | |||
51556 | 124030 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 101 Funston Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991790.36528 | 2114364.58828 | 37.7851691212148 | -122.472160105538 | (37.7851691212148, -122.472160105538) | 11 | 6 | 2 | 54 | 11 | |||
52048 | 225387 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 300 Chattanooga St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6004770.30193 | 2101839.2583 | 37.7515201869079 | -122.426361411567 | (37.7515201869079, -122.426361411567) | 2 | 4 | 5 | 28862 | 22 | |||
57801 | 59099 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 488 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 13 | Permit Number 18401 | 5993459.27292 | 2112191.28378 | 37.7792982564624 | -122.466228254831 | (37.7792982564624, -122.466228254831) | 11 | 6 | 2 | 54 | 11 | ||
60626 | 225817 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 220 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000861.2218 | 2106493.57318 | 37.7640780573843 | -122.440213192391 | (37.7640780573843, -122.440213192391) | 15 | 5 | 5 | 28862 | 3 | |||
78313 | 192320 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011706.66906 | 2107733.95245 | 37.768095358636 | -122.402788984646 | (37.768095358636, -122.402788984646) | 8 | 2 | 8 | 28853 | 20 | |||
91861 | 192309 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 100 De Haro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6011943.75233 | 2107376.90821 | 37.7671282304161 | -122.401943831469 | (37.7671282304161, -122.401943831469) | 8 | 3 | 8 | 28853 | 20 | |||
105552 | 192316 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 195 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6011712.06819 | 2107638.38647 | 37.7678332575256 | -122.402763587784 | (37.7678332575256, -122.402763587784) | 8 | 2 | 8 | 28853 | 20 | |||
136757 | 75946 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 350 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1995 12:00:00 AM | 13 | 6011842.29348 | 2118770.98259 | 37.7984080370505 | -122.403096308158 | (37.7984080370505, -122.403096308158) | 3 | 1 | 10 | 308 | 23 | ||
156453 | 192294 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 551 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6010701.8989 | 2105624.20056 | 37.7622463056326 | -122.40611574324 | (37.7622463056326, -122.40611574324) | 8 | 4 | 8 | 28859 | 19 | |||
158018 | 192355 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1400 Quint St | 2 | : | Tree | Private 2 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.396233670642 | (37.7375943028269, -122.396233670642) | 10 | 3 | 8 | 58 | 1 | |||
159309 | 128827 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1048 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011178.99904 | 2118580.19305 | 37.7978471119154 | -122.405378078855 | (37.7978471119154, -122.405378078855) | 3 | 1 | 10 | 308 | 23 | |||
181729 | 218974 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 211 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5995324.88397 | 2091369.23318 | 37.7222336187729 | -122.458266889107 | (37.7222336187729, -122.458266889107) | 9 | 8 | 4 | 28861 | 24 | |||
184049 | 45643 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 1020 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2001 12:00:00 AM | 13 | Permit Number 44346 | 6011195.59877 | 2118453.88611 | 37.797501231757 | -122.405311739446 | (37.797501231757, -122.405311739446) | 3 | 1 | 10 | 308 | 23 | ||
188068 | 225380 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 3200 Cesar Chavez St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008095.36431 | 2100612.74929 | 37.7483398640139 | -122.414776107534 | (37.7483398640139, -122.414776107534) | 2 | 4 | 7 | 28859 | 19 |
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) );