trees

Custom SQL query returning 39 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
139635 42590 7 90 121 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree 2   06/26/2000 12:00:00 AM     Permit Number 42664 5991652.84779157 2095347.0788302 37.7329441015396 -122.471249796136 (37.7329441015396, -122.471249796136) 9 8 4 59 40
142339 22373 1 90 5506 03rd St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6014104.4995 2092933.9505 37.7275912748343 -122.393459193349 (37.7275912748343, -122.393459193349) 10 3 8 58 1
142681 190058 1 90 601 Amador St 10 : Tree 2     7 Width 3ft   6017131.10054 2099512.41263 37.7458221157047 -122.383453858321 (37.7458221157047, -122.383453858321) 10 3 8 58 1
143612 141065 1 90 193 Cook St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   5997591.6366 2112595.3291 37.7806452152507 -122.451961919026 (37.7806452152507, -122.451961919026) 15 6 2 54 16
143925 175849 1 90 986 Athens St 2 Sidewalk: Curb side : Cutout Tree 2     10 Width 2ft   6002153.04681 2088139.00774 37.713754143201 -122.434432752284 (37.713754143201, -122.434432752284) 9 7 6 28861 5
144437 111361 1 90 404x ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree 2   07/27/2015 12:00:00 AM 3 9x3   5998929 2109293 37.7716543786165 -122.447097632764 (37.7716543786165, -122.447097632764) 15 5 11 29492 9
146118 245157 1 90 241 Central Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   5999819.9184 2109349.706 37.771860941516 -122.444019977581 (37.771860941516, -122.444019977581) 15 5 11 29492 9
148909 67494 1 90 1101 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/08/1992 12:00:00 AM 10   Permit Number 31019 6011959.0139 2103258.41584 37.7558206181412 -122.401601545873 (37.7558206181412, -122.401601545873) 10 3 8 28856 29
149223 41327 1 90 1099 23rd St 6 Sidewalk: Curb side : Cutout Tree 2   02/25/2000 12:00:00 AM 8   Permit Number 41989 6015166.5267 2102962.32653 37.755186078977 -122.390488148502 (37.755186078977, -122.390488148502) 10 3 8 28856 29
151144 126028 1 90 3436 Clay St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 4ft   5998376.70601 2115562.57298 37.7888374239642 -122.449459861577 (37.7888374239642, -122.449459861577) 13 6 1 54 31
156582 46313 1 90 1207 Indiana St 1 Sidewalk: Curb side : Cutout Tree 2   02/04/2002 12:00:00 AM 10   Permit Number 44567 6015074.7999 2102810.74844 37.7547647888776 -122.390794776855 (37.7547647888776, -122.390794776855) 10 3 8 28856 29
157110 111362 1 90 404x ASHBURY ST 2 Sidewalk: Curb side : Cutout Tree 2   07/27/2015 12:00:00 AM 3 9x3   5998929 2109293 37.7716543786165 -122.447097632764 (37.7716543786165, -122.447097632764) 15 5 11 29492 9
157610 34934 1 90 2263 Greenwich St 1 Sidewalk: Curb side : Cutout Tree 2   10/20/1997 12:00:00 AM 4   Permit Number 38529 6002078.2666 2119099.82089 37.7987608392949 -122.436906330362 (37.7987608392949, -122.436906330362) 13 9 1 57 17
162350 112679 4 90 490x GREEN ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6010628 2119373 37.7999931439643 -122.40734061853 (37.7999931439643, -122.40734061853) 3 1 10 308 23
162557 106931 4 90 340 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree 2     15 10x8   6007766.2 2105923.3 37.7629029238803 -122.41629043085 (37.7629029238803, -122.41629043085) 8 4 7 28859 19
163569 99182 1 90 3124 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     20 3x7   5999415.83241 2119586.98668 37.7999467842805 -122.446154238844 (37.7999467842805, -122.446154238844) 13 9 1 57 17
168307 27382 1 90 2540 Hyde St 4 Sidewalk: Curb side : Cutout Tree 1     3 2X3   6006997.1662849 2121079.7808347 37.8044756501735 -122.420025898607 (37.8044756501735, -122.420025898607) 5 1 1 28858 32
169329 102245 1 90 386 Connecticut St 1 Sidewalk: Curb side : Cutout Tree 2     15 6x9   6013188.2401 2105269.20055 37.761410308446 -122.397491470547 (37.761410308446, -122.397491470547) 10 3 8 28856 29
169563 179265 1 90 63 Princeton St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 2ft   6007545.37116 2093646.36987 37.729180805142 -122.41618466351 (37.729180805142, -122.41618466351) 9 3 7 309 28
171914 126030 1 90 3301 Laguna St 16 Sidewalk: Property side : Yard Tree 2     2     6003671.03027 2120119.72439 37.8016516272786 -122.431467704597 (37.8016516272786, -122.431467704597) 13 9 1 57 17
172064 101679 4 90 257 Central Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
173411 40523 7 90 141 Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
173744 190045 1 90 1200 Minnesota St 5 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6015294.5345 2102879.3666 37.754965388969 -122.390039661115 (37.754965388969, -122.390039661115) 10 3 8 28856 29
174754 42547 7 90 1011 23rd St 11 Sidewalk: Curb side : Cutout Tree 2   06/26/2000 12:00:00 AM     Permit Number 42643 6015278.958837 2102962.15711273 37.7551918502677 -122.390099310013 (37.7551918502677, -122.390099310013) 10 3 8 28856 29
176161 190056 1 90 601 Amador St 8 : Tree 2     6 Width 3ft   6017097.53579 2099510.4176 37.7458147826396 -122.383569782742 (37.7458147826396, -122.383569782742) 10 3 8 58 1
176631 132056 1 90 1337 Greenwich St 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 4ft   6006485.23006 2119708.64012 37.8006819908322 -122.421700054519 (37.8006819908322, -122.421700054519) 13 9 1 28858 32
177683 190046 1 90 1200 Minnesota St 6 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6015297.13041 2102859.28878 37.7549104035112 -122.390029281149 (37.7549104035112, -122.390029281149) 10 3 8 28856 29
178416 190043 1 90 1200 Minnesota St 3 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6015293.71026 2102912.85823 37.7550573041579 -122.390044851106 (37.7550573041579, -122.390044851106) 10 3 8 28856 29
179452 225216 1 90 42 Kronquist Ct 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6002223.67361 2100098.01608 37.7465948653766 -122.435043432425 (37.7465948653766, -122.435043432425) 2 7 5 63 22
180045 38045 1 90 1717 Baker St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 07/10/1998 12:00:00 AM 4   Permit Number 40246 6000011.6939 2114927.5611 37.7871872396683 -122.443757410609 (37.7871872396683, -122.443757410609) 15 6 1 29490 31
183065 117531 4 90 257 Central Ave 5 Sidewalk: Curb side : Cutout Tree 2       3x3   5999766.4 2109434.7 37.7720912604321 -122.444211209505 (37.7720912604321, -122.444211209505) 15 5 11 29492 9
185003 126029 1 90 3301 Laguna St 15 Sidewalk: Property side : Yard Tree 2     20     6003669.97171 2120132.26195 37.8016859921622 -122.431472263247 (37.8016859921622, -122.431472263247) 13 9 1 57 17
185374 190057 1 90 601 Amador St 9 : Tree 2     6 Width 3ft   6017114.32264 2099511.63741 37.7458190598104 -122.383511820533 (37.7458190598104, -122.383511820533) 10 3 8 58 1
188098 175851 1 90 401 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2     18 Width 3ft   6008594.06768 2088021.58529 37.7137952413274 -122.41216184759 (37.7137952413274, -122.41216184759) 9 7 8 309 39
191085 40085 1 90 2770 Filbert St 1 Sidewalk: Curb side : Cutout Tree 2   02/19/1999 12:00:00 AM 12   Permit Number 41306 5999702.22145 2118468.61098 37.7968923736436 -122.445082782069 (37.7968923736436, -122.445082782069) 13 9 1 57 17
191408 175848 1 90 900 Vienna St 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 4ft   6002108.06583 2088596.52311 37.7150078260217 -122.434620917447 (37.7150078260217, -122.434620917447) 9 7 6 28861 5
192028 41326 1 90 1099 23rd St 4 Sidewalk: Curb side : Cutout Tree 2   02/25/2000 12:00:00 AM 7   Permit Number 41989 6015140.97483 2102958.96584 37.7551754337272 -122.390576280292 (37.7551754337272, -122.390576280292) 10 3 8 28856 29
192048 41334 1 90 1099 23rd St 2 Sidewalk: Curb side : Cutout Tree 2   02/25/2000 12:00:00 AM 5   Permit Number 41989 6015110.15848 2102957.82605 37.7551705944573 -122.390682773512 (37.7551705944573, -122.390682773512) 10 3 8 28856 29
192812 190042 1 90 1200 Minnesota St 2 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6015293.33964 2102924.2234 37.7550884899453 -122.390046926728 (37.7550884899453, -122.390046926728) 10 3 8 28856 29