trees
38 rows where DBH = 4 and qCaretaker_id = 4 sorted by qLegalStatus_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
57109 | 102194 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
70160 | 95470 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 539X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986557.7 | 2112257.8 | 37.7790802775989 | -122.490108236864 | (37.7790802775989, -122.490108236864) | 11 | 6 | 2 | 55 | 26 | ||
97154 | 70472 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
134117 | 95467 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 533X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986556.1 | 2112298 | 37.7791905619119 | -122.490116729573 | (37.7791905619119, -122.490116729573) | 11 | 6 | 2 | 55 | 26 | ||
1341 | 76159 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
5695 | 77663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006674.08558 | 2093407.54115 | 37.7284760037541 | -122.419179842976 | (37.7284760037541, -122.419179842976) | 9 | 3 | 7 | 309 | 5 | ||
7708 | 76081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
8515 | 76311 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 299X Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 0 | 6006754.26056 | 2093151.90933 | 37.7277786091743 | -122.418884550584 | (37.7277786091743, -122.418884550584) | 9 | 3 | 7 | 309 | 5 | ||
18051 | 77661 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 299X Cambridge St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6006687.82384 | 2093371.12447 | 37.7283767851556 | -122.419129766951 | (37.7283767851556, -122.419129766951) | 9 | 3 | 7 | 309 | 5 | ||
18509 | 76705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6003030.53484 | 2092605.75448 | 37.7260686121528 | -122.431718554264 | (37.7260686121528, -122.431718554264) | 9 | 7 | 6 | 28861 | 5 | ||
26495 | 42983 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2X Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 4 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
42731 | 115967 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4 | 3x3 | 5986812.8086 | 2104676.4366 | 37.7582788637421 | -122.488668327875 | (37.7582788637421, -122.488668327875) | 1 | 8 | 3 | 56 | 35 | |||
51293 | 100971 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 450X Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 4 | Permit Number 37341 | 6009642.5454 | 2120895.3461 | 37.8041179253888 | -122.410858257388 | (37.8041179253888, -122.410858257388) | 3 | 1 | 10 | 308 | 23 | ||
75380 | 46955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 4 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
76451 | 77217 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
84709 | 99338 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 16 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3X3 | 5986576.26956 | 2112967.74794 | 37.7810306764919 | -122.490096232309 | (37.7810306764919, -122.490096232309) | 11 | 6 | 2 | 55 | 26 | ||
86443 | 76019 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
89171 | 77219 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 23 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
90475 | 234072 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 4 | Width 3ft | 6011140.67766 | 2101759.73109 | 37.7516598624171 | -122.404326151746 | (37.7516598624171, -122.404326151746) | 10 | 4 | 8 | 28859 | 19 | ||
90903 | 77212 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
110143 | 99327 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450 30th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986588.01582 | 2112673.64698 | 37.7802238451734 | -122.490033958427 | (37.7802238451734, -122.490033958427) | 11 | 6 | 2 | 55 | 26 | ||
123461 | 99334 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 450 30th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986579.77919 | 2112870.79018 | 37.7807646631349 | -122.490076957163 | (37.7807646631349, -122.490076957163) | 11 | 6 | 2 | 55 | 26 | ||
127608 | 76051 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
132081 | 42984 | DPW Maintained 1 | Tree(s) :: 17 | 2X Yale St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 4 | 4x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
136087 | 30737 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 490X Page St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 4 | 3x3 | Permit Number 42884 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
147370 | 116046 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 650x Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 5x15 | 6011495.20108 | 2105434.89797 | 37.7617708628477 | -122.40335867726 | (37.7617708628477, -122.40335867726) | 10 | 3 | 8 | 28856 | 29 | ||
152290 | 115971 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 1599x 30th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4 | 3x3 | 5986813.9683 | 2104572.6448 | 37.757993947556 | -122.488656688385 | (37.757993947556, -122.488656688385) | 1 | 8 | 3 | 56 | 35 | |||
153204 | 81998 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50638 | 6005939.39797 | 2120724.94139 | 37.8034416999448 | -122.42366116025 | (37.8034416999448, -122.42366116025) | 5 | 9 | 1 | 28858 | 32 |
153739 | 77206 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 499X Hearst Ave | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 4 | 3x3 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 | |
159694 | 76205 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
165795 | 95471 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 601X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 5986558.17112 | 2112222.97674 | 37.778984690357 | -122.49010404497 | (37.778984690357, -122.49010404497) | 11 | 6 | 2 | 55 | 26 | ||
167966 | 76185 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 | |
169868 | 96576 | DPW Maintained 1 | Quercus coccinea :: Scarlet Oak 134 | 401x Otsego Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 4 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | ||||
169903 | 130257 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 2213 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | Width 5ft | 6008055.23608 | 2120086.84866 | 37.8018088638398 | -122.416293973386 | (37.8018088638398, -122.416293973386) | 5 | 1 | 10 | 308 | 32 | ||
173163 | 97729 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005819.00921 | 2120706.70735 | 37.8033848375917 | -122.424076473471 | (37.8033848375917, -122.424076473471) | 5 | 9 | 1 | 28858 | 32 | |
188131 | 97727 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005898.3389 | 2120719.31411 | 37.8034239311172 | -122.423802846647 | (37.8034239311172, -122.423802846647) | 5 | 9 | 1 | 28858 | 32 | |
191362 | 97733 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | Permit Number 50638 | 6005736.8865 | 2120695.23683 | 37.8033487055393 | -122.424359846228 | (37.8033487055393, -122.424359846228) | 5 | 9 | 1 | 28858 | 32 | |
192959 | 76112 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 380 Webster St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/12/1994 12:00:00 AM | 4 | 3x3 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.429051358355 | (37.7740034947051, -122.429051358355) | 7 | 9 | 11 | 28852 | 10 |
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) );