trees

Custom SQL query returning 33 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
26145 258009 1 97 380 Ivy St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005531 2111189 37.7772353303506 -122.424395772149 (37.7772353303506, -122.424395772149) 7 9 11 28852 10
32878 12244 1 97 401X Oak St 1 Sidewalk: Curb side : Cutout Tree 1     30 3X3   6005028.53136 2110211.81183 37.7745238232573 -122.426064391571 (37.7745238232573, -122.426064391571) 7 9 11 28852 10
69321 16914 1 97 483 Oak St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6004697.20239 2110157.08412 37.7743548226588 -122.427206624104 (37.7743548226588, -122.427206624104) 7 9 11 28852 10
131474 16900 1 97 409 Oak St 1 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6005007.3916 2110203.70331 37.7745003644325 -122.426136940772 (37.7745003644325, -122.426136940772) 7 9 11 28852 10
185038 111900 1 97 650X Fillmore St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 07/05/2016 12:00:00 AM 3     6003603.61647971 2110556.18401653 37.7753887478808 -122.431018029936 (37.7753887478808, -122.431018029936) 7 9 11 29492 10
36000 104437 4 97 534 Octavia St 1 Sidewalk: Curb side : Cutout Tree 2           6005464 2111103 37.7769954116482 -122.424621427703 (37.7769954116482, -122.424621427703) 7 9 11 28852 10
6180 33653 7 97 284 Linden St 3 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM     Permit Number 37742 6006036.93235026 2110918.36759919 37.776520795938 -122.422626351394 (37.776520795938, -122.422626351394) 7 9 11 28852 10
6344 33663 7 97 424 Ivy St 1 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM     Permit Number 37751 6005309.8782552 2111164.52643651 37.7771556428857 -122.425158961888 (37.7771556428857, -122.425158961888) 7 9 11 28852 10
10493 59647 7 97 100 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/05/1987 12:00:00 AM   6x9 Permit Number 24228 6003848.70238053 2108788.55742661 37.7705491626589 -122.43004409806 (37.7705491626589, -122.43004409806) 7 9 11 29492 10
11946 33634 7 97 416 Linden St 2 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM     Permit Number 37730 6005394.17412308 2110828.6660173 37.7762382136369 -122.424843455434 (37.7762382136369, -122.424843455434) 7 9 11 28852 10
28013 33609 7 97 308 Lily St 1 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37721 6005048.76551317 2110086.28535746 37.7741803016618 -122.425985460117 (37.7741803016618, -122.425985460117) 7 9 11 28852 10
40736 33615 7 97 312 Lily St 2 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37724 6005030.32834442 2110083.71933458 37.7741722139784 -122.4260490549 (37.7741722139784, -122.4260490549) 7 9 11 28852 10
41759 30892 7 97 412 Hayes St 6 Sidewalk: Curb side : Cutout Tree 2   03/08/1995 12:00:00 AM     Permit Number 34719 6005865.19335847 2111068.58127823 37.7769235557198 -122.423231126893 (37.7769235557198, -122.423231126893) 7 9 11 28852 10
49673 66438 7 97 650X Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/11/1991 12:00:00 AM     Permit Number 29582 6003603.61647971 2110556.18401653 37.7753887478808 -122.431018029936 (37.7753887478808, -122.431018029936) 7 9 11 29492 10
73528 59961 7 97 444 Grove St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/19/1981 12:00:00 AM     Permit Number 19440 6005671.77527769 2111387.84010103 37.7777892453109 -122.4239229277 (37.7777892453109, -122.4239229277) 7 9 11 28852 10
77743 31350 7 97 843 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/12/1995 12:00:00 AM     Permit Number 34960 6003828.78534548 2110731.50789971 37.7758829003399 -122.430251629227 (37.7758829003399, -122.430251629227) 7 9 11 29492 10
78099 66375 7 97 612 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29499 6003620.76837837 2110432.17499844 37.7750492215662 -122.430949845165 (37.7750492215662, -122.430949845165) 7 9 11 29492 10
83608 59954 7 97 559 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/19/1981 12:00:00 AM     Permit Number 19431 6005185.88290556 2110921.14903305 37.7764803824816 -122.42557057591 (37.7764803824816, -122.42557057591) 7 9 11 28852 10
86490 66119 7 97 223 Lily St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29179 6005470.38749546 2110092.46405208 37.7742210861409 -122.424527432779 (37.7742210861409, -122.424527432779) 7 9 11 28852 10
92545 66374 7 97 600 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/04/1991 12:00:00 AM     Permit Number 29498 6003626.18476729 2110393.01425684 37.7749420027203 -122.430928313262 (37.7749420027203, -122.430928313262) 7 9 11 29492 10
108948 30891 7 97 412 Hayes St 5 Sidewalk: Curb side : Cutout Tree 2   03/08/1995 12:00:00 AM     Permit Number 34719 6005865.19335847 2111068.58127823 37.7769235557198 -122.423231126893 (37.7769235557198, -122.423231126893) 7 9 11 28852 10
118167 33695 7 97 415 Ivy St 1 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM     Permit Number 37766 6005362.72010447 2111119.40531281 37.7770347362587 -122.42497295397 (37.7770347362587, -122.42497295397) 7 9 11 28852 10
123850 33611 7 97 310 Lily St 2 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37722 6005039.5469288 2110085.00234602 37.7741762578244 -122.42601725751 (37.7741762578244, -122.42601725751) 7 9 11 28852 10
132088 33651 7 97 284 Linden St 2 Sidewalk: Curb side : Cutout Tree 2   12/03/1996 12:00:00 AM     Permit Number 37742 6006036.93235026 2110918.36759919 37.776520795938 -122.422626351394 (37.776520795938, -122.422626351394) 7 9 11 28852 10
140818 65399 7 97 471 Ellis St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/02/1989 12:00:00 AM     Permit Number 28247 6008612.45505665 2113822.69504434 37.7846403524021 -122.41392234969 (37.7846403524021, -122.41392234969) 7 10 9 28852 36
143659 33610 7 97 308 Lily St 2 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37721 6005048.76551317 2110086.28535746 37.7741803016618 -122.425985460117 (37.7741803016618, -122.425985460117) 7 9 11 28852 10
148185 33613 7 97 386 Lily St 1 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37723 6004689.24070975 2110036.24790961 37.7740225856392 -122.427225555933 (37.7740225856392, -122.427225555933) 7 9 11 28852 10
179128 66115 7 97 817 Hayes St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/15/1990 12:00:00 AM     Permit Number 29170 6003947.68857827 2110748.1234611 37.7759352566539 -122.429841497852 (37.7759352566539, -122.429841497852) 7 9 11 29492 10
179236 30890 7 97 412 Hayes St 4 Sidewalk: Curb side : Cutout Tree 2   03/08/1995 12:00:00 AM     Permit Number 34719 6005865.19335847 2111068.58127823 37.7769235557198 -122.423231126893 (37.7769235557198, -122.423231126893) 7 9 11 28852 10
184502 33607 7 97 314 Lily St 1 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37719 6005021.10976005 2110082.43632314 37.7741681701238 -122.426080852286 (37.7741681701238, -122.426080852286) 7 9 11 28852 10
185167 33614 7 97 312 Lily St 1 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37724 6005030.32834442 2110083.71933458 37.7741722139784 -122.4260490549 (37.7741722139784, -122.4260490549) 7 9 11 28852 10
186946 33612 7 97 310 Lily St 1 Sidewalk: Curb side : Cutout Tree 2   12/02/1996 12:00:00 AM     Permit Number 37722 6005039.5469288 2110085.00234602 37.7741762578244 -122.42601725751 (37.7741762578244, -122.42601725751) 7 9 11 28852 10
190656 30538 7 97 614 Fillmore St 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 34538 6003619.86564688 2110438.7017887 37.7750670913733 -122.430953433821 (37.7750670913733, -122.430953433821) 7 9 11 29492 10