trees
713 rows where qSpecies_id = 102 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4056 | 249318 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 198X Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | |||||||||||||
| 68909 | 176076 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 154 Gillette Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012994.7964 | 2086626.41439 | 37.7102103233239 | -122.396853446553 | (37.7102103233239, -122.396853446553) | 10 | 3 | 8 | 309 | 1 | |||
| 8537 | 78846 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 259 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5992056.72748 | 2086721.95578 | 37.7092849811889 | -122.469225944831 | (37.7092849811889, -122.469225944831) | 9 | 8 | 4 | 64 | 24 | |||
| 166053 | 176079 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1183 Munich St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6001144.67239 | 2087111.03395 | 37.7108742640178 | -122.437844474361 | (37.7108742640178, -122.437844474361) | 9 | 7 | 6 | 28861 | 5 | |||
| 43021 | 176078 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012689.21584 | 2087374.22772 | 37.7122466573345 | -122.397962026443 | (37.7122466573345, -122.397962026443) | 10 | 3 | 8 | 309 | 1 | |||
| 186381 | 176077 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 230 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012696.95044 | 2087397.86987 | 37.7123120047722 | -122.397936950623 | (37.7123120047722, -122.397936950623) | 10 | 3 | 8 | 309 | 1 | |||
| 148959 | 108780 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6006878.58529 | 2087505.45215 | 37.7122816418905 | -122.418054633195 | (37.7122816418905, -122.418054633195) | 9 | 7 | 8 | 309 | 39 |
| 29257 | 37356 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 62 Florentine Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 5 | Permit Number 39862 | 5999496.07093 | 2087702.97116 | 37.7124057060181 | -122.443584900943 | (37.7124057060181, -122.443584900943) | 9 | 7 | 6 | 28861 | 5 | |
| 67548 | 108784 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005634.22998 | 2088024.32377 | 37.7136362375916 | -122.422392346349 | (37.7136362375916, -122.422392346349) | 9 | 7 | 8 | 309 | 18 |
| 185247 | 108782 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 2055 Sunnydale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005606.4158 | 2088034.4515 | 37.713662477117 | -122.422489201534 | (37.713662477117, -122.422489201534) | 9 | 7 | 8 | 309 | 18 |
| 183727 | 32762 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 118 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 4 | Permit Number 37137 | 5995714.52093 | 2089647.57349 | 37.7175287309449 | -122.456795559591 | (37.7175287309449, -122.456795559591) | 9 | 8 | 6 | 28861 | 24 | |
| 82638 | 206751 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 770 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994332.77202 | 2089945.7388 | 37.7182679844691 | -122.461593203464 | (37.7182679844691, -122.461593203464) | 9 | 8 | 6 | 28861 | 24 | |||
| 103724 | 43733 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 770 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43370 | 5994336.72803228 | 2089956.89619003 | 37.7182988477082 | -122.461580337784 | (37.7182988477082, -122.461580337784) | 9 | 8 | 6 | 28861 | 24 | ||
| 151742 | 161277 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 582 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 12:23:00 PM | 3 | Width 0ft | 6002834.75222 | 2090259.20529 | 37.7196144116499 | -122.432227854755 | (37.7196144116499, -122.432227854755) | 9 | 7 | 6 | 28861 | 5 | |
| 1537 | 258399 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 580 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5x5 | 6002841.49317 | 2090269.24655 | 37.7196423649312 | -122.432205270462 | (37.7196423649312, -122.432205270462) | 9 | 7 | 6 | 28861 | 5 | |||
| 182078 | 161275 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 574 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 12:26:00 PM | 3 | Width 0ft | 6002859.41772 | 2090297.55139 | 37.7197211000357 | -122.432145332055 | (37.7197211000357, -122.432145332055) | 9 | 7 | 6 | 28861 | 5 | |
| 2625 | 161272 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 562 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:33:00 PM | 3 | Width 0ft | 6002894.24566 | 2090355.62698 | 37.719882537321 | -122.432029089275 | (37.719882537321, -122.432029089275) | 9 | 7 | 6 | 28861 | 5 | |
| 131980 | 206750 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 311 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995831.52313 | 2090536.35078 | 37.7199758213047 | -122.456455372126 | (37.7199758213047, -122.456455372126) | 9 | 8 | 6 | 28861 | 24 | |||
| 176482 | 206749 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 311 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995818.46528 | 2090537.82945 | 37.7199791317192 | -122.456500615214 | (37.7199791317192, -122.456500615214) | 9 | 8 | 6 | 28861 | 24 | |||
| 141219 | 206748 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 316 Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995822.77858 | 2090577.54277 | 37.7200884227352 | -122.456488575987 | (37.7200884227352, -122.456488575987) | 9 | 8 | 6 | 28861 | 24 | |||
| 151165 | 206747 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 316 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995834.85726 | 2090578.94523 | 37.7200929670035 | -122.4564469257 | (37.7200929670035, -122.4564469257) | 9 | 8 | 6 | 28861 | 24 | |||
| 194473 | 258633 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 625 Niagara Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2021 12:00:00 AM | 3 | 4x6 | 5997754 | 2090591 | 37.7202360579042 | -122.449813998345 | (37.7202360579042, -122.449813998345) | 9 | 8 | 6 | 28861 | 24 | ||
| 143673 | 199806 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1305 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015615.5318 | 2090822.5842 | 37.7218777199193 | -122.388088213537 | (37.7218777199193, -122.388088213537) | 10 | 3 | 8 | 58 | 1 | |||
| 104356 | 199804 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1315 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6015572.2876 | 2090853.6469 | 37.7219606159851 | -122.388239865807 | (37.7219606159851, -122.388239865807) | 10 | 3 | 8 | 58 | 1 | |||
| 8484 | 180531 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 401 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 4 | Width 2ft | 6002788.2945 | 2090951.75373 | 37.721513361625 | -122.432437880612 | (37.721513361625, -122.432437880612) | 9 | 7 | 6 | 28861 | 5 | ||
| 6222 | 180532 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 401 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 15 | Width 4ft | 6002770.13876 | 2090966.12434 | 37.7215517905727 | -122.432501665928 | (37.7215517905727, -122.432501665928) | 9 | 7 | 6 | 28861 | 5 | ||
| 162372 | 37809 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 945 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 6 | Permit Number 40129 | 6008935.03699 | 2091336.11474 | 37.7229153750213 | -122.411217322939 | (37.7229153750213, -122.411217322939) | 9 | 3 | 7 | 309 | 28 | |
| 182323 | 38912 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 215 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40724 | 5994141.27914879 | 2091345.82525201 | 37.7221012612205 | -122.462356600514 | (37.7221012612205, -122.462356600514) | 9 | 8 | 4 | 28861 | 40 | ||
| 72802 | 70492 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 46 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/06/1994 12:00:00 AM | 3 | 6004963.53914 | 2091629.12436 | 37.7234963820321 | -122.424966815785 | (37.7234963820321, -122.424966815785) | 9 | 7 | 6 | 28861 | 5 | ||
| 78986 | 82093 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 90 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52272 | 5992884.13871167 | 2091762.58426518 | 37.7231731092186 | -122.466732469761 | (37.7231731092186, -122.466732469761) | 9 | 8 | 4 | 59 | 40 | ||
| 83092 | 78499 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 90 Corona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52272 | 5992884.13871167 | 2091762.58426518 | 37.7231731092186 | -122.466732469761 | (37.7231731092186, -122.466732469761) | 9 | 8 | 4 | 59 | 40 | ||
| 155288 | 78634 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 90 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52272 | 5992884.13871167 | 2091762.58426518 | 37.7231731092186 | -122.466732469761 | (37.7231731092186, -122.466732469761) | 9 | 8 | 4 | 59 | 40 | ||
| 104240 | 38918 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 116 De Soto St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40728 | 5993276.12701887 | 2091907.60614304 | 37.7235939185401 | -122.465387983379 | (37.7235939185401, -122.465387983379) | 9 | 8 | 4 | 59 | 40 | ||
| 160194 | 38917 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 116 De Soto St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40728 | 5993276.12701887 | 2091907.60614304 | 37.7235939185401 | -122.465387983379 | (37.7235939185401, -122.465387983379) | 9 | 8 | 4 | 59 | 40 | ||
| 79532 | 40759 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 125 De Soto St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46577 | 5993244.02089224 | 2091981.15429222 | 37.723794012147 | -122.465504308143 | (37.723794012147, -122.465504308143) | 9 | 8 | 4 | 59 | 40 | ||
| 48847 | 40753 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 120 Corona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41723 | 5992987.31701285 | 2091988.45595539 | 37.7237992517995 | -122.466392213704 | (37.7237992517995, -122.466392213704) | 9 | 8 | 4 | 59 | 40 | ||
| 43642 | 255804 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5993243 | 2092509 | 37.7252432887469 | -122.465546165723 | (37.7252432887469, -122.465546165723) | 9 | 8 | 4 | 59 | 40 | ||||
| 125907 | 255803 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5993243 | 2092509 | 37.7252432887469 | -122.465546165723 | (37.7252432887469, -122.465546165723) | 9 | 8 | 4 | 59 | 40 | ||||
| 153975 | 255802 | Undocumented 4 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | 5993243 | 2092509 | 37.7252432887469 | -122.465546165723 | (37.7252432887469, -122.465546165723) | 9 | 8 | 4 | 59 | 40 | ||||
| 58539 | 38948 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1998 12:00:00 AM | Permit Number 40745 | 5993321.52837855 | 2092510.8724856 | 37.7252529591009 | -122.465274839058 | (37.7252529591009, -122.465274839058) | 9 | 8 | 4 | 59 | 40 | |||
| 62160 | 38946 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1998 12:00:00 AM | Permit Number 40745 | 5993321.52837855 | 2092510.8724856 | 37.7252529591009 | -122.465274839058 | (37.7252529591009, -122.465274839058) | 9 | 8 | 4 | 59 | 40 | |||
| 132380 | 38945 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2002 12:00:00 AM | Permit Number 45897 | 5993321.52837855 | 2092510.8724856 | 37.7252529591009 | -122.465274839058 | (37.7252529591009, -122.465274839058) | 9 | 8 | 4 | 59 | 40 | ||
| 135540 | 38947 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 151 Urbano Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/1998 12:00:00 AM | Permit Number 40745 | 5993321.52837855 | 2092510.8724856 | 37.7252529591009 | -122.465274839058 | (37.7252529591009, -122.465274839058) | 9 | 8 | 4 | 59 | 40 | |||
| 6349 | 78274 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1715 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6013961.91267 | 2093099.05364 | 37.7280366912377 | -122.393963673903 | (37.7280366912377, -122.393963673903) | 10 | 3 | 8 | 58 | 1 | |||
| 5030 | 171365 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 12 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6002871.58236 | 2093130.52409 | 37.7275005001327 | -122.432305504906 | (37.7275005001327, -122.432305504906) | 9 | 7 | 6 | 28861 | 5 | ||
| 111866 | 49647 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 777 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/2003 12:00:00 AM | 3x3 | Permit Number 46500 | 5994865.10156856 | 2093172.91558947 | 37.7271596651369 | -122.459986833904 | (37.7271596651369, -122.459986833904) | 9 | 8 | 4 | 28861 | 40 | |
| 156772 | 206736 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 778 Faxon Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 5994913.66935 | 2093209.24182 | 37.7272622013836 | -122.459821566928 | (37.7272622013836, -122.459821566928) | 9 | 7 | 4 | 28861 | 40 | |||
| 171134 | 114965 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 778 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776138 | 5994932 | 2093225 | 37.7273065236963 | -122.45975933934 | (37.7273065236963, -122.45975933934) | 9 | 7 | 4 | 28861 | 40 | |||
| 156213 | 38599 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1334 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 1 | Permit Number 40550 | 6016508.9427 | 2093376.549 | 37.7289398652867 | -122.385177756249 | (37.7289398652867, -122.385177756249) | 10 | 3 | 8 | 58 | 1 | |
| 151695 | 40700 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 100 Oxford St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41678 | 6006308.40202986 | 2093422.77537775 | 37.7284972327963 | -122.420445112942 | (37.7284972327963, -122.420445112942) | 9 | 7 | 7 | 309 | 5 | ||
| 5746 | 258377 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1036 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007782.72545 | 2093434.59134 | 37.7286126501976 | -122.415349121053 | (37.7286126501976, -122.415349121053) | 9 | 3 | 7 | 309 | 5 | |||
| 7281 | 258376 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1030 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007799.31029 | 2093439.67558 | 37.7286275425489 | -122.415292145905 | (37.7286275425489, -122.415292145905) | 9 | 3 | 7 | 309 | 5 | |||
| 174878 | 206746 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998707.58431 | 2093469.07503 | 37.7281930968274 | -122.446724762433 | (37.7281930968274, -122.446724762433) | 9 | 7 | 4 | 28861 | 40 | |||
| 159432 | 206745 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998694.48733 | 2093469.34751 | 37.7281930968236 | -122.446770058609 | (37.7281930968236, -122.446770058609) | 9 | 7 | 4 | 28861 | 40 | |||
| 101732 | 27094 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 711 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X3 | 6006079.32482 | 2093593.73712 | 37.728953744301 | -122.421249181231 | (37.728953744301, -122.421249181231) | 9 | 7 | 6 | 28861 | 5 | |||
| 11449 | 37884 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 661 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40161 | 5995348.10661971 | 2093729.21592258 | 37.7287148993258 | -122.458357350083 | (37.7287148993258, -122.458357350083) | 9 | 7 | 4 | 28861 | 40 | ||
| 27807 | 37883 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 661 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40161 | 5995348.10661971 | 2093729.21592258 | 37.7287148993258 | -122.458357350083 | (37.7287148993258, -122.458357350083) | 9 | 7 | 4 | 28861 | 40 | ||
| 110690 | 37885 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 661 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40161 | 5995348.10661971 | 2093729.21592258 | 37.7287148993258 | -122.458357350083 | (37.7287148993258, -122.458357350083) | 9 | 7 | 4 | 28861 | 40 | ||
| 19290 | 36416 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 665 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39335 | 5995348.52277962 | 2093755.44427738 | 37.7287869399676 | -122.458357809087 | (37.7287869399676, -122.458357809087) | 9 | 7 | 4 | 28861 | 40 | ||
| 103912 | 36415 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 665 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39335 | 5995348.52277962 | 2093755.44427738 | 37.7287869399676 | -122.458357809087 | (37.7287869399676, -122.458357809087) | 9 | 7 | 4 | 28861 | 40 | ||
| 152576 | 36414 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 665 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 39335 | 5995348.52277962 | 2093755.44427738 | 37.7287869399676 | -122.458357809087 | (37.7287869399676, -122.458357809087) | 9 | 7 | 4 | 28861 | 40 | ||
| 32362 | 206744 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 360 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5997700.14288 | 2093824.21589 | 37.7291106283493 | -122.450233097774 | (37.7291106283493, -122.450233097774) | 9 | 7 | 4 | 28861 | 40 | |||
| 53488 | 40648 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 5 | Permit Number 41645 | 6004712.3249 | 2093952.72428 | 37.7298622808141 | -122.426000547798 | (37.7298622808141, -122.426000547798) | 9 | 7 | 6 | 28861 | 5 | |
| 136374 | 206758 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993644.01897 | 2093962.07142 | 37.7292561890115 | -122.464265339281 | (37.7292561890115, -122.464265339281) | 9 | 8 | 4 | 59 | 40 | |||
| 90557 | 40647 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Congdon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 6 | Permit Number 41645 | 6004711.57776 | 2093967.72477 | 37.7299034265983 | -122.426004198159 | (37.7299034265983, -122.426004198159) | 9 | 7 | 6 | 28861 | 5 | |
| 78764 | 40650 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Congdon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 7 | Permit Number 41645 | 6004710.85201 | 2093983.77651 | 37.7299474600897 | -122.426007849383 | (37.7299474600897, -122.426007849383) | 9 | 7 | 6 | 28861 | 5 | |
| 4325 | 261136 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 4200 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | 3x3 | 6003439 | 2093988 | 37.729887093701 | -122.43040509359 | (37.729887093701, -122.43040509359) | 9 | 7 | 6 | 28861 | 25 | ||
| 147676 | 49042 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 935 Darien Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46217 | 5994602.24270835 | 2094017.7241855 | 37.729464182785 | -122.460956731648 | (37.729464182785, -122.460956731648) | 9 | 8 | 4 | 59 | 40 | ||
| 48196 | 40649 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 201 Congdon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41645 | 6004716.48108998 | 2094045.77819858 | 37.7301180210727 | -122.425992800888 | (37.7301180210727, -122.425992800888) | 9 | 7 | 6 | 28861 | 5 | ||
| 5995 | 258380 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
| 16611 | 258381 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 80 Somerset St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009574.25344 | 2094049.89218 | 37.7304026643572 | -122.409199080219 | (37.7304026643572, -122.409199080219) | 9 | 3 | 7 | 309 | 28 | |||
| 83688 | 206787 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 270 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998985.10012 | 2094100.68271 | 37.7299431928255 | -122.445810788635 | (37.7299431928255, -122.445810788635) | 9 | 7 | 4 | 28861 | 40 | |||
| 26169 | 206759 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995896.88081 | 2094136.36483 | 37.7298643528405 | -122.456489645298 | (37.7298643528405, -122.456489645298) | 9 | 7 | 4 | 28861 | 40 | |||
| 7857 | 78321 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 26 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014066.05948 | 2094191.20422 | 37.7310413028018 | -122.3936800421 | (37.7310413028018, -122.3936800421) | 10 | 3 | 8 | 58 | 1 | ||
| 107049 | 40697 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 351 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | 6 | Permit Number 41677 | 6005488.64809 | 2094209.66351 | 37.7306116238099 | -122.423334963564 | (37.7306116238099, -122.423334963564) | 9 | 7 | 6 | 28861 | 5 | |
| 4875 | 261114 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 5755 | 261117 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 7023 | 261112 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 8494 | 261111 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 13909 | 261115 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 15179 | 261113 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 16303 | 261116 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 331 Thornton Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013544 | 2094213 | 37.731072125738 | -122.395486430266 | (37.731072125738, -122.395486430266) | 10 | 3 | 8 | 58 | 1 | |
| 5271 | 78323 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 24 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014072.33534 | 2094216.70422 | 37.7311116693492 | -122.393660129315 | (37.7311116693492, -122.393660129315) | 10 | 3 | 8 | 58 | 1 | ||
| 43579 | 49061 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 800 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46227 | 5995425.29330578 | 2094224.97746193 | 37.7300805760009 | -122.45812637796 | (37.7300805760009, -122.45812637796) | 9 | 7 | 4 | 28861 | 40 | ||
| 61986 | 49063 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 800 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46227 | 5995425.29330578 | 2094224.97746193 | 37.7300805760009 | -122.45812637796 | (37.7300805760009, -122.45812637796) | 9 | 7 | 4 | 28861 | 40 | ||
| 112242 | 49062 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 800 Miramar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46227 | 5995425.29330578 | 2094224.97746193 | 37.7300805760009 | -122.45812637796 | (37.7300805760009, -122.45812637796) | 9 | 7 | 4 | 28861 | 40 | ||
| 54803 | 37898 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
| 71186 | 37901 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
| 161012 | 37899 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
| 169803 | 37900 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40169 | 5995814.03079033 | 2094240.32165612 | 37.7301450363484 | -122.45678358123 | (37.7301450363484, -122.45678358123) | 9 | 7 | 4 | 28861 | 40 | ||
| 139163 | 206767 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1525 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995816.07198 | 2094254.87486 | 37.7301851131404 | -122.456777576749 | (37.7301851131404, -122.456777576749) | 9 | 7 | 4 | 28861 | 40 | |||
| 18209 | 78205 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 70 Latona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014348.06009 | 2094265.06475 | 37.7312597751042 | -122.392710275271 | (37.7312597751042, -122.392710275271) | 10 | 3 | 8 | 58 | 1 | |||
| 178970 | 206760 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995833.25703 | 2094287.38686 | 37.7302753699947 | -122.456720516556 | (37.7302753699947, -122.456720516556) | 9 | 7 | 4 | 28861 | 40 | |||
| 51909 | 37903 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1535 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40170 | 5995777.93060406 | 2094290.75580707 | 37.7302814434236 | -122.456912029856 | (37.7302814434236, -122.456912029856) | 9 | 7 | 4 | 28861 | 40 | ||
| 53180 | 37904 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1535 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40170 | 5995777.93060406 | 2094290.75580707 | 37.7302814434236 | -122.456912029856 | (37.7302814434236, -122.456912029856) | 9 | 7 | 4 | 28861 | 40 | ||
| 104829 | 37905 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1535 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40170 | 5995777.93060406 | 2094290.75580707 | 37.7302814434236 | -122.456912029856 | (37.7302814434236, -122.456912029856) | 9 | 7 | 4 | 28861 | 40 | ||
| 15106 | 78327 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 50 Pomona St | 20 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014087.33436 | 2094297.79766 | 37.7313351688787 | -122.393613948242 | (37.7313351688787, -122.393613948242) | 10 | 3 | 8 | 58 | 1 | ||
| 62598 | 206761 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995824.4211 | 2094301.98465 | 37.730314944659 | -122.45675211871 | (37.730314944659, -122.45675211871) | 9 | 7 | 4 | 28861 | 40 | |||
| 137720 | 206762 | DPW Maintained 1 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995821.39633 | 2094303.05932 | 37.7303177217641 | -122.456762653382 | (37.7303177217641, -122.456762653382) | 9 | 7 | 4 | 28861 | 40 | |||
| 63171 | 37908 | Permitted Site 7 | Crataegus phaenopyrum :: Washington Hawthorn 102 | 1540 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1998 12:00:00 AM | Permit Number 40171 | 5995826.42405766 | 2094314.00617458 | 37.7303480678725 | -122.456746063345 | (37.7303480678725, -122.456746063345) | 9 | 7 | 4 | 28861 | 40 |
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) );