Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 157288 | 157288 | 227587 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 77 Brady St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006751.41341 | 2109490.52204 | 37.7726405574578 | -122.42005339854201 | (37.7726405574578, -122.420053398542) | |||
| 56110 | 56110 | 227546 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4281 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001381.6755099995 | 2101715.76186 | 37.7509889636801 | -122.43807083010401 | (37.7509889636801, -122.438070830104) | |||
| 74889 | 74889 | 227564 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4547 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000867.43951 | 2104613.62235 | 37.7589165280041 | -122.440056874944 | (37.7589165280041, -122.440056874944) | |||
| 55670 | 55670 | 41784 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011899.9957 | 2107451.97946 | 37.7673319169733 | -122.40210045827 | (37.7673319169733, -122.40210045827) | |
| 146605 | 146605 | 41785 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011884.29769 | 2107452.29856 | 37.7673319169518 | -122.402154778231 | (37.7673319169518, -122.402154778231) | |
| 183576 | 183576 | 227102 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1451 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6003961.991330001 | 2099782.46881 | 37.745826997234104 | -122.42901002020001 | (37.7458269972341, -122.4290100202) | |||
| 12597 | 12597 | 26986 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1349 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009414.0618 | 2094354.93302 | 37.7312312656966 | -122.409774411069 | (37.7312312656966, -122.409774411069) | |||
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 57061 | 57061 | 227584 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 660 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002549.44678 | 2108867.98451 | 37.7706935809695 | -122.434543909369 | (37.7706935809695, -122.434543909369) | |||
| 60440 | 60440 | 227159 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 156 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005558.07312 | 2099948.5227 | 37.746373159994505 | -122.423502792335 | (37.7463731599945, -122.423502792335) | |||
| 117965 | 117965 | 27025 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1380X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 12 | 3X3 | 6009629.1666 | 2094382.2025400002 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | ||
| 31459 | 31459 | 227146 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997461.46496 | 2105891.36034 | 37.7622303876487 | -122.45192844846599 | (37.7622303876487, -122.451928448466) | |||
| 48273 | 48273 | 227563 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4565 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000806.394180001 | 2104634.53115 | 37.7589704630323 | -122.440269497142 | (37.7589704630323, -122.440269497142) | |||
| 51384 | 51384 | 41787 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011846.53611 | 2107450.83181 | 37.7673257817889 | -122.402285287842 | (37.7673257817889, -122.402285287842) | |
| 82242 | 82242 | 176908 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1053 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6007885.162769999 | 2093698.9537400003 | 37.7293442892945 | -122.415013692231 | (37.7293442892945, -122.415013692231) | |||
| 171102 | 171102 | 41786 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011862.446140001 | 2107450.91483 | 37.767326897836206 | -122.40223026280898 | (37.7673268978362, -122.402230262809) | |
| 173018 | 173018 | 227119 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 799 Duncan St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6001473.16561 | 2099668.76787 | 37.7453736076231 | -122.437607869022 | (37.7453736076231, -122.437607869022) | |||
| 29103 | 29103 | 227140 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997729.62744 | 2105927.06337 | 37.7623437750648 | -122.45100355509399 | (37.7623437750648, -122.451003555094) | |||
| 69248 | 69248 | 39552 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/1998 12:00:00 AM | 10 | Permit Number 40979 | 6013009.1617 | 2107035.865 | 37.7662512051775 | -122.39823478562401 | (37.7662512051775, -122.398234785624) | ||
| 103543 | 103543 | 105757 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1278 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2014 12:00:00 AM | 10 | 3x3 | Permit Number 771070 | 5999104.9 | 2105310.4 | 37.7607292094813 | -122.446202658218 | (37.7607292094813, -122.446202658218) | |
| 148403 | 148403 | 227080 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1405 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007868.4281 | 2107357.29935 | 37.766846100505795 | -122.416038416642 | (37.7668461005058, -122.416038416642) | |||
| 148658 | 148658 | 40072 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.73083275450529 | -122.393144818701 | (37.7308327545053, -122.393144818701) | |
| 161078 | 161078 | 206986 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1284 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992719.06604 | 2106665.13626 | 37.7640822005694 | -122.468386764944 | (37.7640822005694, -122.468386764944) | |||
| 162953 | 162953 | 40073 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 102 Thornton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014207.29735 | 2094114.30982 | 37.7308380137496 | -122.393186376362 | (37.7308380137496, -122.393186376362) | |
| 184622 | 184622 | 93188 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53196 | 6014934.44131 | 2097265.12572 | 37.73952988128521 | -122.39089262491001 | (37.7395298812852, -122.39089262491) | |
| 25925 | 25925 | 206997 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1290 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5992719.48539 | 2106665.14578 | 37.7640822509305 | -122.46838531523998 | (37.7640822509305, -122.46838531524) | |||
| 26796 | 26796 | 47678 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 536 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/2002 12:00:00 AM | 9 | Permit Number 45462 | 6014348.84456 | 2104603.39752 | 37.7596467118443 | -122.393430795897 | (37.7596467118443, -122.393430795897) | |
| 32789 | 32789 | 227562 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4567 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000777.25512 | 2104640.3736 | 37.7589848458951 | -122.440370692454 | (37.7589848458951, -122.440370692454) | |||
| 38388 | 38388 | 227552 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4058 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002586.755890001 | 2105341.84005 | 37.7610137667981 | -122.43416274071998 | (37.7610137667981, -122.43416274072) | |||
| 40644 | 40644 | 227097 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009272.782269999 | 2099754.5666099996 | 37.7460495695343 | -122.41064401410601 | (37.7460495695343, -122.410644014106) | |||
| 44029 | 44029 | 227126 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | |||
| 47841 | 47841 | 207013 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000221.87075 | 2094376.8430299999 | 37.7307720044131 | -122.44155494671101 | (37.7307720044131, -122.441554946711) | |||
| 51569 | 51569 | 200835 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | |||
| 53294 | 53294 | 79640 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | ||
| 61295 | 61295 | 42963 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 560 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | 9 | Permit Number 42852 | 5981647.94996 | 2111905.75128 | 37.7778257173711 | -122.50706663602502 | (37.7778257173711, -122.507066636025) | ||
| 66808 | 66808 | 52362 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1438ASHINGTON Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 9 | Permit Number 48498 | 6007994.9364599995 | 2117377.7611599998 | 37.7943669936906 | -122.416310648633 | (37.7943669936906, -122.416310648633) | |
| 123811 | 123811 | 191221 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014015.897890001 | 2106592.9178299997 | 37.7650909952748 | -122.39472162882099 | (37.7650909952748, -122.394721628821) | |||
| 133941 | 133941 | 227561 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6000738.66154 | 2104570.78605 | 37.7587915779822 | -122.44049917592 | (37.7587915779822, -122.44049917592) | |||
| 153522 | 153522 | 50036 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 73 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 9 | Permit Number 46766 | 6007832.621069999 | 2093714.43935 | 37.729383856755796 | -122.41519642998199 | (37.7293838567558, -122.415196429982) | |
| 158124 | 158124 | 52937 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 436@THERESA Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 9 | Permit Number 48924 | 6002078.69882 | 2093873.61529 | 37.729495870020706 | -122.43509962926599 | (37.7294958700207, -122.435099629266) | |
| 161226 | 161226 | 129375 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 454 Walnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998637.857999999 | 2115126.2699599997 | 37.7876543864995 | -122.448524881439 | (37.7876543864995, -122.448524881439) | |||
| 170912 | 170912 | 227554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 359 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001158.33464 | 2104306.33401 | 37.7580893450524 | -122.439028803251 | (37.7580893450524, -122.439028803251) | |||
| 187717 | 187717 | 227565 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 290 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001097.22568 | 2104712.62438 | 37.7592014422066 | -122.43926926488501 | (37.7592014422066, -122.439269264885) | |||
| 2643 | 2643 | 37817 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003961.27408 | 2090526.1025099999 | 37.7204110616965 | -122.428352887393 | (37.7204110616965, -122.428352887393) |
| 2664 | 2664 | 37831 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 450X Moscow St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003870.23097 | 2090403.3538799998 | 37.720068868758105 | -122.42865884842699 | (37.7200688687581, -122.428658848427) |
| 26337 | 26337 | 227551 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 571 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003034.11181 | 2104925.46753 | 37.75989588789739 | -122.432585790315 | (37.7598958878974, -122.432585790315) | |||
| 35906 | 35906 | 227555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4611 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000604.66017 | 2104640.67953 | 37.7589758571809 | -122.440967627376 | (37.7589758571809, -122.440967627376) | |||
| 36946 | 36946 | 227079 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 7ft | 6006194.41732 | 2099504.07308 | 37.7451886989034 | -122.42127082879601 | (37.7451886989034, -122.421270828796) | |||
| 44951 | 44951 | 227560 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6000737.03493 | 2104555.7602 | 37.758750228049294 | -122.44050372379101 | (37.7587502280493, -122.440503723791) | |||
| 47371 | 47371 | 250553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.787713689594796 | -122.484739928202 | (37.7877136895948, -122.484739928202) | |||
| 49701 | 49701 | 191228 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015254.00871 | 2096807.9147599998 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | |||
| 53372 | 53372 | 82870 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 110 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 53934 | 6006630.3997599995 | 2094273.0498 | 37.730850041273996 | -122.41939224306401 | (37.730850041274, -122.419392243064) |
| 55777 | 55777 | 49803 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 8 | Permit Number 46598 | 6014016.82872 | 2106570.58674 | 37.7650297307661 | -122.394716845308 | (37.7650297307661, -122.394716845308) | |
| 58875 | 58875 | 191246 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 22 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009574.51886 | 2111002.08454 | 37.776949608681 | -122.41039468697599 | (37.776949608681, -122.410394686976) | |||
| 115973 | 115973 | 27273 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 2095X Silver Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2011 12:00:00 AM | 8 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 133333 | 133333 | 227144 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997515.89511 | 2105898.72706 | 37.7622537322474 | -122.451740727559 | (37.7622537322474, -122.451740727559) | |||
| 137003 | 137003 | 227579 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 77 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004499.29505 | 2107353.29779 | 37.7666451110058 | -122.427691415339 | (37.7666451110058, -122.427691415339) | |||
| 148576 | 148576 | 83440 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2230 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 8 | 6011076.92464 | 2105580.38381 | 37.76214696383371 | -122.404815578978 | (37.7621469638337, -122.404815578978) | ||
| 150509 | 150509 | 227085 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009638.60709 | 2096225.80995 | 37.736380874569896 | -122.409130079214 | (37.7363808745699, -122.409130079214) | |||
| 150547 | 150547 | 200836 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013076.6871 | 2107039.6693 | 37.766265411985295 | -122.398001493496 | (37.7662654119853, -122.398001493496) | |||
| 152527 | 152527 | 227145 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 266 Rivoli St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997490.50245 | 2105894.70205 | 37.7622412262784 | -122.451828260367 | (37.7622412262784, -122.451828260367) | |||
| 158472 | 158472 | 82807 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 130 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52471 | 6006613.173690001 | 2094127.5012599998 | 37.730449426586794 | -122.41944147464301 | (37.7304494265868, -122.419441474643) | |
| 169214 | 169214 | 207041 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1414 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5995889.45634 | 2093373.1410400001 | 37.727768297568005 | -122.456460143934 | (37.727768297568, -122.456460143934) | |||
| 170337 | 170337 | 227090 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6009411.625 | 2095915.20486 | 37.7355153013828 | -122.40989293540702 | (37.7355153013828, -122.409892935407) | |||
| 171127 | 171127 | 227091 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6009293.034440001 | 2095834.7354700002 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | |||
| 171343 | 171343 | 83264 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 483 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52321 | 6001958.211069999 | 2090814.3138299999 | 37.721088877137795 | -122.43529742254 | (37.7210888771378, -122.43529742254) | |
| 172334 | 172334 | 227113 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 201 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007896.8692 | 2096132.1903 | 37.736026086627 | -122.415145389863 | (37.736026086627, -122.415145389863) | |||
| 174850 | 174850 | 60223 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.5919699995 | 2117542.6242 | 37.7949000677337 | -122.41136858440399 | (37.7949000677337, -122.411368584404) | |
| 184324 | 184324 | 191220 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2300 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010900.2167 | 2105543.22676 | 37.762035060293 | -122.405424130428 | (37.762035060293, -122.405424130428) | |||
| 185174 | 185174 | 227098 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009270.38668 | 2099790.7272200002 | 37.7461487242839 | -122.41065485095801 | (37.7461487242839, -122.410654850958) | |||
| 188753 | 188753 | 129387 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006679.63776 | 2119843.90732 | 37.801064360981606 | -122.42103693222602 | (37.8010643609816, -122.421036932226) | |||
| 31107 | 31107 | 129376 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6002240.59165 | 2116825.10443 | 37.7925242837291 | -122.43618176277398 | (37.7925242837291, -122.436181762774) | |||
| 33440 | 33440 | 176906 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006512.6379 | 2093630.87617 | 37.7290801395131 | -122.419753817278 | (37.7290801395131, -122.419753817278) | |||
| 39095 | 39095 | 84344 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 581 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49738 | 5987802.4392099995 | 2112041.1140799997 | 37.778557929673205 | -122.485786324881 | (37.7785579296732, -122.485786324881) | |
| 44275 | 44275 | 227553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4445 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001135.34377 | 2105211.25899 | 37.760572740148 | -122.439173173223 | (37.760572740148, -122.439173173223) | |||
| 50407 | 50407 | 52070 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.5131099997 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | ||
| 53126 | 53126 | 83686 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.292880001 | 2117660.17543 | 37.795221808298294 | -122.411440210903 | (37.7952218082983, -122.411440210903) | |
| 55448 | 55448 | 60297 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/19/1998 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.39815254670201 | (37.7662525295396, -122.398152546702) | |
| 55458 | 55458 | 207027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 43 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997356.5626300005 | 2089224.02458 | 37.716459913666704 | -122.451089274853 | (37.7164599136667, -122.451089274853) | |||
| 55763 | 55763 | 52885 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500@ JACKSON Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2006 12:00:00 AM | 7 | Permit Number 48890 | 6002243.8338 | 2116804.81477 | 37.792468757764794 | -122.436169092224 | (37.7924687577648, -122.436169092224) | ||
| 55786 | 55786 | 129372 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999985.518069999 | 2120890.75849 | 37.80355910913379 | -122.444276660352 | (37.8035591091338, -122.444276660352) | |||
| 59525 | 59525 | 83657 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 7 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2012 12:00:00 AM | 7 | Permit Number 769748 | 6003905.60089 | 2093401.9190599998 | 37.728304266518 | -122.42875023574499 | (37.728304266518, -122.428750235745) | |
| 63496 | 63496 | 227556 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Seward St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | |||
| 63881 | 63881 | 129374 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 454 Walnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998634.47077 | 2115144.9555599997 | 37.7877054985629 | -122.448537946784 | (37.7877054985629, -122.448537946784) | |||
| 68994 | 68994 | 83834 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/04/2005 12:00:00 AM | 7 | 6013045.53048 | 2096356.5558 | 37.736930148098295 | -122.397360003177 | (37.7369301480983, -122.397360003177) | ||
| 74310 | 74310 | 129384 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008749.2926 | 2112454.6236099997 | 37.7808916402666 | -122.41335215429399 | (37.7808916402666, -122.413352154294) | |||
| 77242 | 77242 | 81630 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Paulding St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/2005 12:00:00 AM | 7 | 5999996.8419 | 2093367.66723 | 37.7279882186648 | -122.44226048643 | (37.7279882186648, -122.44226048643) | ||
| 132341 | 132341 | 227139 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 280 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997445.297590001 | 2106455.57152 | 37.763778642484205 | -122.452025073424 | (37.7637786424842, -122.452025073424) | |||
| 133135 | 133135 | 227087 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009571.148469999 | 2096096.9094 | 37.736023162027294 | -122.409354219042 | (37.7360231620273, -122.409354219042) | |||
| 137158 | 137158 | 207029 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991723.94975 | 2089189.17612 | 37.7160401362134 | -122.47055564102301 | (37.7160401362134, -122.470555641023) | |||
| 137631 | 137631 | 227157 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3330 20th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007941.59674 | 2104465.0078 | 37.758908650825504 | -122.41558053851001 | (37.7589086508255, -122.41558053851) | |||
| 147945 | 147945 | 52071 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.41051503874701 | (37.7954949369081, -122.410515038747) | ||
| 149498 | 149498 | 65594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1990 12:00:00 AM | 7 | Permit Number 28496 | 6014809.91986 | 2096215.04668 | 37.7366396697686 | -122.391249786165 | (37.7366396697686, -122.391249786165) | ||
| 160906 | 160906 | 227136 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1536 Willard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996925.1738 | 2105904.39227 | 37.7622354382362 | -122.45378420760099 | (37.7622354382362, -122.453784207601) | |||
| 161455 | 161455 | 227116 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 133 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006472.0378 | 2105330.58155 | 37.761202600143 | -122.420724416907 | (37.761202600143, -122.420724416907) | |||
| 162299 | 162299 | 83558 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 483 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52321 | 6001949.50225 | 2090800.0636599998 | 37.7210492547906 | -122.435326507535 | (37.7210492547906, -122.435326507535) | |
| 174335 | 174335 | 48448 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 238 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | 7 | Permit Number 45820 | 5997868.1487 | 2109737.2703 | 37.7728135614974 | -122.45079920226999 | (37.7728135614974, -122.45079920227) | ||
| 175666 | 175666 | 49818 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46609 | 6012222.38132 | 2102319.17957 | 37.7532563730854 | -122.400624753529 | (37.7532563730854, -122.400624753529) |
| 175916 | 175916 | 227573 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4658 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000184.94355 | 2105205.65777 | 37.7605032342671 | -122.442459762729 | (37.7605032342671, -122.442459762729) | |||
| 178180 | 178180 | 207030 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991738.49074 | 2089190.01168 | 37.716043271265704 | -122.470505441771 | (37.7160432712657, -122.470505441771) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");