trees
21 rows where Neighborhoods (old) = 3 and qSpecies_id = 65 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3367 | 221931 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2136 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003273.64696 | 2107146.54353 | 37.7660080078823 | -122.431915952764 | (37.7660080078823, -122.431915952764) | 15 | 5 | 5 | 28862 | 3 | |||
| 8855 | 221923 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002696.84533 | 2104324.2367 | 37.758225920618 | -122.433709258485 | (37.758225920618, -122.433709258485) | 2 | 4 | 5 | 28862 | 3 | |||
| 11193 | 221927 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 30 Collingwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001978.23682 | 2105679.10169 | 37.7619052494464 | -122.436291477373 | (37.7619052494464, -122.436291477373) | 15 | 4 | 5 | 28862 | 3 | |||
| 16727 | 227695 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4250 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6001245.67427 | 2103366.3123 | 37.7555132424609 | -122.438659390527 | (37.7555132424609, -122.438659390527) | 2 | 4 | 5 | 28862 | 3 | |||
| 25181 | 221922 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002658.74413 | 2105066.93812 | 37.7602630379377 | -122.433894115042 | (37.7602630379377, -122.433894115042) | 2 | 4 | 5 | 28862 | 3 | |||
| 31207 | 32474 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Ord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 15 | Permit Number 36982 | 6000854.39467 | 2106273.37873 | 37.7634730690508 | -122.440221013784 | (37.7634730690508, -122.440221013784) | 15 | 5 | 5 | 28862 | 3 | |
| 48932 | 221930 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2134 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003302.06195 | 2107147.52772 | 37.7660123210304 | -122.431817741407 | (37.7660123210304, -122.431817741407) | 15 | 5 | 5 | 28862 | 3 | |||
| 59484 | 221933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4166 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001253.22781 | 2105851.44827 | 37.7623372504834 | -122.438811343586 | (37.7623372504834, -122.438811343586) | 15 | 5 | 5 | 28862 | 3 | |||
| 90849 | 221932 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 265 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001846.56535 | 2107325.41516 | 37.7664181410013 | -122.436864736716 | (37.7664181410013, -122.436864736716) | 15 | 5 | 5 | 28862 | 3 | |||
| 105651 | 32556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 233 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | 7 | Permit Number 37043 | 6004755.28395 | 2103949.67696 | 37.7573140539292 | -122.42656360702 | (37.7573140539292, -122.42656360702) | 2 | 4 | 5 | 28862 | 3 | ||
| 107364 | 221928 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3666 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002501.47722 | 2106518.4971 | 37.7642397410968 | -122.434541817574 | (37.7642397410968, -122.434541817574) | 15 | 5 | 5 | 28862 | 3 | |||
| 114883 | 221926 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.55536 | 2104400.84265 | 37.7584570634637 | -122.432446488035 | (37.7584570634637, -122.432446488035) | 2 | 4 | 5 | 28862 | 3 | |||
| 139226 | 221921 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 474 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002945.55902 | 2105503.88006 | 37.7614790472472 | -122.432933374683 | (37.7614790472472, -122.432933374683) | 15 | 4 | 5 | 28862 | 3 | |||
| 163060 | 221924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003063.54599 | 2104384.44794 | 37.7584120469841 | -122.432445349468 | (37.7584120469841, -122.432445349468) | 2 | 4 | 5 | 28862 | 3 | |||
| 185444 | 221929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 70 Beaver St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002463.4686 | 2106805.25277 | 37.7650249445694 | -122.434693785007 | (37.7650249445694, -122.434693785007) | 15 | 5 | 5 | 28862 | 3 | |||
| 191257 | 221925 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.11799 | 2104395.60529 | 37.7584426581259 | -122.432447626582 | (37.7584426581259, -122.432447626582) | 2 | 4 | 5 | 28862 | 3 | |||
| 73676 | 102018 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 4252 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001333 | 2103370 | 37.7555283353782 | -122.438357655981 | (37.7555283353782, -122.438357655981) | 2 | 4 | 5 | 28862 | 3 | |||
| 31052 | 109288 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773379 | 6002625.7 | 2104315.8 | 37.7581987182413 | -122.433954706682 | (37.7581987182413, -122.433954706682) | 2 | 4 | 5 | 28862 | 3 |
| 56352 | 238396 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2221 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782349 | 6002719.76824 | 2107072.27368 | 37.7657726661007 | -122.433826396093 | (37.7657726661007, -122.433826396093) | 15 | 5 | 5 | 28862 | 3 | |
| 108472 | 109743 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775046 | 6002641.7 | 2105066.1 | 37.7602597694278 | -122.433953002704 | (37.7602597694278, -122.433953002704) | 2 | 4 | 5 | 28862 | 3 |
| 134976 | 255531 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2130 15th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782019 | 6003380.68215 | 2107148.89983 | 37.7660205449408 | -122.431545908158 | (37.7660205449408, -122.431545908158) | 15 | 5 | 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) );