trees
22 rows where DBH = 14 and qCaretaker_id = 4 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1119 | 113031 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | 11 | 6 | 2 | 54 | 11 | |||
| 18625 | 113033 | DPW Maintained 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 | 251 06th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | 3x3 | 5993974.82941 | 2113822.74411 | 37.7838075380241 | -122.464563239136 | (37.7838075380241, -122.464563239136) | 11 | 6 | 2 | 54 | 11 | |||
| 121669 | 234075 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1400 San Bruno Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 14 | Width 4ft | 6011146.17896 | 2101629.85029 | 37.7513035456277 | -122.404297986789 | (37.7513035456277, -122.404297986789) | 10 | 4 | 8 | 28859 | 19 | |||
| 11226 | 33101 | DPW Maintained 1 | Quercus virginiana :: Southern Live Oak 300 | 450X Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 11/05/1996 12:00:00 AM | 14 | Permit Number 37341 | 6009682.3141 | 2120901.0273 | 37.804135754367 | -122.410721035819 | (37.804135754367, -122.410721035819) | 3 | 1 | 10 | 308 | 23 | |
| 11807 | 70932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988727.46903 | 2113517.26751 | 37.7826648905872 | -122.482694534783 | (37.7826648905872, -122.482694534783) | 11 | 6 | 2 | 55 | 26 | |||
| 14144 | 75133 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.432160858845 | (37.7256104849218, -122.432160858845) | 9 | 7 | 6 | 28861 | 5 | ||
| 24577 | 99676 | DPW Maintained 1 | Tree(s) :: 17 | 1250X Shrader St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 5997882 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | 15 | 5 | 11 | 29492 | 9 | ||
| 24846 | 99691 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1550X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 6007274.7 | 2117123.2 | 37.7936275055362 | -122.418784695641 | (37.7936275055362, -122.418784695641) | 5 | 1 | 10 | 28858 | 32 | ||
| 27553 | 97723 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
| 45359 | 96211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201X Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | ||
| 58278 | 75214 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.80856 | 37.7256614422973 | -122.432268027453 | (37.7256614422973, -122.432268027453) | 9 | 7 | 6 | 28861 | 5 | |
| 59231 | 97070 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 3x3 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 67880 | 77637 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 79131 | 97722 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 1 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x57 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
| 98383 | 96212 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 201X Diamond St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 4x4 | 6001762.6 | 2104666.8 | 37.759113460692 | -122.436964804087 | (37.759113460692, -122.436964804087) | 2 | 4 | 5 | 28862 | 3 | ||
| 119464 | 76771 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 129428 | 76768 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 140619 | 76757 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 200X Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/20/1989 12:00:00 AM | 14 | 3x3 | 5995015.41074948 | 2088495.64250033 | 37.7143256328225 | -122.459128681816 | (37.7143256328225, -122.459128681816) | 9 | 8 | 6 | 28861 | 24 | |
| 167189 | 97724 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 1000X Bay St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 7x82 | 6005985.5 | 2121074.1 | 37.8044030021841 | -122.42352646028 | (37.8044030021841, -122.42352646028) | 5 | 1 | 1 | 28858 | 32 | ||
| 180726 | 77634 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 184196 | 122755 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 693 Vermont St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 6011274.22678 | 2105356.76628 | 37.7615439863765 | -122.404117444276 | (37.7615439863765, -122.404117444276) | 10 | 3 | 8 | 28856 | 29 | |||
| 191029 | 95148 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988724.77962 | 2113566.52719 | 37.7827999873072 | -122.482707449869 | (37.7827999873072, -122.482707449869) | 11 | 6 | 2 | 55 | 26 |
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) );