trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
75453 100529 6 17 720 Victoria St 1 Front Yard : Yard Tree 2   09/24/2012 12:00:00 AM     Permit Number 769203 5993611.6 2091925.6 37.723662667106 -122.464229627127 (37.723662667106, -122.464229627127) 9 8 4 59 40
75557 254361 6 27 1749 09th Ave 1 Front Yard : Yard Tree 2       6x6   5993372 2103579 37.7556461665355 -122.465904219148 (37.7556461665355, -122.465904219148) 1 8 4 56 12
76411 104900 6 253 317 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
78664 114390 6 83 23x PINTO AVE 1 Front Yard : Yard Tree 2     7     5988521 2090808 37.7202992922588 -122.481744923362 (37.7202992922588, -122.481744923362) 1 8 4 64 14
81276 114097 6 207 221x VIDAL DR 1 Front Yard : Yard Tree 2     14     5987664 2090556 37.7195574904968 -122.484688777519 (37.7195574904968, -122.484688777519) 1 8 4 64 14
81747 107245 6 17 140 CEDRO AVE   Front Yard : Yard Tree 2           5991993.7 2093259.3 37.7272312918526 -122.469919436342 (37.7272312918526, -122.469919436342) 9 8 4 59 40
82758 106514 6 17 190 EUCALYPTUS DR 2 Front Yard : Yard Tree 2           5990695.4 2094728.8 37.7311910349726 -122.474514801842 (37.7311910349726, -122.474514801842) 1 8 4 64 40
83312 254136 6 15 1623 47th Ave 1 Front Yard : Yard Tree 2       10x6 Permit Number 781075 5981544 2104016 37.7561566229771 -122.506840869024 (37.7561566229771, -122.506840869024) 1 8 3 56 35
84029 102075 6 57 273 Magellan Ave 5 Front Yard : Yard Tree 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
85339 115176 6 17 460 Pacheco St 1 Front Yard : Yard Tree 2   01/14/2016 12:00:00 AM   10x10 Permit Number 775764 5993727.4 2101897.6 37.7510499693469 -122.464553061226 (37.7510499693469, -122.464553061226) 1 8 4 29491 12
91798 173615 6 70 1200X JUNIPERO SERRA BLVD 14 Front Yard : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
93552 104749 6 15 1X Junipero Serra Blvd Off Ramp 1 Front Yard : Yard Tree 2         Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
94784 253250 6 41 99X Lopez Ave 1 Front Yard : Yard Tree 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
95053 114148 6 15 1200X JUNIPERO SERRA BLVD 7 Front Yard : Yard Tree 2     19     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
95583 102077 6 531 273 Magellan Ave 7 Front Yard : Yard Tree 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
96414 114394 6 101 134x TAPIA DR 1 Front Yard : Yard Tree 2     28     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
96682 115070 6 45 401 DARIEN WAY 1 Front Yard : Yard Tree 2     17     5992724 2094938 37.7318827746659 -122.467516839465 (37.7318827746659, -122.467516839465) 9 8 4 59 40
97021 105907 6 100 1837 30TH AVE 1 Front Yard : Yard Tree 2     6     5986904 2102674 37.7527860393128 -122.488205804709 (37.7527860393128, -122.488205804709) 1 8 3 56 35
98635 105649 6 41 3 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469) 1 8 4 64 14
99854 104898 6 62 310 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
101005 104736 6 6 1499X 44th Ave 1 Front Yard : Yard Tree 2         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.503718978789 (37.7595862228156, -122.503718978789) 1 8 3 56 35
101814 110427 6 15 1860 09TH AVE 2 Front Yard : Yard Tree 2   05/12/2015 12:00:00 AM 3   Permit Number 775447 5993494 2102835 37.7536103714224 -122.465428263995 (37.7536103714224, -122.465428263995) 1 8 4 56 12
101899 100432 6 2 200X Stonecrest Dr 2 Front Yard : Yard Tree 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
102526 100433 6 386 200X Stonecrest Dr 3 Front Yard : Yard Tree 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
102553 253254 6 15 270 Castenada Ave 1 Front Yard : Yard Tree 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
104010 104913 6 67 608 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
105349 114158 6 296 1200X JUNIPERO SERRA BLVD 6 Front Yard : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
105498 93932 6 100     Front Yard : Yard Tree 2   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.55284 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841) 1 8 4 64 14
105921 102569 6 9 0 Diaz Ave 1 Front Yard : Yard Tree 2   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.81974 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439) 1 8 4 64 14
106522 102073 6 138 273 Magellan Ave 3 Front Yard : Yard Tree 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
107089 255281 6 9 320 Magellan Ave 2 Front Yard : Yard Tree 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
107229 255805 6 333 2 Sola Ave 1 Front Yard : Yard Tree 2       10x10   5994994 2100719 37.7478867659483 -122.460087684856 (37.7478867659483, -122.460087684856) 1 8 4 29491 40
107818 98757 6 15 340 Castenada Ave 1 Front Yard : Yard Tree 2           5993579.1 2100062.8 37.7460035255592 -122.464932655613 (37.7460035255592, -122.464932655613) 1 8 4 29491 40
109420 114102 6 37 7 ACEVEDO AVE 1 Front Yard : Yard Tree 2     18     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
110154 102074 6 201 273 Magellan Ave 4 Front Yard : Yard Tree 2           5994674.1 2100293.4 37.7466997707371 -122.461163031194 (37.7466997707371, -122.461163031194) 1 8 4 29491 40
111294 255282 6 9 320 Magellan Ave 3 Front Yard : Yard Tree 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
112272 105540 6 62 2694 47TH AVE 1 Front Yard : Yard Tree 2     12     5981878.3 2096771.8 37.7362857499502 -122.505147911282 (37.7362857499502, -122.505147911282) 1 8 3 29491 35
113390 104936 6 37 837 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
114129 254093 6 17 716 Gonzalez Dr 2 Front Yard : Yard Tree 2   01/24/2018 12:00:00 AM 3 10x10 Permit Number 781051 5988732 2090042 37.7182083166364 -122.480959519123 (37.7182083166364, -122.480959519123) 1 8 4 64 14
115084 104751 6 70 13X JUAN BAUTISTA CIR 2 Front Yard : Yard Tree 2           5989494 2090180 37.7186314952818 -122.47833572412 (37.7186314952818, -122.47833572412) 1 8 4 64 14
120316 106363 6 41 101 URBANO DR 1 Front Yard : Yard Tree 2     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025) 9 8 4 59 40
124365 116951 6 238 299 Tara St 1 Front Yard : Yard Tree 2           5997754 2090179.6 37.7191064490611 -122.449784366221 (37.7191064490611, -122.449784366221) 9 8 6 28861 24
125248 106038 6 72 230 Lakeview Ave   Front Yard : Yard Tree 2         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743) 9 8 6 28861 24
125330 104932 6 36 717 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
125509 254393 6 238 150 Granville Way 1 Front Yard : Yard Tree 2       10x10   5994538 2098550 37.7419049979895 -122.461507275162 (37.7419049979895, -122.461507275162) 1 8 4 59 40
126137 104937 6 37 839 Gonzalez Dr 2 Front Yard : Yard Tree 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
127076 104193 6 206 122 Arch St 1 Front Yard : Yard Tree 2           5992720.4 2088013.1 37.7128684825751 -122.467026013031 (37.7128684825751, -122.467026013031) 9 8 6 64 24
127778 114100 6 253 21x ACEVEDO AVE 1 Front Yard : Yard Tree 2     10     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
128499 255151 6 551 201 Vicente St 4 Front Yard : Yard Tree 2       Width 3ft   5992494.60347 2097875.96956 37.7399364549038 -122.468523586018 (37.7399364549038, -122.468523586018) 1 8 4 59 40
138477 104934 6 37 805 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
142019 104750 6 15 1X Junipero Serra Blvd Off Ramp 2 Front Yard : Yard Tree 2   08/30/2016 12:00:00 AM 3   Permit Number 770709 5991326.15861 2088181.65405 37.7132507161795 -122.47185719554 (37.7132507161795, -122.47185719554) 1 8 4 64 14
144280 253255 6 41 270 Castenada Ave 2 Front Yard : Yard Tree 2   01/09/2018 12:00:00 AM 3 10x10 Permit Number 780226 5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
145813 173616 6 36 1200X JUNIPERO SERRA BLVD 15 Front Yard : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
146533 104435 6 28 1601X PORTOLA DR 4 Front Yard : Yard Tree 2     16     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
147278 100431 6 2 200X Stonecrest Dr 1 Front Yard : Yard Tree 2           5990724.7 2093134.9 37.7268162840874 -122.47429724264 (37.7268162840874, -122.47429724264) 9 8 4 64 40
149040 114068 6 37 8 HIGUERA AVE 1 Front Yard : Yard Tree 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
152541 114384 6 83 418X SERRANO DR 2 Front Yard : Yard Tree 2     6     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
154838 102479 6 185 760 Victoria St 5 Front Yard : Yard Tree 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
155948 102478 6 89 760 Victoria St 4 Front Yard : Yard Tree 2           5993664.7 2092172.3 37.7243431058269 -122.464063971167 (37.7243431058269, -122.464063971167) 9 8 4 59 40
156777 114101 6 253 21x ACEVEDO AVE 2 Front Yard : Yard Tree 2     7     5988027 2090598 37.7196939458216 -122.48343711114 (37.7196939458216, -122.48343711114) 1 8 4 64 14
157181 101138 6 15 1290 Portola Dr 1 Front Yard : Yard Tree 2           5994035.6 2097938.3 37.7401964926879 -122.463200022957 (37.7401964926879, -122.463200022957) 1 8 4 59 40
159155 104908 6 62 500 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
160583 104899 6 143 314 Gonzalez Dr 2 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
160882 113234 6 19 2023 43RD AVE 1 Front Yard : Yard Tree 2     12 3x3   5982877 2101339 37.7488847374588 -122.502032899239 (37.7488847374588, -122.502032899239) 1 8 3 29491 35
164851 103422 6 41 1365 Portola Dr 1 Front Yard : Yard Tree 2         Permit Number 769779 5993416.2 2097683.7 37.7394617231066 -122.465323151466 (37.7394617231066, -122.465323151466) 1 8 4 59 40
165218 114145 6 150 1200x JUNIPERO SERRA BLVD 2 Front Yard : Yard Tree 2     6     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
168382 255283 6 9 320 Magellan Ave 4 Front Yard : Yard Tree 2   05/01/2018 12:00:00 AM 3 10x20 Permit Number 781012 5994287.14264 2099988.88368 37.7458413694018 -122.462478996433 (37.7458413694018, -122.462478996433) 1 8 4 29491 40
169388 104432 6 52 1601X PORTOLA DR 1 Front Yard : Yard Tree 2     14     5991823 2096240 37.7354056792703 -122.47072655808 (37.7354056792703, -122.47072655808) 1 8 4 59 40
171749 253384 6 208 55 Cerritos Ave 1 Front Yard : Yard Tree 2       10x10   5992588 2092941 37.7263916542788 -122.46784182224 (37.7263916542788, -122.46784182224) 9 8 4 59 40
172353 99662 6 41 1337 Portola Dr 1 Front Yard : Yard Tree 2           5993559.3 2097744.3 37.7396363671104 -122.464832777968 (37.7396363671104, -122.464832777968) 1 8 4 59 40
173122 112354 6 17 300 Moncada Way 1 Front Yard : Yard Tree 2   01/04/2016 12:00:00 AM   10x10 Permit Number 775546 5992209.2 2093928.1 37.729080105492 -122.469223117768 (37.729080105492, -122.469223117768) 9 8 4 59 40
173819 104916 6 15 700 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
173820 104912 6 42 606 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
173894 114104 6 145 400x ARBALLO DR 1 Front Yard : Yard Tree 2     12 3x3   5988116 2090625 37.7197732605649 -122.48313145165 (37.7197732605649, -122.48313145165) 1 8 4 64 14
177784 114257 6 470 50x CHUMASERO DR 1 Front Yard : Yard Tree 2           5990913 2088468 37.714013037331 -122.473306070941 (37.714013037331, -122.473306070941) 1 8 4 64 14
178381 254173 6 25 1850 19th Ave 1 Front Yard : Yard Tree 2       3x6   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
180735 114146 6 150 1200x JUNIPERO SERRA BLVD 3 Front Yard : Yard Tree 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
181284 114154 6 70 1200x JUNIPERO SERRA BLVD 13 Front Yard : Yard Tree 2     20     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
181383 104933 6 36 755 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990427 2090598 37.7198333383806 -122.475141254145 (37.7198333383806, -122.475141254145) 1 8 4 64 40
183573 104808 6 390 1665 08th Ave   Front Yard : Yard Tree 2     40     5993673.5 2104163.7 37.7572689897716 -122.464904006701 (37.7572689897716, -122.464904006701) 1 8 4 56 12
183605 104761 6 390 1665 18TH AVE   Front Yard : Yard Tree 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
184580 114393 6 101 118x TAPIA DR 1 Front Yard : Yard Tree 2     36     5988638 2090878 37.7204982977387 -122.481345621141 (37.7204982977387, -122.481345621141) 1 8 4 64 14
185053 99826 6 41 1 Cascade Walk 1 Front Yard : Yard Tree 2           5992183.1 2103187.3 37.7545020044945 -122.469987253468 (37.7545020044945, -122.469987253468) 1 8 4 56 12
186272 104762 6 390 1665 18TH AVE   Front Yard : Yard Tree 2     50 9x9   5990543.2 2104073 37.756838968238 -122.475723071248 (37.756838968238, -122.475723071248) 1 8 4 56 12
187303 118359 6 15 8 Keystone Way 1 Front Yard : Yard Tree 2     20 3x3   5994105 2092664 37.7257185609933 -122.46257757783 (37.7257185609933, -122.46257757783) 9 8 4 59 40
187309 106198 6 570 2101 42ND AVE 1 Front Yard : Yard Tree 2     18     5983206.1 2100796.8 37.7474153345648 -122.500854798087 (37.7474153345648, -122.500854798087) 1 8 3 29491 35
188942 104888 6 41 146 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
194270 264977 6 17 188 Yerba Buena Ave 1 Front Yard : Yard Tree 2   12/02/2020 12:00:00 AM 3 3x3 Permit Number 787864 5994639 2096200 37.7354582929988 -122.460987765625 (37.7354582929988, -122.460987765625) 9 8 4 59 40
194374 265048 6 155 959 Kirkham St 1 Front Yard : Yard Tree 2       20x20   5991956 2105209 37.7600399316741 -122.470919881603 (37.7600399316741, -122.470919881603) 1 8 4 56 12
150390 99101 6 11 55x Santa Monica Way 1 Median : Yard Tree 2   04/07/2012 12:00:00 AM     Permit Number 768464 5993693.6 2097654.3 37.7393969918941 -122.464361897304 (37.7393969918941, -122.464361897304) 1 8 4 59 40
51266 255290 6 15 3353 19th Ave 1 Side Yard : Cutout Tree 2       3x3   5990801 2093784 37.7286029699614 -122.474080817952 (37.7286029699614, -122.474080817952) 9 8 4 64 40
2183 117295 6 17 130 CAMBON DR 1 Side Yard : Yard Tree 2       3x3   5990450 2089482 37.7167704112637 -122.474980331165 (37.7167704112637, -122.474980331165) 1 8 4 64 14
12152 255704 6 41 201X Hernandez Ave 1 Side Yard : Yard Tree 2       10x10   5995122 2099706 37.7451126829106 -122.459571712369 (37.7451126829106, -122.459571712369) 1 8 4 59 40
26477 253808 6 17 2 Garfield St 2 Side Yard : Yard Tree 2   09/14/2018 12:00:00 AM 3 10x10 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
48743 253145 6 36 801X Santiago St 1 Side Yard : Yard Tree 2           5990274 2099728 37.7448931297685 -122.476336677657 (37.7448931297685, -122.476336677657) 1 8 3 29491 35
63888 254137 6 15 1619 47th Ave 1 Side Yard : Yard Tree 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
69528 253807 6 93 2 Garfield St 1 Side Yard : Yard Tree 2       10x2 Permit Number 780744 5993976 2090624 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037) 9 8 6 64 24
76823 255913 6 41 121 San Marcos Ave 1 Side Yard : Yard Tree 2       10x10   5993694 2100263 37.7465598483618 -122.464549884035 (37.7465598483618, -122.464549884035) 1 8 4 29491 40
95557 114140 6 15 1200X JUNIPERO SERRA BLVD 5 Side Yard : Yard Tree 2   01/20/2017 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
95967 254201 6 17 55X Aerial Way 1 Side Yard : Yard Tree 2       10x10 Permit Number 781191 5992360 2102538 37.7527294198072 -122.469328234463 (37.7527294198072, -122.469328234463) 1 8 4 56 12
106870 117252 6 63 2500x 34TH AVE 2 Side Yard : Yard Tree 4       3x3   5985829 2097874 37.7395437603018 -122.491570003273 (37.7395437603018, -122.491570003273) 1 8 3 29491 35