Street_Tree_List

Data source: data.sfgov.org

1,480 rows where qLegalStatus = 1 and qSpecies = 35 sorted by Longitude

View and edit SQL

qLegalStatus

  • Permitted Site · 1,480
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
3013 39333 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 0 21st St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
5373 31852 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1117 Houston St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35299          
5518 39334 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 0 21st St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
6740 39332 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 0 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
11785 31851 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1117 Houston St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35299          
11986 31849 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
14197 39331 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 0 21st St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
15875 31850 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
15956 31845 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
44810 53918 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3 21st St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/21/1998 12:00:00 AM     Permit Number 40897          
85021 33758 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 842 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/1996 12:00:00 AM     Permit Number 37811 5981102.7142707 2109980.14676383 37.77250644827279 -122.508809756644 (37.7725064482728, -122.508809756644)
135919 85241 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 4331 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2007 12:00:00 AM 1   Permit Number 49544 5981367.2124 2104841.304 37.7584122600662 -122.507513483633 (37.7584122600662, -122.507513483633)
162332 85242 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 4331 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/20/2007 12:00:00 AM 1   Permit Number 49544 5981385.546 2104841.9152 37.7584150182243 -122.507450124372 (37.7584150182243, -122.507450124372)
111879 68559 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 511 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32449 5981895.88613984 2112278.88841287 37.778864841011796 -122.50623662905001 (37.7788648410118, -122.50623662905)
100869 68558 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 508 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32448 5981947.34598034 2112294.26948127 37.7789101022126 -122.50605975288799 (37.7789101022126, -122.506059752888)
157734 46392 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2474 44th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 1   Permit Number 44624 5982733.0582 2098295.9927 37.7405210225717 -122.502305471655 (37.7405210225717, -122.502305471655)
109056 51769 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3638 Lawton St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52851 5982925.7859 2104266.232 37.7569249636711 -122.50208077934201 (37.7569249636711, -122.502080779342)
40255 51768 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3638 Lawton St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/30/2009 12:00:00 AM 1 3x3 Permit Number 52851 5982945.3427 2104265.0097 37.756922756494106 -122.50201305526699 (37.7569227564941, -122.502013055267)
186101 51766 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3638 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/28/2005 12:00:00 AM 1   Permit Number 48032 5982963.9827 2104265.9264 37.7569263685127 -122.50194866004801 (37.7569263685127, -122.501948660048)
167545 51767 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3638 Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/28/2005 12:00:00 AM 1   Permit Number 48032 5982982.0116 2104266.5376 37.756929105781495 -122.501886355597 (37.7569291057815, -122.501886355597)
51315 34818 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 443 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1997 12:00:00 AM     Permit Number 38451 5983428.96299375 2112819.28622042 37.780438749009704 -122.500973171264 (37.7804387490097, -122.500973171264)
139180 34817 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 443 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1997 12:00:00 AM     Permit Number 38451 5983428.96299375 2112819.28622042 37.780438749009704 -122.500973171264 (37.7804387490097, -122.500973171264)
149853 53802 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1758 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/09/1972 12:00:00 AM 1   Permit Number 9494 5983498.0607 2103182.1267 37.7539819174643 -122.500021533616 (37.7539819174643, -122.500021533616)
123530 88091 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1619 39th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51095 5984024.3 2104125.3 37.756602478656 -122.498271356488 (37.756602478656, -122.498271356488)
51735 88092 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1619 39th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM 2 3x3 Permit Number 51095 5984042.9711 2104115.7287 37.756577293333294 -122.49820607925 (37.7565772933333, -122.49820607925)
178235 51494 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1767 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/12/2005 12:00:00 AM 1   Permit Number 47806 5984074.2238 2103158.268 37.7539502052222 -122.498027293704 (37.7539502052222, -122.498027293704)
85137 88093 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1726 39th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51097 5984135.0 2103400.2 37.7546180463975 -122.497834981734 (37.7546180463975, -122.497834981734)
72111 69039 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1465 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1994 12:00:00 AM 3   Permit Number 33045 5984314.5522 2105205.1639 37.759584498582896 -122.497347291362 (37.7595844985829, -122.497347291362)
162516 69047 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3627 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1994 12:00:00 AM 1   Permit Number 33054 5984427.5354 2106304.0281 37.762608292752105 -122.497037654386 (37.7626082927521, -122.497037654386)
82888 69140 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2639 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/18/1994 12:00:00 AM     Permit Number 33173 5984275.37028508 2097213.25013079 37.737638602389396 -122.496892944046 (37.7376386023894, -122.496892944046)
95593 96005 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3448 Balboa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2011 12:00:00 AM   3x3 Permit Number 767659 5984913.0 2111119.0 37.775857277323105 -122.495713813843 (37.7758572773231, -122.495713813843)
70235 79414 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2635 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52810 5984897.7294 2097238.629 37.7377447344094 -122.49474305383 (37.7377447344094, -122.49474305383)
124447 32174 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 119 Lakeshore Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1995 12:00:00 AM     Permit Number 35512 5984952.68570177 2094288.33327225 37.7296472241819 -122.49433563765699 (37.7296472241819, -122.494335637657)
145196 32175 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 119 Lakeshore Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1995 12:00:00 AM     Permit Number 35512 5984952.68570177 2094288.33327225 37.7296472241819 -122.49433563765699 (37.7296472241819, -122.494335637657)
18086 32173 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 117 Lakeshore Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1995 12:00:00 AM     Permit Number 35511 5984955.52028324 2094294.56016286 37.7296644874619 -122.49432629716298 (37.7296644874619, -122.494326297163)
88347 32171 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 117 Lakeshore Dr 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1995 12:00:00 AM     Permit Number 35511 5984955.52028324 2094294.56016286 37.7296644874619 -122.49432629716298 (37.7296644874619, -122.494326297163)
107326 32172 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 117 Lakeshore Dr 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1995 12:00:00 AM     Permit Number 35511 5984955.52028324 2094294.56016286 37.7296644874619 -122.49432629716298 (37.7296644874619, -122.494326297163)
114564 32169 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 117 Lakeshore Dr 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1995 12:00:00 AM     Permit Number 35511 5984955.52028324 2094294.56016286 37.7296644874619 -122.49432629716298 (37.7296644874619, -122.494326297163)
127685 32170 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 117 Lakeshore Dr 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/15/1995 12:00:00 AM     Permit Number 35511 5984955.52028324 2094294.56016286 37.7296644874619 -122.49432629716298 (37.7296644874619, -122.494326297163)
149345 92403 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1545 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52803 5985264.691000001 2104708.4468 37.7582762928221 -122.494024677293 (37.7582762928221, -122.494024677293)
71523 92404 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1545 35th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52803 5985265.6119 2104693.7127 37.7582358909523 -122.494020406574 (37.7582358909523, -122.494020406574)
54613 43848 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2634 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 3   Permit Number 43470 5985245.7192 2097273.3217 37.7378603541939 -122.493542458198 (37.7378603541939, -122.493542458198)
70310 43849 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2638 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 4   Permit Number 43471 5985246.7805 2097245.1976 37.73778319502121 -122.49353671716999 (37.7377831950212, -122.49353671717)
143293 43850 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2674 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 6   Permit Number 43472 5985253.1482 2097047.7977 37.7372415601551 -122.493500160872 (37.7372415601551, -122.493500160872)
182510 43851 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2678 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 6   Permit Number 43473 5985253.1482 2097007.4687 37.737130827494504 -122.49349719028 (37.7371308274945, -122.49349719028)
77678 50789 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 6900 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/04/2004 12:00:00 AM     Permit Number 47313 5985644.2903515 2112526.34575893 37.7797642444003 -122.493287836243 (37.7797642444003, -122.493287836243)
89242 50787 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 6900 Geary Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/04/2004 12:00:00 AM     Permit Number 47313 5985644.2903515 2112526.34575893 37.7797642444003 -122.493287836243 (37.7797642444003, -122.493287836243)
125717 50788 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 6900 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/04/2004 12:00:00 AM     Permit Number 47313 5985644.2903515 2112526.34575893 37.7797642444003 -122.493287836243 (37.7797642444003, -122.493287836243)
128771 102810 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 490 33rd Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/24/2013 12:00:00 AM 3 3x3 Permit Number 770137 5985656.77163 2112663.0068900003 37.780140206640205 -122.493254729507 (37.7801402066402, -122.493254729507)
104917 102809 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 490 33rd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3 Permit Number 33567 5985658.04889 2112631.72376 37.780054386858794 -122.493248005621 (37.7800543868588, -122.493248005621)
175887 45626 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2226 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/01/2001 12:00:00 AM 3   Permit Number 44336 5985467.3253 2100031.8294 37.745447435936896 -122.492979406528 (37.7454474359369, -122.492979406528)
172408 95443 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1634 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767305 5985639.2643 2104071.5459 37.7565494487406 -122.49268234984 (37.7565494487406, -122.49268234984)
34748 43826 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2657 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 4   Permit Number 43454 5985520.0574 2097206.122 37.7376918862353 -122.49258900314899 (37.7376918862353, -122.492589003149)
39935 43837 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2707 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 4   Permit Number 43459 5985531.9387 2096872.5005 37.736776545221204 -122.492523362027 (37.7367765452212, -122.492523362027)
81224 43843 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2729 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43465 5985530.78244018 2096757.50782257 37.736460738343204 -122.49251889363501 (37.7364607383432, -122.492518893635)
159299 43835 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2690 35th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 3   Permit Number 43458 5985569.0545 2097059.5514 37.737292307195396 -122.492408808668 (37.7372923071954, -122.492408808668)
185028 43836 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2690 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM 4   Permit Number 43458 5985569.2648 2097041.677 37.737243241151496 -122.492406765684 (37.7372432411515, -122.492406765684)
82968 43831 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2690 35th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43458 5985573.35768067 2097037.8388718998 37.737232941963605 -122.492392332362 (37.7372329419636, -122.492392332362)
99451 43832 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2690 35th Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43458 5985573.35768067 2097037.8388718998 37.737232941963605 -122.492392332362 (37.7372329419636, -122.492392332362)
102559 43833 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2690 35th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43458 5985573.35768067 2097037.8388718998 37.737232941963605 -122.492392332362 (37.7372329419636, -122.492392332362)
104307 43834 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2690 35th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43458 5985573.35768067 2097037.8388718998 37.737232941963605 -122.492392332362 (37.7372329419636, -122.492392332362)
136915 95445 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2201 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 2 3x3 Permit Number 767307 5985726.3556 2100198.6842 37.7459207192562 -122.492096016775 (37.7459207192562, -122.492096016775)
151451 95446 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2205 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 2 3x3 Permit Number 767308 5985726.3556 2100168.8125 37.7458386996409 -122.49209381774901 (37.7458386996409, -122.492093817749)
62988 92393 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2223 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52798 5985729.7695 2100081.3311 37.745598698912204 -122.49207557319401 (37.7455986989122, -122.492075573194)
46911 95592 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2210 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767309 5985769.8829 2100165.3986 37.7458318703149 -122.491943057318 (37.7458318703149, -122.491943057318)
74407 95447 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2210 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767309 5985770.3096 2100149.6093 37.745788542103206 -122.49194041962099 (37.7457885421032, -122.491940419621)
67347 92397 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2290 34th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52799 5985786.098999999 2099670.3819 37.7444736358369 -122.491850548624 (37.7444736358369, -122.491850548624)
79803 43861 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2345 Wawona St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43481 5985730.68059538 2097009.14058612 37.7371633406591 -122.491846290454 (37.7371633406591, -122.491846290454)
111978 43863 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2345 Wawona St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43481 5985730.68059538 2097009.14058612 37.7371633406591 -122.491846290454 (37.7371633406591, -122.491846290454)
116072 43862 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2345 Wawona St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2000 12:00:00 AM     Permit Number 43481 5985730.68059538 2097009.14058612 37.7371633406591 -122.491846290454 (37.7371633406591, -122.491846290454)
52716 92396 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2290 34th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52799 5985787.3792 2099657.153 37.7444373876676 -122.491845148303 (37.7444373876676, -122.491845148303)
137052 92395 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2290 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52799 5985787.8059 2099646.4846 37.7444081200554 -122.491842887636 (37.7444081200554, -122.491842887636)
69989 92394 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2290 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2009 12:00:00 AM 2 3x3 Permit Number 52799 5985787.8059 2099633.6824 37.7443729686632 -122.491841945332 (37.7443729686632, -122.491841945332)
156078 92366 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1915 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM 1 3x3 Permit Number 52779 5985969.6964 2102174.4618 37.7513598906592 -122.49139998707199 (37.7513598906592, -122.491399987072)
73741 37222 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2075 33rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM 5   Permit Number 39786 5986006.8021 2101124.4403 37.748478985005896 -122.49119440423401 (37.7484789850059, -122.491194404234)
33475 37204 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1575 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM 2   Permit Number 39771 5986202.8143 2104523.3582 37.75782293745029 -122.49076666265499 (37.7578229374503, -122.490766662655)
151321 84041 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1514 32nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/23/2009 12:00:00 AM 1 3x3 Permit Number 52690 5986231.2266 2104899.676 37.758857862275704 -122.49069609034099 (37.7588578622757, -122.490696090341)
107031 58127 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1291 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/05/1990 12:00:00 AM     Permit Number 29453 5986440.58306347 2106473.88273378 37.763192426611795 -122.490087838111 (37.7631924266118, -122.490087838111)
32121 66333 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1291 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/05/1990 12:00:00 AM 6   Permit Number 29454 5986445.8362 2106470.4022 37.763183176794705 -122.490069413492 (37.7631831767947, -122.490069413492)
135959 95525 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2925 Lincoln Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 2 3x3 Permit Number 767317 5986606.408 2107060.1496 37.764811835149295 -122.489557426261 (37.7648118351493, -122.489557426261)
186001 95591 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2925 Lincoln Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 2 3x3 Permit Number 767317 5986627.6602 2107061.3303 37.7648163177268 -122.48948400821001 (37.7648163177268, -122.48948400821)
35810 92326 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1343 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM 3 3x3 Permit Number 52758 5986769.8307 2106099.7914 37.7621844965801 -122.488921594092 (37.7621844965801, -122.488921594092)
179211 92327 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1347 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM 3 3x3 Permit Number 52759 5986769.8307 2106074.1568 37.7621141110413 -122.488919709577 (37.7621141110413, -122.488919709577)
164556 92332 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2178 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM 1 3x3 Permit Number 52764 5986694.1348 2100449.0089 37.746664568430795 -122.488768011117 (37.7466645684308, -122.488768011117)
136725 92333 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2182 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2009 12:00:00 AM 2 3x3 Permit Number 52765 5986695.3951 2100425.9019 37.7466011963621 -122.488761954977 (37.7466011963621, -122.488761954977)
29283 95438 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2186 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/2011 12:00:00 AM 1 3x3 Permit Number 767300 5986698.9662 2100381.1584 37.746478551124504 -122.48874631833598 (37.7464785511245, -122.488746318336)
51429 69307 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1522 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/16/1994 12:00:00 AM 2   Permit Number 33386 5986858.656 2104872.1171 37.758818824109 -122.48852415134701 (37.758818824109, -122.488524151347)
146393 81679 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1942 Vicente St 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 07/31/2009 12:00:00 AM 2 3x3 Permit Number 52863 5986874.2463 2097598.6809 37.738848836056 -122.487935819213 (37.738848836056, -122.487935819213)
99390 87844 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 536 28th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM   3x3 Permit Number 50751 5987246.0 2112270.7 37.7791558680057 -122.487728106826 (37.7791558680057, -122.487728106826)
46491 38115 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1342 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/28/2003 12:00:00 AM 5   Permit Number 40279 5987120.6367 2106124.4711 37.7622727278914 -122.487710118761 (37.7622727278914, -122.487710118761)
76635 38116 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1346 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/1998 12:00:00 AM 4   Permit Number 40280 5987121.6044 2106101.731 37.7622103462776 -122.487705101187 (37.7622103462776, -122.487705101187)
99434 51238 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1342 29th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/17/2004 12:00:00 AM     Permit Number 47609 5987125.87683066 2106129.95545111 37.762288092049296 -122.487692398291 (37.7622880920493, -122.487692398291)
121675 53179 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2610@ 27th Ave Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51476 5987391.86463584 2114656.62979524 37.785715458645704 -122.487398814258 (37.7857154586457, -122.487398814258)
80735 48847 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 211@ Lake St 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/07/2002 12:00:00 AM     Permit Number 46061 5987400.97577089 2114545.21286522 37.785410070991205 -122.487359105809 (37.7854100709912, -122.487359105809)
61952 44806 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1284 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/12/2001 12:00:00 AM 2   Permit Number 43901 5987417.062999999 2106562.4256 37.7634925157287 -122.486717065387 (37.7634925157287, -122.486717065387)
56036 42854 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2471 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/03/2000 12:00:00 AM 6   Permit Number 42783 5987340.671 2098461.3118 37.74124459004229 -122.486386476099 (37.7412445900423, -122.486386476099)
58689 53262 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1742 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/28/1969 12:00:00 AM 2   Permit Number 6152 5987525.5316 2103414.2811 37.7548548926849 -122.486110800407 (37.7548548926849, -122.486110800407)
134704 45075 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 2118 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2001 12:00:00 AM 5   Permit Number 43957 5987613.4283 2100841.7317 37.747796485779396 -122.48561804583099 (37.7477964857794, -122.485618045831)
43735 50229 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 1346 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/27/2003 12:00:00 AM 1   Permit Number 46937 5987742.4672 2106112.8615 37.76227710092729 -122.485558616267 (37.7622771009273, -122.485558616267)
171386 40958 Permitted Site 1 Prunus serrulata :: Ornamental Cherry 35 3442 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/1999 12:00:00 AM 3   Permit Number 41813 5987915.24459 2111913.2239 37.778213351801895 -122.485386705758 (37.7782133518019, -122.485386705758)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 3040.162ms · Data source: data.sfgov.org