trees
28 rows where Fire Prevention Districts = 8 and qLegalStatus_id = 8
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2474 | 256556 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 5 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:18:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 3739 | 261012 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
| 8082 | 96598 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 18405 | 261011 | Property Tree 8 | Pinus canariensis :: Canary Island Pine 35 | 170 Otis St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6006561 | 2108839 | 37.7708409033816 | -122.420665800575 | (37.7708409033816, -122.420665800575) | 8 | 2 | 9 | 28853 | 19 | ||||
| 19875 | 96597 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 20715 | 99276 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 2 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
| 33788 | 96601 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 34431 | 256554 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 3 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:10:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 35006 | 96602 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 39751 | 96590 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 44908 | 96593 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 63210 | 96591 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 81530 | 96594 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 89589 | 99277 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 3 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
| 90011 | 256555 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 4 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:48:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 103261 | 99275 | Property Tree 8 | Tree(s) :: 17 | 85X 10th St | 1 | Front Yard : Yard | Tree | Private 2 | 04/25/2012 12:00:00 AM | Permit Number 768878 | 6007907.6 | 2110517 | 37.7755240963356 | -122.416126724722 | (37.7755240963356, -122.416126724722) | 8 | 2 | 9 | 28853 | 34 | |||
| 120469 | 96606 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 136541 | 96599 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 138264 | 96604 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 142618 | 96600 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 142995 | 108574 | Property Tree 8 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard | Tree | Private 2 | 7x8 | 6004884.86016 | 2107160.44126 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | 8 | 4 | 5 | 28853 | 19 | ||||
| 145479 | 96592 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 156111 | 96589 | Property Tree 8 | Eriobotrya deflexa :: Bronze Loquat 8 | 450 Church St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6004088.8 | 2106523.6 | 37.7643437320395 | -122.429052084094 | (37.7643437320395, -122.429052084094) | 8 | 4 | 5 | 28862 | 3 | |||||
| 175776 | 256557 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 6 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:44:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 176971 | 256553 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 2 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 09:24:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 | ||
| 184992 | 96603 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 186894 | 96605 | Property Tree 8 | Citrus × meyeri 'Improved' :: Improved Meyer Lemon 317 | 325 Sanchez St | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | 6003898 | 2106263.7 | 37.7636193068731 | -122.429693469686 | (37.7636193068731, -122.429693469686) | 8 | 4 | 5 | 28862 | 3 | |||||
| 189291 | 256552 | Property Tree 8 | Acer rubrum :: Red Maple 75 | 3401X 16th St | 1 | Side Yard : Yard | Tree | SFUSD 4 | 02/08/2019 08:54:00 AM | 3 | 3x3 | 6004088 | 2106523 | 37.7643420392989 | -122.429054808288 | (37.7643420392989, -122.429054808288) | 8 | 4 | 5 | 28862 | 3 |
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) );