Street_Tree_List

Data source: data.sfgov.org

72 rows where SiteOrder = 3 and qLegalStatus = 4

View and edit SQL

Suggested facets: qSpecies, qSiteInfo, qCaretaker, DBH, PlotSize

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
15 196591 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 43 Lafayette St 3 : 4 Tree 1 Private 1     13 Width 3ft Permit Number 772992 6007555.65106 2109624.06249 37.7730525072055 -122.417280912782 (37.7730525072055, -122.417280912782)
60 121139 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1388x Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/08/2016 12:00:00 AM 3 3x3            
224 117019 Planning Code 138.1 required 4 Metrosideros excelsa :: New Zealand Xmas Tree 2 168 Hyde St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.41556230388201 (37.782365960952, -122.415562303882)
387 85807 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 210X Shipley St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604.0 2111950.0 37.779665925350706 -122.40344075372101 (37.7796659253507, -122.403440753721)
395 249557 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 3 : 4 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005881.27559 2115126.52616 37.788066583556706 -122.423464052238 (37.7880665835567, -122.423464052238)
400 251289 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 33 08th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.777717506500295 -122.41332290472799 (37.7777175065003, -122.413322904728)
415 250074 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 1599X Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083.0 2115238.0 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373)
425 251299 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 2190X Market St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4X4   6003624.7851 2107240.8343 37.766286807234295 -122.430708166736 (37.7662868072343, -122.430708166736)
976 160371 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 868 Edinburgh St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/26/2017 12:00:00 AM 3 3x3 Permit Number 779314 6001686.38396 2088939.3945099998 37.7159253269669 -122.43610294800199 (37.7159253269669, -122.436102948002)
1433 251520 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884)
1801 251699 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6005943.79297 2120373.7363400003 37.8024776288704 -122.423620966152 (37.8024776288704, -122.423620966152)
2147 252908 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 600 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879)
2666 253103 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 3000x Irving St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427.0 2106455.0 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734)
2897 253249 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 570 Jessie St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.1376799997 37.7809123781536 -122.40995800293301 (37.7809123781536, -122.409958002933)
3179 253343 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 200 Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6 Permit Number 778434 5995550.1802199995 2114806.2223 37.786598594028504 -122.459184390305 (37.7865985940285, -122.459184390305)
3307 192596 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1335 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/27/2015 12:00:00 AM 3 Width 4ft Permit Number 770747 6008295.90964 2110693.56586 37.776030729971794 -122.41479596277901 (37.7760307299718, -122.414795962779)
3316 253394 Planning Code 138.1 required 4 Ulmus parvifolia :: Chinese Elm 46 115 Steuart St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3511 247940 Planning Code 138.1 required 4 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 29 Joy St 3 Unaccepted Street : Yard 14 Tree 1 DPW 2     5   Permit Number 775404 6010280.31746 2098909.2881400003 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782)
3526 201695 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 342 08th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009961.08769 2109918.5710299998 37.773996196412604 -122.40898095270398 (37.7739961964126, -122.408980952704)
3538 253485 Planning Code 138.1 required 4 Trachycarpus fortunei :: Windmill Palm 31 1x Gordon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763.0 2109812.0 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953)
3575 201690 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 324 08th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009863.47645 2110020.43216 37.7742704149776 -122.409325797764 (37.7742704149776, -122.409325797764)
3584 253477 Planning Code 138.1 required 4 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1222 Harrison St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984.0 2109753.0 37.7735428603255 -122.40889001076201 (37.7735428603255, -122.408890010762)
3691 152812 Planning Code 138.1 required 4 Pittosporum undulatum :: Victorian Box 26 2901 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.751181646126795 -122.40825175271401 (37.7511816461268, -122.408251752714)
4404 239458 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 165 Sussex St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   10/11/2017 12:00:00 AM 3 Width 3ft Permit Number 780743 6001977.4736 2096494.97635 37.7366877772239 -122.435637038029 (37.7366877772239, -122.435637038029)
4888 151878 Planning Code 138.1 required 4 Eriobotrya deflexa :: Bronze Loquat 49 1450 15th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007623.77597 2107385.0882099997 37.7669086438472 -122.41688659964599 (37.7669086438472, -122.416886599646)
4889 253706 Planning Code 138.1 required 4 Eriobotrya deflexa :: Bronze Loquat 49 98X Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137          
4970 253749 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 2x Rhode Island St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5010 253737 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/03/2017 12:00:00 AM 3 3x6   6011517.0 2108140.0 37.769199681039794 -122.403473604048 (37.7691996810398, -122.403473604048)
5205 243371 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1 Hill St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006273.4727300005 2103450.37091 37.7560287860041 -122.42127764924 (37.7560287860041, -122.42127764924)
6989 115533 Planning Code 138.1 required 4 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 100X Hayes St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452)
7243 116776 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 1106 Pacific Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/28/2016 12:00:00 AM 3 3x3   6008776.88904 2117992.21481 37.7960980717264 -122.41364847189399 (37.7960980717264, -122.413648471894)
7304 117114 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 1650 Broadway 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005648.88243 2117910.88116 37.7956986045686 -122.42446621984399 (37.7956986045686, -122.424466219844)
7909 115530 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 101 Polk St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007332.44961 2111311.79762 37.7776740647351 -122.418172674243 (37.7776740647351, -122.418172674243)
9630 72480 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 42X Colin P Kelly Jr St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9719 173651 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 80 Entrada Ct 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
9765 122594 Planning Code 138.1 required 4 Pyrus calleryana :: Ornamental Pear 9 72 Townsend St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480.0 2112413.0 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941)
9770 151746 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 3030 17th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008502.962040001 2106251.6003 37.763845762487 -122.413765441348 (37.763845762487, -122.413765441348)
13336 187675 Planning Code 138.1 required 4 Olea europaea :: Olive Tree 41 2690 Harrison St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657)
13838 15248 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007914.867219999 2110337.26914 37.7750310067149 -122.41608885424 (37.7750310067149, -122.41608885424)
14706 117455 Planning Code 138.1 required 4 Tristaniopsis laurina :: Swamp Myrtle 37 236 Shipley St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3 Permit Number 776408 6011503.45491 2111758.7875900003 37.7791352841027 -122.403775126323 (37.7791352841027, -122.403775126323)
15102 115350 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 399 Fremont St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014880.23802 2114582.9179 37.7870777663613 -122.39229093398599 (37.7870777663613, -122.392290933986)
22936 104688 Planning Code 138.1 required 4 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 2655 Bush St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746)
76409 113646 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947.0 2110424.0 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901)
81719 112974 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 4099x ULLOA ST 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   10/20/2015 12:00:00 AM   3x3 Permit Number 773327 5983385.0 2098079.0 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652)
85844 44010 Planning Code 138.1 required 4 Jacaranda mimosifolia :: Jacaranda 52 405x Florida St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.41044985886299 (37.7642662704227, -122.410449858863)
86819 15237 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008256.52807 2110680.03106 37.7759913537931 -122.414931236282 (37.7759913537931, -122.414931236282)
88619 107647 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.765380001 2115716.99395 37.789681792424105 -122.42387802240101 (37.7896817924241, -122.423878022401)
97156 115962 Planning Code 138.1 required 4 Magnolia grandiflora :: Southern Magnolia 21 209 Grattan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/04/2016 12:00:00 AM 3 3x3   5997642.1 2106419.3 37.7636903209387 -122.451341781368 (37.7636903209387, -122.451341781368)
101006 122699 Planning Code 138.1 required 4 Ginkgo biloba :: Maidenhair Tree 44 98 Woolsey St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/16/2016 12:00:00 AM 3 3x3   6011441.9927199995 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524)
101224 121527 Planning Code 138.1 required 4 Tilia cordata :: Littleleaf Linden 208 333 Beale St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x10   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
106586 121542 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 318 Main St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       8x15   6015095.0 2115307.0 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205)
109208 118376 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 340 Fremont St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x6   6014683.0 2114666.0 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362)
110233 43569 Planning Code 138.1 required 4 Ginkgo biloba :: Maidenhair Tree 44 601 29TH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2000 12:00:00 AM   3x3 Permit Number 43230 6002630.6 2098839.9 37.743163470374895 -122.43354642924999 (37.7431634703749, -122.43354642925)
112639 64697 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1X Hill St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/04/2016 12:00:00 AM 3 3x3 Permit Number 778691 6006319.44787647 2103419.18592492 37.7559457511246 -122.421116437378 (37.7559457511246, -122.421116437378)
113628 116851 Planning Code 138.1 required 4 Olea europaea :: Olive Tree 41 83 Panorama Dr 3 Front Yard : Yard 7 Tree 1 Private 1   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054)
120364 115538 Planning Code 138.1 required 4 Crataegus laevigata :: English Hawthorn 66 99X Lech Walesa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.502280001 2111387.72892 37.7778703965252 -122.41892509804701 (37.7778703965252, -122.418925098047)
120641 115504 Planning Code 138.1 required 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 2901 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.751172725188106 -122.408119020981 (37.7511727251881, -122.408119020981)
124502 113651 Planning Code 138.1 required 4 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 98X 10TH ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x6 Permit Number 773574 6007947.0 2110424.0 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901)
125829 119287 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 400 Grove St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/28/2016 12:00:00 AM 3 4x4   6005873.0 2111410.0 37.777861449140204 -122.423228396467 (37.7778614491402, -122.423228396467)
126990 115495 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 1199X OCEAN AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2016 12:00:00 AM 3 3x3 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
127734 113338 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2X STANFORD ST 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727.0 2112481.0 37.781297869167396 -122.392674013487 (37.7812978691674, -122.392674013487)
129261 115492 Planning Code 138.1 required 4 Washingtonia robusta :: Mexican Fan Palm 75 280 BRIGHTON AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/10/2016 12:00:00 AM 3 4x12 Permit Number 777362 5996259.0 2091739.0 37.7233025441304 -122.455064598389 (37.7233025441304, -122.455064598389)
138808 121536 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x6   6015114.0 2115064.0 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663)
140623 117481 Planning Code 138.1 required 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 191 601 PACHECO ST 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x9   5993107.0 2101833.0 37.7508368102529 -122.46669375398199 (37.7508368102529, -122.466693753982)
145478 121524 Planning Code 138.1 required 4 Tilia cordata :: Littleleaf Linden 208 280 Beale St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x10   6014751.0 2115177.0 37.788701802156204 -122.392779649259 (37.7887018021562, -122.392779649259)
151629 116966 Planning Code 138.1 required 4 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 480 Potrero Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6010311.678719999 2106089.82191 37.7635029625087 -122.407498202703 (37.7635029625087, -122.407498202703)
151686 121503 Planning Code 138.1 required 4 Acer rubrum :: Red Maple 6 299 Fremont St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.39394375569401 (37.7884053276005, -122.393943755694)
157784 113241 Planning Code 138.1 required 4 Platanus x hispanica :: Sycamore: London Plane 15 329 Brannan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/10/2015 12:00:00 AM 3 3x4 Permit Number 770912 6014742.36618 2112476.99378 37.7812877223957 -122.39262057328999 (37.7812877223957, -122.39262057329)
165797 121508 Planning Code 138.1 required 4 Magnolia grandiflora :: Southern Magnolia 21 300 Folsom St 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1     6 3x3   6012258.9126 2112729.3972 37.78184252759429 -122.401229897449 (37.7818425275943, -122.401229897449)
166306 109458 Planning Code 138.1 required 4 Koelreuteria bipinnata :: Chinese Flame Tree 283 360 Berry St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 4x4 Permit Number 773752 6013450.121119999 2109506.07563 37.7730584040491 -122.396882784219 (37.7730584040491, -122.396882784219)
172623 115978 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721001 (37.7228154963084, -122.40191601721)
179588 115097 Planning Code 138.1 required 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 537 Natoma St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010133.894719999 2111910.59383 37.779475503918 -122.408523727481 (37.779475503918, -122.408523727481)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 83.304ms · Data source: data.sfgov.org