trees
39 rows where PlotSize = "Width 3ft" and qLegalStatus_id = 6 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
551 | 234021 | Significant Tree 6 | Pittosporum tobira :: Japanese Mockorange 118 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 3ft | 6009064.54563 | 2097789.74594 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | 10 | 7 | 7 | 28859 | 2 | |||
1248 | 260958 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
10162 | 230434 | Significant Tree 6 | Magnolia x soulangiana :: Saucer Magnolia 147 | 272 Anderson St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | Width 3ft | 6007874.82314 | 2097362.07469 | 37.7394018403099 | -122.415308650074 | (37.7394018403099, -122.415308650074) | 2 | 7 | 7 | 28859 | 2 | |||
11129 | 236516 | Significant Tree 6 | Prunus cerasifera :: Cherry Plum 7 | 63 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6009359.84862 | 2097078.24448 | 37.7387058549889 | -122.410154031979 | (37.7387058549889, -122.410154031979) | 10 | 7 | 7 | 28859 | 2 | |||
11600 | 260651 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
13777 | 261032 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 438 Roosevelt Way | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6000030.97008 | 2106544.70148 | 37.7641711390149 | -122.443088453592 | (37.7641711390149, -122.443088453592) | 15 | 5 | 5 | 29492 | 3 | ||||
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 | ||||
15717 | 221238 | Significant Tree 6 | Betula pendula :: European White Birch 253 | 55 Bronte St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6009363.02974 | 2097125.97708 | 37.7388370966643 | -122.41014640214 | (37.7388370966643, -122.41014640214) | 10 | 7 | 7 | 28859 | 2 | |||
16256 | 260911 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2035 15th Ave | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 5991575 | 2101572 | 37.7500316406912 | -122.471972478281 | (37.7500316406912, -122.471972478281) | 1 | 8 | 4 | 29491 | 12 | ||||
16260 | 260650 | Significant Tree 6 | Lophostemon confertus :: Brisbane Box 11 | 3751 Sacramento St | 1 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 5996933 | 2115011 | 37.7872402598449 | -122.454414995547 | (37.7872402598449, -122.454414995547) | 11 | 6 | 1 | 54 | 31 | ||||
17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
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 | ||||
18860 | 229626 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 19 | 3658 Folsom St | 1 | Side Yard : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008459.0571 | 2097864.523 | 37.7408142714666 | -122.413324142211 | (37.7408142714666, -122.413324142211) | 2 | 7 | 7 | 28859 | 2 | |||
27985 | 253620 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1120 South Van Ness Ave | 3 | Front Yard : Cutout | Tree | Private 2 | Width 3ft | 6007603.98274 | 2103104.14442 | 37.7551530486792 | -122.416651764192 | (37.7551530486792, -122.416651764192) | 2 | 4 | 7 | 28859 | 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 | |||
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 | |||
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 | |||
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 | ||||
107642 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 367 Jersey St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6002770.52649 | 2101500.01269 | 37.7504754543841 | -122.433252636724 | (37.7504754543841, -122.433252636724) | 2 | 4 | 5 | 28862 | 22 | ||||
113217 | 255048 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 45 Eagle St | 3 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6000118.88808 | 2104341.86796 | 37.7581277146448 | -122.44262619575 | (37.7581277146448, -122.44262619575) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
128499 | 255151 | Significant Tree 6 | Araucaria bidwillii :: Bunya Bunya 551 | 201 Vicente St | 4 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 5992494.60347 | 2097875.96956 | 37.7399364549038 | -122.468523586018 | (37.7399364549038, -122.468523586018) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
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 | |||
172650 | 255483 | Significant Tree 6 | Persea americana :: Avocado 34 | 1295 Hampshire St | 1 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6010340.83328 | 2101731.71507 | 37.7515382084299 | -122.407090155993 | (37.7515382084299, -122.407090155993) | 10 | 4 | 7 | 28859 | 19 | ||||
176722 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 701 Noe St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.7577272573137 | -122.432146391441 | (37.7577272573137, -122.432146391441) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
72516 | 258223 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 53 Starr King Way | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | Permit Number 782966 | 6005764 | 2113984 | 37.784922869937 | -122.423788535241 | (37.784922869937, -122.423788535241) | 13 | 9 | 11 | 28858 | 41 | |||
16055 | 260578 | Significant Tree 6 | Tree(s) :: 17 | 1879 Funston Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 784834 | 5992075.37659 | 2102679.56742 | 37.7531016753032 | -122.470322812874 | (37.7531016753032, -122.470322812874) | 1 | 8 | 4 | 56 | 12 | |
3462 | 233333 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 188 States St | 1 | Back Yard : Yard | Tree | Private 2 | 14 | Width 3ft | Permit Number 784841 | 6001049.9199 | 2106366.66768 | 37.763740347549 | -122.43955144426 | (37.763740347549, -122.43955144426) | 15 | 5 | 5 | 28862 | 3 | ||
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 | |||
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 |
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) );