trees

Custom SQL query returning 66 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
5120 197001 1 123 2 Napoleon St 16 : Tree 2     9 Width 4ft   6013598.90827 2100122.82985 37.7473023413409 -122.395710528743 (37.7473023413409, -122.395710528743) 10 3 8 58 1
11064 196994 1 123 2 Napoleon St 7 : Tree 2     7 Width 4ft   6013884.28274 2100137.93009 37.7473596740254 -122.394724774624 (37.7473596740254, -122.394724774624) 10 3 8 58 1
20599 196997 1 123 2 Napoleon St 11 : Tree 2     7 Width 4ft   6013762.67186 2100131.60985 37.7473355578075 -122.395144856947 (37.7473355578075, -122.395144856947) 10 3 8 58 1
22157 197002 1 123 2251 Silver Ave 3 : Tree 2     6 Width 3ft   6012830.37736 2096288.90355 37.7367324078692 -122.398099143384 (37.7367324078692, -122.398099143384) 10 3 8 58 1
70671 196993 1 123 2 Napoleon St 6 : Tree 2     7 Width 4ft   6013912.09606 2100139.02388 37.7473642236913 -122.394628673985 (37.7473642236913, -122.394628673985) 10 3 8 58 1
88076 196990 1 123 2 Napoleon St 1 : Tree 2     6 Width 4ft   6014143.12746 2100151.41021 37.7474110756645 -122.393830644379 (37.7474110756645, -122.393830644379) 10 3 8 58 1
92182 196991 1 123 2 Napoleon St 2 : Tree 2     5 Width 4ft   6014086.84637 2100149.18925 37.7474018495283 -122.394025106589 (37.7474018495283, -122.394025106589) 10 3 8 58 1
97589 196999 1 123 2 Napoleon St 14 : Tree 2     4 Width 4ft   6013629.21679 2100123.8728 37.7473068910098 -122.395605796394 (37.7473068910098, -122.395605796394) 10 3 8 58 1
121622 197000 1 123 2 Napoleon St 15 : Tree 2     6 Width 4ft   6013614.06576 2100123.51682 37.7473050707808 -122.395658162994 (37.7473050707808, -122.395658162994) 10 3 8 58 1
124135 196995 1 123 2 Napoleon St 8 : Tree 2     8 Width 4ft   6013853.97089 2100136.72086 37.7473546683845 -122.394829506973 (37.7473546683845, -122.394829506973) 10 3 8 58 1
148421 196998 1 123 2 Napoleon St 13 : Tree 2     5 Width 4ft   6013702.50003 2100126.86267 37.7473191766464 -122.395352595851 (37.7473191766464, -122.395352595851) 10 3 8 58 1
184445 196996 1 123 2 Napoleon St 10 : Tree 2     8 Width 4ft   6013793.66265 2100133.46781 37.7473423827584 -122.395037822335 (37.7473423827584, -122.395037822335) 10 3 8 58 1
193907 196992 1 123 2 Napoleon St 5 : Tree 2     7 Width 4ft   6013942.24849 2100140.56785 37.7473701394162 -122.394524516312 (37.7473701394162, -122.394524516312) 10 3 8 58 1
23399 101632 7 123 1585X Jerrold Ave 6 Sidewalk: Curb side : Cutout Tree 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 7 123 1519 Innes Ave   Sidewalk: Curb side : Cutout Tree 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 7 123 4655X 03rd St 3 Sidewalk: Curb side : Cutout Tree 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 7 123 1585X Jerrold Ave 5 Sidewalk: Curb side : Cutout Tree 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 1 123 1683 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree 2     3 3x3   6015409.74359 2097962.08476 37.7414699491892 -122.389297877816 (37.7414699491892, -122.389297877816) 10 3 8 58 1
64144 95296 1 123 4517 03rd St 5 Sidewalk: Curb side : Cutout Tree 1     6 3x3   6015219.41618 2096207.76459 37.7366423919508 -122.389833460403 (37.7366423919508, -122.389833460403) 10 3 8 58 1
64306 22261 7 123 4655X 03rd St 1 Sidewalk: Curb side : Cutout Tree 2     6 3X3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
67071 3776 1 123 6 Carpenter Ct 2 Sidewalk: Curb side : Cutout Tree 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
71003 22267 7 123 4655X 03rd St 7 Sidewalk: Curb side : Cutout Tree 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 7 123 1599@ Lane Revere Ave 2 Sidewalk: Curb side : Cutout Tree 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 7 123 4655X 03rd St 2 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6015123.96867 2095945.95372 37.7359182191114 -122.390145181472 (37.7359182191114, -122.390145181472) 10 3 8 58 1
77304 101627 7 123 1585X Jerrold Ave 1 Sidewalk: Curb side : Cutout Tree 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
85376 85063 7 123 4532 03rd St 1 Sidewalk: Curb side : Cutout Tree 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 7 123 1585X Jerrold Ave 8 Sidewalk: Curb side : Cutout Tree 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 7 123 4655X 03rd St 5 Sidewalk: Curb side : Cutout Tree 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
90252 22222 7 123 4301 03rd St 4 Sidewalk: Curb side : Cutout Tree 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 7 123 4755X 03rd St 1 Sidewalk: Curb side : Cutout Tree 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 7 123 4755X 03rd St 4 Sidewalk: Curb side : Cutout Tree 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 7 123 1585X Jerrold Ave 4 Sidewalk: Curb side : Cutout Tree 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 1 123 4517 03rd St 6 Sidewalk: Curb side : Cutout Tree 1     6 3x3   6015219.41618 2096207.76459 37.7366423919508 -122.389833460403 (37.7366423919508, -122.389833460403) 10 3 8 58 1
102501 22264 7 123 4655X 03rd St 4 Sidewalk: Curb side : Cutout Tree 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 7 123 1585X Jerrold Ave 2 Sidewalk: Curb side : Cutout Tree 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 7 123 1554 Jerrold Ave   Sidewalk: Curb side : Cutout Tree 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 7 123 4445 03rd St 4 Sidewalk: Curb side : Cutout Tree 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
123373 88498 7 123 1599 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 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
124252 88468 7 123 1950 Donner Ave   Sidewalk: Curb side : Cutout Tree 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
132977 101633 7 123 1585X Jerrold Ave 7 Sidewalk: Curb side : Cutout Tree 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 7 123 4445 03rd St 5 Sidewalk: Curb side : Cutout Tree 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 7 123 4416 03rd St 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6015163.3661 2096572.43152 37.7376405844607 -122.390052718455 (37.7376405844607, -122.390052718455) 10 3 8 58 1
148723 22242 7 123 4430 03rd St 1 Sidewalk: Curb side : Cutout Tree 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 1 123 4434 03rd St 1 Sidewalk: Curb side : Cutout Tree 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 7 123 4400 03rd St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015280 2096693 37.737978108932 -122.389657874388 (37.737978108932, -122.389657874388) 10 3 8 58 1
151905 22278 7 123 4755X 03rd St 2 Sidewalk: Curb side : Cutout Tree 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 1 123 4720 03rd St 1 Sidewalk: Curb side : Cutout Tree 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 7 123 4655X 03rd St 6 Sidewalk: Curb side : Cutout Tree 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
170027 22282 7 123 4755X 03rd St 6 Sidewalk: Curb side : Cutout Tree 19     4 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
174039 22279 7 123 4755X 03rd St 3 Sidewalk: Curb side : Cutout Tree 19     6 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
183387 22238 1 123 4420 03rd St 1 Sidewalk: Curb side : Cutout Tree 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
186419 100315 1 123 1683 Galvez Ave 3 Sidewalk: Curb side : Cutout Tree 2     10 3x3   6015443.91077 2097940.33755 37.7414121299803 -122.389178220304 (37.7414121299803, -122.389178220304) 10 3 8 58 1
191217 22252 7 123 4544 03rd St 1 Sidewalk: Curb side : Cutout Tree 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 7 123 1585X Jerrold Ave 3 Sidewalk: Curb side : Cutout Tree 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
61090 104044 1 123 1601X Kansas St 8 Sidewalk: Property side : Cutout Tree 1     70 9x9   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
80922 104045 1 123 1601X Kansas St 7 Sidewalk: Property side : Cutout Tree 1     4 3x6   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
115832 104046 1 123 1601X Kansas St 6 Sidewalk: Property side : Cutout Tree 1     4 3x6   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
125523 104460 1 123 1601X Kansas St 2 Sidewalk: Property side : Cutout Tree 1     4 3x6   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
4592 196983 1 123 1601 Kansas St 2 Sidewalk: Property side : Yard Tree 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1
62748 196988 1 123 1601 Kansas St 8 Sidewalk: Property side : Yard Tree 2     6 Width 5ft   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
111720 196987 1 123 1601 Kansas St 7 Sidewalk: Property side : Yard Tree 2     7 Width 5ft   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
141990 196989 1 123 1601 Kansas St 8 Sidewalk: Property side : Yard Tree 2     6 Width 5ft   6011818.89895 2100809.64818 37.7490890172439 -122.401913980245 (37.7490890172439, -122.401913980245) 10 3 8 58 1
146245 196984 1 123 1601 Kansas St 6 Sidewalk: Property side : Yard Tree 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
168607 196986 1 123 1601 Kansas St 7 Sidewalk: Property side : Yard Tree 2     7 Width 5ft   6011820.27046 2100794.29001 37.7490469235803 -122.40190815805 (37.7490469235803, -122.40190815805) 10 3 8 58 1
170158 196985 1 123 1601 Kansas St 6 Sidewalk: Property side : Yard Tree 2     8 Width 5ft   6011820.47885 2100780.87152 37.7490100909441 -122.401906494295 (37.7490100909441, -122.401906494295) 10 3 8 58 1
176314 196982 1 123 1601 Kansas St 2 Sidewalk: Property side : Yard Tree 2     9 Width 6ft   6011835.24913 2100548.938 37.7483740760146 -122.401839117097 (37.7483740760146, -122.401839117097) 10 3 8 58 1