Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3708 | 3708 | 241324 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | Width 3ft | 6007395.8118199995 | 2106861.7423400003 | 37.765458833278 | -122.417637995807 | (37.765458833278, -122.417637995807) | ||
11160 | 11160 | 19922 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 100 STAIRWAY37 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
15101 | 15101 | 100314 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1683 Galvez Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015409.74359 | 2097962.08476 | 37.7414699491892 | -122.389297877816 | (37.7414699491892, -122.389297877816) | |||
15563 | 15563 | 104460 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601X Kansas St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | |||
19270 | 19270 | 91581 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010962999 | 2108444.137303 | 37.769802266170295 | -122.41783941244101 | (37.7698022661703, -122.417839412441) | ||
23657 | 23657 | 196979 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.39701407983802 | (37.7599198521353, -122.397014079838) | |||
25708 | 25708 | 41912 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | |
29450 | 29450 | 241312 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007473.647469999 | 2105479.75896 | 37.761668608133604 | -122.41727083858 | (37.7616686081336, -122.41727083858) | |||
31761 | 31761 | 179275 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 716 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6005245.16074 | 2092477.2139400002 | 37.725840954193295 | -122.424053582122 | (37.7258409541933, -122.424053582122) | |||
33708 | 33708 | 80092 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.798896010091205 | -122.429310324527 | (37.7988960100912, -122.429310324527) | |
34027 | 34027 | 196983 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | |||
37755 | 37755 | 241365 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1475 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6010134.568630001 | 2100721.5441 | 37.748752956797794 | -122.407732226982 | (37.7487529567978, -122.407732226982) | |||
38456 | 38456 | 241317 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 270 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007335.93397 | 2108086.9588 | 37.7688196204438 | -122.41793196081801 | (37.7688196204438, -122.417931960818) | |||
39431 | 39431 | 241273 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 55 Haight St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005874.88911 | 2109629.37494 | 37.7729723901943 | -122.423095264536 | (37.7729723901943, -122.423095264536) | |||
41551 | 41551 | 34964 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 900 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 8 | Permit Number 38553 | 6014444.742740001 | 2102850.7303299997 | 37.7548395926778 | -122.39297650156901 | (37.7548395926778, -122.392976501569) | ||
41621 | 41621 | 120834 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5989271.19606 | 2110543.25177 | 37.7745306911578 | -122.48059571456498 | (37.7745306911578, -122.480595714565) | |||
44724 | 44724 | 241370 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2877 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 7ft | 6009531.75591 | 2102750.92335 | 37.7542914163323 | -122.409959999651 | (37.7542914163323, -122.409959999651) | |||
46628 | 46628 | 90888 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.389219999 | 2110587.7825599997 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | ||
47277 | 47277 | 90869 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989208.80531 | 2110541.2902599997 | 37.774521679169396 | -122.48081139016199 | (37.7745216791694, -122.480811390162) | ||
54443 | 54443 | 136182 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5999403.041730001 | 2119664.02877 | 37.800157590747105 | -122.446204044176 | (37.8001575907471, -122.446204044176) | |||
62853 | 62853 | 94082 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1355 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53468 | 6007647.44648 | 2117801.56463 | 37.79551110671729 | -122.41754305889 | (37.7955111067173, -122.41754305889) | |
63143 | 63143 | 136180 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.44618771161699 | (37.8000790286731, -122.446187711617) | |||
64275 | 64275 | 38887 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 316 Laurel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998129.6596099995 | 2115308.75845 | 37.788126381265705 | -122.45029630035101 | (37.7881263812657, -122.450296300351) | |
66138 | 66138 | 241291 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1225 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011156.6405 | 2102469.67171 | 37.75361009534021 | -122.404320914102 | (37.7536100953402, -122.404320914102) | |||
71771 | 71771 | 241341 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2701 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009762.27519 | 2105459.58065 | 37.7617416960496 | -122.409353942929 | (37.7617416960496, -122.409353942929) | |||
72636 | 72636 | 197004 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 503 Beale St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6015943.643630001 | 2113959.00175 | 37.7854236244348 | -122.388568185881 | (37.7854236244348, -122.388568185881) | |||
73801 | 73801 | 241296 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1350 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007156.61283 | 2107616.82741 | 37.767518656696794 | -122.41851887996 | (37.7675186566968, -122.41851887996) | |||
75960 | 75960 | 36966 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.520930001 | 2112981.13075 | 37.781516271518505 | -122.463326949801 | (37.7815162715185, -122.463326949801) | |
76557 | 76557 | 123210 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | |||
80241 | 80241 | 91582 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 270x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007359.0 | 2108191.0 | 37.76910659118089 | -122.417859552844 | (37.7691065911809, -122.417859552844) | ||
81470 | 81470 | 83567 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | ||
81712 | 81712 | 88507 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.729165942396705 | -122.46178944431601 | (37.7291659423967, -122.461789444316) | ||
81820 | 81820 | 84105 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3909 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.753073006911706 | -122.430037470862 | (37.7530730069117, -122.430037470862) | ||
83911 | 83911 | 91617 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1200X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007645.0 | 2102652.0 | 37.7539138699857 | -122.416477888477 | (37.7539138699857, -122.416477888477) | ||
85801 | 85801 | 3776 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 6 Carpenter Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.259790401 | 2095536.4485417 | 37.7348782815847 | -122.38484307413 | (37.7348782815847, -122.38484307413) | ||
87078 | 87078 | 90864 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | ||
87922 | 87922 | 91679 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007478.430249 | 2106383.2495009997 | 37.7641496522652 | -122.41731832527799 | (37.7641496522652, -122.417318325278) | ||
88841 | 88841 | 100425 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | ||||
89164 | 89164 | 88499 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1599@ Lane Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | ||
90594 | 90594 | 91629 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1474 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | ||
90672 | 90672 | 91591 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007414.001232 | 2106821.277656 | 37.765348750234104 | -122.41757221444999 | (37.7653487502341, -122.41757221445) | ||
90801 | 90801 | 91667 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.760511294598395 | -122.41697023405099 | (37.7605112945984, -122.416970234051) | ||
92341 | 92341 | 120913 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 499X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6007431.0 | 2106864.0 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | |||
95503 | 95503 | 121263 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6007449.0 | 2105508.0 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | |||
95661 | 95661 | 87989 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 233 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741.0 | 2113986.0 | 37.785152065252 | -122.41002947845502 | (37.785152065252, -122.410029478455) | ||
96071 | 96071 | 22262 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4655X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6015123.968669999 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | |||
97868 | 97868 | 90578 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2050X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989208.063569999 | 2110596.77372 | 37.7746739782763 | -122.48081801885701 | (37.7746739782763, -122.480818018857) | ||
98253 | 98253 | 91634 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1515 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007819.0 | 2100813.0 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | ||
98254 | 98254 | 87994 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 248 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | ||
99756 | 99756 | 101628 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1585X Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.38905762495199 | (37.7385310737434, -122.389057624952) | ||
100760 | 100760 | 90567 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1800 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5989974.77369 | 2110623.83605 | 37.77479281883429 | -122.47816782258002 | (37.7747928188343, -122.47816782258) | ||
103104 | 103104 | 25585 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1100 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/1997 12:00:00 AM | 30 | 3X3 | 6008661.2482385 | 2097297.4630516004 | 37.7392685988549 | -122.41258496268699 | (37.7392685988549, -122.412584962687) | ||
103422 | 103422 | 88738 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 218 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51672 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | ||
105185 | 105185 | 82729 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 49 Samoset St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.40833270178899 | (37.744466098795, -122.408332701789) | ||
109205 | 109205 | 88157 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 353 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.40269788763901 | (37.7812807348582, -122.402697887639) | ||
109934 | 109934 | 90568 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1818 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989946.281719999 | 2110622.60957 | 37.774787797349205 | -122.478266291409 | (37.7747877973492, -122.478266291409) | ||
111041 | 111041 | 91703 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.41827656224599 | (37.7722336617279, -122.418276562246) | ||
111077 | 111077 | 91609 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 976 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007571.644451 | 2103976.864237 | 37.7575475186204 | -122.41682542620701 | (37.7575475186204, -122.416825426207) | ||
111152 | 111152 | 46563 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 5 | Permit Number 44698 | 6007428.13103163 | 2106459.60978175 | 37.764356489748394 | -122.41749770834998 | (37.7643564897484, -122.41749770835) | ||
112773 | 112773 | 91699 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 143 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.771393498784704 | -122.417934514554 | (37.7713934987847, -122.417934514554) | ||
116508 | 116508 | 91649 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1245 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007697.947405 | 2102409.42617 | 37.753250794870404 | -122.416277603857 | (37.7532507948704, -122.416277603857) | ||
116651 | 116651 | 91583 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 280 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 6007340.222146 | 2108038.912892 | 37.7686879390349 | -122.417913721993 | (37.7686879390349, -122.417913721993) | |||
120681 | 120681 | 91673 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.41706129314801 | (37.7614631059869, -122.417061293148) | ||
122595 | 122595 | 22278 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 4755X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115002 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | ||
124538 | 124538 | 90586 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988739.4165199995 | 2110581.09487 | 37.7746036774674 | -122.482437994797 | (37.7746036774674, -122.482437994797) | ||
124609 | 124609 | 88015 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 77 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | ||
127917 | 127917 | 90555 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992035.9437 | 2110699.81053 | 37.7751208528883 | -122.471043412514 | (37.7751208528883, -122.471043412514) | ||
129112 | 129112 | 90897 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1145 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992033.67177 | 2110642.90774 | 37.774964481845394 | -122.471047125233 | (37.7749644818454, -122.471047125233) | ||
133844 | 133844 | 39269 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 800 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/16/1998 12:00:00 AM | 5 | Permit Number 40882 | 6010051.67469 | 2116602.92631 | 37.79235492430121 | -122.40913935929399 | (37.7923549243012, -122.409139359294) | |
137187 | 137187 | 241363 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 610 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009795.298280001 | 2105395.5079 | 37.7615676169818 | -122.409235207249 | (37.7615676169818, -122.409235207249) | |||
137614 | 137614 | 136179 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2400 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001333.810430001 | 2119043.17386 | 37.79856296146029 | -122.43947832036501 | (37.7985629614603, -122.439478320365) | |||
142071 | 142071 | 87969 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204.0 | 2110019.0 | 37.773777512847296 | -122.439280334526 | (37.7737775128473, -122.439280334526) | ||
142178 | 142178 | 84150 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3324-3330 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50579 | 6007386.65215888 | 2105022.29149516 | 37.7604076136969 | -122.417539297454 | (37.7604076136969, -122.417539297454) | ||
143407 | 143407 | 91647 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1271 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | ||
144800 | 144800 | 91585 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007359.06414 | 2107782.395856 | 37.7679846640127 | -122.41783036345501 | (37.7679846640127, -122.417830363455) | ||
145363 | 145363 | 85250 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.124369999 | 2111060.02557 | 37.7766442216524 | -122.43884948393499 | (37.7766442216524, -122.438849483935) | |
146690 | 146690 | 241281 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1201 Vermont St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6011465.9993 | 2101906.42682 | 37.7520808305785 | -122.403211459137 | (37.7520808305785, -122.403211459137) | |||
149584 | 149584 | 241343 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2170 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009555.0777199995 | 2104672.73912 | 37.7595695967776 | -122.41001500939801 | (37.7595695967776, -122.410015009398) | |||
150108 | 150108 | 241344 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2180 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009557.961759999 | 2104644.45965 | 37.7594921093986 | -122.410003038507 | (37.7594921093986, -122.410003038507) | |||
152365 | 152365 | 196991 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2 Napoleon St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014086.846369999 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | |||
153311 | 153311 | 119966 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5987215.946719999 | 2112352.1893599997 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | |||
158888 | 158888 | 196975 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 209 Mississippi St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6014043.29115 | 2106063.3256200003 | 37.7636383743244 | -122.39458979361099 | (37.7636383743244, -122.394589793611) | |||
161370 | 161370 | 241304 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007541.98711 | 2105410.71397 | 37.761482871149894 | -122.417029586455 | (37.7614828711499, -122.417029586455) | |||
161693 | 161693 | 241355 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 6009659.81185 | 2101050.9246 | 37.7496307742409 | -122.409397182327 | (37.7496307742409, -122.409397182327) | |||
162285 | 162285 | 241373 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 3783 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004532.87463 | 2101890.40961 | 37.751647212562204 | -122.427186107874 | (37.7516472125622, -122.427186107874) | |||
162522 | 162522 | 30565 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | ||
163275 | 163275 | 241358 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1081 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6008654.31002 | 2102275.26835 | 37.7529361586965 | -122.412960810713 | (37.7529361586965, -122.412960810713) | |||
163725 | 163725 | 196982 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | |||
163754 | 163754 | 196981 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2460 Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009761.09751 | 2107855.1809 | 37.7683194004524 | -122.40952709750401 | (37.7683194004524, -122.409527097504) | |||
163897 | 163897 | 241320 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007347.086630001 | 2107747.30956 | 37.767887651234105 | -122.417869305024 | (37.7678876512341, -122.417869305024) | |||
165056 | 165056 | 241299 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007561.10393 | 2105083.1685099998 | 37.7605845824436 | -122.416940261287 | (37.7605845824436, -122.416940261287) | |||
166315 | 166315 | 136177 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003216.31619 | 2118958.4665599996 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | |||
174238 | 174238 | 241311 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007420.66445 | 2106451.36867 | 37.76433344145371 | -122.417522949121 | (37.7643334414537, -122.417522949121) | |||
176576 | 176576 | 196964 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 500 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6015932.05228 | 2105848.0016400004 | 37.7631519652185 | -122.3880420744 | (37.7631519652185, -122.3880420744) | |||
177306 | 177306 | 241346 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2601 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6009581.66758 | 2105919.15522 | 37.762993462413895 | -122.410011039795 | (37.7629934624139, -122.410011039795) | |||
179395 | 179395 | 241382 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 2169 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008151.18943 | 2105840.29781 | 37.762696660032 | -122.414953006889 | (37.762696660032, -122.414953006889) | |||
181475 | 181475 | 241308 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007488.17208 | 2106401.00941 | 37.764198964923295 | -122.417285889641 | (37.7641989649233, -122.417285889641) | |||
185439 | 185439 | 136184 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | |||
185963 | 185963 | 241364 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 826 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6009889.67634 | 2104361.42581 | 37.7587335483391 | -122.408835831807 | (37.7587335483391, -122.408835831807) | |||
186567 | 186567 | 241357 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1099 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6008659.53051 | 2102232.0888799997 | 37.7528178906343 | -122.412939704518 | (37.7528178906343, -122.412939704518) |
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");