575 rows where qSpecies_id = 123 sorted by YCoord

View and edit SQL

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)
6080 19758 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY15 16 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
9823 19923 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY37 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
15070 19922 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 100 STAIRWAY37 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 20ST                      
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
125579 62067 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 240 Leland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50979 6009906.39574025 2087592.17070432 37.7126897048858 -122.40759567922 (37.7126897048858, -122.40759567922) 9 7 8 309 39
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
101659 87845 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 6 Minerva St   Sidewalk: Curb side : Cutout Tree Private 2   06/10/2008 12:00:00 AM   3x3 Permit Number 50752 5996525.4 2089078.3 37.7160121664781 -122.453951648081 (37.7160121664781, -122.453951648081) 9 8 6 28861 24
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
151959 81505 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 30 Lee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2007 12:00:00 AM   3x3 Permit Number 49730 5996533.25550088 2090072.07142613 37.7187412808671 -122.453996225339 (37.7187412808671, -122.453996225339) 9 8 6 28861 24
84189 83512 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 271 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2007 12:00:00 AM   3x3 Permit Number 49725 5994714.51593994 2090381.39140811 37.719486148882 -122.460305233079 (37.719486148882, -122.460305233079) 9 8 6 28861 24
32350 84048 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1006 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2007 12:00:00 AM   3x3 Permit Number 49723 5995065.73258922 2090627.8481306 37.7201830572422 -122.459109050516 (37.7201830572422, -122.459109050516) 9 8 6 28861 24
16550 88330 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 544 London St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51318 6001416.8 2090660.3 37.7206352284922 -122.437157897339 (37.7206352284922, -122.437157897339) 9 7 6 28861 5
88850 88346 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 351 Vienna St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51331 6003903 2091384 37.7227633616233 -122.428615443614 (37.7227633616233, -122.428615443614) 9 7 6 28861 5
69913 81225 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 225 Jules Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2007 12:00:00 AM   3x3 Permit Number 49728 5994438.42452426 2091412.78636228 37.7223022264954 -122.461334300987 (37.7223022264954, -122.461334300987) 9 8 4 28861 24
6926 96580 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 5 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
23905 96578 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 8 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
31248 96579 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 4 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
166189 96581 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
172028 96582 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 7 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
180230 96584 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 401x Otsego Ave 9 Sidewalk: Curb side : Cutout Tree SFUSD 4   05/14/2011 12:00:00 AM   3x3   6000208.5 2091425.4 37.7226672598955 -122.441389471398 (37.7226672598955, -122.441389471398) 9 7 6 28861 25
115556 50665 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2004 12:00:00 AM 5   Permit Number 47244 6000927.33064 2091848.93503 37.7238711151562 -122.438934974279 (37.7238711151562, -122.438934974279) 9 7 6 28861 25
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
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
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
171562 88315 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 157 Edinburg St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51306 6004192.4 2092727.9 37.7264697879052 -122.427710754996 (37.7264697879052, -122.427710754996) 9 7 6 28861 5
103146 49557 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 62 Arco Way 1 Sidewalk: Curb side : Cutout Tree Private 2   05/05/2003 12:00:00 AM 7   Permit Number 46446 5999409.77309 2093045.09949 37.7270690458815 -122.444266822659 (37.7270690458815, -122.444266822659) 9 7 6 28861 25
40738 100424 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 200X Stonecrest Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
60226 100425 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 200X Stonecrest Dr 2 Sidewalk: Property side : Cutout Tree Private 2       3x6   5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
86529 179278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 223 Pioche St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006228.66725 2093396.90262 37.7284216981869 -122.420718924746 (37.7284216981869, -122.420718924746) 9 7 7 309 5
170652 179279 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 223 Pioche St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6006275.12702 2093408.77207 37.7284569075468 -122.420559152977 (37.7284569075468, -122.420559152977) 9 7 7 309 5
132731 26278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1828 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/08/1998 12:00:00 AM 3     6000476.90225 2093497.19967 37.7283712336437 -122.440610195428 (37.7283712336437, -122.440610195428) 9 7 6 28861 25
124252 88468 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1950 Donner Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51422 6011569.2 2093583.7 37.7292341601061 -122.402269464083 (37.7292341601061, -122.402269464083) 10 3 8 58 1
51900 40680 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 227 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1999 12:00:00 AM 11   Permit Number 41663 6004891.01488 2093810.36977 37.7294815042584 -122.425372669006 (37.7294815042584, -122.425372669006) 9 7 6 28861 5
60418 88523 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 10 Valdez Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51454 5996417 2093827.6 37.7290464055545 -122.454669245202 (37.7290464055545, -122.454669245202) 9 7 4 28861 40
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
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
74147 88499 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1599@ Lane Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51438 6015105.8 2094319.6 37.7314515735977 -122.39009441777 (37.7314515735977, -122.39009441777) 10 3 8 58 1
123373 88498 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1599 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51438 6015105.8 2094319.6 37.7314515735977 -122.39009441777 (37.7314515735977, -122.39009441777) 10 3 8 58 1
97177 82510 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 162 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM 5 3x3 Permit Number 52478 6009746.4088 2094920.98232 37.7328041358849 -122.408665340153 (37.7328041358849, -122.408665340153) 10 3 7 309 28
193922 179281 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010435.48171 2094947.68687 37.7329160304499 -122.406284910247 (37.7329160304499, -122.406284910247) 10 3 7 309 28
60643 89323 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 18 Hale St   Sidewalk: Curb side : Cutout Tree Private 2   11/04/2008 12:00:00 AM   3x3 Permit Number 51913 6010478.7 2094954.8 37.7329379790561 -122.406135993698 (37.7329379790561, -122.406135993698) 10 3 7 309 28
16220 179280 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010456.33755 2094955.50587 37.7329386663832 -122.406213356571 (37.7329386663832, -122.406213356571) 10 3 7 309 28
109700 89324 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 16 Hale St   Sidewalk: Curb side : Cutout Tree Private 2   11/04/2008 12:00:00 AM   3x3 Permit Number 51914 6010434.1 2094994.4 37.7330442175155 -122.40629297735 (37.7330442175155, -122.40629297735) 10 3 7 309 28
121788 213854 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 494 Mangels Ave 4 Sidewalk: Property side : Yard Tree Private 2     15     5998170.4747 2095280.37565 37.7331358031646 -122.448711968308 (37.7331358031646, -122.448711968308) 9 7 4 59 40
67071 3776 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 6 Carpenter Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6016649.2597904 2095536.4485417 37.7348782815847 -122.38484307413 (37.7348782815847, -122.38484307413) 10 3 8 58 1
91890 22277 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 1 Sidewalk: Curb side : Cutout Tree Arts Commission 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
93143 22280 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 4 Sidewalk: Curb side : Cutout Tree Arts Commission 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
151905 22278 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 2 Sidewalk: Curb side : Cutout Tree Arts Commission 19   01/31/1992 12:00:00 AM 6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
170027 22282 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 6 Sidewalk: Curb side : Cutout Tree Arts Commission 19     4 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
174039 22279 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4755X 03rd St 3 Sidewalk: Curb side : Cutout Tree Arts Commission 19     6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
162699 22272 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4720 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/03/1995 12:00:00 AM 6 3x3   6014914.77079 2095774.79236 37.7354366396256 -122.390856509346 (37.7354366396256, -122.390856509346) 10 3 8 58 1
144328 88018 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3926 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51046 6004957.7 2095821.3 37.7350068377073 -122.425285172259 (37.7350068377073, -122.425285172259) 2 7 5 28861 2
38784 22263 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1997 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
64306 22261 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
71003 22267 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
76848 22262 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
86818 22265 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1998 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
102501 22264 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
163314 22266 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4655X 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM 6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
98123 241389 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 47 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6002625.89983 2096003.53123 37.7353751906151 -122.43336004273 (37.7353751906151, -122.43336004273) 2 7 5 63 7
20731 63489 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 319 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50934 6006645.5795298 2096080.30995427 37.7358132351331 -122.419467931102 (37.7358132351331, -122.419467931102) 2 7 7 28859 2
64144 95296 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4517 03rd St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6015219.41618 2096207.76459 37.7366423919508 -122.389833460403 (37.7366423919508, -122.389833460403) 10 3 8 58 1
94686 95297 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4517 03rd St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6015219.41618 2096207.76459 37.7366423919508 -122.389833460403 (37.7366423919508, -122.389833460403) 10 3 8 58 1
27312 88136 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 321 Los Palmos Dr   Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51162 5997690 2096237 37.7357349780848 -122.450442028597 (37.7357349780848, -122.450442028597) 9 7 4 59 40
191217 22252 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4544 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/1993 12:00:00 AM 6 3x3   6015060.7997 2096239.5516 37.7367208751663 -122.390384090827 (37.7367208751663, -122.390384090827) 10 3 8 58 1
39070 241380 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4050 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008348.5979 2096262.44881 37.7364091240834 -122.413592786804 (37.7364091240834, -122.413592786804) 10 7 7 28859 2
22157 197002 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2251 Silver Ave 3 : Tree Private 2     6 Width 3ft   6012830.37736 2096288.90355 37.7367324078692 -122.398099143384 (37.7367324078692, -122.398099143384) 10 3 8 58 1
85376 85063 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4532 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/29/2007 12:00:00 AM 3 3x3   6015094.5224 2096297.78902 37.7368826538298 -122.390271563398 (37.7368826538298, -122.390271563398) 10 3 8 58 1
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
111608 22240 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4445 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2010 12:00:00 AM 3 3X3   6015309.22014 2096468.43632 37.7373631231169 -122.389541166269 (37.7373631231169, -122.389541166269) 10 3 8 58 1
136365 22239 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4445 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1995 12:00:00 AM 3 3X3   6015309.22014 2096468.43632 37.7373631231169 -122.389541166269 (37.7373631231169, -122.389541166269) 10 3 8 58 1
148392 95290 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4416 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
148723 22242 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4430 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1995 12:00:00 AM 6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
148991 22243 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4434 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/19/1993 12:00:00 AM 6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
183387 22238 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4420 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/19/1993 12:00:00 AM 6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
149067 95289 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4400 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015280 2096693 37.737978108932 -122.389657874388 (37.737978108932, -122.389657874388) 10 3 8 58 1
105176 88473 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1554 Jerrold Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51426 6015626.2 2096846 37.7384174065816 -122.388471555996 (37.7384174065816, -122.388471555996) 10 3 8 58 1
90252 22222 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4301 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM 3 3x3 Permit Number 768640 6015412.92695 2096851.83844 37.7384216168093 -122.389209364399 (37.7384216168093, -122.389209364399) 10 3 8 58 1
35315 88470 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1519 Innes Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51424 6015916 2096861 37.7384746486807 -122.387470605672 (37.7384746486807, -122.387470605672) 10 3 8 58 1
23399 101632 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1
46025 101631 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1
77304 101627 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1
86262 101634 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1
93279 101630 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2015 12:00:00 AM 3 3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1
104346 101628 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/05/2012 12:00:00 AM   3x3 Permit Number 768640 6015457.6 2096890.8 37.7385310737434 -122.389057624952 (37.7385310737434, -122.389057624952) 10 3 8 58 1

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