356 rows where qSpecies_id = 91 sorted by Supervisor Districts

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts ▼ Zip Codes Neighborhoods (old)
6247 20077 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY55 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
8265 19714 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY13 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 40ST                      
15670 19820 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY25 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 10ST                      
16158 19973 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY44 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 36                      
18879 19971 DPW Maintained 1 Schinus molle :: California Pepper 91 100 STAIRWAY44 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 15                      
20349 124365 DPW Maintained 1 Schinus molle :: California Pepper 91 69 Palm Ave 4 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   5995847.94198 2114000.61223 37.7844037185844 -122.458095888318 (37.7844037185844, -122.458095888318) 11 6 1 54 31
31200 53044 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/10/2006 12:00:00 AM 11 3x3 Permit Number 49022 6000981.43692 2118569.50402 37.797242328631 -122.440663646636 (37.797242328631, -122.440663646636) 13 9 1 57 17
34897 136370 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6000983.74683 2118556.26599 37.7972061120278 -122.440654703763 (37.7972061120278, -122.440654703763) 13 9 1 57 17
43385 136376 DPW Maintained 1 Schinus molle :: California Pepper 91 2880 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   5999781.6675 2117438.62155 37.7940688297731 -122.444733809114 (37.7940688297731, -122.444733809114) 13 9 1 57 27
46065 136368 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000986.41607 2118529.18744 37.797131913463 -122.440643524276 (37.797131913463, -122.440643524276) 13 9 1 57 17
52524 136373 DPW Maintained 1 Schinus molle :: California Pepper 91 2858 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   5999883.33678 2117451.31751 37.7941094908262 -122.444382936819 (37.7941094908262, -122.444382936819) 13 9 1 57 27
61318 136374 DPW Maintained 1 Schinus molle :: California Pepper 91 2858 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   5999876.11536 2117451.30478 37.7941090438496 -122.444407922699 (37.7941090438496, -122.444407922699) 13 9 1 57 27
95494 136372 DPW Maintained 1 Schinus molle :: California Pepper 91 2005 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5999418.04323 2115732.63691 37.7893638888782 -122.445869229291 (37.7893638888782, -122.445869229291) 13 6 1 29490 31
98928 136366 DPW Maintained 1 Schinus molle :: California Pepper 91 2323 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6001763.72183 2119055.52403 37.7986213292711 -122.437991580064 (37.7986213292711, -122.437991580064) 13 9 1 57 17
107727 136369 DPW Maintained 1 Schinus molle :: California Pepper 91 2945 Scott St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6000984.79842 2118544.66291 37.7971743129098 -122.440650232318 (37.7971743129098, -122.440650232318) 13 9 1 57 17
132367 69363 DPW Maintained 1 Schinus molle :: California Pepper 91 3524 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1994 12:00:00 AM 12   Permit Number 33457 6002667.84891 2120741.39075 37.8033016521051 -122.434983652687 (37.8033016521051, -122.434983652687) 13 9 1 57 17
133494 136375 DPW Maintained 1 Schinus molle :: California Pepper 91 2880 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   5999802.94718 2117441.8408 37.7940788832989 -122.44466041095 (37.7940788832989, -122.44466041095) 13 9 1 57 27
136874 136371 DPW Maintained 1 Schinus molle :: California Pepper 91 3518 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002669.28578 2120724.92735 37.8032565295236 -122.434977502225 (37.8032565295236, -122.434977502225) 13 9 1 57 17
148920 69361 DPW Maintained 1 Schinus molle :: California Pepper 91 3518 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/18/1994 12:00:00 AM 8   Permit Number 33455 6002672.47282 2120707.16348 37.8032079355658 -122.4349652022 (37.8032079355658, -122.4349652022) 13 9 1 57 17
187275 136365 DPW Maintained 1 Schinus molle :: California Pepper 91 2624 Greenwich St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 3ft   6000330.31034 2118901.65056 37.7981172142989 -122.442940566381 (37.7981172142989, -122.442940566381) 13 9 1 57 17
3391 122720 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008692.81337 2118287.13673 37.796903132994 -122.413960264957 (37.796903132994, -122.413960264957) 5 1 10 308 21
23970 136382 DPW Maintained 1 Schinus molle :: California Pepper 91 1015 Vallejo St 1 Front Yard : Yard Tree Private 2     14     6008613.87178 2118642.82165 37.7978753218528 -122.414258600758 (37.7978753218528, -122.414258600758) 5 1 10 308 21
40901 122721 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008692.81337 2118287.13673 37.796903132994 -122.413960264957 (37.796903132994, -122.413960264957) 5 1 10 308 21
48994 249781 DPW Maintained 1 Schinus molle :: California Pepper 91 119 Pfeiffer St 1 Back Yard : Yard Tree Private 2     9 Width 0ft   6010443.51385 2121141.6092 37.8048389819848 -122.408103813361 (37.8048389819848, -122.408103813361) 3 1 10 308 23
73636 136377 DPW Maintained 1 Schinus molle :: California Pepper 91 633 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009222.09013 2115205.65792 37.7884718549403 -122.41191097002 (37.7884718549403, -122.41191097002) 5 1 10 28852 21
81419 136381 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 2 Sidewalk: Curb side : Pot Tree Private 2     15 Width 3ft   6008695.6423 2118278.07408 37.7968784080765 -122.413949834731 (37.7968784080765, -122.413949834731) 5 1 10 308 21
141132 136380 DPW Maintained 1 Schinus molle :: California Pepper 91 1023 Broadway 1 Sidewalk: Curb side : Pot Tree Private 2     12 Width 3ft   6008680.39017 2118276.96424 37.7968745041214 -122.414002532311 (37.7968745041214, -122.414002532311) 5 1 10 308 21
153086 136379 DPW Maintained 1 Schinus molle :: California Pepper 91 1 Nob Hill Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 1ft   6009499.81555 2116296.95751 37.7914838769232 -122.411027191854 (37.7914838769232, -122.411027191854) 5 1 10 28857 21
158509 136378 DPW Maintained 1 Schinus molle :: California Pepper 91 1 Nob Hill Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6009539.87257 2116302.4428 37.7915011843851 -122.410888982239 (37.7915011843851, -122.410888982239) 5 1 10 28857 21
169751 249770 DPW Maintained 1 Schinus molle :: California Pepper 91 102 Pfeiffer St 1 Side Yard : Yard Tree Private 2     8 Width 0ft   6010494.56062 2121168.81632 37.8049165440205 -122.407929079557 (37.8049165440205, -122.407929079557) 3 1 10 308 23
319 96811 Permitted Site 7 Schinus molle :: California Pepper 91 356 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996379.5 2106960.2 37.7651031164685 -122.455747798641 (37.7651031164685, -122.455747798641) 15 5 11 29492 12
888 246022 DPW Maintained 1 Schinus molle :: California Pepper 91 625 Ashbury St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998964.2184 2108548.4801 37.769612128289 -122.446922226392 (37.769612128289, -122.446922226392) 15 5 11 29492 9
13181 239606 DPW Maintained 1 Schinus molle :: California Pepper 91 179 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5997457.76068 2107065.24918 37.7654533761877 -122.452025957451 (37.7654533761877, -122.452025957451) 15 5 11 29492 9
19961 142238 DPW Maintained 1 Schinus molle :: California Pepper 91 689 HAYES ST 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6004757.5201 2110863.998 37.776299246383 -122.427048334097 (37.776299246383, -122.427048334097) 7 9 11 28852 10
30132 62463 DPW Maintained 1 Schinus molle :: California Pepper 91 1906 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/17/1985 12:00:00 AM 9   Permit Number 22631 5999997.0295 2111289.4853 37.7771971847485 -122.443546707231 (37.7771971847485, -122.443546707231) 15 5 11 29490 16
32623 138856 DPW Maintained 1 Schinus molle :: California Pepper 91 601 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6004940.3956 2111052.9695 37.7768284552741 -122.426429175067 (37.7768284552741, -122.426429175067) 7 9 11 28852 10
36697 33682 DPW Maintained 1 Schinus molle :: California Pepper 91 417 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 8   Permit Number 37761 6005332.3776 2111131.0936 37.7770651154691 -122.425078750067 (37.7770651154691, -122.425078750067) 7 9 11 28852 10
51033 12258 DPW Maintained 1 Schinus molle :: California Pepper 91 601 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004950.99275 2110977.71573 37.7766224258639 -122.426387156922 (37.7766224258639, -122.426387156922) 7 9 11 28852 10
54807 136367 DPW Maintained 1 Schinus molle :: California Pepper 91 689 Hayes St 5 : Tree Private 2     16 Width 3ft   6004762.56149 2110859.02755 37.7762858838177 -122.427030540428 (37.7762858838177, -122.427030540428) 7 9 11 28852 10
55243 239585 DPW Maintained 1 Schinus molle :: California Pepper 91 838 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   5998709.19727 2107219.09568 37.7659474025784 -122.44770861806 (37.7659474025784, -122.44770861806) 15 5 11 29492 9
70623 138859 DPW Maintained 1 Schinus molle :: California Pepper 91 601 LAGUNA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6004948.1933 2110978.3343 37.7766239660594 -122.426396885095 (37.7766239660594, -122.426396885095) 7 9 11 28852 10
82801 239584 DPW Maintained 1 Schinus molle :: California Pepper 91 863 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5998665.55754 2107188.82134 37.7658617826328 -122.447857378524 (37.7658617826328, -122.447857378524) 15 5 11 29492 9
84224 239582 DPW Maintained 1 Schinus molle :: California Pepper 91 43 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5998416.52248 2107203.63932 37.765888231668 -122.448719802287 (37.765888231668, -122.448719802287) 15 5 11 29492 9
86676 214165 DPW Maintained 1 Schinus molle :: California Pepper 91 428 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5996451.80809 2106977.82649 37.7651556637169 -122.455498978198 (37.7651556637169, -122.455498978198) 15 5 11 29492 12
87765 247489 DPW Maintained 1 Schinus molle :: California Pepper 91 868 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6002408.5917 2109542.1708 37.7725367328675 -122.435079355167 (37.7725367328675, -122.435079355167) 15 5 11 29492 9
89257 33655 DPW Maintained 1 Schinus molle :: California Pepper 91 542 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM 22   Permit Number 37744 6004783.29295 2110728.72543 37.775929278336 -122.426949542114 (37.775929278336, -122.426949542114) 7 9 11 28852 10
89477 142226 DPW Maintained 1 Schinus molle :: California Pepper 91 542 LINDEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6004780.8856 2110726.6251 37.7759233752217 -122.426957720143 (37.7759233752217, -122.426957720143) 7 9 11 28852 10
95933 217745 DPW Maintained 1 Schinus molle :: California Pepper 91 641 Frederick St 2 : Tree Private 2     5 Width 3ft   5996420.96236 2107271.42438 37.7659600380538 -122.45562688879 (37.7659600380538, -122.45562688879) 15 5 11 29492 12
97929 217735 DPW Maintained 1 Schinus molle :: California Pepper 91 723 Frederick St 1 : Tree Private 2     7 Width 3ft   5996116.65034 2107229.99676 37.7658288206775 -122.456676438985 (37.7658288206775, -122.456676438985) 15 5 11 29492 12
99586 117533 Undocumented 4 Schinus molle :: California Pepper 91 870 PAGE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6002404 2109622 37.7727556633357 -122.435100948925 (37.7727556633357, -122.435100948925) 15 5 11 29492 9
104806 12260 DPW Maintained 1 Schinus molle :: California Pepper 91 611 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 3X3   6004921 2111005 37.7766956463335 -122.426492853872 (37.7766956463335, -122.426492853872) 7 9 11 28852 10
108429 117357 DPW Maintained 1 Schinus molle :: California Pepper 91 602 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 3x3   6004937.66325 2110937.75927 37.7765119617013 -122.426430421921 (37.7765119617013, -122.426430421921) 7 9 11 28852 10
113901 12257 DPW Maintained 1 Schinus molle :: California Pepper 91 601 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004946.44345 2111002.77203 37.7766909671748 -122.426404678747 (37.7766909671748, -122.426404678747) 7 9 11 28852 10
126077 138851 DPW Maintained 1 Schinus molle :: California Pepper 91 602 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6004934.5518 2110939.3444 37.7765161381936 -122.426441298216 (37.7765161381936, -122.426441298216) 7 9 11 28852 10
128413 244460 DPW Maintained 1 Schinus molle :: California Pepper 91 690 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003277.2679 2109662.4318 37.7729162274022 -122.432083107592 (37.7729162274022, -122.432083107592) 15 9 11 29492 10
130978 20249 DPW Maintained 1 Schinus molle :: California Pepper 91 1880 Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/2000 12:00:00 AM 10 3X3   6002546.9119 2114591.5393 37.7864088846335 -122.43496207541 (37.7864088846335, -122.43496207541) 13 9 11 29490 27
148800 84811 Permitted Site 7 Schinus molle :: California Pepper 91 654 Shrader St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/20/2007 12:00:00 AM     Permit No. 49280 5997579.9 2108309.3 37.7688762175244 -122.451693255762 (37.7688762175244, -122.451693255762) 15 5 11 29492 9
152697 244482 DPW Maintained 1 Schinus molle :: California Pepper 91 235 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6001259.6239 2109499.111 37.7723531930337 -122.43905065598 (37.7723531930337, -122.43905065598) 15 5 11 29492 9
161220 244226 DPW Maintained 1 Schinus molle :: California Pepper 91 340 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6003259.6765 2109534.4722 37.7725638844758 -122.432134818626 (37.7725638844758, -122.432134818626) 15 9 11 29492 10
164670 217740 DPW Maintained 1 Schinus molle :: California Pepper 91 689 Frederick St 1 : Tree Private 2     5 Width 3ft   5996243.38999 2107249.52604 37.7658897191639 -122.456239488074 (37.7658897191639, -122.456239488074) 15 5 11 29492 12
168249 239583 DPW Maintained 1 Schinus molle :: California Pepper 91 857 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5998663.26171 2107205.3997 37.7659071714014 -122.447866512943 (37.7659071714014, -122.447866512943) 15 5 11 29492 9
177046 239605 DPW Maintained 1 Schinus molle :: California Pepper 91 217 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5997066.3771 2107014.18212 37.7652907329028 -122.453375969329 (37.7652907329028, -122.453375969329) 15 5 11 29492 12
179961 138858 DPW Maintained 1 Schinus molle :: California Pepper 91 601 LAGUNA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6004946.3367 2111001.3561 37.7766870733429 -122.426404947187 (37.7766870733429, -122.426404947187) 7 9 11 28852 10
182586 138852 DPW Maintained 1 Schinus molle :: California Pepper 91 604 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6004921.1795 2110937.9117 37.776511448416 -122.426487454824 (37.776511448416, -122.426487454824) 7 9 11 28852 10
184088 108112 Permitted Site 7 Schinus molle :: California Pepper 91 690 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003299.11292 2109682.74913 37.7729732522628 -122.432008994211 (37.7729732522628, -122.432008994211) 15 9 11 29492 10
189330 117358 DPW Maintained 1 Schinus molle :: California Pepper 91 602 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6004920.03397 2110936.25791 37.7765068427555 -122.426491299758 (37.7765068427555, -122.426491299758) 7 9 11 28852 10
18196 54018 DPW Maintained 1 Schinus molle :: California Pepper 91 850 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2020 12:00:00 AM 3 3x3 Permit Number 785014 5985129.09281 2110070.96029 37.7729923119367 -122.494889012959 (37.7729923119367, -122.494889012959) 11 6 2 55 26
26202 32764 Permitted Site 7 Schinus molle :: California Pepper 91 274 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM     Permit Number 37139 5995268.23997636 2113729.87048347 37.7836270090334 -122.460081822154 (37.7836270090334, -122.460081822154) 11 6 2 54 11
32012 35755 DPW Maintained 1 Schinus molle :: California Pepper 91 6838 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2   04/20/1998 12:00:00 AM 7   Permit Number 39022 5985827.97682 2112563.40957 37.7798767531698 -122.49265512383 (37.7798767531698, -122.49265512383) 11 6 2 55 26
37249 35756 DPW Maintained 1 Schinus molle :: California Pepper 91 6838 Geary Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2   04/20/1998 12:00:00 AM 8   Permit Number 39022 5985797.58958 2112563.51135 37.7798752557854 -122.492760252761 (37.7798752557854, -122.492760252761) 11 6 2 55 26
57476 55227 DPW Maintained 1 Schinus molle :: California Pepper 91 211 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/1972 12:00:00 AM 13   Permit Number 11145 5988668.09914 2113889.94192 37.7836846949952 -122.48292724876 (37.7836846949952, -122.48292724876) 11 6 2 55 26
109460 122117 DPW Maintained 1 Schinus molle :: California Pepper 91 141 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5990819.37104 2114444.89613 37.7853333844834 -122.475525275427 (37.7853333844834, -122.475525275427) 11 6 2 54 26
117755 35754 DPW Maintained 1 Schinus molle :: California Pepper 91 6838 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   04/20/1998 12:00:00 AM 7   Permit Number 39022 5985859.7786 2112565.45862 37.7798842387291 -122.492545259885 (37.7798842387291, -122.492545259885) 11 6 2 55 26
131504 68701 DPW Maintained 1 Schinus molle :: California Pepper 91 174 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/1993 12:00:00 AM 8   Permit Number 32613 5991836.39041 2114296.24984 37.7849841461432 -122.471995891724 (37.7849841461432, -122.471995891724) 11 6 2 54 11
159315 32765 Permitted Site 7 Schinus molle :: California Pepper 91 274 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM     Permit Number 37139 5995268.23997636 2113729.87048347 37.7836270090334 -122.460081822154 (37.7836270090334, -122.460081822154) 11 6 2 54 11
176454 103991 DPW Maintained 1 Schinus molle :: California Pepper 91 490 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 6X9   5992225.21796 2112091.38371 37.7789526802379 -122.470490047579 (37.7789526802379, -122.470490047579) 11 6 2 54 11
11956 72875 DPW Maintained 1 Schinus molle :: California Pepper 91 2506 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     5989254.9412 2098243.205 37.7407571191622 -122.47975172868 (37.7407571191622, -122.47975172868) 1 8 3 29491 35
59190 183549 DPW Maintained 1 Schinus molle :: California Pepper 91 2593 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5989226.3762 2097721.7265 37.7393236152619 -122.479812344828 (37.7393236152619, -122.479812344828) 1 8 3 29491 35
59784 45068 DPW Maintained 1 Schinus molle :: California Pepper 91 2227 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/08/2001 12:00:00 AM 4   Permit Number 43949 5987902.9352 2100130.6194 37.7458608246267 -122.4845648054 (37.7458608246267, -122.4845648054) 1 8 3 29491 35
76751 49937 DPW Maintained 1 Schinus molle :: California Pepper 91 2591 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2003 12:00:00 AM 4   Permit Number 46696 5988296.2269 2097703.198 37.7392186595719 -122.483026991295 (37.7392186595719, -122.483026991295) 1 8 3 29491 35
101688 50158 DPW Maintained 1 Schinus molle :: California Pepper 91 1863@ ORTEGA 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2003 12:00:00 AM 4   Permit Number 46871 5985958.4054 2102559.7986 37.7524172606528 -122.491467392102 (37.7524172606528, -122.491467392102) 1 8 3 56 35
147452 183550 DPW Maintained 1 Schinus molle :: California Pepper 91 2593 23rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5989227.3726 2097702.4617 37.7392707770079 -122.479807490437 (37.7392707770079, -122.479807490437) 1 8 3 29491 35
159362 68308 DPW Maintained 1 Schinus molle :: California Pepper 91 2178 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM 0   Permit Number 32119 5981736.58109187 2100266.85539552 37.7458738657157 -122.505896923616 (37.7458738657157, -122.505896923616) 1 8 3 29491 35
13005 40812 Permitted Site 7 Schinus molle :: California Pepper 91 240 Maywood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1999 12:00:00 AM     Permit Number 41757 5994290.46519005 2095120.08849436 37.732473059968 -122.462114481375 (37.732473059968, -122.462114481375) 9 8 4 59 40
29837 214153 DPW Maintained 1 Schinus molle :: California Pepper 91 391 Santa Ana Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   5992476.67943 2094212.83068 37.7298773579434 -122.46831913414 (37.7298773579434, -122.46831913414) 9 8 4 59 40
34168 68064 Permitted Site 7 Schinus molle :: California Pepper 91 1911 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31801 5993434.8119843 2102472.74927138 37.7526123103472 -122.465606631992 (37.7526123103472, -122.465606631992) 1 8 4 29491 12
61023 46902 Permitted Site 7 Schinus molle :: California Pepper 91 1416 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44958 5990552.94389775 2105736.96364621 37.7614083342209 -122.47581088419 (37.7614083342209, -122.47581088419) 1 8 4 56 12
62891 214155 DPW Maintained 1 Schinus molle :: California Pepper 91 495 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   5993543.01566 2101855.50119 37.7509237457529 -122.46518761832 (37.7509237457529, -122.46518761832) 1 8 4 29491 40
71330 42296 Permitted Site 7 Schinus molle :: California Pepper 91 250 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM 7 4x5 Permit Number 42524 5999448.10009127 2093930.90110115 37.7295034375942 -122.444197952384 (37.7295034375942, -122.444197952384) 9 7 4 63 40
74800 214156 DPW Maintained 1 Schinus molle :: California Pepper 91 495 Pacheco St 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 6ft   5993555.55486 2101853.98601 37.7509203085364 -122.465144146879 (37.7509203085364, -122.465144146879) 1 8 4 29491 40
92722 37473 Permitted Site 7 Schinus molle :: California Pepper 91 1453 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44951 5992709.117019 2105576.23529487 37.7610917906482 -122.468341951453 (37.7610917906482, -122.468341951453) 1 8 4 56 12
99414 214166 DPW Maintained 1 Schinus molle :: California Pepper 91 25 Hazelwood Ave 1 Sidewalk: Curb side : Yard Tree Private 2     11 Width 3ft   5996590.09341 2093838.6494 37.729086671304 -122.454071648891 (37.729086671304, -122.454071648891) 9 7 4 28861 40
102833 214157 DPW Maintained 1 Schinus molle :: California Pepper 91 100 Vista Verde Ct 8 Sidewalk: Curb side : Yard Tree Private 2     9 Width 10ft   5999199.91271 2096059.32177 37.7353334179866 -122.445208921854 (37.7353334179866, -122.445208921854) 9 7 4 63 40
119469 214167 DPW Maintained 1 Schinus molle :: California Pepper 91 1911 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993435.67173 2102452.28847 37.7525561798324 -122.465602172524 (37.7525561798324, -122.465602172524) 1 8 4 29491 12
125113 214170 DPW Maintained 1 Schinus molle :: California Pepper 91 158 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   5999431.23761 2093723.53638 37.7289331003841 -122.444241352082 (37.7289331003841, -122.444241352082) 9 7 4 63 40
136689 214160 DPW Maintained 1 Schinus molle :: California Pepper 91 250 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   5999436.94421 2094022.09374 37.7297531948487 -122.44424306977 (37.7297531948487, -122.44424306977) 9 7 4 63 40
139364 29613 DPW Maintained 1 Schinus molle :: California Pepper 91 900X Junipero Serra Blvd 22 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   5991166.63654 2090933.64994 37.7207977908582 -122.472609073865 (37.7207977908582, -122.472609073865) 9 8 4 64 40
149656 40810 Permitted Site 7 Schinus molle :: California Pepper 91 240 Maywood Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   08/25/1999 12:00:00 AM     Permit Number 41757 5994290.46519005 2095120.08849436 37.732473059968 -122.462114481375 (37.732473059968, -122.462114481375) 9 8 4 59 40
154950 214159 DPW Maintained 1 Schinus molle :: California Pepper 91 711 Joost Ave 5 Sidewalk: Property side : Yard Tree Private 2     17     5997419.66265 2094969.48638 37.7322392132651 -122.451285300082 (37.7322392132651, -122.451285300082) 9 7 4 59 40
158611 214152 DPW Maintained 1 Schinus molle :: California Pepper 91 1414 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   5990551.39802 2105727.60563 37.7613825499841 -122.47581554727 (37.7613825499841, -122.47581554727) 1 8 4 56 12

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);