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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9952 | 9952 | 39131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 774 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1998 12:00:00 AM | 2.5x3 | Permit Number 40811 | 6007313.40469967 | 2102804.1822591 | 37.7543130741871 | -122.417635411147 | (37.7543130741871, -122.417635411147) | |
| 17839 | 17839 | 45141 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | ||
| 17861 | 17861 | 36571 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 193 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39434 | 6006550.67564365 | 2097394.54535781 | 37.739416487692 | -122.41988928119801 | (37.739416487692, -122.419889281198) | ||
| 17879 | 17879 | 68381 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.76131256253829 | -122.445651023552 | (37.7613125625383, -122.445651023552) | ||
| 18482 | 18482 | 50084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 163 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46816 | 5992385.51984068 | 2098065.73695017 | 37.7404512063716 | -122.468914554715 | (37.7404512063716, -122.468914554715) | ||
| 18838 | 18838 | 43257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.728118638728105 | -122.407120168437 | (37.7281186387281, -122.407120168437) | ||
| 19412 | 19412 | 68594 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.754890406441895 | -122.47320772508499 | (37.7548904064419, -122.473207725085) | ||
| 19803 | 19803 | 40552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 380 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41594 | 5992231.83033974 | 2094391.07598337 | 37.7303526300924 | -122.46917856626301 | (37.7303526300924, -122.469178566263) | ||
| 19839 | 19839 | 46807 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | ||
| 20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
| 20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
| 20490 | 20490 | 68099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31844 | 6006420.25408514 | 2099944.49896622 | 37.7464107382986 | -122.42052117977501 | (37.7464107382986, -122.420521179775) | ||
| 20623 | 20623 | 39050 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009499.38 | 2105599.429 | 37.762110954787005 | -122.410273070025 | (37.762110954787, -122.410273070025) | ||
| 20981 | 20981 | 40426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 21241 | 21241 | 41670 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 25402 | 25402 | 52514 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 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) | ||
| 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) | ||
| 47996 | 47996 | 36107 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1342 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1998 12:00:00 AM | Permit Number 39204 | 5992735.49126181 | 2106322.00548974 | 37.7631410027064 | -122.46830499108499 | (37.7631410027064, -122.468304991085) | ||
| 49108 | 49108 | 45296 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 586 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44763 | 6008684.90239462 | 2096105.66029686 | 37.7359974954785 | -122.412418957568 | (37.7359974954785, -122.412418957568) | ||
| 49625 | 49625 | 39053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009484.188999999 | 2105497.432 | 37.7618300427155 | -122.410318408111 | (37.7618300427155, -122.410318408111) | ||
| 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) | ||
| 50089 | 50089 | 64596 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3339 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1988 12:00:00 AM | Permit Number 25497 | 6006072.66920916 | 2103140.85266196 | 37.7551675977095 | -122.42195010954501 | (37.7551675977095, -122.421950109545) | ||
| 50096 | 50096 | 31268 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991067.840009999 | 2098080.24601 | 37.7404148266578 | -122.47347158803001 | (37.7404148266578, -122.47347158803) | ||
| 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) | ||
| 50492 | 50492 | 68045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1972 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1993 12:00:00 AM | Permit Number 31782 | 5993192.12493699 | 2102059.66959025 | 37.75146409897361 | -122.466415859099 | (37.7514640989736, -122.466415859099) | ||
| 51129 | 51129 | 45410 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 71 De Soto St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2001 12:00:00 AM | Permit Number 44213 | 5993067.86469343 | 2091642.16884569 | 37.7228530792724 | -122.46608862413 | (37.7228530792724, -122.46608862413) | ||
| 51322 | 51322 | 32829 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4255 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37187 | 6001551.51110422 | 2101720.28734658 | 37.7510110467741 | -122.437483847043 | (37.7510110467741, -122.437483847043) | ||
| 53239 | 53239 | 40427 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 53240 | 53240 | 32846 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4290x 23RD ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | 3x3 | Permit Number 37198 | 6001397.0 | 2102325.0 | 37.7526626570726 | -122.438061472785 | (37.7526626570726, -122.438061472785) | |
| 54626 | 54626 | 45131 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 121 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43990 | 6000310.782626901 | 2109305.17604742 | 37.7717666625759 | -122.442318851526 | (37.7717666625759, -122.442318851526) | ||
| 54654 | 54654 | 47931 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 421 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45666 | 6000072.19761127 | 2095017.15680877 | 37.732521628448296 | -122.442118334295 | (37.7325216284483, -122.442118334295) | ||
| 55720 | 55720 | 67194 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 351 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30644 | 6007123.27859933 | 2096564.8875319 | 37.7371706731445 | -122.417850672524 | (37.7371706731445, -122.417850672524) | ||
| 58956 | 58956 | 42053 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 470 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42368 | 6003495.60283243 | 2099833.79882234 | 37.7459415266501 | -122.43062638702601 | (37.7459415266501, -122.430626387026) | ||
| 61492 | 61492 | 40445 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 201 Ellsworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/10/1999 12:00:00 AM | Permit Number 41532 | 6008126.9485778 | 2097682.94540443 | 37.7402970476748 | -122.41445960736799 | (37.7402970476748, -122.414459607368) | ||
| 62731 | 62731 | 43404 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 25 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43147 | 6000608.85784108 | 2102791.78597094 | 37.753899484954 | -122.440820481699 | (37.753899484954, -122.440820481699) | ||
| 62739 | 62739 | 38779 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 534 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/1998 12:00:00 AM | Permit Number 40639 | 6013303.96708897 | 2111684.86517271 | 37.779032729498894 | -122.397541189965 | (37.7790327294989, -122.397541189965) | ||
| 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) | ||
| 67570 | 67570 | 52458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 557@ ANZA 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48569 | 5992189.638752901 | 2111651.23752465 | 37.777742101383794 | -122.470581063094 | (37.7777421013838, -122.470581063094) | ||
| 69276 | 69276 | 39031 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2701X Mariposa St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009344.866 | 2105909.325 | 37.7629531959614 | -122.410829364237 | (37.7629531959614, -122.410829364237) | ||
| 71185 | 71185 | 64744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1058 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/17/1988 12:00:00 AM | Permit Number 25706 | 6001496.66932698 | 2109419.88262313 | 37.7721491365124 | -122.43822501871 | (37.7721491365124, -122.43822501871) | ||
| 72473 | 72473 | 39099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3353 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40788 | 6005993.50178043 | 2103136.86299129 | 37.7551521778285 | -122.42222361067101 | (37.7551521778285, -122.422223610671) | ||
| 76169 | 76169 | 51818 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 555 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2005 12:00:00 AM | Permit Number 48061 | 6009275.17221026 | 2105665.92876427 | 37.7622809774576 | -122.411053219069 | (37.7622809774576, -122.411053219069) | ||
| 76346 | 76346 | 51950 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 505 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | Permit Number 48174 | 5993345.13352476 | 2105251.56144285 | 37.760237035945295 | -122.466118668568 | (37.7602370359453, -122.466118668568) | ||
| 76411 | 76411 | 49539 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 270 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/2003 12:00:00 AM | Permit Number 46434 | 6008335.40255887 | 2109294.70940542 | 37.7721920194728 | -122.414560335389 | (37.7721920194728, -122.414560335389) | ||
| 77567 | 77567 | 31547 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 230 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45060 | 5998353.30570755 | 2112667.00543316 | 37.7808856171306 | -122.449332118202 | (37.7808856171306, -122.449332118202) | ||
| 77579 | 77579 | 31254 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991075.91901 | 2097809.61001 | 37.7396721973209 | -122.47342391940201 | (37.7396721973209, -122.473423919402) | ||
| 77601 | 77601 | 35956 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 338 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2000 12:00:00 AM | Permit Number 39114 | 6007098.24292142 | 2096514.81395524 | 37.7370317731807 | -122.41793368389999 | (37.7370317731807, -122.4179336839) | ||
| 77604 | 77604 | 47167 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 220 San Fernando Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | Permit Number 45132 | 5992111.12252735 | 2095318.35041834 | 37.7328917184148 | -122.469663345403 | (37.7328917184148, -122.469663345403) | ||
| 77750 | 77750 | 48650 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 426 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45943 | 5993014.50141682 | 2103930.95922511 | 37.7565919256494 | -122.467166140324 | (37.7565919256494, -122.467166140324) | ||
| 77923 | 77923 | 46809 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 90 San Jacinto Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44892 | 5993785.91066901 | 2095094.03244535 | 37.732372453232 | -122.463856941781 | (37.732372453232, -122.463856941781) | ||
| 78054 | 78054 | 47993 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2582 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2002 12:00:00 AM | Permit Number 45725 | 5991769.8321385 | 2097864.05184963 | 37.739861839435 | -122.471028652434 | (37.739861839435, -122.471028652434) | ||
| 78060 | 78060 | 31092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 78135 | 78135 | 41141 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1901 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1999 12:00:00 AM | Permit Number 41876 | 5997475.24774631 | 2108806.66286617 | 37.7702358542847 | -122.452091128514 | (37.7702358542847, -122.452091128514) | ||
| 78359 | 78359 | 46917 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1221 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44973 | 5995133.00137739 | 2107226.62921874 | 37.7657630476681 | -122.460078405891 | (37.7657630476681, -122.460078405891) | ||
| 78524 | 78524 | 47338 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399X Vernon St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 78540 | 78540 | 67176 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 320 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30622 | 6006979.64844614 | 2096524.9264163002 | 37.7370528645637 | -122.418344436004 | (37.7370528645637, -122.418344436004) | ||
| 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) | ||
| 78592 | 78592 | 38001 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2460 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | Permit Number 40213 | 5992065.65260132 | 2098696.41331766 | 37.7421643974791 | -122.47006643116 | (37.7421643974791, -122.47006643116) | ||
| 78659 | 78659 | 35985 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 135 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39138 | 6006346.33672477 | 2097504.87289585 | 37.7397079084401 | -122.42060362628901 | (37.7397079084401, -122.420603626289) | ||
| 78834 | 78834 | 47027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 332 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/2002 12:00:00 AM | Permit Number 45022 | 6002753.52600326 | 2109683.5809307 | 37.77294459037179 | -122.433896303244 | (37.7729445903718, -122.433896303244) | ||
| 78907 | 78907 | 46184 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44511 | 5997623.38792866 | 2107669.89260679 | 37.767123058720706 | -122.451496709211 | (37.7671230587207, -122.451496709211) | ||
| 78933 | 78933 | 37575 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 72 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | Permit Number 40007 | 6001986.3327137 | 2105443.64764807 | 37.761259209908204 | -122.436246626023 | (37.7612592099082, -122.436246626023) | ||
| 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) | ||
| 79052 | 79052 | 31257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097777.29501 | 37.739568319433104 | -122.47432587378599 | (37.7395683194331, -122.474325873786) | ||
| 79053 | 79053 | 48648 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 136 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45941 | 5993890.54218032 | 2104640.94515626 | 37.758591893357504 | -122.46418804186399 | (37.7585918933575, -122.464188041864) | ||
| 79090 | 79090 | 68593 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1766 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32494 | 5991252.00487941 | 2103443.53443164 | 37.7551516891549 | -122.473225878929 | (37.7551516891549, -122.473225878929) | ||
| 79225 | 79225 | 40774 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 45 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41733 | 5991509.03275031 | 2091578.2410006002 | 37.722587492429106 | -122.47147247116501 | (37.7225874924291, -122.471472471165) | ||
| 79250 | 79250 | 45439 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 660 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44226 | 5993379.37180742 | 2091524.88455142 | 37.7225490119239 | -122.465003304293 | (37.7225490119239, -122.465003304293) | ||
| 79252 | 79252 | 64520 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 433 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | Permit Number 25402 | 6000639.30708593 | 2110429.29392401 | 37.774871925888796 | -122.441263136485 | (37.7748719258888, -122.441263136485) | ||
| 79253 | 79253 | 43518 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3966 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43193 | 6008375.23965972 | 2096657.08362143 | 37.73749420119729 | -122.413528576903 | (37.7374942011973, -122.413528576903) | ||
| 79286 | 79286 | 64552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 446 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | Permit Number 29779 | 6000207.51332852 | 2110416.28372075 | 37.7748115969963 | -122.442755862923 | (37.7748115969963, -122.442755862923) | ||
| 79448 | 79448 | 42039 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 186 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42359 | 6004732.95354078 | 2098732.8034677 | 37.742988466771 | -122.42626942175899 | (37.742988466771, -122.426269421759) | ||
| 79449 | 79449 | 42553 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 82 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42645 | 5993073.36121291 | 2094485.358364 | 37.7306600968778 | -122.46627615105 | (37.7306600968778, -122.46627615105) | ||
| 79541 | 79541 | 31081 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
| 79559 | 79559 | 47344 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 637 Garfield St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45270 | 5992377.81868219 | 2090468.81878363 | 37.7195915118568 | -122.46838862425899 | (37.7195915118568, -122.468388624259) | ||
| 79569 | 79569 | 47924 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2002 12:00:00 AM | Permit Number 45660 | 6000180.73439645 | 2110607.3459333 | 37.7753346787069 | -122.44286221948201 | (37.7753346787069, -122.442862219482) | ||
| 79621 | 79621 | 43653 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1038 Clayton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43296 | 5998866.89911478 | 2106402.77921975 | 37.7637150147123 | -122.44710440936501 | (37.7637150147123, -122.447104409365) | ||
| 79702 | 79702 | 67195 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 364 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30645 | 6007254.96525843 | 2096501.59955249 | 37.7370043084172 | -122.41739088683 | (37.7370043084172, -122.41739088683) | ||
| 79755 | 79755 | 66153 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 242 Williams Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | Permit Number 29224 | 6012823.28895075 | 2093870.94233966 | 37.730092792538706 | -122.39795408284401 | (37.7300927925387, -122.397954082844) | ||
| 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) | ||
| 79822 | 79822 | 39041 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009489.42605904 | 2105918.18139903 | 37.762985618211395 | -122.41033000413601 | (37.7629856182114, -122.410330004136) | ||
| 79920 | 79920 | 68078 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 533 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31816 | 5993378.12281416 | 2101850.02786606 | 37.750899207284604 | -122.465757431223 | (37.7508992072846, -122.465757431223) | ||
| 79971 | 79971 | 32214 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 22 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | Permit Number 35535 | 6009204.03379581 | 2099499.67440684 | 37.7453458370511 | -122.410863739161 | (37.7453458370511, -122.410863739161) | ||
| 80061 | 80061 | 62015 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1335 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1986 12:00:00 AM | Permit Number 22951 | 5996759.80767811 | 2106875.81619467 | 37.764893238314 | -122.454426318727 | (37.764893238314, -122.454426318727) | ||
| 80204 | 80204 | 63681 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1360 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1987 12:00:00 AM | Permit Number 24336 | 6003877.5677897 | 2100349.08682524 | 37.7473780197128 | -122.429342342987 | (37.7473780197128, -122.429342342987) | ||
| 80244 | 80244 | 66649 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 953 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29860 | 6009977.90870649 | 2103659.93293665 | 37.7568123482779 | -122.408481200185 | (37.7568123482779, -122.408481200185) | ||
| 80261 | 80261 | 41467 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4201 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43106 | 6001496.29110136 | 2103344.13246923 | 37.7554665958578 | -122.437791093286 | (37.7554665958578, -122.437791093286) | ||
| 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) | ||||
| 80304 | 80304 | 43922 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2713 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/2000 12:00:00 AM | Permit Number 43514 | 6009896.870643401 | 2103354.29233864 | 37.7559685890585 | -122.408739899203 | (37.7559685890585, -122.408739899203) | ||
| 80317 | 80317 | 47339 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 399 Vernon St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45267 | 5992467.59204583 | 2090467.76074352 | 37.7195937916744 | -122.468078236027 | (37.7195937916744, -122.468078236027) | ||
| 80450 | 80450 | 50198 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 619 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2003 12:00:00 AM | Permit Number 46904 | 6000550.61015539 | 2111065.53774883 | 37.7766138373401 | -122.441615625625 | (37.7766138373401, -122.441615625625) | ||
| 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) | ||
| 80514 | 80514 | 34387 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 194 Lippard Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38135 | 6001745.9731421 | 2094969.88286984 | 37.7324870706739 | -122.43632831918801 | (37.7324870706739, -122.436328319188) | ||
| 80816 | 80816 | 40492 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 15 Aptos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41568 | 5993166.50981737 | 2094885.79509382 | 37.7317649711718 | -122.465983210891 | (37.7317649711718, -122.465983210891) | ||
| 80874 | 80874 | 61471 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 353 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1984 12:00:00 AM | Permit Number 21414 | 6004212.58352082 | 2106861.11747112 | 37.7652774800544 | -122.428648012847 | (37.7652774800544, -122.428648012847) | ||
| 80935 | 80935 | 52928 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 16SAN JOSE Havelock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48912 | 6000085.98999689 | 2092943.15717176 | 37.7268276925501 | -122.44192184351002 | (37.7268276925501, -122.44192184351) | ||
| 80937 | 80937 | 52102 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 626 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48294 | 5997817.67079409 | 2098058.32410379 | 37.7407432018068 | -122.45013185931299 | (37.7407432018068, -122.450131859313) | ||
| 80938 | 80938 | 32888 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1427 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44963 | 5994250.98670041 | 2105798.55598521 | 37.761791161249704 | -122.463025460455 | (37.7617911612497, -122.463025460455) | ||
| 80958 | 80958 | 40497 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 41 Aptos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41570 | 5993155.80977638 | 2094728.71790558 | 37.7313330588046 | -122.46600879303001 | (37.7313330588046, -122.46600879303) |
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");