Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 48882 | 48882 | 111292 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 291 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991505.832330001 | 2113494.12901 | 37.78276261074429 | -122.47308099011002 | (37.7827626107443, -122.47308099011) | |||
| 77340 | 77340 | 112100 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 78997 | 78997 | 112099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 80264 | 80264 | 116708 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 82303 | 82303 | 116707 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2699 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009829.68874677 | 2105460.44811296 | 37.7617478547189 | -122.40912084667299 | (37.7617478547189, -122.409120846673) | ||||
| 83862 | 83862 | 121571 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 35 Woodward St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6006513.38590805 | 2108286.22014995 | 37.7693204178219 | -122.420791248972 | (37.7693204178219, -122.420791248972) | ||||
| 106592 | 106592 | 112101 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 108021 | 108021 | 112102 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 200X RICHLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 6006012.0 | 2096107.0 | 37.7358508133721 | -122.421660362723 | (37.7358508133721, -122.421660362723) | |||
| 113514 | 113514 | 113368 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 90 Bronte St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009303.14527846 | 2096925.28322047 | 37.738282678059605 | -122.41033928886101 | (37.7382826780596, -122.410339288861) | ||||
| 141023 | 141023 | 117556 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1314 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007674.4763735 | 2101992.27281083 | 37.75210406660779 | -122.416329227522 | (37.7521040666078, -122.416329227522) | |||
| 187880 | 187880 | 83324 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 354 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 4x3 | 5987173.082 | 2113552.1603 | 37.782670140120295 | -122.48807454413901 | (37.7826701401203, -122.488074544139) | ||
| 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) | |
| 72959 | 72959 | 66951 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 215 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | 6 | Permit Number 30278 | 5996621.348809999 | 2111366.70352 | 37.777216108990295 | -122.45522977568001 | (37.7772161089903, -122.45522977568) | |
| 132328 | 132328 | 66840 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 219 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | 5 | Permit Number 30281 | 5996624.75082 | 2111349.11485 | 37.7771680103021 | -122.455216735737 | (37.7771680103021, -122.455216735737) | |
| 184320 | 184320 | 66954 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 233 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | 5 | Permit Number 30283 | 5996643.42444 | 2111190.44092 | 37.7767334046408 | -122.45514066907101 | (37.7767334046408, -122.455140669071) | |
| 119401 | 119401 | 66388 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 356 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29514 | 6002742.70754595 | 2109761.69750647 | 37.7731584652371 | -122.433939310336 | (37.7731584652371, -122.433939310336) | ||
| 183700 | 183700 | 68974 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3555 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 8 | Permit Number 32964 | 5999680.68438 | 2120824.08507 | 37.803358645751295 | -122.44532675102501 | (37.8033586457513, -122.445326751025) | |
| 88496 | 88496 | 37046 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 111 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | Permit Number 39652 | 6005218.05274193 | 2098707.44239672 | 37.742946239057495 | -122.42459027630301 | (37.7429462390575, -122.424590276303) | ||
| 95009 | 95009 | 64795 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 631 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25794 | 6002386.47068217 | 2100020.71974534 | 37.7463918703816 | -122.43447497238199 | (37.7463918703816, -122.434474972382) | ||
| 95190 | 95190 | 64815 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4023 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25824 | 6003747.29974038 | 2100382.29605917 | 37.7474618286155 | -122.429795169077 | (37.7474618286155, -122.429795169077) | ||
| 103529 | 103529 | 64796 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25795 | 6002429.63187351 | 2100023.00695662 | 37.746400600483206 | -122.434325889637 | (37.7464006004832, -122.434325889637) | ||
| 138544 | 138544 | 64798 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 477 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1989 12:00:00 AM | Permit Number 25797 | 6003429.85929429 | 2100071.57951916 | 37.746590692358104 | -122.43087068562401 | (37.7465906923581, -122.430870685624) | ||
| 54057 | 54057 | 39694 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1770 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | 8 | Permit Number 41079 | 6014361.02925 | 2095331.7699799999 | 37.7341894506734 | -122.392740033843 | (37.7341894506734, -122.392740033843) | |
| 100318 | 100318 | 32773 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | Permit Number 777166 | 6000581.70628279 | 2110842.47785635 | 37.7760031430575 | -122.44149204508301 | (37.7760031430575, -122.441492045083) | ||
| 128279 | 128279 | 32772 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2016 12:00:00 AM | Permit Number 777166 | 6000581.70628279 | 2110842.47785635 | 37.7760031430575 | -122.44149204508301 | (37.7760031430575, -122.441492045083) | ||
| 45294 | 45294 | 72250 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 360 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 7 | 6002105.68115 | 2091634.84352 | 37.7233502412928 | -122.434846310935 | (37.7233502412928, -122.434846310935) | ||
| 56354 | 56354 | 72253 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 9 | 6002525.5538800005 | 2090783.37547 | 37.7210361300962 | -122.433334076631 | (37.7210361300962, -122.433334076631) | ||
| 66886 | 66886 | 70849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 342 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6002406.02923 | 2091608.4235099999 | 37.723294745932705 | -122.43380617753799 | (37.7232947459327, -122.433806177538) | ||
| 73480 | 73480 | 72247 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 463 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6002254.00349 | 2090778.2369799998 | 37.721006611639204 | -122.434272377969 | (37.7210066116392, -122.434272377969) | ||
| 137136 | 137136 | 70242 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 534 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 10 | 6002535.969769999 | 2090796.29844 | 37.7210722045999 | -122.43329899495701 | (37.7210722045999, -122.433298994957) | ||
| 183763 | 183763 | 72256 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 663 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002588.76079 | 2089788.4767900002 | 37.718307944930004 | -122.43304454347499 | (37.71830794493, -122.433044543475) | ||
| 96270 | 96270 | 39761 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 614 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41128 | 6002993.27838861 | 2104685.30364209 | 37.7592341397996 | -122.432709857016 | (37.7592341397996, -122.432709857016) | ||
| 108404 | 108404 | 39759 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 610 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41127 | 6002992.35862594 | 2104701.94013783 | 37.7592797674618 | -122.432714226416 | (37.7592797674618, -122.432714226416) | ||
| 127790 | 127790 | 39760 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 610 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41127 | 6002992.35862594 | 2104701.94013783 | 37.7592797674618 | -122.432714226416 | (37.7592797674618, -122.432714226416) | ||
| 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) | |
| 75076 | 75076 | 60582 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1426 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 10 | Permit Number 20198 | 6000937.5822 | 2111077.0426 | 37.776667466633796 | -122.44027780516701 | (37.7766674666338, -122.440277805167) | |
| 78987 | 78987 | 60586 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1539 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | Permit Number 20203 | 6000401.58465504 | 2110947.80103865 | 37.7762820704764 | -122.442122693377 | (37.7762820704764, -122.442122693377) | ||
| 139603 | 139603 | 61265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 536 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1984 12:00:00 AM | Permit Number 21154 | 6007808.87042057 | 2096393.95276278 | 37.7367398832799 | -122.415468164194 | (37.7367398832799, -122.415468164194) | ||
| 50098 | 50098 | 49044 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 79 Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46218 | 5995600.89018522 | 2093144.22655709 | 37.7271231825202 | -122.45744116150101 | (37.7271231825202, -122.457441161501) | ||
| 79763 | 79763 | 49051 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 55 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46222 | 5993672.55552624 | 2093155.09549516 | 37.727042075487496 | -122.46410812816002 | (37.7270420754875, -122.46410812816) | ||
| 80459 | 80459 | 34179 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 514 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46223 | 5995415.14715319 | 2092747.45765731 | 37.7260230798326 | -122.458054566673 | (37.7260230798326, -122.458054566673) | ||
| 89167 | 89167 | 49043 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 79 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46218 | 5995600.89018522 | 2093144.22655709 | 37.7271231825202 | -122.45744116150101 | (37.7271231825202, -122.457441161501) | ||
| 92326 | 92326 | 49045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 79 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46218 | 5995600.89018522 | 2093144.22655709 | 37.7271231825202 | -122.45744116150101 | (37.7271231825202, -122.457441161501) | ||
| 180260 | 180260 | 50303 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 23 Riverton Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2004 12:00:00 AM | 4 | Permit Number 47013 | 5987011.8079 | 2095678.86657 | 37.7335855541208 | -122.487319225206 | (37.7335855541208, -122.487319225206) | |
| 91013 | 91013 | 69067 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1362 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33075 | 5991809.26409527 | 2106159.97161256 | 37.762642560557296 | -122.471496661693 | (37.7626425605573, -122.471496661693) | ||
| 91626 | 91626 | 68031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1751 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33106 | 5993088.11292384 | 2103560.51520851 | 37.7555790313551 | -122.466884638125 | (37.7555790313551, -122.466884638125) | ||
| 118873 | 118873 | 69066 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1358 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33074 | 5991808.36845327 | 2106186.00567565 | 37.7627139913726 | -122.471501656502 | (37.7627139913726, -122.471501656502) | ||
| 122039 | 122039 | 69063 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1355 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1994 12:00:00 AM | Permit Number 33071 | 5992376.37367885 | 2106231.50488837 | 37.762871763681005 | -122.469540458568 | (37.762871763681, -122.469540458568) | ||
| 91921 | 91921 | 60567 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3975 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21117 | 6003857.80208029 | 2104188.22469401 | 37.757918271249 | -122.429684464769 | (37.757918271249, -122.429684464769) | ||
| 105776 | 105776 | 61258 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3987 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21142 | 6003783.88783992 | 2104184.12312575 | 37.7579028236845 | -122.429939798703 | (37.7579028236845, -122.429939798703) | ||
| 113883 | 113883 | 61238 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21110 | 6004305.99620693 | 2104230.28606193 | 37.7580591303819 | -122.428137417999 | (37.7580591303819, -122.428137417999) | ||
| 118988 | 118988 | 61242 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3983 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21114 | 6003808.52592004 | 2104185.49031517 | 37.757907972934106 | -122.429854687404 | (37.7579079729341, -122.429854687404) | ||
| 143333 | 143333 | 61240 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3991 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21112 | 6003759.24980586 | 2104182.75593888 | 37.7578976743831 | -122.430024909832 | (37.7578976743831, -122.430024909832) | ||
| 65798 | 65798 | 49135 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.730300088752706 | -122.45495298879601 | (37.7303000887527, -122.454952988796) | ||
| 85799 | 85799 | 49136 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 110 Valdez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46262 | 5996344.49436596 | 2094285.70346417 | 37.730300088752706 | -122.45495298879601 | (37.7303000887527, -122.454952988796) | ||
| 89676 | 89676 | 49125 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46256 | 5995794.69069605 | 2092577.70083633 | 37.725578768403295 | -122.456730244977 | (37.7255787684033, -122.456730244977) | ||
| 102558 | 102558 | 49122 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 71 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46254 | 5996767.20137074 | 2094321.13477848 | 37.730421614661296 | -122.453494198414 | (37.7304216146613, -122.453494198414) | ||
| 103786 | 103786 | 49123 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 71 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46254 | 5996767.20137074 | 2094321.13477848 | 37.730421614661296 | -122.453494198414 | (37.7304216146613, -122.453494198414) | ||
| 118214 | 118214 | 49126 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 38 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46257 | 5995648.98743874 | 2092511.94184061 | 37.7253898428328 | -122.45722917090299 | (37.7253898428328, -122.457229170903) | ||
| 121747 | 121747 | 49131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 70 Valdez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46260 | 5996389.50969278 | 2094077.42166365 | 37.729730779153705 | -122.454782323076 | (37.7297307791537, -122.454782323076) | ||
| 58182 | 58182 | 60606 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 705 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1983 12:00:00 AM | 11 | Permit Number 20228 | 6001025.3202 | 2111162.5004 | 37.776907107128 | -122.439980423401 | (37.776907107128, -122.439980423401) | |
| 102549 | 102549 | 60607 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 707 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1983 12:00:00 AM | Permit Number 20229 | 6001032.91323273 | 2111092.62455504 | 37.7767156779646 | -122.439949145427 | (37.7767156779646, -122.439949145427) | ||
| 174776 | 174776 | 60605 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 703 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1983 12:00:00 AM | 5 | Permit Number 20227 | 6001028.5934 | 2111122.4037 | 37.7767971980591 | -122.439966224713 | (37.7767971980591, -122.439966224713) | |
| 98738 | 98738 | 69128 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 307 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | Permit Number 33153 | 6004198.31580289 | 2107122.12007778 | 37.7659933229399 | -122.42871596905 | (37.7659933229399, -122.42871596905) | ||
| 95014 | 95014 | 41293 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 17 Brosnan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 41969 | 6005971.57727628 | 2108056.82988088 | 37.768660013765505 | -122.422649038224 | (37.7686600137655, -122.422649038224) | ||
| 142507 | 142507 | 41294 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 46 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/19/2000 12:00:00 AM | Permit Number 41970 | 6005255.02879358 | 2105775.2295184 | 37.7623548306425 | -122.42496517281201 | (37.7623548306425, -122.424965172812) | ||
| 151092 | 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) | ||
| 171006 | 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) | ||
| 85660 | 85660 | 64377 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2629 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1994 12:00:00 AM | Permit Number 25216 | 6010044.28903581 | 2105006.16815646 | 37.760512524529204 | -122.408346583675 | (37.7605125245292, -122.408346583675) | ||
| 118228 | 118228 | 52580 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 406@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2006 12:00:00 AM | Permit Number 48673 | 6003878.54680143 | 2099854.64384228 | 37.746020449437395 | -122.42930370529 | (37.7460204494374, -122.42930370529) | ||
| 187137 | 187137 | 87178 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1850 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50167 | 5987398.7116 | 2100339.5275 | 37.7464050543011 | -122.486323651924 | (37.7464050543011, -122.486323651924) |
| 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) | |
| 58633 | 58633 | 38648 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1920 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 6 | Permit Number 41183 | 6000483.83562 | 2115395.5317 | 37.7884990837232 | -122.44215751227699 | (37.7884990837232, -122.442157512277) | |
| 92514 | 92514 | 30573 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 164 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34550 | 6004481.83420946 | 2108792.73976924 | 37.7705964833806 | -122.42785438691001 | (37.7705964833806, -122.42785438691) | ||
| 162119 | 162119 | 30574 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 6 | Permit Number 34551 | 6004467.68034 | 2108789.06417 | 37.7705855903724 | -122.427903083363 | (37.7705855903724, -122.427903083363) | |
| 90492 | 90492 | 35088 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1475 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38629 | 5992093.71707194 | 2105411.69966032 | 37.760604455321605 | -122.47045835143999 | (37.7606044553216, -122.47045835144) | ||
| 65433 | 65433 | 72295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 142 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 4 | 6013238.890240001 | 2111406.12615 | 37.7782637520155 | -122.39774676201901 | (37.7782637520155, -122.397746762019) | ||
| 66361 | 66361 | 72296 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 146 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 9 | 6013222.13416 | 2111389.89822 | 37.7782182607083 | -122.397803589275 | (37.7782182607083, -122.397803589275) | ||
| 158929 | 158929 | 73738 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 142 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 9 | 6013247.88073 | 2111413.28408 | 37.778283906709795 | -122.39771616258498 | (37.7782839067098, -122.397716162585) | ||
| 78557 | 78557 | 35097 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 706 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38639 | 6002155.75551452 | 2089694.71254743 | 37.7180259181087 | -122.43453455761801 | (37.7180259181087, -122.434534557618) | ||
| 106319 | 106319 | 35098 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 710 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38640 | 6002142.25029691 | 2089673.27394965 | 37.71796628582229 | -122.43457970713999 | (37.7179662858223, -122.43457970714) | ||
| 118911 | 118911 | 50301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3212 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2004 12:00:00 AM | Permit Number 47011 | 6014135.02682875 | 2089827.85867998 | 37.7190642634607 | -122.39313641269699 | (37.7190642634607, -122.393136412697) | ||
| 161121 | 161121 | 66857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 40 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1994 12:00:00 AM | 4 | Permit Number 30163 | 5998731.6167 | 2110525.0238 | 37.7750259211455 | -122.447869104501 | (37.7750259211455, -122.447869104501) | |
| 123557 | 123557 | 69212 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1089 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33263 | 6008066.8179196995 | 2101598.29376591 | 37.7510443436687 | -122.414944565 | (37.7510443436687, -122.414944565) | ||
| 25423 | 25423 | 30768 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.727837721051294 | -122.391915390574 | (37.7278377210513, -122.391915390574) | |
| 52581 | 52581 | 30766 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1595 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34647 | 6014606.5276 | 2093671.0453 | 37.729643069645704 | -122.391775180038 | (37.7296430696457, -122.391775180038) | |
| 73597 | 73597 | 30774 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 548 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 4 | 4.5x12 | Permit Number 34652 | 6014028.90307 | 2112230.33243 | 37.7805707972354 | -122.39507154151501 | (37.7805707972354, -122.395071541515) |
| 84001 | 84001 | 44249 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 215 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/2001 12:00:00 AM | Permit Number 43684 | 6005176.84475376 | 2098998.91583461 | 37.743744231429204 | -122.424753493257 | (37.7437442314292, -122.424753493257) | ||
| 94798 | 94798 | 63330 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 93 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1987 12:00:00 AM | Permit Number 23903 | 6009698.11202926 | 2099903.10238683 | 37.7464812534823 | -122.409183752873 | (37.7464812534823, -122.409183752873) | ||
| 49635 | 49635 | 35149 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 11 Laussat St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38681 | 6004664.75137838 | 2109286.2995173 | 37.771962024845294 | -122.427256837171 | (37.7719620248453, -122.427256837171) | ||
| 119044 | 119044 | 35155 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1044 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38686 | 6001561.46281092 | 2109428.97187027 | 37.7721777782295 | -122.438001544264 | (37.7721777782295, -122.438001544264) | ||
| 130959 | 130959 | 52615 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2525@ STANYAN McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2006 12:00:00 AM | 4 | Permit Number 48699 | 5996929.0411 | 2110754.1973 | 37.7755519756107 | -122.454121126365 | (37.7755519756107, -122.454121126365) | |
| 104017 | 104017 | 102628 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 100 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3x3 | Permit Number 769972 | 6013417.4 | 2111578.2 | 37.778746166691 | -122.397141295625 | (37.778746166691, -122.397141295625) | |
| 150573 | 150573 | 38787 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 564 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/2013 12:00:00 AM | 3 | Permit Number 769972 | 6013384.96932 | 2111589.18475 | 37.7787745228569 | -122.397254257292 | (37.7787745228569, -122.397254257292) | |
| 28586 | 28586 | 69849 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 22 Bernice St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 6 | 6008480.655259999 | 2108494.13228 | 37.7700019816405 | -122.414001247166 | (37.7700019816405, -122.414001247166) | ||
| 136955 | 136955 | 79204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 175 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 4 | 6010493.03003 | 2110416.65916 | 37.7753936142481 | -122.40717598278499 | (37.7753936142481, -122.407175982785) | ||
| 39288 | 39288 | 72315 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3526 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 6 | 5997893.64237 | 2115823.01153 | 37.7895248738152 | -122.45114997549601 | (37.7895248738152, -122.451149975496) | ||
| 47150 | 47150 | 81654 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 6 | 6014140.03196 | 2096118.2922200002 | 37.7363368024053 | -122.393559125566 | (37.7363368024053, -122.393559125566) | ||
| 176927 | 176927 | 40009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 963 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/14/2004 12:00:00 AM | 5 | Permit Number 41262 | 6018899.57505 | 2094657.4041900001 | 37.732588803110204 | -122.377001897143 | (37.7325888031102, -122.377001897143) | |
| 63192 | 63192 | 73419 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 608 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 5 | 5988811.35353 | 2111153.65157 | 37.7761799433929 | -122.48223111012 | (37.7761799433929, -122.48223111012) |
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");