trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6628 73438 1 65 212 20th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   16     5989642.98356 2113924.77294 37.7838370079244 -122.479557105797 (37.7838370079244, -122.479557105797) 11 6 2 55 26
6832 221870 1 65 530 Banks St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6008584.18129 2096552.27767 37.7372181568784 -122.412798757353 (37.7372181568784, -122.412798757353) 10 7 7 28859 2
12867 73402 1 65 1434 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   16     5982802.3301 2105339.2702 37.759863969648 -122.502587148941 (37.759863969648, -122.502587148941) 1 8 3 56 35
14208 70581 1 65 366 20th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   16     5989681.74367 2112910.59233 37.7810546031553 -122.47934879186 (37.7810546031553, -122.47934879186) 11 6 2 55 26
16984 203543 1 65 518 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5997969.26989 2094410.6553 37.7307362500808 -122.449344943519 (37.7307362500808, -122.449344943519) 9 7 4 59 40
30504 37659 1 65 486 Funston Ave 2 Sidewalk: Curb side : Cutout Tree 2   07/02/2008 12:00:00 AM 16 3x3 Permit Number 51139 5991909.24916 2112157.7974 37.7791167592266 -122.471587940686 (37.7791167592266, -122.471587940686) 11 6 2 54 11
33356 138630 1 65 1702 Baker St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   6000078.3648 2114795.7207 37.7868290426993 -122.443517270296 (37.7868290426993, -122.443517270296) 13 6 1 29490 27
35544 221939 1 65 21 Harry St 3 Sidewalk: Property side : Yard Tree 2     16 Width 8ft   6003408.10773 2097774.81236 37.740283068906 -122.430782023672 (37.740283068906, -122.430782023672) 2 7 5 63 7
45404 221907 1 65 1217 Noe St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6003244.02772 2101149.87665 37.7495409130801 -122.431590240821 (37.7495409130801, -122.431590240821) 2 4 5 28862 22
49629 221833 1 65 577 Capp St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6007293.94274 2103980.62531 37.7575422218038 -122.417786099775 (37.7575422218038, -122.417786099775) 2 4 7 28859 19
65829 68256 1 65 243 Holyoke St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/09/1993 12:00:00 AM 16   Permit Number 32061 6009551.9423 2093241.4503 37.7281816043806 -122.409219186739 (37.7281816043806, -122.409219186739) 10 3 7 309 28
71152 221844 1 65 127 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 2ft   6004153.19016 2095736.31086 37.7347279926082 -122.428060594226 (37.7347279926082, -122.428060594226) 2 7 5 28861 25
97742 141702 1 65 154 BEAUMONT AVE 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   5996846.4318 2111948.6051 37.7788267693983 -122.454493192496 (37.7788267693983, -122.454493192496) 15 6 2 54 16
103811 189214 1 65 1498 25th St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6014376.75149 2102028.72002 37.7525787510095 -122.393154121288 (37.7525787510095, -122.393154121288) 10 3 8 28856 29
125012 221854 1 65 4418 23rd St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 2ft   6000475.00831 2102295.38218 37.7525288566262 -122.441247749083 (37.7525288566262, -122.441247749083) 2 4 5 28862 22
139320 203578 1 65 312 Joost Ave 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5999939.80462 2094974.46238 37.7323968536154 -122.442572982852 (37.7323968536154, -122.442572982852) 9 7 4 63 40
143155 221914 1 65 476 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6003319.74249 2102160.73191 37.7523207750848 -122.431400568387 (37.7523207750848, -122.431400568387) 2 4 5 28862 22
149081 221900 1 65 7 Marsily St 3 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6004249.68912 2095508.61359 37.7341082463924 -122.427710746252 (37.7341082463924, -122.427710746252) 2 7 5 28861 25
154673 221886 1 65 121 Santa Marina St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6006322.71195 2097511.22057 37.7397240062552 -122.420685761336 (37.7397240062552, -122.420685761336) 2 7 7 28859 2
157942 221798 1 65 430 Webster St 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6004116.67022 2110321.94704 37.7747746486742 -122.429226550889 (37.7747746486742, -122.429226550889) 7 9 11 28852 10
165874 38552 1 65 1820 Keith St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/17/1998 12:00:00 AM 16   Permit Number 40520 6015364.9925 2093693.5794 37.7297470188732 -122.389154637038 (37.7297470188732, -122.389154637038) 10 3 8 58 1
171216 203540 1 65 305 Foerster St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5998091.57112 2094441.2535 37.7308272605603 -122.448924334186 (37.7308272605603, -122.448924334186) 9 7 4 59 40
176460 124540 1 65 1001 Balboa St 5 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   5992434.91117 2111337.17059 37.7768939384148 -122.469709718849 (37.7768939384148, -122.469709718849) 11 6 2 54 11
181596 140134 1 65 1624 FULTON ST 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 0ft   5999973.0263 2110940.5311 37.7762376765447 -122.443604667807 (37.7762376765447, -122.443604667807) 15 5 11 29492 16
190685 39931 1 65 175 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/25/1999 12:00:00 AM 16   Permit Number 41202 6010293.70332 2087956.69983 37.7137123004597 -122.406282682604 (37.7137123004597, -122.406282682604) 9 7 8 309 39
193468 114082 1 65 20 Cook St 3 Sidewalk: Curb side : Cutout Tree 2 FUF   16     5997500.7704 2113521.7588 37.7831837426404 -122.452343137457 (37.7831837426404, -122.452343137457) 15 6 1 54 31