trees
23 rows where SiteOrder = 2, Zip Codes = 28861 and qSpecies_id = 65 sorted by TreeID
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73282 | 108847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 970 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001586.13513 | 2086816.33243 | 37.7100901720951 | -122.436297601751 | (37.7100901720951, -122.436297601751) | 9 | 7 | 6 | 28861 | 5 | |
| 6932 | 112764 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774164 | 5997123.4 | 2089342.1 | 37.7167707693614 | -122.45190370908 | (37.7167707693614, -122.45190370908) | 9 | 8 | 6 | 28861 | 24 | ||
| 13377 | 160452 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001241.76743 | 2090358.86031 | 37.719797591855 | -122.437741350891 | (37.719797591855, -122.437741350891) | 9 | 7 | 6 | 28861 | 5 | ||
| 19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
| 130503 | 175177 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 763 Morse St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5998527.33807 | 2087102.13623 | 37.7107006525794 | -122.44688991486 | (37.7107006525794, -122.44688991486) | 9 | 7 | 6 | 28861 | 5 | |||
| 55860 | 175179 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 450 Italy Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001771.83891 | 2089201.36797 | 37.7166495024579 | -122.43582630935 | (37.7166495024579, -122.43582630935) | 9 | 7 | 6 | 28861 | 5 | |||
| 126749 | 175180 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002933.07108 | 2089399.59548 | 37.7172596870602 | -122.43182665728 | (37.7172596870602, -122.43182665728) | 9 | 7 | 6 | 28861 | 5 | |||
| 107710 | 175194 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 522 Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004004.48398 | 2092477.2158 | 37.7257708331541 | -122.428342513702 | (37.7257708331541, -122.428342513702) | 9 | 7 | 6 | 28861 | 5 | |||
| 188048 | 175198 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 648 Peru Ave | 2 | Side Yard : Yard | Tree | Private 2 | 12 | 6005048.079 | 2092617.03467 | 37.7262137420546 | -122.424744822616 | (37.7262137420546, -122.424744822616) | 9 | 7 | 6 | 28861 | 5 | ||||
| 20543 | 203531 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5995610.31086 | 2092357.07195 | 37.7249623857941 | -122.457351672459 | (37.7249623857941, -122.457351672459) | 9 | 7 | 4 | 28861 | 40 | |||
| 127453 | 203538 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 313 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5999326.9827 | 2094355.31618 | 37.7306618716326 | -122.444647158563 | (37.7306618716326, -122.444647158563) | 9 | 7 | 4 | 28861 | 40 | |||
| 159787 | 203555 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5994968.99544 | 2088379.28856 | 37.7140034838548 | -122.459280689461 | (37.7140034838548, -122.459280689461) | 9 | 8 | 6 | 28861 | 24 | |||
| 118838 | 203560 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5997153.12879 | 2089368.29033 | 37.7168443846497 | -122.451802840126 | (37.7168443846497, -122.451802840126) | 9 | 8 | 6 | 28861 | 24 | |||
| 159587 | 203566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5996063.41122 | 2094232.89601 | 37.7301389635391 | -122.455920909543 | (37.7301389635391, -122.455920909543) | 9 | 7 | 4 | 28861 | 40 | |||
| 146877 | 203582 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5997457.41638 | 2093726.64675 | 37.7288288329774 | -122.451065185614 | (37.7288288329774, -122.451065185614) | 9 | 7 | 4 | 28861 | 40 | |||
| 69139 | 221840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.7336390727743 | -122.427481531566 | (37.7336390727743, -122.427481531566) | 2 | 7 | 5 | 28861 | 25 | |||
| 28695 | 221842 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004251.52018 | 2095424.77714 | 37.7338781539609 | -122.427698444448 | (37.7338781539609, -122.427698444448) | 2 | 7 | 5 | 28861 | 25 | |||
| 167184 | 221846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6004388.2708 | 2095606.1808 | 37.7343839821397 | -122.427238573395 | (37.7343839821397, -122.427238573395) | 2 | 7 | 5 | 28861 | 25 | |||
| 1033 | 221901 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004253.74444 | 2095482.9703 | 37.7340380650904 | -122.427694899296 | (37.7340380650904, -122.427694899296) | 2 | 7 | 5 | 28861 | 25 | |||
| 7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
| 171813 | 35138 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 832 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38668 | 6001976.8462 | 2088896.96126 | 37.7158253124776 | -122.435095942923 | (37.7158253124776, -122.435095942923) | 9 | 7 | 6 | 28861 | 5 | |
| 111705 | 74111 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 500X Avalon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/1994 12:00:00 AM | 15 | 3x3 | 6003976.59234436 | 2092494.78352221 | 37.7258174919201 | -122.428440184616 | (37.7258174919201, -122.428440184616) | 9 | 7 | 6 | 28861 | 5 | ||
| 156296 | 87374 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 149 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50353 | 5999085.2 | 2093741.7 | 37.7289632252792 | -122.445438930282 | (37.7289632252792, -122.445438930282) | 9 | 7 | 4 | 28861 | 40 |
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) );