trees
3,247 rows where qSpecies_id = 22 sorted by YCoord 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70152 | 57739 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1430 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/1992 12:00:00 AM | 1 | Permit Number 31420 | 6009340.15372 | 2118176.38357 | 37.7966353671694 | -122.411712476165 | (37.7966353671694, -122.411712476165) | 3 | 1 | 10 | 308 | 4 | ||
| 6769 | 125297 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010069.63851 | 2118171.76968 | 37.7966635933042 | -122.409187958682 | (37.7966635933042, -122.409187958682) | 3 | 1 | 10 | 308 | 4 | |||
| 288 | 125298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 822 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010056.95509 | 2118170.07703 | 37.7966582351325 | -122.409231726859 | (37.7966582351325, -122.409231726859) | 3 | 1 | 10 | 308 | 4 | |||
| 72179 | 128882 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999935.66766 | 2118151.33165 | 37.7960345301288 | -122.444252194282 | (37.7960345301288, -122.444252194282) | 13 | 9 | 1 | 57 | 17 | |||
| 156358 | 106963 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Port | 14 | 5999920.02374 | 2118149.14648 | 37.7960276377095 | -122.444306168018 | (37.7960276377095, -122.444306168018) | 13 | 9 | 1 | 57 | 17 | |||
| 135289 | 128883 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2728 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5999906.60451 | 2118147.85643 | 37.7960233299564 | -122.444352508267 | (37.7960233299564, -122.444352508267) | 13 | 9 | 1 | 57 | 17 | |||
| 137551 | 172448 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | 6009344.92188 | 2118146.86954 | 37.7965545963687 | -122.411693890757 | (37.7965545963687, -122.411693890757) | 3 | 1 | 10 | 308 | 4 | ||
| 100090 | 11432 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1994 12:00:00 AM | 6 | 3X3 | 6012526.0110026 | 2118137.4589098 | 37.796706690547 | -122.400685892184 | (37.796706690547, -122.400685892184) | 3 | 1 | 10 | 28860 | 4 | ||
| 58103 | 129049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 345 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012447.02159 | 2118133.2731 | 37.796690791499 | -122.400958920936 | (37.796690791499, -122.400958920936) | 3 | 1 | 10 | 28860 | 4 | |||
| 100039 | 92890 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Tree no. 2 on Montgomery | 6011720.98401 | 2118117.86666 | 37.796607963049 | -122.403470105059 | (37.796607963049, -122.403470105059) | 3 | 1 | 10 | 308 | 4 | ||
| 103228 | 88440 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 2848 Scott St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51404 | 6001088 | 2118113 | 37.795994956377 | -122.440262158185 | (37.795994956377, -122.440262158185) | 13 | 9 | 1 | 57 | 17 | |||
| 39318 | 129048 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 349 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012262.33565 | 2118106.53288 | 37.796607065509 | -122.401596099595 | (37.796607065509, -122.401596099595) | 3 | 1 | 10 | 28860 | 4 | |||
| 162337 | 129047 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 349 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012243.75564 | 2118106.34516 | 37.796605513293 | -122.401660377751 | (37.796605513293, -122.401660377751) | 3 | 1 | 10 | 28860 | 4 | |||
| 83058 | 172447 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | 6009352.06363 | 2118102.09709 | 37.7964320628364 | -122.411666013574 | (37.7964320628364, -122.411666013574) | 3 | 1 | 10 | 308 | 4 | ||
| 55409 | 19210 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 395X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1994 12:00:00 AM | 3 | 3X3 | 6012205.7972639 | 2118092.2355744 | 37.7965646535307 | -122.401790730678 | (37.7965646535307, -122.401790730678) | 3 | 1 | 10 | 28860 | 4 | ||
| 106349 | 92889 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 53104 Tree no. 1 on Montgomery St | 6011723.54732 | 2118091.83637 | 37.7965366333102 | -122.403459403146 | (37.7965366333102, -122.403459403146) | 3 | 1 | 10 | 308 | 4 | |
| 54293 | 172446 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 964 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | Width 2ft | 6009459.97745 | 2118085.18417 | 37.7963916769881 | -122.411291411782 | (37.7963916769881, -122.411291411782) | 3 | 1 | 10 | 308 | 4 | ||
| 881 | 254388 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
| 6545 | 254389 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 990 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009377.71563 | 2118076.93343 | 37.7963644085284 | -122.411575473026 | (37.7963644085284, -122.411575473026) | 3 | 1 | 10 | 308 | 4 | ||
| 94894 | 129050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 480 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011790.74157 | 2118076.54295 | 37.7964983941394 | -122.403225818635 | (37.7964983941394, -122.403225818635) | 3 | 1 | 10 | 28860 | 4 | |||
| 48085 | 128881 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2785 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999690.87391 | 2118073.65713 | 37.7958072876205 | -122.44509363868 | (37.7958072876205, -122.44509363868) | 13 | 9 | 1 | 57 | 17 | |||
| 93209 | 129051 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 480 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011751.23747 | 2118071.45452 | 37.7964822162381 | -122.403362154035 | (37.7964822162381, -122.403362154035) | 3 | 1 | 10 | 28860 | 4 | |||
| 119665 | 254391 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009354.25568 | 2118062.93204 | 37.7963246481861 | -122.41165565994 | (37.7963246481861, -122.41165565994) | 3 | 1 | 10 | 308 | 4 | ||
| 191301 | 254390 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2018 12:00:00 AM | 3 | 3x3 | 6009354.25568 | 2118062.93204 | 37.7963246481861 | -122.41165565994 | (37.7963246481861, -122.41165565994) | 3 | 1 | 10 | 308 | 4 | ||
| 127997 | 92908 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 802 Montgomery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Tree no. 2 on Jackson St. | 6011726 | 2118056 | 37.7964383722538 | -122.403448393826 | (37.7964383722538, -122.403448393826) | 3 | 1 | 10 | 28860 | 4 | ||
| 24018 | 53050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1024 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767676 | 6009180.15933 | 2118047.86674 | 37.7962735150778 | -122.412257006676 | (37.7962735150778, -122.412257006676) | 3 | 1 | 10 | 308 | 21 |
| 22650 | 53051 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1024 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51546 | 6009165.99693 | 2118045.48743 | 37.7962661873755 | -122.412305843439 | (37.7962661873755, -122.412305843439) | 3 | 1 | 10 | 308 | 21 | |
| 170372 | 1717 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 555 Battery St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012534.63593 | 2117926.51881 | 37.7961279804624 | -122.400641221934 | (37.7961279804624, -122.400641221934) | 3 | 1 | 10 | 28860 | 4 | |||
| 120996 | 105049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2835 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771766 | 6002046.08058 | 2117916.60345 | 37.7955102037842 | -122.436932952092 | (37.7955102037842, -122.436932952092) | 13 | 9 | 1 | 57 | 27 | |
| 71715 | 128988 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1215 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009812.45895 | 2117905.58189 | 37.7959182954451 | -122.41005906 | (37.7959182954451, -122.41005906) | 3 | 1 | 10 | 308 | 4 | |||
| 93672 | 128989 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1211 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6009815.83375 | 2117884.20117 | 37.7958597783613 | -122.410045872345 | (37.7958597783613, -122.410045872345) | 3 | 1 | 10 | 308 | 4 | |||
| 145292 | 128990 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1211 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009818.96912 | 2117865.4528 | 37.7958084756462 | -122.410033699112 | (37.7958084756462, -122.410033699112) | 3 | 1 | 10 | 308 | 4 | |||
| 129234 | 129046 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6013276.03301 | 2117859.85346 | 37.7959862545039 | -122.398071142972 | (37.7959862545039, -122.398071142972) | 3 | 1 | 10 | 28860 | 6 | |||
| 35819 | 23691 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/25/2014 02:27:00 PM | 3 | 3X3 | 6012568.7473634 | 2117857.4681317 | 37.7959402861802 | -122.400518335953 | (37.7959402861802, -122.400518335953) | 3 | 1 | 10 | 28860 | 4 | ||
| 96609 | 23690 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/2016 12:00:00 AM | 6 | 3X3 | 6012568.7473634 | 2117857.4681317 | 37.7959402861802 | -122.400518335953 | (37.7959402861802, -122.400518335953) | 3 | 1 | 10 | 28860 | 4 | ||
| 70540 | 50452 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2821 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 3 | Permit Number 47098 | 6002052.06788 | 2117856.8779 | 37.7953465532623 | -122.436907957234 | (37.7953465532623, -122.436907957234) | 13 | 9 | 1 | 57 | 27 | ||
| 138747 | 129033 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6013239.28212 | 2117856.41836 | 37.795974775567 | -122.398198067906 | (37.795974775567, -122.398198067906) | 3 | 1 | 10 | 28860 | 6 | |||
| 192440 | 129052 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012440.41364 | 2117843.22562 | 37.7958940218454 | -122.40096139676 | (37.7958940218454, -122.40096139676) | 3 | 1 | 10 | 28860 | 4 | |||
| 89417 | 129053 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 400X Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/25/2014 02:27:00 PM | 6 | Width 4ft | 6012415.44443 | 2117838.53104 | 37.7958797388015 | -122.401047465462 | (37.7958797388015, -122.401047465462) | 3 | 1 | 10 | 28860 | 4 | ||
| 56993 | 129045 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013279.7836 | 2117837.77288 | 37.7959258353613 | -122.398056615315 | (37.7959258353613, -122.398056615315) | 3 | 1 | 10 | 28860 | 6 | |||
| 52384 | 129034 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013241.89259 | 2117832.60042 | 37.7959095225567 | -122.398187363256 | (37.7959095225567, -122.398187363256) | 3 | 1 | 10 | 28860 | 6 | |||
| 104985 | 23693 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 444 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2012 12:00:00 AM | 3 | 3x3 | 6012360.1719452 | 2117827.4460445 | 37.795846218583 | -122.401237940514 | (37.795846218583, -122.401237940514) | 3 | 1 | 10 | 28860 | 4 | ||
| 158324 | 129054 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 444 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/22/2012 12:00:00 AM | 2 | Width 4ft | 6012321.89911 | 2117825.32237 | 37.7958382521842 | -122.401370223173 | (37.7958382521842, -122.401370223173) | 3 | 1 | 10 | 28860 | 4 | ||
| 103045 | 129055 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 444 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2004 12:00:00 AM | 5 | Width 4ft | 6012276.75519 | 2117819.30425 | 37.7958192090308 | -122.401526007337 | (37.7958192090308, -122.401526007337) | 3 | 1 | 10 | 28860 | 4 | ||
| 98681 | 129044 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6013286.59086 | 2117813.86982 | 37.7958605823612 | -122.398031383042 | (37.7958605823612, -122.398031383042) | 3 | 1 | 10 | 28860 | 6 | |||
| 100990 | 129043 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013288.00774 | 2117785.67539 | 37.795783246053 | -122.398024501452 | (37.795783246053, -122.398024501452) | 3 | 1 | 10 | 28860 | 6 | |||
| 161993 | 129036 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013248.88041 | 2117784.9287 | 37.7957790165368 | -122.398159837726 | (37.7957790165368, -122.398159837726) | 3 | 1 | 10 | 28860 | 6 | |||
| 164875 | 30510 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2774 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2016 12:00:00 AM | 3 | 6x7 | Permit Number 778747 | 5999768.8918 | 2117782.75925 | 37.7950130117898 | -122.444802762862 | (37.7950130117898, -122.444802762862) | 13 | 9 | 1 | 57 | 17 | |
| 170802 | 128920 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000649.00717 | 2117775.55771 | 37.7950434250715 | -122.441756924556 | (37.7950434250715, -122.441756924556) | 13 | 9 | 1 | 57 | 27 | |||
| 32284 | 143495 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 KEARNY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011293.9321 | 2117775.1194 | 37.7956429995479 | -122.404923663455 | (37.7956429995479, -122.404923663455) | 3 | 1 | 10 | 28857 | 4 | |
| 116188 | 129042 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013288.71505 | 2117766.07666 | 37.795729471979 | -122.398020678438 | (37.795729471979, -122.398020678438) | 3 | 1 | 10 | 28860 | 6 | |||
| 44175 | 129037 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013253.49225 | 2117761.73014 | 37.7957155756652 | -122.398142251463 | (37.7957155756652, -122.398142251463) | 3 | 1 | 10 | 28860 | 6 | |||
| 86915 | 48412 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2002 12:00:00 AM | 2 | Permit Number 45791 | 6000650.17466 | 2117761.24056 | 37.7950041804639 | -122.441751856862 | (37.7950041804639, -122.441751856862) | 13 | 9 | 1 | 57 | 27 | ||
| 19320 | 33230 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | Permit Number 37416 | 6000651.12195 | 2117750.428 | 37.7949745459919 | -122.441747802734 | (37.7949745459919, -122.441747802734) | 13 | 9 | 1 | 57 | 27 | ||
| 57233 | 129041 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013290.87946 | 2117742.04768 | 37.7956636146407 | -122.398011502625 | (37.7956636146407, -122.398011502625) | 3 | 1 | 10 | 28860 | 6 | |||
| 65864 | 143494 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 KEARNY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011299.0592 | 2117739.2293 | 37.7955447405749 | -122.40490339454 | (37.7955447405749, -122.40490339454) | 3 | 1 | 10 | 28857 | 4 | |
| 175024 | 129038 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013256.5667 | 2117739.00297 | 37.7956533434856 | -122.398130017998 | (37.7956533434856, -122.398130017998) | 3 | 1 | 10 | 28860 | 6 | |||
| 12180 | 91455 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 35371 | 91453 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680 WASHINGTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 106482 | 91454 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 186354 | 91452 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 188877 | 91456 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 680x WASHINGTON ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011317 | 2117738 | 37.7955423680345 | -122.404841229346 | (37.7955423680345, -122.404841229346) | 3 | 1 | 10 | 28857 | 4 | ||
| 35542 | 129040 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 306 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013297.17121 | 2117703.63203 | 37.7955584847826 | -122.397987035675 | (37.7955584847826, -122.397987035675) | 3 | 1 | 10 | 28860 | 6 | |||
| 137874 | 143493 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 800 KEARNY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 1 | Width 0ft | Permit Number 52103 | 6011305.9671 | 2117702.4892 | 37.7954442472417 | -122.404876903904 | (37.7954442472417, -122.404876903904) | 3 | 1 | 10 | 28857 | 4 | |
| 70905 | 129039 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6013261.47543 | 2117697.75471 | 37.795540358945 | -122.398110137583 | (37.795540358945, -122.398110137583) | 3 | 1 | 10 | 28860 | 6 | |||
| 121836 | 129056 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011415.91868 | 2117696.60349 | 37.7954342317671 | -122.404496036363 | (37.7954342317671, -122.404496036363) | 3 | 1 | 10 | 28857 | 4 | |
| 35704 | 91458 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 102419 | 91459 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 133806 | 91457 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 808 Kearny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 3x3 | Permit Number 52103 | 6011295 | 2117692 | 37.7954148333998 | -122.404914113244 | (37.7954148333998, -122.404914113244) | 3 | 1 | 10 | 28857 | 4 | ||
| 181409 | 129057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011354.55314 | 2117688.13829 | 37.7954075587569 | -122.404707776336 | (37.7954075587569, -122.404707776336) | 3 | 1 | 10 | 28857 | 4 | |
| 96387 | 129059 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011327.66618 | 2117687.2461 | 37.7954036062342 | -122.404800747351 | (37.7954036062342, -122.404800747351) | 3 | 1 | 10 | 28857 | 4 | |
| 69113 | 88410 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1135 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51385 | 6009840.54095 | 2117687.0727 | 37.7953198964454 | -122.409946457661 | (37.7953198964454, -122.409946457661) | 3 | 1 | 10 | 28857 | 4 | |
| 153836 | 129058 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 662 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2009 12:00:00 AM | 2 | Width 3ft | Permit Number 52103 | 6011338.85852 | 2117686.82601 | 37.7954030783469 | -122.404761990195 | (37.7954030783469, -122.404761990195) | 3 | 1 | 10 | 28857 | 4 | |
| 13947 | 109612 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 41338 | 109613 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 69431 | 109609 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | |||
| 88306 | 109615 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 88483 | 109611 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 99915 | 109610 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 137959 | 109614 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 311x DAVIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013158 | 2117662 | 37.7954364211004 | -122.398465672767 | (37.7954364211004, -122.398465672767) | 3 | 1 | 10 | 28860 | 6 | ||||
| 100505 | 88411 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1135 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51385 | 6009845.51627 | 2117657.92269 | 37.7952401364672 | -122.409927183403 | (37.7952401364672, -122.409927183403) | 3 | 1 | 10 | 28857 | 4 | |
| 91412 | 50868 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 4 | Permit Number 47381 | 6001017.8874 | 2117610.38946 | 37.7946109276092 | -122.440468695171 | (37.7946109276092, -122.440468695171) | 13 | 9 | 1 | 57 | 27 | ||
| 21892 | 50870 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 47381 | 6001002.60746 | 2117608.08082 | 37.7946037186291 | -122.440521399949 | (37.7946037186291, -122.440521399949) | 13 | 9 | 1 | 57 | 27 | |||
| 49478 | 50869 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 47381 | 6000989.97476 | 2117606.30096 | 37.7945981122598 | -122.440564982893 | (37.7945981122598, -122.440564982893) | 13 | 9 | 1 | 57 | 27 | |||
| 148685 | 50866 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 4 | Permit Number 47381 | 6000975.83576 | 2117602.5105 | 37.7945868995178 | -122.440613633526 | (37.7945868995178, -122.440613633526) | 13 | 9 | 1 | 57 | 27 | ||
| 193692 | 62619 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2620 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Permit Number 25602 | 6003607.45896 | 2117531.28887 | 37.7945408488382 | -122.431502797041 | (37.7945408488382, -122.431502797041) | 13 | 9 | 1 | 29490 | 27 | ||
| 10470 | 128936 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2618 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003606.06388 | 2117505.00365 | 37.7944685972958 | -122.431505746802 | (37.7944685972958, -122.431505746802) | 13 | 9 | 1 | 29490 | 27 | |||
| 72689 | 129022 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010179.58419 | 2117492.42024 | 37.7948044239469 | -122.408759568426 | (37.7948044239469, -122.408759568426) | 3 | 1 | 10 | 28857 | 4 | |||
| 186892 | 51668 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2618 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2005 12:00:00 AM | 3 | Permit Number 48074 | 6003607.03534 | 2117490.12899 | 37.7944278103538 | -122.431501323032 | (37.7944278103538, -122.431501323032) | 13 | 9 | 1 | 29490 | 27 | ||
| 160038 | 129021 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010133.14197 | 2117484.27799 | 37.7947794659604 | -122.408919690903 | (37.7947794659604, -122.408919690903) | 3 | 1 | 10 | 28857 | 4 | |||
| 67790 | 129020 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010113.76388 | 2117481.29123 | 37.7947701795629 | -122.408986531214 | (37.7947701795629, -122.408986531214) | 3 | 1 | 10 | 28857 | 4 | |||
| 29718 | 129019 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010068.23962 | 2117476.51245 | 37.7947545079644 | -122.409143714711 | (37.7947545079644, -122.409143714711) | 3 | 1 | 10 | 28857 | 4 | |||
| 111317 | 129018 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010048.24656 | 2117474.59523 | 37.794748123684 | -122.40921275837 | (37.794748123684, -122.40921275837) | 3 | 1 | 10 | 28857 | 4 | |||
| 29589 | 129017 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 979 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010033.78329 | 2117473.19929 | 37.7947434804789 | -122.409262704913 | (37.7947434804789, -122.409262704913) | 3 | 1 | 10 | 28857 | 4 | |||
| 35002 | 98799 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | ||
| 170083 | 98803 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.7947497683853 | -122.408823532788 | (37.7947497683853, -122.408823532788) | 3 | 1 | 10 | 28857 | 4 | |
| 114301 | 98806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
| 179485 | 98802 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 03/16/2012 12:00:00 AM | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | |
| 29859 | 128994 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Jones St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008423.06087 | 2117463.28601 | 37.7946258887275 | -122.414835338698 | (37.7946258887275, -122.414835338698) | 5 | 1 | 10 | 28858 | 21 | |||
| 91518 | 109618 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 300x DAVIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013341 | 2117458 | 37.794886478256 | -122.39781814115 | (37.794886478256, -122.39781814115) | 3 | 1 | 10 | 28860 | 6 |
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) );