trees
135 rows where qSpecies_id = 201 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28174 | 12897 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
30168 | 12899 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
101621 | 12901 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
134662 | 12898 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | |||
180899 | 12896 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 255X Larch St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006360.81512 | 2112999.88713 | 37.7822544100736 | -122.421653822027 | (37.7822544100736, -122.421653822027) | 7 | 9 | 11 | 28852 | 41 | ||
48075 | 12885 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 200X Larch St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006589.39642 | 2113072.01589 | 37.7824653447827 | -122.420868153744 | (37.7824653447827, -122.420868153744) | 7 | 9 | 11 | 28852 | 41 | |||
141620 | 12882 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 200X Larch St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006589.39642 | 2113072.01589 | 37.7824653447827 | -122.420868153744 | (37.7824653447827, -122.420868153744) | 7 | 9 | 11 | 28852 | 41 | |||
187122 | 12883 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 200X Larch St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006589.39642 | 2113072.01589 | 37.7824653447827 | -122.420868153744 | (37.7824653447827, -122.420868153744) | 7 | 9 | 11 | 28852 | 41 | |||
82303 | 57313 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 3x3 | Permit Number 16136 | 5999704.4841929 | 2114025.1830868 | 37.784692017358 | -122.444755399201 | (37.784692017358, -122.444755399201) | 15 | 6 | 1 | 29490 | 31 | ||
39505 | 12439 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
66425 | 12435 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
103348 | 12437 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
108252 | 12436 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1595X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004488.80475 | 2114299.5475 | 37.785717215657 | -122.428222797765 | (37.785717215657, -122.428222797765) | 13 | 9 | 11 | 29490 | 13 | |||
194140 | 2459 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1801X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1998 12:00:00 AM | 3 | 4X4 | 6003961.1396892 | 2114603.1916159 | 37.7865210759478 | -122.430070036959 | (37.7865210759478, -122.430070036959) | 13 | 9 | 11 | 29490 | 27 | ||
184820 | 2460 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1802X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6004009.7642795 | 2114616.5275781 | 37.7865604469042 | -122.429902759542 | (37.7865604469042, -122.429902759542) | 13 | 9 | 11 | 29490 | 27 | |||
11297 | 12432 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
28792 | 12433 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
136130 | 12431 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
192508 | 12434 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1755 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004422.6934 | 2114848.24389 | 37.7872200575435 | -122.428490648397 | (37.7872200575435, -122.428490648397) | 13 | 9 | 11 | 29490 | 27 | |||
46728 | 2641 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1765X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004408.21795 | 2114879.70403 | 37.7873056200256 | -122.428542973686 | (37.7873056200256, -122.428542973686) | 13 | 9 | 11 | 29490 | 27 | |||
75110 | 2642 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1765X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6004408.21795 | 2114879.70403 | 37.7873056200256 | -122.428542973686 | (37.7873056200256, -122.428542973686) | 13 | 9 | 11 | 29490 | 27 | |||
44098 | 2649 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1945 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004183.14856 | 2114926.81574 | 37.7874222375245 | -122.429325027076 | (37.7874222375245, -122.429325027076) | 13 | 9 | 11 | 29490 | 27 | |||
87715 | 2648 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1945 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4X4 | 6004183.14856 | 2114926.81574 | 37.7874222375245 | -122.429325027076 | (37.7874222375245, -122.429325027076) | 13 | 9 | 11 | 29490 | 27 | |||
51435 | 26712 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 340 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 2x2 | 5994414.30523 | 2114928.25799 | 37.7868683042504 | -122.463123069231 | (37.7868683042504, -122.463123069231) | 11 | 6 | 1 | 54 | 11 | |||
56267 | 26711 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 340 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 2x2 | 5994414.30523 | 2114928.25799 | 37.7868683042504 | -122.463123069231 | (37.7868683042504, -122.463123069231) | 11 | 6 | 1 | 54 | 11 | |||
119425 | 26714 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 340 Lake St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 5994414.30523 | 2114928.25799 | 37.7868683042504 | -122.463123069231 | (37.7868683042504, -122.463123069231) | 11 | 6 | 1 | 54 | 11 | |||
168126 | 102450 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2205 Pacific Ave | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/28/2014 12:00:00 AM | Permit Number 772662 | 6003508.7 | 2117188.3 | 37.7935934914571 | -122.431820013768 | (37.7935934914571, -122.431820013768) | 13 | 9 | 1 | 29490 | 27 | |||
180945 | 113407 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1959X POLK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6006418 | 2117595 | 37.7948746770036 | -122.421782481899 | (37.7948746770036, -122.421782481899) | 13 | 9 | 10 | 28858 | 32 | |||
37670 | 106946 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2710 BAKER ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2014 12:00:00 AM | 1 | 3x3 | 5999632.3 | 2118174.9 | 37.7960819303033 | -122.44530359746 | (37.7960819303033, -122.44530359746) | 13 | 9 | 1 | 57 | 17 | |||
114486 | 84965 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2503 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52401 | 6001033 | 2118263 | 37.7964036854154 | -122.440463231838 | (37.7964036854154, -122.440463231838) | 13 | 9 | 1 | 57 | 17 | ||
108197 | 53283 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2606 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2007 12:00:00 AM | Permit Number 49537 | 6005355.41207376 | 2118914.02943872 | 37.7984364178674 | -122.42555310995 | (37.7984364178674, -122.42555310995) | 13 | 9 | 1 | 57 | 17 | |||
155511 | 114474 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1254 MONTGOMERY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011527 | 2119680 | 37.8008863659875 | -122.40425133897 | (37.8008863659875, -122.40425133897) | 3 | 1 | 10 | 308 | 23 | ||||
58602 | 85259 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2239 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49558 | 6007574 | 2120083 | 37.8017712241665 | -122.417959005089 | (37.8017712241665, -122.417959005089) | 5 | 1 | 1 | 28858 | 32 | |||
44201 | 58123 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 800 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1978 12:00:00 AM | Permit Number 17105 | 6008509.24459419 | 2120396.75874665 | 37.802685318336 | -122.414744832906 | (37.802685318336, -122.414744832906) | 5 | 1 | 10 | 308 | 32 | |||
188310 | 112373 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 15 VANDEWATER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009208 | 2121303 | 37.8052128657777 | -122.412390870606 | (37.8052128657777, -122.412390870606) | 3 | 1 | 10 | 308 | 23 |
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) );