trees
33 rows where qSpecies_id = 262
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3583 | 111721 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 2 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
| 8741 | 196051 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 10 McLea Ct | 4 | : | Tree | Private 2 | 11 | Width 3ft | 6010059.73194 | 2109243.59053 | 37.7721483818683 | -122.408592099356 | (37.7721483818683, -122.408592099356) | 14 | 2 | 9 | 28853 | 34 | |||
| 10241 | 201203 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 700 Folsom St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 0ft | 6012613.1776 | 2113155.5665 | 37.7830324476743 | -122.40003423518 | (37.7830324476743, -122.40003423518) | 6 | 2 | 9 | 28853 | 34 | |||
| 18714 | 111970 | Undocumented 4 | Populus spp :: Poplar Spp 262 | 1x STORRIE ST | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | |||
| 27222 | 258201 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 598X Alemany Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||||
| 27908 | 195954 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 2421 Mendell St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 6013414.63482 | 2092942.60744 | 37.7275766906898 | -122.395844685983 | (37.7275766906898, -122.395844685983) | 10 | 3 | 8 | 58 | 1 | |||
| 31232 | 111969 | Undocumented 4 | Populus spp :: Poplar Spp 262 | 1x STORRIE ST | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
| 33311 | 258200 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 598X Alemany Blvd | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||||
| 54457 | 87343 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 501 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2008 12:00:00 AM | 28 | 3x3 | Permit Number 50334 | 6005378.8 | 2111039.4 | 37.776815969449 | -122.424911635128 | (37.776815969449, -122.424911635128) | 7 | 9 | 11 | 28852 | 10 | |
| 56306 | 200810 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 700 Folsom St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 0ft | 6012593.9836 | 2113138.6758 | 37.7829849995618 | -122.400099452375 | (37.7829849995618, -122.400099452375) | 6 | 2 | 9 | 28853 | 34 | |||
| 64526 | 111722 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
| 71797 | 256101 | Property Tree 8 | Populus spp :: Poplar Spp 262 | 1255 Oak St | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 6001013 | 2109627 | 37.7726903083913 | -122.439912920243 | (37.7726903083913, -122.439912920243) | 15 | 5 | 11 | 29492 | 9 | ||||
| 72502 | 16898 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 389 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 8 | 3X3 | 6005170.89461 | 2110180.50535 | 37.7744459083426 | -122.425569700541 | (37.7744459083426, -122.425569700541) | 7 | 9 | 11 | 28852 | 10 | ||
| 74470 | 111737 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 1856 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000232.462 | 2111322.6114 | 37.7773015647198 | -122.442734652887 | (37.7773015647198, -122.442734652887) | 15 | 5 | 11 | 29490 | 16 | |||
| 78458 | 93734 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 314 Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 10x3.5 | 6012069.81458 | 2087144.45151 | 37.7115812210645 | -122.400086747616 | (37.7115812210645, -122.400086747616) | 10 | 3 | 8 | 309 | 1 | |||
| 79856 | 201202 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 700 Folsom St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 6012631.6038 | 2113173.225 | 37.7830819611444 | -122.399971728129 | (37.7830819611444, -122.399971728129) | 6 | 2 | 9 | 28853 | 34 | |||
| 80241 | 200812 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 700 Folsom St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 0ft | 6012525.6531 | 2113074.1841 | 37.7828041102256 | -122.400331318039 | (37.7828041102256, -122.400331318039) | 6 | 2 | 9 | 28853 | 34 | |||
| 93373 | 196054 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 1698 Armstrong Ave | 1 | Front Yard : Yard | Tree | Private 2 | 22 | 6013977.61585 | 2092814.60739 | 37.7272565320487 | -122.393889484316 | (37.7272565320487, -122.393889484316) | 10 | 3 | 8 | 58 | 1 | ||||
| 94245 | 111724 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 5 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
| 101059 | 196056 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 2399 Lane St | 2 | Side Yard : Yard | Tree | Private 2 | 20 | 6013962.89137 | 2092855.96285 | 37.7273692674706 | -122.393943280856 | (37.7273692674706, -122.393943280856) | 10 | 3 | 8 | 58 | 1 | ||||
| 104641 | 113894 | Undocumented 4 | Populus spp :: Poplar Spp 262 | 1x STORRIE ST | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | |||
| 106380 | 201201 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 700 Folsom St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 0ft | 6012655.4043 | 2113195.49 | 37.7831444225813 | -122.399890951556 | (37.7831444225813, -122.399890951556) | 6 | 2 | 9 | 28853 | 34 | |||
| 109267 | 111723 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 4 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
| 111763 | 245851 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 387 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005165.6973 | 2110226.7645 | 37.7745726310598 | -122.425590972035 | (37.7745726310598, -122.425590972035) | 7 | 9 | 11 | 28852 | 10 | |||
| 113111 | 113895 | Undocumented 4 | Populus spp :: Poplar Spp 262 | 1x STORRIE ST | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | |||
| 129888 | 196050 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 10 McLea Ct | 1 | : | Tree | Private 2 | 15 | Width 3ft | 6010085.91639 | 2109269.38137 | 37.7722206639802 | -122.408503344349 | (37.7722206639802, -122.408503344349) | 14 | 2 | 9 | 28853 | 34 | |||
| 139544 | 104085 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 1329 Stanyan St | 1 | Front Yard : Yard | Tree | Private 2 | 08/07/2013 12:00:00 AM | Permit Number 770194 | 5997530.4 | 2104741.3 | 37.7590765601241 | -122.451607069148 | (37.7590765601241, -122.451607069148) | 15 | 5 | 4 | 28862 | 12 | |||
| 156063 | 234870 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 77 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008161.52815 | 2098236.22134 | 37.7418181639891 | -122.414379182749 | (37.7418181639891, -122.414379182749) | 2 | 7 | 7 | 28859 | 2 | |||
| 161968 | 113896 | Undocumented 4 | Populus spp :: Poplar Spp 262 | 1x STORRIE ST | 28 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | |||
| 163996 | 258199 | Significant Tree 6 | Populus spp :: Poplar Spp 262 | 598X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6006099.613365 | 2094764.868461 | 37.732170557365 | -122.421262171784 | (37.732170557365, -122.421262171784) | 2 | 7 | 7 | 28861 | 2 | ||||
| 170363 | 201205 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 700 Folsom St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 0ft | 6012507.9947 | 2113054.9902 | 37.7827504235263 | -122.400391060455 | (37.7827504235263, -122.400391060455) | 6 | 2 | 9 | 28853 | 34 | |||
| 174529 | 201204 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 700 Folsom St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 24 | Width 0ft | 6012574.7897 | 2113119.4819 | 37.7829312273653 | -122.400164507332 | (37.7829312273653, -122.400164507332) | 6 | 2 | 9 | 28853 | 34 | |||
| 183314 | 196055 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 1698 Armstrong Ave | 2 | Front Yard : Yard | Tree | Private 2 | 28 | 6013969.15001 | 2092819.20952 | 37.7272686980793 | -122.393919072915 | (37.7272686980793, -122.393919072915) | 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) );