trees
246 rows where qSpecies_id = 20 sorted by Police Districts 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5802 | 62147 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2057 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/06/1985 12:00:00 AM | 3 | Permit Number 22261 | 5999361.52655 | 2121151.92571 | 37.8042405839018 | -122.446454803956 | (37.8042405839018, -122.446454803956) | 13 | 9 | 1 | 57 | 17 | |
| 20359 | 111160 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003321.77346 | 2119803.50555 | 37.8007635719416 | -122.432653690929 | (37.8007635719416, -122.432653690929) | 13 | 9 | 1 | 57 | 17 | |||
| 35594 | 111164 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003392.25539 | 2119813.00098 | 37.8007936407819 | -122.432410472862 | (37.8007936407819, -122.432410472862) | 13 | 9 | 1 | 57 | 17 | |||
| 38852 | 85278 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 506 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49567 | 6004562 | 2110191 | 37.7744403005412 | -122.427676731417 | (37.7744403005412, -122.427676731417) | 7 | 9 | 11 | 28852 | 10 | |||
| 41793 | 253689 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 60 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005848 | 2109690 | 37.7731373345919 | -122.423192587546 | (37.7731373345919, -122.423192587546) | 7 | 9 | 11 | 28852 | 10 | ||||
| 52323 | 130435 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2127 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6003305.56754 | 2117513.80582 | 37.7944757298119 | -122.432546129322 | (37.7944757298119, -122.432546129322) | 13 | 9 | 1 | 29490 | 27 | |||
| 58828 | 110905 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2891 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2015 12:00:00 AM | 3 | 3x10 | Permit Number 775210 | 5999766.16076 | 2117386.55705 | 37.7939249895015 | -122.444783719687 | (37.7939249895015, -122.444783719687) | 13 | 9 | 1 | 57 | 27 | |
| 64224 | 130432 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2824 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999398.65268 | 2118424.75751 | 37.7967546325742 | -122.446130041675 | (37.7967546325742, -122.446130041675) | 13 | 9 | 1 | 57 | 17 | |||
| 85882 | 18881 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2323 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2009 12:00:00 AM | 3 | 2X2 | 6003542.78856 | 2115901.08421 | 37.7900610577291 | -122.431610123004 | (37.7900610577291, -122.431610123004) | 13 | 9 | 1 | 29490 | 27 | ||
| 107681 | 111163 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003374.28365 | 2119810.99129 | 37.8007871036097 | -122.432472518919 | (37.8007871036097, -122.432472518919) | 13 | 9 | 1 | 57 | 17 | |||
| 117311 | 111161 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6003338.31122 | 2119805.54449 | 37.8007701082019 | -122.432596609162 | (37.8007701082019, -122.432596609162) | 13 | 9 | 1 | 57 | 17 | |||
| 120165 | 48972 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 135 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 46159 | 6003310.63727526 | 2108787.86549198 | 37.7705167748166 | -122.431905219461 | (37.7705167748166, -122.431905219461) | 15 | 9 | 5 | 29492 | 9 | ||
| 126173 | 111165 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6003411.20248 | 2119815.94235 | 37.8008027913768 | -122.432345118256 | (37.8008027913768, -122.432345118256) | 13 | 9 | 1 | 57 | 17 | |||
| 130401 | 10238 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 48 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/29/2017 12:00:00 AM | 3 | 3X3 | 6005948.4469202 | 2109689.9882841 | 37.7731429705185 | -122.422845127343 | (37.7731429705185, -122.422845127343) | 7 | 9 | 11 | 28852 | 10 | ||
| 137511 | 111162 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 99X Magnolia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6003355.09781 | 2119808.05454 | 37.8007779520905 | -122.4325387 | (37.8007779520905, -122.4325387) | 13 | 9 | 1 | 57 | 17 | |||
| 137574 | 16869 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 251 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52092 | 6005763.06398 | 2110312.25693 | 37.774841108223 | -122.423530640295 | (37.774841108223, -122.423530640295) | 7 | 9 | 11 | 28852 | 10 | |
| 139619 | 16927 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 516 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | 3 | 3X3 | 6004360.99062 | 2110167.09094 | 37.7743632798821 | -122.428370356734 | (37.7743632798821, -122.428370356734) | 7 | 9 | 11 | 28852 | 10 | ||
| 155003 | 253692 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 68 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005803 | 2109684 | 37.7731183204112 | -122.423347821955 | (37.7731183204112, -122.423347821955) | 7 | 9 | 11 | 28852 | 10 | ||||
| 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 | ||
| 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 | |||
| 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 | ||||
| 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 | ||||
| 22680 | 46900 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1357 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44956 | 5991106.29954004 | 2106174.99705817 | 37.7626431240146 | -122.473929035532 | (37.7626431240146, -122.473929035532) | 1 | 8 | 11 | 56 | 12 | ||
| 30898 | 254205 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1766 44th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 5982566.32735 | 2103096.10961 | 37.7536910129268 | -122.503237266994 | (37.7536910129268, -122.503237266994) | 1 | 8 | 3 | 56 | 35 | ||||
| 40861 | 85261 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2998 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989779.1 | 2095328.3 | 37.7327839760928 | -122.477726384657 | (37.7327839760928, -122.477726384657) | 1 | 8 | 4 | 64 | 35 | |||
| 48235 | 38441 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2591 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1998 12:00:00 AM | Permit Number 40466 | 5992043.6333811 | 2097820.82323466 | 37.7397589768558 | -122.470078824326 | (37.7397589768558, -122.470078824326) | 1 | 8 | 4 | 59 | 40 | |||
| 58877 | 208545 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 12 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5996523.6042 | 2089967.17912 | 37.7184527177873 | -122.454022014425 | (37.7184527177873, -122.454022014425) | 9 | 8 | 6 | 28861 | 24 | |||
| 63410 | 208550 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 498 Vernon St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992503.57103 | 2091183.80618 | 37.7215619556104 | -122.468005927235 | (37.7215619556104, -122.468005927235) | 9 | 8 | 6 | 64 | 24 | |||
| 77081 | 44219 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2139 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Permit Number 43665 | 5987260.984 | 2100720.2895 | 37.7474424963194 | -122.486827848138 | (37.7474424963194, -122.486827848138) | 1 | 8 | 3 | 29491 | 35 | |||
| 80382 | 37200 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1523 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 0 | Permit Number 39767 | 5986185.22517174 | 2104866.53832379 | 37.7587641880882 | -122.490852744095 | (37.7587641880882, -122.490852744095) | 1 | 8 | 3 | 56 | 35 | |
| 89773 | 208553 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 595 Victoria St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5993236.49495 | 2091160.42378 | 37.7215400517233 | -122.465470730297 | (37.7215400517233, -122.465470730297) | 9 | 8 | 6 | 64 | 24 | |||
| 92543 | 183390 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2673 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989554.4883 | 2097163.7436 | 37.7378105948151 | -122.478637096313 | (37.7378105948151, -122.478637096313) | 1 | 8 | 3 | 29491 | 35 | |||
| 100896 | 45081 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 2143 29th Ave | 1 | 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 | ||
| 103730 | 30933 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 515 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 2 | Permit Number 34746 | 5995238.05278 | 2091207.05999 | 37.7217833398997 | -122.458555307998 | (37.7217833398997, -122.458555307998) | 9 | 8 | 6 | 28861 | 24 | |
| 115190 | 97119 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1151 Taraval St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2011 12:00:00 AM | 2 | 3x3 | Permit Number 768432 | 5989613.2 | 2098967.9 | 37.7427677493048 | -122.478566001777 | (37.7427677493048, -122.478566001777) | 1 | 8 | 3 | 29491 | 35 | |
| 118863 | 208547 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 249 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996507.17422 | 2091557.14862 | 37.7228174577402 | -122.454193583485 | (37.7228174577402, -122.454193583485) | 9 | 8 | 4 | 28861 | 24 | |||
| 121806 | 208551 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 439 Vernon St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5992460.92355 | 2090770.88393 | 37.7204257089658 | -122.46812332475 | (37.7204257089658, -122.46812332475) | 9 | 8 | 6 | 64 | 24 | |||
| 124243 | 37205 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1579 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 4 | Permit Number 39772 | 5986201.0748 | 2104494.9459 | 37.7577448234718 | -122.490770587951 | (37.7577448234718, -122.490770587951) | 1 | 8 | 3 | 56 | 35 | |
| 133372 | 208549 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 498 Vernon St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5992504.0941 | 2091172.39511 | 37.7215306538065 | -122.468003289534 | (37.7215306538065, -122.468003289534) | 9 | 8 | 6 | 64 | 24 | |||
| 136599 | 208554 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 447 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5993467.66599 | 2088853.99323 | 37.7152204788151 | -122.464504257677 | (37.7152204788151, -122.464504257677) | 9 | 8 | 6 | 64 | 24 | |||
| 149031 | 177298 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988403.4281 | 2091243.72009 | 37.721488831717 | -122.482183231171 | (37.721488831717, -122.482183231171) | 1 | 8 | 4 | 64 | 14 | ||||
| 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 | |
| 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 | |||
| 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 | |
| 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 | |
| 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 | ||
| 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 | ||||
| 5938 | 229255 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 260 Randall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003887.38012 | 2097809.34417 | 37.7404050277631 | -122.429127352938 | (37.7404050277631, -122.429127352938) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | ||||
| 7571 | 237826 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 210 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/2020 12:00:00 AM | 3 | Width 2ft | Permit Number 785232 | 6002395.63458 | 2097149.51403 | 37.7385087290057 | -122.434238055364 | (37.7385087290057, -122.434238055364) | 2 | 7 | 5 | 63 | 7 | |
| 12128 | 81186 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 559 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6001911.78003 | 2090228.45376 | 37.7194775995917 | -122.435416033226 | (37.7194775995917, -122.435416033226) | 9 | 7 | 6 | 28861 | 5 | |||
| 15774 | 208544 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 171 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999615.39289 | 2094047.29924 | 37.7298325824993 | -122.443627964962 | (37.7298325824993, -122.443627964962) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | ||||
| 19323 | 81173 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001918.1505 | 2090237.98214 | 37.7195041241905 | -122.435394694117 | (37.7195041241905, -122.435394694117) | 9 | 7 | 6 | 28861 | 5 | |||
| 19604 | 78246 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1447 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5999064.52078 | 2089547.19331 | 37.7174448988403 | -122.445208973141 | (37.7174448988403, -122.445208973141) | 9 | 7 | 6 | 28861 | 25 | |||
| 19877 | 246803 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6010372.78366 | 2099322.13571 | 37.7449238197814 | -122.406809864293 | (37.7449238197814, -122.406809864293) | 2 | 7 | 7 | 28859 | 2 | |||
| 19925 | 229241 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009182.18967 | 2098038.44408 | 37.7413323942725 | -122.410836091326 | (37.7413323942725, -122.410836091326) | 10 | 7 | 7 | 28859 | 2 | |||
| 22730 | 4491 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1608 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/1998 12:00:00 AM | 3 | 3X3 | 6004562.86857 | 2099453.04475 | 37.7449564687567 | -122.426908813616 | (37.7449564687567, -122.426908813616) | 2 | 7 | 5 | 63 | 22 | ||
| 26180 | 115023 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 618 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 12:00:00 AM | 6 | Permit Number 775874 | 6003941.00941 | 2091735.88537 | 37.7237317121275 | -122.428509122993 | (37.7237317121275, -122.428509122993) | 9 | 7 | 6 | 28861 | 5 | ||
| 28278 | 49981 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 4 | 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 | ||
| 28410 | 177294 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 570 Edinburgh St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6002574.43441 | 2090375.15322 | 37.7199180155891 | -122.433135958685 | (37.7199180155891, -122.433135958685) | 9 | 7 | 6 | 28861 | 5 | |||
| 28736 | 36479 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 541 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39372 | 5996872.5215496 | 2093815.84341283 | 37.7290402419627 | -122.45309363195 | (37.7290402419627, -122.45309363195) | 9 | 7 | 4 | 28861 | 40 | ||
| 31077 | 177293 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 570 Edinburgh St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6002594.98621 | 2090406.02371 | 37.7200039448969 | -122.433067122761 | (37.7200039448969, -122.433067122761) | 9 | 7 | 6 | 28861 | 5 | |||
| 33104 | 49982 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 1 | 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 | ||
| 35087 | 1920 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 48 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2012 12:00:00 AM | 3 | 3x3 | 6001413.10408 | 2097289.51467 | 37.7388373223942 | -122.437645189074 | (37.7388373223942, -122.437645189074) | 2 | 7 | 5 | 63 | 7 | ||
| 37036 | 177300 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001639.62994 | 2087602.93432 | 37.7122530470215 | -122.436168967218 | (37.7122530470215, -122.436168967218) | 9 | 7 | 6 | 28861 | 5 | |||
| 44112 | 40458 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/1999 12:00:00 AM | Permit Number 41543 | 6008355.36167983 | 2098222.23165667 | 37.7417906382072 | -122.413707978506 | (37.7417906382072, -122.413707978506) | 2 | 7 | 7 | 28859 | 2 | ||
| 48134 | 88833 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 900 Powhattan Ave | 3 | 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 | ||
| 49181 | 36477 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 531 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39371 | 5996915.79992705 | 2093810.02039561 | 37.7290267336025 | -122.452943595903 | (37.7290267336025, -122.452943595903) | 9 | 7 | 4 | 28861 | 40 | ||
| 50140 | 177288 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 170 Lawrence Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5996808.94464 | 2087276.43363 | 37.7110809120333 | -122.452841609247 | (37.7110809120333, -122.452841609247) | 9 | 7 | 6 | 28861 | 25 | |||
| 53505 | 229257 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 210 Moffitt St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002381.14665 | 2097165.58245 | 37.7385520268501 | -122.434289296035 | (37.7385520268501, -122.434289296035) | 2 | 7 | 5 | 63 | 7 | |||
| 53896 | 42075 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 125 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2005 12:00:00 AM | Permit Number 42387 | 6009870.15357172 | 2099865.41345763 | 37.7463874047531 | -122.408586191488 | (37.7463874047531, -122.408586191488) | 2 | 7 | 7 | 28859 | 2 | ||
| 54872 | 50865 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 238 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/2004 12:00:00 AM | Permit Number 47380 | 6007739.99301992 | 2097997.57355167 | 37.741139201026 | -122.415819822319 | (37.741139201026, -122.415819822319) | 2 | 7 | 7 | 28859 | 2 | ||
| 62848 | 177296 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6000995.34675 | 2087902.8646 | 37.7130399628101 | -122.438417271438 | (37.7130399628101, -122.438417271438) | 9 | 7 | 6 | 28861 | 5 | |||
| 63595 | 37844 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 117 Brewster St | 2 | 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 | ||
| 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 | ||
| 70454 | 229226 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 546 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007812.08689 | 2096313.01345 | 37.7365178224466 | -122.415451314937 | (37.7365178224466, -122.415451314937) | 2 | 7 | 7 | 28859 | 2 | |||
| 70784 | 52521 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 225 Onondaga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 6 | Permit Number 48914 | 6000062.86091 | 2091491.3711 | 37.7228401035632 | -122.441897645058 | (37.7228401035632, -122.441897645058) | 9 | 7 | 6 | 28861 | 25 | |
| 73392 | 177301 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1222 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6001599.00625 | 2087595.59489 | 37.7122305864419 | -122.436308849585 | (37.7122305864419, -122.436308849585) | 9 | 7 | 6 | 28861 | 5 | |||
| 76828 | 177295 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 115 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001002.00553 | 2087880.82642 | 37.7129798296258 | -122.438392678593 | (37.7129798296258, -122.438392678593) | 9 | 7 | 6 | 28861 | 5 | |||
| 77741 | 229223 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 587 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/1988 12:00:00 AM | 1 | Width 2ft | Permit Number 25015 | 6002801.67142 | 2098869.60801 | 37.7432547464139 | -122.432957032239 | (37.7432547464139, -122.432957032239) | 2 | 7 | 5 | 63 | 22 | |
| 80365 | 229259 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 269 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003857.56826 | 2097789.37323 | 37.7403485044927 | -122.429229006915 | (37.7403485044927, -122.429229006915) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | ||
| 86510 | 115434 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 563 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777504 | 6001902.43576 | 2090213.7176 | 37.7194366066954 | -122.435447279293 | (37.7194366066954, -122.435447279293) | 9 | 7 | 6 | 28861 | 5 | ||
| 87645 | 229235 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1626 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003320.17625 | 2098729.19184 | 37.7428985924036 | -122.431154158661 | (37.7428985924036, -122.431154158661) | 2 | 7 | 5 | 63 | 22 | |||
| 88802 | 229224 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 428 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003023.34739 | 2099505.62424 | 37.7450136701507 | -122.432235947738 | (37.7450136701507, -122.432235947738) | 2 | 7 | 5 | 63 | 22 | |||
| 89049 | 177289 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 1200 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999793.10154 | 2090324.86823 | 37.719621778009 | -122.442746423415 | (37.719621778009, -122.442746423415) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||
| 90883 | 36476 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 524 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1999 12:00:00 AM | Permit Number 41513 | 5996948.70097149 | 2093858.06219815 | 37.729160530354 | -122.452833321223 | (37.729160530354, -122.452833321223) | 9 | 7 | 4 | 28861 | 40 | ||
| 97114 | 208543 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 100 Vista Verde Ct | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999208.78816 | 2096056.42924 | 37.7353259823914 | -122.445178028358 | (37.7353259823914, -122.445178028358) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | |
| 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 | ||
| 113052 | 49980 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 145 Ocean Ave | 3 | 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 | ||
| 117553 | 114096 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 424 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2015 12:00:00 AM | 3 | 3x3 | 5998431.96208 | 2087528.92056 | 37.7118670561881 | -122.447250250697 | (37.7118670561881, -122.447250250697) | 9 | 7 | 6 | 28861 | 25 | ||
| 122883 | 36480 | Permitted Site 7 | Magnolia doltsopa :: Himalayan Magnolia 20 | 541 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39372 | 5996872.5215496 | 2093815.84341283 | 37.7290402419627 | -122.45309363195 | (37.7290402419627, -122.45309363195) | 9 | 7 | 4 | 28861 | 40 | ||
| 123138 | 229256 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 260 Randall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003866.23298 | 2097822.81814 | 37.7404408270718 | -122.429201431925 | (37.7404408270718, -122.429201431925) | 2 | 7 | 5 | 63 | 7 |
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) );