trees
39 rows where qSpecies_id = 128 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
177184 | 255317 | Undocumented 4 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 200x 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
176808 | 86624 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010883.02334 | 2109759.81343 | 37.7736118855124 | -122.405780619884 | (37.7736118855124, -122.405780619884) | 14 | 2 | 9 | 28853 | 34 | ||
170196 | 255470 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
165211 | 14666 | Permitted Site 7 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 714 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2007 12:00:00 AM | 3 | 4x4 | 6005700.53435 | 2112083.57003 | 37.7797011734876 | -122.42387292416 | (37.7797011734876, -122.42387292416) | 7 | 9 | 11 | 28852 | 41 | ||
153871 | 255321 | Undocumented 4 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 200x 10th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
153561 | 86622 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 930 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010974.49101 | 2109846.6671 | 37.7738554803892 | -122.405470335808 | (37.7738554803892, -122.405470335808) | 14 | 2 | 9 | 28853 | 34 | ||
152616 | 86621 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 930 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010943.48703 | 2109819.00642 | 37.7737777969396 | -122.405575635607 | (37.7737777969396, -122.405575635607) | 14 | 2 | 9 | 28853 | 34 | ||
149273 | 255318 | Undocumented 4 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 200x 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
138994 | 87544 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 2633 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/06/2015 02:30:00 PM | 3 | 3x3 | 6011111.3256 | 2093302.3089 | 37.7284359494724 | -122.403832591411 | (37.7284359494724, -122.403832591411) | 10 | 3 | 7 | 309 | 28 | ||
121978 | 255456 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 5 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
110210 | 86626 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010925.67942 | 2109801.58517 | 37.7737289664413 | -122.405636007996 | (37.7737289664413, -122.405636007996) | 14 | 2 | 9 | 28853 | 34 | ||
110013 | 255471 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 9 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
105901 | 255323 | Undocumented 4 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 200x 10th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
101093 | 255322 | Undocumented 4 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 200x 10th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
87542 | 83391 | Permitted Site 7 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 96 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52351 | 6014310.58263087 | 2094108.91217505 | 37.7308289302696 | -122.392828922233 | (37.7308289302696, -122.392828922233) | 10 | 3 | 8 | 58 | 1 | ||
69399 | 82993 | Permitted Site 7 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1326 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52356 | 6016552.575661 | 2093339.01207111 | 37.7288392099229 | -122.385024298281 | (37.7288392099229, -122.385024298281) | 10 | 3 | 8 | 58 | 1 | ||
68696 | 86625 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010895.2675 | 2109773.10415 | 37.7736490634866 | -122.405739201611 | (37.7736490634866, -122.405739201611) | 14 | 2 | 9 | 28853 | 34 | ||
61249 | 255468 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 6 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
54595 | 255319 | Undocumented 4 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 200x 10th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
51814 | 255320 | Undocumented 4 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 200x 10th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008367 | 2109860 | 37.773745949403 | -122.414491044326 | (37.773745949403, -122.414491044326) | 8 | 2 | 9 | 28853 | 34 | ||||
46362 | 86627 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 900X Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6011099.26328 | 2109964.5705 | 37.7741861916712 | -122.405047029392 | (37.7741861916712, -122.405047029392) | 14 | 2 | 9 | 28853 | 34 | ||
29038 | 86623 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 950 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 04/13/2007 12:00:00 AM | 3 | 3x3 | 6010870.62173 | 2109748.7492 | 37.7735808121462 | -122.405822739627 | (37.7735808121462, -122.405822739627) | 14 | 2 | 9 | 28853 | 34 | ||
19084 | 255469 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3101 San Bruno Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | Width 0ft | 6011789.9977 | 2091083.3506 | 37.722381037733 | -122.401330502391 | (37.722381037733, -122.401330502391) | 10 | 3 | 7 | 309 | 28 | ||||
18215 | 259278 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1600x Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/22/2018 12:00:00 AM | 3 | ||||||||||||
16634 | 260615 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1799x Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
14503 | 240533 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 3250 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2020 12:00:00 AM | 3 | Width 3ft | 6006625.63728 | 2103804.91247 | 37.7570221231963 | -122.420084904521 | (37.7570221231963, -122.420084904521) | 2 | 4 | 7 | 28859 | 19 | ||
13985 | 259279 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1600x Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
13653 | 259360 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1699x Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | ||||||||||||
13531 | 153686 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 2270 Jerrold Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011939.91411 | 2099578.75428 | 37.7457160010972 | -122.401409013634 | (37.7457160010972, -122.401409013634) | 10 | 3 | 8 | 58 | 1 | |||
11475 | 259367 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1642 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | 6014931.68657 | 2094537.59816 | 37.7320404940749 | -122.390711594417 | (37.7320404940749, -122.390711594417) | 10 | 3 | 8 | 58 | 1 | ||
11029 | 260616 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1799x Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
10768 | 153683 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 2270 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2018 12:00:00 AM | 3 | 4x5 | 6012073.90061 | 2099479.48912 | 37.7454509151246 | -122.400938732042 | (37.7454509151246, -122.400938732042) | 10 | 3 | 8 | 58 | 1 | ||
9635 | 260617 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1799x Indiana St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 09/21/2019 12:00:00 AM | 3 | |||||||||||||
9287 | 153684 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 2270 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011989.83943 | 2099540.55556 | 37.7456139010699 | -122.401233694387 | (37.7456139010699, -122.401233694387) | 10 | 3 | 8 | 58 | 1 | |||
6783 | 153685 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 2270 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011963.89438 | 2099561.89223 | 37.7456710394792 | -122.401324908126 | (37.7456710394792, -122.401324908126) | 10 | 3 | 8 | 58 | 1 | |||
5679 | 259398 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1493 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5x5 | 6015791.94251 | 2095245.69488 | 37.7340324759476 | -122.38778686519 | (37.7340324759476, -122.38778686519) | 10 | 3 | 8 | 58 | 1 | |
3203 | 259365 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1624 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | 6014998.44757 | 2094487.89709 | 37.7319077287371 | -122.390477313703 | (37.7319077287371, -122.390477313703) | 10 | 3 | 8 | 58 | 1 | ||
2822 | 153687 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 2270 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011853.81258 | 2099640.54453 | 37.7458808594256 | -122.401711084218 | (37.7458808594256, -122.401711084218) | 10 | 3 | 8 | 58 | 1 | |||
663 | 259361 | DPW Maintained 1 | Acer rubrum 'October Glory' :: Red October Glory Maple 128 | 1699x Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 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) );