90 rows where Fire Prevention Districts = 2 and qLegalStatus_id = 8 sorted by DBH

View and edit SQL

Fire Prevention 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)
227 102275 Property Tree 8 Tree(s) :: 17 267 Topaz Way   Back Yard : Yard Landscaping Private 2           6001225.6 2097744.2 37.7400751189117 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
342 115652 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 18 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
2059 264900 Property Tree 8 Pinus radiata :: Monterey Pine 15 35X Parkridge Dr 1 Median : Yard Tree Private 2       3x3   5999060 2101975 37.7515684597407 -122.446118026985 (37.7515684597407, -122.446118026985) 2 5 5 63 38
2998 261600 Property Tree 8 Acer macrophyllum :: Big Leaf Maple 180 451X Jersey St 1 Back Yard : Yard Tree Public Library 12       3x3   6002237 2101405 37.7501842910814 -122.435090813874 (37.7501842910814, -122.435090813874) 2 4 5 28862 22
5758 262529 Property Tree 8 Pinus pinea :: Italian Stone Pine 63 555 Portola Dr 8 Front Yard : Yard Tree SFUSD 4       10x10   5997546 2099815 37.7455510557903 -122.451197845188 (37.7455510557903, -122.451197845188) 2 7 5 63 7
6585 260539 Property Tree 8 Pinus radiata :: Monterey Pine 15 1230 Twin Peaks Blvd 1 Back Yard : Yard Tree Private 2       3x3   5997905 2100119 37.7464063138276 -122.449978390477 (37.7464063138276, -122.449978390477) 2 5 4 63 38
9029 258675 Property Tree 8 Myoporum laetum :: Myoporum 62 60 Laidley St 1 Back Yard : Yard Tree Private 2       3x3   6003232 2097949 37.7407513687421 -122.431403364879 (37.7407513687421, -122.431403364879) 2 7 5 63 7
10460 258772 Property Tree 8 Cupressus spp :: Cypress species 337 20 Crestline Dr 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   5999139 2101332 37.7498074496931 -122.445798597569 (37.7498074496931, -122.445798597569) 2 5 5 63 38
22171 251481 Property Tree 8 Pinus radiata :: Monterey Pine 15 32 Peralta Ave 1 Back Yard : Yard Tree DPW 1       3x3   6010779 2100499 37.7481779538542 -122.405488104269 (37.7481779538542, -122.405488104269) 2 7 7 28859 2
22321 256538 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 19 Miguel St 1 Back Yard : Yard Tree Private 2       3x3   6003470 2097467 37.7394413932778 -122.430546066859 (37.7394413932778, -122.430546066859) 2 7 5 63 7
23775 108576 Property Tree 8 :: 45 2479 Diamond St 1 Front Yard : Yard Landscaping Private 2           6002240 2097369 37.7391025518434 -122.434791855338 (37.7391025518434, -122.434791855338) 2 7 5 63 7
24981 115647 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 13 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
26011 100148 Property Tree 8 Tree(s) :: 17 209 Vicksburg St   Back Yard : Yard Tree Private 2           6004141 2102142 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815) 2 4 5 28862 22
27745 115653 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 19 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
30200 98503 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 208 Glenview Dr   Back Yard : Yard Tree Private 2           5998871 2100779 37.7482737407191 -122.446685565827 (37.7482737407191, -122.446685565827) 2 5 5 63 38
32266 108871 Property Tree 8 Tree(s) :: 17 99x OAKWOOD ST 1 Back Yard : Yard Tree Private 2           6005305 2104962 37.7601247169433 -122.424734485609 (37.7601247169433, -122.424734485609) 2 4 5 28859 19
33684 97290 Property Tree 8 Pinus radiata :: Monterey Pine 15 55 Hiliritas Ave   Front Yard : Yard Tree Private 2         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981) 2 7 5 63 7
33827 99268 Property Tree 8 Tree(s) :: 17 292 Whitney St   Front Yard : Cutout Tree Private 2           6004280 2096681 37.7373290690714 -122.427689454915 (37.7373290690714, -122.427689454915) 2 7 5 63 7
34602 97033 Property Tree 8 Afrocarpus gracilior :: Fern Pine 89 61 Vicksburg St   Back Yard : Yard Tree Private 2         Possible significant tree; Nellie RoW; rear yard 6004120 2102703 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406) 2 4 5 28862 22
36364 115642 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 8 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
40432 110929 Property Tree 8 Pinus radiata :: Monterey Pine 15 445 BEACON ST   Back Yard : Yard Tree Private 2       3x3   6002243 2098437 37.7420352018096 -122.434857838675 (37.7420352018096, -122.434857838675) 2 7 5 63 7
42557 101977 Property Tree 8 Cedrus deodara :: Deodar Cedar 109 601 Grand View Ave   Front Yard : Yard Tree Private 2           6000076.2 2101609.9 37.7506239629918 -122.442577679409 (37.7506239629918, -122.442577679409) 2 4 5 28862 22
44517 251117 Property Tree 8 Sequoiadendron giganteum :: Sierra Redwood 240 2024 Castro St 1 Back Yard : Yard Tree Private 2           6002622 2099601 37.7452527853239 -122.433630548541 (37.7452527853239, -122.433630548541) 2 7 5 63 22
45129 98465 Property Tree 8 Tree(s) :: 17 190 Portola Dr   Back Yard : Yard Landscaping Private 2           5999550.3 2100620.3 37.7478767693988 -122.444325170302 (37.7478767693988, -122.444325170302) 2 5 5 63 38
53202 102251 Property Tree 8 Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 125X Powhattan Ave 4 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
54211 98502 Property Tree 8 Tree(s) :: 17 244 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
57437 108624 Property Tree 8 Juniperus chinensis :: Juniper 113 101 GENEBERN WAY 1 Front Yard : Yard Tree Private 2           6005050.2 2095237.8 37.733409902631 -122.424923866144 (37.733409902631, -122.424923866144) 2 7 7 28861 2
57789 121199 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 72 Fountain St 1 Back Yard : Yard Tree Private 2           6000322 2101283 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556) 2 4 5 28862 22
66704 107130 Property Tree 8 Phoenix dactylifera :: Date Palm 87 751 DOLORES ST 1 Front Yard : Cutout Tree Private 2           6005081.8 2103948.4 37.7573290011944 -122.425434294507 (37.7573290011944, -122.425434294507) 2 4 5 28859 19
67651 115641 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 7 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
68497 99961 Property Tree 8 Callistemon citrinus :: Lemon Bottlebrush 67 537 Valley St 1 Front Yard : Yard Tree Private 2   07/25/2012 12:00:00 AM     Permit Number 768880 6002459 2099152 37.7440106863694 -122.434162082356 (37.7440106863694, -122.434162082356) 2 7 5 63 22
69931 115646 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 12 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
82655 115645 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 11 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
84644 118371 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 4808 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999981 2101110 37.7492459313263 -122.442870994168 (37.7492459313263, -122.442870994168) 2 4 5 28862 22
90504 98893 Property Tree 8 Tree(s) :: 17 216 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998910 2100761 37.7482265448319 -122.446549410607 (37.7482265448319, -122.446549410607) 2 5 5 63 38
94159 97024 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1455 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768189 6009349 2100759.5 37.7488131674601 -122.410451409671 (37.7488131674601, -122.410451409671) 2 4 7 28859 19
99841 98436 Property Tree 8 Tree(s) :: 17 238 Glenview Dr   Back Yard : Yard Tree Private 2           5999035 2100736 37.7481650400364 -122.446115368035 (37.7481650400364, -122.446115368035) 2 5 5 63 38
101616 102250 Property Tree 8 Olea europaea :: Olive Tree 9 125X Powhattan Ave 3 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
102518 115648 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 14 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
105747 98892 Property Tree 8 Tree(s) :: 17 220 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998935 2100753 37.7482060067302 -122.44646238624 (37.7482060067302, -122.44646238624) 2 5 5 63 38
105934 99256 Property Tree 8 Sequoia sempervirens :: Coast Redwood 155 1466 York St   Back Yard : Yard Tree Private 2           6010099 2100741 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429) 2 4 7 28859 19
106673 256140 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 892 Moultrie St 1 Side Yard : Yard Tree Private 2       3x3   6007512 2095150 37.7333075704823 -122.416406492547 (37.7333075704823, -122.416406492547) 2 7 7 28859 2
108303 102249 Property Tree 8 Olea europaea :: Olive Tree 9 125X Powhattan Ave 2 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
109260 115649 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 15 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
113384 98890 Property Tree 8 Tree(s) :: 17 256 Glenview Dr   Back Yard : Yard Landscaping Private 2           5999134 2100748 37.7482036421854 -122.44577389345 (37.7482036421854, -122.44577389345) 2 5 5 63 38
113451 115644 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 10 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
117229 102248 Property Tree 8 Olea europaea :: Olive Tree 9 125X Powhattan Ave 1 Front Yard : Yard Tree Private 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
117341 104397 Property Tree 8 Pseudotsuga menziesii :: Douglas Fir 285 350 Collingwood St 1 Front Yard : Yard Tree Private 2           6002086 2103822 37.7568122198273 -122.435785890783 (37.7568122198273, -122.435785890783) 2 4 5 28862 3
120627 100045 Property Tree 8 Acacia decurrens :: Acacia: Silver Wattle 111 556 28th St   Front Yard : Yard Tree Private 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
122314 97023 Property Tree 8 Jacaranda mimosifolia :: Jacaranda 50 1443 Alabama St   Sidewalk: Curb side : Cutout Tree Private 2   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.7488938036461 -122.410459018192 (37.7488938036461, -122.410459018192) 2 4 7 28859 19
124823 98405 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 84 Richland Ave   Sidewalk: Curb side : Cutout Tree Private 2   02/08/2012 12:00:00 AM     Permit Number 768549 6005038.1 2096133 37.735867237922 -122.425029371072 (37.735867237922, -122.425029371072) 2 7 5 28859 2
137033 114410 Property Tree 8 Pinus radiata :: Monterey Pine 15 10 GARDENSIDE DR   Sidewalk: Curb side : Cutout Tree Private 2           5999306 2102458 37.7529087049134 -122.445302055175 (37.7529087049134, -122.445302055175) 2 5 5 63 38
137283 109242 Property Tree 8 Private shrub :: Private Shrub 284 2479 DIAMOND ST   Sidewalk: Curb side : Yard Landscaping Private 2           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916) 2 7 5 63 7
137488 98501 Property Tree 8 Tree(s) :: 17 232 Glenview Dr   Back Yard : Yard Landscaping Private 2           5998998 2100740 37.7481739100487 -122.446243600021 (37.7481739100487, -122.446243600021) 2 5 5 63 38
144021 115650 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 16 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
145213 256660 Property Tree 8 Private shrub :: Private Shrub 284 40X Miguel St 1 Back Yard : Yard Landscaping Private 2       3x3   6003624 2097154 37.7385906898162 -122.429991281012 (37.7385906898162, -122.429991281012) 2 7 5 63 7
149268 106458 Property Tree 8 Tree(s) :: 17 71 HANCOCK ST   Back Yard : Yard Tree Private 2           6003861.6 2105050 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413) 2 4 5 28862 3
162706 94228 Property Tree 8 Acer palmatum :: Japanese Maple 216 1097 Church St   Front Yard : Yard Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53567 6004455 2102510 37.7533440588084 -122.427499544702 (37.7533440588084, -122.427499544702) 2 4 5 28862 22
163840 115640 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 6 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
166769 102079 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 76 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/2012 12:00:00 AM   3x3 Permit Number 769729 6008162.3 2099676.4 37.7457726186307 -122.414478397936 (37.7457726186307, -122.414478397936) 2 7 7 28859 2
168631 115643 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 9 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
172414 256223 Property Tree 8 Schinus molle :: California Pepper 91 116X Brewster St 1 Sidewalk: Property side : Yard Tree Rec/Park 5       6x6   6010334 2099321 37.7449185312124 -122.406943891675 (37.7449185312124, -122.406943891675) 2 7 7 28859 2
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
175002 115655 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 21 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
177053 115654 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 20 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
181668 115651 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 17 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
183601 256482 Property Tree 8 Pinus radiata :: Monterey Pine 15 168 Moultrie St 1 Back Yard : Cutout Tree Private 2       3x3   6007766 2098288 37.7419381097545 -122.415750458671 (37.7419381097545, -122.415750458671) 2 7 7 28859 2
192149 98878 Property Tree 8 Tree(s) :: 17 11 Panorama Dr   Back Yard : Yard Landscaping Private 2           5998029 2100213 37.7466715093679 -122.449556386849 (37.7466715093679, -122.449556386849) 2 5 4 63 38
141413 224714 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 3 Front Yard : Cutout Tree MTA 3     11 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
68467 224715 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 4 Front Yard : Cutout Tree MTA 3     12 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
169065 108625 Property Tree 8 Persea americana :: Avocado 34 100 GENEBERN WAY 1 Front Yard : Yard Tree Private 2     12     6004991.8 2095242.4 37.7334192343039 -122.425126098693 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
42570 224716 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 5 Front Yard : Cutout Tree MTA 3     13 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
173132 115637 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 3 Back Yard : Cutout Tree DPW 1     14 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
122758 121144 Property Tree 8 Pinus radiata :: Monterey Pine 15 400 Franconia St 1 Back Yard : Yard Tree Private 2     15 3x3   6010016 2098808 37.7434921454983 -122.408007311669 (37.7434921454983, -122.408007311669) 2 7 7 28859 2
137355 115636 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 2 Back Yard : Cutout Tree DPW 1     16 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
154580 224422 Property Tree 8 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3255x 24th St 2 Front Yard : Cutout Tree MTA 3     16 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
58309 100046 Property Tree 8 Tree(s) :: 17 562 28th St   Front Yard : Yard Tree Private 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262 2099459 37.7448424535299 -122.434865213189 (37.7448424535299, -122.434865213189) 2 7 5 63 22
50874 225889 Property Tree 8 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 474 3255x 24th St 7 Back Yard : Cutout Tree MTA 3     18 Width 8ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
28785 122558 Property Tree 8 Pinus radiata :: Monterey Pine 15 1760 Diamond St 1 Back Yard : Yard Tree Private 2     20 3x3   6001927 2098732 37.7428272563398 -122.435971568238 (37.7428272563398, -122.435971568238) 2 7 5 63 22
94640 115635 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 1 Back Yard : Cutout Tree DPW 1     20 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
48396 109097 Property Tree 8 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
90477 109091 Property Tree 8 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 4235 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876 (37.7525900037408, -122.43731782876) 2 4 5 28862 22
106981 109092 Property Tree 8 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
185468 120977 Property Tree 8 Pinus radiata :: Monterey Pine 15 794x Gates St 1 Sidewalk: Curb side : Yard Tree Private 2     3030 3x3   6008103 2095407 37.7340464539486 -122.414381414226 (37.7340464539486, -122.414381414226) 2 7 7 28859 2
111666 225888 Property Tree 8 Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 474 3255x 24th St 1 Front Yard : Cutout Tree MTA 3     32 6x6   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
135134 113440 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 190 BEACON ST   Back Yard : Yard Tree Private 2     32 3x3   6003193 2097540 37.7396261385587 -122.431509020833 (37.7396261385587, -122.431509020833) 2 7 5 63 7
158127 104008 Property Tree 8 Pinus radiata :: Monterey Pine 15 357 Collingwood St 1 Back Yard : Yard Tree Private 2     36     6002124 2103789 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093) 2 4 5 28862 3
99978 234895 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 3255x 24th St 6 Side Yard : Cutout Tree Private 2     40 Width 10ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
92653 115639 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 5 Back Yard : Cutout Tree DPW 1     6 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
61637 115638 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 4 Back Yard : Cutout Tree DPW 1     7 3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2

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