trees

8,298 rows where qLegalStatus_id = 4 sorted by Police Districts descending

✎ 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)
65 264979 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 1 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
116 113159 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
149 244279 Undocumented 4 :: 45 585 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6004230.7823 2110095.842 37.7741602789386 -122.428815691218 (37.7741602789386, -122.428815691218) 7 9 11 28852 10
412 121036 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1830 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006566 2117108 37.7935458417616 -122.421235781398 (37.7935458417616, -122.421235781398) 13 9 10 28858 32
479 122586 Undocumented 4 Prunus spp :: Cherry 68 2500X Lyon St 6 Median : Cutout Tree Private 2     12 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
563 100819 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2430X Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6002728 2116798 37.7924775418689 -122.434493377265 (37.7924775418689, -122.434493377265) 13 9 1 29490 27
1199 116255 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
1436 256792 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 120 Cedar St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006815 2114489 37.7863687502832 -122.420188259313 (37.7863687502832, -122.420188259313) 13 9 10 28858 36
1551 260493 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1799 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006327 2116970 37.7931534514646 -122.422052933674 (37.7931534514646, -122.422052933674) 13 9 10 28858 32
1667 101664 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
1730 121323 Undocumented 4 Tree(s) :: 17 3699X Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
2062 112894 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1x WEBSTER ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
2553 140071 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
2733 107738 Undocumented 4 Tree(s) :: 17 155x HAYES ST 4 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2016 12:00:00 AM 3 3x3 Permit Number 774227 6007127.8 2111172.9 37.7772811641179 -122.41887077508 (37.7772811641179, -122.41887077508) 7 9 9 28852 36
4013 264857 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 800x Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007181 2113695 37.7842092359088 -122.41886565636 (37.7842092359088, -122.41886565636) 7 9 9 28858 36
4227 109316 Undocumented 4 Trachycarpus fortunei :: Windmill Palm 116 1516 BROADWAY 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006331.3 2118082.2 37.7962075161748 -122.422117105361 (37.7962075161748, -122.422117105361) 13 9 10 28858 32
4438 254757 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2450 California St 13 Front Yard : Yard Tree MTA 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
4754 101985 Undocumented 4 Tree(s) :: 17 205X Rose St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10
4853 107519 Undocumented 4 Tree(s) :: 17 100x CHURCH ST   Sidewalk: Curb side : Cutout Tree Private 2           6004015.5 2108290.9 37.7691921614924 -122.429431648714 (37.7691921614924, -122.429431648714) 7 9 5 28862 3
5054 102983 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 555 Turk St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
5491 125353 Undocumented 4 Acer palmatum :: Japanese Maple 216 2083 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6003071.4644 2118540.95305 37.7972827324699 -122.43342959001 (37.7972827324699, -122.43342959001) 13 9 1 57 17
5583 244247 Undocumented 4 :: 45 200 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005673.0642 2110022.689 37.7740409443959 -122.423821374378 (37.7740409443959, -122.423821374378) 7 9 11 28852 10
5731 261315 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 198 Austin St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006408 2115479 37.789064104593 -122.421666719739 (37.789064104593, -122.421666719739) 13 9 10 28858 21
5972 136242 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1679 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006678.63942 2116999.88567 37.7932553363267 -122.420838360099 (37.7932553363267, -122.420838360099) 13 9 10 28858 32
6007 261051 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
6342 264855 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 800x Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007181 2113695 37.7842092359088 -122.41886565636 (37.7842092359088, -122.41886565636) 7 9 9 28858 36
6838 256837 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1201x Franklin St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
7141 264858 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 800x Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007181 2113695 37.7842092359088 -122.41886565636 (37.7842092359088, -122.41886565636) 7 9 9 28858 36
7197 116162 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2569 GREENWICH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000631 2118874 37.7980584318084 -122.441898109379 (37.7980584318084, -122.441898109379) 13 9 1 57 17
7464 224445 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 20 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6003875.0564 2108571.54256 37.7699547852142 -122.429937456853 (37.7699547852142, -122.429937456853) 7 9 5 29492 10
7675 260491 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1799 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006327 2116970 37.7931534514646 -122.422052933674 (37.7931534514646, -122.422052933674) 13 9 10 28858 32
7782 101433 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2501X Buchanan St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
8876 136239 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1679 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006621.33402 2116991.57937 37.7932292991375 -122.4210360509 (37.7932292991375, -122.4210360509) 13 9 10 28858 32
8895 260492 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1799 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006327 2116970 37.7931534514646 -122.422052933674 (37.7931534514646, -122.422052933674) 13 9 10 28858 32
9428 261317 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 198 Austin St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006408 2115479 37.789064104593 -122.421666719739 (37.789064104593, -122.421666719739) 13 9 10 28858 21
9528 260488 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1868 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006172 2116875 37.7928838619922 -122.422582490215 (37.7928838619922, -122.422582490215) 13 9 10 28858 32
9658 114582 Undocumented 4 Myoporum laetum :: Myoporum 62 1501 BEACH ST 4 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6002979 2121285 37.8048119223389 -122.43394578499 (37.8048119223389, -122.43394578499) 13 9 1 57 17
9678 257993 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1299x Laguna St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004575 2113275 37.7829089401984 -122.427851556708 (37.7829089401984, -122.427851556708) 7 9 11 29490 41
9864 102975 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 555 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
10487 260490 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1799 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006327 2116970 37.7931534514646 -122.422052933674 (37.7931534514646, -122.422052933674) 13 9 10 28858 32
10626 117236 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
10966 109166 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 51x OCTAVIA ST 5 Median : Cutout Tree DPW 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
11207 108105 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
11452 110549 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 7 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
11559 261050 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
11636 249410 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 698 Polk St 1 : Tree Private 2     17 Width 3ft   6007114.55441 2113257.76141 37.7830049436594 -122.419064511231 (37.7830049436594, -122.419064511231) 7 9 9 28852 36
11868 260487 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1868 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006172 2116875 37.7928838619922 -122.422582490215 (37.7928838619922, -122.422582490215) 13 9 10 28858 32
12000 261047 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 750 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
12499 101675 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 15 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41
12604 116259 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 7 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
13336 136240 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1679 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006640.65595 2116994.76492 37.7932391350289 -122.420969421921 (37.7932391350289, -122.420969421921) 13 9 10 28858 32
13431 260489 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1868 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2019 12:00:00 AM 3 3x3   6006172 2116875 37.7928838619922 -122.422582490215 (37.7928838619922, -122.422582490215) 13 9 10 28858 32
13440 264856 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 800x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007181 2113695 37.7842092359088 -122.41886565636 (37.7842092359088, -122.41886565636) 7 9 9 28858 36
13756 261045 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 750 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
14018 111009 Undocumented 4 Olea europaea :: Olive Tree 9 1801x WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003409 2114904 37.7873157334926 -122.432001790592 (37.7873157334926, -122.432001790592) 13 9 11 29490 27
14179 257990 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1299x Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004575 2113275 37.7829089401984 -122.427851556708 (37.7829089401984, -122.427851556708) 7 9 11 29490 41
14418 256780 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 2301 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006284 2118744 37.7980219841193 -122.422327817993 (37.7980219841193, -122.422327817993) 13 9 10 28858 32
14879 100801 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2447 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6002488 2116745 37.7923183909502 -122.435319990545 (37.7923183909502, -122.435319990545) 13 9 1 29490 27
15126 121049 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
15238 261049 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
15598 112413 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 469x IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005169 2110996 37.7766849510116 -122.425634307332 (37.7766849510116, -122.425634307332) 7 9 11 28852 10
15988 136243 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1679 Washington St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006695.60451 2117001.64443 37.7932611216587 -122.42077978457 (37.7932611216587, -122.42077978457) 13 9 10 28858 32
16013 108100 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 2390X Green St 2 Sidewalk: Curb side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
16042 256809 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
16378 261659 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 2401 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000878 2119196 37.7989566302666 -122.441066533327 (37.7989566302666, -122.441066533327) 13 9 1 57 17
16513 263639 Undocumented 4 Eucalyptus sideroxylon :: Red Ironbark 127 970 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003214 2110722 37.7758219527997 -122.432377649116 (37.7758219527997, -122.432377649116) 15 9 11 29492 10
16514 136241 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1679 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006661.22108 2116996.66069 37.7932454995431 -122.42089839975 (37.7932454995431, -122.42089839975) 13 9 10 28858 32
16602 257992 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1299x Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004575 2113275 37.7829089401984 -122.427851556708 (37.7829089401984, -122.427851556708) 7 9 11 29490 41
16787 105348 Undocumented 4 Photinia fraseri :: Photinia: Chinese photinia 166 651X Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6004248.77005 2110989.99433 37.7766164199227 -122.428817225763 (37.7766164199227, -122.428817225763) 7 9 11 28852 10
17203 107449 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1130x CHESTNUT ST 1 Unaccepted Street : Yard Tree Private 2     60     6006351.9 2120450.9 37.8027125282147 -122.422214196597 (37.8027125282147, -122.422214196597) 5 9 1 28858 32
17244 112890 Undocumented 4 Cornus nuttallii x florida 'Eddie's White Wonder' :: Eddie's White Wonder Dogwood 373 1X WEBSTER ST 1 Sidewalk: Property side : Yard Tree Private 2     4 3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
17663 101489 Undocumented 4 Ceratonia siliqua :: Carob 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233) 7 9 5 28852 10
17877 101023 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 3024 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999465 2119192 37.7988650643156 -122.445955676486 (37.7988650643156, -122.445955676486) 13 9 1 57 17
18163 140072 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
18428 261048 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
18974 101400 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2101X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
19086 261318 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 198 Austin St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006408 2115479 37.789064104593 -122.421666719739 (37.789064104593, -122.421666719739) 13 9 10 28858 21
19090 261316 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 198 Austin St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006408 2115479 37.789064104593 -122.421666719739 (37.789064104593, -122.421666719739) 13 9 10 28858 21
19662 102997 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2430X Jackson St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6002728 2116798 37.7924775418689 -122.434493377265 (37.7924775418689, -122.434493377265) 13 9 1 29490 27
19924 114954 Undocumented 4 Ficus Spp. :: 101 601x OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
19967 101427 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 2501X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003643.1 2116935.1 37.7929058867978 -122.431336896261 (37.7929058867978, -122.431336896261) 13 9 1 29490 27
20044 120894 Undocumented 4 Pittosporum spp :: Pittosporum spp 170 735 Marina Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999444 2121468 37.805113148598 -122.446192149022 (37.805113148598, -122.446192149022) 13 9 1 57 17
20378 116241 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
20571 95244 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2626 Larkin St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2010 12:00:00 AM 10 3x3 Permit Number 767140 6006627 2120193 37.802019913523 -122.421243885087 (37.802019913523, -122.421243885087) 5 9 1 28858 32
20799 108149 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 2232 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
20962 116910 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 351X HERMANN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6003606 2108630 37.7701000542623 -122.430872290016 (37.7701000542623, -122.430872290016) 15 9 5 29492 10
21018 110553 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 11 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
21264 256802 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
21279 122585 Undocumented 4 Sequoia sempervirens :: Coast Redwood 155 2500X Lyon St 5 Median : Cutout Tree Private 2     70 10x20   5999276 2117538 37.7943128273924 -122.446490617691 (37.7943128273924, -122.446490617691) 13 9 1 57 27
21498 98979 Undocumented 4 Ficus nitida :: Laurel Fig 53 38 MILEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778225 5999656 2118689 37.7974948649915 -122.4452585722 (37.7974948649915, -122.4452585722) 13 9 1 57 17
21499 102751 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2490X Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 5x6   6001093.5 2118310.7 37.7965381017858 -122.440257311894 (37.7965381017858, -122.440257311894) 13 9 1 57 17
21702 256807 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
22170 100293 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3725 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003057 2121128 37.8043852677309 -122.433664630457 (37.8043852677309, -122.433664630457) 13 9 1 57 17
22189 99108 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1642 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006878.8 2116741.3 37.7925566043485 -122.420127429765 (37.7925566043485, -122.420127429765) 13 9 10 28858 32
22280 121321 Undocumented 4 Tree(s) :: 17 3699X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003556 2121083 37.8042900105203 -122.431934584375 (37.8042900105203, -122.431934584375) 13 9 1 28858 17
23205 81367 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1001 Polk St 1 Sidewalk: Curb side : Pot Tree Private 2   11/08/2003 12:00:00 AM   3x3   6006914.85774282 2114314.60875621 37.7858955407321 -122.419830397182 (37.7858955407321, -122.419830397182) 13 9 9 28858 36
23325 101665 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Daniel Burnham Ct 5 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6006348.55699 2114768.54675 37.7871100236423 -122.421821900065 (37.7871100236423, -122.421821900065) 13 9 1 28858 41

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