trees

208 rows where Police Districts = 9 and qLegalStatus_id = 6 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
7770 98170 Significant Tree 6 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 2324 Sacramento St   Front Yard : Yard Tree Private 2   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.431173718492 (37.7902385582714, -122.431173718492) 13 9 1 29490 27
12063 95300 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 701 Golden Gate Ave   Front Yard : Yard Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
74407 121161 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 5 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
79081 121163 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 7 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
83376 121162 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 6 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
99672 121159 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 3 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
106415 121157 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 1 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
123818 121160 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 4 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
151632 95299 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 701 Golden Gate Ave   Front Yard : Yard Tree Private 2   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617 -122.422419858646 (37.780652317617, -122.422419858646) 7 9 11 28852 41
194054 121158 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 350x Octavia St 2 Side Yard : Yard Tree Private 2           6005623 2110494 37.7753322239184 -122.424028078477 (37.7753322239184, -122.424028078477) 7 9 11 28852 10
22 262394 Significant Tree 6 Pinus radiata :: Monterey Pine 15 66 Cleary Ct 1 Sidewalk: Property side : Cutout Tree DPW 1   11/13/2020 12:00:00 AM 3 3x3   6004824 2113713 37.7841256623529 -122.427021325889 (37.7841256623529, -122.427021325889) 13 9 11 28858 41
60038 258526 Significant Tree 6 Pinus radiata :: Monterey Pine 15 50 Hermann St 2 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
81315 104261 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1556X O'Farrell St 1 Front Yard : Yard Tree Private 2           6003781.85581 2113525.38813 37.783551542878 -122.430613377711 (37.783551542878, -122.430613377711) 13 9 11 29490 41
116546 95242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2620 Larkin St   Front Yard : Yard Tree Private 2     37   Permit Number 56959 6006630 2120172 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572) 5 9 1 28858 32
125282 110236 Significant Tree 6 Pinus radiata :: Monterey Pine 15 100 BUCHANAN ST 1 Sidewalk: Curb side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.7712187378523 -122.426532477218 (37.7712187378523, -122.426532477218) 7 9 5 28852 10
10900 256098 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 1776 Vallejo St 1 Front Yard : Cutout Tree Private 2           6005064.21519 2118169.93221 37.7963768588038 -122.426507729874 (37.7963768588038, -122.426507729874) 13 9 1 28858 17
29 264952 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 2 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
31 264951 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 1 Front Yard : Yard Tree Private 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
3436 103654 Significant Tree 6 Tree(s) :: 17 307X Octavia St 3 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
15160 260680 Significant Tree 6 Tree(s) :: 17 1450x Laguna St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6004617 2113883 37.7845807327875 -122.42774958855 (37.7845807327875, -122.42774958855) 13 9 11 28858 41
20021 88145 Significant Tree 6 Tree(s) :: 17 1475 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975 (37.7830370509294, -122.43279450975) 15 9 11 29490 41
20207 105239 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 6 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
25451 105226 Significant Tree 6 Tree(s) :: 17 1150X Golden Gate Ave 1 Front Yard : Yard Tree Private 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
27763 105240 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 10 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
29114 103653 Significant Tree 6 Tree(s) :: 17 307X Octavia St 2 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
51498 88569 Significant Tree 6 Tree(s) :: 17 1335 Webster St 60 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
56668 113769 Significant Tree 6 Tree(s) :: 17 2550 Broadway 1 Sidewalk: Property side : Cutout Tree Private 2           6001418.65940389 2117313.19689891 37.7938177263924 -122.439060665499 (37.7938177263924, -122.439060665499) 13 9 1 57 27
73226 114272 Significant Tree 6 Tree(s) :: 17 2241 Sacramento St 1 Front Yard : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.7901043022718 -122.429743441495 (37.7901043022718, -122.429743441495) 13 9 1 29490 27
77876 88571 Significant Tree 6 Tree(s) :: 17 1335 Webster St 62 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
96773 92813 Significant Tree 6 Tree(s) :: 17 365 Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3 Permit Number 53020 6006011 2111744 37.7787863189721 -122.42277474798 (37.7787863189721, -122.42277474798) 7 9 11 28852 10
100242 106956 Significant Tree 6 Tree(s) :: 17 50 Fell St 3 Front Yard : Yard Tree Private 2     14 10x10   6007226 2110908 37.7765593411304 -122.418512280303 (37.7765593411304, -122.418512280303) 7 9 9 28852 36
102859 87188 Significant Tree 6 Tree(s) :: 17 2119 Bush St   Front Yard : Yard Tree Private 2   01/29/2008 12:00:00 AM     Permit Number 50204 6002998 2114831 37.7870919849741 -122.433418544226 (37.7870919849741, -122.433418544226) 13 9 11 29490 27
106956 251495 Significant Tree 6 Tree(s) :: 17 2448 Clay St 1 Sidewalk: Curb side : Yard Tree Private 2   06/28/2017 12:00:00 AM 3 10x10 Permit Number 780000 6003026 2116224 37.7909183964794 -122.433421252488 (37.7909183964794, -122.433421252488) 13 9 1 29490 27
108684 103655 Significant Tree 6 Tree(s) :: 17 307X Octavia St 4 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
109449 103656 Significant Tree 6 Tree(s) :: 17 307X Octavia St 5 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
117572 105241 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 11 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
117668 105242 Significant Tree 6 Tree(s) :: 17 20X Cleary Ct 14 Front Yard : Yard Tree Private 2   01/06/2014 12:00:00 AM     Permit Number 770859 6005004.4 2113886.9 37.7846133478309 -122.426409592351 (37.7846133478309, -122.426409592351) 13 9 11 28858 41
121105 88572 Significant Tree 6 Tree(s) :: 17 1335 Webster St 66 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
121235 86895 Significant Tree 6 Tree(s) :: 17 321 Haight St   Front Yard : Yard Tree Private 2   10/26/2007 12:00:00 AM     Permit Number 49844 6004599.9 2109420.1 37.7723257406977 -122.427490696784 (37.7723257406977, -122.427490696784) 7 9 11 28852 10
125819 88147 Significant Tree 6 Tree(s) :: 17 1475 Fillmore St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975 (37.7830370509294, -122.43279450975) 15 9 11 29490 41
130549 88570 Significant Tree 6 Tree(s) :: 17 1335 Webster St 61 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
141035 88568 Significant Tree 6 Tree(s) :: 17 1335 Webster St 59 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
145466 88567 Significant Tree 6 Tree(s) :: 17 1335 Webster St 39 Front Yard : Cutout Tree Private 2   07/30/2008 12:00:00 AM     Permit Number 51511 6003187 2113215 37.7826655777078 -122.432649168887 (37.7826655777078, -122.432649168887) 15 9 11 29490 41
150357 100434 Significant Tree 6 Tree(s) :: 17 2430 Sacramento St 1 Front Yard : Yard Tree Private 2   09/24/2012 12:00:00 AM     Permit Number 769154 6003168.3 2115899 37.7900341016439 -122.432905672523 (37.7900341016439, -122.432905672523) 13 9 1 29490 27
152489 103652 Significant Tree 6 Tree(s) :: 17 307X Octavia St 1 Front Yard : Yard Tree DPW for City Agency 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
165618 105227 Significant Tree 6 Tree(s) :: 17 1150X Golden Gate Ave 2 Front Yard : Yard Tree Private 2   01/02/2014 12:00:00 AM     Permit Number 771276 6004329.61165 2112216.22051 37.7799879097685 -122.428625001082 (37.7799879097685, -122.428625001082) 7 9 11 29490 41
166780 173951 Significant Tree 6 Tree(s) :: 17 2646 Union St 1 Front Yard : Cutout Tree Private 2   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338 2118225 37.7962597494046 -122.442865342513 (37.7962597494046, -122.442865342513) 13 9 1 57 17
170538 88146 Significant Tree 6 Tree(s) :: 17 1475 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2000 12:00:00 AM   3x3 Permit Number 51176 6003147.8 2113351.1 37.7830370509294 -122.43279450975 (37.7830370509294, -122.43279450975) 15 9 11 29490 41
172328 101741 Significant Tree 6 Tree(s) :: 17 1590 Broadway 1 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM     Permit Number 769428 6006147.8 2117991.4 37.7959478507639 -122.422745597666 (37.7959478507639, -122.422745597666) 13 9 10 28858 32
177345 251411 Significant Tree 6 Tree(s) :: 17 2751 Buchanan St 1 Front Yard : Cutout Tree Private 2   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497 2117826 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505) 13 9 1 29490 27
181978 107824 Significant Tree 6 Tree(s) :: 17 10 STARR KING WAY 6 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3   Permit Number 774657 6005969 2114025 37.7850470161942 -122.423082215486 (37.7850470161942, -122.423082215486) 13 9 11 28858 41
182332 258021 Significant Tree 6 Tree(s) :: 17 201x Gough St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006013 2110374 37.7750247439455 -122.422670446803 (37.7750247439455, -122.422670446803) 7 9 11 28852 10
192756 94447 Significant Tree 6 Tree(s) :: 17 1103 Gough St 4 Sidewalk: Property side : Cutout Tree Private 2   08/06/2010 12:00:00 AM   3x3 Permit Number 53668 6005549.7 2113553.5 37.7837287235103 -122.424499312595 (37.7837287235103, -122.424499312595) 7 9 11 28858 41
92073 98492 Significant Tree 6 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 2149 Laguna St 1 Front Yard : Yard Tree Private 2           6004211.7 2116183 37.7908730187591 -122.429315856087 (37.7908730187591, -122.429315856087) 13 9 1 29490 27
91423 99643 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 1268 Lombard St 1 Front Yard : Yard Tree Private 2       3x3   6006289 2120073 37.8016713630652 -122.42240499597 (37.8016713630652, -122.42240499597) 5 9 1 28858 32
92540 113772 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 4 Sidewalk: Property side : Cutout Tree Private 2     4     6001375.31674 2117310.7972 37.7938086711861 -122.439210462719 (37.7938086711861, -122.439210462719) 13 9 1 57 27
95081 112874 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2636 Vallejo St 1 Sidewalk: Property side : Cutout Tree Private 2   08/25/2015 12:00:00 AM 13 3x3 Permit Number 776037 6000935.48392 2117605.97258 37.7945941075731 -122.440753504176 (37.7945941075731, -122.440753504176) 13 9 1 57 27
128387 113771 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 3 Sidewalk: Property side : Cutout Tree Private 2     5     6001386.1067 2117311.2447 37.7938105138862 -122.439173160634 (37.7938105138862, -122.439173160634) 13 9 1 57 27
162406 255994 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 179 Retiro Way 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   6001908 2121813 37.8062008335618 -122.437689923584 (37.8062008335618, -122.437689923584) 13 9 1 57 17
172310 113770 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 2550 Broadway 2 Sidewalk: Property side : Cutout Tree Private 2     5     6001403.30227 2117311.89486 37.7938132775122 -122.439113709125 (37.7938132775122, -122.439113709125) 13 9 1 57 27
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
18171 260058 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 5 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
43239 258527 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 50 Hermann St 3 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
55812 101740 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 3 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 10   Permit Number 769428 6006182.95151 2117984.64817 37.7959312951427 -122.42262348649 (37.7959312951427, -122.42262348649) 13 9 10 28858 32
63716 101743 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 4 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 12   Permit Number 769428 6006129.33795 2117976.30804 37.7959053703882 -122.422808406898 (37.7959053703882, -122.422808406898) 13 9 10 28858 32
140481 101742 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1590 Broadway 2 Front Yard : Yard Tree Private 2   12/21/2012 12:00:00 AM 8   Permit Number 769428 6006220.99461 2117990.30451 37.7959489722299 -122.422492252021 (37.7959489722299, -122.422492252021) 13 9 10 28858 32
157383 110560 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 2 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
157916 110559 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 1 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
167525 258528 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 50 Hermann St 4 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10
69 126274 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
12050 261306 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1555 Union St 1 Front Yard : Cutout Tree Private 2       3x3   6005549 2118864 37.7983099861265 -122.424879674285 (37.7983099861265, -122.424879674285) 13 9 1 57 17
17242 253971 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
108843 253969 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
124902 257918 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 2200 Vallejo St 1 Front Yard : Yard Tree Private 2       3x3   6002990 2117900 37.7955182191045 -122.433665645084 (37.7955182191045, -122.433665645084) 13 9 1 57 17
139296 253970 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
159837 253968 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
169126 115697 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1425x LAGUNA ST 1 Front Yard : Yard Tree Private 2     25     6004559 2113815 37.7843907406582 -122.4279454018 (37.7843907406582, -122.4279454018) 13 9 11 29490 41
83971 105071 Significant Tree 6 Acacia stenophylla :: Shoestring Acacia 30 1808 Vallejo St 1 Front Yard : Yard Tree Private 2     3   Permit Number 771033 6004794.05676 2118138.55822 37.7962754378239 -122.427440299436 (37.7962754378239, -122.427440299436) 13 9 1 57 17
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
16717 262293 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002408 2117119 37.7933407549318 -122.435623560602 (37.7933407549318, -122.435623560602) 13 9 1 29490 27
84706 103143 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2620 Buchanan St 1 Front Yard : Yard Tree Private 2       3x3   6003626 2117322 37.7939672460834 -122.431423695166 (37.7939672460834, -122.431423695166) 13 9 1 29490 27
99529 103588 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 101X Laguna St 1 Front Yard : Yard Tree Private 2           6005198.60314 2109385.58511 37.772264815602 -122.425417269432 (37.772264815602, -122.425417269432) 7 9 5 28852 10
64 264974 Significant Tree 6 Persea americana :: Avocado 34 1868 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003954 2119422 37.7997518904289 -122.430438688757 (37.7997518904289, -122.430438688757) 13 9 1 57 17
75842 103617 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 2 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
95437 103618 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 3 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
138097 88148 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1499 Eddy St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2000 12:00:00 AM 6 3x3 Permit Number 51176 6003399.3649 2112760.0054 37.7814283176978 -122.431881978872 (37.7814283176978, -122.431881978872) 15 9 11 29490 41
41224 258232 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 1 Sidewalk: Property side : Cutout Tree Private 2   04/24/2019 12:00:00 AM 3 3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
53621 258239 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 8 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
67916 258235 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 4 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
71526 258236 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
103945 258237 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
120900 258240 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
138832 258234 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
155172 258233 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
160060 258238 Significant Tree 6 Liquidambar styraciflua :: American Sweet Gum 37 200x Gough St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006251 2110547 37.7755131849671 -122.421859443165 (37.7755131849671, -122.421859443165) 7 9 11 28852 10
154508 109210 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2637 Larkin St 1 Front Yard : Yard Tree Private 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774817 6006569.78732 2120282.61277 37.8022627417937 -122.421448236261 (37.8022627417937, -122.421448236261) 5 9 1 28858 32
166311 127110 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201 Laguna St 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812) 13 9 1 57 17
185953 126695 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 2829 Divisadero St 2 Front Yard : Yard Tree Private 2     11 10x10 Permit Number 779774 6000551.43021 2118023.61416 37.7957189625051 -122.442112369006 (37.7957189625051, -122.442112369006) 13 9 1 57 17

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);