trees
135 rows where 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
165266 | 108915 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 45 LANGTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2x3 | 6010039 | 2111121 | 37.7773021497785 | -122.408796288569 | (37.7773021497785, -122.408796288569) | 8 | 2 | 9 | 28853 | 34 | |||
167377 | 116343 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 611 YORK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009887 | 2105445 | 37.7617086481783 | -122.408921539166 | (37.7617086481783, -122.408921539166) | 2 | 4 | 8 | 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 | |||
169289 | 113025 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 183 EDGEWOOD AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996556 | 2106005 | 37.7624905091914 | -122.455068303068 | (37.7624905091914, -122.455068303068) | 15 | 5 | 11 | 29492 | 12 | ||||
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 | ||
171462 | 102875 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2761 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
171574 | 108672 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
173983 | 108670 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
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 | ||||
175090 | 258068 | - 12 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 2700 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5991795.11646 | 2097053.50144 | 37.7376377360918 | -122.470882201509 | (37.7376377360918, -122.470882201509) | 1 | 8 | 4 | 29491 | 40 | |||||
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 | ||||
176160 | 116174 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
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 | |
176478 | 108673 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
177114 | 24373 | DPW Maintained 1 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005439.3271375 | 2108485.5635222 | 37.7698071707032 | -122.42452055163 | (37.7698071707032, -122.42452055163) | 8 | 4 | 5 | 28853 | 19 | |||
178820 | 108675 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 290x DORLAND ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003652 | 2105829 | 37.762411792447 | -122.430513287182 | (37.762411792447, -122.430513287182) | 8 | 4 | 5 | 28862 | 3 | |||
178958 | 116169 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
179967 | 104844 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 395X Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003932.8304 | 2096688.95118 | 37.7373312570435 | -122.428890347629 | (37.7373312570435, -122.428890347629) | 2 | 7 | 5 | 63 | 7 | |||
180509 | 113981 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
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 | ||
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 | |||
184431 | 116175 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
185037 | 113026 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 183 EDGEWOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996556 | 2106005 | 37.7624905091914 | -122.455068303068 | (37.7624905091914, -122.455068303068) | 15 | 5 | 11 | 29492 | 12 | ||||
185722 | 114530 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 31 BAY VIEW ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014415 | 2094670 | 37.7323753626402 | -122.392507164078 | (37.7323753626402, -122.392507164078) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
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 | ||||
189932 | 114531 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 31 BAY VIEW ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014415 | 2094670 | 37.7323753626402 | -122.392507164078 | (37.7323753626402, -122.392507164078) | 10 | 3 | 8 | 58 | 1 | ||||
191181 | 116120 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1649x NEWHALL ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x2 | 6014119 | 2095297 | 37.7340805339716 | -122.393574379436 | (37.7340805339716, -122.393574379436) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
191995 | 116176 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1786 CARROLL AVE | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x15 | 6013382 | 2092582 | 37.7265847203042 | -122.395932246796 | (37.7265847203042, -122.395932246796) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 |
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) );