trees

150 rows where Police Districts = 4 and qLegalStatus_id = 6 sorted by qSiteInfo descending

✎ View and edit SQL

This data as json, CSV (advanced)

Police 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)
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
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
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
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
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
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
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
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
67906 223957 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6000715.72405 2104622.00656 37.7589309108477 -122.440582177927 (37.7589309108477, -122.440582177927) 2 4 5 28862 38
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
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
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
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
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
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
159982 102589 Significant Tree 6 Pinus radiata :: Monterey Pine 15 5157 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree Private 2     8     6000788.8 2100195.2 37.7467801300642 -122.440012028415 (37.7467801300642, -122.440012028415) 2 4 5 63 22
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
167295 223958 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 98 Seward St 2 Sidewalk: Property side : Yard Tree Private 2     13 Width 3ft   6000714.90104 2104629.88079 37.7589524846915 -122.440585589054 (37.7589524846915, -122.440585589054) 2 4 5 28862 38
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
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
3323 258079 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 606 Capp St 3 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6007262.82565 2103708.68672 37.7567937898158 -122.417874439265 (37.7567937898158, -122.417874439265) 2 4 7 28859 19
8316 260638 Significant Tree 6 Olea europaea :: Olive Tree 9 3140 25th St 2 Sidewalk: Property side : Cutout Tree Private 2     3 3x3   6008726.17419 2101580.94088 37.7510337250786 -122.412663209658 (37.7510337250786, -122.412663209658) 2 4 7 28859 19
45541 92053 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
52899 173663 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 3878 17th St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003109 2105964 37.7627516946294 -122.432400964417 (37.7627516946294, -122.432400964417) 15 4 5 28862 3
67165 258067 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 833 York St 1 Sidewalk: Property side : Cutout Tree Private 2       2x3 Permit Number 782335 6009933.30187 2104364.32189 37.758743943813 -122.408685158341 (37.758743943813, -122.408685158341) 2 4 7 28859 19
73609 252836 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 98 Prosper St 4 Sidewalk: Property side : Cutout Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
93094 106927 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 4150 24th St   Sidewalk: Property side : Cutout Tree Private 2       1.5X1.5 Permit Number 772519 6002207.56819 2101805.30097 37.7512817512061 -122.435221219626 (37.7512817512061, -122.435221219626) 2 4 5 28862 22
126309 258077 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 291 Duboce Ave 4 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6005037.67201 2108401.42033 37.7695534429634 -122.425903876974 (37.7695534429634, -122.425903876974) 8 4 5 28853 19
156075 258076 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 291 Duboce Ave 3 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6005037.67201 2108401.42033 37.7695534429634 -122.425903876974 (37.7695534429634, -122.425903876974) 8 4 5 28853 19
173080 105857 Significant Tree 6 Juniperus chinensis :: Juniper 113 1500X Valencia St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6006259.2 2100711.5 37.7485076710609 -122.421132539956 (37.7485076710609, -122.421132539956) 2 4 5 28859 19
175545 92054 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1001 Potrero Ave   Sidewalk: Property side : Cutout Tree Private 2         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
193898 258078 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 606 Capp St 2 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   6007262.82565 2103708.68672 37.7567937898158 -122.417874439265 (37.7567937898158, -122.417874439265) 2 4 7 28859 19
194449 262095 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 3550 Cesar Chavez St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 785078 6006203 2100616 37.7482422814736 -122.421320098122 (37.7482422814736, -122.421320098122) 2 4 5 28859 19
144623 96617 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3555@ Valencia 19th St 251 Sidewalk: Property side : Tree Rec/Park 5         Permit Number 771218 6006277 2104934 37.7601026853586 -122.42137080656 (37.7601026853586, -122.42137080656) 2 4 7 28859 19
170957 96618 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3555@ 19th St 19th St 268 Sidewalk: Property side : Tree Rec/Park 5         Permit Number 771218 6006277 2104934 37.7601026853586 -122.42137080656 (37.7601026853586, -122.42137080656) 2 4 7 28859 19
104567 254405 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 321 Lexington St 2 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   6006540.69106 2104208.04068 37.7581242333638 -122.420407294379 (37.7581242333638, -122.420407294379) 2 4 7 28859 19
1533 120590 Significant Tree 6 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 191 52 Prosper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003308 2106220 37.7634658909933 -122.43173097309 (37.7634658909933, -122.43173097309) 15 4 5 28862 3
1871 261422 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
2313 260963 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
2713 121088 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000227 2103854 37.7567943109509 -122.442217277848 (37.7567943109509, -122.442217277848) 2 4 5 28862 38
3581 255621 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
4089 260964 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
4630 261689 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 10 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
6430 260967 Significant Tree 6 Fraxinus spp :: Ash Spp 121 1100x Vermont St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
8787 260968 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9066 260960 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1001 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
9069 255620 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 785157 6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
9216 261431 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1110x Vermont St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
10119 261688 Significant Tree 6 Eucalyptus sideroxylon :: Red Ironbark 127 1100x Vermont St 9 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
13844 260966 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
14462 261432 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 8 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
16010 260965 Significant Tree 6 Robinia pseudoacacia 'Umbraculifera' :: Globe Locust 356 1100x Vermont St 6 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6010509 2103658 37.7568367689384 -122.406644345083 (37.7568367689384, -122.406644345083) 10 4 8 28859 19
18002 261423 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 2400x 23rd St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011254 2102764 37.7544236960072 -122.404004933004 (37.7544236960072, -122.404004933004) 10 4 8 28859 19
42649 115940 Significant Tree 6 Olea europaea :: Olive Tree 9 3401x 17TH ST 1 Sidewalk: Curb side : Cutout Tree Police Dept 10     20 3x3   6006069 2106010 37.7630453994978 -122.422166625338 (37.7630453994978, -122.422166625338) 8 4 5 28859 19
54607 108196 Significant Tree 6 Ginkgo biloba :: Maidenhair Tree 22 930 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
61723 111634 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 3009 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   12     6009514.91537658 2100993.40768569 37.7494647260255 -122.40989418187 (37.7494647260255, -122.40989418187) 2 4 7 28859 19
81588 113833 Significant Tree 6 Ficus nitida :: Laurel Fig 53 932 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     30     6007966 2102301 37.7529681504442 -122.415342945464 (37.7529681504442, -122.415342945464) 2 4 7 28859 19
89489 112577 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 3326 23RD ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24   Permit Number 775776 6006851 2102663.4 37.7539004875763 -122.419224541208 (37.7539004875763, -122.419224541208) 2 4 7 28859 19
99418 115942 Significant Tree 6 Olea europaea :: Olive Tree 9 3401x 17TH ST 3 Sidewalk: Curb side : Cutout Tree Police Dept 10       3x3   6006069 2106010 37.7630453994978 -122.422166625338 (37.7630453994978, -122.422166625338) 8 4 5 28859 19
107615 121415 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
110004 113695 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 907 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009441 2103786 37.7571284172194 -122.410346937481 (37.7571284172194, -122.410346937481) 2 4 7 28859 19
113215 108560 Significant Tree 6 Pinus halepensis :: Allepo Pine 330 3790 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2           6003155.9 2103640.4 37.7563743055091 -122.432072816055 (37.7563743055091, -122.432072816055) 2 4 5 28862 3
131057 121416 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 366 San Carlos St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006692 2103986 37.7575230865131 -122.419868246156 (37.7575230865131, -122.419868246156) 2 4 7 28859 19
145683 112626 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 3430X 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     12     6006285 2102686.4 37.7539317482446 -122.421183538041 (37.7539317482446, -122.421183538041) 2 4 5 28859 19
170533 115941 Significant Tree 6 Olea europaea :: Olive Tree 9 3401x 17TH ST 2 Sidewalk: Curb side : Cutout Tree Police Dept 10       3x3   6006069 2106010 37.7630453994978 -122.422166625338 (37.7630453994978, -122.422166625338) 8 4 5 28859 19
180439 108197 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 930 FLORIDA ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
9703 264868 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 145 Guerrero St 1 Side Yard : Yard Tree Private 2       3x3   6005490 2108162 37.7689216043545 -122.424322258789 (37.7689216043545, -122.424322258789) 8 4 5 28853 19
1790 103256 Significant Tree 6 Maytenus boaria :: Mayten 58 4187 26th St 1 Front Yard : Yard Tree Private 2     16 3x3   6002700 2100625 37.7480688746475 -122.433434000346 (37.7480688746475, -122.433434000346) 2 4 5 63 22
5213 84938 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 145 Guerrero St 1 Front Yard : Yard Tree Private 2         Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
8218 100711 Significant Tree 6 Tree(s) :: 17 966-968 Guerrero St 1 Front Yard : Yard Tree Private 2   09/27/2012 12:00:00 AM 14   Permit Number 769148 6005605.8 2103343.5 37.7556976788024 -122.423579088745 (37.7556976788024, -122.423579088745) 2 4 5 28859 19
9783 261822 Significant Tree 6 Acacia baileyana :: Bailey's Acacia 122 3580 21st St 2 Front Yard : Yard Tree Private 2       Width 3ft Permit Number 785112 6004538.52309 2103691.84305 37.7565938462521 -122.427294885373 (37.7565938462521, -122.427294885373) 2 4 5 28862 3
9966 251172 Significant Tree 6 Pinus radiata :: Monterey Pine 15 363 Jersey St 2 Front Yard : Yard Tree Private 2           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601) 2 4 5 28862 22
10260 261386 Significant Tree 6 Ficus microcarpa :: Chinese Banyan 97 31 Abbey St 1 Front Yard : Yard Tree Private 2       3x3   6004642 2106187 37.7634508076606 -122.427114742536 (37.7634508076606, -122.427114742536) 8 4 5 28862 3
12225 102131 Significant Tree 6 Tree(s) :: 17 850 Treat Ave 1 Front Yard : Yard Tree Private 2   12/24/2012 12:00:00 AM     Permit Number 769452 6008548.2 2103592.2 37.7565461982029 -122.413420887965 (37.7565461982029, -122.413420887965) 2 4 7 28859 19
12923 237906 Significant Tree 6 Tree(s) :: 17 3937 21st St 3 Front Yard : Yard Tree Private 2   10/06/2020 12:00:00 AM 3 Width 3ft Permit Number 785171 6002245.41508 2103514.00804 37.7559756019151 -122.43521254633 (37.7559756019151, -122.43521254633) 2 4 5 28862 22
15065 261762 Significant Tree 6 Syagrus romanzoffianum :: Queen Palm 85 2943 Harrison St 1 Front Yard : Yard Tree Private 2       Width 3ft   6009034.67775 2101326.83516 37.7503533174728 -122.411578417814 (37.7503533174728, -122.411578417814) 2 4 7 28859 19
17604 261710 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 93 3555 16th St 1 Front Yard : Yard Tree Public Library 12       8x8   6003221.95473 2106496.25325 37.7642195378276 -122.432048304209 (37.7642195378276, -122.432048304209) 15 4 5 28862 3
20184 108109 Significant Tree 6 Tree(s) :: 17 952 CAPP ST 1 Front Yard : Yard Tree Private 2   01/06/2015 12:00:00 AM 3 3x3 Permit Number 774355 6007364.7 2101732.3 37.7513728159016 -122.417382061559 (37.7513728159016, -122.417382061559) 2 4 7 28859 19
23877 105554 Significant Tree 6 Maytenus boaria :: Mayten 58 410 Elizabeth St 1 Front Yard : Yard Tree Private 2         Permit Number 772516 6003623.1 2102191.9 37.7524235434098 -122.430353733326 (37.7524235434098, -122.430353733326) 2 4 5 28862 22
27944 252826 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 3852 17th St 5 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
32199 253765 Significant Tree 6 Cornus SPP :: Dogwood 355 1366 Guerrero St 2 Front Yard : Yard Tree Private 2   02/14/2018 12:00:00 AM 3 3x3 Permit Number 780977 6005800.08489 2101007.66776 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761) 2 4 5 28859 19
36007 107047 Significant Tree 6 Tree(s) :: 17 1933 15TH ST   Front Yard : Yard Tree Private 2           6004592.7 2107127.1 37.7660293092823 -122.427352228532 (37.7660293092823, -122.427352228532) 8 4 5 28862 3
37050 252828 Significant Tree 6 Palm (unknown Genus) :: Palm Spp 273 3852 17th St 7 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
37736 101041 Significant Tree 6 Tree(s) :: 17 3750 18th St 1 Front Yard : Yard Tree SFUSD 4   03/15/2012 12:00:00 AM 30   Permit Number 769376 6005230 2105481 37.7615455321967 -122.425030802687 (37.7615455321967, -122.425030802687) 8 4 5 28859 19
40225 99859 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4443 19th St 1 Front Yard : Yard Tree Private 2     12     6001193.1 2104609.9 37.7589248414166 -122.438930324474 (37.7589248414166, -122.438930324474) 2 4 5 28862 3
43597 78107 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 970 GUERRERO ST 1 Front Yard : Yard Tree Private 2     15     6005649.9 2103318.5 37.7556315237614 -122.423424799558 (37.7556315237614, -122.423424799558) 2 4 5 28859 19
44457 252830 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 3852 17th St 9 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
46691 258502 Significant Tree 6 Liriodendron tulipifera :: Tulip Tree 145 3321 16th St 2 Front Yard : Yard Tree Private 2           6004551.31558 2106568.33958 37.7644927464624 -122.427455559127 (37.7644927464624, -122.427455559127) 8 4 5 28862 3
46751 105555 Significant Tree 6 Maytenus boaria :: Mayten 58 410 Elizabeth St 2 Front Yard : Yard Tree Private 2         Permit Number 772516 6003623.1 2102191.9 37.7524235434098 -122.430353733326 (37.7524235434098, -122.430353733326) 2 4 5 28862 22
48978 87197 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 617 Sanchez St 1 Front Yard : Yard Tree Private 2         Permit Number 50213 6003760 2104634 37.7591367256626 -122.430054504807 (37.7591367256626, -122.430054504807) 2 4 5 28862 3
61475 187629 Significant Tree 6 Acer japonicum :: Japanese Maple 124 4283 23rd St 1 Front Yard : Yard Tree Private 2       3x3   6001353 2102279 37.7525338497288 -122.438210337194 (37.7525338497288, -122.438210337194) 2 4 5 28862 22
66345 100552 Significant Tree 6 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 4443 19th St 4 Front Yard : Yard Tree Private 2           6001193.1 2104609.9 37.7589248414166 -122.438930324474 (37.7589248414166, -122.438930324474) 2 4 5 28862 3
66793 84935 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 145 Guerrero St 1 Front Yard : Yard Tree Private 2   06/06/2007 12:00:00 AM     Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
66903 233917 Significant Tree 6 Persea americana :: Avocado 34 1011 South Van Ness Ave 1 Front Yard : Yard Tree Private 2     21 Width 3ft   6007639.59401 2103741.67603 37.756905567467 -122.416573768674 (37.756905567467, -122.416573768674) 2 4 7 28859 19
68284 253182 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 5157 Diamond Heights Blvd 1 Front Yard : Yard Tree Private 2           6000788 2100195 37.7467795353698 -122.440014780391 (37.7467795353698, -122.440014780391) 2 4 5 63 22
69345 252824 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 3852 17th St 3 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
78403 258093 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1825 Mission St 7 Front Yard : Yard Tree Private 2   04/04/2019 12:00:00 AM 3 3X3   6006778.7933 2107821.9347 37.7680605555842 -122.419840266187 (37.7680605555842, -122.419840266187) 8 4 7 28853 19
78900 254971 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 972 Guerrero St 1 Front Yard : Yard Tree Private 2       3x3   6005650 2103315 37.7556219192197 -122.423424204919 (37.7556219192197, -122.423424204919) 2 4 5 28859 19
78991 252827 Significant Tree 6 Washingtonia robusta :: Mexican Fan Palm 72 3852 17th St 6 Front Yard : Yard Tree Private 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
84261 251716 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 3929 19th St 1 Front Yard : Yard Tree Private 2           6003450 2104734 37.7593937399337 -122.431133769968 (37.7593937399337, -122.431133769968) 2 4 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)
);