Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31730 | 31730 | 33993 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2034 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2013 12:00:00 AM | 3 | Permit Number 769995 | 6001441.2983 | 2115588.3906099997 | 37.789083143910496 | -122.438858673106 | (37.7890831439105, -122.438858673106) | ||
| 31779 | 31779 | 68325 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32140 | 6006815.0166 | 2113575.49994 | 37.783860503793996 | -122.42012334783199 | (37.783860503794, -122.420123347832) | |
| 31859 | 31859 | 31232 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34918 | 5991386.50478 | 2098046.67038 | 37.7403410850744 | -122.472367334291 | (37.7403410850744, -122.472367334291) | |
| 32114 | 32114 | 49856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 76@ LAGUNA Magnolia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2003 12:00:00 AM | 4 | Permit Number 46629 | 6003390.669840001 | 2119840.41127 | 37.80086881239821 | -122.432417918359 | (37.8008688123982, -122.432417918359) | ||
| 32253 | 32253 | 38647 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1920 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 7 | Permit Number 41183 | 6000481.01223 | 2115413.16411 | 37.7885473368318 | -122.442168546961 | (37.7885473368318, -122.442168546961) | |
| 32276 | 32276 | 31868 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3633 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 7 | Permit Number 41912 | 5999648.6988 | 2121058.91348 | 37.804001595372604 | -122.445454333359 | (37.8040015953726, -122.445454333359) | |
| 32539 | 32539 | 57394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1355 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1989 12:00:00 AM | 4 | 3x3 | Permit Number 28227 | 6007983.42237 | 2117121.90556 | 37.79366382996479 | -122.41633235826299 | (37.7936638299648, -122.416332358263) | |
| 32985 | 32985 | 47409 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1245 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45320 | 5994762.6518 | 2112104.25477 | 37.7791344121855 | -122.461713045527 | (37.7791344121855, -122.461713045527) | |
| 33004 | 33004 | 37858 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 566St. Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 7 | Permit Number 40145 | 6001842.58186 | 2090205.4937 | 37.719410626184796 | -122.43565358376699 | (37.7194106261848, -122.435653583767) | |
| 33081 | 33081 | 31729 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2467 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35226 | 5990125.4261 | 2098592.0294 | 37.7417654319331 | -122.47676743237601 | (37.7417654319331, -122.476767432376) | |
| 33166 | 33166 | 43255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43041 | 6010125.284580001 | 2093194.02185 | 37.7280834802679 | -122.40723376965 | (37.7280834802679, -122.40723376965) | |
| 33519 | 33519 | 64497 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1542 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 9 | Permit Number 25376 | 6000402.8495 | 2110654.2627 | 37.7754761607449 | -122.442097242557 | (37.7754761607449, -122.442097242557) | |
| 33574 | 33574 | 53443 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 5 | Permit Number 23058 | 6007695.329609999 | 2119167.05545 | 37.7992630980807 | -122.41747419599899 | (37.7992630980807, -122.417474195999) | |
| 33694 | 33694 | 45545 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 150 Riverton Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44298 | 5987075.11092 | 2094929.45879 | 37.7315315673308 | -122.48704535198 | (37.7315315673308, -122.48704535198) | |
| 33765 | 33765 | 32484 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 203 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1996 12:00:00 AM | 7 | Permit Number 36992 | 6001040.84571 | 2106331.01428 | 37.7636419356406 | -122.43958027293002 | (37.7636419356406, -122.43958027293) | ||
| 33861 | 33861 | 43701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3342 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 5 | Permit Number 43344 | 5992980.72479 | 2110052.83989 | 37.77339904403011 | -122.46772817008001 | (37.7733990440301, -122.46772817008) | |
| 33876 | 33876 | 67957 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 886 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 5 | Permit Number 31677 | 5987616.4327300005 | 2109922.8540000003 | 37.772730941918894 | -122.48627423406799 | (37.7727309419189, -122.486274234068) | |
| 34001 | 34001 | 82881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 644 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52479 | 6007623.11914 | 2094146.28665 | 37.7305578398533 | -122.415951268757 | (37.7305578398533, -122.415951268757) | |
| 34185 | 34185 | 64492 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1570 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25369 | 6000283.6045 | 2110639.8088 | 37.775429677687995 | -122.442508700238 | (37.775429677688, -122.442508700238) | |
| 34255 | 34255 | 68402 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 127 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | Permit Number 32234 | 6002270.3264 | 2093907.92717 | 37.7296009620913 | -122.434439606907 | (37.7296009620913, -122.434439606907) | |
| 34260 | 34260 | 67963 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 882 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | Permit Number 31684 | 5986994.57488 | 2109967.9859599997 | 37.7728185972219 | -122.48842859801701 | (37.7728185972219, -122.488428598017) | |
| 34278 | 34278 | 31819 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 195 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35284 | 6009854.1227 | 2111441.50203 | 37.778171816101704 | -122.409458466633 | (37.7781718161017, -122.409458466633) | |
| 34347 | 34347 | 44742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 276 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43860 | 5992023.15498 | 2086637.27235 | 37.7090505207416 | -122.469335815893 | (37.7090505207416, -122.469335815893) | |
| 34633 | 34633 | 56154 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 442 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1973 12:00:00 AM | 6 | Permit Number 12262 | 5990943.20975 | 2112366.81543 | 37.7796347288322 | -122.474945092225 | (37.7796347288322, -122.474945092225) | ||
| 34883 | 34883 | 34644 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1507 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 4 | Permit Number 38323 | 5987736.3957 | 2105018.4617 | 37.7592718242591 | -122.485499299017 | (37.7592718242591, -122.485499299017) | |
| 34995 | 34995 | 47407 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 615 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45318 | 5993448.607469999 | 2111270.20769 | 37.7767686143956 | -122.46619819632 | (37.7767686143956, -122.46619819632) | |
| 35084 | 35084 | 63426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3511 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1987 12:00:00 AM | 11 | Permit Number 24010 | 5997342.80811 | 2116025.28768 | 37.790048717230796 | -122.45307040038999 | (37.7900487172308, -122.45307040039) | ||
| 35350 | 35350 | 60550 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 538 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | 4 | Permit Number 20160 | 5985052.81447 | 2112190.6948599997 | 37.7788080303748 | -122.49530921969601 | (37.7788080303748, -122.495309219696) | |
| 35493 | 35493 | 48678 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 581 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2002 12:00:00 AM | 2 | Permit Number 45960 | 6005081.6405 | 2110909.2726 | 37.776441882073605 | -122.42593033475201 | (37.7764418820736, -122.425930334752) | ||
| 35867 | 35867 | 31577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1723 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35116 | 5989021.1478 | 2103586.321 | 37.7554143192924 | -122.48095119881799 | (37.7554143192924, -122.480951198818) | |
| 36212 | 36212 | 60790 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 264 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/1983 12:00:00 AM | 6 | Permit Number 20464 | 5998458.1657 | 2112249.2928 | 37.7797446843644 | -122.44893925935301 | (37.7797446843644, -122.448939259353) | ||
| 36225 | 36225 | 32121 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 278#1 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 8 | Permit Number 35483 | 6003519.82131 | 2106657.45741 | 37.7646790482105 | -122.431029575562 | (37.7646790482105, -122.431029575562) | |
| 36533 | 36533 | 45511 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3060 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 4 | Permit Number 44277 | 5988860.89889 | 2094966.83884 | 37.731738166776 | -122.480874345273 | (37.731738166776, -122.480874345273) | |
| 36553 | 36553 | 60584 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1531 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 8 | Permit Number 20201 | 6000391.1057 | 2110950.8694 | 37.7762898982244 | -122.442159163176 | (37.7762898982244, -122.442159163176) | |
| 36603 | 36603 | 45048 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1874 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/07/2001 12:00:00 AM | 0 | Permit Number 43934 | 5988178.9536632 | 2102555.33901725 | 37.752534528362204 | -122.48378813711001 | (37.7525345283622, -122.48378813711) | |
| 36830 | 36830 | 32000 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1100 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1995 12:00:00 AM | 4 | Permit Number 35398 | 6004681.79036 | 2090489.9843099997 | 37.7203526336359 | -122.42585972476299 | (37.7203526336359, -122.425859724763) | |
| 37165 | 37165 | 67394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 751 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 5 | Permit Number 30891 | 5990660.6415099995 | 2110260.19062 | 37.773834136535704 | -122.475768727884 | (37.7738341365357, -122.475768727884) | |
| 37332 | 37332 | 31458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 2 | Permit Number 35026 | 6001236.64987 | 2102602.74693 | 37.7534161628409 | -122.438635890359 | (37.7534161628409, -122.438635890359) | |
| 37394 | 37394 | 39047 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009496.342 | 2105638.057 | 37.762216848178504 | -122.410286304804 | (37.7622168481785, -122.410286304804) | ||
| 37503 | 37503 | 43691 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 525 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 2 | Permit Number 43335 | 5993425.14726 | 2111878.89622 | 37.7784385555739 | -122.466323599337 | (37.7784385555739, -122.466323599337) | |
| 37525 | 37525 | 55624 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 428 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1992 12:00:00 AM | 9 | Permit Number 30322 | 6005737.866 | 2111395.9106 | 37.7778151358824 | -122.42369487071699 | (37.7778151358824, -122.423694870717) | ||
| 37562 | 37562 | 43855 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2762 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 5 | Permit Number 43476 | 5985275.17 | 2096431.4539 | 37.7355505326544 | -122.493378625972 | (37.7355505326544, -122.493378625972) | |
| 37616 | 37616 | 34801 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 311 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 7 | Permit Number 38437 | 5998132.09009 | 2088842.02869 | 37.715455411421 | -122.44838118866699 | (37.715455411421, -122.448381188667) | |
| 37630 | 37630 | 92414 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2780 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52807 | 5985278.8845 | 2096306.2218 | 37.7352068959215 | -122.49335656011499 | (37.7352068959215, -122.493356560115) |
| 37861 | 37861 | 42156 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 544 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/09/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53993 | 5989414.7005900005 | 2111630.63553 | 37.777524684762795 | -122.480178910626 | (37.7775246847628, -122.480178910626) |
| 37948 | 37948 | 84553 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 818 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50088 | 5987290.35276 | 2110337.46987 | 37.7738503500177 | -122.487432627805 | (37.7738503500177, -122.487432627805) | |
| 38014 | 38014 | 43592 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1943 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 3 | Permit Number 43253 | 5986599.433999999 | 2102022.9577 | 37.750980680205004 | -122.48921117318399 | (37.750980680205, -122.489211173184) | |
| 38064 | 38064 | 34679 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2069 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 4 | Permit Number 41918 | 6003062.63239 | 2118890.11528 | 37.7982409403347 | -122.43348511594 | (37.7982409403347, -122.43348511594) | |
| 38516 | 38516 | 67659 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 44 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 9 | Permit Number 31260 | 6014110.85725 | 2093863.20548 | 37.7301431741556 | -122.393502220965 | (37.7301431741556, -122.393502220965) | |
| 38535 | 38535 | 62099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2423 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1985 12:00:00 AM | 8 | Permit Number 22192 | 6003671.00405 | 2116729.08453 | 37.7923418022811 | -122.431225634948 | (37.7923418022811, -122.431225634948) | ||
| 38558 | 38558 | 57413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1976 12:00:00 AM | 5 | Permit Number 16255 | 5996562.3267 | 2113747.4862 | 37.78374972289961 | -122.455606076565 | (37.7837497228996, -122.455606076565) | ||
| 38589 | 38589 | 60786 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 184 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 2 | Permit Number 20458 | 5998502.4989 | 2112521.0456 | 37.780493382223 | -122.448805471636 | (37.780493382223, -122.448805471636) | |
| 38648 | 38648 | 68912 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 10 Florence St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32890 | 6008496.870730001 | 2118345.67653 | 37.797052862167604 | -122.41464241973 | (37.7970528621676, -122.41464241973) | |
| 38869 | 38869 | 47100 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 229 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 4 | Permit Number 45081 | 5996640.441000001 | 2111213.02603 | 37.7767952462698 | -122.455152622085 | (37.7767952462698, -122.455152622085) | |
| 39072 | 39072 | 58938 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1354 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1980 12:00:00 AM | 4 | Permit Number 18216 | 6011960.102969999 | 2102068.33335 | 37.7525529728507 | -122.401514142577 | (37.7525529728507, -122.401514142577) | ||
| 39240 | 39240 | 52917 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2606@ SCOTT Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2006 12:00:00 AM | 5 | Permit Number 48904 | 6001656.51059 | 2116675.28524 | 37.792079717356 | -122.438191960699 | (37.792079717356, -122.438191960699) | ||
| 39554 | 39554 | 38584 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1601 Quesada Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40543 | 6015197.8625 | 2094625.9840000002 | 37.7322979479453 | -122.389797530007 | (37.7322979479453, -122.389797530007) | |
| 39587 | 39587 | 87180 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1850 Rivera St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50167 | 5987363.9346 | 2100338.1081 | 37.7463991299213 | -122.48644380105499 | (37.7463991299213, -122.486443801055) | |
| 39643 | 39643 | 46463 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 31 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2002 12:00:00 AM | 8 | Permit Number 44667 | 6013974.3230800005 | 2095449.0350900001 | 37.7344899510581 | -122.39408521636801 | (37.7344899510581, -122.394085216368) | ||
| 40267 | 40267 | 43856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2770 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43477 | 5985275.7006 | 2096383.1652 | 37.7354179757794 | -122.49337323491999 | (37.7354179757794, -122.49337323492) | |
| 40354 | 40354 | 53351 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2274 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | Permit Number 6244 | 5988266.9432 | 2099841.7174 | 37.7450887673736 | -122.483284958368 | (37.7450887673736, -122.483284958368) | |
| 40588 | 40588 | 65111 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 3 | Permit Number 27080 | 5989001.55724 | 2114468.21758 | 37.785291873757295 | -122.481815995928 | (37.7852918737573, -122.481815995928) | |
| 40596 | 40596 | 69408 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 981 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 4 | Permit Number 33513 | 6001538.598040001 | 2086768.9797900002 | 37.7099574510375 | -122.43645851206301 | (37.7099574510375, -122.436458512063) | |
| 40778 | 40778 | 31726 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2457 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35224 | 5990124.6943 | 2098653.4978 | 37.741934165798995 | -122.47677445266599 | (37.741934165799, -122.476774452666) | |
| 40927 | 40927 | 43854 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2750 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 5 | Permit Number 43475 | 5985271.1902 | 2096508.1321 | 37.7357608377733 | -122.49339803308001 | (37.7357608377733, -122.49339803308) | |
| 41094 | 41094 | 68347 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 479 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 10 | Permit Number 32166 | 5989354.45266 | 2112083.78554 | 37.7787654076266 | -122.48042050354601 | (37.7787654076266, -122.480420503546) | |
| 41179 | 41179 | 31559 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 178 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35104 | 5998526.8653 | 2112524.7682 | 37.7805049968836 | -122.448721445326 | (37.7805049968836, -122.448721445326) | ||
| 41477 | 41477 | 101694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 265X Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5996668.18061 | 2111006.52263 | 37.7762298334399 | -122.45504173762698 | (37.7762298334399, -122.455041737627) | |||
| 41559 | 41559 | 98163 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2810 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2012 12:00:00 AM | 3 | 5x6 | Permit Number 768567 | 6001207.65142 | 2115957.84021 | 37.7900842611176 | -122.439693556909 | (37.7900842611176, -122.439693556909) | |
| 41615 | 41615 | 48776 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2423 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 52958 | 6001866.8355 | 2117312.40288 | 37.793841036894996 | -122.43750988067801 | (37.793841036895, -122.437509880678) | ||
| 41900 | 41900 | 66953 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 241 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | 3 | Permit Number 30282 | 5996650.5039099995 | 2111138.3656900004 | 37.7765908258581 | -122.455112415266 | (37.7765908258581, -122.455112415266) | |
| 42021 | 42021 | 95125 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 91 Rotteck St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54053 | 6003379.33035 | 2094579.25553 | 37.731507167824 | -122.430653552813 | (37.731507167824, -122.430653552813) |
| 42033 | 42033 | 43829 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2676 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43457 | 5985566.531 | 2097143.2459 | 37.737521962445705 | -122.49242369498 | (37.7375219624457, -122.49242369498) | |
| 42191 | 42191 | 47070 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 610 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/02/2002 12:00:00 AM | 7 | Permit Number 45053 | 6004032.90703 | 2110923.42535 | 37.7764214179404 | -122.429559210103 | (37.7764214179404, -122.429559210103) | |
| 42301 | 42301 | 30496 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2460 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1985 12:00:00 AM | 5 | Permit Number 22043 | 6001850.15003 | 2117377.4559 | 37.7940187069382 | -122.43757227473999 | (37.7940187069382, -122.43757227474) | ||
| 42365 | 42365 | 47394 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 492 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45308 | 5995008.66399 | 2112223.96074 | 37.7794772512056 | -122.46087067285102 | (37.7794772512056, -122.460870672851) | |
| 42438 | 42438 | 65220 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 438 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 15 | Permit Number 28007 | 6002076.3517 | 2091079.52692 | 37.72182380131979 | -122.434908002604 | (37.7218238013198, -122.434908002604) | |
| 42532 | 42532 | 51420 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 655 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2004 12:00:00 AM | 3 | Permit Number 47745 | 6013231.54034 | 2110531.34183 | 37.7758613840288 | -122.397710814302 | (37.7758613840288, -122.397710814302) | |
| 42579 | 42579 | 34802 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 314 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1997 12:00:00 AM | 5 | Permit Number 38438 | 5998143.868319999 | 2088884.5785 | 37.7155729168266 | -122.448343540327 | (37.7155729168266, -122.448343540327) | |
| 42655 | 42655 | 45085 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2310 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43967 | 5987349.47 | 2099507.712 | 37.7441182403398 | -122.486432860446 | (37.7441182403398, -122.486432860446) | |
| 42925 | 42925 | 67228 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 679 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 5 | Permit Number 30687 | 5983489.7095099995 | 2111188.94144 | 37.775965863323 | -122.500642433993 | (37.775965863323, -122.500642433993) | |
| 43008 | 43008 | 38589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1606 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1998 12:00:00 AM | 6 | Permit Number 40544 | 6015214.8687 | 2094687.4678 | 37.7324677131079 | -122.389743028049 | (37.7324677131079, -122.389743028049) | |
| 43101 | 43101 | 41909 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 774 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 5 | Permit Number 42272 | 5992600.74218 | 2110192.2118 | 37.7737597740758 | -122.46905271709 | (37.7737597740758, -122.46905271709) | |
| 43152 | 43152 | 68657 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 243 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 8 | Permit Number 32564 | 5993662.97724 | 2113866.3239700003 | 37.7839092140163 | -122.46564528953002 | (37.7839092140163, -122.46564528953) | |
| 43205 | 43205 | 36955 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 375 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39586 | 5994624.16459 | 2113023.06924 | 37.7816492574469 | -122.46225878194201 | (37.7816492574469, -122.462258781942) | |
| 43248 | 43248 | 68349 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 527 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 6 | Permit Number 32168 | 5991569.001 | 2111811.09611 | 37.7781451219305 | -122.47273970036899 | (37.7781451219305, -122.472739700369) | |
| 43285 | 43285 | 38380 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 722 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/1998 12:00:00 AM | 4 | Permit Number 40439 | 5990392.11079 | 2110429.52825 | 37.7742835191546 | -122.47670998353901 | (37.7742835191546, -122.476709983539) | ||
| 43576 | 43576 | 68892 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 7 | Permit Number 32864 | 6012556.44634 | 2091062.56254 | 37.7223666905441 | -122.398679591909 | (37.7223666905441, -122.398679591909) | |
| 43723 | 43723 | 43544 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1808 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | 10 | Permit Number 43209 | 6000435.9514 | 2111350.611 | 37.7773900427547 | -122.442032729545 | (37.7773900427547, -122.442032729545) | |
| 43727 | 43727 | 45086 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2310 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43967 | 5987348.1163 | 2099529.371 | 37.7441776312875 | -122.486439131059 | (37.7441776312875, -122.486439131059) | |
| 43838 | 43838 | 52448 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 431 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 4 | Permit Number 48560 | 5992472.90838 | 2112504.99178 | 37.780102654065 | -122.469663313675 | (37.780102654065, -122.469663313675) | |
| 43909 | 43909 | 49837 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 610@ 18th ST San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46620 | 6010937.1736 | 2105420.43613 | 37.7616999711052 | -122.40528766280899 | (37.7616999711052, -122.405287662809) | |
| 44021 | 44021 | 43660 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 226 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 5 | Permit Number 43303 | 5992466.9959 | 2113900.33268 | 37.783933536641 | -122.469785383042 | (37.783933536641, -122.469785383042) | |
| 44335 | 44335 | 60787 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 210 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | 6 | Permit Number 20460 | 5998412.8171 | 2112484.496 | 37.780387897645795 | -122.449113088127 | (37.7803878976458, -122.449113088127) | |
| 44470 | 44470 | 33977 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 344 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | Permit Number 37920 | 5990607.48731 | 2113091.65197 | 37.781605467696295 | -122.47615944559799 | (37.7816054676963, -122.476159445598) | ||
| 44568 | 44568 | 47936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 235 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45671 | 5996315.56567541 | 2094902.75702129 | 37.7319927097789 | -122.45509757060199 | (37.7319927097789, -122.455097570602) | ||
| 44598 | 44598 | 31928 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 440 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 6 | Permit Number 35344 | 5991750.017519999 | 2100486.13622 | 37.7470602654233 | -122.47128815772301 | (37.7470602654233, -122.471288157723) | |
| 44839 | 44839 | 84348 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3332-3334 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50580 | 6007340.92664153 | 2105019.75450207 | 37.760398074706 | -122.417697261406 | (37.760398074706, -122.417697261406) | ||
| 44868 | 44868 | 40014 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25X Bay View St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 7 | 3x3 | Permit Number 50722 | 6014394.45523 | 2094706.7316599998 | 37.7324750793504 | -122.39258076118799 | (37.7324750793504, -122.392580761188) | |
| 44897 | 44897 | 67602 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 206 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/1992 12:00:00 AM | 6 | Permit Number 31173 | 6013425.35879 | 2106076.07377 | 37.7636390047618 | -122.39672793716998 | (37.7636390047618, -122.39672793717) |
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");