575 rows where qSpecies_id = 123 sorted by Neighborhoods (old)

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                      
4592 196983 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
5120 197001 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 16 : Tree Private 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1
11064 196994 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 7 : Tree Private 2     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.394724774624 (37.7473596740254, -122.394724774624) 10 3 8 58 1
20599 196997 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 11 : Tree Private 2     7 Width 4ft   6013762.67186 2100131.60985 37.7473355578075 -122.395144856947 (37.7473355578075, -122.395144856947) 10 3 8 58 1
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
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
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
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
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
55570 100314 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1683 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6015409.74359 2097962.08476 37.7414699491892 -122.389297877816 (37.7414699491892, -122.389297877816) 10 3 8 58 1
61090 104044 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 8 Sidewalk: Property side : Cutout Tree DPW 1     70 9x9   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
62748 196988 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
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
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
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
70671 196993 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 6 : Tree Private 2     7 Width 4ft   6013912.09606 2100139.02388 37.7473642236913 -122.394628673985 (37.7473642236913, -122.394628673985) 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
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
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
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
80922 104045 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 7 Sidewalk: Property side : Cutout Tree DPW 1     4 3x6   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 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
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
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
88076 196990 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 1 : Tree Private 2     6 Width 4ft   6014143.12746 2100151.41021 37.7474110756645 -122.393830644379 (37.7474110756645, -122.393830644379) 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
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
92182 196991 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 2 : Tree Private 2     5 Width 4ft   6014086.84637 2100149.18925 37.7474018495283 -122.394025106589 (37.7474018495283, -122.394025106589) 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
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
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
97589 196999 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 14 : Tree Private 2     4 Width 4ft   6013629.21679 2100123.8728 37.7473068910098 -122.395605796394 (37.7473068910098, -122.395605796394) 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
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
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
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
111720 196987 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 7 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
115832 104046 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 6 Sidewalk: Property side : Cutout Tree DPW 1     4 3x6   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
121622 197000 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 15 : Tree Private 2     6 Width 4ft   6013614.06576 2100123.51682 37.7473050707808 -122.395658162994 (37.7473050707808, -122.395658162994) 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
124135 196995 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 8 : Tree Private 2     8 Width 4ft   6013853.97089 2100136.72086 37.7473546683845 -122.394829506973 (37.7473546683845, -122.394829506973) 10 3 8 58 1
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
125523 104460 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601X Kansas St 2 Sidewalk: Property side : Cutout Tree DPW 1     4 3x6   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
132977 101633 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 7 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
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
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
146245 196984 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 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
148421 196998 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 13 : Tree Private 2     5 Width 4ft   6013702.50003 2100126.86267 37.7473191766464 -122.395352595851 (37.7473191766464, -122.395352595851) 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
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
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
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
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
168607 196986 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 7 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 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
170158 196985 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 6 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 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
176314 196982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1601 Kansas St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 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
184445 196996 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 10 : Tree Private 2     8 Width 4ft   6013793.66265 2100133.46781 37.7473423827584 -122.395037822335 (37.7473423827584, -122.395037822335) 10 3 8 58 1
186419 100315 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1683 Galvez Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6015443.91077 2097940.33755 37.7414121299803 -122.389178220304 (37.7414121299803, -122.389178220304) 10 3 8 58 1
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
193442 101629 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1585X Jerrold Ave 3 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
193907 196992 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 2 Napoleon St 5 : Tree Private 2     7 Width 4ft   6013942.24849 2100140.56785 37.7473701394162 -122.394524516312 (37.7473701394162, -122.394524516312) 10 3 8 58 1
21871 246838 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 399 Broderick St 1 : Tree Private 2     5 Width 4ft   6001188.47767 2109990.61312 37.7736986862745 -122.439331993472 (37.7736986862745, -122.439331993472) 15 5 11 29492 10
31202 246856 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 425 Divisadero St 1 : Tree Private 2     4 Width 3ft   6001680.71036 2109929.19364 37.773558043107 -122.437624887779 (37.773558043107, -122.437624887779) 15 5 11 29492 10
46451 87968 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51004 6001204 2110019 37.7737775128473 -122.439280334526 (37.7737775128473, -122.439280334526) 15 5 11 29492 10
56282 87763 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1303 Fell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6001194 2110018 37.7737741980345 -122.439314854348 (37.7737741980345, -122.439314854348) 15 5 11 29492 10
67085 241273 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 55 Haight St 2 : Tree Private 2     3 Width 3ft   6005874.88911 2109629.37494 37.7729723901943 -122.423095264536 (37.7729723901943, -122.423095264536) 7 9 11 28852 10
143335 87451 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 345 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2007 12:00:00 AM 3 3x3   6005911.17036 2110956.31285 37.7766178884522 -122.423064096477 (37.7766178884522, -122.423064096477) 7 9 11 28852 10
162540 87971 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 4 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51004 6001204 2110019 37.7737775128473 -122.439280334526 (37.7737775128473, -122.439280334526) 15 5 11 29492 10
163157 85249 - 12 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1335 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/19/2007 12:00:00 AM 3 3x3 under 3 yr maintenance agreement. expires 7/19/2010 6001350.12437 2111060.02557 37.7766442216524 -122.438849483935 (37.7766442216524, -122.438849483935) 15 5 11 29492 10
173753 87969 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51004 6001204 2110019 37.7737775128473 -122.439280334526 (37.7737775128473, -122.439280334526) 15 5 11 29492 10
180744 87970 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1301 Fell St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51004 6001204 2110019 37.7737775128473 -122.439280334526 (37.7737775128473, -122.439280334526) 15 5 11 29492 10
182299 87977 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1372 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 51013 6001285 2110422 37.7748886587191 -122.43902903105 (37.7748886587191, -122.43902903105) 15 5 11 29492 10
190505 85250 - 12 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1335 Fulton St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/19/2007 12:00:00 AM 15 3x3 under 3yr maintenance agreement. Expires 7/19/2010. 6001350.12437 2111060.02557 37.7766442216524 -122.438849483935 (37.7766442216524, -122.438849483935) 15 5 11 29492 10
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
5657 41933 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 610 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 6   Permit Number 42292 5994729.71498 2111330.05881 37.7770067806052 -122.461770835952 (37.7770067806052, -122.461770835952) 11 6 2 54 11
23653 90897 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1145 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5992033.67177 2110642.90774 37.7749644818454 -122.471047125233 (37.7749644818454, -122.471047125233) 11 6 2 54 11
27091 90555 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2008 12:00:00 AM 3 3x3   5992035.9437 2110699.81053 37.7751208528883 -122.471043412514 (37.7751208528883, -122.471043412514) 11 6 2 54 11
34046 31982 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 232 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 12 3x3 Permit Number 35382 5994946.26899 2113981.48738 37.7842993574965 -122.461213955921 (37.7842993574965, -122.461213955921) 11 6 2 54 11
38813 90554 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1150 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/14/2008 12:00:00 AM 3 3x3   5992007.5751 2110699.64473 37.7751187568292 -122.471141532792 (37.7751187568292, -122.471141532792) 11 6 2 54 11
39857 8913 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 4455X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5993194.92162 2112721.50101 37.7807388335807 -122.467181309852 (37.7807388335807, -122.467181309852) 11 6 2 54 11
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
61838 90896 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 1145 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 3x3   5992053.33041 2110644.47867 37.7749699321879 -122.47097923688 (37.7749699321879, -122.47097923688) 11 6 2 54 11
64123 123208 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5993131.19371 2112699.04699 37.7806735020779 -122.467400140372 (37.7806735020779, -122.467400140372) 11 6 2 54 11
74281 34259 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 164 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 12   Permit Number 39598 5993996.78061 2114472.4725 37.7855927810379 -122.464534489449 (37.7855927810379, -122.464534489449) 11 6 1 54 11
76553 123210 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993133.98431 2112655.94122 37.7805553064396 -122.467387351051 (37.7805553064396, -122.467387351051) 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
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
101968 41934 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 615 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 5   Permit Number 42293 5994683.51563 2111320.01316 37.7769765383201 -122.461929924013 (37.7769765383201, -122.461929924013) 11 6 2 54 11
103672 36967 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 381 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 9   Permit Number 39594 5994314.22367 2112999.17695 37.7815658043957 -122.463329288102 (37.7815658043957, -122.463329288102) 11 6 2 54 11
113993 36966 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 381 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM 7   Permit Number 39594 5994314.52093 2112981.13075 37.7815162715185 -122.463326949801 (37.7815162715185, -122.463326949801) 11 6 2 54 11
116652 123211 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 400 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993134.492 2112639.50466 37.7805102054167 -122.467384399185 (37.7805102054167, -122.467384399185) 11 6 2 54 11
116896 124090 DPW Maintained 1 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 601 Funston Ave 5 Sidewalk: Property side : Yard Tree Private 2     12     5991893.39709 2111137.10441 37.7763132974782 -122.471568380763 (37.7763132974782, -122.471568380763) 11 6 2 54 11

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