trees
246 rows where qSpecies_id = 20
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157092 | 97121 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
| 157847 | 124522 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 51 Parsons St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996562.78722 | 2110517.36103 | 37.7748806768667 | -122.455370959381 | (37.7748806768667, -122.455370959381) | 11 | 6 | 2 | 54 | 16 | |||
| 158347 | 49979 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | Permit Number 46730 | 6000660.24856199 | 2091684.26047151 | 37.7234037567812 | -122.43984643001 | (37.7234037567812, -122.43984643001) | 9 | 7 | 6 | 28861 | 25 | ||
| 158951 | 229250 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 396 Cumberland St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6003147.80925 | 2104494.52044 | 37.7587190575556 | -122.432161790553 | (37.7587190575556, -122.432161790553) | 2 | 4 | 5 | 28862 | 3 | |||
| 159123 | 1680 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 400 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/1998 12:00:00 AM | 12 | 3X3 | 5994348.50119 | 2111464.79497 | 37.7773547778944 | -122.463099340943 | (37.7773547778944, -122.463099340943) | 11 | 6 | 2 | 54 | 11 | ||
| 159246 | 46338 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3703 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2002 12:00:00 AM | Permit Number 44587 | 6005824.5079347 | 2100789.51596522 | 37.7486973702763 | -122.422641242993 | (37.7486973702763, -122.422641242993) | 2 | 4 | 5 | 28859 | 19 | ||
| 159248 | 177299 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001664.56674 | 2087607.40628 | 37.7122667427937 | -122.43608309818 | (37.7122667427937, -122.43608309818) | 9 | 7 | 6 | 28861 | 5 | |||
| 159254 | 38335 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 444 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/2017 12:00:00 AM | 3 | Permit Number 47950 | 5983475.92441 | 2112817.71297 | 37.7804371865901 | -122.500810595919 | (37.7804371865901, -122.500810595919) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 160538 | 17695 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1100X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2004 12:00:00 AM | 3 | 3X3 | 6002388.932052 | 2112303.174651 | 37.7801166436013 | -122.435344894499 | (37.7801166436013, -122.435344894499) | 15 | 5 | 11 | 29490 | 41 | ||
| 160681 | 38834 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 254 Clement St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | Permit Number 40666 | 5994768.12752284 | 2113559.99820217 | 37.7831318083177 | -122.461799686207 | (37.7831318083177, -122.461799686207) | 11 | 6 | 2 | 54 | 11 | ||
| 161225 | 41119 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2344 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | 11 | 5 | 2 | 54 | 16 | ||
| 161934 | 114095 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 424 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2015 12:00:00 AM | 3 | 3x3 | 5998448.01058 | 2087544.4934 | 37.7119107326703 | -122.44719590289 | (37.7119107326703, -122.44719590289) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | ||
| 164273 | 208552 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Vernon St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 5992432.90306 | 2088632.12991 | 37.7145515909498 | -122.468064688039 | (37.7145515909498, -122.468064688039) | 9 | 8 | 6 | 64 | 24 | |||
| 164546 | 208548 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 150 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 5995469.48283 | 2089658.18964 | 37.7175438071807 | -122.457643306389 | (37.7175438071807, -122.457643306389) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 166087 | 48710 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | Permit Number 45977 | 6002865.90865477 | 2096146.69511849 | 37.735781899273 | -122.432540466241 | (37.735781899273, -122.432540466241) | 2 | 7 | 5 | 63 | 7 | |||
| 169626 | 229233 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 4233 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002320.97141 | 2101183.15228 | 37.7495799175888 | -122.434784573367 | (37.7495799175888, -122.434784573367) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 169767 | 48596 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2828 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45906 | 6006109.55880525 | 2120479.22122038 | 37.8027766188477 | -122.423054835322 | (37.8027766188477, -122.423054835322) | 5 | 9 | 1 | 28858 | 32 | ||
| 171110 | 177290 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 231 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004061.30791 | 2089085.46996 | 37.7164610594049 | -122.427904501587 | (37.7164610594049, -122.427904501587) | 9 | 7 | 6 | 28861 | 5 | |||
| 171270 | 208540 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1205 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995843.60881 | 2092100.29717 | 37.7242707405805 | -122.456526632611 | (37.7242707405805, -122.456526632611) | 9 | 7 | 4 | 28861 | 40 | |||
| 174917 | 229234 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 909 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6000533.75366 | 2101957.19594 | 37.751603625115 | -122.441020338428 | (37.751603625115, -122.441020338428) | 2 | 4 | 5 | 28862 | 22 | |||
| 175958 | 13062 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.411324605789 | (37.8031495768645, -122.411324605789) | 3 | 1 | 10 | 308 | 23 | ||
| 176947 | 130433 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 550 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6004538.94577 | 2111043.55474 | 37.776779903004 | -122.427817240371 | (37.776779903004, -122.427817240371) | 7 | 9 | 11 | 28852 | 10 | |||
| 177265 | 21847 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 202X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2000 12:00:00 AM | 3 | 3X3 | 5994968.90714 | 2110807.33222 | 37.7755852784786 | -122.460905507707 | (37.7755852784786, -122.460905507707) | 11 | 6 | 2 | 54 | 11 | ||
| 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 | |||
| 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 | ||
| 180489 | 208541 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1201 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5995841.38448 | 2092081.24928 | 37.7242183119117 | -122.456532944957 | (37.7242183119117, -122.456532944957) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | ||
| 184176 | 208546 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5996523.78627 | 2089975.89779 | 37.7184766676518 | -122.454022014422 | (37.7184766676518, -122.454022014422) | 9 | 8 | 6 | 28861 | 24 | |||
| 184259 | 97120 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
| 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 | |||
| 185492 | 44220 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2001 12:00:00 AM | 2 | Permit Number 43665 | 5987262.4786 | 2100698.6187 | 37.74738308124 | -122.486821088856 | (37.74738308124, -122.486821088856) | 1 | 8 | 3 | 29491 | 35 | ||
| 186826 | 254204 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781022 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | |
| 187310 | 37270 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 3722 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39810 | 6003578.77249291 | 2103641.69607352 | 37.7564018297216 | -122.43061046837 | (37.7564018297216, -122.43061046837) | 2 | 4 | 5 | 28862 | 3 | ||
| 187508 | 229254 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 157 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001282.99504 | 2106223.75237 | 37.7633611996826 | -122.438735069383 | (37.7633611996826, -122.438735069383) | 15 | 5 | 5 | 28862 | 3 | |||
| 188519 | 253691 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Haight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005848 | 2109690 | 37.7731373345919 | -122.423192587546 | (37.7731373345919, -122.423192587546) | 7 | 9 | 11 | 28852 | 10 | ||||
| 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 | ||
| 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 | ||
| 190510 | 41121 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2344 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1999 12:00:00 AM | Permit Number 41865 | 5996582.9529178 | 2110470.59190578 | 37.7747534181142 | -122.455297821718 | (37.7747534181142, -122.455297821718) | 11 | 5 | 2 | 54 | 16 | ||
| 190537 | 123699 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 302 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994616.48583 | 2111473.74211 | 37.777394777876 | -122.462172950615 | (37.777394777876, -122.462172950615) | 11 | 6 | 2 | 54 | 11 | |||
| 190649 | 229222 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 67 Guerrero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005445.58133 | 2108574.74537 | 37.7700523958333 | -122.424505263025 | (37.7700523958333, -122.424505263025) | 8 | 2 | 5 | 28853 | 19 | |||
| 193435 | 45082 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2143 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | Permit Number 43964 | 5987260.68011287 | 2100690.67520581 | 37.7473611656774 | -122.486826724588 | (37.7473611656774, -122.486826724588) | 1 | 8 | 3 | 29491 | 35 | ||
| 193889 | 253690 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005848 | 2109690 | 37.7731373345919 | -122.423192587546 | (37.7731373345919, -122.423192587546) | 7 | 9 | 11 | 28852 | 10 |
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) );