trees

Custom SQL query returning 37 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
146627 175215 1 65 857 Barneveld Ave 1 Sidewalk: Property side : Yard Tree 2     33 Width 8ft   6010301.67863 2094727.33157 37.7323034959049 -122.406731980322 (37.7323034959049, -122.406731980322) 10 3 7 309 28
52355 175197 1 65 701 Peru Ave 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 5ft   6005286.47432 2092498.92071 37.7259028886841 -122.423912306729 (37.7259028886841, -122.423912306729) 9 7 7 309 5
21664 175212 1 65 87x Valmar Ter 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6005258.73549 2092540.80848 37.7260163372638 -122.424011175489 (37.7260163372638, -122.424011175489) 9 7 7 309 5
31850 175188 1 65 526 Lathrop Ave 12 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6013054.80397 2086529.42647 37.7099473534465 -122.396639252322 (37.7099473534465, -122.396639252322) 10 3 8 309 1
34364 175214 1 65 728 Burrows St 5 Sidewalk: Curb side : Cutout Tree 2     19 Width 3ft   6009081.49175 2092873.82998 37.7271458291085 -122.410819605863 (37.7271458291085, -122.410819605863) 9 3 7 309 28
45238 175213 1 65 87x Valmar Ter 2 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6005270.21686 2092560.99775 37.7260724207817 -122.423972920124 (37.7260724207817, -122.423972920124) 9 7 7 309 5
52738 175189 1 65 526 Lathrop Ave 15 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6013119.70644 2086508.48338 37.7098934597806 -122.3964134685 (37.7098934597806, -122.3964134685) 10 3 8 309 1
53116 175186 1 65 526 Lathrop Ave 5 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6012896.74794 2086580.57878 37.7100790097123 -122.397189112215 (37.7100790097123, -122.397189112215) 10 3 8 309 1
61711 175190 1 65 2201 Bay Shore Blvd 7 Sidewalk: Curb side : Cutout Tree 2     24 Width 3ft   6011418.48668 2087333.27614 37.7120633584163 -122.402351191059 (37.7120633584163, -122.402351191059) 10 3 8 309 1
77457 175216 1 65 240 Dwight St 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6010752.32605 2091460.28671 37.7233580771044 -122.404944037249 (37.7233580771044, -122.404944037249) 10 3 7 309 28
87516 175187 1 65 526 Lathrop Ave 8 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6012949.0524 2086563.25538 37.7100343547851 -122.39700712268 (37.7100343547851, -122.39700712268) 10 3 8 309 1
108759 175185 1 65 526 Lathrop Ave 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6012801.34824 2086611.11374 37.7101575412033 -122.397520974627 (37.7101575412033, -122.397520974627) 10 3 8 309 1
164548 175191 1 65 193 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree 2     17 Width 3ft   6010202.71269 2087988.02388 37.7137932196449 -122.406599386967 (37.7137932196449, -122.406599386967) 9 7 8 309 39
4665 255219 1 65 668 Goettingen St 1 Sidewalk: Curb side : Cutout Tree 1 FUF   3 3x5   6010649.61655 2091566.6998 37.7236445235288 -122.405306576793 (37.7236445235288, -122.405306576793) 10 3 7 309 28
60136 108565 1 65 521 Goettingen St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 12/24/2014 12:00:00 AM 3 3x3 Permit Number 772537 6010495.60195 2092202.94019 37.7253828953025 -122.405883778414 (37.7253828953025, -122.405883778414) 10 3 7 309 28
160888 97263 1 65 220 Gaven St 1 Sidewalk: Curb side : Cutout Tree 2   12/24/2014 12:00:00 AM 3 3x3 Permit Number 773740 6009330.61336 2094994.97082 37.7329839958128 -122.410108077526 (37.7329839958128, -122.410108077526) 10 3 7 309 28
589 108776 7 65 500X Lathrop Ave 15 Sidewalk: Curb side : Cutout Tree 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
4556 35737 1 65 351 Hale St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 04/14/1998 12:00:00 AM 11   Permit Number 39011 6008822.29863 2094308.62612 37.7310709363673 -122.411816979173 (37.7310709363673, -122.411816979173) 9 3 7 309 28
7022 70397 1 65 130 Oxford St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   21     6006350.25387 2093285.00079 37.7281212922586 -122.420290654116 (37.7281212922586, -122.420290654116) 9 7 7 309 5
13677 73831 1 65 102 Teddy Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   19     6010808.25129 2088026.19044 37.713931877121 -122.404509096323 (37.713931877121, -122.404509096323) 9 7 8 309 39
21642 38204 1 65 691 Goettingen St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/17/1998 12:00:00 AM 14   Permit Number 40328 6010720.89935 2091470.20831 37.7233835629968 -122.405053372309 (37.7233835629968, -122.405053372309) 10 3 7 309 28
21660 65231 1 65 812 Silliman St 1 Sidewalk: Curb side : Cutout Tree 2   07/24/1989 12:00:00 AM 10   Permit Number 28018 6008328.075 2093605.15348 37.7291116131036 -122.41347586773 (37.7291116131036, -122.41347586773) 9 3 7 309 28
26137 108762 7 65 500X Lathrop Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
33233 67291 1 65 701 Peru Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/22/1992 12:00:00 AM 19   Permit Number 30767 6005304.50618 2092488.24493 37.725874593313 -122.423849212975 (37.725874593313, -122.423849212975) 9 7 7 309 5
43315 38214 1 65 331 Wayland St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/17/1998 12:00:00 AM 11   Permit Number 40337 6010588.27199 2092325.30166 37.7257240567036 -122.405572039215 (37.7257240567036, -122.405572039215) 10 3 7 309 28
46915 38203 1 65 691 Goettingen St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 07/17/1998 12:00:00 AM 14   Permit Number 40328 6010707.71448 2091513.67595 37.7235021790704 -122.405102009451 (37.7235021790704, -122.405102009451) 10 3 7 309 28
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
59999 38206 1 65 756 Goettingen St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/17/1998 12:00:00 AM 11   Permit Number 40330 6010781.48445 2091161.67808 37.7225397893635 -122.404822228563 (37.7225397893635, -122.404822228563) 10 3 7 309 28
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
83049 39933 1 65 180 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/25/1999 12:00:00 AM 17   Permit Number 41204 6010299.07366 2087996.8284 37.7138227857583 -122.406266946271 (37.7138227857583, -122.406266946271) 9 7 8 309 39
104017 35736 1 65 351 Hale St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/14/1998 12:00:00 AM 9   Permit Number 39011 6008805.61164 2094302.44729 37.731053034462 -122.411874232722 (37.731053034462, -122.411874232722) 9 3 7 309 28
127600 39936 1 65 262 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/25/1999 12:00:00 AM 11   Permit Number 41207 6009779.33678 2088185.9421 37.7143129666441 -122.408076686195 (37.7143129666441, -122.408076686195) 9 7 8 309 39
141890 39929 7 65 137 Arleta Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/25/1999 12:00:00 AM     Permit Number 767825 6010490.84450997 2087849.27835868 37.7134283686634 -122.405593725995 (37.7134283686634, -122.405593725995) 9 7 8 309 39
142656 108766 7 65 500X Lathrop Ave 5 Sidewalk: Curb side : Cutout Tree 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
172883 108769 7 65 500X Lathrop Ave 8 Sidewalk: Curb side : Cutout Tree 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1
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
191256 108773 7 65 500X Lathrop Ave 12 Sidewalk: Curb side : Cutout Tree 2 FUF 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654) 10 3 8 309 1