trees

575 rows where qSpecies_id = 123 sorted by qAddress descending

✎ View and edit SQL

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)
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
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
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
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
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
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
176816 91702 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 1 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
146243 88019 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 926 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/2008 12:00:00 AM   3x3 Permit Number 51046 6007429 2114473 37.7863593952456 -122.418062835651 (37.7863593952456, -122.418062835651) 13 9 9 28858 36
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
73623 247601 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 6 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6009211.63365 2096404.06359 37.7368463915456 -122.410618895163 (37.7368463915456, -122.410618895163) 10 7 7 28859 2
141436 247600 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6009197.59612 2096407.47189 37.7368549629719 -122.410667669902 (37.7368549629719, -122.410667669902) 10 7 7 28859 2
143795 247599 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Tompkins Ave 4 Sidewalk: Property side : Yard Tree Private 2     11 Width 10ft   6009183.00439 2096409.33052 37.7368592482464 -122.410718251366 (37.7368592482464, -122.410718251366) 10 7 7 28859 2
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
4053 196973 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2019 12:00:00 AM 3 Width 4ft   6014457.83967 2102608.37301 37.7541748588033 -122.392914253189 (37.7541748588033, -122.392914253189) 10 3 8 28856 29
53461 196972 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6014458.90845 2102627.41024 37.7542271903342 -122.392911888877 (37.7542271903342, -122.392911888877) 10 3 8 28856 29
60153 34963 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1997 12:00:00 AM 13   Permit Number 38553 6014444.86373 2102867.97159 37.7548869402077 -122.392977289379 (37.7548869402077, -122.392977289379) 10 3 8 28856 29
89090 34965 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 900 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1997 12:00:00 AM 12   Permit Number 38553 6014443.03671 2102833.9751 37.7547934916369 -122.392981229311 (37.7547934916369, -122.392981229311) 10 3 8 28856 29
39809 88509 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 896 Darien Way 4 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
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
66880 88511 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 896 Darien Way 6 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
71898 88508 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 896 Darien Way 3 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
96159 88510 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 896 Darien Way 5 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
180009 88506 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 896 Darien Way   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
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
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
26140 136187 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 840 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010038.55828 2116686.60963 37.7925839636381 -122.409190650353 (37.7925839636381, -122.409190650353) 3 1 10 28857 4
96568 88524 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 840 Powell St   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51456 6010045 2116631 37.7924316339339 -122.409164435867 (37.7924316339339, -122.409164435867) 3 1 10 28857 4
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
170208 91664 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 815 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 3 3x3   6007560.040875 2104909.5668 37.7601078524477 -122.4169316378 (37.7601078524477, -122.4169316378) 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
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
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
39352 136186 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010043.14101 2116645.97985 37.7924726608324 -122.40917192557 (37.7924726608324, -122.40917192557) 3 1 10 28857 4
45296 38903 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1998 12:00:00 AM 3   Permit Number 40882 6010050.21943 2116612.32864 37.7923806592989 -122.409145058308 (37.7923806592989, -122.409145058308) 3 1 10 28857 4
92775 136185 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010045.72464 2116634.21167 37.7924404929984 -122.409162155311 (37.7924404929984, -122.409162155311) 3 1 10 28857 4
147702 38904 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1998 12:00:00 AM 6   Permit Number 40717 6010047.86641 2116623.85793 37.7924121841197 -122.409154013767 (37.7924121841197, -122.409154013767) 3 1 10 28857 4
182003 39270 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 800 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1998 12:00:00 AM 3   Permit Number 40882 6010056.25648 2116573.77784 37.7922751463304 -122.409121448409 (37.7922751463304, -122.409121448409) 3 1 10 28857 4
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
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
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
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
193505 91666 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 793 South Van Ness Ave 1 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
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
13645 70110 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 79 Stoneyford Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6006114.15907 2093862.38939 37.7296933683514 -122.421147824905 (37.7296933683514, -122.421147824905) 9 7 7 28861 5
75224 52663 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 772 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM 4 3x3 Permit Number 50440 6001423.61779826 2102059.9147838 37.7519363103852 -122.437950438082 (37.7519363103852, -122.437950438082) 2 4 5 28862 22
130878 123179 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 771 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992862.96444 2110216.56004 37.7738417753505 -122.468147428182 (37.7738417753505, -122.468147428182) 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
92525 88014 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 1 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
174823 88016 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 77 McAllister St 3 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
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
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
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
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
599 78256 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 754 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6002680.72455 2088998.08405 37.7161429170478 -122.432670234864 (37.7161429170478, -122.432670234864) 9 7 6 28861 5
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
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
168558 241302 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 741 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007545.5728 2105350.70249 37.7613182952255 -122.417012932805 (37.7613182952255, -122.417012932805) 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
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
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
97888 37999 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 725 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40211 6012746.31439 2104130.05474 37.7582578483487 -122.398939962714 (37.7582578483487, -122.398939962714) 10 3 8 28856 29
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
177426 241314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 722 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007476.75646 2105385.74126 37.7614106322283 -122.417253423206 (37.7614106322283, -122.417253423206) 2 4 7 28859 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
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
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
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
178993 179276 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 716 Peru Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6005258.78381 2092467.95462 37.7258162992748 -122.424005829932 (37.7258162992748, -122.424005829932) 9 7 6 309 5
193441 179277 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 716 Peru Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6005276.23831 2092458.42558 37.7257911200544 -122.423944813618 (37.7257911200544, -122.423944813618) 9 7 6 309 5
93244 86800 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 71 Miguel St   Sidewalk: Curb side : Cutout Tree Private 2   10/09/2007 12:00:00 AM   3x3 Permit Number 49752 6003860 2097292 37.7389829690297 -122.429185143196 (37.7389829690297, -122.429185143196) 2 7 5 63 7
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
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
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
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
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
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
91782 88337 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 686 Naples St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51324 6002465 2089669 37.7179728672328 -122.433463798527 (37.7179728672328, -122.433463798527) 9 7 6 28861 5
172506 88317 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 670 Edinburg St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51308 6002238.5 2089937.8 37.7186980790536 -122.434265915388 (37.7186980790536, -122.434265915388) 9 7 6 28861 5
190579 241272 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 67 Webster St 1 : Tree Private 2     13 Width 4ft   6004275.92505 2108860.93687 37.7707720854826 -122.428571490982 (37.7707720854826, -122.428571490982) 7 9 11 29492 10
100139 67314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 666 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1992 12:00:00 AM 7   Permit Number 30795 5992883.6827 2110925.23066 37.77578879069 -122.468127322089 (37.77578879069, -122.468127322089) 11 6 2 54 11
47551 84204 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
61889 84203 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
80433 84200 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 11 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
145828 84205 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
152881 84199 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
161073 84202 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 9 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
164480 84201 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 10 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
172942 84198 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 655 Sunnydale Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50698 6009691.88445474 2086493.84620901 37.7096619192865 -122.408259684415 (37.7096619192865, -122.408259684415) 9 7 8 309 39
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
87429 41913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 642 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 8   Permit Number 42274 5992259.32657 2111046.49076 37.7760856603427 -122.470295940533 (37.7760856603427, -122.470295940533) 11 6 2 54 11
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
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
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
177005 91676 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 629 South Van Ness Ave   Sidewalk: Curb side : Cutout Tree DPW 1   03/01/2007 12:00:00 AM 8 3x3   6007499.688693 2105999.37525 37.7630968189144 -122.417217594449 (37.7630968189144, -122.417217594449) 8 4 7 28859 19
60565 79256 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 627 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/16/2008 12:00:00 AM   3x3 Permit Number 50884 5996581.50943321 2107294.3742688 37.7660322643278 -122.455073251071 (37.7660322643278, -122.455073251071) 15 5 11 29492 12
157957 88525 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 626x Funston Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51466 5991969.3 2111151 37.7763558419216 -122.471306826694 (37.7763558419216, -122.471306826694) 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
153745 83991 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 62 Woodland Ave 1 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

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