trees
150 rows where Police Districts = 4 and qLegalStatus_id = 6 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
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 | ||||
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 | ||||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );