256 rows where qSpecies_id = 151 sorted by PlantDate descending

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)
131792 67823 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 138 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1992 12:00:00 AM     Permit Number 31479 6004089.22123214 2102351.15512092 37.7528872126598 -122.428753160983 (37.7528872126598, -122.428753160983) 2 4 5 28862 22
166925 62359 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 183 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1992 12:00:00 AM     Permit Number 31493 6004713.1576588 2099557.75082014 37.7452524642677 -122.426396594795 (37.7452524642677, -122.426396594795) 2 7 5 63 22
180622 67834 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 614 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1992 12:00:00 AM     Permit Number 31496 6001920.673977 2099454.66622044 37.7448111687463 -122.43604514265 (37.7448111687463, -122.43604514265) 2 7 5 63 22
83465 68848 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 227 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32811 5999239.62014085 2094052.0632873 37.7298242245316 -122.444927391996 (37.7298242245316, -122.444927391996) 9 7 4 28861 40
114407 68863 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 152 Judson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32826 5999067.96340072 2093519.65088656 37.7283525462917 -122.445482558018 (37.7283525462917, -122.445482558018) 9 7 4 28861 40
146059 67909 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 124 Judson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1993 12:00:00 AM     Permit Number 32837 5999245.55939042 2093517.24429142 37.7283560753919 -122.444868429871 (37.7283560753919, -122.444868429871) 9 7 4 28861 40
168613 25930 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1940 Oakdale Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2008 12:00:00 AM 12 3x3   6013172.33562 2096908.97422 37.7384540331375 -122.396960298598 (37.7384540331375, -122.396960298598) 10 3 8 58 1
32738 66930 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 206 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1991 12:00:00 AM     Permit Number 30252 6007535.74955777 2097703.77171349 37.7403210020284 -122.41650521811 (37.7403210020284, -122.41650521811) 2 7 7 28859 2
71484 66923 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 196 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1991 12:00:00 AM     Permit Number 30244 6007541.39171999 2097769.00500385 37.740500435503 -122.416490329324 (37.740500435503, -122.416490329324) 2 7 7 28859 2
137851 66928 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 160 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1991 12:00:00 AM     Permit Number 30250 6007554.42782644 2097919.72536023 37.7409150133245 -122.416455928807 (37.7409150133245, -122.416455928807) 2 7 7 28859 2
164763 66919 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 256 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/18/1991 12:00:00 AM   3x3 Permit Number 30240 6007515.01387925 2097464.03098478 37.7396615608777 -122.416559935715 (37.7396615608777, -122.416559935715) 2 7 7 28859 2
144291 66433 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 118 Highland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1991 12:00:00 AM     Permit Number 29576 6005529.27345058 2096644.50573799 37.7372994514328 -122.423367539465 (37.7372994514328, -122.423367539465) 2 7 7 28859 2
32603 87041 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 735 07th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 4 3x3 Permit Number 49983 5993785.44399 2110433.89839 37.7744917610659 -122.464972234911 (37.7744917610659, -122.464972234911) 11 6 2 54 11
40483 87042 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 735 07th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 3 3x3 Permit Number 49983 5993785.1728 2110455.01638 37.7745497297907 -122.464974707047 (37.7745497297907, -122.464974707047) 11 6 2 54 11
116366 59096 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 735 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 3 3x3 Permit Number 49983 5993787.7809 2110375.019 37.7743302287246 -122.464959874093 (37.7743302287246, -122.464959874093) 11 6 2 54 11
141258 87040 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 735 07th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 4 3x3 Permit Number 49983 5993786.75747 2110417.02828 37.7744455159827 -122.4649664659 (37.7744455159827, -122.4649664659) 11 6 2 54 11
157761 87043 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 735 07th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2007 12:00:00 AM 4 3x3 Permit Number 49983 5993784.66357 2110476.13962 37.7746076992047 -122.464978002989 (37.7746076992047, -122.464978002989) 11 6 2 54 11
43590 66306 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 311 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29421 6000730.96676364 2094981.50970271 37.7324612706981 -122.439838262312 (37.7324612706981, -122.439838262312) 9 7 5 63 40
60513 66307 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 312 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29422 6000783.0417172 2094985.88569991 37.7324762502781 -122.439658540918 (37.7324762502781, -122.439658540918) 9 7 5 63 40
91979 66308 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 324 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29423 6000783.52973512 2095017.02999143 37.7325617930594 -122.439659085695 (37.7325617930594, -122.439659085695) 9 7 5 63 40
115628 66305 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 309 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29420 6000730.88542732 2094976.31898746 37.7324470135678 -122.439838171481 (37.7324470135678, -122.439838171481) 9 7 5 63 40
140306 57830 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 307 Baden St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29419 6000730.804091 2094971.1282722 37.7324327564376 -122.439838080651 (37.7324327564376, -122.439838080651) 9 7 5 63 40
154668 66320 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 221 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1990 12:00:00 AM     Permit Number 29437 6000609.84219196 2094923.1600046 37.7322941604972 -122.440252834618 (37.7322941604972, -122.440252834618) 9 7 4 63 40
67640 66893 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 201 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1991 12:00:00 AM     Permit Number 30211 6007590.04442076 2097728.05974103 37.7403907448612 -122.416319207408 (37.7403907448612, -122.416319207408) 2 7 7 28859 2
159388 66895 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 168 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1991 12:00:00 AM     Permit Number 30213 6007551.53091374 2097886.23194596 37.7408228849183 -122.4164635734 (37.7408228849183, -122.4164635734) 2 7 7 28859 2
170715 66902 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 280 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1991 12:00:00 AM     Permit Number 30220 6007505.06075356 2097348.955435 37.7393450290906 -122.416586199821 (37.7393450290906, -122.416586199821) 2 7 7 28859 2
177080 66906 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 219 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1991 12:00:00 AM 20 2x5 Permit Number 30224 6007582.57957611 2097641.75307421 37.7401533460797 -122.416338906472 (37.7401533460797, -122.416338906472) 2 7 7 28859 2
191295 66903 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 228 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1991 12:00:00 AM     Permit Number 30221 6007526.62585922 2097598.28579286 37.7400308479341 -122.416529293976 (37.7400308479341, -122.416529293976) 2 7 7 28859 2
34670 66326 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 135 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM     Permit Number 29445 6000528.81306712 2095194.53475792 37.7330346787859 -122.440552427184 (37.7330346787859, -122.440552427184) 9 7 5 63 40
103700 66325 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 131 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM     Permit Number 29444 6000554.87735499 2095194.20587313 37.7330352599042 -122.440462292733 (37.7330352599042, -122.440462292733) 9 7 5 63 40
131393 64147 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1620 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1987 12:00:00 AM     Permit Number 24926 6003320.75004876 2098798.13825464 37.7430879358174 -122.431157094729 (37.7430879358174, -122.431157094729) 2 7 5 63 22
25626 68823 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 306 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1993 12:00:00 AM     Permit Number 32772 5999450.43970514 2094100.18276953 37.729968379033 -122.444202023687 (37.729968379033, -122.444202023687) 9 7 4 63 40
188615 68833 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 178 Flood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/30/1993 12:00:00 AM     Permit Number 32784 5999570.75659197 2094098.77581282 37.7299713792854 -122.443785974037 (37.7299713792854, -122.443785974037) 9 7 4 63 40
32767 68798 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 2448 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1993 12:00:00 AM     Permit Number 32737 5992373.31469622 2098785.22580126 37.7424260349459 -122.469009103079 (37.7424260349459, -122.469009103079) 1 8 4 29491 40
47559 68789 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 2338 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/1993 12:00:00 AM     Permit Number 32726 5992037.40889194 2099520.42913846 37.7444253016329 -122.470224079807 (37.7444253016329, -122.470224079807) 1 8 4 29491 40
30587 47753 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 70 Homestead St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/15/2003 12:00:00 AM     Permit Number 45532 6000951.94406001 2101308.28424915 37.7498456794841 -122.439527672975 (37.7498456794841, -122.439527672975) 2 4 5 28862 22
123360 63780 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 220 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/11/1995 12:00:00 AM     Permit Number 24461 6003691.42811687 2101600.49522177 37.7508035549005 -122.430075258307 (37.7508035549005, -122.430075258307) 2 4 5 28862 22
23011 50535 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 799 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/2003 12:00:00 AM     Permit Number 47174 6003192.2245553 2109948.41523105 37.7736966455287 -122.432397711934 (37.7736966455287, -122.432397711934) 15 9 11 29492 10
23228 50536 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 799 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/06/2003 12:00:00 AM     Permit Number 47174 6003192.2245553 2109948.41523105 37.7736966455287 -122.432397711934 (37.7736966455287, -122.432397711934) 15 9 11 29492 10
84836 66660 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1500 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM   3x3 Permit Number 31265 6016229.06481316 2097072.60827917 37.7390730165912 -122.386402918839 (37.7390730165912, -122.386402918839) 10 3 8 58 1
119139 65406 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 555 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/03/1989 12:00:00 AM     Permit Number 28257 6008843.98828556 2114419.97110382 37.786293329177 -122.413163568484 (37.786293329177, -122.413163568484) 5 10 9 28852 36
85201 68664 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 211 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM     Permit Number 32571 5993343.03467885 2114079.66644038 37.7844765349697 -122.46676767712 (37.7844765349697, -122.46676767712) 11 6 2 54 11
106252 68686 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 128 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM     Permit Number 32596 5992134.97207697 2114599.88023196 37.7858351044588 -122.470985030783 (37.7858351044588, -122.470985030783) 11 6 2 54 11
179940 62390 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 259 Santa Rosa Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/26/1985 12:00:00 AM     Permit Number 22540 6000848.37769972 2093515.20006186 37.7284418053746 -122.439327280294 (37.7284418053746, -122.439327280294) 9 7 6 28861 25
132348 66258 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 30 Chaves Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1990 12:00:00 AM     Permit Number 29361 5996943.80390812 2098830.64453292 37.7428137596531 -122.453209085576 (37.7428137596531, -122.453209085576) 9 7 4 59 40
96084 64067 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 666 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/24/1987 12:00:00 AM     Permit Number 24827 6002225.57771541 2098886.88816265 37.7432695004337 -122.434950246577 (37.7432695004337, -122.434950246577) 2 7 5 63 22
137787 104161 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 138 ALPINE TER 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/2013 12:00:00 AM 12 3x3 Permit Number 770750 6001664 2107990 37.7682325491861 -122.437543793089 (37.7682325491861, -122.437543793089) 15 5 5 29492 3
47147 68648 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1935 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/1993 12:00:00 AM     Permit Number 32553 5990620.64023794 2102219.83857431 37.7517551651121 -122.475319963854 (37.7517551651121, -122.475319963854) 1 8 4 29491 12
120324 68556 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 753 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32445 5982266.13075099 2110637.89900645 37.7743809541883 -122.50483419911 (37.7743809541883, -122.50483419911) 11 6 2 55 26
63053 63989 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 445 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM     Permit Number 24735 6002297.0656458 2100886.57142057 37.7487642194423 -122.434846033464 (37.7487642194423, -122.434846033464) 2 4 5 28862 22
121517 254611 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 49 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1   10/05/2018 02:11:00 PM 3 3X3   6001570.75814 2091771.51604 37.7236951277094 -122.436705214986 (37.7236951277094, -122.436705214986) 9 7 6 28861 25
166161 63980 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 3666 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/05/1987 12:00:00 AM     Permit Number 24720 6003941.47141404 2103077.78156468 37.7548739945164 -122.429315917927 (37.7548739945164, -122.429315917927) 2 4 5 28862 22
16439 67516 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 327 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/22/1992 12:00:00 AM     Permit Number 31052 5997915.17390153 2093778.82856929 37.7289983088646 -122.449486452558 (37.7289983088646, -122.449486452558) 9 7 4 28861 40
167461 63972 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 337 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/19/1987 12:00:00 AM       6002987.03604686 2100924.44853758 37.7489073707234 -122.432462826172 (37.7489073707234, -122.432462826172) 2 4 5 28862 22
18660 264656 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1199 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/08/2020 04:53:00 PM   3x3                      
170005 67470 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 28 Agua Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM     Permit Number 30992 5997437.11856426 2098613.47951491 37.7422457393208 -122.451487690832 (37.7422457393208, -122.451487690832) 9 7 4 59 40
89977 56611 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 131 Chaves Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/01/1992 12:00:00 AM     Permit Number 30977 5996730.28293802 2098448.69823617 37.7417527884603 -122.453919799435 (37.7417527884603, -122.453919799435) 9 7 4 59 40
79837 65256 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1059 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28055 6009469.52961682 2103013.30669194 37.7550083744364 -122.410193718367 (37.7550083744364, -122.410193718367) 2 4 7 28859 19
136826 60207 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 3338 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1999 12:00:00 AM 7   Permit Number 19754 6007475 2101539 37.7508482631719 -122.416986935836 (37.7508482631719, -122.416986935836) 2 4 7 28859 19
43235 57575 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 30 Beverly St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1994 12:00:00 AM     Permit Number 16442 5991446.93129096 2089419.02625002 37.7166552263353 -122.471529877911 (37.7166552263353, -122.471529877911) 9 8 6 64 24
127221 53339 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 701 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1994 12:00:00 AM     Permit Number 6231 5992196.93740977 2089828.37078741 37.7178225482589 -122.468967276491 (37.7178225482589, -122.468967276491) 9 8 6 64 24
170769 53492 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 255 Ralston St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1994 12:00:00 AM     Permit Number 6402 5992175.72287884 2089558.97106605 37.7170816163747 -122.469021010071 (37.7170816163747, -122.469021010071) 9 8 6 64 24
6722 95806 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 570 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM 5 3x3 Permit Number 767550 6014847.40317 2105882.92079 37.7631876934897 -122.391795984023 (37.7631876934897, -122.391795984023) 14 3 8 28856 29
38518 95809 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 691 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM 4 3x3 Permit Number 767553 6015468.0632 2105845.97691 37.7631206885995 -122.389646729328 (37.7631206885995, -122.389646729328) 14 3 8 28856 29
145208 95813 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 691 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM 4 3x3 Permit Number 767553 6015467.36325 2105865.66469 37.7631747081784 -122.389650525366 (37.7631747081784, -122.389650525366) 14 3 8 28856 29
173003 95811 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 691 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2011 12:00:00 AM 4 3x3 Permit Number 767553 6015465.85735 2105884.27578 37.7632257267086 -122.389657033744 (37.7632257267086, -122.389657033744) 14 3 8 28856 29
42223 37689 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 385 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM     Permit Number 43282 6007841.95638313 2105703.00432184 37.7623023025462 -122.416012813552 (37.7623023025462, -122.416012813552) 8 4 7 28859 19
178401 64628 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 170 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/1988 12:00:00 AM     Permit Number 25537 6005392.70908858 2102720.91068508 37.7539761631805 -122.424271747549 (37.7539761631805, -122.424271747549) 2 4 5 28859 19
129396 64627 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 120 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1988 12:00:00 AM     Permit Number 25536 6005377.18111658 2103001.16489201 37.7547447992353 -122.424345378751 (37.7547447992353, -122.424345378751) 2 4 5 28859 19
125461 64589 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 3350 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/1988 12:00:00 AM     Permit Number 25490 6006008.81445181 2103189.70066891 37.7552981215573 -122.422174408546 (37.7552981215573, -122.422174408546) 2 4 5 28859 19
82588 66076 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1830 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM     Permit Number 29120 6008716.78878742 2119192.91553026 37.7993915237126 -122.413941412032 (37.7993915237126, -122.413941412032) 3 1 10 308 32
156905 66086 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 895 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/08/1990 12:00:00 AM     Permit Number 29130 6008704.72380049 2119330.26525123 37.7997679743153 -122.413992883013 (37.7997679743153, -122.413992883013) 3 1 10 308 32
124746 63645 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 749 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/01/1998 12:00:00 AM     Permit Number 24292 6000489.386797 2111504.70719641 37.777816196669 -122.441858942096 (37.777816196669, -122.441858942096) 15 5 11 29490 16
188020 87046 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 735@ 8th Ave 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/30/2010 12:00:00 AM 3 3x3 Permit Number 53657 5993787.03862 2110396.38433 37.7743888494182 -122.464963993756 (37.7743888494182, -122.464963993756) 11 6 2 54 11
78371 33939 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 378 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1989 12:00:00 AM     Permit Number 37898 6003089.72357803 2091687.1316724 37.72354963405 -122.431448393386 (37.72354963405, -122.431448393386) 9 7 6 28861 5
148871 63880 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 883 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24586 6003774.19132667 2103145.47595377 37.7550503955524 -122.429899247451 (37.7550503955524, -122.429899247451) 2 4 5 28862 22
149721 34268 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 166 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM 3   Permit Number 38071 5987436.71132 2114846.84684 37.7862403554066 -122.487257635976 (37.7862403554066, -122.487257635976) 11 6 1 55 33
51718 43139 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1 Gambier St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2000 12:00:00 AM 4   Permit Number 42953 6005713.11166 2093478.24293 37.7286159697368 -122.422507005398 (37.7286159697368, -122.422507005398) 9 7 7 309 5
96848 43137 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1 Gambier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM 7   Permit Number 42953 6005718.46144 2093462.75751 37.728573751977 -122.422487410986 (37.728573751977, -122.422487410986) 9 7 7 309 5
152379 43141 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 45 Gambier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM 10   Permit Number 42954 6005755.19133 2093338.41647 37.7282344107702 -122.422351602551 (37.7282344107702, -122.422351602551) 9 7 7 309 5
161958 43169 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 351 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2000 12:00:00 AM 6   Permit Number 42978 6005826.41516 2092089.07714 37.7248080153712 -122.422016663551 (37.7248080153712, -122.422016663551) 9 7 7 309 5
165181 43138 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1 Gambier St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/11/2000 12:00:00 AM 4   Permit Number 42953 6005709.81909 2093489.20943 37.7286458955884 -122.422519166951 (37.7286458955884, -122.422519166951) 9 7 7 309 5
42735 63835 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 480 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24525 6007455.04270761 2096578.56376841 37.737226890345 -122.416704578376 (37.737226890345, -122.416704578376) 2 7 7 28859 2
77589 63838 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 310 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24529 6007512.21907746 2097215.58579661 37.7389792281053 -122.416552004438 (37.7389792281053, -122.416552004438) 2 7 7 28859 2
172297 63837 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 443 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24528 6007534.27332128 2096872.17856811 37.7380375478753 -122.416451432701 (37.7380375478753, -122.416451432701) 2 7 7 28859 2
184194 63836 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 449 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1987 12:00:00 AM     Permit Number 24527 6007531.71339338 2096844.47873768 37.7379613462812 -122.416458322142 (37.7379613462812, -122.416458322142) 2 7 7 28859 2
9879 63777 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 118 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24458 6004354.0616299 2101637.06942721 37.7509414857928 -122.427786417218 (37.7509414857928, -122.427786417218) 2 4 5 28862 22
125608 63771 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 590 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24450 6003156.31583287 2110278.10733635 37.7745998623789 -122.432545479611 (37.7745998623789, -122.432545479611) 15 9 11 29492 10
192102 37860 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 147 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/1998 12:00:00 AM 13 6x8 Permit Number 40147 6003940.89934 2092950.10622 37.7270656869264 -122.428596014613 (37.7270656869264, -122.428596014613) 9 7 6 28861 5
43632 48013 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1991 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45735 5991253.49588687 2101875.72214117 37.7508469733877 -122.473106392758 (37.7508469733877, -122.473106392758) 1 8 4 29491 12
167774 42973 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 538 Cambridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM 8   Permit Number 42858 6007050.21421 2092033.4761 37.7247242929748 -122.4177821868 (37.7247242929748, -122.4177821868) 9 7 7 309 28
14127 45367 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 546 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2001 12:00:00 AM     Permit Number 44192 6007805.03016333 2096352.99475391 37.7366272057089 -122.415478542826 (37.7366272057089, -122.415478542826) 2 7 7 28859 2
6623 42595 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1950 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 5   Permit Number 42667 6005494.51102 2116553.24353 37.7919621552701 -122.424903735525 (37.7919621552701, -122.424903735525) 13 9 1 28858 27
28039 42596 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1950 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2000 12:00:00 AM 11 3x3 Permit Number 42667 6005477.78345 2116550.81967 37.7919545551073 -122.424961440544 (37.7919545551073, -122.424961440544) 13 9 1 28858 27
110307 42646 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X GREEN ST 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 10 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
154741 42598 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1961 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 14   Permit Number 42668 6005388.01706 2116488.54152 37.7917784840479 -122.425267599417 (37.7917784840479, -122.425267599417) 13 9 1 28858 27
166834 42645 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X GREEN ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 06/26/2000 12:00:00 AM 6 3x3   6005364 2118556 37.7974538454152 -122.425497899433 (37.7974538454152, -122.425497899433) 13 9 1 57 17
55302 42355 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 14 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 9 8x90 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
70737 42344 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 380X Flood Ave 3 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 06/23/2000 12:00:00 AM 8 8x45 Permit Number 42547 5998132.77434913 2094246.31790382 37.7302943698097 -122.448767853229 (37.7302943698097, -122.448767853229) 9 7 4 28861 40
26041 87359 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2127 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/22/2010 12:00:00 AM 2 3x3 Permit Number 53579 6012075.86217 2102321.0716 37.7532533954437 -122.401131582655 (37.7532533954437, -122.401131582655) 10 3 8 28856 29

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)
);