Street_Tree_List

Data source: data.sfgov.org

6,719 rows where qSpecies = 16 sorted by Longitude

View and edit SQL

Suggested facets: qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
3019 20034 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
3951 20035 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
4351 36746 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 5555 Woodward St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/26/1998 12:00:00 AM     Permit Number 39516          
5302 35167 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 240 Walter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/02/1998 12:00:00 AM     Permit Number 38700          
5746 31847 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7293 31848 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
7527 20039 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
9510 46857 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/25/2002 12:00:00 AM     Permit Number 44926          
10575 20040 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 ST            
10952 43297 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1501 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/2000 12:00:00 AM     Permit Number 43066          
11795 31846 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/1995 12:00:00 AM     Permit Number 35298          
11812 20044 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
12976 20042 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 13 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
13223 33083 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14695 20043 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 100 STAIRWAY51 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 ST            
14881 33084 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/05/1996 12:00:00 AM     Permit Number 37336          
83651 68577 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 139 Sutro Heights Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32471 5981217.74443457 2111271.39856875 37.7760586259822 -122.508507736704 (37.7760586259822, -122.508507736704)
149511 34721 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 5535 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM 4   Permit Number 38376 5981434.12386 2111625.14448 37.7770426583791 -122.507785493074 (37.7770426583791, -122.507785493074)
170734 67270 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 539 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/09/1992 12:00:00 AM 3   Permit Number 30743 5981594.696269999 2112052.0019099996 37.7782241419477 -122.50726170878299 (37.7782241419477, -122.507261708783)
154522 118420 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 5501 Anza St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   5981593.2087199995 2111630.13422 37.7770657300516 -122.507235548964 (37.7770657300516, -122.507235548964)
105081 36131 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1579 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/29/1998 12:00:00 AM     Permit Number 39226 5981546.79724008 2104343.49116474 37.7570559852656 -122.50685548584299 (37.7570559852656, -122.506855485843)
24853 47834 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 891 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/17/2007 12:00:00 AM 4 3x3 Permit Number 49787 5981681.239030001 2109702.6053299997 37.7717784851525 -122.50678802713199 (37.7717784851525, -122.506788027132)
131523 118430 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 5400 Anza St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   5981830.664890001 2111695.69394 37.7772597209712 -122.506418991145 (37.7772597209712, -122.506418991145)
185018 118428 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 5400 Anza St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5981858.846609999 2111695.90062 37.7772619476301 -122.50632151854099 (37.7772619476301, -122.506321518541)
9777 88104 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1247 46th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   4x10 Permit Number 51108 5981754.7 2106590.8 37.763238693975296 -122.50630313344999 (37.7632386939753, -122.50630313345)
72566 83831 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1249-1249 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/23/2008 12:00:00 AM 3 4x9 Permit Number 50162 5981782.7749 2106603.6182 37.7632755418665 -122.50620698388599 (37.7632755418665, -122.506206983886)
160579 68561 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 531 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 4   Permit Number 32451 5981904.26903 2112120.67838 37.7784309363863 -122.50619589543699 (37.7784309363863, -122.506195895437)
168261 68777 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 555 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/16/1993 12:00:00 AM 4   Permit Number 32707 5981911.30335 2111941.60843 37.777939677133205 -122.506158280277 (37.7779396771332, -122.506158280277)
45509 68562 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 532 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM 5   Permit Number 32452 5981948.24889 2112111.86912 37.7784093377083 -122.50604310187401 (37.7784093377083, -122.506043101874)
33287 118775 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 630 45th Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     27 Width 2ft   5981986.088380001 2111427.82901 37.7765333919608 -122.50586147692101 (37.7765333919608, -122.505861476921)
186216 250997 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 415 44th Ave 1 : 4 Tree 1 Private 1     5 Width 3ft   5982186.75835 2112941.64621 37.7807016980586 -122.505279538125 (37.7807016980586, -122.505279538125)
107860 81964 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 455 44th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2007 12:00:00 AM   3x3 Permit Number 50002 5982191.84204192 2112715.55923715 37.780081229053 -122.505245190233 (37.780081229053, -122.505245190233)
30707 250995 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 453 44th Ave 2 : 4 Tree 1 Private 1     5 Width 3ft   5982194.00965 2112744.27477 37.780160200984604 -122.505239820464 (37.7801602009846, -122.505239820464)
26055 70169 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 5233 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/10/1993 12:00:00 AM 3     5982394.507019999 2111657.31782 37.777187531817496 -122.504465669217 (37.7771875318175, -122.504465669217)
121137 68542 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 514 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32426 5982569.023547499 2112276.16618805 37.7788969713665 -122.503907817569 (37.7788969713665, -122.503907817569)
94759 47444 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 651 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/14/2002 12:00:00 AM     Permit Number 45354 5982550.9590229 2111342.50779778 37.7763323565324 -122.503901138971 (37.7763323565324, -122.503901138971)
55330 37078 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1318 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/20/2002 12:00:00 AM 2   Permit Number 39680 5982466.3981 2106106.9098 37.761951943280394 -122.50380580728 (37.7619519432804, -122.50380580728)
166287 55604 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 658 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/08/1973 12:00:00 AM 1   Permit Number 773340 5982601.78539 2111293.4380900003 37.7762006139918 -122.50372168450501 (37.7762006139918, -122.503721684505)
171448 83913 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1659 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/23/2008 12:00:00 AM 1 3x3 Permit Number 50155 5982499.5096 2103826.5104 37.7556925599446 -122.503522416925 (37.7556925599446, -122.503522416925)
54349 79894 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 4119 Clement St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/20/2001 12:00:00 AM 7     5982716.5012300005 2113074.1195 37.78109658773229 -122.503456745272 (37.7810965877323, -122.503456745272)
67159 92236 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 551 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/22/2009 12:00:00 AM 2 3x3 Permit Number 52679 5982837.48707 2112035.40062 37.7782516820937 -122.502961282193 (37.7782516820937, -122.502961282193)
155742 40221 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1463 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/06/1999 12:00:00 AM 4   Permit Number 41400 5982763.9993 2105167.6847 37.7593905919599 -122.502707013206 (37.7593905919599, -122.502707013206)
171006 72283 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 779 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 4     5982894.68666 2110493.65125 37.774021849099704 -122.502649263154 (37.7740218490997, -122.502649263154)
171943 184308 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1555 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982786.0012 2104528.3348 37.7576364108681 -122.502583598561 (37.7576364108681, -122.502583598561)
70691 184573 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1731 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5982827.3086 2103329.3402 37.754346736395995 -122.502352009826 (37.754346736396, -122.502352009826)
26539 184576 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1735 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5982829.6776 2103308.6964 37.75429019350779 -122.50234228965799 (37.7542901935078, -122.502342289658)
24589 184585 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1743 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5982830.016 2103255.9026 37.754145256427606 -122.50233721253099 (37.7541452564276, -122.502337212531)
102609 89562 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 5027 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/27/2008 12:00:00 AM 3 3x3   5983024.08969 2111679.84197 37.7772863874511 -122.50228944566099 (37.7772863874511, -122.502289445661)
185728 51437 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 535 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/19/2004 12:00:00 AM 2   Permit Number 47757 5983145.9728 2112126.6615400002 37.7785203841092 -122.501900888351 (37.7785203841092, -122.501900888351)
132519 47430 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 651 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 5   Permit Number 45341 5983172.9702 2111364.55723 37.776429453588 -122.501751096095 (37.776429453588, -122.501751096095)
106043 89022 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 801 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2008 12:00:00 AM   3x3 Permit Number 51767 5983196.2 2110303.4 37.7735171880717 -122.501592216483 (37.7735171880717, -122.501592216483)
175787 49394 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 868 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/18/2003 12:00:00 AM 4   Permit Number 46347 5983274.10488 2109909.62702 37.7724405765784 -122.50129360387301 (37.7724405765784, -122.501293603873)
45057 70451 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2683 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/1994 12:00:00 AM 4     5983041.4986 2096885.6865 37.7366668238827 -122.5011347377 (37.7366668238827, -122.5011347377)
138008 56715 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 3550 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2     5983275.5384 2103598.154 37.75511115010929 -122.50082181985901 (37.7551111501093, -122.500821819859)
46105 117727 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 432 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   5983474.89929 2112887.7743599997 37.780629494505796 -122.50081932484501 (37.7806294945058, -122.500819324845)
67414 117728 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 432 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 4ft   5983476.79722 2112873.2862 37.780589825682895 -122.50081168738001 (37.7805898256829, -122.50081168738)
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)
66582 47427 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 743 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 3   Permit Number 45338 5983505.42349 2110743.75617 37.7747444359741 -122.500555150992 (37.7747444359741, -122.500555150992)
176672 50404 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 650 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2003 12:00:00 AM 1   Permit Number 47055 5983530.01588 2111373.74494 37.776475646301606 -122.500516673446 (37.7764756463016, -122.500516673446)
151092 72277 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 819 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 6     5983524.1138 2110218.5518 37.773303473649605 -122.500451657892 (37.7733034736496, -122.500451657892)
59594 67226 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 858 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1992 12:00:00 AM 2   Permit Number 30685 5983581.64532 2109958.3486599997 37.7725924077801 -122.500233411273 (37.7725924077801, -122.500233411273)
51275 67225 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 862 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1992 12:00:00 AM 3   Permit Number 30684 5983582.48092 2109929.96399 37.7725145206954 -122.50022842205 (37.7725145206954, -122.50022842205)
165978 67253 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 878 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1992 12:00:00 AM 4   Permit Number 30717 5983587.04483 2109836.93635 37.7722593614509 -122.50020575664101 (37.7722593614509, -122.500205756641)
114510 84877 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1951 41st Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2007 12:00:00 AM     Permit No. 49250 5983480.4 2101864.4 37.7503627699789 -122.499985207399 (37.7503627699789, -122.499985207399)
128529 84876 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1951 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2007 12:00:00 AM     Permit No. 49250 5983480.4 2101864.4 37.7503627699789 -122.499985207399 (37.7503627699789, -122.499985207399)
171845 54485 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 524 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/14/1995 12:00:00 AM 3   Permit Number 10277 5983807.43995 2112211.38308 37.778791839243205 -122.499618921418 (37.7787918392432, -122.499618921418)
175620 117840 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 600x 39th Ave 2 Median : Cutout 11 Tree 1 DPW 2     2 Width 6ft   5983808.599090001 2111637.58628 37.777216427782896 -122.499572493795 (37.7772164277829, -122.499572493795)
60634 117841 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 600x 39th Ave 1 Median : Cutout 11 Tree 1 DPW 2     2 Width 6ft   5983809.68656 2111621.06726 37.7771711351486 -122.499567510814 (37.7771711351486, -122.499567510814)
51598 117842 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 620x 39th Ave 5 Median : Cutout 11 Tree 1 DPW 2     2 Width 6ft   5983810.65643 2111554.107 37.7769873385843 -122.499559205901 (37.7769873385843, -122.499559205901)
154043 117830 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 870 39th Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5983887.3151 2110064.19539 37.77290096878129 -122.499183906851 (37.7729009687813, -122.499183906851)
33246 102378 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 870 39th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     2     5983886.84831 2110037.48525 37.7728276030319 -122.499183547509 (37.7728276030319, -122.499183547509)
69190 102377 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 870 39th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Rec/Park 3     3     5983889.8768 2109995.31333 37.7727119887219 -122.49916995510901 (37.7727119887219, -122.499169955109)
154893 49552 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 1606@ LAWTON 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2003 12:00:00 AM 1   Permit Number 46442 5983773.0639 2104184.1322 37.7567492805381 -122.499144554539 (37.7567492805381, -122.499144554539)
161530 67267 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 552 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/09/1992 12:00:00 AM 3   Permit Number 30740 5984123.38609 2112065.40916 37.7784095705965 -122.49851517128599 (37.7784095705965, -122.498515171286)
56474 183181 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2401 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5983915.9024 2098758.6426 37.7418607608057 -122.49824988070299 (37.7418607608057, -122.498249880703)
153700 183184 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2415 40th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983915.9024 2098706.2108 37.7417167973555 -122.49824600919202 (37.7417167973555, -122.498246009192)
155036 183182 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2411 40th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983916.579 2098737.6699 37.74180321515429 -122.498245992674 (37.7418032151543, -122.498245992674)
137406 183183 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2413 40th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5983917.2555 2098721.0947 37.7417577438343 -122.49824242970399 (37.7417577438343, -122.498242429704)
91592 37724 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2400X 40TH AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
96765 37720 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2400X 40TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
122602 37719 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2400X 40TH AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
124347 37718 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2400X 40TH AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/1998 12:00:00 AM     Permit Number 40087 5983946.0 2098489.0 37.741122160337504 -122.498125905701 (37.7411221603375, -122.498125905701)
162710 118025 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 455 37th Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5984366.92897 2112698.04941 37.7801608967117 -122.49771940229799 (37.7801608967117, -122.497719402298)
151019 47423 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 679 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 3   Permit Number 45334 5984421.41273 2111219.03192 37.7761031357935 -122.497421700614 (37.7761031357935, -122.497421700614)
66202 46259 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2401 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/2002 12:00:00 AM 3   Permit Number 44544 5984226.0421 2098787.5863 37.741958412916105 -122.497179671255 (37.7419584129161, -122.497179671255)
62444 46260 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 2401 39th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/30/2002 12:00:00 AM 3   Permit Number 44544 5984227.7748 2098774.5909 37.741922832622 -122.497172721174 (37.741922832622, -122.497172721174)
59340 184148 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1590 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5984387.4321 2104376.7436 37.7573141589658 -122.49703409299102 (37.7573141589658, -122.497034092991)
55066 111025 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 699x 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x3   5984730.84558 2111224.06012 37.7761350733047 -122.496351676847 (37.7761350733047, -122.496351676847)
137039 111026 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 699x 36th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   5984732.6875 2111184.59691 37.7760268265664 -122.496342392756 (37.7760268265664, -122.496342392756)
135677 118269 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 699 36th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5984732.8096199995 2111158.8686 37.7759561911706 -122.49634007150401 (37.7759561911706, -122.496340071504)
136753 47422 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 882 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 3   Permit Number 45333 5984826.62197 2109866.02853 37.7724119173032 -122.49592016034201 (37.7724119173032, -122.495920160342)
60410 118066 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 415 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   5984976.2398 2113055.57112 37.7811782471615 -122.495637927617 (37.7811782471615, -122.495637927617)
130107 47416 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 419 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 4   Permit Number 45327 5984977.87864 2113027.24246 37.7811005608257 -122.495630168001 (37.7811005608257, -122.495630168001)
136014 118067 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 423 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5984977.9667 2113013.83856 37.7810637627503 -122.495628874406 (37.7810637627503, -122.495628874406)
185253 38724 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 439 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 7   Permit Number 45328 5984981.48092 2112906.9180099997 37.7807703956275 -122.49560882850099 (37.7807703956275, -122.495608828501)
124445 60548 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 511 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM     Permit Number 20158 5984997.83219607 2112387.91202298 37.7793463125181 -122.495513971823 (37.7793463125181, -122.495513971823)
180542 118261 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 507 35th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5984999.83681 2112374.81786 37.779310477103294 -122.49550607110599 (37.7793104771033, -122.495506071106)
139173 60546 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 500 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM     Permit Number 20156 5985047.62508393 2112456.532077 37.7795376389344 -122.495346781978 (37.7795376389344, -122.495346781978)
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)
150768 60565 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 695 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1982 12:00:00 AM 6   Permit Number 20175 5985042.36004 2111233.42242 37.7761790231769 -122.49527477111299 (37.7761790231769, -122.495274771113)

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 2812.208ms · Data source: data.sfgov.org