trees

8,298 rows where qLegalStatus_id = 4 sorted by qSiteInfo

✎ View and edit SQL

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)
134678 116624 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 5 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
147794 115388 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 169x BOCANA ST 1 Front Yard : Cutout Tree Private 2     25 40x50   6007278 2097999 37.7411171346524 -122.417417333034 (37.7411171346524, -122.417417333034) 2 7 7 28859 2
148169 116626 Undocumented 4 Callistemon viminalis :: Weeping Bottlebrush 60 5732X GEARY BLVD 7 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
153318 114098 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 219x VIDAL DR 1 Front Yard : Cutout Tree Private 2     40     5987664 2090565 37.7195822022131 -122.484689437364 (37.7195822022131, -122.484689437364) 1 8 4 64 14
160316 114264 Undocumented 4 Pinus radiata :: Monterey Pine 15 800x BROTHERHOOD WAY 5 Front Yard : Cutout Tree Private 2     32     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
163015 112570 Undocumented 4 Cordyline australis :: Dracena Palm 64 162 GRAND VIEW AVE 2 Front Yard : Cutout Tree Private 2       3x3   6000754 2103380 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392) 2 4 5 63 38
167673 116622 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 3 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
174243 116623 Undocumented 4 Olea europaea :: Olive Tree 9 5732X GEARY BLVD 4 Front Yard : Cutout Tree MTA 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
176052 114930 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 6 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
179210 112417 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 98X BROADMOOR DR 1 Front Yard : Cutout Tree Private 2     28 3x3   5990934 2093194 37.7269906812088 -122.47357801435 (37.7269906812088, -122.47357801435) 9 8 4 64 40
182097 114929 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 5 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
182761 114936 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 12 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
188579 114935 Undocumented 4 Pinus radiata :: Monterey Pine 15 4400x OCEAN AVE 11 Front Yard : Cutout Tree Private 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
65 264979 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
231 116978 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 4 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
1948 113530 Undocumented 4 Prunus spp :: Flowering Plum 209 2598x 30TH AVE 3 Front Yard : Yard Tree Private 2       3x3   5987135 2097625 37.7389363086492 -122.487036198648 (37.7389363086492, -122.487036198648) 1 8 3 29491 35
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4438 254757 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 13 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
6238 103666 Undocumented 4 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
6858 261031 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 150 Chestnut St 1 Front Yard : Yard Tree Private 2       3x3   6011107 2121175 37.8049677916951 -122.405810090856 (37.8049677916951, -122.405810090856) 3 1 10 308 23
7194 117622 Undocumented 4 Pinus radiata :: Monterey Pine 15 890x VERMONT ST 1 Front Yard : Yard Tree Rec/Park 5           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
8160 107407 Undocumented 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 171 TWIN PEAKS BLVD 1 Front Yard : Yard Tree Private 2     12     5998631.4 2104681.4 37.7589750798494 -122.447794991901 (37.7589750798494, -122.447794991901) 15 5 5 28862 12
8847 110165 Undocumented 4 Pinus radiata :: Monterey Pine 15 129x GARCES DR 1 Front Yard : Yard Tree Private 2     23     5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
10436 105254 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 130 GONZALEZ DR   Front Yard : Yard Tree Private 2     2     5990327 2090136 37.7185590045312 -122.47545320092 (37.7185590045312, -122.47545320092) 1 8 4 64 14
11053 116828 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 15 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
13714 116827 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 14 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
15258 103665 Undocumented 4 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 Undocumented 4 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 Undocumented 4 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18674 103662 Undocumented 4 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
20014 178243 Undocumented 4 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 3 Front Yard : Yard Tree Private 2     26 Width 8ft   6009152.06447 2086268.0035 37.7090115585089 -122.410109471469 (37.7090115585089, -122.410109471469) 9 7 8 309 39
20335 114509 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 3X VULCAN STWY 1 Front Yard : Yard Tree Private 2     56     6000640 2106231 37.7633444989385 -122.440959493883 (37.7633444989385, -122.440959493883) 15 5 5 28862 3
21010 258626 Undocumented 4 Tree(s) :: 17 43 Carver St 1 Front Yard : Yard Tree Private 2       3x3   6009465 2098515 37.7426567664404 -122.40989186085 (37.7426567664404, -122.40989186085) 10 7 7 28859 2
21975 107666 Undocumented 4 Quillaja saponaria :: Chilean Soapbark 349 140 STRATFORD DR 1 Front Yard : Yard Tree Private 2   12/17/2014 12:00:00 AM 3   Permit Number 774157 5990881.4 2091504.3 37.7223481397163 -122.473636645054 (37.7223481397163, -122.473636645054) 9 8 4 64 40
22356 93153 Undocumented 4 Yucca elephantipes :: Giant Yucca 268 222 Sadowa St 2 Front Yard : Yard Tree Private 2     6 3x24   5994796 2087777 37.7123397937745 -122.459835021723 (37.7123397937745, -122.459835021723) 9 8 6 28861 24
22667 116824 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 11 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
23240 255713 Undocumented 4 Myoporum laetum :: Myoporum 62 618x Mendell St 3 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
25538 97980 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 325 Bowdoin St 10 Front Yard : Yard Tree Private 2       3x105 Permit Number 767976 6008582.5 2094142.5 37.7306013339748 -122.412634267782 (37.7306013339748, -122.412634267782) 9 3 7 309 28
25732 116996 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 606x FULTON ST   Front Yard : Yard Tree Private 2   09/29/2016 12:00:00 AM 3     6004628 2111737 37.7786889706302 -122.427558590519 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
28904 255717 Undocumented 4 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 937x Meade Ave 3 Front Yard : Yard Tree Private 2       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
29414 120559 Undocumented 4 Pinus radiata :: Monterey Pine 15 298X Bemis St 1 Front Yard : Yard Tree Private 2           6002876 2096191 37.7359041225922 -122.432508740106 (37.7359041225922, -122.432508740106) 2 7 5 63 7
32419 110166 Undocumented 4 Pinus radiata :: Monterey Pine 15 131x GARCES DR 1 Front Yard : Yard Tree Private 2     28     5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
33077 178244 Undocumented 4 Pinus radiata :: Monterey Pine 15 62 Tomaso Ct 4 Front Yard : Yard Tree Private 2     17 Width 8ft   6009170.0421 2086265.24197 37.7090049835504 -122.410047143074 (37.7090049835504, -122.410047143074) 9 7 8 309 39
34419 116605 Undocumented 4 Ficus Spp. :: 101 1325x 08TH AVE 2 Front Yard : Yard Tree MTA 3           5993613 2106469 37.7635952548206 -122.465280685608 (37.7635952548206, -122.465280685608) 1 8 11 56 12
34663 103470 Undocumented 4 Tree(s) :: 17 1190X Vermont St 1 Front Yard : Yard Tree Private 2   05/03/2013 12:00:00 AM 24   Permit Number 770173 6011370.8 2102820.9 37.7545864559266 -122.403605009348 (37.7545864559266, -122.403605009348) 10 4 8 28859 19
35001 116817 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 4 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
35280 255716 Undocumented 4 Prunus domestica 'Santa Rosa' :: Santa Rosa Plum 158 937x Meade Ave 2 Front Yard : Yard Tree Private 2       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
36528 107066 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 1758 12th Ave 1 Front Yard : Yard Tree Private 2   07/24/2014 12:00:00 AM     Permit Number 773344 5992506.32742 2103625.79831 37.7557246862805 -122.468901366602 (37.7557246862805, -122.468901366602) 1 8 4 56 12
37329 112121 Undocumented 4 Acer japonicum :: Japanese Maple 124 428 COLLINGWOOD ST 1 Front Yard : Yard Tree Private 2     5 10x9   6002093 2103331 37.755464449457 -122.435726554381 (37.755464449457, -122.435726554381) 2 4 5 28862 22
37718 110162 Undocumented 4 Tree(s) :: 17 123x GARCES DR 2 Front Yard : Yard Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 777996 5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
38711 116976 Undocumented 4 Salix spp :: Willow 203 100x CARGO WAY 7 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
42853 113802 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 806 SHOTWELL ST 4 Front Yard : Yard Tree Private 2           6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
46883 106970 Undocumented 4 Tree(s) :: 17 30 Piedmont St   Front Yard : Yard Tree Private 2   07/11/2014 12:00:00 AM     Permit Number 772781 5999571.08265 2107127.27884 37.7657445183673 -122.444720943629 (37.7657445183673, -122.444720943629) 15 5 5 29492 9
46944 102226 Undocumented 4 Tree(s) :: 17 3088 Market St 1 Front Yard : Yard Tree Private 2   01/28/2013 12:00:00 AM 60   Permit Number 769557 5999953.3 2105403.7 37.7610338030554 -122.443275133554 (37.7610338030554, -122.443275133554) 15 5 5 28862 3
49406 106153 Undocumented 4 Tree(s) :: 17 735 TERESITA BLVD 1 Front Yard : Yard Tree Private 2   07/25/2014 12:00:00 AM 40   Permit Number 772792 5998960.9 2095994 37.7351404140963 -122.446030577249 (37.7351404140963, -122.446030577249) 9 7 4 63 40
49681 116977 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100x CARGO WAY 117 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
52993 107410 Undocumented 4 Tree(s) :: 17 195 VILLA TER 1 Front Yard : Yard Tree Private 2           5999179.7 2104111.6 37.7574418733594 -122.445857739815 (37.7574418733594, -122.445857739815) 2 5 5 28862 3
53316 104931 Undocumented 4 Pinus radiata :: Monterey Pine 15 841 Gonzalez Dr 1 Front Yard : Yard Tree Private 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
53972 116826 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 13 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
57984 116822 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 9 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
59108 109457 Undocumented 4 Eucalyptus cinerea :: Ash-colored Eucalyptus 142 951 GILMAN AVE 43 Front Yard : Yard Tree Rec/Park 5     23     6015934 2089205 37.7174537876507 -122.386874585955 (37.7174537876507, -122.386874585955) 10 3 8 58 1
64580 114269 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 10 Front Yard : Yard Tree Private 2     38     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
67277 113529 Undocumented 4 Prunus spp :: Flowering Plum 209 2598x 30TH AVE 2 Front Yard : Yard Tree Private 2       3x3   5987135 2097625 37.7389363086492 -122.487036198648 (37.7389363086492, -122.487036198648) 1 8 3 29491 35
72158 113805 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 990X OSHAUGHNESSY BLVD 2 Front Yard : Yard Tree Rec/Park 5       3x30   6000025 2096199 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687) 9 7 4 63 40
72407 118344 Undocumented 4 Pinus radiata :: Monterey Pine 15 621x Gough St 1 Front Yard : Yard Tree Private 2           6005346 2111820 37.7789574535961 -122.425080654997 (37.7789574535961, -122.425080654997) 7 9 11 28852 41
73123 119673 Undocumented 4 Shrub :: Shrub 66 1207 De Haro St 1 Front Yard : Yard Tree Private 2           6012287 2102743 37.7544236952833 -122.400431054928 (37.7544236952833, -122.400431054928) 10 3 8 28856 29
74005 107506 Undocumented 4 Tree(s) :: 17 129 STRATFORD DR 1 Front Yard : Yard Tree Private 2         12' PROW 5990962.6 2091579.6 37.7225595971545 -122.473361447828 (37.7225595971545, -122.473361447828) 9 8 4 64 40
74396 121619 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 1465 Rhode Island St 1 Front Yard : Yard Tree Private 2           6012073 2101555 37.7511497699027 -122.401087656443 (37.7511497699027, -122.401087656443) 10 3 8 28856 29
78350 107828 Undocumented 4 Juniperus chinensis :: Juniper 113 2601 Van Ness Ave 2 Front Yard : Yard Tree Private 2     35   Permit Number 774138 6005744.5 2119283.2 37.7994720432373 -122.424233014169 (37.7994720432373, -122.424233014169) 13 9 1 28858 17
80560 114268 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 800x BROTHERHOOD WAY 9 Front Yard : Yard Tree Private 2     30     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
81034 116831 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 18 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
81049 116820 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 7 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
81381 111709 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 2 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
87763 120665 Undocumented 4 Pinus radiata :: Monterey Pine 15 2202 22nd St 1 Front Yard : Yard Tree Private 2           6011556 2103784 37.7572412595444 -122.403032272766 (37.7572412595444, -122.403032272766) 10 3 8 28856 29
90664 116825 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 12 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
90678 112684 Undocumented 4 Schinus molle :: California Pepper 91 86 STANTON ST 1 Front Yard : Yard Tree Private 2       3x3   6000281 2103909 37.7569484049338 -122.442034474193 (37.7569484049338, -122.442034474193) 2 4 5 28862 38
90740 112843 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1415 EVANS AVE 1 Front Yard : Yard Tree Private 2           6016481 2097724 37.7408755487739 -122.385577218432 (37.7408755487739, -122.385577218432) 10 3 8 58 1
94782 94852 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 769 Joost Ave 1 Front Yard : Yard Tree Private 2     6     5997030.4 2094957.2 37.7321831815324 -122.45263017562 (37.7321831815324, -122.45263017562) 9 7 4 59 40
98187 114386 Undocumented 4 Pinus radiata :: Monterey Pine 15 429x ARBALLO DR 1 Front Yard : Yard Tree Private 2     56     5988163 2090444 37.7192790152529 -122.482955732568 (37.7192790152529, -122.482955732568) 1 8 4 64 14
101697 255715 Undocumented 4 Prunus armeniaca :: Apricot 296 937x Meade Ave 1 Front Yard : Yard Tree Private 2       3x3   6012763 2089349 37.7176730984513 -122.397845439416 (37.7176730984513, -122.397845439416) 10 3 8 58 1
101974 110216 Undocumented 4 Tree(s) :: 17 2X BONVIEW ST 1 Front Yard : Yard Tree Private 2       3x3   6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
102160 117527 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1099x WALLER ST 1 Front Yard : Yard Tree Private 2           6000071 2108311 37.769023235971 -122.44307686155 (37.769023235971, -122.44307686155) 15 5 5 29492 9
102741 98542 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 555 Teresita Blvd 1 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
103044 116823 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 10 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
104143 121618 Undocumented 4 Tree(s) :: 17 1459 Rhode Island St 1 Front Yard : Yard Tree Private 2           6012071 2101579 37.7512155571193 -122.401096258898 (37.7512155571193, -122.401096258898) 10 3 8 28856 29
106034 255453 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 Kiska Rd 1 Front Yard : Yard Tree Private 2       3x3   6018381 2093938 37.7305848832053 -122.378744818809 (37.7305848832053, -122.378744818809) 10 3 8 58 1
106101 107308 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 190 EUCALYPTUS DR 3 Front Yard : Yard Tree Private 2     14     5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40
107208 100135 Undocumented 4 Tree(s) :: 17 155 05th St 1 Front Yard : Yard Tree Private 2   11/27/2012 12:00:00 AM 9   Permit Number 769351 6011029.6 2112857.4 37.7821253339557 -122.405491786923 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
116417 104205 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 710X Brotherhood Way 2 Front Yard : Yard Tree DPW 1         Permit Number 770788 5991124.9259 2088065.41222 37.7129198985758 -122.472544248538 (37.7129198985758, -122.472544248538) 1 8 4 64 14
120109 105769 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 1 Gonzalez Dr 1 Front Yard : Yard Tree Private 2   02/24/2014 12:00:00 AM     Permit Number 772589 5990111.8 2090190.8 37.7186969947407 -122.476201051717 (37.7186969947407, -122.476201051717) 1 8 4 64 14
120683 255712 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 618x Mendell St 6 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
120884 113311 Undocumented 4 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1001x Alemany Blvd 10 Front Yard : Yard Tree Private 2   11/09/2015 12:00:00 AM 20   Permit Number 776808 6003491.75626 2094313.44879 37.7307836910976 -122.430245918511 (37.7307836910976, -122.430245918511) 9 7 6 28861 25
122223 113804 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 990X OSHAUGHNESSY BLVD 1 Front Yard : Yard Tree Rec/Park 5       3x30   6000025 2096199 37.735764003208 -122.442366322687 (37.735764003208, -122.442366322687) 9 7 4 63 40
125688 117419 Undocumented 4 Pinus Spp :: Pine Spp 100 452 OAK ST 1 Front Yard : Yard Tree Private 2           6004802 2110240 37.774588415373 -122.426850015779 (37.774588415373, -122.426850015779) 7 9 11 28852 10
126220 116830 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 17 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
126572 111172 Undocumented 4 Tree(s) :: 17 5 LUNADO WAY 3 Front Yard : Yard Tree Private 2       3x3   5991435 2091370 37.7220114309215 -122.471713215221 (37.7220114309215, -122.471713215221) 9 8 4 59 40
126599 102130 Undocumented 4 Myoporum laetum :: Myoporum 62 33 Topaz Way 4 Front Yard : Yard Tree Private 2     7   Permit Number 769641 6001571.9 2098568 37.7423567715609 -122.437187662125 (37.7423567715609, -122.437187662125) 2 7 5 63 7
129496 255714 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 618x Mendell St 9 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016376 2097269 37.7396204009215 -122.385908564927 (37.7396204009215, -122.385908564927) 10 3 8 58 1
130616 116421 Undocumented 4 Podocarpus gracilor :: Fern Pine 51 621 STOCKTON ST 1 Front Yard : Yard Tree Private 2           6010507 2116333 37.7916392690679 -122.407544875665 (37.7916392690679, -122.407544875665) 5 1 10 28857 21
131531 104929 Undocumented 4 Tree(s) :: 17 815 Gonzalez Dr 1 Front Yard : Yard Tree Private 2   09/11/2014 12:00:00 AM 3   Permit Number 770295 5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40

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