trees
98 rows where SiteOrder = 2 and qSpecies_id = 123
This data as json, CSV (advanced)
rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
925 | 34964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 900 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2019 12:00:00 AM | 3 | Permit Number 38553 | 6014444.74274 | 2102850.73033 | 37.7548395926778 | -122.392976501569 | (37.7548395926778, -122.392976501569) | 10 | 3 | 8 | 28856 | 29 | ||
1297 | 241324 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/16/2019 12:00:00 AM | 3 | Width 3ft | 6007395.81182 | 2106861.74234 | 37.765458833278 | -122.417637995807 | (37.765458833278, -122.417637995807) | 8 | 4 | 7 | 28853 | 19 | ||
4592 | 196983 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
14948 | 90869 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989208.80531 | 2110541.29026 | 37.7745216791694 | -122.480811390162 | (37.7745216791694, -122.480811390162) | 11 | 6 | 2 | 55 | 26 | ||
15070 | 19922 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 100 STAIRWAY37 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
15597 | 91581 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007370.010963 | 2108444.137303 | 37.7698022661703 | -122.417839412441 | (37.7698022661703, -122.417839412441) | 8 | 4 | 9 | 28853 | 19 | ||
16388 | 241286 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 Vermont St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6011483 | 2102064 | 37.7525144414714 | -122.403163750863 | (37.7525144414714, -122.403163750863) | 10 | 4 | 8 | 28859 | 19 | |||
16406 | 241355 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2970 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6009659.81185 | 2101050.9246 | 37.7496307742409 | -122.409397182327 | (37.7496307742409, -122.409397182327) | 2 | 4 | 7 | 28859 | 19 | |||
16583 | 241346 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2601 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6009581.66758 | 2105919.15522 | 37.7629934624139 | -122.410011039795 | (37.7629934624139, -122.410011039795) | 8 | 4 | 8 | 28859 | 19 | |||
21100 | 241341 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2701 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009762.27519 | 2105459.58065 | 37.7617416960496 | -122.409353942929 | (37.7617416960496, -122.409353942929) | 2 | 4 | 8 | 28859 | 19 | |||
23653 | 90897 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1145 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5992033.67177 | 2110642.90774 | 37.7749644818454 | -122.471047125233 | (37.7749644818454, -122.471047125233) | 11 | 6 | 2 | 54 | 11 | ||
25076 | 241291 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1225 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011156.6405 | 2102469.67171 | 37.7536100953402 | -122.404320914102 | (37.7536100953402, -122.404320914102) | 10 | 4 | 8 | 28859 | 19 | |||
27091 | 90555 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1150 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992035.9437 | 2110699.81053 | 37.7751208528883 | -122.471043412514 | (37.7751208528883, -122.471043412514) | 11 | 6 | 2 | 54 | 11 | ||
31101 | 88015 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 77 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51043 | 6008723.4 | 2112463.6 | 37.780914833514 | -122.413442364822 | (37.780914833514, -122.413442364822) | 7 | 10 | 9 | 28852 | 36 | ||
31987 | 39269 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 800 Powell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/16/1998 12:00:00 AM | 5 | Permit Number 40882 | 6010051.67469 | 2116602.92631 | 37.7923549243012 | -122.409139359294 | (37.7923549243012, -122.409139359294) | 3 | 1 | 10 | 28857 | 4 | |
32834 | 241370 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2877 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 7ft | 6009531.75591 | 2102750.92335 | 37.7542914163323 | -122.409959999651 | (37.7542914163323, -122.409959999651) | 2 | 4 | 7 | 28859 | 19 | |||
36193 | 90586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2200X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988739.41652 | 2110581.09487 | 37.7746036774674 | -122.482437994797 | (37.7746036774674, -122.482437994797) | 11 | 6 | 2 | 55 | 26 | ||
42648 | 241281 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1201 Vermont St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6011465.9993 | 2101906.42682 | 37.7520808305785 | -122.403211459137 | (37.7520808305785, -122.403211459137) | 10 | 4 | 8 | 28859 | 19 | |||
43855 | 91617 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1200X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007645 | 2102652 | 37.7539138699857 | -122.416477888477 | (37.7539138699857, -122.416477888477) | 2 | 4 | 7 | 28859 | 19 | ||
44084 | 41912 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 642 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 8 | Permit Number 42274 | 5992258.1025 | 2111064.36491 | 37.7761346671426 | -122.470301476833 | (37.7761346671426, -122.470301476833) | 11 | 6 | 2 | 54 | 11 | |
46483 | 83567 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 62 Woodland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50867 | 5997102.41885097 | 2106267.4466409 | 37.7632424534183 | -122.453197397762 | (37.7632424534183, -122.453197397762) | 15 | 5 | 11 | 29492 | 12 | ||
47581 | 88507 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 896 Darien Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51444 | 5994359.2 | 2093914.2 | 37.7291659423967 | -122.461789444316 | (37.7291659423967, -122.461789444316) | 9 | 8 | 4 | 59 | 40 | ||
47749 | 84105 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3909 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50417 | 6003719.39167552 | 2102426.4465388 | 37.7530730069117 | -122.430037470862 | (37.7530730069117, -122.430037470862) | 2 | 4 | 5 | 28862 | 22 | ||
49326 | 91582 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270x South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007359 | 2108191 | 37.7691065911809 | -122.417859552844 | (37.7691065911809, -122.417859552844) | 8 | 4 | 7 | 28853 | 19 | ||
52926 | 241317 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 270 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007335.93397 | 2108086.9588 | 37.7688196204438 | -122.417931960818 | (37.7688196204438, -122.417931960818) | 8 | 4 | 7 | 28853 | 19 | |||
55070 | 90888 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1643 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 2 | 3x3 | 5990427.38922 | 2110587.78256 | 37.7747200883254 | -122.47659951411 | (37.7747200883254, -122.47659951411) | 11 | 6 | 2 | 55 | 26 | ||
55570 | 100314 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1683 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6015409.74359 | 2097962.08476 | 37.7414699491892 | -122.389297877816 | (37.7414699491892, -122.389297877816) | 10 | 3 | 8 | 58 | 1 | |||
55713 | 136180 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3134 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999407.16472 | 2119635.33058 | 37.8000790286731 | -122.446187711617 | (37.8000790286731, -122.446187711617) | 13 | 9 | 1 | 57 | 17 | |||
56230 | 136182 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3140 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999403.04173 | 2119664.02877 | 37.8001575907471 | -122.446204044176 | (37.8001575907471, -122.446204044176) | 13 | 9 | 1 | 57 | 17 | |||
58715 | 196964 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 500 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015932.05228 | 2105848.00164 | 37.7631519652185 | -122.3880420744 | (37.7631519652185, -122.3880420744) | 14 | 3 | 8 | 28856 | 29 | |||
59371 | 91679 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007478.430249 | 2106383.249501 | 37.7641496522652 | -122.417318325278 | (37.7641496522652, -122.417318325278) | 8 | 4 | 7 | 28859 | 19 | ||
60226 | 100425 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 200X Stonecrest Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x6 | 5990724.7 | 2093134.9 | 37.7268162840874 | -122.47429724264 | (37.7268162840874, -122.47429724264) | 9 | 8 | 4 | 64 | 40 | ||||
62289 | 91591 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 490 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007414.001232 | 2106821.277656 | 37.7653487502341 | -122.41757221445 | (37.7653487502341, -122.41757221445) | 8 | 4 | 7 | 28853 | 19 | ||
66671 | 38887 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 316 Laurel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | 6 | Permit Number 40705 | 5998129.65961 | 2115308.75845 | 37.7881263812657 | -122.450296300351 | (37.7881263812657, -122.450296300351) | 13 | 6 | 1 | 54 | 31 | |
67071 | 3776 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 6 Carpenter Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.2597904 | 2095536.4485417 | 37.7348782815847 | -122.38484307413 | (37.7348782815847, -122.38484307413) | 10 | 3 | 8 | 58 | 1 | ||
67085 | 241273 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 55 Haight St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6005874.88911 | 2109629.37494 | 37.7729723901943 | -122.423095264536 | (37.7729723901943, -122.423095264536) | 7 | 9 | 11 | 28852 | 10 | |||
67783 | 90864 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2207 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5988718.74486 | 2110525.68485 | 37.7744503344144 | -122.482505440318 | (37.7744503344144, -122.482505440318) | 11 | 6 | 2 | 55 | 26 | ||
68475 | 91629 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1474 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007732.521449 | 2101073.304189 | 37.7495840503135 | -122.416063424016 | (37.7495840503135, -122.416063424016) | 2 | 4 | 7 | 28859 | 19 | ||
69848 | 91667 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007551.894714 | 2105056.665982 | 37.7605112945984 | -122.416970234051 | (37.7605112945984, -122.416970234051) | 2 | 4 | 7 | 28859 | 19 | ||
71899 | 136184 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006503.30451 | 2120455.88239 | 37.8027347473741 | -122.421690613452 | (37.8027347473741, -122.421690613452) | 5 | 9 | 1 | 28858 | 32 | |||
74147 | 88499 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1599@ Lane Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51438 | 6015105.8 | 2094319.6 | 37.7314515735977 | -122.39009441777 | (37.7314515735977, -122.39009441777) | 10 | 3 | 8 | 58 | 1 | ||
76553 | 123210 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993133.98431 | 2112655.94122 | 37.7805553064396 | -122.467387351051 | (37.7805553064396, -122.467387351051) | 11 | 6 | 2 | 54 | 11 | |||
76848 | 22262 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4655X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6015123.96867 | 2095945.95372 | 37.7359182191114 | -122.390145181472 | (37.7359182191114, -122.390145181472) | 10 | 3 | 8 | 58 | 1 | |||
80892 | 120913 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 499X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007431 | 2106864 | 37.7654670122947 | -122.41751644763 | (37.7654670122947, -122.41751644763) | 8 | 4 | 7 | 28853 | 19 | |||
83333 | 196981 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2460 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009761.09751 | 2107855.1809 | 37.7683194004524 | -122.409527097504 | (37.7683194004524, -122.409527097504) | 8 | 4 | 8 | 28853 | 19 | |||
87658 | 87989 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 233 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51028 | 6009741 | 2113986 | 37.785152065252 | -122.410029478455 | (37.785152065252, -122.410029478455) | 14 | 10 | 9 | 28852 | 36 | ||
90241 | 241363 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 610 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009795.29828 | 2105395.5079 | 37.7615676169818 | -122.409235207249 | (37.7615676169818, -122.409235207249) | 2 | 4 | 8 | 28859 | 19 | |||
92157 | 121263 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x3 | 6007449 | 2105508 | 37.7617447647779 | -122.41735808585 | (37.7617447647779, -122.41735808585) | 2 | 4 | 7 | 28859 | 19 | |||
92182 | 196991 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2 Napoleon St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6014086.84637 | 2100149.18925 | 37.7474018495283 | -122.394025106589 | (37.7474018495283, -122.394025106589) | 10 | 3 | 8 | 58 | 1 | |||
92727 | 241365 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1475 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6010134.56863 | 2100721.5441 | 37.7487529567978 | -122.407732226982 | (37.7487529567978, -122.407732226982) | 2 | 4 | 7 | 28859 | 19 | |||
94223 | 136177 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2028 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003216.31619 | 2118958.46656 | 37.7984373333682 | -122.432958210354 | (37.7984373333682, -122.432958210354) | 13 | 9 | 1 | 57 | 17 | |||
99310 | 87994 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 248 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/2008 12:00:00 AM | 3x3 | Permit Number 51031 | 6008142.6 | 2113255.6 | 37.7830568472778 | -122.415507732402 | (37.7830568472778, -122.415507732402) | 7 | 10 | 9 | 28852 | 36 | ||
103612 | 241364 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 826 York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 6009889.67634 | 2104361.42581 | 37.7587335483391 | -122.408835831807 | (37.7587335483391, -122.408835831807) | 2 | 4 | 7 | 28859 | 19 | |||
104346 | 101628 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1585X Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/2012 12:00:00 AM | 3x3 | Permit Number 768640 | 6015457.6 | 2096890.8 | 37.7385310737434 | -122.389057624952 | (37.7385310737434, -122.389057624952) | 10 | 3 | 8 | 58 | 1 | ||
104412 | 119966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 524 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5987215.94672 | 2112352.18936 | 37.7793778617147 | -122.487838060827 | (37.7793778617147, -122.487838060827) | 11 | 6 | 2 | 55 | 26 | |||
104883 | 241373 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3783 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004532.87463 | 2101890.40961 | 37.7516472125622 | -122.427186107874 | (37.7516472125622, -122.427186107874) | 2 | 4 | 5 | 28862 | 22 | |||
105407 | 241312 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 700 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007473.64747 | 2105479.75896 | 37.7616686081336 | -122.41727083858 | (37.7616686081336, -122.41727083858) | 2 | 4 | 7 | 28859 | 19 | |||
109489 | 25585 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1100 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/1997 12:00:00 AM | 30 | 3X3 | 6008661.2482385 | 2097297.4630516 | 37.7392685988549 | -122.412584962687 | (37.7392685988549, -122.412584962687) | 10 | 7 | 7 | 28859 | 2 | ||
110190 | 88738 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 218 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51672 | 6002821.3 | 2109296.6 | 37.7718858820629 | -122.433634203014 | (37.7718858820629, -122.433634203014) | 15 | 5 | 11 | 29492 | 9 | ||
110974 | 120834 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2033 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5989271.19606 | 2110543.25177 | 37.7745306911578 | -122.480595714565 | (37.7745306911578, -122.480595714565) | 11 | 6 | 2 | 55 | 26 | |||
111602 | 91634 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1515 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007819 | 2100813 | 37.7488741754589 | -122.415745948384 | (37.7488741754589, -122.415745948384) | 2 | 4 | 7 | 28859 | 19 | ||
112009 | 196975 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 209 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014043.29115 | 2106063.32562 | 37.7636383743244 | -122.394589793611 | (37.7636383743244, -122.394589793611) | 14 | 3 | 8 | 28856 | 29 | |||
112842 | 90578 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2050X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989208.06357 | 2110596.77372 | 37.7746739782763 | -122.480818018857 | (37.7746739782763, -122.480818018857) | 11 | 6 | 2 | 55 | 26 | ||
113993 | 36966 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 381 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | 7 | Permit Number 39594 | 5994314.52093 | 2112981.13075 | 37.7815162715185 | -122.463326949801 | (37.7815162715185, -122.463326949801) | 11 | 6 | 2 | 54 | 11 | |
116025 | 30565 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2245 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1995 12:00:00 AM | 7 | Permit Number 34543 | 6002240.34549 | 2118428.38115 | 37.7969264516424 | -122.436297407498 | (37.7969264516424, -122.436297407498) | 13 | 9 | 1 | 57 | 17 | ||
118233 | 179275 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 716 Peru Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005245.16074 | 2092477.21394 | 37.7258409541933 | -122.424053582122 | (37.7258409541933, -122.424053582122) | 9 | 7 | 6 | 309 | 5 | |||
120740 | 88157 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 353 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51181 | 6011830.6 | 2112533.5 | 37.7812807348582 | -122.402697887639 | (37.7812807348582, -122.402697887639) | 6 | 2 | 9 | 28853 | 34 | ||
125452 | 196979 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1551 20th St | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.397014079838 | (37.7599198521353, -122.397014079838) | 10 | 3 | 8 | 28856 | 29 | |||
125523 | 104460 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601X Kansas St | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
131142 | 241308 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 565 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007488.17208 | 2106401.00941 | 37.7641989649233 | -122.417285889641 | (37.7641989649233, -122.417285889641) | 8 | 4 | 7 | 28859 | 19 | |||
131374 | 82729 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 49 Samoset St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2008 12:00:00 AM | 3x3 | Permit Number 50251 | 6009929.1659667 | 2099164.47966506 | 37.744466098795 | -122.408332701789 | (37.744466098795, -122.408332701789) | 2 | 7 | 7 | 28859 | 2 | ||
134217 | 91699 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 143 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007354.401692 | 2109023.98005 | 37.7713934987847 | -122.417934514554 | (37.7713934987847, -122.417934514554) | 8 | 2 | 9 | 28853 | 19 | ||
135225 | 197004 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 503 Beale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6015943.64363 | 2113959.00175 | 37.7854236244348 | -122.388568185881 | (37.7854236244348, -122.388568185881) | 6 | 2 | 9 | 28856 | 6 | |||
138245 | 46563 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2002 12:00:00 AM | 5 | Permit Number 44698 | 6007428.13103163 | 2106459.60978175 | 37.7643564897484 | -122.41749770835 | (37.7643564897484, -122.41749770835) | 8 | 4 | 7 | 28859 | 19 | ||
143144 | 91583 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 280 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 6007340.222146 | 2108038.912892 | 37.7686879390349 | -122.417913721993 | (37.7686879390349, -122.417913721993) | 8 | 4 | 7 | 28853 | 19 | |||
143289 | 241382 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2169 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008151.18943 | 2105840.29781 | 37.762696660032 | -122.414953006889 | (37.762696660032, -122.414953006889) | 8 | 4 | 7 | 28859 | 19 | |||
144571 | 91703 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007261.828778 | 2109331.862933 | 37.7722336617279 | -122.418276562246 | (37.7722336617279, -122.418276562246) | 8 | 2 | 9 | 28853 | 19 | ||
146984 | 91609 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 976 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007571.644451 | 2103976.864237 | 37.7575475186204 | -122.416825426207 | (37.7575475186204, -122.416825426207) | 2 | 4 | 7 | 28859 | 19 | ||
148213 | 136179 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2400 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6001333.81043 | 2119043.17386 | 37.7985629614603 | -122.439478320365 | (37.7985629614603, -122.439478320365) | 13 | 9 | 1 | 57 | 17 | |||
151093 | 241311 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 550 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007420.66445 | 2106451.36867 | 37.7643334414537 | -122.417522949121 | (37.7643334414537, -122.417522949121) | 8 | 4 | 7 | 28859 | 19 | |||
151905 | 22278 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 4755X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 01/31/1992 12:00:00 AM | 6 | 3X3 | 6015037.5047362 | 2095657.5026115 | 37.7351213950345 | -122.390423975921 | (37.7351213950345, -122.390423975921) | 10 | 3 | 8 | 58 | 1 | ||
155023 | 80092 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1800-1804 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52336 | 6004273.51915 | 2119103.69822 | 37.7988960100912 | -122.429310324527 | (37.7988960100912, -122.429310324527) | 13 | 9 | 1 | 57 | 17 | |
160938 | 241304 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007541.98711 | 2105410.71397 | 37.7614828711499 | -122.417029586455 | (37.7614828711499, -122.417029586455) | 2 | 4 | 7 | 28859 | 19 | |||
161394 | 91673 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 731 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007532.676036 | 2105403.706321 | 37.7614631059869 | -122.417061293148 | (37.7614631059869, -122.417061293148) | 2 | 4 | 7 | 28859 | 19 | ||
163999 | 94082 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1355 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53468 | 6007647.44648 | 2117801.56463 | 37.7955111067173 | -122.41754305889 | (37.7955111067173, -122.41754305889) | 5 | 1 | 10 | 28858 | 32 | |
164866 | 91649 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1245 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007697.947405 | 2102409.42617 | 37.7532507948704 | -122.416277603857 | (37.7532507948704, -122.416277603857) | 2 | 4 | 7 | 28859 | 19 | ||
167044 | 241320 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007347.08663 | 2107747.30956 | 37.7678876512341 | -122.417869305024 | (37.7678876512341, -122.417869305024) | 8 | 4 | 7 | 28853 | 19 | |||
173753 | 87969 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1301 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51004 | 6001204 | 2110019 | 37.7737775128473 | -122.439280334526 | (37.7737775128473, -122.439280334526) | 15 | 5 | 11 | 29492 | 10 | ||
175176 | 84150 | Permitted Site 7 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 3324-3330 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50579 | 6007386.65215888 | 2105022.29149516 | 37.7604076136969 | -122.417539297454 | (37.7604076136969, -122.417539297454) | 2 | 4 | 7 | 28859 | 19 | ||
176194 | 241296 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1350 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007156.61283 | 2107616.82741 | 37.7675186566968 | -122.41851887996 | (37.7675186566968, -122.41851887996) | 8 | 4 | 7 | 28853 | 19 | |||
176314 | 196982 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1601 Kansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6011835.24913 | 2100548.938 | 37.7483740760146 | -122.401839117097 | (37.7483740760146, -122.401839117097) | 10 | 3 | 8 | 58 | 1 | |||
177703 | 91647 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1271 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007705.648787 | 2102264.402582 | 37.7528530260896 | -122.416240700263 | (37.7528530260896, -122.416240700263) | 2 | 4 | 7 | 28859 | 19 | ||
179949 | 91585 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 324 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007359.06414 | 2107782.395856 | 37.7679846640127 | -122.417830363455 | (37.7679846640127, -122.417830363455) | 8 | 4 | 7 | 28853 | 19 | ||
186656 | 241344 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2180 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009557.96176 | 2104644.45965 | 37.7594921093986 | -122.410003038507 | (37.7594921093986, -122.410003038507) | 2 | 4 | 7 | 28859 | 19 | |||
190029 | 241343 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 2170 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009555.07772 | 2104672.73912 | 37.7595695967776 | -122.410015009398 | (37.7595695967776, -122.410015009398) | 2 | 4 | 7 | 28859 | 19 | |||
190505 | 85250 | - 12 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1335 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 07/19/2007 12:00:00 AM | 15 | 3x3 | under 3yr maintenance agreement. Expires 7/19/2010. | 6001350.12437 | 2111060.02557 | 37.7766442216524 | -122.438849483935 | (37.7766442216524, -122.438849483935) | 15 | 5 | 11 | 29492 | 10 |
193578 | 241299 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 793 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007561.10393 | 2105083.16851 | 37.7605845824436 | -122.416940261287 | (37.7605845824436, -122.416940261287) | 2 | 4 | 7 | 28859 | 19 | |||
193922 | 179281 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 16 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010435.48171 | 2094947.68687 | 37.7329160304499 | -122.406284910247 | (37.7329160304499, -122.406284910247) | 10 | 3 | 7 | 309 | 28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );