trees
246 rows where qSpecies_id = 20 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77498 | 38289 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 40 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40372 | 6007297.20256077 | 2106986.85810046 | 37.7657968225323 | -122.417987933805 | (37.7657968225323, -122.417987933805) | 8 | 4 | 7 | 28853 | 19 | ||
80931 | 41295 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 154 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41972 | 6006408.35563549 | 2106971.5871641 | 37.7657048266582 | -122.421061187567 | (37.7657048266582, -122.421061187567) | 8 | 4 | 7 | 28853 | 19 | ||
82639 | 38294 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
84061 | 229220 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 10 Lundys Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6007188.55641 | 2099623.37433 | 37.7455722705428 | -122.417841712947 | (37.7455722705428, -122.417841712947) | 2 | 7 | 7 | 28859 | 2 | |||
84940 | 68270 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 425 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | Permit Number 773761 | 6009804.05619 | 2092417.85671 | 37.7259343110037 | -122.408289550324 | (37.7259343110037, -122.408289550324) | 10 | 3 | 7 | 309 | 28 | |
86063 | 37843 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40136 | 6010376.80138594 | 2099288.55656196 | 37.7448318435542 | -122.406793605579 | (37.7448318435542, -122.406793605579) | 2 | 7 | 7 | 28859 | 2 | ||
90447 | 88832 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.7413024486906 | -122.41106600773 | (37.7413024486906, -122.41106600773) | 10 | 7 | 7 | 28859 | 2 | ||
98054 | 38287 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 32 Adair St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/1998 12:00:00 AM | Permit Number 40900 | 6007321.94599403 | 2106988.23094143 | 37.765801984592 | -122.417902448639 | (37.765801984592, -122.417902448639) | 8 | 4 | 7 | 28853 | 19 | ||
103553 | 41737 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1342-1344 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42176 | 6006947.20300055 | 2107647.30575448 | 37.767590551717 | -122.419245364711 | (37.767590551717, -122.419245364711) | 8 | 4 | 7 | 28853 | 19 | ||
104967 | 32521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 849 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 6 | Permit Number 37023 | 6007575.18526 | 2095405.75029 | 37.734013358015 | -122.416206150117 | (37.734013358015, -122.416206150117) | 2 | 7 | 7 | 28859 | 2 | |
108550 | 38292 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
109085 | 45276 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 518 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44119 | 6007993.51053318 | 2096451.22471646 | 37.7369075159799 | -122.414833833066 | (37.7369075159799, -122.414833833066) | 2 | 7 | 7 | 28859 | 2 | ||
109410 | 43909 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1179 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/2000 12:00:00 AM | Permit Number 43508 | 6008693.56566701 | 2101689.35157322 | 37.7513295663287 | -122.412783637177 | (37.7513295663287, -122.412783637177) | 2 | 4 | 7 | 28859 | 19 | ||
112424 | 38293 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40373 | 6007133.38425029 | 2106994.31986795 | 37.7658080895378 | -122.418555077027 | (37.7658080895378, -122.418555077027) | 8 | 4 | 7 | 28853 | 19 | ||
131472 | 246804 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 2 | : | Tree | Private 2 | 5 | Width 2ft | 6010378.07148 | 2099339.08892 | 37.7449706654762 | -122.406792774468 | (37.7449706654762, -122.406792774468) | 2 | 7 | 7 | 28859 | 2 | |||
133104 | 38288 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 40 Adair St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40372 | 6007297.20256077 | 2106986.85810046 | 37.7657968225323 | -122.417987933805 | (37.7657968225323, -122.417987933805) | 8 | 4 | 7 | 28853 | 19 | ||
134610 | 229240 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009167.29555 | 2098038.41743 | 37.7413314859486 | -122.410887588289 | (37.7413314859486, -122.410887588289) | 10 | 7 | 7 | 28859 | 2 | |||
135372 | 229238 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 35 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007492.54577 | 2099921.15591 | 37.7464070149728 | -122.416811654632 | (37.7464070149728, -122.416811654632) | 2 | 7 | 7 | 28859 | 2 | |||
135686 | 229230 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 265 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006749.35138 | 2102271.82416 | 37.7528195849561 | -122.419548287136 | (37.7528195849561, -122.419548287136) | 2 | 4 | 7 | 28859 | 19 | |||
136172 | 56244 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 259 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 3 | 3x4 | Permit Number 12370 | 6006755.08173393 | 2102278.34303033 | 37.752837807054 | -122.419528932935 | (37.752837807054, -122.419528932935) | 2 | 4 | 7 | 28859 | 19 | |
138010 | 95988 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 10 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2011 12:00:00 AM | 3x3 | Permit Number 767640 | 6007158.9 | 2099647 | 37.7456354723022 | -122.417945934991 | (37.7456354723022, -122.417945934991) | 2 | 7 | 7 | 28859 | 2 | ||
150998 | 229239 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009149.94921 | 2098041.78953 | 37.7413397723193 | -122.410947804196 | (37.7413397723193, -122.410947804196) | 10 | 7 | 7 | 28859 | 2 | |||
165989 | 229228 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 588 Ogden Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 4ft | 6007775.88717 | 2096147.34568 | 37.7360609002791 | -122.415564747312 | (37.7360609002791, -122.415564747312) | 2 | 7 | 7 | 28859 | 2 | |||
169759 | 229227 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 518 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008002.66712 | 2096426.21911 | 37.7368393705501 | -122.414800405411 | (37.7368393705501, -122.414800405411) | 2 | 7 | 7 | 28859 | 2 | |||
183542 | 27640 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2797 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2000 12:00:00 AM | 6 | 3X3 | 6009854.42856 | 2101083.40112 | 37.7497308499102 | -122.408726478761 | (37.7497308499102, -122.408726478761) | 2 | 4 | 7 | 28859 | 19 | ||
188919 | 88831 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2008 12:00:00 AM | 3x3 | Permit Number 51715 | 6009115.5 | 2098028.9 | 37.7413024486906 | -122.41106600773 | (37.7413024486906, -122.41106600773) | 10 | 7 | 7 | 28859 | 2 | ||
3119 | 264752 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
7535 | 264754 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
12536 | 43291 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 123 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2000 12:00:00 AM | 7 | Permit Number 43059 | 6013181.78147 | 2106427.07637 | 37.7645892203513 | -122.397595020318 | (37.7645892203513, -122.397595020318) | 14 | 3 | 8 | 28856 | 29 | |
17535 | 49781 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 308@ BLANKEN Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | 6 | Permit Number 46566 | 6012565.76433 | 2086991.30055 | 37.7111883387537 | -122.398361863208 | (37.7111883387537, -122.398361863208) | 10 | 3 | 8 | 309 | 1 | |
18449 | 264755 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 176 Hahn St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007577 | 2087516 | 37.7123498887131 | -122.4156414431 | (37.7123498887131, -122.4156414431) | 9 | 7 | 8 | 309 | 39 | ||||
23138 | 55180 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 91 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/04/1987 12:00:00 AM | 4 | Permit Number 24627 | 6013135.97557 | 2086935.85146 | 37.7110678340902 | -122.396387174153 | (37.7110678340902, -122.396387174153) | 10 | 3 | 8 | 309 | 1 | ||
30930 | 192814 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013571.38168 | 2106139.70119 | 37.7638218378314 | -122.396227345714 | (37.7638218378314, -122.396227345714) | 14 | 3 | 8 | 28856 | 29 | |||
33431 | 39987 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1430 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 6 | Permit Number 41245 | 6017109.13931221 | 2093820.25947236 | 37.7301913909688 | -122.383133682915 | (37.7301913909688, -122.383133682915) | 10 | 3 | 8 | 58 | 1 | |
70318 | 60303 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 678 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1982 12:00:00 AM | 6 | Permit Number 19870 | 6009154.33491 | 2088966.77185 | 37.7164219496995 | -122.410292044649 | (37.7164219496995, -122.410292044649) | 9 | 7 | 8 | 309 | 39 | ||
76611 | 229261 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2617 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009984.45916 | 2105005.31178 | 37.7605068225536 | -122.40855344831 | (37.7605068225536, -122.40855344831) | 2 | 4 | 8 | 28859 | 19 | |||
83083 | 40054 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1294 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41290 | 6016570.04020415 | 2092976.75616645 | 37.7278454926494 | -122.384938693931 | (37.7278454926494, -122.384938693931) | 10 | 3 | 8 | 58 | 1 | ||
87868 | 40029 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1637 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 3 | Permit Number 41272 | 6014869.44662 | 2095922.83463 | 37.7358406185575 | -122.391023557209 | (37.7358406185575, -122.391023557209) | 10 | 3 | 8 | 58 | 1 | |
105157 | 117202 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 298 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013997.81154 | 2105821.62372 | 37.7629721853348 | -122.394730166958 | (37.7629721853348, -122.394730166958) | 14 | 3 | 8 | 28856 | 29 | |||
142205 | 200499 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1082 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6013591.41 | 2089958.2062 | 37.7193919575312 | -122.395024624648 | (37.7193919575312, -122.395024624648) | 10 | 3 | 8 | 58 | 1 | |||
160329 | 117201 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 298 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013997.02726 | 2105851.29667 | 37.7630536171528 | -122.394734957662 | (37.7630536171528, -122.394734957662) | 14 | 3 | 8 | 28856 | 29 | |||
162731 | 27135 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1921 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1999 12:00:00 AM | 7 | 2X3 | 6011851.93655 | 2095690.98382 | 37.7350361003237 | -122.401440051024 | (37.7350361003237, -122.401440051024) | 10 | 3 | 8 | 58 | 1 | ||
178625 | 192813 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1251 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013542.5057 | 2106139.39713 | 37.7638193961669 | -122.396327198343 | (37.7638193961669, -122.396327198343) | 14 | 3 | 8 | 28856 | 29 | |||
184881 | 177297 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 175 Nueva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012935.72172 | 2087140.54754 | 37.7116187434797 | -122.397093648265 | (37.7116187434797, -122.397093648265) | 10 | 3 | 8 | 309 | 1 | |||
179310 | 42243 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 547 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.7792163405696 | -122.408779938797 | (37.7792163405696, -122.408779938797) | 14 | 2 | 9 | 28853 | 34 | ||
189499 | 42244 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 547 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42492 | 6010057.93942853 | 2111817.75656126 | 37.7792163405696 | -122.408779938797 | (37.7792163405696, -122.408779938797) | 14 | 2 | 9 | 28853 | 34 |
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) );