trees
7,322 rows where qSpecies_id = 1 sorted by Location descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 91447 | 136776 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Richardson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999020.04225 | 2119778.41485 | 37.8004497840758 | -122.447537603903 | (37.8004497840758, -122.447537603903) | 13 | 9 | 1 | 57 | 17 | ||||
| 125382 | 136774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Francisco St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999022.27584 | 2119774.26108 | 37.8004385065862 | -122.447529575653 | (37.8004385065862, -122.447529575653) | 13 | 9 | 1 | 57 | 17 | ||||
| 95669 | 136775 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2600 Francisco St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5999017.84714 | 2119772.04283 | 37.8004321627783 | -122.447544740905 | (37.8004321627783, -122.447544740905) | 13 | 9 | 1 | 57 | 17 | ||||
| 76107 | 87069 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2268 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2007 12:00:00 AM | 3x3 | Permit Number 50010 | 6001029.8 | 2119730 | 37.8004314980305 | -122.440579577974 | (37.8004314980305, -122.440579577974) | 13 | 9 | 1 | 57 | 17 | ||
| 1073 | 108979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3298 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2017 12:00:00 AM | 3 | 3x3 | 6001360.79576 | 2119668.58087 | 37.800281699894 | -122.43942979746 | (37.800281699894, -122.43942979746) | 13 | 9 | 1 | 57 | 17 | ||
| 4767 | 40166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3031 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | 8 | 6x6 | Permit Number 41359 | 6004240.20521 | 2119600.37832 | 37.8002578795473 | -122.429461041019 | (37.8002578795473, -122.429461041019) | 13 | 9 | 1 | 57 | 17 |
| 110113 | 45789 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1320 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51739 | 6011061.04232 | 2119446.90948 | 37.8002203085803 | -122.40584732891 | (37.8002203085803, -122.40584732891) | 3 | 1 | 10 | 308 | 23 | |
| 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 | |||
| 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 | |||
| 11724 | 81872 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3132 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003807.91186 | 2119539.89269 | 37.8000673168179 | -122.430952625964 | (37.8000673168179, -122.430952625964) | 13 | 9 | 1 | 57 | 17 | |||
| 111644 | 136754 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003810.27417 | 2119515.60646 | 37.8000007669699 | -122.43094271723 | (37.8000007669699, -122.43094271723) | 13 | 9 | 1 | 57 | 17 | |||
| 77533 | 136755 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003812.47728 | 2119500.94744 | 37.7999606419262 | -122.430934046864 | (37.7999606419262, -122.430934046864) | 13 | 9 | 1 | 57 | 17 | |||
| 91685 | 83367 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124-3128 Laguna St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52345 | 6003823.24826281 | 2119450.20874415 | 37.7998219368855 | -122.430893152133 | (37.7998219368855, -122.430893152133) | 13 | 9 | 1 | 57 | 17 | ||
| 118620 | 80937 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124-3128 Laguna St | 2 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52345 | 6003823.24826281 | 2119450.20874415 | 37.7998219368855 | -122.430893152133 | (37.7998219368855, -122.430893152133) | 13 | 9 | 1 | 57 | 17 | ||
| 41072 | 82084 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1844 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50673 | 6004066.07798 | 2119420.86744 | 37.7997551288643 | -122.430050776817 | (37.7997551288643, -122.430050776817) | 13 | 9 | 1 | 57 | 17 | |
| 168151 | 81967 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1844 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50673 | 6004048.69981 | 2119419.7854 | 37.7997511736373 | -122.430110834457 | (37.7997511736373, -122.430110834457) | 13 | 9 | 1 | 57 | 17 | |
| 104410 | 142922 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 465 GREEN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010790.8559 | 2119269.8876 | 37.7997191359575 | -122.406769801504 | (37.7997191359575, -122.406769801504) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | ||
| 146458 | 67618 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1440 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31199 | 6006039.45477 | 2119353.85991 | 37.7996827073455 | -122.423217389787 | (37.7996827073455, -122.423217389787) | 13 | 9 | 1 | 28858 | 32 | |
| 32424 | 102772 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1440 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 31199 | 6006025.32539 | 2119349.84654 | 37.7996708902593 | -122.423265997228 | (37.7996708902593, -122.423265997228) | 13 | 9 | 1 | 28858 | 32 | ||
| 36605 | 58164 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1472 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 8 | Permit Number 31200 | 6005960.50321 | 2119339.77329 | 37.7996395731743 | -122.423489589398 | (37.7996395731743, -122.423489589398) | 13 | 9 | 1 | 28858 | 32 | |
| 102214 | 102774 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1472 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | Permit Number 31200 | 6005947.91695 | 2119337.23456 | 37.7996318920616 | -122.423532961902 | (37.7996318920616, -122.423532961902) | 13 | 9 | 1 | 28858 | 32 | ||
| 5649 | 136764 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003765.13271 | 2119380.44822 | 37.7996270995734 | -122.43108927166 | (37.7996270995734, -122.43108927166) | 13 | 9 | 1 | 57 | 17 | |||
| 101890 | 9940 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600X Green St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 08:48:00 AM | 3 | 6X6 | 6010123.5350709 | 2119222.6779084 | 37.799552149361 | -122.409075654051 | (37.799552149361, -122.409075654051) | 3 | 1 | 10 | 308 | 23 | ||
| 93455 | 143490 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/2016 08:48:00 AM | 0 | Width 0ft | 6010035.0683 | 2119214.1514 | 37.7995237814105 | -122.409381180174 | (37.7995237814105, -122.409381180174) | 3 | 1 | 10 | 308 | 4 | ||
| 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 | |||
| 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 | |||
| 134060 | 142919 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 626 GREEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6009894.6922 | 2119198.6113 | 37.7994732460735 | -122.409865836283 | (37.7994732460735, -122.409865836283) | 3 | 1 | 10 | 308 | 4 | |||
| 121837 | 29734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 644 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009872.4617 | 2119193.0537 | 37.7994567403911 | -122.409942369513 | (37.7994567403911, -122.409942369513) | 3 | 1 | 10 | 308 | 4 | ||
| 97509 | 29738 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 656 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009848.564 | 2119190.8307 | 37.7994492972084 | -122.410024907374 | (37.7994492972084, -122.410024907374) | 3 | 1 | 10 | 308 | 4 | ||
| 81104 | 136763 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 212 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002224.23945 | 2119329.5583 | 37.7993999335119 | -122.436417669343 | (37.7993999335119, -122.436417669343) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 141678 | 258493 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1100 Montgomery St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6011579.56023 | 2119131.56016 | 37.7993834201653 | -122.404030839573 | (37.7993834201653, -122.404030839573) | 3 | 1 | 10 | 308 | 23 | ||||
| 166789 | 110082 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3028 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773127 | 6003845.53754 | 2119275.91303 | 37.7993446288048 | -122.430803577743 | (37.7993446288048, -122.430803577743) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |
| 51325 | 136762 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 211 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002240.18311 | 2119305.05407 | 37.7993335572449 | -122.436360744046 | (37.7993335572449, -122.436360744046) | 13 | 9 | 1 | 57 | 17 | |||
| 190270 | 31503 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 213 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35063 | 6002220.45956 | 2119302.10567 | 37.7993243409999 | -122.436428783179 | (37.7993243409999, -122.436428783179) | 13 | 9 | 1 | 57 | 17 | ||
| 73427 | 31504 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35064 | 6002200.31175 | 2119299.02621 | 37.7993147407511 | -122.436498280994 | (37.7993147407511, -122.436498280994) | 13 | 9 | 1 | 57 | 17 | ||
| 79860 | 31502 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 215 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/1995 12:00:00 AM | 8 | 3x3 | Permit Number 35062 | 6002281.47865413 | 2119297.17151766 | 37.7993142601434 | -122.436217282838 | (37.7993142601434, -122.436217282838) | 13 | 9 | 1 | 57 | 17 | |
| 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 | |||
| 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 | |||
| 47931 | 41412 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 237 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | Permit Number 42025 | 6002180.68587279 | 2119283.13380429 | 37.7992699891282 | -122.436565055121 | (37.7992699891282, -122.436565055121) | 13 | 9 | 1 | 57 | 17 | |||
| 173271 | 136899 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 687 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009739.09157 | 2119126.69971 | 37.7992670730616 | -122.410399191672 | (37.7992670730616, -122.410399191672) | 3 | 1 | 10 | 308 | 4 | |||
| 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 | |||
| 5739 | 52729 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2015 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/2006 12:00:00 AM | 5 | Permit Number 48785 | 6003207.48866 | 2119256.92944 | 37.7992563342625 | -122.433010091366 | (37.7992563342625, -122.433010091366) | 13 | 9 | 1 | 57 | 17 | |
| 101212 | 136777 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3151 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003316.54978 | 2119247.15356 | 37.7992356777548 | -122.432632003762 | (37.7992356777548, -122.432632003762) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 116494 | 136778 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3151 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003326.69384 | 2119173.05641 | 37.7990328014768 | -122.432591606232 | (37.7990328014768, -122.432591606232) | 13 | 9 | 1 | 57 | 17 | |||
| 150447 | 136906 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 471 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6011241.07834 | 2118988.50847 | 37.7989717177149 | -122.405192033407 | (37.7989717177149, -122.405192033407) | 3 | 1 | 10 | 308 | 23 | |||
| 121201 | 142935 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 530 VALLEJO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6010961.4694 | 2118993.7222 | 37.7989703977105 | -122.406159945771 | (37.7989703977105, -122.406159945771) | 3 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 17975 | 136753 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3104 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003385.31973 | 2119082.57835 | 37.7987876966409 | -122.432382275515 | (37.7987876966409, -122.432382275515) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 122116 | 88279 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3104 Buchanan St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51271 | 6003396 | 2118973 | 37.7984874284796 | -122.432337488027 | (37.7984874284796, -122.432337488027) | 13 | 9 | 1 | 57 | 17 | |||
| 176608 | 143374 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1576 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6005414.4547 | 2118918.8036 | 37.7984528623984 | -122.425349144038 | (37.7984528623984, -122.425349144038) | 13 | 9 | 1 | 57 | 17 | |||
| 30481 | 136759 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1576 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005415.96156 | 2118918.51958 | 37.7984521676846 | -122.425343909611 | (37.7984521676846, -122.425343909611) | 13 | 9 | 1 | 57 | 17 | |||
| 94939 | 136894 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1136 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007527.55421 | 2118870.77791 | 37.7984401527358 | -122.418033743385 | (37.7984401527358, -122.418033743385) | 5 | 1 | 10 | 28858 | 32 | |||
| 119138 | 88405 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1140 Green St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51382 | 6007541.2 | 2118862 | 37.7984168187982 | -122.417985902037 | (37.7984168187982, -122.417985902037) | 5 | 1 | 10 | 28858 | 32 | |||
| 24687 | 34671 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2001X Filbert St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/2013 12:00:00 AM | 3 | Permit Number 770195 | 6003313.06094 | 2118924.86911 | 37.7983505703751 | -122.432621042824 | (37.7983505703751, -122.432621042824) | 13 | 9 | 1 | 57 | 17 | |
| 90042 | 34670 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2001X Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 38339 | 6003296.78192 | 2118922.23396 | 37.7983424117356 | -122.432677184799 | (37.7983424117356, -122.432677184799) | 13 | 9 | 1 | 57 | 17 | |
| 128590 | 65764 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3060 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2013 12:00:00 AM | 1 | Permit Number 770428 | 6003411.00905 | 2118900.38698 | 37.7982889029567 | -122.432280363442 | (37.7982889029567, -122.432280363442) | 13 | 9 | 1 | 57 | 17 | |
| 183043 | 136756 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3023 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999942.68983 | 2118971.84309 | 37.7982878372718 | -122.444286889232 | (37.7982878372718, -122.444286889232) | 13 | 9 | 1 | 57 | 17 | |||
| 105063 | 143356 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 UNION ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005276.7947 | 2118850.6229 | 37.7982578772588 | -122.425820634818 | (37.7982578772588, -122.425820634818) | 13 | 9 | 1 | 57 | 17 | |||
| 20458 | 42640 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 Union St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/25/2015 02:08:00 PM | 3 | 3x3 | Permit Number 42688 | 6005273.82097 | 2118847.7065 | 37.7982497015198 | -122.425830717123 | (37.7982497015198, -122.425830717123) | 13 | 9 | 1 | 57 | 17 |
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |
| 124759 | 33127 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2695 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37360 | 6000019.34944839 | 2118808.38457485 | 37.7978433969726 | -122.444009873772 | (37.7978433969726, -122.444009873772) | 13 | 9 | 1 | 57 | 17 | ||
| 185807 | 33128 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2695 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | Permit Number 37360 | 6000019.34944839 | 2118808.38457485 | 37.7978433969726 | -122.444009873772 | (37.7978433969726, -122.444009873772) | 13 | 9 | 1 | 57 | 17 | ||
| 88899 | 48409 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701X Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2002 12:00:00 AM | 4 | Permit Number 45790 | 5999904.13106 | 2118796.62771 | 37.7978045425136 | -122.444407714966 | (37.7978045425136, -122.444407714966) | 13 | 9 | 1 | 57 | 17 | ||
| 189002 | 48411 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2002 12:00:00 AM | 4 | Permit Number 45790 | 5999892.74652 | 2118795.2194 | 37.7978000261054 | -122.444447007245 | (37.7978000261054, -122.444447007245) | 13 | 9 | 1 | 57 | 17 | ||
| 15442 | 48410 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2701X Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/2002 12:00:00 AM | 4 | Permit Number 45790 | 5999879.07462 | 2118793.03652 | 37.7977932524078 | -122.444494158697 | (37.7977932524078, -122.444494158697) | 13 | 9 | 1 | 57 | 17 | |
| 174688 | 136757 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2964 Broderick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6000011.75151 | 2118772.95544 | 37.7977456845608 | -122.444033617674 | (37.7977456845608, -122.444033617674) | 13 | 9 | 1 | 57 | 17 | |||
| 70569 | 136758 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2964 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000014.84089 | 2118748.39628 | 37.7976784278661 | -122.444021162054 | (37.7976784278661, -122.444021162054) | 13 | 9 | 1 | 57 | 17 | |||
| 120599 | 42679 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1570 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/16/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52633 | 6005487.62506 | 2118579.71964 | 37.7975259577146 | -122.425071812519 | (37.7975259577146, -122.425071812519) | 13 | 9 | 1 | 57 | 17 | |
| 131320 | 48424 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3034 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/03/2014 12:00:00 AM | 3 | Permit Number 772479 | 6001994.11068 | 2118598.66634 | 37.7973800166165 | -122.437161635315 | (37.7973800166165, -122.437161635315) | 13 | 9 | 1 | 57 | 17 | |
| 22952 | 136779 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2700 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004443.0325 | 2118468.37808 | 37.7971611791972 | -122.428678439257 | (37.7971611791972, -122.428678439257) | 13 | 9 | 1 | 57 | 17 | |||
| 182874 | 42609 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1776 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | Permit Number 43815 | 6004539.5485431 | 2118448.64668332 | 37.797112463642 | -122.428343062682 | (37.797112463642, -122.428343062682) | 13 | 9 | 1 | 57 | 17 | ||
| 81298 | 52085 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2672 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2005 12:00:00 AM | 6 | Permit Number 48282 | 6000189.16008 | 2118535.00366 | 37.7971024507605 | -122.443402636239 | (37.7971024507605, -122.443402636239) | 13 | 9 | 1 | 57 | 17 | ||
| 76342 | 52084 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2672 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/18/2005 12:00:00 AM | 5 | Permit Number 48282 | 6000173.86506 | 2118533.24935 | 37.7970967616558 | -122.443455434519 | (37.7970967616558, -122.443455434519) | 13 | 9 | 1 | 57 | 17 | ||
| 23994 | 42610 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1778 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42677 | 6004517.51154 | 2118442.44969 | 37.7970942013016 | -122.428418874228 | (37.7970942013016, -122.428418874228) | 13 | 9 | 1 | 57 | 17 | |
| 142125 | 42617 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1790 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42679 | 6004487.31439 | 2118438.14954 | 37.7970806853794 | -122.428523057119 | (37.7970806853794, -122.428523057119) | 13 | 9 | 1 | 57 | 17 | |
| 44239 | 42612 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1795 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 6 | Permit Number 42678 | 6004479.33424 | 2118391.14401 | 37.796951168625 | -122.428547318108 | (37.796951168625, -122.428547318108) | 13 | 9 | 1 | 57 | 17 | |
| 132586 | 136852 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2644 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004461.72357 | 2118337.70377 | 37.7968034387856 | -122.42860444394 | (37.7968034387856, -122.42860444394) | 13 | 9 | 1 | 57 | 17 | |||
| 169459 | 143555 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2325 UNION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001937.0295 | 2118384.3847 | 37.7967884103712 | -122.437343798957 | (37.7967884103712, -122.437343798957) | 13 | 9 | 1 | 57 | 17 | |||
| 141480 | 143554 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2325 UNION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001905.1734 | 2118379.9907 | 37.796774534562 | -122.437453713409 | (37.796774534562, -122.437453713409) | 13 | 9 | 1 | 57 | 17 | |||
| 88954 | 143553 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2325 UNION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6001890.893 | 2118377.7938 | 37.7967676905684 | -122.437502969388 | (37.7967676905684, -122.437502969388) | 13 | 9 | 1 | 57 | 17 | |||
| 41671 | 136851 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2644 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6004463.94695 | 2118324.20714 | 37.796766506319 | -122.428595787972 | (37.796766506319, -122.428595787972) | 13 | 9 | 1 | 57 | 17 | |||
| 58126 | 136842 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1883 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004056.17594 | 2118328.14161 | 37.7967542242854 | -122.430007049991 | (37.7967542242854, -122.430007049991) | 13 | 9 | 1 | 57 | 17 | |||
| 168882 | 143552 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2325 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001872.2188 | 2118372.3013 | 37.7967515478875 | -122.437567192759 | (37.7967515478875, -122.437567192759) | 13 | 9 | 1 | 57 | 17 |
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) );