trees

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

✎ View and edit SQL

This data as json, CSV (advanced)

Neighborhoods (old) ✖

  • 19 · 132 ✖
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)
87982 91650 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 3 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
88350 91701 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 101x South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007269.02291 2109328.047293 37.7722235898389 -122.41825140648 (37.7722235898389, -122.41825140648) 8 2 9 28853 19
88879 241357 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   6008659.53051 2102232.08888 37.7528178906343 -122.412939704518 (37.7528178906343, -122.412939704518) 2 4 7 28859 19
89482 91663 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 859 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007573.699386 2104662.928197 37.7594314080197 -122.416866925134 (37.7594314080197, -122.416866925134) 2 4 7 28859 19
89764 241327 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 377 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007424.50403 2107516.88319 37.7672593111026 -122.417585193005 (37.7672593111026, -122.417585193005) 8 4 7 28853 19
90022 91674 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 697 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007520.814164 2105617.901611 37.7620505693283 -122.417117496488 (37.7620505693283, -122.417117496488) 8 4 7 28859 19
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
91402 241353 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   6009702.25291 2105928.94008 37.7630270871447 -122.409594665358 (37.7630270871447, -122.409594665358) 8 4 8 28859 19
91934 91678 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 565 South Van Ness Ave 1 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
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
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
93792 241347 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009595.63011 2105921.4482 37.7630005409651 -122.409962909868 (37.7630005409651, -122.409962909868) 8 4 8 28859 19
94776 91627 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1468 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007730.662506 2101106.855019 37.7496760688109 -122.416072228065 (37.7496760688109, -122.416072228065) 2 4 7 28859 19
95212 91600 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 722 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007467 2105381 37.7613970649262 -122.417286830828 (37.7613970649262, -122.417286830828) 2 4 7 28859 19
95270 241307 Undocumented 4 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 629 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007511.70266 2105973.00163 37.7630250789657 -122.417174173153 (37.7630250789657, -122.417174173153) 8 4 7 28859 19
95383 241300 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007560.00542 2105104.33275 37.7606426327636 -122.416945560095 (37.7606426327636, -122.416945560095) 2 4 7 28859 19
95941 91580 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 200x South Van Ness Ave 1 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
96199 91639 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1435 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007760.067233 2101299.189418 37.7502058289413 -122.415984163776 (37.7502058289413, -122.415984163776) 2 4 7 28859 19
96550 91587 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 362 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 4 3x3   6007371.2189 2107569.74946 37.7674014710001 -122.417773246729 (37.7674014710001, -122.417773246729) 8 4 7 28853 19
99873 35784 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51612 6004919.48722825 2106038.70275083 37.7630593064236 -122.426144444701 (37.7630593064236, -122.426144444701) 8 4 5 28859 19
100115 91632 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1540 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007748.949212 2100776.810346 37.748770868614 -122.415985622241 (37.748770868614, -122.415985622241) 2 4 7 28859 19
102562 241293 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1300 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6011113.70254 2102244.24348 37.7529887195714 -122.404453537112 (37.7529887195714, -122.404453537112) 10 4 8 28859 19
102687 241279 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 19 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010767.41286 2100951.64139 37.7494201602129 -122.405560047672 (37.7494201602129, -122.405560047672) 10 4 7 28859 19
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
103723 241301 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 765 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007553.45453 2105201.24032 37.7609083500518 -122.416975083028 (37.7609083500518, -122.416975083028) 2 4 7 28859 19
103864 32350 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 11   Permit Number 36907 6009568.01706 2104596.56642 37.7593611689943 -122.40996488119 (37.7593611689943, -122.40996488119) 2 4 7 28859 19
103971 241282 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011466.58759 2101921.66983 37.7521227174025 -122.403210496885 (37.7521227174025, -122.403210496885) 10 4 8 28859 19
105398 91651 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1245 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007697.947405 2102409.42617 37.7532507948704 -122.416277603857 (37.7532507948704, -122.416277603857) 2 4 7 28859 19
105405 91590 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 490 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007414.001232 2106821.277656 37.7653487502341 -122.41757221445 (37.7653487502341, -122.41757221445) 8 4 7 28853 19
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
105683 241297 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1534 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007142.6566 2107359.78421 37.7668120908263 -122.418548923599 (37.7668120908263, -122.418548923599) 8 4 7 28853 19
106489 91706 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 5 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
108205 91655 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1155 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007669.369399 2102936.135663 37.7546954122234 -122.416413737633 (37.7546954122234, -122.416413737633) 2 4 7 28859 19
108520 241298 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007561.5863 2105063.97813 37.760531917228 -122.416937233294 (37.760531917228, -122.416937233294) 2 4 7 28859 19
111472 91628 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1474 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007732.521449 2101073.304189 37.7495840503135 -122.416063424016 (37.7495840503135, -122.416063424016) 2 4 7 28859 19
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
111765 91613 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1116 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 10 3x3   6007617.645495 2103146.62493 37.7552704588724 -122.416607523387 (37.7552704588724, -122.416607523387) 2 4 7 28859 19
111775 241385 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6008146.20784 2105935.07496 37.7629566162671 -122.41497694503 (37.7629566162671, -122.41497694503) 8 4 7 28859 19
112988 241350 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009654.92584 2105925.07195 37.7630138140553 -122.409758081181 (37.7630138140553, -122.409758081181) 8 4 8 28859 19
114516 241358 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1081 Treat Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 6ft   6008654.31002 2102275.26835 37.7529361586965 -122.412960810713 (37.7529361586965, -122.412960810713) 2 4 7 28859 19
118012 241319 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 324 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007346.30903 2107764.0705 37.7679336290724 -122.417873182915 (37.7679336290724, -122.417873182915) 8 4 7 28853 19
122308 91633 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1515 South Van Ness Ave 1 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
122969 241351 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 6ft   6009671.13273 2105926.35263 37.7630182387282 -122.409702117253 (37.7630182387282, -122.409702117253) 8 4 8 28859 19
123616 241386 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2169 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008144.96622 2105963.39406 37.763034304202 -122.414983243884 (37.763034304202, -122.414983243884) 8 4 7 28859 19
123745 241313 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 720 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007476.61227 2105442.18225 37.7615655979969 -122.417257921613 (37.7615655979969, -122.417257921613) 2 4 7 28859 19
123994 121589 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270x South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007359 2108191 37.7691065911809 -122.417859552844 (37.7691065911809, -122.417859552844) 8 4 7 28853 19
126071 241306 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 635 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007512.51553 2105948.57414 37.7629580524843 -122.417169630685 (37.7629580524843, -122.417169630685) 8 4 7 28859 19
128361 91689 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 335 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007402.197577 2107728.718925 37.7678397070843 -122.417677364286 (37.7678397070843, -122.417677364286) 8 4 7 28853 19
128961 91690 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 315 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007395.800334 2107840.638089 37.7681466508094 -122.417707425394 (37.7681466508094, -122.417707425394) 8 4 7 28853 19
129554 120951 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 741 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6007568 2105341 37.7612929159977 -122.416934678899 (37.7612929159977, -122.416934678899) 2 4 7 28859 19
129945 91693 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 253 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007399.603267 2108201.969765 37.7691389965346 -122.417719885805 (37.7691389965346, -122.417719885805) 8 4 7 28853 19
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
132267 91658 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1073 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007642.630657 2103418.725072 37.7560189888407 -122.416540390694 (37.7560189888407, -122.416540390694) 2 4 7 28859 19
133550 241356 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3041 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6009354.55363 2100986.01535 37.749435439707 -122.410448197535 (37.749435439707, -122.410448197535) 2 4 7 28859 19
133771 91586 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 356 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007369.299728 2107603.325202 37.7674935541002 -122.417782265097 (37.7674935541002, -122.417782265097) 8 4 7 28853 19
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
135185 241339 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2707 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009729.78186 2105457.4669 37.761734071584 -122.409466175622 (37.761734071584, -122.409466175622) 2 4 8 28859 19
135561 91626 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1450 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007725.085674 2101207.507592 37.749952124518 -122.416098640357 (37.749952124518, -122.416098640357) 2 4 7 28859 19
135886 241369 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2877 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 7ft   6009515.68514 2102750.48038 37.7542892993236 -122.410015545387 (37.7542892993236, -122.410015545387) 2 4 7 28859 19
135948 84422 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3324-3330 19th St 1 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
136593 91668 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 3 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
136903 37712 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 720 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/29/1998 12:00:00 AM 4   Permit Number 40083 6007483.64662361 2105457.13704999 37.7616070561613 -122.417234652367 (37.7616070561613, -122.417234652367) 2 4 7 28859 19
137034 241359 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 707 Treat Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 8ft   6008539.21153 2104376.13627 37.7586982040894 -122.413507415061 (37.7586982040894, -122.413507415061) 2 4 7 28859 19
137048 241309 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 565 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007486.87936 2106417.71309 37.7642447566068 -122.417291544578 (37.7642447566068, -122.417291544578) 8 4 7 28859 19
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
139041 241316 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 270 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007332.32989 2108125.54734 37.7689253726442 -122.41794716295 (37.7689253726442, -122.41794716295) 8 4 7 28853 19
139468 91692 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 263 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007399.273892 2108147.255986 37.7689887468538 -122.417717146452 (37.7689887468538, -122.417717146452) 8 4 7 28853 19
139882 91608 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 918 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 7 3x3   6007553.688973 2104300.922411 37.758436297925 -122.416910482813 (37.758436297925, -122.416910482813) 2 4 7 28859 19
140031 241328 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 373 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007423.72887 2107548.58471 37.7673463124187 -122.417590121285 (37.7673463124187, -122.417590121285) 8 4 7 28853 19
142131 91614 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1140 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007588 2102997 37.7548579556474 -122.416699447347 (37.7548579556474, -122.416699447347) 2 4 7 28859 19
142984 31525 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1330 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 12 4x4 Permit Number 35080 6011118.50482 2102111.69571 37.7526250409161 -122.404427600678 (37.7526250409161, -122.404427600678) 10 4 8 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
143430 91578 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 160 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/19/2013 01:03:00 PM 4 3x3   6007300.496664 2108846.846012 37.7709040967706 -122.418108415168 (37.7709040967706, -122.418108415168) 8 2 9 28853 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
144829 241322 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 442 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007381.66806 2107115.42092 37.7661545793962 -122.417704898167 (37.7661545793962, -122.417704898167) 8 4 7 28853 19
145660 91669 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 765 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007543.215311 2105213.393874 37.7609411449227 -122.417011357225 (37.7609411449227, -122.417011357225) 2 4 7 28859 19
146824 32353 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 8   Permit Number 36907 6009556.94604 2104659.06953 37.759532167893 -122.410007582777 (37.759532167893, -122.410007582777) 2 4 7 28859 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
148664 91605 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 814 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 6 3x3   6007520.10207 2104907.355044 37.7600995328259 -122.417069610712 (37.7600995328259, -122.417069610712) 2 4 7 28859 19
149728 91698 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 143 South Van Ness Ave 1 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
149994 91642 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 5 3x3   6007742.379122 2101613.996265 37.7510692229497 -122.41606762223 (37.7510692229497, -122.41606762223) 2 4 7 28859 19
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
152443 91602 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007474 2105260 37.7610652207705 -122.417254045994 (37.7610652207705, -122.417254045994) 2 4 7 28859 19
153220 241354 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 10 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 6ft   6009719.71418 2105928.26145 37.7630262022081 -122.409534224627 (37.7630262022081, -122.409534224627) 8 4 8 28859 19
153411 241275 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6010636.10474 2101276.89456 37.750305890826 -122.406037027383 (37.750305890826, -122.406037027383) 10 4 7 28859 19
153861 120915 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 499X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     4 3x3   6007431 2106864 37.7654670122947 -122.41751644763 (37.7654670122947, -122.41751644763) 8 4 7 28853 19
153876 241326 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 395 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 Width 3ft   6007429.44982 2107410.61084 37.7669677904545 -122.417560553376 (37.7669677904545, -122.417560553376) 8 4 7 28853 19
155550 91589 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 442 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007397.135958 2107116.333394 37.7661579552478 -122.417651462281 (37.7661579552478, -122.417651462281) 8 4 7 28853 19
157671 91653 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1199 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007683.015377 2102689.848948 37.7540199323813 -122.416349102661 (37.7540199323813, -122.416349102661) 2 4 7 28859 19
157891 241292 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1223 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011155.71596 2102482.72814 37.7536458937577 -122.404325030294 (37.7536458937577, -122.404325030294) 10 4 8 28859 19
158272 91620 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1290 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 9 3x3   6007671.629207 2102150.724826 37.7525389797951 -122.41635029552 (37.7525389797951, -122.41635029552) 2 4 7 28859 19
159489 241280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1334 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010312.03054 2101467.09279 37.7508100021879 -122.40717110848 (37.7508100021879, -122.40717110848) 2 4 7 28859 19
160517 241330 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 335 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007413.91501 2107730.15032 37.7678442967163 -122.417636936423 (37.7678442967163, -122.417636936423) 8 4 7 28853 19
160670 241349 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009630.95541 2105923.95007 37.7630093903014 -122.409840907855 (37.7630093903014, -122.409840907855) 8 4 8 28859 19
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
162673 241334 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 245 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007405.72375 2108268.9659 37.7693232965496 -122.417703464652 (37.7693232965496, -122.417703464652) 8 4 7 28853 19
163045 91611 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1086 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007607.027989 2103338.253155 37.7557960290434 -122.416657816418 (37.7557960290434, -122.416657816418) 2 4 7 28859 19
163539 95622 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 201 Capp St 3 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

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