trees
7,322 rows where qSpecies_id = 1 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
| 1095 | 255202 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 1138 | 260594 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 2475 | 259866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 4112 | 255223 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 6640 | 255204 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 6981 | 259867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 7570 | 36838 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 7587 | 259089 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 7844 | 36854 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 8196 | 255225 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 400 Bacon St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 8832 | 260593 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 10581 | 260591 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 11185 | 98268 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401X Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
| 11245 | 255201 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 11633 | 259865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 101x Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 11767 | 255200 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 12758 | 260592 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3090x Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | ||||||||||||
| 13636 | 36840 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 13881 | 255222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1051 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 14357 | 36839 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 14394 | 36837 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 15903 | 255203 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301X Burrows St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 18459 | 36836 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/26/1998 12:00:00 AM | Permit Number 39538 | ||||||||||||||
| 1312 | 71251 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1364 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6007075.57639 | 2118114.43065 | 37.7963379640898 | -122.419544039651 | (37.7963379640898, -122.419544039651) | 5 | 1 | 10 | 28858 | 32 | |||
| 2032 | 71654 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 442 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6011342.51966 | 2119044.79856 | 37.7991319472408 | -122.404844976017 | (37.7991319472408, -122.404844976017) | 3 | 1 | 10 | 308 | 23 | |||
| 2801 | 57909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 900 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/10/1977 12:00:00 AM | 3 | Permit Number 16867 | 6009529.40724 | 2116088.3946 | 37.790912873091 | -122.410910067748 | (37.790912873091, -122.410910067748) | 5 | 1 | 10 | 28857 | 21 | |
| 3422 | 136854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 685 Geary St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008467.44267 | 2114497.67483 | 37.7864855385225 | -122.414471823731 | (37.7864855385225, -122.414471823731) | 5 | 1 | 9 | 28852 | 36 | |||
| 3494 | 75703 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1154 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011133.22449 | 2118927.94274 | 37.7987993887319 | -122.405560977554 | (37.7987993887319, -122.405560977554) | 3 | 1 | 10 | 308 | 23 | |||
| 4334 | 136909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009830.0684 | 2121639.18274 | 37.8061708284786 | -122.410261867902 | (37.8061708284786, -122.410261867902) | 3 | 1 | 10 | 308 | 23 | |||
| 4454 | 128029 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | Width 4ft | 6007868.73718 | 2121431.95 | 37.8054916838703 | -122.417034709883 | (37.8054916838703, -122.417034709883) | 5 | 1 | 10 | 308 | 23 | ||
| 4706 | 71655 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 551 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010904.1531 | 2118940.5182 | 37.7988211063956 | -122.406354529449 | (37.7988211063956, -122.406354529449) | 3 | 1 | 10 | 308 | 23 | |||
| 5092 | 31222 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 566 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 7 | Permit Number 34909 | 6010818.5641 | 2118972.1322 | 37.7989031225504 | -122.406652925798 | (37.7989031225504, -122.406652925798) | 3 | 1 | 10 | 308 | 23 | |
| 5314 | 71429 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2029 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6009865.7372 | 2121062.537 | 37.8045895022466 | -122.410097693334 | (37.8045895022466, -122.410097693334) | 3 | 1 | 10 | 308 | 23 | |||
| 6710 | 71626 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 546 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6010902.3539 | 2118984.9834 | 37.7989430963584 | -122.406363890018 | (37.7989430963584, -122.406363890018) | 3 | 1 | 10 | 308 | 23 | |||
| 9338 | 49154 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1807 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2003 12:00:00 AM | 5 | Permit Number 46276 | 6008254.79988 | 2118664.91004 | 37.7979157949336 | -122.41550265903 | (37.7979157949336, -122.41550265903) | 5 | 1 | 10 | 28858 | 21 | |
| 9650 | 71158 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 728 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6009232.04509 | 2115488.13377 | 37.7892480238112 | -122.411896496347 | (37.7892480238112, -122.411896496347) | 5 | 1 | 10 | 28857 | 21 | |||
| 10132 | 136901 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2333 Leavenworth St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 12:00:00 AM | 3 | Width 5ft | 6007536.47447 | 2120305.57509 | 37.8023802472184 | -122.41810464953 | (37.8023802472184, -122.41810464953) | 5 | 1 | 1 | 28858 | 32 | ||
| 10954 | 75645 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1154 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6011131.8005 | 2118945.02958 | 37.7988462254172 | -122.405567109137 | (37.7988462254172, -122.405567109137) | 3 | 1 | 10 | 308 | 23 | |||
| 10959 | 143055 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1729 Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010430.3624 | 2120468.8411 | 37.8029909907013 | -122.408101849493 | (37.8029909907013, -122.408101849493) | 3 | 1 | 10 | 308 | 23 | |||
| 13079 | 75759 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1154 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011137.27895 | 2118914.33148 | 37.7987622422292 | -122.405545988575 | (37.7987622422292, -122.405545988575) | 3 | 1 | 10 | 308 | 23 | |||
| 15821 | 136893 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1181 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007367.63196 | 2118799.32732 | 37.7982349652399 | -122.418582055512 | (37.7982349652399, -122.418582055512) | 5 | 1 | 10 | 28858 | 32 | |||
| 17059 | 71785 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Montgomery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011579.56023 | 2119131.56016 | 37.7993834201653 | -122.404030839573 | (37.7993834201653, -122.404030839573) | 3 | 1 | 10 | 308 | 23 | |||
| 18525 | 128025 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2018 12:00:00 AM | 3 | Width 4ft | 6007851.19839 | 2121552.20369 | 37.8058208834027 | -122.41710393162 | (37.8058208834027, -122.41710393162) | 5 | 1 | 10 | 308 | 23 | ||
| 18622 | 43041 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 California St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2000 12:00:00 AM | 4 | Permit Number 42896 | 6013121.90526 | 2116951.92225 | 37.7934847048142 | -122.398540715889 | (37.7934847048142, -122.398540715889) | 4 | 1 | 10 | 28860 | 6 | ||
| 18668 | 71959 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1253 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007487.95581 | 2115400.40107 | 37.7889091295876 | -122.417924628633 | (37.7889091295876, -122.417924628633) | 13 | 1 | 10 | 28858 | 21 | |||
| 19436 | 128031 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2601 Jones St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | Width 4ft | 6007875.63102 | 2121383.54419 | 37.8053591615717 | -122.417007420861 | (37.8053591615717, -122.417007420861) | 5 | 1 | 10 | 308 | 23 | ||
| 21591 | 52359 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 645 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007837.48852 | 2114654.59381 | 37.786880990198 | -122.416662434642 | (37.786880990198, -122.416662434642) | 13 | 1 | 9 | 28858 | 36 |
| 24670 | 142643 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2360 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6008894.7015 | 2121338.3744 | 37.8052924087646 | -122.413477585873 | (37.8052924087646, -122.413477585873) | 3 | 1 | 10 | 308 | 23 | |||
| 25891 | 136907 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 352 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779330 | 6011790.69425 | 2119110.61996 | 37.7993377175325 | -122.403298763539 | (37.7993377175325, -122.403298763539) | 3 | 1 | 10 | 308 | 23 | |
| 26255 | 136858 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 657 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6007825.30735 | 2114737.29156 | 37.7871073729566 | -122.41671043954 | (37.7871073729566, -122.41671043954) | 13 | 1 | 9 | 28858 | 36 | |||
| 28200 | 136898 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009723.43312 | 2119123.66122 | 37.7992578523185 | -122.410453160888 | (37.7992578523185, -122.410453160888) | 3 | 1 | 10 | 308 | 4 | |||
| 28490 | 111716 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2390x MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008938 | 2121373 | 37.8053899130211 | -122.413330195558 | (37.8053899130211, -122.413330195558) | 3 | 1 | 10 | 308 | 23 | ||||
| 30755 | 136843 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009226.83639 | 2115517.12487 | 37.7893273341332 | -122.411916567401 | (37.7893273341332, -122.411916567401) | 5 | 1 | 10 | 28857 | 21 | |||
| 31971 | 136896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1141 Filbert St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 6007469.2981 | 2119510.08172 | 37.8001922416361 | -122.418280679223 | (37.8001922416361, -122.418280679223) | 5 | 1 | 1 | 28858 | 32 | |||
| 33735 | 136859 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 657 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6007828.04713 | 2114722.95506 | 37.7870681625178 | -122.416699944461 | (37.7870681625178, -122.416699944461) | 13 | 1 | 9 | 28858 | 36 | |||
| 33805 | 136884 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1346 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007485.68221 | 2115803.46091 | 37.790015704896 | -122.417961079041 | (37.790015704896, -122.417961079041) | 13 | 1 | 10 | 28858 | 21 | |||
| 34308 | 105924 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 995 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2014 12:00:00 AM | 3x3 | Permit Number 769111 | 6007873.5 | 2115092.6 | 37.7880856736468 | -122.416568881841 | (37.7880856736468, -122.416568881841) | 13 | 1 | 10 | 28858 | 21 | ||
| 35057 | 33968 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 36203 | 136905 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 489 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011188.88046 | 2118982.22248 | 37.7989515396286 | -122.405372213459 | (37.7989515396286, -122.405372213459) | 3 | 1 | 10 | 308 | 23 | |||
| 36238 | 33970 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | Permit Number 37917 | 6007661.76235911 | 2121488.31416717 | 37.8056348004683 | -122.417754973992 | (37.8056348004683, -122.417754973992) | 5 | 1 | 10 | 308 | 23 | |||
| 37639 | 142928 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 535 VALLEJO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010939.1083 | 2118946.1728 | 37.7988385878677 | -122.406233971076 | (37.7988385878677, -122.406233971076) | 3 | 1 | 10 | 308 | 23 | |||
| 38230 | 249816 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1744 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6010853.01699 | 2120942.1518 | 37.8043142410716 | -122.406672612469 | (37.8043142410716, -122.406672612469) | 3 | 1 | 10 | 308 | 23 | |||
| 39816 | 136846 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 832 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008575.73176 | 2115262.36954 | 37.7885912876079 | -122.414151290059 | (37.7885912876079, -122.414151290059) | 5 | 1 | 10 | 28858 | 21 | |||
| 42555 | 136892 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1181 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007351.51754 | 2118798.12127 | 37.7982307465006 | -122.418637730772 | (37.7982307465006, -122.418637730772) | 5 | 1 | 10 | 28858 | 32 | |||
| 43924 | 136895 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1141 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6007447.28231 | 2119505.96137 | 37.8001796889091 | -122.418356570305 | (37.8001796889091, -122.418356570305) | 5 | 1 | 1 | 28858 | 32 | |||
| 44061 | 98652 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 801@Jones Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49829 | 6008750 | 2115238 | 37.7885341615981 | -122.413546621934 | (37.7885341615981, -122.413546621934) | 5 | 1 | 10 | 28858 | 21 | |||
| 46843 | 66363 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1990 12:00:00 AM | 7 | Permit Number 29484 | 6010775.7697 | 2119267.8381 | 37.7997126644202 | -122.406821861034 | (37.7997126644202, -122.406821861034) | 3 | 1 | 10 | 308 | 23 | ||
| 47405 | 136912 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 220 Front St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013058.84529 | 2116999.3227 | 37.7936113419514 | -122.398762237783 | (37.7936113419514, -122.398762237783) | 4 | 1 | 10 | 28860 | 6 | |||
| 50227 | 89042 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 740 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2008 12:00:00 AM | 3x3 | Permit Number 51781 | 6009231 | 2115470 | 37.7891981742353 | -122.411898830301 | (37.7891981742353, -122.411898830301) | 5 | 1 | 10 | 28857 | 21 | |||
| 52241 | 143090 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6009917.0126 | 2120239.8067 | 37.8023333626961 | -122.409862137219 | (37.8023333626961, -122.409862137219) | 3 | 1 | 10 | 308 | 23 | |||
| 52839 | 115077 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2371X MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008645 | 2121254 | 37.8050467143555 | -122.414335738873 | (37.8050467143555, -122.414335738873) | 3 | 1 | 10 | 308 | 23 | |||
| 57514 | 136877 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1270 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007359.86964 | 2115441.61687 | 37.7890150886326 | -122.418370713951 | (37.7890150886326, -122.418370713951) | 13 | 1 | 10 | 28858 | 21 | |||
| 62164 | 136900 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009756.40097 | 2119128.02525 | 37.7992716829875 | -122.410339388547 | (37.7992716829875, -122.410339388547) | 3 | 1 | 10 | 308 | 4 | |||
| 62561 | 34985 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 352 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/1997 12:00:00 AM | Permit Number 38563 | 6011683.65196768 | 2119096.70399263 | 37.7992935287718 | -122.403668189675 | (37.7992935287718, -122.403668189675) | 3 | 1 | 10 | 308 | 23 | |||
| 63189 | 136903 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 489 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011153.14202 | 2118978.86723 | 37.7989403286997 | -122.405495644528 | (37.7989403286997, -122.405495644528) | 3 | 1 | 10 | 308 | 23 | |||
| 63459 | 43038 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46535 | 6013143.74639 | 2116952.94383 | 37.793488726585 | -122.398465215105 | (37.793488726585, -122.398465215105) | 4 | 1 | 10 | 28860 | 6 | ||
| 63709 | 109830 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | 5 | 1 | 10 | 28852 | 21 | |||||
| 64068 | 41775 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1346 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 9 | Permit Number 42189 | 6007517.3354 | 2115809.02803 | 37.7900327722351 | -122.417851956197 | (37.7900327722351, -122.417851956197) | 13 | 1 | 10 | 28858 | 21 | |
| 64452 | 52356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 625 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 4 | Permit Number 48494 | 6007848.64495 | 2114584.12188 | 37.7866881189023 | -122.416618841793 | (37.7866881189023, -122.416618841793) | 13 | 1 | 9 | 28858 | 36 | |
| 65365 | 142917 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 616 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009970.2756 | 2119208.615 | 37.7995049493744 | -122.40960499613 | (37.7995049493744, -122.40960499613) | 3 | 1 | 10 | 308 | 4 | |||
| 68910 | 96805 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 471 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | 3x3 | Permit Number 771933 | 6011260.5 | 2118966.4 | 37.7989120989831 | -122.405123270049 | (37.7989120989831, -122.405123270049) | 3 | 1 | 10 | 308 | 23 | ||
| 71021 | 52357 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 625 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 5 | 3x3 | Permit Number 48494 | 6007849.56747 | 2114575.31498 | 37.7866639891833 | -122.416615025979 | (37.7866639891833, -122.416615025979) | 13 | 1 | 9 | 28858 | 36 |
| 73480 | 50660 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49797 | 6008816.5346 | 2120736.2648 | 37.8036347775517 | -122.413705478453 | (37.8036347775517, -122.413705478453) | 3 | 1 | 10 | 308 | 23 | |
| 73696 | 52361 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 647 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48497 | 6007836.05897 | 2114669.78847 | 37.7869226306302 | -122.416668457383 | (37.7869226306302, -122.416668457383) | 13 | 1 | 9 | 28858 | 36 |
| 76017 | 102529 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200X 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2013 12:00:00 AM | 3x3 | Permit Number 768962 | 6013046 | 2116920 | 37.7933928248556 | -122.398801114306 | (37.7933928248556, -122.398801114306) | 4 | 1 | 10 | 28860 | 6 | ||
| 76195 | 136904 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 489 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011169.9699 | 2118979.74952 | 37.7989436921596 | -122.405437476356 | (37.7989436921596, -122.405437476356) | 3 | 1 | 10 | 308 | 23 | |||
| 76783 | 65427 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 738 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1989 12:00:00 AM | 1 | Permit Number 774746 | 6010331.84975 | 2116201.13824 | 37.7912674029188 | -122.408141592969 | (37.7912674029188, -122.408141592969) | 5 | 1 | 10 | 28857 | 21 | |
| 77981 | 136878 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1270 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007341.96632 | 2115439.36334 | 37.7890078931592 | -122.418432497382 | (37.7890078931592, -122.418432497382) | 13 | 1 | 10 | 28858 | 21 | |||
| 78376 | 142916 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 610 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009998.0636 | 2119211.9495 | 37.7995156621516 | -122.409509074765 | (37.7995156621516, -122.409509074765) | 3 | 1 | 10 | 308 | 4 | |||
| 81370 | 256662 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1306 Broadway | : | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | Permit Number 782593 | 6007370.8774 | 2118134.97157 | 37.7964109931986 | -122.418523691035 | (37.7964109931986, -122.418523691035) | 5 | 1 | 10 | 28858 | 32 | ||
| 86550 | 81847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 611 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50019 | 6007860.49957 | 2114503.13892 | 37.7864664261202 | -122.416572088746 | (37.7864664261202, -122.416572088746) | 13 | 1 | 9 | 28858 | 36 | |
| 87285 | 82209 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 901 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51621 | 6007847.58999161 | 2114760.86418186 | 37.7871733508583 | -122.416635016809 | (37.7871733508583, -122.416635016809) | 13 | 1 | 9 | 28858 | 36 | ||
| 87422 | 136910 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009806.2153 | 2121790.84358 | 37.8065859141719 | -122.410355131177 | (37.8065859141719, -122.410355131177) | 3 | 1 | 10 | 308 | 23 | |||
| 87557 | 110604 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1193 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 4x4 | Permit Number 777025 | 6007369 | 2118756 | 37.7981160762917 | -122.418574247636 | (37.7981160762917, -122.418574247636) | 5 | 1 | 10 | 28858 | 32 | ||
| 88349 | 117264 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1280 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007807 | 2115863 | 37.7901972632139 | -122.416853563641 | (37.7901972632139, -122.416853563641) | 13 | 1 | 10 | 28858 | 21 | ||||
| 88455 | 52360 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 645 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 3 | 3x3 | Permit Number 48496 | 6007841.58942 | 2114643.58565 | 37.7868509951157 | -122.416647466318 | (37.7868509951157, -122.416647466318) | 13 | 1 | 9 | 28858 | 36 |
| 90624 | 143017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 655 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008708.0589 | 2120716.6295 | 37.8035747718659 | -122.414079475338 | (37.8035747718659, -122.414079475338) | 3 | 1 | 10 | 308 | 23 | |||
| 90809 | 136881 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1001 Pine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009094.10364 | 2115978.2019 | 37.7905858921869 | -122.41240841294 | (37.7905858921869, -122.41240841294) | 5 | 1 | 10 | 28858 | 21 | |||
| 92310 | 136876 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1270 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007411.33279 | 2115448.79796 | 37.7890377029824 | -122.418193167101 | (37.7890377029824, -122.418193167101) | 13 | 1 | 10 | 28858 | 21 |
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) );