trees

575 rows where qSpecies_id = 123 sorted by XCoord 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)
141990 196989 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 8 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
49759 88162 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 365 Clementina St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51185 6011732.3 2112447.5 37.7810391100489 -122.40303190845 (37.7810391100489, -122.40303190845) 6 2 9 28853 34
94675 35355 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1315 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 12   Permit Number 38817 6011731.8197 2102219.99473 37.7529566614441 -122.402314252327 (37.7529566614441, -122.402314252327) 10 3 8 28856 29
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
176344 88191 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 355 Tehama St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51196 6011553 2112651 37.7815878594503 -122.403666522452 (37.7815878594503, -122.403666522452) 6 2 9 28853 34
8545 241289 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 9ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
10563 220139 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 4 Sidewalk: Property side : Yard Tree Private 2     4 Width 5ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
13557 220140 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 7ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
16388 241286 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
19316 241287 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1383 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6011483 2102064 37.7525144414714 -122.403163750863 (37.7525144414714, -122.403163750863) 10 4 8 28859 19
187496 241285 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 7 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011473.17853 2101977.48291 37.75227633599 -122.403191629999 (37.75227633599, -122.403191629999) 10 4 8 28859 19
18173 241284 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 6ft   6011470.02474 2101959.91095 37.7522279111039 -122.403201300403 (37.7522279111039, -122.403201300403) 10 4 8 28859 19
22119 241283 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011469.09548 2101944.76887 37.7521862823701 -122.403203448894 (37.7521862823701, -122.403203448894) 10 4 8 28859 19
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
42648 241281 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 6ft   6011465.9993 2101906.42682 37.7520808305785 -122.403211459137 (37.7520808305785, -122.403211459137) 10 4 8 28859 19
54319 241288 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1201 Vermont St 16 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   6011465.27105 2102063.55943 37.7525122416483 -122.403225029932 (37.7525122416483, -122.403225029932) 10 4 8 28859 19
24305 31508 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2419 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 13   Permit Number 35068 6011299.52328 2102275.53688 37.7530850270762 -122.403813131691 (37.7530850270762, -122.403813131691) 10 4 8 28859 19
119219 88203 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 436 Clementina St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51208 6011221 2112104 37.7800673738175 -122.40477656867 (37.7800673738175, -122.40477656867) 14 2 9 28853 34
67242 241290 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1227 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011160.10458 2102427.21865 37.753493722159 -122.404305946667 (37.753493722159, -122.404305946667) 10 4 8 28859 19
25076 241291 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1225 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6011156.6405 2102469.67171 37.7536100953402 -122.404320914102 (37.7536100953402, -122.404320914102) 10 4 8 28859 19
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
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
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
57071 31514 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2537 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/1995 12:00:00 AM 13   Permit Number 35072 6010934.2499 2102257.13766 37.7530140939364 -122.405075029795 (37.7530140939364, -122.405075029795) 10 4 8 28859 19
161656 88185 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 493 Clementina St   Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51192 6010910.3 2111721.3 37.7789991980081 -122.405824460674 (37.7789991980081, -122.405824460674) 14 2 9 28853 34
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
51857 241278 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 16 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010738.66995 2101021.37362 37.7496100223844 -122.405664352824 (37.7496100223844, -122.405664352824) 10 4 7 28859 19
78586 241277 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 15 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010729.0783 2101044.09639 37.749671877762 -122.405699121544 (37.749671877762, -122.405699121544) 10 4 7 28859 19
14811 241276 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1400 Potrero Ave 13 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010713.5875 2101085.71194 37.7497852786664 -122.405755620526 (37.7497852786664, -122.405755620526) 10 4 7 28859 19
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
4814 72022 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 550 Stockton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6010599.26481 2116134.30998 37.7910988780658 -122.407211626534 (37.7910988780658, -122.407211626534) 5 1 10 28857 6
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
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
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
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
54649 241274 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2616 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6010311.63301 2104008.02665 37.7577868194278 -122.407351591615 (37.7577868194278, -122.407351591615) 10 4 7 28859 19
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
30264 241366 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1399 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010111.5288 2101104.25474 37.7498025060946 -122.40783888207 (37.7498025060946, -122.40783888207) 2 4 7 28859 19
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
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
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
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
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
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
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
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
72441 82759 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 49 Samoset St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2008 12:00:00 AM   3x3 Permit Number 50251 6009929.1659667 2099164.47966506 37.744466098795 -122.408332701789 (37.744466098795, -122.408332701789) 2 7 7 28859 2
131374 82729 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 49 Samoset St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/11/2008 12:00:00 AM   3x3 Permit Number 50251 6009929.1659667 2099164.47966506 37.744466098795 -122.408332701789 (37.744466098795, -122.408332701789) 2 7 7 28859 2
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
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
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
75650 241361 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 608 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009795.10344 2105420.22693 37.7616354789124 -122.409237625525 (37.7616354789124, -122.409237625525) 2 4 8 28859 19
82690 241362 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009794.30933 2105409.48411 37.7616059370772 -122.409239613928 (37.7616059370772, -122.409239613928) 2 4 8 28859 19
86392 241360 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 600 York St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009793.68997 2105435.76266 37.7616780573116 -122.409243610512 (37.7616780573116, -122.409243610512) 2 4 8 28859 19
21100 241341 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009762.27519 2105459.58065 37.7617416960496 -122.409353942929 (37.7617416960496, -122.409353942929) 2 4 8 28859 19
83333 196981 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2460 Alameda St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009761.09751 2107855.1809 37.7683194004524 -122.409527097504 (37.7683194004524, -122.409527097504) 8 4 8 28853 19
81234 241340 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2701 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009746.5481 2105459.14432 37.7617396168174 -122.409408306065 (37.7617396168174, -122.409408306065) 2 4 8 28859 19
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
65987 87988 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
87658 87989 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
119445 87990 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 233 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2008 12:00:00 AM   3x3 Permit Number 51028 6009741 2113986 37.785152065252 -122.410029478455 (37.785152065252, -122.410029478455) 14 10 9 28852 36
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
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
176637 241338 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2709 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009715.56008 2105456.2423 37.7617299122363 -122.409515276828 (37.7617299122363, -122.409515276828) 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
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
175714 241337 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2711 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009686.38177 2105455.07073 37.761725060389 -122.409616110618 (37.761725060389, -122.409616110618) 2 4 8 28859 19
43080 241352 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009685.74216 2105928.63246 37.7630253172965 -122.409651748936 (37.7630253172965, -122.409651748936) 8 4 8 28859 19
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
16406 241355 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2970 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009659.81185 2101050.9246 37.7496307742409 -122.409397182327 (37.7496307742409, -122.409397182327) 2 4 7 28859 19
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
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
37335 241348 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009609.90256 2105923.09061 37.7630058505491 -122.409913662092 (37.7630058505491, -122.409913662092) 8 4 8 28859 19
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
16583 241346 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   6009581.66758 2105919.15522 37.7629934624139 -122.410011039795 (37.7629934624139, -122.410011039795) 8 4 8 28859 19
36145 241371 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2865 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6009580.01982 2102754.75587 37.7543046444459 -122.40979336069 (37.7543046444459, -122.40979336069) 2 4 7 28859 19
87745 241345 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2601 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   6009569.08803 2105916.84613 37.7629864171226 -122.410054385304 (37.7629864171226, -122.410054385304) 8 4 8 28859 19
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
81519 32351 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/03/1996 12:00:00 AM 9   Permit Number 36907 6009560.84271 2104624.99701 37.7594388308635 -122.409991700751 (37.7594388308635, -122.409991700751) 2 4 7 28859 19
186656 241344 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2180 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009557.96176 2104644.45965 37.7594921093986 -122.410003038507 (37.7594921093986, -122.410003038507) 2 4 7 28859 19
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
190029 241343 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2170 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009555.07772 2104672.73912 37.7595695967776 -122.410015009398 (37.7595695967776, -122.410015009398) 2 4 7 28859 19
15698 241342 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2122 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6009546.72381 2104789.44467 37.7598895755605 -122.410052140597 (37.7598895755605, -122.410052140597) 2 4 7 28859 19
32834 241370 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2877 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 7ft   6009531.75591 2102750.92335 37.7542914163323 -122.409959999651 (37.7542914163323, -122.409959999651) 2 4 7 28859 19
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
68023 241368 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2879 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009498.83241 2102749.66821 37.75428612472 -122.410073769282 (37.75428612472, -122.410073769282) 2 4 7 28859 19
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
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
9813 201661 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 149 Dore St 1 : Tree Private 2     3 Width 2ft   6009207.44548 2109499.94346 37.7728044975557 -122.411558355748 (37.7728044975557, -122.411558355748) 8 2 9 28853 34
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
74691 52826 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 3063 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/30/2009 12:00:00 AM   3x3 Permit Number 52281 6009164.51309648 2101559.46503951 37.7509993493006 -122.411145866905 (37.7509993493006, -122.411145866905) 2 4 7 28859 19

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