trees
42 rows where qSpecies_id = 354
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12903 | 258678 | Undocumented 4 | Ulmus 'Prospector' :: Prospector Elm 354 | 598X Dewey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994262 | 2099558 | 37.7446568233288 | -122.462534686315 | (37.7446568233288, -122.462534686315) | 1 | 8 | 4 | 59 | 40 | ||||
18861 | 215956 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 90 Marcela Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 4ft | 5994588.83347 | 2100601.43435 | 37.7475406481854 | -122.46148020007 | (37.7475406481854, -122.46148020007) | 1 | 8 | 4 | 29491 | 40 | |||
19210 | 258682 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 65 Lopez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 0ft | 5993986.53674 | 2100544.36079 | 37.7473492535732 | -122.463558747362 | (37.7473492535732, -122.463558747362) | 1 | 8 | 4 | 29491 | 40 | ||||
21492 | 26625 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1285X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011577.7605432 | 2093254.4735551 | 37.7283306504833 | -122.402216731645 | (37.7283306504833, -122.402216731645) | 10 | 3 | 8 | 58 | 1 | ||
25677 | 26621 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1287 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011580.6766762 | 2093245.3904793 | 37.7283058730155 | -122.402206012046 | (37.7283058730155, -122.402206012046) | 10 | 3 | 8 | 58 | 1 | ||
26370 | 26622 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1287 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011580.6766762 | 2093245.3904793 | 37.7283058730155 | -122.402206012046 | (37.7283058730155, -122.402206012046) | 10 | 3 | 8 | 58 | 1 | ||
33237 | 26630 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1099X Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 6 | 3x3 | 6011264.5101367 | 2094143.9045995 | 37.7307553523476 | -122.403362203504 | (37.7307553523476, -122.403362203504) | 10 | 3 | 8 | 58 | 1 | ||
37474 | 26573 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 355 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6010658.7520522 | 2098287.1955653 | 37.742098094898 | -122.4057481481 | (37.742098094898, -122.4057481481) | 10 | 3 | 8 | 58 | 1 | ||
40690 | 26592 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1641 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6012044.29404 | 2091348.95121 | 37.723124507518 | -122.400470100871 | (37.723124507518, -122.400470100871) | 10 | 3 | 8 | 58 | 1 | ||
41486 | 26633 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1099X Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 3 | 3x3 | 6011264.5101367 | 2094143.9045995 | 37.7307553523476 | -122.403362203504 | (37.7307553523476, -122.403362203504) | 10 | 3 | 8 | 58 | 1 | ||
43560 | 26588 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1689 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6012152.58041 | 2090999.78087 | 37.7221717951322 | -122.400071264268 | (37.7221717951322, -122.400071264268) | 10 | 3 | 8 | 58 | 1 | ||
47306 | 10858 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1299X HUDSON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/09/1998 12:00:00 AM | 3 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
78024 | 10828 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1139X Hudson Ave | 35 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X4 | 6017877.50401 | 2094618.75301 | 37.7324263269122 | -122.380532796123 | (37.7324263269122, -122.380532796123) | 10 | 3 | 8 | 58 | 1 | ||
78066 | 26587 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1689 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6012155.56121 | 2090982.84738 | 37.722125465409 | -122.400059771692 | (37.722125465409, -122.400059771692) | 10 | 3 | 8 | 58 | 1 | ||
82649 | 26631 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1099X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 6 | 3x3 | 6011264.5101367 | 2094143.9045995 | 37.7307553523476 | -122.403362203504 | (37.7307553523476, -122.403362203504) | 10 | 3 | 8 | 58 | 1 | ||
86190 | 10802 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1139X Hudson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 10 | 3X4 | 6017516.82701 | 2094854.43001 | 37.7330535397707 | -122.381796140074 | (37.7330535397707, -122.381796140074) | 10 | 3 | 8 | 58 | 1 | ||
86713 | 26623 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1285X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011577.7605432 | 2093254.4735551 | 37.7283306504833 | -122.402216731645 | (37.7283306504833, -122.402216731645) | 10 | 3 | 8 | 58 | 1 | ||
88560 | 26620 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1291 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011586.2312153 | 2093228.0893826 | 37.728258677836 | -122.402185593782 | (37.728258677836, -122.402185593782) | 10 | 3 | 8 | 58 | 1 | ||
91745 | 26584 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1799X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/1998 12:00:00 AM | 6 | 3x3 | 6012271.06402 | 2090627.31189 | 37.7211556763389 | -122.399635553716 | (37.7211556763389, -122.399635553716) | 10 | 3 | 8 | 58 | 1 | ||
101599 | 26597 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1587 Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6011950.6493597 | 2091636.7727547 | 37.723909583861 | -122.400814025253 | (37.723909583861, -122.400814025253) | 10 | 3 | 8 | 58 | 1 | ||
111803 | 26627 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1175 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/1998 12:00:00 AM | 10 | 3X3 | 6011420.37467 | 2093734.24789 | 37.7296392246522 | -122.402794552619 | (37.7296392246522, -122.402794552619) | 10 | 3 | 8 | 58 | 1 | ||
114653 | 10871 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/09/1998 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
115193 | 23647 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 205 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/13/1998 12:00:00 AM | 12 | 3x3 | 6006710.5618045 | 2098464.2835012 | 37.74236275595 | -122.41941233416 | (37.74236275595, -122.41941233416) | 2 | 7 | 7 | 28859 | 2 | ||
116740 | 25443 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 2157 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6011805.96604 | 2087487.58241 | 37.7125086752638 | -122.40102277785 | (37.7125086752638, -122.40102277785) | 10 | 3 | 8 | 309 | 1 | ||
119916 | 26595 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1641 Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6012023.31681 | 2091412.97114 | 37.7232991233056 | -122.400547110399 | (37.7232991233056, -122.400547110399) | 10 | 3 | 8 | 58 | 1 | ||
126357 | 11314 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1216X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/1998 12:00:00 AM | 8 | 3X3 | 6017561.7867095 | 2093983.7658262 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | 10 | 3 | 8 | 58 | 1 | ||
126961 | 26571 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 355 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:34:00 PM | 3 | 3X3 | 6010658.7520522 | 2098287.1955653 | 37.742098094898 | -122.4057481481 | (37.742098094898, -122.4057481481) | 10 | 3 | 8 | 58 | 1 | ||
134918 | 10865 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1275X HUDSON AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 6 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
137767 | 26626 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1285X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011577.7605432 | 2093254.4735551 | 37.7283306504833 | -122.402216731645 | (37.7283306504833, -122.402216731645) | 10 | 3 | 8 | 58 | 1 | ||
139314 | 26577 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 345 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1998 12:00:00 AM | 6 | 3X3 | 6010697.3878905 | 2098349.5702175 | 37.7422715227695 | -122.405618949101 | (37.7422715227695, -122.405618949101) | 10 | 3 | 8 | 58 | 1 | ||
143920 | 26575 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 345 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1998 12:00:00 AM | 6 | 5 | 6010697.3878905 | 2098349.5702175 | 37.7422715227695 | -122.405618949101 | (37.7422715227695, -122.405618949101) | 10 | 3 | 8 | 58 | 1 | ||
163326 | 10803 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1139X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 8 | 3x4 | 6017525.94101 | 2094844.01301 | 37.7330254400126 | -122.381763905983 | (37.7330254400126, -122.381763905983) | 10 | 3 | 8 | 58 | 1 | ||
163367 | 33985 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 205 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1997 12:00:00 AM | 3x3 | Permit Number 37927 | 6006711.00483305 | 2098465.18063871 | 37.7423652442414 | -122.419410865929 | (37.7423652442414, -122.419410865929) | 2 | 7 | 7 | 28859 | 2 | ||
171885 | 25436 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 2555 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6010748.9210869 | 2086419.1045134 | 37.7095158271004 | -122.404601102054 | (37.7095158271004, -122.404601102054) | 10 | 3 | 8 | 309 | 1 | ||
172283 | 26632 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1099X Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/1998 12:00:00 AM | 6 | 3x3 | 6011264.5101367 | 2094143.9045995 | 37.7307553523476 | -122.403362203504 | (37.7307553523476, -122.403362203504) | 10 | 3 | 8 | 58 | 1 | ||
173323 | 25435 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 2555 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/1997 12:00:00 AM | 3 | 3X3 | 6010769.38234 | 2086480.89286 | 37.7096866290477 | -122.404534730683 | (37.7096866290477, -122.404534730683) | 10 | 3 | 8 | 309 | 1 | ||
177486 | 26594 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1641 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1998 12:00:00 AM | 3 | 3X3 | 6012028.09993 | 2091395.08785 | 37.7232502861947 | -122.400529320352 | (37.7232502861947, -122.400529320352) | 10 | 3 | 8 | 58 | 1 | ||
181242 | 26624 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1285X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011577.7605432 | 2093254.4735551 | 37.7283306504833 | -122.402216731645 | (37.7283306504833, -122.402216731645) | 10 | 3 | 8 | 58 | 1 | ||
185877 | 10827 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1139X Hudson Ave | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 3X4 | 6017856.67001 | 2094625.26301 | 37.732443052397 | -122.380605277249 | (37.732443052397, -122.380605277249) | 10 | 3 | 8 | 58 | 1 | ||
188332 | 10860 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1299X HUDSON AVE | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/06/1997 12:00:00 AM | 3 | 3X4 | 6017281 | 2095243 | 37.734107450868 | -122.382638493216 | (37.734107450868, -122.382638493216) | 10 | 3 | 8 | 58 | 1 | ||
191875 | 11311 | DPW Maintained 1 | Ulmus 'Prospector' :: Prospector Elm 354 | 1216X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/25/1998 12:00:00 AM | 8 | 3X3 | 6017561.7867095 | 2093983.7658262 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | 10 | 3 | 8 | 58 | 1 | ||
191881 | 26598 | Permitted Site 7 | Ulmus 'Prospector' :: Prospector Elm 354 | 1587 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1998 12:00:00 AM | 6 | 3X3 | 6011950.6493597 | 2091636.7727547 | 37.723909583861 | -122.400814025253 | (37.723909583861, -122.400814025253) | 10 | 3 | 8 | 58 | 1 |
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) );