trees

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

✎ 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)
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
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
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
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
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
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
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
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
25972 121523 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
80358 121522 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
194150 121524 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
35800 121504 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 4 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014396.4001 2115093.29031 37.7884522533286 -122.394000660325 (37.7884522533286, -122.394000660325) 6 2 9 28855 6
37189 121502 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 2 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549) 6 2 9 28855 6
40751 121505 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 5 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014377.50413 2115113.61118 37.7885069995398 -122.394067461056 (37.7885069995398, -122.394067461056) 6 2 9 28855 6
66507 121501 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 1 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014441.60375 2115047.86993 37.7883300516388 -122.393841081021 (37.7883300516388, -122.393841081021) 6 2 9 28855 6
120636 121503 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 3 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014412.49464 2115075.87435 37.7884053276005 -122.393943755694 (37.7884053276005, -122.393943755694) 6 2 9 28855 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
43149 121513 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
62167 121518 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 13 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
63982 121515 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
80342 121514 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
81393 121521 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 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
101009 121510 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
102091 121512 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
106371 121516 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 11 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
107276 121511 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
149769 121517 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
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
168121 121519 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
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
183412 121520 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 15 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
192715 121509 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
34491 187942 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 3 Sidewalk: Curb side : Yard Tree Private 2     3     6015080.74918 2115307.92538 37.7890796023783 -122.391647913344 (37.7890796023783, -122.391647913344) 6 2 9 28855 6
71462 187943 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6015093.73077 2115293.30797 37.7890401869059 -122.391601975949 (37.7890401869059, -122.391601975949) 6 2 9 28855 6
73578 187945 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 6 Sidewalk: Curb side : Yard Tree Private 2     3     6015129.76051 2115255.3706 37.7889380194338 -122.391474663423 (37.7889380194338, -122.391474663423) 6 2 9 28855 6
110801 187940 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6015048.62855 2115342.19505 37.7891719160015 -122.391761444649 (37.7891719160015, -122.391761444649) 6 2 9 28855 6
122606 187947 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 8 Sidewalk: Curb side : Yard Tree Private 2     3     6015161.72984 2115222.99296 37.7888508922136 -122.391361788631 (37.7888508922136, -122.391361788631) 6 2 9 28855 6
133882 187944 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6015109.7038 2115276.55289 37.7889950679055 -122.391545539018 (37.7889950679055, -122.391545539018) 6 2 9 28855 6
149325 187946 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6015145.56326 2115239.56325 37.7888954931699 -122.391418882079 (37.7888954931699, -122.391418882079) 6 2 9 28855 6
160771 187941 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6015065.49236 2115322.58848 37.7891190169896 -122.391701726057 (37.7891190169896, -122.391701726057) 6 2 9 28855 6
21732 121544 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 5 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
30239 121540 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
46657 121543 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 4 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
48226 121547 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 8 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
73712 121545 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 6 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
117838 121542 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
139844 121546 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 7 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
186332 121541 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
20988 201691 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009873.18605 2110010.6659 37.7742441430989 -122.40929152101 (37.7742441430989, -122.40929152101) 8 2 9 28853 34
21880 201692 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009893.13849 2109987.83278 37.7741825665069 -122.409220890035 (37.7741825665069, -122.409220890035) 8 2 9 28853 34
164004 201690 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009863.47645 2110020.43216 37.7742704149776 -122.409325797764 (37.7742704149776, -122.409325797764) 8 2 9 28853 34
175654 201688 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009806.99553 2110077.79875 37.7744247656342 -122.409525226004 (37.7744247656342, -122.409525226004) 8 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
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
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
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
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
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
20157 121528 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
40138 121526 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
52894 121531 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
100470 121527 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
103030 121533 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
103456 121525 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
152599 121532 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
170258 121530 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
184275 121529 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
5835 118375 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6
32270 118379 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
42633 118377 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
64723 118378 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
70059 118374 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 4x6   6014693.17098 2114681.80971 37.787338911495 -122.392945071183 (37.787338911495, -122.392945071183) 6 2 9 28855 6
75283 118380 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
132870 118376 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
27322 201695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009961.08769 2109918.57103 37.7739961964126 -122.408980952704 (37.7739961964126, -122.408980952704) 8 2 9 28853 34
74052 201694 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009941.3987 2109939.6045 37.7740528464887 -122.409050544971 (37.7740528464887, -122.409050544971) 8 2 9 28853 34
74410 201698 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010000.12901 2109874.7171 37.7738779706193 -122.408842806955 (37.7738779706193, -122.408842806955) 8 2 9 28853 34
85953 201697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009987.20299 2109888.7351 37.7739157367544 -122.408888509595 (37.7739157367544, -122.408888509595) 8 2 9 28853 34
107192 201696 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009973.11931 2109904.86997 37.773959250457 -122.408938366227 (37.773959250457, -122.408938366227) 8 2 9 28853 34
134197 201699 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6010014.86815 2109861.25987 37.7738418457656 -122.408790872027 (37.7738418457656, -122.408790872027) 8 2 9 28853 34
16206 109465 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 10 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013321.87847 2109385.26551 37.7727195476045 -122.397317921189 (37.7727195476045, -122.397317921189) 14 2 9 310 20
16815 109466 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013302.89282 2109368.02055 37.7726711397891 -122.397382385507 (37.7726711397891, -122.397382385507) 14 2 9 310 20
27368 109463 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013357.96458 2109418.68041 37.7728133064148 -122.397195438039 (37.7728133064148, -122.397195438039) 14 2 9 310 20
48798 109467 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 12 Sidewalk: Curb side : Cutout Tree Private 2     6 4x4 Permit Number 773752 6013285.76594 2109350.55221 37.7726222220803 -122.397440404346 (37.7726222220803, -122.397440404346) 14 2 9 310 20
84511 109468 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 13 Sidewalk: Curb side : Cutout Tree Private 2     7 4x4 Permit Number 773752 6013267.70036 2109332.73182 37.7725722854256 -122.397501645497 (37.7725722854256, -122.397501645497) 14 2 9 310 20
115539 109460 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 4x4 Permit Number 773752 6013412.32492 2109471.0252 37.7729600595772 -122.397011068921 (37.7729600595772, -122.397011068921) 14 2 9 310 20
126344 109462 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 773752 6013376.015 2109435.75899 37.7728612052211 -122.3971341969 (37.7728612052211, -122.3971341969) 14 2 9 310 20
127231 109459 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 773752 6013430.92674 2109487.72122 37.7730069385559 -122.396947893341 (37.7730069385559, -122.396947893341) 14 2 9 310 20
150292 109461 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 4x4 Permit Number 773752 6013397.07251 2109454.07559 37.7729126707161 -122.397062640549 (37.7729126707161, -122.397062640549) 14 2 9 310 20
152102 109458 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 4x4 Permit Number 773752 6013450.12112 2109506.07563 37.7730584040491 -122.396882784219 (37.7730584040491, -122.396882784219) 14 2 9 310 20
154592 109464 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013338.99753 2109402.36294 37.7727674463814 -122.39725990323 (37.7727674463814, -122.39725990323) 14 2 9 310 20
168906 109469 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013484.3589 2109540.27035 37.7731542007368 -122.3967667483 (37.7731542007368, -122.3967667483) 14 2 9 310 20
193110 109470 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.7731063019529 -122.396823476633 (37.7731063019529, -122.396823476633) 14 2 9 310 20

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