trees

202 rows where qLegalStatus_id = 6 and qSiteInfo = "Sidewalk: Property side : Yard" sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: qSiteInfo

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)
1051 251262 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
8535 251265 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
14241 251264 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
15795 251263 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 779147                    
42183 110954 Significant Tree 6 Pinus radiata :: Monterey Pine 15 126X Mendell St 1 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6017060.74507 2098543.22184 37.7431570265693 -122.383629676533 (37.7431570265693, -122.383629676533) 10 3 8 58 1
133009 110951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 1 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
141742 110952 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 8 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
146688 110953 Significant Tree 6 Pinus radiata :: Monterey Pine 15 220 Newhall St 10 Sidewalk: Property side : Yard Tree Private 2   05/12/2015 12:00:00 AM 3     6016803.8 2098347.9 37.7426065069695 -122.384504531053 (37.7426065069695, -122.384504531053) 10 3 8 58 1
17656 261984 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 1557 Bancroft Ave 4 Sidewalk: Property side : Yard Tree DPW 1           6014517 2091967 37.7249591332222 -122.391965574806 (37.7249591332222, -122.391965574806) 10 3 8 58 1
17557 261982 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 2403 Keith St 3 Sidewalk: Property side : Yard Tree DPW 1           6014456 2092405 37.7261584067484 -122.392207065149 (37.7261584067484, -122.392207065149) 10 3 8 58 1
68704 173596 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 300 Howard St 1 Sidewalk: Property side : Yard Tree Private 2       3x3 Permit Number 779179 6014439 2115766 37.7903017260092 -122.393900378517 (37.7903017260092, -122.393900378517) 12 2 9 28855 6
23612 253210 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 567 Mississippi St 1 Sidewalk: Property side : Yard Tree Private 2   05/02/2019 12:00:00 AM 3 3x3   6014163 2104519 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073) 10 3 8 28856 29
135623 258062 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 567 Mississippi St 2 Sidewalk: Property side : Yard Tree Private 2   05/02/2019 12:00:00 AM 3 3x3   6014163 2104519 37.7594046471392 -122.394067636073 (37.7594046471392, -122.394067636073) 10 3 8 28856 29
2321 48402 Significant Tree 6 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree Private 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
81334 106255 Significant Tree 6 Tree(s) :: 17 1900X 18th St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770844 6012067 2105610 37.7622835736204 -122.401393347502 (37.7622835736204, -122.401393347502) 8 3 8 28856 29
684 260585 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
4938 260583 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6111 260586 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
6121 260584 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 397 05th St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
9510 260587 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 890x Harrison St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
101661 257928 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 101 Lombard St 12 Sidewalk: Property side : Yard Tree Private 2       Width 6ft   6011760.21977 2120791.0173 37.8039499778675 -122.403522505873 (37.8039499778675, -122.403522505873) 3 1 10 28860 6
194330 265002 Significant Tree 6 :: Tree 573 1445 San Bruno Ave 1 Sidewalk: Property side : Yard Tree Private 2       5x5   6011217 2101257 37.7502837374969 -122.404026841996 (37.7502837374969, -122.404026841996) 10 4 8 28859 19
1467 259815 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 9 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3205 259817 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
3287 259814 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 8 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6413 259813 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 7 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
6612 259812 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 6 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
7698 259819 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 13 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
9200 259821 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 15 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
12030 259810 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13096 259808 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13203 259818 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 12 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
13753 259809 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14819 259822 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 16 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14961 259823 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 17 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16309 259807 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
16536 259816 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 10 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
18661 259820 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 14 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
18707 259811 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 850x Bryant St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6011306 2110409 37.7754180474052 -122.404363174614 (37.7754180474052, -122.404363174614) 14 2 9 28853 34
14736 92056 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree Private 2   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
161427 92055 Significant Tree 6 Quercus agrifolia :: Coast Live Oak 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
158154 258096 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 941 Mission St 4 Sidewalk: Property side : Yard Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6010493.2294 2112796.27211 37.7819274857178 -122.407343084927 (37.7819274857178, -122.407343084927) 14 2 9 28853 34
7930 223763 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 3ft   6009530.79254 2097866.09723 37.7408787078943 -122.409618578334 (37.7408787078943, -122.409618578334) 10 7 7 28859 2
4813 223765 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6009530.59471 2097856.4038 37.7408520807582 -122.409618578357 (37.7408520807582, -122.409618578357) 10 7 7 28859 2
3385 223764 Significant Tree 6 Juniperus chinensis :: Juniper 113 126 Bradford St 2 Sidewalk: Property side : Yard Tree Private 2     12 Width 3ft   6009530.67949 2097860.55808 37.7408634922583 -122.409618578359 (37.7408634922583, -122.409618578359) 10 7 7 28859 2
4164 260061 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 8 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
8078 260059 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 6 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
9215 260060 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
18171 260058 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 100 Larkin St 5 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   6007818.52804 2111871.98583 37.7792395550969 -122.416530850318 (37.7792395550969, -122.416530850318) 7 9 9 28852 36
33161 254729 Significant Tree 6 Cryptomeria japonica :: Japanese Cryptomeria 420 1940 Mission St 6 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
151585 254728 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1940 Mission St 5 Sidewalk: Property side : Yard Tree Private 2       Width 0ft   6006763.6807 2106952.0622 37.7656712394659 -122.419830807079 (37.7656712394659, -122.419830807079) 8 4 7 28853 19
52809 224289 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 166 San Carlos St 1 Sidewalk: Property side : Yard Tree Private 2     18 Width 3ft   6006647.34642 2105145.25174 37.7607036068074 -122.420104944992 (37.7607036068074, -122.420104944992) 2 4 7 28859 19
33143 116090 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
54660 116089 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
96610 116088 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
122222 116087 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 98x WOODWARD ST 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006422 2107919 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108) 8 4 7 28853 19
36041 255248 Significant Tree 6 Maytenus boaria :: Mayten 58 209x Willow St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
85142 255249 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 209x Willow St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
117546 255247 Significant Tree 6 Maytenus boaria :: Mayten 58 209x Willow St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
139171 255246 Significant Tree 6 Maytenus boaria :: Mayten 58 209x Willow St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
177763 255250 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 209x Willow St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
27012 255276 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 6 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
126646 255275 Significant Tree 6 Maytenus boaria :: Mayten 58 263 Willow St 5 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   6006404.75096 2113360.62408 37.7832473828943 -122.421527451234 (37.7832473828943, -122.421527451234) 7 9 11 28858 41
69 126274 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1240 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     24 Width 6ft   6006421.51674 2120105.21307 37.8017672864012 -122.421948716173 (37.8017672864012, -122.421948716173) 5 9 1 28858 32
157383 110560 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 2 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
157916 110559 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 320x FULTON ST 1 Sidewalk: Property side : Yard Tree Private 2       10x36   6006080 2112015 37.7795343118474 -122.422555311635 (37.7795343118474, -122.422555311635) 7 9 11 28852 10
182332 258021 Significant Tree 6 Tree(s) :: 17 201x Gough St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6006013 2110374 37.7750247439455 -122.422670446803 (37.7750247439455, -122.422670446803) 7 9 11 28852 10
124108 258218 Significant Tree 6 Olea europaea :: Olive Tree 9 1000 North Point St 1 Sidewalk: Property side : Yard Tree Private 2           6005937.91741 2121414.48699 37.8053349315385 -122.423715341013 (37.8053349315385, -122.423715341013) 5 1 1 28858 32
6691 256248 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
48610 256247 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
94582 256246 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 199x Clinton Park 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
88383 103615 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 5 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
110134 103612 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 2 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
144064 103614 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 4 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
172262 103613 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 3 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
182906 103611 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 200X Buchanan St 1 Sidewalk: Property side : Yard Tree Private 2           6004748.9 2109266.8 37.7719132424086 -122.426964371637 (37.7719132424086, -122.426964371637) 7 9 5 28852 10
60900 103616 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 201X Haight St 1 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
75842 103617 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 2 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
95437 103618 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 201X Haight St 3 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
17242 253971 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 4 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
108843 253969 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
139296 253970 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 3 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
159837 253968 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1401X Laguna St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   6004485 2113711 37.784100995896 -122.428194001884 (37.784100995896, -122.428194001884) 13 9 11 29490 41
34658 104715 Significant Tree 6 Juniperus chinensis :: Juniper 113 3618 22nd St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
103792 104717 Significant Tree 6 Juniperus chinensis :: Juniper 113 3618 22nd St 3 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
138982 104716 Significant Tree 6 Juniperus chinensis :: Juniper 113 3618 22nd St 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 770676 6004228.3 2103103.8 37.7549616692716 -122.428325838726 (37.7549616692716, -122.428325838726) 2 4 5 28862 22
16372 96327 Significant Tree 6 Cordyline australis :: Dracena Palm 64 296 Randall St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
162530 96328 Significant Tree 6 Cordyline australis :: Dracena Palm 64 296 Randall St 2 Sidewalk: Property side : Yard Tree Private 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
166311 127110 Significant Tree 6 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 3201 Laguna St 1 Sidewalk: Property side : Yard Tree Private 2     23 Width 6ft   6003718.35126 2119752.0994 37.8006449063974 -122.431277695812 (37.8006449063974, -122.431277695812) 13 9 1 57 17
189569 252838 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 99 Pond St 1 Sidewalk: Property side : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
5239 112929 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
23199 112923 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
53110 112918 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
56286 112919 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
65651 112922 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
74096 112921 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
77157 112924 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2X Noe St   Sidewalk: Property side : Yard Tree Private 2           6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
106523 112930 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
148103 112925 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3
166722 112928 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 2X Noe St   Sidewalk: Property side : Yard Tree Private 2   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.433490232023 (37.7683199626551, -122.433490232023) 15 5 5 28862 3

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