trees

232 rows where Neighborhoods (old) = 19 and qSpecies_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

  • 19 · 232 ✖
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)
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
1298 91659 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1015 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007624.666917 2103742.941155 37.7569082017019 -122.4166254819 (37.7569082017019, -122.4166254819) 2 4 7 28859 19
5764 241323 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/16/2019 12:00:00 AM 3 Width 3ft   6007394.41265 2106888.07859 37.7655310677289 -122.417644702035 (37.7655310677289, -122.417644702035) 8 4 7 28853 19
6410 91640 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1427 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007757.588641 2101343.923892 37.7503285203588 -122.415995902486 (37.7503285203588, -122.415995902486) 2 4 7 28859 19
7907 91707 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 6 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
8545 241289 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 9ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
10563 220139 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
11610 241384 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008146.34247 2105906.05304 37.7628769363446 -122.414974425147 (37.7628769363446, -122.414974425147) 8 4 7 28859 19
13557 220140 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 7ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
14811 241276 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010713.5875 2101085.71194 37.7497852786664 -122.405755620526 (37.7497852786664, -122.405755620526) 10 4 7 28859 19
15558 91677 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 599 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007489.042117 2106191.625958 37.7636240956729 -122.417268041752 (37.7636240956729, -122.417268041752) 8 4 7 28859 19
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
15680 91641 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1401X South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007749.533216 2101489.31094 37.7507272674606 -122.416034053567 (37.7507272674606, -122.416034053567) 2 4 7 28859 19
15698 241342 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2122 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009546.72381 2104789.44467 37.7598895755605 -122.410052140597 (37.7598895755605, -122.410052140597) 2 4 7 28859 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
17020 82125 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 317 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/2008 12:00:00 AM 5 3x3 Permit Number 50070 6006739.55759841 2104266.9934198 37.75829730851 -122.41972370977 (37.75829730851, -122.41972370977) 2 4 7 28859 19
18173 241284 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011470.02474 2101959.91095 37.7522279111039 -122.403201300403 (37.7522279111039, -122.403201300403) 10 4 8 28859 19
19316 241287 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
20067 91584 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 1 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
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
22095 241295 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1350 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007154.42592 2107655.79566 37.7676255312226 -122.418529207767 (37.7676255312226, -122.418529207767) 8 4 7 28853 19
22119 241283 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011469.09548 2101944.76887 37.7521862823701 -122.403203448894 (37.7521862823701, -122.403203448894) 10 4 8 28859 19
22150 91686 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 377 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007415.631785 2107493.688708 37.7671951252581 -122.417614236777 (37.7671951252581, -122.417614236777) 8 4 7 28853 19
23759 95623 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 201 Capp St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767388 6007162.9 2106147.3 37.7634840327412 -122.418392924595 (37.7634840327412, -122.418392924595) 8 4 7 28859 19
24305 31508 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2419 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 13   Permit Number 35068 6011299.52328 2102275.53688 37.7530850270762 -122.403813131691 (37.7530850270762, -122.403813131691) 10 4 8 28859 19
24904 91704 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 3 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
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
25956 241315 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007487.69135 2105254.04954 37.7610496524471 -122.417206271746 (37.7610496524471, -122.417206271746) 2 4 7 28859 19
29262 91646 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1271 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007705.648787 2102264.402582 37.7528530260896 -122.416240700263 (37.7528530260896, -122.416240700263) 2 4 7 28859 19
29419 91588 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400x South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007384.392817 2107339.273033 37.7667693781679 -122.417711341871 (37.7667693781679, -122.417711341871) 8 4 7 28853 19
30264 241366 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1399 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010111.5288 2101104.25474 37.7498025060946 -122.40783888207 (37.7498025060946, -122.40783888207) 2 4 7 28859 19
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
35434 91607 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 882 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007541.210677 2104526.186296 37.759054118783 -122.416969598799 (37.759054118783, -122.416969598799) 2 4 7 28859 19
35939 91612 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1108 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007615.164408 2103191.40433 37.755393273338 -122.416619275738 (37.755393273338, -122.416619275738) 2 4 7 28859 19
36145 241371 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2865 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6009580.01982 2102754.75587 37.7543046444459 -122.40979336069 (37.7543046444459, -122.40979336069) 2 4 7 28859 19
37335 241348 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009609.90256 2105923.09061 37.7630058505491 -122.409913662092 (37.7630058505491, -122.409913662092) 8 4 8 28859 19
38921 91625 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1434 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007720.12849 2101296.976541 37.7501975073399 -122.416122118115 (37.7501975073399, -122.416122118115) 2 4 7 28859 19
39867 91624 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1424 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007717.03025 2101352.89464 37.7503508716121 -122.416136791792 (37.7503508716121, -122.416136791792) 2 4 7 28859 19
41188 91672 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 1 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
41845 91616 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1200X South Van Ness Ave 1 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
42600 91638 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1453 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007765.644065 2101198.536844 37.7499297732176 -122.415957751819 (37.7499297732176, -122.415957751819) 2 4 7 28859 19
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
42736 241305 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 697 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 Width 3ft   6007530.22491 2105637.84626 37.7621058621135 -122.417086361543 (37.7621058621135, -122.417086361543) 8 4 7 28859 19
43080 241352 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009685.74216 2105928.63246 37.7630253172965 -122.409651748936 (37.7630253172965, -122.409651748936) 8 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
45380 91682 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007432.064539 2107206.199481 37.766406671896 -122.417537020573 (37.766406671896, -122.417537020573) 8 4 7 28853 19
46855 91705 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 4 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
47891 37711 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 720 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 6   Permit Number 40083 6007483.64662361 2105457.13704999 37.7616070561613 -122.417234652367 (37.7616070561613, -122.417234652367) 2 4 7 28859 19
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
50197 91660 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 999 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/01/2007 12:00:00 AM 3 3x3   6007618.393891 2103856.158531 37.7572187178563 -122.416655196612 (37.7572187178563, -122.416655196612) 2 4 7 28859 19
50595 241318 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 280 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007336.81249 2108065.49507 37.7687607355409 -122.417927400355 (37.7687607355409, -122.417927400355) 8 4 7 28853 19
51857 241278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010738.66995 2101021.37362 37.7496100223844 -122.405664352824 (37.7496100223844, -122.405664352824) 10 4 7 28859 19
52753 241325 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007441.87524 2107194.22963 37.766374357512 -122.417502238664 (37.766374357512, -122.417502238664) 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
53423 91645 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1300X South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007675.941296 2102071.044433 37.7523204379956 -122.416329740365 (37.7523204379956, -122.416329740365) 2 4 7 28859 19
53750 91599 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 700 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007449 2105508 37.7617447647779 -122.41735808585 (37.7617447647779, -122.41735808585) 2 4 7 28859 19
53988 91694 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 245 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007404.295323 2108246.270012 37.7692608986091 -122.417706796624 (37.7692608986091, -122.417706796624) 8 4 7 28853 19
54319 241288 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 16 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6011465.27105 2102063.55943 37.7525122416483 -122.403225029932 (37.7525122416483, -122.403225029932) 10 4 8 28859 19
54649 241274 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2616 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010311.63301 2104008.02665 37.7577868194278 -122.407351591615 (37.7577868194278, -122.407351591615) 10 4 7 28859 19
56651 91619 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1286 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007670.444381 2102173.036115 37.7526001749043 -122.416355973027 (37.7526001749043, -122.416355973027) 2 4 7 28859 19
56814 241333 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 259 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007398.77752 2108173.34419 37.7690603509832 -122.417720712761 (37.7690603509832, -122.417720712761) 8 4 7 28853 19
57032 91601 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 746 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007497.69689 2105311.935767 37.7612091575166 -122.417175768763 (37.7612091575166, -122.417175768763) 2 4 7 28859 19
57071 31514 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2537 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 13   Permit Number 35072 6010934.2499 2102257.13766 37.7530140939364 -122.405075029795 (37.7530140939364, -122.405075029795) 10 4 8 28859 19
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
59684 91684 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 387 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1 Cleary Bros. Landscape 03/01/2007 12:00:00 AM 5 3x3   6007418.830408 2107437.729103 37.7670416532981 -122.41759920657 (37.7670416532981, -122.41759920657) 8 4 7 28853 19
59988 91630 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1490x South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007737.478632 2100983.83524 37.7493386674544 -122.41603994665 (37.7493386674544, -122.41603994665) 2 4 7 28859 19
60318 91631 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1500 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007741.508083 2100911.11035 37.7491392078361 -122.416020863166 (37.7491392078361, -122.416020863166) 2 4 7 28859 19
60684 241329 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 349 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007417.32507 2107664.81767 37.7676651004942 -122.417620510295 (37.7676651004942, -122.417620510295) 8 4 7 28853 19
60767 91618 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1240 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007656.818859 2102429.616316 37.7533039196294 -122.41642126514 (37.7533039196294, -122.41642126514) 2 4 7 28859 19
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
67006 91687 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 373 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007414.352338 2107516.072508 37.7672565139252 -122.417620248867 (37.7672565139252, -122.417620248867) 8 4 7 28853 19
67242 241290 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1227 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011160.10458 2102427.21865 37.753493722159 -122.404305946667 (37.753493722159, -122.404305946667) 10 4 8 28859 19
67599 91656 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1141 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007665.027497 2103014.499609 37.7549103375799 -122.416434303552 (37.7549103375799, -122.416434303552) 2 4 7 28859 19
67982 241367 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3747 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6005339.63853 2104274.22686 37.7582382098444 -122.424565763112 (37.7582382098444, -122.424565763112) 2 4 5 28859 19
68023 241368 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2879 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009498.83241 2102749.66821 37.75428612472 -122.410073769282 (37.75428612472, -122.410073769282) 2 4 7 28859 19
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
74482 91579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 170 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   06/19/2013 01:09:00 PM 3 3x3   6007322.882921 2108766.782992 37.7706855226421 -122.418025303656 (37.7706855226421, -122.418025303656) 8 2 9 28853 19
74691 52826 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3063 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52281 6009164.51309648 2101559.46503951 37.7509993493006 -122.411145866905 (37.7509993493006, -122.411145866905) 2 4 7 28859 19
75362 91635 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1515 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007819 2100813 37.7488741754589 -122.415745948384 (37.7488741754589, -122.415745948384) 2 4 7 28859 19
75650 241361 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 608 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009795.10344 2105420.22693 37.7616354789124 -122.409237625525 (37.7616354789124, -122.409237625525) 2 4 8 28859 19
77309 91657 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1133 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007662.546411 2103059.279009 37.7550331520704 -122.416446055556 (37.7550331520704, -122.416446055556) 2 4 7 28859 19
78586 241277 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010729.0783 2101044.09639 37.749671877762 -122.405699121544 (37.749671877762, -122.405699121544) 10 4 7 28859 19
79863 241303 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 731 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007544.46079 2105381.89304 37.7614038747014 -122.417018988842 (37.7614038747014, -122.417018988842) 2 4 7 28859 19
80479 91680 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 565 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007478.430249 2106383.249501 37.7641496522652 -122.417318325278 (37.7641496522652, -122.417318325278) 8 4 7 28859 19
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
81154 91654 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1169 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007673.711302 2102857.771696 37.7544804867979 -122.416393171829 (37.7544804867979, -122.416393171829) 2 4 7 28859 19
81234 241340 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009746.5481 2105459.14432 37.7617396168174 -122.409408306065 (37.7617396168174, -122.409408306065) 2 4 8 28859 19
81519 32351 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 9   Permit Number 36907 6009560.84271 2104624.99701 37.7594388308635 -122.409991700751 (37.7594388308635, -122.409991700751) 2 4 7 28859 19
82690 241362 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009794.30933 2105409.48411 37.7616059370772 -122.409239613928 (37.7616059370772, -122.409239613928) 2 4 8 28859 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
84099 91688 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 349 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007406.675646 2107650.375519 37.7676248464865 -122.417656321662 (37.7676248464865, -122.417656321662) 8 4 7 28853 19
84687 91615 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1176 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007636.253645 2102810.779435 37.754349350274 -122.416519382003 (37.754349350274, -122.416519382003) 2 4 7 28859 19
86391 241321 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 356 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007355.98691 2107612.7207 37.7675186027402 -122.417828978541 (37.7675186027402, -122.417828978541) 8 4 7 28853 19
86392 241360 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 600 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009793.68997 2105435.76266 37.7616780573116 -122.409243610512 (37.7616780573116, -122.409243610512) 2 4 8 28859 19
87205 91675 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 637 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007502.174043 2105954.495988 37.7629737307137 -122.41720581807 (37.7629737307137, -122.41720581807) 8 4 7 28859 19
87512 91604 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 802 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007516.377022 2104974.620116 37.7602840176254 -122.417087260164 (37.7602840176254, -122.417087260164) 2 4 7 28859 19
87745 241345 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009569.08803 2105916.84613 37.7629864171226 -122.410054385304 (37.7629864171226, -122.410054385304) 8 4 8 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);