trees
38 rows where qLegalStatus_id = 7 and qSpecies_id = 201
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
29785 | 88720 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 301 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2008 12:00:00 AM | 3x3 | Permit Number 774804 | 6004157.3 | 2109772.9 | 37.773269399945 | -122.429046849446 | (37.773269399945, -122.429046849446) | 7 | 9 | 11 | 29492 | 10 | ||
34099 | 105230 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 69 KEYSTONE WAY | 1 | Front Yard : Yard | Tree | Private 2 | 06/17/2014 12:00:00 AM | 30 | Permit Number 773353 | 5994093.4 | 2093229.9 | 37.7272717167315 | -122.462658710338 | (37.7272717167315, -122.462658710338) | 9 | 8 | 4 | 59 | 40 | ||
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 | |||
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 | |||
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 | |||
46643 | 39172 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 736 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 8 | Permit Number 40834 | 6007488.6062833 | 2105367.57823812 | 37.761361427438 | -122.417211152399 | (37.761361427438, -122.417211152399) | 2 | 4 | 7 | 28859 | 19 | |
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 | |||
53502 | 101169 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1301X 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 33324 | 5994554 | 2106650 | 37.7641464551633 | -122.462039213312 | (37.7641464551633, -122.462039213312) | 1 | 5 | 11 | 56 | 12 | ||||
56835 | 4258 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 4094X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003364.7569552 | 2100412.8299453 | 37.7475239975457 | -122.431120155296 | (37.7475239975457, -122.431120155296) | 2 | 4 | 5 | 63 | 22 | |||
58269 | 122812 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 889 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6009956.83094511 | 2104043.07852524 | 37.7578631996098 | -122.40858112242 | (37.7578631996098, -122.40858112242) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | |||
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 | |||
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 | |||
75400 | 4259 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 4094X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6003364.7569552 | 2100412.8299453 | 37.7475239975457 | -122.431120155296 | (37.7475239975457, -122.431120155296) | 2 | 4 | 5 | 63 | 22 | |||
80990 | 107306 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 191 CASELLI AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000068 | 2104828 | 37.7594596127231 | -122.442837096046 | (37.7594596127231, -122.442837096046) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||
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 | |||
91987 | 58133 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 311 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/05/2016 12:00:00 AM | 3 | Permit Number 17115 | 6000220.45021465 | 2109949.44722515 | 37.7735305196789 | -122.442677584536 | (37.7735305196789, -122.442677584536) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |||
106986 | 100896 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1800 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
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 | |||
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 | |||
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 | ||
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 | |||
145570 | 69257 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 401 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/1994 12:00:00 AM | Permit Number 33324 | 5994548.69419505 | 2106652.17355678 | 37.7641521177083 | -122.462057722056 | (37.7641521177083, -122.462057722056) | 1 | 5 | 11 | 56 | 12 | |||
161672 | 99651 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1300 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2003 12:00:00 AM | 3x3 | 5991764 | 2106610 | 37.7638756002396 | -122.471686009646 | (37.7638756002396, -122.471686009646) | 11 | 8 | 11 | 56 | 12 | |||
163371 | 66635 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 889 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1998 12:00:00 AM | Permit Number 29846 | 6009956.83094511 | 2104043.07852524 | 37.7578631996098 | -122.40858112242 | (37.7578631996098, -122.40858112242) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
169366 | 54897 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 203 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1972 12:00:00 AM | 3x3 | Permit Number 10763 | 5997226.12135807 | 2107036.80892371 | 37.765362015501 | -122.452825087824 | (37.765362015501, -122.452825087824) | 15 | 5 | 11 | 29492 | 12 | ||
174023 | 101168 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 401 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 33324 | 5994554 | 2106650 | 37.7641464551633 | -122.462039213312 | (37.7641464551633, -122.462039213312) | 1 | 5 | 11 | 56 | 12 | ||||
175470 | 101167 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 401 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 33324 | 5994554 | 2106650 | 37.7641464551633 | -122.462039213312 | (37.7641464551633, -122.462039213312) | 1 | 5 | 11 | 56 | 12 | ||||
176336 | 86911 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2256 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49876 | 6009641 | 2104201 | 37.7582791230904 | -122.409684549013 | (37.7582791230904, -122.409684549013) | 2 | 4 | 7 | 28859 | 19 | |
179643 | 100895 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1800 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
191669 | 4260 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 4094X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6003303.5082097 | 2100409.5413687 | 37.7475114969278 | -122.431331714787 | (37.7475114969278, -122.431331714787) | 2 | 4 | 5 | 63 | 22 | |||
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 | |||
194128 | 21848 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 224 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/1993 12:00:00 AM | 5 | 3X3 | 5994910.90461 | 2110804.06513 | 37.775572970261 | -122.461105914285 | (37.775572970261, -122.461105914285) | 11 | 6 | 2 | 54 | 11 |
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) );