trees
221 rows where qSpecies_id = 153 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 193714 | 247476 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 856 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002462.8226 | 2109547.3008 | 37.7725538978004 | -122.434892132162 | (37.7725538978004, -122.434892132162) | 15 | 5 | 11 | 29492 | 9 | |||
| 192537 | 222873 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 4354 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000914.51326 | 2103313.56277 | 37.7553495604475 | -122.439800863126 | (37.7553495604475, -122.439800863126) | 2 | 4 | 5 | 28862 | 38 | |||
| 192421 | 46860 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 96 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44930 | 6005007.55179 | 2092712.98729 | 37.7264749177759 | -122.424891746668 | (37.7264749177759, -122.424891746668) | 9 | 7 | 6 | 28861 | 5 | ||
| 191773 | 175838 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994346.0156 | 2086520.62322 | 37.7088641902123 | -122.461299273568 | (37.7088641902123, -122.461299273568) | 9 | 8 | 6 | 28861 | 25 | |||
| 190723 | 175837 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | 9 | 8 | 6 | 28861 | 25 | |||
| 189808 | 106235 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 785 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6011771.38268 | 2109636.80705 | 37.7733237777988 | -122.402698980481 | (37.7733237777988, -122.402698980481) | 14 | 2 | 9 | 28853 | 34 | ||||
| 189272 | 173806 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 950 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007805.70004 | 2120292.05671 | 37.8023582786402 | -122.417172035787 | (37.8023582786402, -122.417172035787) | 5 | 1 | 1 | 308 | 32 | ||||
| 187258 | 222864 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.7532329691398 | -122.413002991602 | (37.7532329691398, -122.413002991602) | 2 | 4 | 7 | 28859 | 19 | |||
| 187222 | 115857 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 185514 | 34617 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3299 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38300 | 5999016.0246967 | 2115927.38259794 | 37.7898756461349 | -122.44727418368 | (37.7898756461349, -122.44727418368) | 13 | 6 | 1 | 29490 | 31 | ||
| 183706 | 59249 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 948 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 10 | Permit Number 18581 | 6007857.82328 | 2120305.56138 | 37.80239829122 | -122.416992620734 | (37.80239829122, -122.416992620734) | 5 | 1 | 1 | 308 | 32 | ||
| 183417 | 46864 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 96 Athens St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | Permit Number 44930 | 6004995.61677719 | 2092705.22653245 | 37.726452934298 | -122.424932453632 | (37.726452934298, -122.424932453632) | 9 | 7 | 6 | 28861 | 5 | ||
| 183195 | 50085 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 169 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46817 | 5992373.11163098 | 2098031.46456186 | 37.7403563861764 | -122.468954963559 | (37.7403563861764, -122.468954963559) | 1 | 8 | 4 | 59 | 40 | ||
| 182973 | 32637 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 778 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37083 | 6011766.14443501 | 2109713.24584796 | 37.7735333687871 | -122.402722477064 | (37.7735333687871, -122.402722477064) | 14 | 2 | 9 | 28853 | 34 | ||
| 182659 | 28505 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 270 06th St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010824.2979387 | 2111653.7211901 | 37.7788088323978 | -122.406117215604 | (37.7788088323978, -122.406117215604) | 14 | 2 | 9 | 28853 | 34 | |||
| 182640 | 41705 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.7339547580058 | -122.431850206764 | (37.7339547580058, -122.431850206764) | 2 | 7 | 5 | 63 | 7 | ||
| 182616 | 52299 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 46221st ST. Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2005 12:00:00 AM | Permit Number 48460 | 6001157.72665298 | 2103563.59755974 | 37.7560499364738 | -122.438977677821 | (37.7560499364738, -122.438977677821) | 2 | 4 | 5 | 28862 | 38 | ||
| 182600 | 38809 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 202 Townsend St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963121 | 2111590.96099347 | 37.7788497186051 | -122.392879852588 | (37.7788497186051, -122.392879852588) | 6 | 2 | 9 | 28856 | 34 | ||
| 182239 | 1547 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 501 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 5995572.64433 | 2112729.15384 | 37.7808968119003 | -122.458956226418 | (37.7808968119003, -122.458956226418) | 11 | 6 | 2 | 54 | 11 | |||
| 180116 | 125952 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 2294 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001994.86126 | 2118787.45338 | 37.7978984191288 | -122.437172562074 | (37.7978984191288, -122.437172562074) | 13 | 9 | 1 | 57 | 17 | |||
| 179881 | 42255 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 449 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42499 | 6011032.58907867 | 2112142.29283942 | 37.7801619842664 | -122.405431068184 | (37.7801619842664, -122.405431068184) | 14 | 2 | 9 | 28853 | 34 | ||
| 179749 | 115864 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 179557 | 115853 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 401x KANSAS ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011620 | 2106285 | 37.7641120222234 | -122.402986839965 | (37.7641120222234, -122.402986839965) | 8 | 3 | 8 | 28856 | 29 | |||||
| 179419 | 38247 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | 9 | 3x3 | Permit Number 40358 | 6008135.39153425 | 2107951.7492744 | 37.7684933273993 | -122.415157113805 | (37.7684933273993, -122.415157113805) | 8 | 4 | 7 | 28853 | 19 | |
| 177372 | 175828 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 490 Harkness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010182.47488 | 2089702.17663 | 37.7184987999604 | -122.406790070203 | (37.7184987999604, -122.406790070203) | 10 | 7 | 8 | 309 | 39 | |||
| 176813 | 37586 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 2775 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40017 | 6001162.31345404 | 2105517.18376133 | 37.7614142693336 | -122.439101823773 | (37.7614142693336, -122.439101823773) | 15 | 4 | 5 | 28862 | 3 | ||
| 176766 | 115856 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 175081 | 188464 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011863.90983 | 2109727.01208 | 37.7735766257899 | -122.402385258275 | (37.7735766257899, -122.402385258275) | 14 | 2 | 9 | 28853 | 34 | |||
| 173777 | 34577 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 295X Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | 13 | 6 | 1 | 54 | 31 | ||
| 173545 | 115867 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 172840 | 45193 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 44037 | 5997793.88507772 | 2107168.4294301 | 37.7657559303797 | -122.45087082602 | (37.7657559303797, -122.45087082602) | 15 | 5 | 11 | 29492 | 9 | ||
| 171444 | 59252 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 961 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 11 | Permit Number 18584 | 6007751.14837 | 2120241.22842 | 37.8022156478981 | -122.417357207676 | (37.8022156478981, -122.417357207676) | 5 | 1 | 10 | 308 | 32 | ||
| 170623 | 36005 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 315 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39154 | 6008606.55118779 | 2100215.49511804 | 37.7472778014217 | -122.412980345984 | (37.7472778014217, -122.412980345984) | 2 | 7 | 7 | 28859 | 2 | ||
| 168666 | 222879 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003245.02631 | 2105961.0603 | 37.7627513352378 | -122.431930287959 | (37.7627513352378, -122.431930287959) | 15 | 4 | 5 | 28862 | 3 | |||
| 166216 | 52213 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3667 24th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2005 12:00:00 AM | Permit Number 48396 | 6005350.78664261 | 2101935.57102078 | 37.7518174353483 | -122.424360871513 | (37.7518174353483, -122.424360871513) | 2 | 4 | 5 | 28859 | 19 | |||
| 165117 | 175825 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6003581.23003 | 2087608.20421 | 37.7123776381814 | -122.429458597533 | (37.7123776381814, -122.429458597533) | 9 | 7 | 6 | 28861 | 5 | |||
| 164703 | 59251 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 955 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 15 | Permit Number 18583 | 6007775.57137 | 2120243.85461 | 37.8022242328199 | -122.417272878267 | (37.8022242328199, -122.417272878267) | 5 | 1 | 10 | 308 | 32 | ||
| 162996 | 115863 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 162799 | 222875 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003058.60804 | 2095498.12618 | 37.7340120027534 | -122.431827935223 | (37.7340120027534, -122.431827935223) | 2 | 7 | 5 | 63 | 7 | |||
| 161579 | 188452 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011502.89501 | 2106343.32084 | 37.7642656181765 | -122.403395977545 | (37.7642656181765, -122.403395977545) | 8 | 3 | 8 | 28856 | 29 | |||
| 160314 | 222876 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6003060.85114 | 2095475.7145 | 37.7339505925395 | -122.431818580457 | (37.7339505925395, -122.431818580457) | 2 | 7 | 5 | 63 | 7 | |||
| 160240 | 188466 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 445 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011029.5684 | 2112160.37935 | 37.7802114767035 | -122.405442792276 | (37.7802114767035, -122.405442792276) | 14 | 2 | 9 | 28853 | 34 | |||
| 158200 | 38808 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 202 Townsend St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1998 12:00:00 AM | Permit Number 40646 | 6014649.4963121 | 2111590.96099347 | 37.7788497186051 | -122.392879852588 | (37.7788497186051, -122.392879852588) | 6 | 2 | 9 | 28856 | 34 | ||
| 158108 | 125962 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 952 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007785.23718 | 2120295.43881 | 37.8023664138362 | -122.41724308731 | (37.8023664138362, -122.41724308731) | 5 | 1 | 1 | 308 | 32 | |||
| 157286 | 188449 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011506.74728 | 2106279.38998 | 37.7640902935593 | -122.403378155697 | (37.7640902935593, -122.403378155697) | 8 | 3 | 8 | 28856 | 29 | |||
| 156809 | 34576 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 295X Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38282 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | 13 | 6 | 1 | 54 | 31 | ||
| 156537 | 40720 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 36 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 770949 | 6009333.47018643 | 2097251.8201173 | 37.7391809774349 | -122.41025748835 | (37.7391809774349, -122.41025748835) | 10 | 7 | 7 | 28859 | 2 | ||
| 155577 | 184174 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1655 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5985601.1485 | 2103943.8243 | 37.7561965316146 | -122.492804758993 | (37.7561965316146, -122.492804758993) | 1 | 8 | 3 | 56 | 35 | |||
| 152486 | 222874 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 462 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001154.00187 | 2103552.82126 | 37.7560201354351 | -122.43898978707 | (37.7560201354351, -122.43898978707) | 2 | 4 | 5 | 28862 | 38 | |||
| 151909 | 48945 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 819 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/2002 12:00:00 AM | Permit Number 46132 | 6009934.90888897 | 2104445.04060173 | 37.7589656692148 | -122.408685294891 | (37.7589656692148, -122.408685294891) | 2 | 4 | 7 | 28859 | 19 | ||
| 151107 | 32628 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 766 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 7 | Permit Number 37081 | 6011809.7571 | 2109765.86877 | 37.7736802942351 | -122.402575314726 | (37.7736802942351, -122.402575314726) | 14 | 2 | 9 | 28853 | 34 | |
| 150353 | 101286 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3333 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6001806.51614 | 2119614.34242 | 37.8001581312395 | -122.43788354539 | (37.8001581312395, -122.43788354539) | 13 | 9 | 1 | 57 | 17 | |||
| 149476 | 125954 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 251 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999004.62741 | 2115731.3369 | 37.7893367050801 | -122.447299501178 | (37.7893367050801, -122.447299501178) | 13 | 6 | 1 | 54 | 31 | |||
| 148343 | 41704 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42154 | 6003051.73866425 | 2095477.41967872 | 37.7339547580058 | -122.431850206764 | (37.7339547580058, -122.431850206764) | 2 | 7 | 5 | 63 | 7 | ||
| 147607 | 188460 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011827.04267 | 2109686.99498 | 37.7734646898654 | -122.40250997357 | (37.7734646898654, -122.40250997357) | 14 | 2 | 9 | 28853 | 34 | |||
| 147434 | 115861 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 146826 | 188448 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011508.86092 | 2106242.57461 | 37.7639893248743 | -122.403368255061 | (37.7639893248743, -122.403368255061) | 8 | 3 | 8 | 28856 | 29 | |||
| 146222 | 115860 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 142930 | 59248 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 939 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 9 | Permit Number 18580 | 6007864.89194 | 2120254.38142 | 37.8022581615512 | -122.41696453129 | (37.8022581615512, -122.41696453129) | 5 | 1 | 10 | 308 | 32 | ||
| 142756 | 65051 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3026 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2013 12:00:00 AM | 5 | Permit Number 769905 | 6003418.47474 | 2118846.82882 | 37.7981422694136 | -122.432250702931 | (37.7981422694136, -122.432250702931) | 13 | 9 | 1 | 57 | 17 | ||
| 141429 | 106234 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 785 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6011757.19214 | 2109625.51022 | 37.7732919669825 | -122.402747273178 | (37.7732919669825, -122.402747273178) | 14 | 2 | 9 | 28853 | 34 | ||||
| 140855 | 52257 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3667 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48424 | 6005350.78664261 | 2101935.57102078 | 37.7518174353483 | -122.424360871513 | (37.7518174353483, -122.424360871513) | 2 | 4 | 5 | 28859 | 19 | ||
| 140768 | 125958 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 941 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007838.51696 | 2120251.34871 | 37.8022483508428 | -122.417055586769 | (37.8022483508428, -122.417055586769) | 5 | 1 | 10 | 308 | 32 | |||
| 140364 | 188454 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011500.01929 | 2106398.96501 | 37.7644182439416 | -122.403409838819 | (37.7644182439416, -122.403409838819) | 8 | 3 | 8 | 28856 | 29 | |||
| 138124 | 247494 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002693.3039 | 2109766.0565 | 37.7731676302149 | -122.434110515465 | (37.7731676302149, -122.434110515465) | 15 | 5 | 11 | 29492 | 9 | |||
| 137598 | 125957 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1047 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009453.06953 | 2117007.51923 | 37.7934322851104 | -122.411239149462 | (37.7934322851104, -122.411239149462) | 3 | 1 | 10 | 28857 | 21 | |||
| 135942 | 222863 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008222.11657 | 2107958.04741 | 37.7685154940131 | -122.414857584305 | (37.7685154940131, -122.414857584305) | 8 | 4 | 7 | 28853 | 19 | |||
| 133095 | 222870 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 25 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007227.82526 | 2099384.75669 | 37.7449192898986 | -122.417689017034 | (37.7449192898986, -122.417689017034) | 2 | 7 | 7 | 28859 | 2 | |||
| 132877 | 44052 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3100 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | 8 | Permit Number 43582 | 6001963.46914 | 2118819.46564 | 37.7979845319203 | -122.437283480869 | (37.7979845319203, -122.437283480869) | 13 | 9 | 1 | 57 | 17 | ||
| 132856 | 37018 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.412968551923 | (37.753266951872, -122.412968551923) | 2 | 4 | 7 | 28859 | 19 | ||
| 132403 | 115855 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 129831 | 106940 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 1607 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
| 129412 | 52258 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3667 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48424 | 6005350.78664261 | 2101935.57102078 | 37.7518174353483 | -122.424360871513 | (37.7518174353483, -122.424360871513) | 2 | 4 | 5 | 28859 | 19 | ||
| 128123 | 175839 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 728 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009068.66668 | 2092869.3876 | 37.7271329121485 | -122.410863628551 | (37.7271329121485, -122.410863628551) | 9 | 3 | 7 | 309 | 28 | |||
| 127308 | 125960 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007965.18699 | 2120322.02846 | 37.8024495444817 | -122.416622255608 | (37.8024495444817, -122.416622255608) | 5 | 1 | 1 | 308 | 32 | |||
| 127193 | 205979 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.7437152253671 | -122.464891008423 | (37.7437152253671, -122.464891008423) | 1 | 8 | 4 | 29491 | 40 | |||
| 126312 | 125956 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1047 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009450.24252 | 2117026.36812 | 37.7934838810207 | -122.411250263289 | (37.7934838810207, -122.411250263289) | 3 | 1 | 10 | 28857 | 21 | |||
| 124461 | 102667 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3026 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2013 12:00:00 AM | 5 | Permit Number 769905 | 6003415.56335 | 2118865.49284 | 37.7981933509083 | -122.432262110832 | (37.7981933509083, -122.432262110832) | 13 | 9 | 1 | 57 | 17 | ||
| 124409 | 125959 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007983.53221 | 2120324.66338 | 37.802457811042 | -122.416558958654 | (37.802457811042, -122.416558958654) | 5 | 1 | 1 | 308 | 32 | |||
| 123719 | 34580 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 295X Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2012 12:00:00 AM | Permit Number 769651 | 5999028.12405406 | 2115657.54379136 | 37.789135431233 | -122.447212892779 | (37.789135431233, -122.447212892779) | 13 | 6 | 1 | 54 | 31 | |||
| 123654 | 37019 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39631 | 6008654.53435588 | 2102395.73728972 | 37.753266951872 | -122.412968551923 | (37.753266951872, -122.412968551923) | 2 | 4 | 7 | 28859 | 19 | ||
| 122776 | 40255 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/1999 12:00:00 AM | Permit Number 41416 | 6005635.54182208 | 2102533.13348143 | 37.7534742792296 | -122.42341862495 | (37.7534742792296, -122.42341862495) | 2 | 4 | 5 | 28859 | 19 | ||
| 121494 | 32636 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 119756 | 188450 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011505.24263 | 2106303.9355 | 37.7641576060043 | -122.403385086777 | (37.7641576060043, -122.403385086777) | 8 | 3 | 8 | 28856 | 29 | |||
| 117579 | 125963 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 954 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007766.23356 | 2120291.49428 | 37.8023545140073 | -122.417308569644 | (37.8023545140073, -122.417308569644) | 5 | 1 | 1 | 308 | 32 | |||
| 116855 | 222881 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3844 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004001.37732 | 2104831.96458 | 37.7596939568222 | -122.429233822808 | (37.7596939568222, -122.429233822808) | 2 | 4 | 5 | 28862 | 3 | |||
| 116330 | 32630 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 115792 | 175830 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5994659.60487 | 2086786.3953 | 37.7096119809882 | -122.460234715484 | (37.7096119809882, -122.460234715484) | 9 | 8 | 6 | 28861 | 25 | |||
| 114452 | 32633 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 777 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | Permit Number 37082 | 6011816.13660142 | 2109689.10170506 | 37.7734698655912 | -122.40254784763 | (37.7734698655912, -122.40254784763) | 14 | 2 | 9 | 28853 | 34 | ||
| 113359 | 35156 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1076 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38687 | 6001413.36342647 | 2109408.19644929 | 37.7721123108282 | -122.43851234272 | (37.7721123108282, -122.43851234272) | 15 | 5 | 11 | 29492 | 9 | ||
| 111421 | 51367 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 50 Pomona St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52508 | 6014166.48709 | 2094684.74927 | 37.7324020570933 | -122.39336736943 | (37.7324020570933, -122.39336736943) | 10 | 3 | 8 | 58 | 1 |
| 110268 | 188447 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011509.63905 | 2106201.49872 | 37.7638765831644 | -122.40336267386 | (37.7638765831644, -122.40336267386) | 8 | 3 | 8 | 28856 | 29 | |||
| 109815 | 32658 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 18 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 12 | Permit Number 37091 | 6011613.66818 | 2110190.11377 | 37.7748342242639 | -122.40328347057 | (37.7748342242639, -122.40328347057) | 14 | 2 | 9 | 28853 | 34 | |
| 107571 | 175829 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5994644.58104 | 2086786.22758 | 37.709610656267 | -122.460286627948 | (37.709610656267, -122.460286627948) | 9 | 8 | 6 | 28861 | 25 | |||
| 106619 | 222866 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005593.12032 | 2102536.33181 | 37.7534806667087 | -122.423565555132 | (37.7534806667087, -122.423565555132) | 2 | 4 | 5 | 28859 | 19 | |||
| 105468 | 188446 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011512.27704 | 2106186.35742 | 37.763835155891 | -122.403352484549 | (37.763835155891, -122.403352484549) | 8 | 3 | 8 | 28856 | 29 | |||
| 105361 | 60676 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1074 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1983 12:00:00 AM | 12 | Permit Number 20313 | 6001422.6196434 | 2109409.49491386 | 37.772116402608 | -122.438480417824 | (37.772116402608, -122.438480417824) | 15 | 5 | 11 | 29492 | 9 | ||
| 104937 | 175831 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5994675.09306 | 2086785.58839 | 37.7096106562906 | -122.460181127555 | (37.7096106562906, -122.460181127555) | 9 | 8 | 6 | 28861 | 25 | |||
| 104503 | 222865 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005579.30004 | 2102535.69949 | 37.7534781504092 | -122.423613303727 | (37.7534781504092, -122.423613303727) | 2 | 4 | 5 | 28859 | 19 | |||
| 103914 | 205976 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990268.09461 | 2106501.35163 | 37.7634906193203 | -122.476851900801 | (37.7634906193203, -122.476851900801) | 1 | 8 | 3 | 56 | 12 |
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) );