trees

274 rows where Supervisor Districts = 9 and qLegalStatus_id = 2 sorted by YCoord

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor 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)
124352 255410 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 6 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
130074 255415 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
139116 255407 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
149074 255412 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
164769 255405 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
165740 255404 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 150 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
167550 255408 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
178102 255413 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 9 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
179705 255411 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 199x Hayes St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2018 12:00:00 AM 3 3x3   6006976 2111107 37.7770916699959 -122.419391225109 (37.7770916699959, -122.419391225109) 7 9 9 28852 36
93518 115534 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 4 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007259.83389 2111260.26588 37.7775284833993 -122.418420222514 (37.7775284833993, -122.418420222514) 7 9 9 28852 36
184734 115535 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 5 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007237.56945 2111260.60051 37.7775281488378 -122.418497266559 (37.7775281488378, -122.418497266559) 7 9 9 28852 36
115681 115533 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 3 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007275.38703 2111262.82601 37.7775363884346 -122.418366600452 (37.7775363884346, -122.418366600452) 7 9 9 28852 36
34272 115532 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 2 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007293.46404 2111265.83422 37.7775456658356 -122.418304279225 (37.7775456658356, -122.418304279225) 7 9 9 28852 36
168962 115531 Planning Code 138.1 required 2 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 100X Hayes St 1 Sidewalk: Curb side : Pot Tree Private 2   02/08/2016 12:00:00 AM 3   Permit Number 770842 6007312.73746 2111269.98589 37.7775581502144 -122.41823790028 (37.7775581502144, -122.41823790028) 7 9 9 28852 36
57131 192563 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.7776687794229 -122.413273679445 (37.7776687794229, -122.413273679445) 8 2 9 28853 34
39373 251291 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
115603 251289 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
158927 251290 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
169960 192564 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
167439 115530 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 101 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007332.44961 2111311.79762 37.7776740647351 -122.418172674243 (37.7776740647351, -122.418172674243) 7 9 9 28852 36
135842 115529 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 101 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007327.31765 2111347.52577 37.777771876795 -122.418192961161 (37.777771876795, -122.418192961161) 7 9 9 28852 36
171393 115528 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 101 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007325.8351 2111377.63368 37.7778544624367 -122.418200224953 (37.7778544624367, -122.418200224953) 7 9 9 28852 36
12720 115537 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
40425 115540 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x5 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
75364 115539 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
164265 115538 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
185440 115536 Planning Code 138.1 required 2 Crataegus laevigata :: English Hawthorn 133 99X Lech Walesa St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/08/2016 12:00:00 AM 3 3x10 Permit Number 770842 6007116.50228 2111387.72892 37.7778703965252 -122.418925098047 (37.7778703965252, -122.418925098047) 7 9 9 28852 36
47139 257910 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
121157 257909 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
193393 257908 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20
176162 121550 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009252.51421 2111618.01515 37.7786227523886 -122.411552131552 (37.7786227523886, -122.411552131552) 8 2 9 28853 34
168133 121551 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1125 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/23/2017 12:00:00 AM 3 3x3 Permit Number 778243 6009293.51408 2111653.12836 37.7787214646499 -122.411412777974 (37.7787214646499, -122.411412777974) 8 2 9 28853 34
84600 117455 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 Shipley St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011503.45491 2111758.78759 37.7791352841027 -122.403775126323 (37.7791352841027, -122.403775126323) 14 2 9 28856 34
52945 117454 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 236 Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2016 12:00:00 AM 3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
123746 117456 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 SHIPLEY ST 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
160441 117453 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011539.59396 2111788.0027 37.779217520823 -122.403652162024 (37.779217520823, -122.403652162024) 14 2 9 28856 34
96128 73589 Planning Code 138.1 required 2 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 468 Clementina St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1995 12:00:00 AM 12 3x3 Permit Number 770905 6010928.13640467 2111848.51157587 37.7793494887795 -122.405771720076 (37.7793494887795, -122.405771720076) 14 2 9 28853 34
16780 85805 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627 2111882 37.7794804977568 -122.403356401218 (37.7794804977568, -122.403356401218) 14 2 9 28856 34
88090 85806 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627 2111882 37.7794804977568 -122.403356401218 (37.7794804977568, -122.403356401218) 14 2 9 28856 34
98758 101942 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010108.29372 2111885.47528 37.7794051005107 -122.408610520167 (37.7794051005107, -122.408610520167) 14 2 9 28853 34
122740 115096 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010119.08101 2111896.4319 37.7794357889593 -122.408573975335 (37.7794357889593, -122.408573975335) 14 2 9 28853 34
728 102430 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 200 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.7794962351107 -122.407028471514 (37.7794962351107, -122.407028471514) 14 2 9 28853 34
183224 115097 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010133.89472 2111910.59383 37.779475503918 -122.408523727481 (37.779475503918, -122.408523727481) 14 2 9 28853 34
128069 104819 Planning Code 138.1 required 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 468 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3X3 Permit Number 770905 6011018.41682 2111922.08536 37.7795565535331 -122.405464583724 (37.7795565535331, -122.405464583724) 14 2 9 28853 34
14666 102429 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 200 06th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010552.49087 2111923.99595 37.7795357369219 -122.407076563634 (37.7795357369219, -122.407076563634) 14 2 9 28853 34
128513 199503 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1009 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010500.98308 2111924.50305 37.7795342467397 -122.407254787701 (37.7795342467397, -122.407254787701) 14 2 9 28853 34
57149 115098 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010148.06204 2111925.42664 37.7795170247346 -122.408475763058 (37.7795170247346, -122.408475763058) 14 2 9 28853 34
132587 199504 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 1009 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 Width 3ft Permit Number 770993 6010510.13491 2111932.18806 37.7795558601644 -122.407223669342 (37.7795558601644, -122.407223669342) 14 2 9 28853 34
35619 85803 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 923 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806 (37.779617893816, -122.40405196806) 14 2 9 28856 34
126119 85804 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 923 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011441.4589 2111949.4191 37.7796552503769 -122.404003016031 (37.7796552503769, -122.404003016031) 14 2 9 28856 34
17501 251213 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
34271 251211 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
91455 85807 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
124736 251212 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
102133 113329 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 329 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 3 3x3 Permit Number 770912 6014656.6559 2112395.64308 37.7810595913673 -122.392911397837 (37.7810595913673, -122.392911397837) 6 2 9 28856 6
1962 122597 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
19209 122592 Planning Code 138.1 required 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 72 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
27168 75842 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
34241 122599 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
60760 122593 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 72 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
72432 122594 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 72 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
100384 122598 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
111086 122596 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
118733 72480 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
180599 75872 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
95774 105277 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 64 Townsend St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015510.23316 2112419.28649 37.7811718861147 -122.38996007562 (37.7811718861147, -122.38996007562) 6 2 9 28856 6
29570 105276 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 64 Townsend St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015520.22928 2112423.42174 37.7811837949483 -122.389925782657 (37.7811837949483, -122.389925782657) 6 2 9 28856 6
104520 105275 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 64 Townsend St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015531.53579 2112438.89481 37.7812269075454 -122.389887748547 (37.7812269075454, -122.389887748547) 6 2 9 28856 6
57241 253248 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
79696 253247 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
187618 253249 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
93218 113240 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 329 Brannan St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 2 3x4 Permit Number 770912 6014728.70394 2112464.72966 37.7812532891345 -122.392666980121 (37.7812532891345, -122.392666980121) 6 2 9 28856 6
134726 113241 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 329 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 3 3x4 Permit Number 770912 6014742.36618 2112476.99378 37.7812877223957 -122.39262057329 (37.7812877223957, -122.39262057329) 6 2 9 28856 6
36960 113338 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
125850 113335 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 1 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
160249 113337 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
94254 121506 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 1 Sidewalk: Property side : Cutout Tree Private 2     11 3x3   6012227.3168 2112699.1751 37.7817577819585 -122.401337080379 (37.7817577819585, -122.401337080379) 6 2 9 28856 34
178528 121507 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6012241.512 2112714.7441 37.7818013227969 -122.401289065763 (37.7818013227969, -122.401289065763) 6 2 9 28856 34
160922 121508 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 3 Sidewalk: Property side : Cutout Tree Private 2     6 3x3   6012258.9126 2112729.3972 37.7818425275943 -122.401229897449 (37.7818425275943, -122.401229897449) 6 2 9 28856 34
81347 117017 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008130.7573 2112963.51283 37.7822541806174 -122.415528017206 (37.7822541806174, -122.415528017206) 7 10 9 28852 36
77658 94315 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 399X Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008122 2112982 37.7823044496932 -122.415559622955 (37.7823044496932, -122.415559622955) 7 10 9 28852 36
17276 72565 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     3 4x4 Permit Number 770847 6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
177060 116640 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 2 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
97662 117018 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008125.66458 2112987.05621 37.7823185388132 -122.415547303188 (37.7823185388132, -122.415547303188) 7 10 9 28852 36
14869 117019 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.415562303882 (37.782365960952, -122.415562303882) 7 10 9 28852 36
61797 117020 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008118.25915 2113018.66588 37.7824049150971 -122.415575161466 (37.7824049150971, -122.415575161466) 7 10 9 28852 36
68035 117021 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008114.19003 2113031.70239 37.7824404814865 -122.415590162171 (37.7824404814865, -122.415590162171) 7 10 9 28852 36
136714 65940 Planning Code 138.1 required 2 Liquidambar styraciflua :: American Sweet Gum 37 620 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.7833233693217 -122.417975883707 (37.7833233693217, -122.417975883707) 7 9 9 28858 36
3797 260871 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
11471 260869 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
13730 260870 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
18437 260868 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
9750 169122 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009478.56357 2113738.5186 37.7844578281201 -122.410919945006 (37.7844578281201, -122.410919945006) 14 10 9 28852 36
5118 169123 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009469.52117 2113800.26568 37.7846268637924 -122.410955591431 (37.7846268637924, -122.410955591431) 14 10 9 28852 36
1080 169338 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
16066 260290 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1029 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/15/2019 12:00:00 AM 3 Width 4ft   6006781.41851 2114264.09095 37.7857493130165 -122.420288474132 (37.7857493130165, -122.420288474132) 13 9 9 28858 36
30147 115348 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014915.48611 2114547.78532 37.7869832575075 -122.39216652446 (37.7869832575075, -122.39216652446) 6 2 9 28855 6
152753 115349 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014896.08459 2114567.05321 37.7870350854597 -122.392234997951 (37.7870350854597, -122.392234997951) 6 2 9 28855 6
101037 115350 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014880.23802 2114582.9179 37.7870777663613 -122.392290933986 (37.7870777663613, -122.392290933986) 6 2 9 28855 6
153202 115351 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014858.41874 2114606.67601 37.7871417890985 -122.392368086818 (37.7871417890985, -122.392368086818) 6 2 9 28855 6

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