trees
218 rows where qSpecies_id = 175 sorted by DBH
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17902 | 113640 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
19057 | 251711 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 3 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
22296 | 113639 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
36594 | 251713 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 5 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
52533 | 251712 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 4 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
54464 | 251710 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 2 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
95096 | 251715 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 7 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
100335 | 251709 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 1 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
108536 | 258481 | Undocumented 4 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1721x Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008705 | 2118812 | 37.7983449620815 | -122.413955244514 | (37.7983449620815, -122.413955244514) | 5 | 1 | 10 | 308 | 21 | ||||
112344 | 94983 | Permitted Site 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 3x3 | Permit Number 54004 | 6008557 | 2113884 | 37.78480556642 | -122.414118544888 | (37.78480556642, -122.414118544888) | 7 | 10 | 9 | 28852 | 36 | ||
113295 | 113637 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
115499 | 113638 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
130383 | 251714 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 6 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
158338 | 258480 | Undocumented 4 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1721x Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008705 | 2118812 | 37.7983449620815 | -122.413955244514 | (37.7983449620815, -122.413955244514) | 5 | 1 | 10 | 308 | 21 | ||||
173830 | 98139 | Property Tree 8 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 556 Laidley St | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003085 | 2096041 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | 2 | 7 | 5 | 63 | 7 | |||||
174218 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
11926 | 197450 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009244.39331 | 2111101.4918 | 37.7772040457577 | -122.411543721977 | (37.7772040457577, -122.411543721977) | 8 | 2 | 9 | 28853 | 34 | |||
73039 | 240915 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 315 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006533.58338 | 2104305.2413 | 37.7583907231708 | -122.420438775123 | (37.7583907231708, -122.420438775123) | 2 | 4 | 7 | 28859 | 19 | |||
79756 | 240934 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 4069 19th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6002570.92304 | 2104708.12559 | 37.7592728411839 | -122.434172195294 | (37.7592728411839, -122.434172195294) | 2 | 4 | 5 | 28862 | 3 | |||
99637 | 240885 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 3013 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6009432.4377 | 2100992.16843 | 37.7494567005869 | -122.410179305636 | (37.7494567005869, -122.410179305636) | 2 | 4 | 7 | 28859 | 19 | |||
111952 | 240919 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 556 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002989.39478 | 2095969.72486 | 37.7353029813381 | -122.432100892951 | (37.7353029813381, -122.432100892951) | 2 | 7 | 5 | 63 | 7 | |||
12553 | 58942 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1372 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1980 12:00:00 AM | 10 | Permit Number 18220 | 6011965.36067 | 2101992.52974 | 37.752345126031 | -122.401490633396 | (37.752345126031, -122.401490633396) | 10 | 3 | 8 | 28856 | 29 | |
34955 | 240903 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008699.59316 | 2101430.06174 | 37.7506179528532 | -122.412744464408 | (37.7506179528532, -122.412744464408) | 2 | 4 | 7 | 28859 | 19 | |||
35652 | 240901 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008702.87271 | 2101385.26076 | 37.7504951234628 | -122.412729956536 | (37.7504951234628, -122.412729956536) | 2 | 4 | 7 | 28859 | 19 | |||
40977 | 240905 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008695.45219 | 2101477.07086 | 37.7507467969474 | -122.412762107295 | (37.7507467969474, -122.412762107295) | 2 | 4 | 7 | 28859 | 19 | |||
56305 | 240515 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 457 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005735.72646 | 2107821.05877 | 37.767999333532 | -122.423448064975 | (37.767999333532, -122.423448064975) | 8 | 4 | 5 | 28853 | 19 | |||
59180 | 240893 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008715.08963 | 2101164.19704 | 37.7498888176188 | -122.412672083351 | (37.7498888176188, -122.412672083351) | 2 | 4 | 7 | 28859 | 19 | |||
59230 | 240911 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1051 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009458.35478 | 2103057.57846 | 37.7551293083888 | -122.410235489878 | (37.7551293083888, -122.410235489878) | 2 | 4 | 7 | 28859 | 19 | |||
60591 | 240888 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008723.38535 | 2101024.2236 | 37.7495049474174 | -122.412633502442 | (37.7495049474174, -122.412633502442) | 2 | 4 | 7 | 28859 | 19 | |||
93062 | 240916 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 64 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x10 | 6004904.76782 | 2096171.47798 | 37.7359653572213 | -122.425493090943 | (37.7359653572213, -122.425493090943) | 2 | 7 | 5 | 28859 | 2 | |||
119930 | 240906 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008696.38021 | 2101499.73493 | 37.7508090794957 | -122.412760500211 | (37.7508090794957, -122.412760500211) | 2 | 4 | 7 | 28859 | 19 | |||
150221 | 240917 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 83 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005893.634 | 2099040.45784 | 37.7438987545233 | -122.422277954379 | (37.7438987545233, -122.422277954379) | 2 | 7 | 7 | 28859 | 2 | |||
159262 | 240891 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6008718.64971 | 2101088.20431 | 37.7496803583719 | -122.41265440089 | (37.7496803583719, -122.41265440089) | 2 | 4 | 7 | 28859 | 19 | |||
177511 | 240908 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 725 Florida St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009319.31515 | 2104845.25039 | 37.7600300568648 | -122.410842580843 | (37.7600300568648, -122.410842580843) | 2 | 4 | 7 | 28859 | 19 | |||
192445 | 240927 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1148 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008036.38125 | 2101261.79072 | 37.7501186717498 | -122.415026003064 | (37.7501186717498, -122.415026003064) | 2 | 4 | 7 | 28859 | 19 | |||
42502 | 240923 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 828 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009093.2856 | 2104203.13194 | 37.758254269047 | -122.411578943013 | (37.758254269047, -122.411578943013) | 2 | 4 | 7 | 28859 | 19 | |||
179619 | 197380 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2251 Silver Ave | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012873.30802 | 2096314.08493 | 37.7368039417418 | -122.397952478343 | (37.7368039417418, -122.397952478343) | 10 | 3 | 8 | 58 | 1 | |||
28175 | 240514 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 457 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005714.78028 | 2107820.47236 | 37.7679965411359 | -122.423520473904 | (37.7679965411359, -122.423520473904) | 8 | 4 | 5 | 28853 | 19 | |||
59833 | 4403 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1044 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004378.89078 | 2102815.58991 | 37.7541788320093 | -122.427784518551 | (37.7541788320093, -122.427784518551) | 2 | 4 | 5 | 28862 | 22 | |||
132466 | 34777 | Permitted Site 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1148 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2002 12:00:00 AM | 12 | 4xt | Permit Number 45651 | 6008035.00461404 | 2101235.83901924 | 37.7500473368591 | -122.415028926905 | (37.7500473368591, -122.415028926905) | 2 | 4 | 7 | 28859 | 19 |
68571 | 240913 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 85 Sycamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6006349.99918 | 2105832.52537 | 37.7625739412505 | -122.421182140339 | (37.7625739412505, -122.421182140339) | 8 | 4 | 7 | 28859 | 19 | |||
74328 | 240920 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 83 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003674.03568 | 2096782.40891 | 37.7375732191201 | -122.429791784672 | (37.7375732191201, -122.429791784672) | 2 | 7 | 5 | 63 | 7 | |||
101619 | 197454 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009151.50306 | 2111008.98278 | 37.7769448269774 | -122.41185852156 | (37.7769448269774, -122.41185852156) | 8 | 2 | 9 | 28853 | 34 | |||
102473 | 240918 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 4158 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6002863.78754 | 2100671.92533 | 37.7482070116408 | -122.43287098151 | (37.7482070116408, -122.43287098151) | 2 | 4 | 5 | 28862 | 22 | |||
114006 | 240886 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6009453.92739 | 2100992.83614 | 37.7494597384933 | -122.410105040531 | (37.7494597384933, -122.410105040531) | 2 | 4 | 7 | 28859 | 19 | |||
131614 | 197448 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009272.74588 | 2111128.58634 | 37.7772800312881 | -122.411447555674 | (37.7772800312881, -122.411447555674) | 8 | 2 | 9 | 28853 | 34 | |||
143907 | 240887 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 3009 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6009470.6055 | 2100993.60175 | 37.7494627754843 | -122.410047420976 | (37.7494627754843, -122.410047420976) | 2 | 4 | 7 | 28859 | 19 | |||
176330 | 136360 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1725 Taylor St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6008711.32926 | 2118885.42513 | 37.7985469247543 | -122.413938540155 | (37.7985469247543, -122.413938540155) | 5 | 1 | 10 | 308 | 21 | |||
47420 | 103279 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 221 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2013 12:00:00 AM | 3 | 5x6 | Permit Number 770111 | 6004127.45538 | 2092231.09561 | 37.7251019992539 | -122.427899880877 | (37.7251019992539, -122.427899880877) | 9 | 7 | 6 | 28861 | 5 | |
56514 | 197407 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015042.44961 | 2109744.00575 | 37.7738002107574 | -122.39139131067 | (37.7738002107574, -122.39139131067) | 14 | 3 | 9 | 310 | 20 | |||
59075 | 197429 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015013.85039 | 2109250.55837 | 37.7724437264277 | -122.391455737212 | (37.7724437264277, -122.391455737212) | 14 | 3 | 9 | 310 | 20 | |||
73990 | 240910 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 725 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009324.1679 | 2104803.20752 | 37.7599148887933 | -122.410822828117 | (37.7599148887933, -122.410822828117) | 2 | 4 | 7 | 28859 | 19 | |||
97798 | 36119 | Permitted Site 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1374 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2016 12:00:00 AM | 3 | 5x3 | Permit Number 43440 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.472603569045 | (37.7623789807661, -122.472603569045) | 1 | 8 | 11 | 56 | 12 |
98641 | 197453 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009170.60283 | 2111027.24083 | 37.7769960307789 | -122.411793739793 | (37.7769960307789, -122.411793739793) | 8 | 2 | 9 | 28853 | 34 | |||
134025 | 197449 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009262.53236 | 2111115.69015 | 37.7772440485182 | -122.411481976333 | (37.7772440485182, -122.411481976333) | 8 | 2 | 9 | 28853 | 34 | |||
154513 | 197451 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009234.52734 | 2111091.20385 | 37.7771752440663 | -122.41157712459 | (37.7771752440663, -122.41157712459) | 8 | 2 | 9 | 28853 | 34 | |||
4747 | 197441 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015039.64568 | 2108796.242 | 37.7711977058453 | -122.391334743299 | (37.7711977058453, -122.391334743299) | 14 | 3 | 9 | 310 | 20 | |||
22270 | 38984 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 300x San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40762 | 6010859.35781 | 2106780.294 | 37.7654294829959 | -122.405652581617 | (37.7654294829959, -122.405652581617) | 8 | 4 | 8 | 28853 | 19 | |
24106 | 197438 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015034.67097 | 2108883.60182 | 37.7714373005145 | -122.391358059129 | (37.7714373005145, -122.391358059129) | 14 | 3 | 9 | 310 | 20 | |||
27319 | 197432 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015019.54428 | 2109161.1913 | 37.7721986602722 | -122.391429792676 | (37.7721986602722, -122.391429792676) | 14 | 3 | 9 | 310 | 20 | |||
27914 | 197445 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013675.59633 | 2108064.32122 | 37.7691122166786 | -122.396001777755 | (37.7691122166786, -122.396001777755) | 14 | 3 | 9 | 310 | 20 | |||
35791 | 197455 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009137.47043 | 2110995.28328 | 37.7769064241241 | -122.4119060966 | (37.7769064241241, -122.4119060966) | 8 | 2 | 9 | 28853 | 34 | |||
36023 | 197442 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015041.42072 | 2108767.34362 | 37.7711184557895 | -122.391326582849 | (37.7711184557895, -122.391326582849) | 14 | 3 | 9 | 310 | 20 | |||
49544 | 197434 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015028.191 | 2108995.68449 | 37.7717446951044 | -122.391388310536 | (37.7717446951044, -122.391388310536) | 14 | 3 | 9 | 310 | 20 | |||
50420 | 197403 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015051.73928 | 2109577.98183 | 37.7733448615187 | -122.391347567643 | (37.7733448615187, -122.391347567643) | 14 | 3 | 9 | 310 | 20 | |||
51457 | 197376 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 300 San Bruno Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010875.09874 | 2106538.07352 | 37.7647652806152 | -122.405581075631 | (37.7647652806152, -122.405581075631) | 8 | 4 | 8 | 28853 | 19 | |||
88055 | 197457 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009096.316 | 2110957.37076 | 37.7768000163312 | -122.412045782913 | (37.7768000163312, -122.412045782913) | 8 | 2 | 9 | 28853 | 34 | |||
99793 | 197443 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013632.06784 | 2108039.85381 | 37.7690426127674 | -122.396150626374 | (37.7690426127674, -122.396150626374) | 14 | 3 | 9 | 310 | 20 | |||
109547 | 197389 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015087.56892 | 2108946.60059 | 37.7716132169039 | -122.39117948526 | (37.7716132169039, -122.39117948526) | 14 | 3 | 9 | 310 | 20 | |||
113142 | 96393 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767136 | 6015446.34816 | 2105205.82612 | 37.7613617684412 | -122.389677121926 | (37.7613617684412, -122.389677121926) | 10 | 3 | 8 | 28856 | 29 | |
119933 | 197444 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013653.6839 | 2108052.2415 | 37.7690778293104 | -122.396076725459 | (37.7690778293104, -122.396076725459) | 14 | 3 | 9 | 310 | 20 | |||
125503 | 197394 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015074.87374 | 2109163.38918 | 37.7722077659022 | -122.391238555416 | (37.7722077659022, -122.391238555416) | 14 | 3 | 9 | 310 | 20 | |||
131703 | 240914 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 85 Sycamore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006391.17124 | 2105833.44907 | 37.7625787985022 | -122.421039806442 | (37.7625787985022, -122.421039806442) | 8 | 4 | 7 | 28859 | 19 | |||
134960 | 197456 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 668 Natoma St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009124.38702 | 2110985.06111 | 37.7768776224341 | -122.411950633731 | (37.7768776224341, -122.411950633731) | 8 | 2 | 9 | 28853 | 34 | |||
136671 | 197408 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015042.21783 | 2109774.95767 | 37.773885184988 | -122.391394276636 | (37.773885184988, -122.391394276636) | 14 | 3 | 9 | 310 | 20 | |||
149133 | 197435 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015029.61492 | 2108966.93535 | 37.7716658353527 | -122.391381374959 | (37.7716658353527, -122.391381374959) | 14 | 3 | 9 | 310 | 20 | |||
159316 | 197423 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015003.80632 | 2109440.09446 | 37.7729635930298 | -122.391503734027 | (37.7729635930298, -122.391503734027) | 14 | 3 | 9 | 310 | 20 | |||
161828 | 197446 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013697.34857 | 2108075.95156 | 37.7691453611896 | -122.395927352578 | (37.7691453611896, -122.395927352578) | 14 | 3 | 9 | 310 | 20 | |||
167371 | 197428 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015013.65902 | 2109278.19684 | 37.7725196049206 | -122.39145833173 | (37.7725196049206, -122.39145833173) | 14 | 3 | 9 | 310 | 20 | |||
173099 | 197440 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015037.52027 | 2108824.47635 | 37.7712751131743 | -122.391344069293 | (37.7712751131743, -122.391344069293) | 14 | 3 | 9 | 310 | 20 | |||
173113 | 197439 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015038.53037 | 2108853.85657 | 37.7713558408268 | -122.39134262946 | (37.7713558408268, -122.39134262946) | 14 | 3 | 9 | 310 | 20 | |||
179190 | 197384 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015096.00206 | 2108800.56286 | 37.7712126975445 | -122.391140104833 | (37.7712126975445, -122.391140104833) | 14 | 3 | 9 | 310 | 20 | |||
186115 | 240510 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 180 Guerrero St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6005414.72148 | 2107962.30986 | 37.7683690520207 | -122.424568435908 | (37.7683690520207, -122.424568435908) | 8 | 4 | 5 | 28853 | 19 | |||
6352 | 197375 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 300 San Bruno Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010873.43891 | 2106555.26332 | 37.7648123871029 | -122.405588027383 | (37.7648123871029, -122.405588027383) | 8 | 4 | 8 | 28853 | 19 | |||
8409 | 197436 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015031.80159 | 2108941.72055 | 37.7715967224486 | -122.391372048095 | (37.7715967224486, -122.391372048095) | 14 | 3 | 9 | 310 | 20 | |||
8818 | 197404 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015051.04014 | 2109607.02256 | 37.7734245621155 | -122.39135201659 | (37.7734245621155, -122.39135201659) | 14 | 3 | 9 | 310 | 20 | |||
12310 | 197401 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015056.14247 | 2109498.92263 | 37.7731280268706 | -122.391326808588 | (37.7731280268706, -122.391326808588) | 14 | 3 | 9 | 310 | 20 | |||
32884 | 34475 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1725 Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1997 12:00:00 AM | 5 | Permit Number 38203 | 6008703.71619 | 2118937.2294 | 37.7986887388648 | -122.413968550512 | (37.7986887388648, -122.413968550512) | 5 | 1 | 10 | 308 | 21 | ||
35995 | 179418 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 416 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012204.41611 | 2086714.82751 | 37.7104090627014 | -122.399591381259 | (37.7104090627014, -122.399591381259) | 10 | 3 | 8 | 309 | 1 | |||
36313 | 136356 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 400 Leavenworth St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008467.36905 | 2113992.78863 | 37.7850992389805 | -122.414436340073 | (37.7850992389805, -122.414436340073) | 7 | 10 | 9 | 28852 | 36 | |||
37111 | 197402 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015055.01936 | 2109528.18581 | 37.7732083147396 | -122.391332739634 | (37.7732083147396, -122.391332739634) | 14 | 3 | 9 | 310 | 20 | |||
45343 | 197431 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015017.15645 | 2109191.48818 | 37.7722817162658 | -122.391440170853 | (37.7722817162658, -122.391440170853) | 14 | 3 | 9 | 310 | 20 | |||
48408 | 38390 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2435 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1998 12:00:00 AM | 5 | 3x5 | Permit Number 40447 | 6006235.29717 | 2119188.71841 | 37.7992403209449 | -122.422527961414 | (37.7992403209449, -122.422527961414) | 13 | 9 | 1 | 28858 | 32 | |
48454 | 197398 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015068.90313 | 2109281.03348 | 37.7725304597531 | -122.391267433543 | (37.7725304597531, -122.391267433543) | 14 | 3 | 9 | 310 | 20 | |||
52999 | 179419 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 416 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012202.51453 | 2086708.25139 | 37.7103908999794 | -122.399597492152 | (37.7103908999794, -122.399597492152) | 10 | 3 | 8 | 309 | 1 | |||
54092 | 197405 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1145 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015047.0197 | 2109662.59609 | 37.7735769315563 | -122.391369809678 | (37.7735769315563, -122.391369809678) | 14 | 3 | 9 | 310 | 20 | |||
56482 | 240942 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 671 Church St | 54 | Front Yard : Yard | Tree | Private 2 | 5 | Width 3ft | 6004290.97855 | 2105224.44216 | 37.7607879973784 | -122.428260207767 | (37.7607879973784, -122.428260207767) | 2 | 4 | 5 | 28862 | 3 | |||
56632 | 197385 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015094.6551 | 2108827.79856 | 37.7712874060154 | -122.391146668097 | (37.7712874060154, -122.391146668097) | 14 | 3 | 9 | 310 | 20 | |||
62406 | 119522 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 790 31st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5986359.69309 | 2110558.27509 | 37.7744022999761 | -122.490668135755 | (37.7744022999761, -122.490668135755) | 11 | 6 | 2 | 55 | 26 | |||
66029 | 197424 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015005.72101 | 2109404.95283 | 37.7728672081818 | -122.39149465358 | (37.7728672081818, -122.39149465358) | 14 | 3 | 9 | 310 | 20 |
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) );