trees

Custom SQL query returning 32 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
7372 175205 1 65 653 Peru Ave 6 Side Yard : Yard Tree 2     15     6005071.6263 2092637.86098 37.7262722564417 -122.424664901662 (37.7262722564417, -122.424664901662) 9 7 6 28861 5
31207 32474 1 65 7 Ord St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/10/1996 12:00:00 AM 15   Permit Number 36982 6000854.39467 2106273.37873 37.7634730690508 -122.440221013784 (37.7634730690508, -122.440221013784) 15 5 5 28862 3
53408 37793 1 65 347 Hamilton St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/06/1998 12:00:00 AM 15   Permit Number 40121 6009401.77176 2092702.5768 37.7266935573585 -122.409700314138 (37.7266935573585, -122.409700314138) 10 3 7 309 28
60145 38581 1 65 1483 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/17/1998 12:00:00 AM 15   Permit Number 40541 6015866.8585 2094128.4257 37.7309688285238 -122.387449938884 (37.7309688285238, -122.387449938884) 10 3 8 58 1
85408 67245 1 65 4738 Anza St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/08/1992 12:00:00 AM 15   Permit Number 30709 5983942.53029 2111768.14196 37.7775827533368 -122.499118839179 (37.7775827533368, -122.499118839179) 11 6 2 55 26
190011 66065 1 65 615 Missouri St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/06/1990 12:00:00 AM 15   Permit Number 29105 6013588.8129 2104207.15934 37.7585164708659 -122.396031617282 (37.7585164708659, -122.396031617282) 10 3 8 28856 29
192251 44734 1 65 1434 Quintara St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/03/2001 12:00:00 AM 15   Permit Number 43849 5988947.4767 2101073.1476 37.7485095315689 -122.481021968545 (37.7485095315689, -122.481021968545) 1 8 3 29491 35
154695 4846 1 65 210 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/27/1992 12:00:00 AM 15 3X3   6006713.9746 2097429.76412 37.7395223890352 -122.419327161814 (37.7395223890352, -122.419327161814) 2 7 7 28859 2
100013 112856 4 65 1700x BAKER ST 2 Sidewalk: Curb side : Cutout Tree 2     15 3x3   6000040 2114920 37.7871680933118 -122.443658934554 (37.7871680933118, -122.443658934554) 15 6 1 29490 31
111705 74111 4 65 500X Avalon Ave 2 Sidewalk: Curb side : Cutout Tree 2   06/25/1994 12:00:00 AM 15 3x3   6003976.59234436 2092494.78352221 37.7258174919201 -122.428440184616 (37.7258174919201, -122.428440184616) 9 7 6 28861 5
138216 121328 1 65 2455 32nd Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 3x3   5986403.9195 2098529.3345 37.7413767161187 -122.489630387324 (37.7413767161187, -122.489630387324) 1 8 3 29491 35
155522 247495 1 65 537 Steiner St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   6003124.7415 2110167.9221 37.7742955303854 -122.432646828997 (37.7742955303854, -122.432646828997) 15 9 11 29492 10
163162 141448 1 65 194 Beaumont Ave 2 Sidewalk: Curb side : Cutout Tree 2     15 Width 0ft   5996892.1188 2111627.1044 37.7779466329687 -122.454311915058 (37.7779466329687, -122.454311915058) 15 6 2 54 16
23331 125557 1 65 22 Dashiell Hammett St 6 Sidewalk: Curb side : Cutout Tree 2     15 Width 1ft   6010370.0822 2116109.39697 37.7910176441083 -122.40800283658 (37.7910176441083, -122.40800283658) 5 1 10 28857 21
76757 203585 1 65 122 Detroit St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 2ft   5999428.77785 2093578.76175 37.7285354426355 -122.444239456297 (37.7285354426355, -122.444239456297) 9 7 4 63 40
4279 117667 1 65 4750 Anza St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   5983866.04939 2111764.3275 37.777567793158 -122.499383126218 (37.777567793158, -122.499383126218) 11 6 2 55 26
10474 221869 1 65 673 Andover St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6007432.02888 2095820.07599 37.7351429550833 -122.416730429683 (37.7351429550833, -122.416730429683) 2 7 7 28859 2
53011 221889 1 65 190 Bartlett St 2 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6006689.37303 2102664.80303 37.7538952362014 -122.419783585756 (37.7538952362014, -122.419783585756) 2 4 7 28859 19
69909 175176 1 65 226 Rome St 1 Sidewalk: Property side : Yard Tree 2     15 Width 3ft   5998630.92665 2088821.65601 37.7154279802818 -122.446655529047 (37.7154279802818, -122.446655529047) 9 7 6 28861 25
93698 203506 1 65 910 Kirkham St 4 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   5992059 2105289 37.7602655469825 -122.470569484113 (37.7602655469825, -122.470569484113) 1 8 4 56 12
107364 221928 1 65 3666 16th St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6002501.47722 2106518.4971 37.7642397410968 -122.434541817574 (37.7642397410968, -122.434541817574) 15 5 5 28862 3
110481 175078 1 65 1584 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6001809.64472 2092991.82578 37.7270593952569 -122.435966703417 (37.7270593952569, -122.435966703417) 9 7 6 28861 25
130543 221890 1 65 190 Bartlett St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6006689.76882 2102684.09428 37.7539482278401 -122.419783585763 (37.7539482278401, -122.419783585763) 2 4 7 28859 19
155147 221860 1 65 516 Douglass St 1 Sidewalk: Curb side : Cutout Tree 2   05/27/1998 12:00:00 AM 15 Width 3ft Permit Number 39568 6001163.03933 2103237.69221 37.7551553815387 -122.438935950032 (37.7551553815387, -122.438935950032) 2 4 5 28862 22
165676 203552 1 65 181 Flood Ave 11 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   5999546.8407 2094056.93019 37.7298551168086 -122.443865648605 (37.7298551168086, -122.443865648605) 9 7 4 63 40
190577 221864 1 65 592 Laidley St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6002944.20199 2095934.50761 37.7352037204832 -122.432254626652 (37.7352037204832, -122.432254626652) 2 7 5 63 7
192627 221915 1 65 476 Elizabeth St 2 Sidewalk: Curb side : Cutout Tree 2     15 Width 3ft   6003301.60957 2102160.71382 37.7523196977161 -122.431463273608 (37.7523196977161, -122.431463273608) 2 4 5 28862 22
81710 125550 1 65 1445 Greenwich St 9 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   6006031.52695 2119650.26621 37.8004961162623 -122.423265904597 (37.8004961162623, -122.423265904597) 13 9 1 28858 32
87625 221792 1 65 2818 23rd St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   6009842.62719 2102814.79283 37.7544842057885 -122.408889429605 (37.7544842057885, -122.408889429605) 2 4 7 28859 19
157703 123202 1 65 1310 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   5993110.48216 2112011.57103 37.7787846837447 -122.467421785255 (37.7787846837447, -122.467421785255) 11 6 2 54 11
178287 125551 1 65 1445 Greenwich St 11 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   6006045.33094 2119651.17602 37.8004993933977 -122.423218201864 (37.8004993933977, -122.423218201864) 13 9 1 28858 32
99045 221908 1 65 1175 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 5ft   6003228.29657 2101452.81084 37.7503718075255 -122.431666264992 (37.7503718075255, -122.431666264992) 2 4 5 28862 22