trees
37 rows where qSpecies_id = 209 sorted by Supervisor Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15839 | 23554 | DPW Maintained 1 | Prunus spp :: Flowering Plum 209 | 2900X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 12 | 7x200 | 6005603.07732 | 2120439.4792 | 37.8026389039281 | -122.424804692283 | (37.8026389039281, -122.424804692283) | 5 | 9 | 1 | 28858 | 32 | |||
54402 | 46253 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 2161 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2002 12:00:00 AM | Permit Number 44539 | 6000422.21933345 | 2120600.45809947 | 37.8027869270392 | -122.442744582339 | (37.8027869270392, -122.442744582339) | 13 | 9 | 1 | 57 | 17 | |||
66065 | 49499 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 2 05th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2003 12:00:00 AM | 3x3 | Permit Number 46414 | 5994271.00866961 | 2115572.53954866 | 37.7886290700296 | -122.463665616673 | (37.7886290700296, -122.463665616673) | 11 | 6 | 1 | 54 | 11 | ||
39590 | 112840 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 390X FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009568 | 2121208 | 37.8049722148904 | -122.411138326504 | (37.8049722148904, -122.411138326504) | 3 | 1 | 10 | 308 | 23 | |||
61014 | 112834 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 390X FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6009568 | 2121208 | 37.8049722148904 | -122.411138326504 | (37.8049722148904, -122.411138326504) | 3 | 1 | 10 | 308 | 23 | |||
164925 | 112833 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 390X FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6009568 | 2121208 | 37.8049722148904 | -122.411138326504 | (37.8049722148904, -122.411138326504) | 3 | 1 | 10 | 308 | 23 | |||
9370 | 110531 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
16109 | 110528 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
30659 | 138782 | DPW Maintained 1 | Prunus spp :: Flowering Plum 209 | 1600 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003605.5991 | 2114290.1506 | 37.785641401605 | -122.431277765367 | (37.785641401605, -122.431277765367) | 13 | 9 | 11 | 29490 | 13 | |||
73491 | 50740 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 1342 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2004 12:00:00 AM | Permit Number 47289 | 5994283.18646849 | 2106374.99221952 | 37.7633757600059 | -122.462955918232 | (37.7633757600059, -122.462955918232) | 1 | 5 | 11 | 56 | 12 | |||
77119 | 48844 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 1448 Willard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46059 | 5996867.56750086 | 2106312.76767495 | 37.7633534302896 | -122.454012939619 | (37.7633534302896, -122.454012939619) | 15 | 5 | 11 | 29492 | 12 | |||
88497 | 110530 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
91829 | 48845 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 1448 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2002 12:00:00 AM | Permit Number 46059 | 5996867.56750086 | 2106312.76767495 | 37.7633534302896 | -122.454012939619 | (37.7633534302896, -122.454012939619) | 15 | 5 | 11 | 29492 | 12 | |||
104448 | 110529 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 1201X PAGE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000585 | 2109266 | 37.7716747202038 | -122.441367506705 | (37.7716747202038, -122.441367506705) | 15 | 5 | 11 | 29492 | 9 | ||||
135096 | 245005 | DPW Maintained 1 | Prunus spp :: Flowering Plum 209 | 1201X PAGE St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6000742.0786 | 2109265.2481 | 37.7716816027389 | -122.440824109665 | (37.7716816027389, -122.440824109665) | 15 | 5 | 11 | 29492 | 9 | |||
149601 | 51540 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 674 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2005 12:00:00 AM | Permit Number 47838 | 6004132.67430136 | 2111000.02371457 | 37.7766373865732 | -122.429219550092 | (37.7766373865732, -122.429219550092) | 7 | 9 | 11 | 28852 | 10 | |||
158767 | 50393 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 721 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47044 | 5997910.37931247 | 2108052.55231231 | 37.7681901749559 | -122.450531643961 | (37.7681901749559, -122.450531643961) | 15 | 5 | 11 | 29492 | 9 | |||
157032 | 50827 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 463 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/19/2004 12:00:00 AM | Permit Number 47346 | 5982193.64126412 | 2112664.09629578 | 37.7799400328538 | -122.505235150793 | (37.7799400328538, -122.505235150793) | 11 | 6 | 2 | 55 | 26 | ||
1948 | 113530 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 2598x 30TH AVE | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5987135 | 2097625 | 37.7389363086492 | -122.487036198648 | (37.7389363086492, -122.487036198648) | 1 | 8 | 3 | 29491 | 35 | ||||
20803 | 106041 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 1863 30TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5986871.4 | 2102587.7 | 37.752547180917 | -122.488312198386 | (37.752547180917, -122.488312198386) | 1 | 8 | 3 | 56 | 35 | |||||
67277 | 113529 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 2598x 30TH AVE | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5987135 | 2097625 | 37.7389363086492 | -122.487036198648 | (37.7389363086492, -122.487036198648) | 1 | 8 | 3 | 29491 | 35 | ||||
168848 | 113528 | DPW Maintained 1 | Prunus spp :: Flowering Plum 209 | 2598x 30TH AVE | 1 | Front Yard : Yard | Tree | Private 2 | 0 | 3x3 | 5987135 | 2097625 | 37.7389363086492 | -122.487036198648 | (37.7389363086492, -122.487036198648) | 1 | 8 | 3 | 29491 | 35 | |||
37208 | 40811 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 240 Maywood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41757 | 5994290.46519005 | 2095120.08849436 | 37.732473059968 | -122.462114481375 | (37.732473059968, -122.462114481375) | 9 | 8 | 4 | 59 | 40 | |||
76574 | 49330 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 240 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2003 12:00:00 AM | Permit Number 46323 | 5993821.72840823 | 2099372.81249517 | 37.7441229807574 | -122.464043606671 | (37.7441229807574, -122.464043606671) | 1 | 8 | 4 | 29491 | 40 | |||
94463 | 40855 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 279 Castenada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1999 12:00:00 AM | Permit Number 41777 | 5993975.46786533 | 2100273.51978571 | 37.7466049549422 | -122.463577369293 | (37.7466049549422, -122.463577369293) | 1 | 8 | 4 | 29491 | 40 | |||
167840 | 40854 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 279 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1999 12:00:00 AM | Permit Number 41777 | 5993975.46786533 | 2100273.51978571 | 37.7466049549422 | -122.463577369293 | (37.7466049549422, -122.463577369293) | 1 | 8 | 4 | 29491 | 40 | |||
22278 | 55517 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 1300 NOE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1978 12:00:00 AM | 20 | 20x9 | Permit Number 17224 | 6003188 | 2100604 | 37.7480388879628 | -122.431745016509 | (37.7480388879628, -122.431745016509) | 2 | 4 | 5 | 63 | 22 | |
89628 | 50182 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 201 Miguel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/18/2003 12:00:00 AM | Permit Number 46889 | 6004144.3554048 | 2096845.73705792 | 37.7377737257901 | -122.428170177932 | (37.7377737257901, -122.428170177932) | 2 | 7 | 5 | 63 | 7 | |||
124256 | 41648 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 2101 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/07/2000 12:00:00 AM | Permit Number 42120 | 6004156.40485232 | 2107641.60228879 | 37.767417323707 | -122.428897969573 | (37.767417323707, -122.428897969573) | 8 | 4 | 5 | 28862 | 3 | ||
24192 | 109019 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 111x 14th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
40239 | 109016 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 111x 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
57029 | 109018 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 111x 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007970.1 | 2107738.8 | 37.7678993280557 | -122.415713764528 | (37.7678993280557, -122.415713764528) | 8 | 4 | 7 | 28853 | 19 | ||||
82525 | 106933 | Undocumented 4 | Prunus spp :: Flowering Plum 209 | 2121 FOLSOM ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008239.2 | 2106082.2 | 37.7633658127111 | -122.414665728371 | (37.7633658127111, -122.414665728371) | 8 | 4 | 7 | 28859 | 19 | |||
178709 | 44780 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 245 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43879 | 6008107.11444951 | 2097451.94759538 | 37.7396616642552 | -122.414511844426 | (37.7396616642552, -122.414511844426) | 2 | 7 | 7 | 28859 | 2 | |||
185026 | 106686 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 167 BRUSSELS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010362.6 | 2093899.2 | 37.7300330299681 | -122.406463027526 | (37.7300330299681, -122.406463027526) | 10 | 3 | 7 | 309 | 28 | |||||
110055 | 178856 | DPW Maintained 1 | Prunus spp :: Flowering Plum 209 | 121 Delta St | 1 | Side Yard : Yard | Tree | Private 2 | 18 | Permit Number 779841 | 6009824.00265 | 2088991.81654 | 37.7165282333562 | -122.407979098955 | (37.7165282333562, -122.407979098955) | 9 | 7 | 8 | 309 | 39 | |||
77120 | 108682 | Permitted Site 7 | Prunus spp :: Flowering Plum 209 | 365X MAIN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015422.8 | 2115169.7 | 37.7887190478313 | -122.390454789278 | (37.7887190478313, -122.390454789278) | 6 | 2 | 9 | 28855 | 6 |
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) );