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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2949 | 2949 | 32064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3650 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 6 | Permit Number 35439 | 6004539.0 | 2106054.0 | 37.76307979631979 | -122.427461511029 | (37.7630797963198, -122.427461511029) | |
3674 | 3674 | 32468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2017 12:00:00 AM | 3 | Permit Number 36977 | 6000626.3294 | 2105651.6556 | 37.7617529834407 | -122.44096521177099 | (37.7617529834407, -122.440965211771) | |
7047 | 7047 | 71287 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 225 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/16/1982 12:00:00 AM | 6 | 5998480.7052 | 2112368.9268 | 37.780074457240794 | -122.448869905513 | (37.7800744572408, -122.448869905513) | ||
7584 | 7584 | 38094 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2624 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 6 | Permit Number 778879 | 5999853.7645 | 2114048.6642 | 37.7847650081627 | -122.444240628643 | (37.7847650081627, -122.444240628643) | |
7637 | 7637 | 36881 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | |
8381 | 8381 | 71797 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2033 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 6 | 5998131.4502 | 2109940.9744 | 37.7733879494567 | -122.44990310006399 | (37.7733879494567, -122.449903100064) | ||
9798 | 9798 | 32469 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 124 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779287 | 6000593.0 | 2105649.0 | 37.7617437934708 | -122.441080293978 | (37.7617437934708, -122.441080293978) | |
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) | ||
18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
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) | ||
23415 | 23415 | 65130 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 38 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1989 12:00:00 AM | 8 | Permit Number 27100 | 5989605.43837 | 2114945.94466 | 37.7866386771259 | -122.479761743811 | (37.7866386771259, -122.479761743811) | |
23540 | 23540 | 50495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.3595900002 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | |
23672 | 23672 | 45504 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3071 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44274 | 5989334.51674 | 2094909.25358 | 37.731607570812294 | -122.47923275968 | (37.7316075708123, -122.47923275968) | |
23899 | 23899 | 72385 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 8 | 5995057.69186 | 2110887.03516 | 37.775809229939206 | -122.460604158861 | (37.7758092299392, -122.460604158861) | ||
24290 | 24290 | 31978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 241 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 10 | Permit Number 35377 | 5995211.0055599995 | 2113933.52562 | 37.784182899243 | -122.460294590416 | (37.784182899243, -122.460294590416) | |
24502 | 24502 | 66601 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1111 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 9 | Permit Number 29794 | 6008473.92013 | 2115892.33746 | 37.7903153068679 | -122.414548140207 | (37.7903153068679, -122.414548140207) | |
24668 | 24668 | 62307 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 75 Loraine Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 12 | Permit Number 22445. Tree 1 on Anza | 5996139.53723 | 2112297.17389 | 37.7797432798479 | -122.456963823301 | (37.7797432798479, -122.456963823301) | |
24704 | 24704 | 50215 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 894@ CABRILLO 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46923 | 5986993.182990001 | 2109884.80336 | 37.7725901199359 | -122.488427298171 | (37.7725901199359, -122.488427298171) | |
24747 | 24747 | 32784 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 722 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37151 | 5999634.6045 | 2111035.6277 | 37.7764794805822 | -122.444782194549 | (37.7764794805822, -122.444782194549) | |
24778 | 24778 | 45056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2327 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43941 | 5988236.6427 | 2099455.0874 | 37.7440254200914 | -122.483361393915 | (37.7440254200914, -122.483361393915) | |
24803 | 24803 | 43758 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 187 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43394 | 5990518.06964 | 2114139.81459 | 37.78447824498161 | -122.47654538071698 | (37.7844782449816, -122.476545380717) | |
25010 | 25010 | 78257 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 538 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/2000 12:00:00 AM | 7 | 6003439.3186800005 | 2090205.80452 | 37.7195020449593 | -122.430134279779 | (37.7195020449593, -122.430134279779) | ||
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) | ||
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) | |
25526 | 25526 | 31523 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1320 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 9 | Permit Number 35078 | 6011116.30671 | 2102174.6826400002 | 37.752797866337794 | -122.404439635397 | (37.7527978663378, -122.404439635397) | |
25882 | 25882 | 31929 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 450 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35345 | 5991716.333380001 | 2100485.7522400003 | 37.747057262589 | -122.471404605562 | (37.747057262589, -122.471404605562) | |
25960 | 25960 | 31277 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991087.0554599995 | 2097794.191 | 37.739630505545705 | -122.47338429037902 | (37.7396305055457, -122.473384290379) | |
26055 | 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) | ||
26128 | 26128 | 31225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2491 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34912 | 5987341.6863 | 2098360.1236 | 37.740966813188 | -122.486375538404 | (37.740966813188, -122.486375538404) | |
26319 | 26319 | 67661 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 33 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 5 | Permit Number 31262 | 6014174.7724 | 2093920.80707 | 37.7303048875537 | -122.39328528558201 | (37.7303048875537, -122.393285285582) | |
26534 | 26534 | 42234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 479 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 1 | Permit Number 42487 | 6010475.72371 | 2112231.45093 | 37.780375639875295 | -122.407363816092 | (37.7803756398753, -122.407363816092) | |
26685 | 26685 | 72437 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3770 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 8 | 5996832.97473 | 2115019.84204 | 37.7872588007918 | -122.45476169870001 | (37.7872588007918, -122.4547616987) | ||
27208 | 27208 | 78214 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 743 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 5 | 6011081.23974 | 2091316.8573 | 37.722982629931295 | -122.403796950193 | (37.7229826299313, -122.403796950193) | ||
27234 | 27234 | 73651 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2484 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1990 12:00:00 AM | 6 | 5989869.6737 | 2098462.6897 | 37.7413954601505 | -122.477642278142 | (37.7413954601505, -122.477642278142) | ||
27701 | 27701 | 45499 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2963 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 2 | Permit Number 44272 | 5989310.955130001 | 2095557.4598599998 | 37.7333860107429 | -122.47936161996999 | (37.7333860107429, -122.47936161997) | |
27720 | 27720 | 72005 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1963 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1995 12:00:00 AM | 5 | 5987221.7723 | 2101915.2958 | 37.7507213765199 | -122.487051188188 | (37.7507213765199, -122.487051188188) | ||
27869 | 27869 | 31273 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991084.11448 | 2097836.49496 | 37.7397464910963 | -122.473397543673 | (37.7397464910963, -122.473397543673) | |
27935 | 27935 | 31275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991083.96236 | 2097817.15833 | 37.739693388847606 | -122.47339665963001 | (37.7396933888476, -122.47339665963) | |
28003 | 28003 | 60357 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | |
28025 | 28025 | 67400 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 547 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 6 | Permit Number 30897 | 5990610.3412 | 2111645.1131599997 | 37.777633837418996 | -122.47604389172199 | (37.777633837419, -122.476043891722) | |
28035 | 28035 | 73552 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1558 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1988 12:00:00 AM | 7 | 6000334.7955 | 2110645.2290000003 | 37.775447477965706 | -122.4423320082 | (37.7754474779657, -122.4423320082) | ||
28083 | 28083 | 31759 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2654 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35245 | 5989289.1529 | 2097265.3499 | 37.7380741702289 | -122.479561911147 | (37.7380741702289, -122.479561911147) | |
28229 | 28229 | 43752 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 258 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43388 | 5991219.98047 | 2113680.3591 | 37.7832573927775 | -122.47408349916799 | (37.7832573927775, -122.474083499168) | |
28323 | 28323 | 43865 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43482 | 5985465.207 | 2096960.4516 | 37.7370141335806 | -122.49276055533998 | (37.7370141335806, -122.49276055534) | |
28507 | 28507 | 73526 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 807 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/11/1996 12:00:00 AM | 8 | 6009578.52705 | 2116144.74687 | 37.791070356964205 | -122.41074409605899 | (37.7910703569642, -122.410744096059) | ||
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) | ||
28667 | 28667 | 31457 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001233.81138 | 2102648.72464 | 37.7535422450846 | -122.43864900065701 | (37.7535422450846, -122.438649000657) | |
28739 | 28739 | 64507 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 848 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 6 | Permit Number 25388 | 6000492.1653 | 2111922.2928 | 37.778962938676706 | -122.441879309268 | (37.7789629386767, -122.441879309268) | |
28848 | 28848 | 78416 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2959 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 5 | 5990231.308540001 | 2095554.29925 | 37.7334307457305 | -122.47617950378 | (37.7334307457305, -122.47617950378) | ||
28994 | 28994 | 38689 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1387 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 7 | Permit Number 40602 | 6001181.9349 | 2110716.5649 | 37.775691594994505 | -122.439406673557 | (37.7756915949945, -122.439406673557) | |
29236 | 29236 | 47400 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 680 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45311 | 5994746.17876 | 2110902.86146 | 37.7758347580225 | -122.461682901678 | (37.7758347580225, -122.461682901678) | |
29420 | 29420 | 31287 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34935 | 5990781.283369999 | 2097640.71217 | 37.7391913809888 | -122.474430310711 | (37.7391913809888, -122.474430310711) | |
29579 | 29579 | 70603 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 242 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1994 12:00:00 AM | 10 | 6004588.06185 | 2091017.9173400002 | 37.7217969250666 | -122.42622128008999 | (37.7217969250666, -122.42622128009) | ||
29656 | 29656 | 45512 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3060 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 4 | Permit Number 44277 | 5988861.0879999995 | 2094953.9729400002 | 37.7317028513108 | -122.48087274987101 | (37.7317028513108, -122.480872749871) | |
29689 | 29689 | 31744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2435 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35234 | 5989813.6936 | 2098781.7399 | 37.742268240421204 | -122.47785915361601 | (37.7422682404212, -122.477859153616) | |
30312 | 30312 | 52936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 385 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48922 | 6001040.8792 | 2092508.1161099998 | 37.725687536143106 | -122.438589665189 | (37.7256875361431, -122.438589665189) | |
30627 | 30627 | 38811 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 326 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | 8 | Permit Number 40647 | 5992799.72049 | 2113267.67027 | 37.78221564478971 | -122.46858824048599 | (37.7822156447897, -122.468588240486) | |
30650 | 30650 | 43288 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2210 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43057 | 6011175.09189 | 2105117.22439 | 37.760880718387796 | -122.404443451212 | (37.7608807183878, -122.404443451212) | |
31181 | 31181 | 73534 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2122 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/1995 12:00:00 AM | 2 | 5988232.3443 | 2100841.764 | 37.7478326165783 | -122.483477893757 | (37.7478326165783, -122.483477893757) | ||
31189 | 31189 | 43857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2784 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43478 | 5985281.0071 | 2096265.8928 | 37.7350962873764 | -122.493346251334 | (37.7350962873764, -122.493346251334) | |
31196 | 31196 | 32470 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 59 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 6 | Permit Number 36978 | 6001062.3142800005 | 2106026.41955 | 37.762806815291796 | -122.439484183958 | (37.7628068152918, -122.439484183958) | |
31396 | 31396 | 62715 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1941 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 6 | Permit Number 23057 | 6007704.91578 | 2119106.60942 | 37.7990976677838 | -122.417436738332 | (37.7990976677838, -122.417436738332) | |
31401 | 31401 | 68521 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 708 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2015 12:00:00 AM | 7 | Permit Number 775425 | 5995373.47149 | 2110684.12761 | 37.775270261614104 | -122.45949710563801 | (37.7752702616141, -122.459497105638) | |
31628 | 31628 | 68536 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 734 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32418 | 5993833.0352 | 2110476.78435 | 37.7746122584416 | -122.464810724109 | (37.7746122584416, -122.464810724109) | |
31779 | 31779 | 68325 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 841 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | 7 | Permit Number 32140 | 6006815.0166 | 2113575.49994 | 37.783860503793996 | -122.42012334783199 | (37.783860503794, -122.420123347832) | |
31859 | 31859 | 31232 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34918 | 5991386.50478 | 2098046.67038 | 37.7403410850744 | -122.472367334291 | (37.7403410850744, -122.472367334291) | |
31893 | 31893 | 79837 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2808 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2002 12:00:00 AM | 6 | 6006109.456119999 | 2120466.37489 | 37.80274134031279 | -122.42305427704599 | (37.8027413403128, -122.423054277046) | ||
32142 | 32142 | 78209 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 602 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/2000 12:00:00 AM | 7 | 6011148.7159 | 2091968.9624700001 | 37.7247769455958 | -122.403609556646 | (37.7247769455958, -122.403609556646) | ||
32253 | 32253 | 38647 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1920 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 7 | Permit Number 41183 | 6000481.01223 | 2115413.16411 | 37.7885473368318 | -122.442168546961 | (37.7885473368318, -122.442168546961) | |
32276 | 32276 | 31868 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3633 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 7 | Permit Number 41912 | 5999648.6988 | 2121058.91348 | 37.804001595372604 | -122.445454333359 | (37.8040015953726, -122.445454333359) | |
32322 | 32322 | 80604 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 888 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/2002 12:00:00 AM | 3 | 6015452.956 | 2105074.08431 | 37.761000400173295 | -122.38964506649201 | (37.7610004001733, -122.389645066492) | ||
32900 | 32900 | 78278 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1129 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2000 12:00:00 AM | 3 | 6000344.02965 | 2090524.15486 | 37.720200365833996 | -122.440856356949 | (37.720200365834, -122.440856356949) | ||
32985 | 32985 | 47409 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1245 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45320 | 5994762.6518 | 2112104.25477 | 37.7791344121855 | -122.461713045527 | (37.7791344121855, -122.461713045527) | |
33004 | 33004 | 37858 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 566St. Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/2003 12:00:00 AM | 7 | Permit Number 40145 | 6001842.58186 | 2090205.4937 | 37.719410626184796 | -122.43565358376699 | (37.7194106261848, -122.435653583767) | |
33081 | 33081 | 31729 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2467 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 4 | Permit Number 35226 | 5990125.4261 | 2098592.0294 | 37.7417654319331 | -122.47676743237601 | (37.7417654319331, -122.476767432376) | |
33147 | 33147 | 78042 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1975 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/2000 12:00:00 AM | 2 | 5986293.4379 | 2101820.6717 | 37.7504073916771 | -122.490254444499 | (37.7504073916771, -122.490254444499) | ||
33166 | 33166 | 43255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 5 | Permit Number 43041 | 6010125.284580001 | 2093194.02185 | 37.7280834802679 | -122.40723376965 | (37.7280834802679, -122.40723376965) | |
33519 | 33519 | 64497 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1542 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 9 | Permit Number 25376 | 6000402.8495 | 2110654.2627 | 37.7754761607449 | -122.442097242557 | (37.7754761607449, -122.442097242557) | |
33574 | 33574 | 53443 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1955 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 5 | Permit Number 23058 | 6007695.329609999 | 2119167.05545 | 37.7992630980807 | -122.41747419599899 | (37.7992630980807, -122.417474195999) | |
33694 | 33694 | 45545 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 150 Riverton Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2001 12:00:00 AM | 3 | Permit Number 44298 | 5987075.11092 | 2094929.45879 | 37.7315315673308 | -122.48704535198 | (37.7315315673308, -122.48704535198) | |
33737 | 33737 | 78509 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 750 Eucalyptus Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/2000 12:00:00 AM | 3 | 5988915.04586 | 2094775.69423 | 37.7312164799499 | -122.48067316246402 | (37.7312164799499, -122.480673162464) | ||
33861 | 33861 | 43701 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3342 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 5 | Permit Number 43344 | 5992980.72479 | 2110052.83989 | 37.77339904403011 | -122.46772817008001 | (37.7733990440301, -122.46772817008) | |
33876 | 33876 | 67957 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 886 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 5 | Permit Number 31677 | 5987616.4327300005 | 2109922.8540000003 | 37.772730941918894 | -122.48627423406799 | (37.7727309419189, -122.486274234068) | |
34185 | 34185 | 64492 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1570 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/1988 12:00:00 AM | 8 | Permit Number 25369 | 6000283.6045 | 2110639.8088 | 37.775429677687995 | -122.442508700238 | (37.775429677688, -122.442508700238) | |
34255 | 34255 | 68402 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 127 Tingley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1993 12:00:00 AM | 9 | Permit Number 32234 | 6002270.3264 | 2093907.92717 | 37.7296009620913 | -122.434439606907 | (37.7296009620913, -122.434439606907) | |
34260 | 34260 | 67963 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 882 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 6 | Permit Number 31684 | 5986994.57488 | 2109967.9859599997 | 37.7728185972219 | -122.48842859801701 | (37.7728185972219, -122.488428598017) | |
34278 | 34278 | 31819 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 195 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35284 | 6009854.1227 | 2111441.50203 | 37.778171816101704 | -122.409458466633 | (37.7781718161017, -122.409458466633) | |
34347 | 34347 | 44742 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 276 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 4 | Permit Number 43860 | 5992023.15498 | 2086637.27235 | 37.7090505207416 | -122.469335815893 | (37.7090505207416, -122.469335815893) |
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");