trees
180 rows where qSpecies_id = 150 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
875 | 19954 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
1404 | 19975 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY45 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
1595 | 19920 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY36 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1837 | 19878 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY33 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
2169 | 19944 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
6286 | 19771 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY17 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
7321 | 20302 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 50X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
9985 | 19773 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY17 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 20ST | |||||||||||||
11575 | 19874 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY33 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
12424 | 19961 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY41 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
14073 | 19821 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY25 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10ST | |||||||||||||
17397 | 19895 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY33 | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
17450 | 19946 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
17793 | 19777 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY18 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
134873 | 6425 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1100X Evans Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/04/2003 12:00:00 AM | 12 | 3x3 | 6018217.31109 | 2096647.32337 | 37.7380151271058 | -122.379498860299 | (37.7380151271058, -122.379498860299) | 10 | 3 | 8 | 58 | 1 | ||
190012 | 6427 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1100X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018163.14059 | 2096688.19053 | 37.7381243524454 | -122.379688994958 | (37.7381243524454, -122.379688994958) | 10 | 3 | 8 | 58 | 1 | |||
144258 | 6728 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1200X Fairfax Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
171557 | 6704 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1200X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
63575 | 44253 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1375 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.384281551427 | (37.7404816352752, -122.384281551427) | 10 | 3 | 8 | 58 | 1 | |||
101683 | 44252 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1375 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.384281551427 | (37.7404816352752, -122.384281551427) | 10 | 3 | 8 | 58 | 1 | |||
74203 | 1916 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 11 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016651.8152009 | 2095266.4928857 | 37.734137178639 | -122.384815438972 | (37.734137178639, -122.384815438972) | 10 | 3 | 8 | 58 | 1 | |||
132091 | 1912 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 8 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016615.0158523 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | 10 | 3 | 8 | 58 | 1 | |||
88192 | 1711 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 5 Bass Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016572.54474 | 2095129.81679 | 37.7337575087508 | -122.385079984921 | (37.7337575087508, -122.385079984921) | 10 | 3 | 8 | 58 | 1 | |||
180412 | 6835 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1485 FAIRFAX AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/03/2017 08:13:00 AM | 3 | 3X3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | ||
94332 | 29878 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1500X La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 14 | 12x31 | 6015992.6911276 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | 10 | 3 | 8 | 58 | 1 | |||
122765 | 188562 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 36 03rd St | 11 | : | Tree | Private 2 | 12 | Width 3ft | 6015968.54272 | 2098749.82191 | 37.7436638776954 | -122.387420665355 | (37.7436638776954, -122.387420665355) | 10 | 3 | 8 | 58 | 1 | |||
185709 | 26889 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1601 Galvez Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6015842.1307553 | 2097647.0535434 | 37.7406288998504 | -122.387780842816 | (37.7406288998504, -122.387780842816) | 10 | 3 | 8 | 58 | 1 | |||
173340 | 22130 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3795X 03rd St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
187481 | 22125 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3795X 03rd St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015845.49183 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | 10 | 3 | 8 | 58 | 1 | |||
128049 | 200915 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3801 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6015749.7726 | 2098032.6644 | 37.7416825916515 | -122.388127088521 | (37.7416825916515, -122.388127088521) | 10 | 3 | 8 | 58 | 1 | |||
165268 | 188545 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 651 Missouri St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013660.85413 | 2103803.37059 | 37.75741176256 | -122.395754171925 | (37.75741176256, -122.395754171925) | 10 | 3 | 8 | 28856 | 29 | ||||
145654 | 188546 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 651 Missouri St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6013632.14132 | 2103889.75102 | 37.757647347167 | -122.395859525694 | (37.757647347167, -122.395859525694) | 10 | 3 | 8 | 28856 | 29 | ||||
7936 | 188547 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013501.25195 | 2102912.88665 | 37.754957806785 | -122.396243734071 | (37.754957806785, -122.396243734071) | 10 | 3 | 8 | 28856 | 29 | ||||
22213 | 188548 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013494.18064 | 2102912.22652 | 37.7549556007366 | -122.396268142573 | (37.7549556007366, -122.396268142573) | 10 | 3 | 8 | 28856 | 29 | ||||
144780 | 188549 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013485.70626 | 2102911.99671 | 37.7549544981753 | -122.396297433481 | (37.7549544981753, -122.396297433481) | 10 | 3 | 8 | 28856 | 29 | ||||
14871 | 188551 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013445.60553 | 2102908.48406 | 37.7549426217134 | -122.396435867938 | (37.7549426217134, -122.396435867938) | 10 | 3 | 8 | 28856 | 29 | ||||
47455 | 188552 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013433.23441 | 2102906.76929 | 37.7549372248775 | -122.396478530878 | (37.7549372248775, -122.396478530878) | 10 | 3 | 8 | 28856 | 29 | ||||
146942 | 188553 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013421.85474 | 2102905.28008 | 37.7549325025407 | -122.396517780884 | (37.7549325025407, -122.396517780884) | 10 | 3 | 8 | 28856 | 29 | ||||
64708 | 188554 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013414.60293 | 2102900.51315 | 37.7549190100055 | -122.396542525734 | (37.7549190100055, -122.396542525734) | 10 | 3 | 8 | 28856 | 29 | ||||
191870 | 188555 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013407.82956 | 2102894.99959 | 37.7549034940071 | -122.396565563648 | (37.7549034940071, -122.396565563648) | 10 | 3 | 8 | 28856 | 29 | ||||
119931 | 188543 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1501 22nd St | 13 | Front Yard : Yard | Tree | Private 2 | 9 | 6013381.40306 | 2103831.17556 | 37.7574725594206 | -122.396722580779 | (37.7574725594206, -122.396722580779) | 10 | 3 | 8 | 28856 | 29 | ||||
63539 | 188544 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1501 22nd St | 15 | Front Yard : Yard | Tree | Private 2 | 12 | 6013369.71631 | 2103799.38115 | 37.757384608426 | -122.396760769601 | (37.757384608426, -122.396760769601) | 10 | 3 | 8 | 28856 | 29 | ||||
24584 | 188556 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6013320.20258 | 2102893.09045 | 37.7548933748448 | -122.396868470618 | (37.7548933748448, -122.396868470618) | 10 | 3 | 8 | 28856 | 29 | ||||
88490 | 188557 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6013310.23031 | 2102900.17201 | 37.7549122641975 | -122.39690345423 | (37.7549122641975, -122.39690345423) | 10 | 3 | 8 | 28856 | 29 | ||||
43781 | 188558 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013273.06711 | 2102892.5718 | 37.7548893269913 | -122.397031443052 | (37.7548893269913, -122.397031443052) | 10 | 3 | 8 | 28856 | 29 | ||||
49488 | 188559 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6013256.52558 | 2102904.20918 | 37.7549203598944 | -122.397089464634 | (37.7549203598944, -122.397089464634) | 10 | 3 | 8 | 28856 | 29 | ||||
61467 | 188560 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013253.43645 | 2102897.8837 | 37.7549028195293 | -122.397099704282 | (37.7549028195293, -122.397099704282) | 10 | 3 | 8 | 28856 | 29 | ||||
158251 | 188550 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 6013235.33415 | 2102896.38806 | 37.7548977050817 | -122.397162202681 | (37.7548977050817, -122.397162202681) | 10 | 3 | 8 | 28856 | 29 | ||||
27746 | 54159 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 262 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 13 | Permit Number 9894 | 6012942.04708 | 2095291.83842 | 37.7340008934128 | -122.397643138528 | (37.7340008934128, -122.397643138528) | 10 | 3 | 8 | 58 | 1 | ||
115625 | 188542 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 900x Carolina St | 54 | Median : Yard | Tree | DPW 1 | 16 | 6012509.86374 | 2102962.70315 | 37.75503937799 | -122.399675754754 | (37.75503937799, -122.399675754754) | 10 | 3 | 8 | 28856 | 29 | ||||
175920 | 188561 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2230 Jerrold Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6012197.23492 | 2099395.45129 | 37.7452270442016 | -122.400506356909 | (37.7452270442016, -122.400506356909) | 10 | 3 | 8 | 58 | 1 | |||
170310 | 188563 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1 Waterville St | 1 | Side Yard : Yard | Tree | Private 2 | 6 | 6011470.31075 | 2096143.82241 | 37.7362581989524 | -122.402791312072 | (37.7362581989524, -122.402791312072) | 10 | 3 | 8 | 58 | 1 | ||||
98334 | 20270 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2290 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x3 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
128926 | 20260 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x3 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
51132 | 85506 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
60011 | 85505 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
72951 | 23661 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 308 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006889.9376932 | 2098288.2721449 | 37.7418895695178 | -122.418779625482 | (37.7418895695178, -122.418779625482) | 2 | 7 | 7 | 28859 | 2 | |||
143241 | 23685 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 330 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006867.2134351 | 2098039.8280465 | 37.7412061180035 | -122.418840582769 | (37.7412061180035, -122.418840582769) | 2 | 7 | 7 | 28859 | 2 | |||
74665 | 23658 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 302 Virginia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1997 12:00:00 AM | 8 | 3X3 | 6006870.1278442 | 2098321.8073815 | 37.7419805343744 | -122.418850499491 | (37.7419805343744, -122.418850499491) | 2 | 7 | 7 | 28859 | 2 | ||
54153 | 87313 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 230 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2008 12:00:00 AM | 3x3 | Permit Number 768785 | 6005882 | 2110375 | 37.7750200980063 | -122.423123675956 | (37.7750200980063, -122.423123675956) | 7 | 9 | 11 | 28852 | 10 | ||
41079 | 6157 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000X Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005895.06272 | 2113497.50021 | 37.7835944591715 | -122.423300504237 | (37.7835944591715, -122.423300504237) | 7 | 9 | 11 | 28858 | 41 | |||
35757 | 220118 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 42 | Front Yard : Yard | Tree | Private 2 | 12 | 6005108.52091 | 2097145.57569 | 37.7386515206473 | -122.424857914163 | (37.7386515206473, -122.424857914163) | 2 | 7 | 5 | 63 | 7 | ||||
124064 | 220119 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 65 | Front Yard : Yard | Tree | Private 2 | 6 | 6005096.05499 | 2097092.98426 | 37.7385064123255 | -122.42489727481 | (37.7385064123255, -122.42489727481) | 2 | 7 | 5 | 63 | 7 | ||||
22571 | 220121 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 67 | Front Yard : Yard | Tree | Private 2 | 8 | 6005092.0847 | 2097087.14126 | 37.7384901445062 | -122.424910586579 | (37.7384901445062, -122.424910586579) | 2 | 7 | 5 | 63 | 7 | ||||
170265 | 220120 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 66 | Front Yard : Yard | Tree | Private 2 | 15 | 6005087.11734 | 2097092.81243 | 37.738505435679 | -122.424928164698 | (37.738505435679, -122.424928164698) | 2 | 7 | 5 | 63 | 7 | ||||
50068 | 86923 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 195 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49881 | 6004763 | 2102539 | 37.7534411018365 | -122.426436480741 | (37.7534411018365, -122.426436480741) | 2 | 4 | 5 | 28862 | 22 | |||
145781 | 124767 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 3045 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6005087.0459 | 2120451.7007 | 37.8026433016029 | -122.426591292679 | (37.8026433016029, -122.426591292679) | 13 | 9 | 1 | 57 | 17 | |||
87585 | 10279 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 321 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004595.17399 | 2109451.15702 | 37.7724107484201 | -122.42750925745 | (37.7724107484201, -122.42750925745) | 7 | 9 | 11 | 28852 | 10 | |||
71222 | 2429 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 319X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6004581.20934 | 2109449.43359 | 37.7724052264427 | -122.427557439719 | (37.7724052264427, -122.427557439719) | 7 | 9 | 11 | 28852 | 10 | |||
185791 | 45128 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 232 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2001 12:00:00 AM | Permit Number 43985 | 6004034.46486858 | 2105728.24125402 | 37.7621567917777 | -122.429183297925 | (37.7621567917777, -122.429183297925) | 8 | 4 | 5 | 28862 | 3 | |||
172468 | 141736 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1420 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6003702.0095 | 2113653.0853 | 37.7838976435553 | -122.430898731444 | (37.7838976435553, -122.430898731444) | 13 | 9 | 11 | 29490 | 41 | |||
126091 | 30294 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 2705 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | Permit Number 137 | 6003541.5840662 | 2117604.65844184 | 37.7947385690082 | -122.43173597332 | (37.7947385690082, -122.43173597332) | 13 | 9 | 1 | 29490 | 27 | |||
25182 | 30293 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 2101 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | Permit Number 136 | 6003511.17021246 | 2117907.12338032 | 37.795567335959 | -122.431862816552 | (37.795567335959, -122.431862816552) | 13 | 9 | 1 | 29490 | 27 | |||
2897 | 62561 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 263 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22761 | 6002735.54596737 | 2109434.34982555 | 37.7722592430025 | -122.433940680004 | (37.7722592430025, -122.433940680004) | 15 | 5 | 11 | 29492 | 9 | ||
10494 | 62550 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 851 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22746 | 6002504.62213879 | 2109507.36231307 | 37.7724466097716 | -122.43474468697 | (37.7724466097716, -122.43474468697) | 15 | 5 | 11 | 29492 | 9 | ||
122138 | 59644 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 865 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22747 | 6002440.7343378 | 2109498.78550878 | 37.7724194326945 | -122.434965067297 | (37.7724194326945, -122.434965067297) | 15 | 5 | 11 | 29492 | 9 | ||
23013 | 62551 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 873 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22748 | 6002404.22700345 | 2109493.88447514 | 37.7724039027427 | -122.435090998906 | (37.7724039027427, -122.435090998906) | 15 | 5 | 11 | 29492 | 9 | ||
70471 | 247305 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 873 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002334.5255 | 2109487.5806 | 37.7723826357595 | -122.435331651709 | (37.7723826357595, -122.435331651709) | 15 | 5 | 11 | 29492 | 9 | |||
120558 | 62558 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 240 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30458 | 6002321.70129221 | 2109304.4334506 | 37.771879030768 | -122.43536290852 | (37.771879030768, -122.43536290852) | 15 | 5 | 11 | 29492 | 9 | ||
164894 | 62557 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 231 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22756 | 6002274.80033002 | 2109264.35337792 | 37.7717663171547 | -122.435522274291 | (37.7717663171547, -122.435522274291) | 15 | 5 | 11 | 29492 | 9 | ||
176679 | 53569 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 718 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1988 12:00:00 AM | Permit Number 6489 | 6002262.08955542 | 2108831.48537983 | 37.7705770468004 | -122.435535269571 | (37.7705770468004, -122.435535269571) | 15 | 5 | 11 | 29492 | 9 | ||
130684 | 18906 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2603 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 6002313.43773 | 2115715.13601 | 37.7894807345857 | -122.435850259079 | (37.7894807345857, -122.435850259079) | 13 | 6 | 1 | 29490 | 27 | |||
88750 | 62552 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 925 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22749 | 6002145.34756636 | 2109458.3701838 | 37.7722916859717 | -122.435983944483 | (37.7722916859717, -122.435983944483) | 15 | 5 | 11 | 29492 | 9 | ||
15340 | 62553 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 932 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22750 | 6002100.93353536 | 2109504.64892618 | 37.7724162326817 | -122.436140888716 | (37.7724162326817, -122.436140888716) | 15 | 5 | 11 | 29492 | 9 | ||
34835 | 71106 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 4235 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2015 07:32:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
167077 | 62554 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 950 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22751 | 6002017.25559301 | 2109492.91057277 | 37.772379247666 | -122.436429497983 | (37.772379247666, -122.436429497983) | 15 | 5 | 11 | 29492 | 9 | ||
147928 | 35038 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 955 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/16/1998 12:00:00 AM | Permit Number 38604 | 6002005.88434069 | 2109438.80626308 | 37.7722300445304 | -122.436464959051 | (37.7722300445304, -122.436464959051) | 15 | 5 | 11 | 29492 | 9 | ||
26226 | 247413 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 963 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | Permit Number 782288 | 6001970.4339 | 2109438.2533 | 37.7722265117572 | -122.436587545425 | (37.7722265117572, -122.436587545425) | 15 | 5 | 11 | 29492 | 9 | ||
124619 | 63746 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 963 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24418 | 6001968.69414602 | 2109433.58921739 | 37.7722136064806 | -122.436593229472 | (37.7722136064806, -122.436593229472) | 15 | 5 | 11 | 29492 | 9 | ||
171859 | 62555 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 968 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22753 | 6001933.57765066 | 2109481.17221936 | 37.7723422619436 | -122.436718106962 | (37.7723422619436, -122.436718106962) | 15 | 5 | 11 | 29492 | 9 | ||
177158 | 36668 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 973 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/20/1998 12:00:00 AM | Permit Number 39474 | 6001922.20638095 | 2109427.06790723 | 37.7721930587125 | -122.436753567493 | (37.7721930587125, -122.436753567493) | 15 | 5 | 11 | 29492 | 9 | ||
181814 | 247417 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 981 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001920.2327 | 2109431.4693 | 37.7722050316748 | -122.436760709737 | (37.7722050316748, -122.436760709737) | 15 | 5 | 11 | 29492 | 9 | |||
33671 | 247415 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 995 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001860.534 | 2109422.6502 | 37.7721774236453 | -122.436966580829 | (37.7721774236453, -122.436966580829) | 15 | 5 | 11 | 29492 | 9 | |||
85742 | 62544 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22739 | 6001803.31467833 | 2109086.42479932 | 37.7712509798957 | -122.437140429673 | (37.7712509798957, -122.437140429673) | 15 | 5 | 11 | 29492 | 9 | ||
108542 | 62546 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 324 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22741 | 6001810.43023006 | 2109526.13327918 | 37.7724587144958 | -122.437147304211 | (37.7724587144958, -122.437147304211) | 15 | 5 | 11 | 29492 | 9 | ||
57534 | 64732 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1988 12:00:00 AM | Permit Number 25691 | 6001783.83117373 | 2109148.55885484 | 37.7714204770503 | -122.437212273367 | (37.7714204770503, -122.437212273367) | 15 | 5 | 11 | 29492 | 9 | ||
119874 | 62548 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22743 | 6001791.89658849 | 2109658.78296356 | 37.7728218839519 | -122.437220913321 | (37.7728218839519, -122.437220913321) | 15 | 5 | 11 | 29492 | 9 | ||
144633 | 34853 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 85 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/01/1997 12:00:00 AM | Permit Number 38476 | 6001445.41488356 | 2093713.29123004 | 37.7290196763486 | -122.437277475077 | (37.7290196763486, -122.437277475077) | 9 | 7 | 6 | 28861 | 25 | ||
132213 | 62556 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1009 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22755 | 6001742 | 2109408 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | 15 | 5 | 11 | 29492 | 9 | ||
166484 | 62547 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 339 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22742 | 6001725.06048849 | 2109561.60697562 | 37.772551263359 | -122.43744514665 | (37.772551263359, -122.43744514665) | 15 | 5 | 11 | 29492 | 9 |
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) );