256 rows where qSpecies_id = 151

View and edit SQL

Neighborhoods (old)

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)
890 231975 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 3666 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6003943.14044 2103070.57421 37.7548542993098 -122.429309632052 (37.7548542993098, -122.429309632052) 2 4 5 28862 22
1406 75132 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 148X Paris St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   6002992.10347 2092540.72564 37.7258878789975 -122.431846767938 (37.7258878789975, -122.431846767938) 9 7 6 28861 5
1945 44489 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 16 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2001 12:00:00 AM 8   Permit Number 43794 6005364.27294 2093438.07689 37.7284859970226 -122.423710107629 (37.7284859970226, -122.423710107629) 9 7 6 28861 5
3370 67249 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 559 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1992 12:00:00 AM 5   Permit Number 30713 5983459.33471 2112007.07812 37.7782104457147 -122.500808022251 (37.7782104457147, -122.500808022251) 11 6 2 55 26
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
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
8770 231971 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 4098 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 3ft   6002611.76959 2101830.0379 37.7513726180492 -122.433825215284 (37.7513726180492, -122.433825215284) 2 4 5 28862 22
9740 75309 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 125 Excelsior Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   5 3x3   6002784.56496 2092514.51527 37.7258041440316 -122.432562342276 (37.7258041440316, -122.432562342276) 9 7 6 28861 5
9741 131187 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 13 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6001696.09346 2116629.35582 37.7919558582198 -122.438051712318 (37.7919558582198, -122.438051712318) 13 6 1 29490 27
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
10268 231965 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 799X Eugenia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   6007531.06073 2097759.54123 37.7404738690811 -122.416525379751 (37.7404738690811, -122.416525379751) 2 7 7 28859 2
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
14190 67936 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 78 Saint Mary's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31649                    
14893 69004 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2079 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1994 12:00:00 AM 0 3x3 Permit Number 33005 5982592.52058918 2100976.42518266 37.7478724914068 -122.502989774605 (37.7478724914068, -122.502989774605) 1 8 3 29491 35
15126 121049 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
16040 78382 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 606 Lisbon St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12     6001696.66297 2089972.42102 37.7187623714737 -122.436141300492 (37.7187623714737, -122.436141300492) 9 7 6 28861 5
16063 231976 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 3670 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6003921.45543 2103072.93083 37.7548595423439 -122.42938479289 (37.7548595423439, -122.42938479289) 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
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                      
18761 56456 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 141 Delmar St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/1992 12:00:00 AM     Permit Number 30464 5999359.80887308 2107414.28954328 37.7665205189943 -122.445472331181 (37.7665205189943, -122.445472331181) 15 5 5 29492 9
18805 78255 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 512 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6001977.46264 2090420.81734 37.7200095171006 -122.435202744616 (37.7200095171006, -122.435202744616) 9 7 6 28861 5
19381 70028 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 555 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5983452.32231 2112030.75964 37.7782750565666 -122.500834032057 (37.7782750565666, -122.500834032057) 11 6 2 55 26
19917 209292 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1466 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5993385.70012 2105501.91756 37.7609267888564 -122.465996561219 (37.7609267888564, -122.465996561219) 1 8 11 56 12
20236 131192 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1700 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6005755.68073 2116051.93764 37.7906004431923 -122.423964421545 (37.7906004431923, -122.423964421545) 13 9 1 28858 27
21835 65598 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 966 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/1990 12:00:00 AM     Permit Number 28500 6001950.73496364 2088338.48153862 37.7142903680478 -122.435146273727 (37.7142903680478, -122.435146273727) 9 7 6 28861 5
22053 49821 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2003 12:00:00 AM 7   Permit Number 46611 6012834.79813 2105677.969 37.7625130103804 -122.398742575008 (37.7625130103804, -122.398742575008) 14 3 8 28856 29
22314 231968 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 177 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6004880.9264 2095958.67753 37.735379707894 -122.425560380023 (37.735379707894, -122.425560380023) 2 7 5 28861 2
22799 101714 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 1240 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2           6006918 2119116 37.7990791449181 -122.420160405591 (37.7990791449181, -122.420160405591) 5 1 1 28858 32
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
24703 121054 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
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
25935 66407 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 533 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29534 6008039.98859373 2096389.06187115 37.7367394418447 -122.414668739511 (37.7367394418447, -122.414668739511) 2 7 7 28859 2
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
27044 49828 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X 18th St 10 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2003 12:00:00 AM 7   Permit Number 46611 6012702.02381 2105670.26876 37.7624844685969 -122.399201255332 (37.7624844685969, -122.399201255332) 14 3 8 28856 29
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
28120 131190 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2451 Steiner St 9 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6002262.78346 2116332.95188 37.7911742205576 -122.436069745025 (37.7911742205576, -122.436069745025) 13 9 1 29490 27
28265 231979 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 478 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002951.2565 2105388.22536 37.7611618104807 -122.43290540667 (37.7611618104807, -122.43290540667) 15 4 5 28862 3
29365 231964 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 332 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008801.63861 2097226.11377 37.7390805674202 -122.412094512652 (37.7390805674202, -122.412094512652) 10 7 7 28859 2
29959 45335 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1239 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2001 12:00:00 AM     Permit Number 44167 6013665.22038022 2106606.66789645 37.7651092465016 -122.39593550872 (37.7651092465016, -122.39593550872) 14 3 8 28856 29
30115 46922 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 174 Granville Way 2 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM     Permit Number 44977 5994451.42522147 2098637.59383586 37.7421405253127 -122.461812970424 (37.7421405253127, -122.461812970424) 1 8 4 59 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
31598 5809 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 25 Dukes Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/09/1998 12:00:00 AM 6 3X4   6016112.32175 2096327.0001 37.7370192646182 -122.386754585178 (37.7370192646182, -122.386754585178) 10 3 8 58 1
32169 231956 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 162 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6004841.81484 2095922.14472 37.7352771869788 -122.425693003951 (37.7352771869788, -122.425693003951) 2 7 5 28861 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
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
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
34596 66400 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 531 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29526 6007491.7583768 2096409.40123315 37.7367644721833 -122.416565655603 (37.7367644721833, -122.416565655603) 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
35390 60180 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 39 Dearborn St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1982 12:00:00 AM     Permit Number 19713 6005845.55661292 2105868.08575362 37.7626431308333 -122.422929354207 (37.7626431308333, -122.422929354207) 8 4 5 28859 19
37383 121052 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
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
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
41699 52773 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2380@ STEINER Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2006 12:00:00 AM 5   Permit Number 48816 6002179.59387 2117772.23813 37.7951214016938 -122.436460636263 (37.7951214016938, -122.436460636263) 13 9 1 57 17
41931 64823 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 324 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1989 12:00:00 AM     Permit Number 25832 6002281.26415206 2109593.58721525 37.7726706787738 -122.435523472346 (37.7726706787738, -122.435523472346) 15 5 11 29492 9
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
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
43103 209295 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2559 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5992040.53101 2098014.3866 37.7402902733651 -122.470103641773 (37.7402902733651, -122.470103641773) 1 8 4 59 40
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
43366 60181 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 45 Dearborn St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1982 12:00:00 AM     Permit Number 19714 6005847.32276765 2105836.20953391 37.7625557059029 -122.422920980075 (37.7625557059029, -122.422920980075) 8 4 5 28859 19
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
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
44026 45318 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 651 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2001 12:00:00 AM     Permit Number 44155 5993484.7456852 2090166.18126819 37.718824416648 -122.464540445707 (37.718824416648, -122.464540445707) 9 8 6 64 24
45505 231972 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 206 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003745.92075 2101014.04618 37.7491963890986 -122.429844992161 (37.7491963890986, -122.429844992161) 2 4 5 28862 22
45942 67106 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1422 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1992 12:00:00 AM     Permit Number 30521 5994302.05947846 2105826.4023092 37.7618705618217 -122.462850841683 (37.7618705618217, -122.462850841683) 1 5 11 56 12
45973 231978 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 3813 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004168.45878 2105381.57202 37.7612125052624 -122.428695150486 (37.7612125052624, -122.428695150486) 2 4 5 28862 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
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
48209 209293 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1416 07th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5993991.03354 2105859.32276 37.7619430335757 -122.463928938879 (37.7619430335757, -122.463928938879) 1 5 11 56 12
48519 131189 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 21 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6002000.17825 2116671.28438 37.792088271701 -122.4370025821 (37.792088271701, -122.4370025821) 13 6 1 29490 27
49220 7946 Landmark tree 11 Melaleuca ericifolia :: Heath Melaleuca 151 1701 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6005703.15328 2116043.32965 37.7905738421571 -122.424145551273 (37.7905738421571, -122.424145551273) 13 9 1 28858 27
49524 209294 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 246 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994759.39259 2090227.21808 37.7190654070329 -122.460138948468 (37.7190654070329, -122.460138948468) 9 8 6 28861 24
51034 64836 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 420 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/1989 12:00:00 AM     Permit Number 25845 6003164.08916748 2099517.74214557 37.745054922078 -122.431750153289 (37.745054922078, -122.431750153289) 2 7 5 63 22
51461 83403 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 24 Otsego Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2008 12:00:00 AM   3x3 Permit Number 50775 6000910.29193694 2092966.50207531 37.7269387297254 -122.439073931559 (37.7269387297254, -122.439073931559) 9 7 6 28861 25
51644 64810 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 718 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1989 12:00:00 AM     Permit Number 25813 6001878.33374757 2099742.03375236 37.7455978068181 -122.436212108036 (37.7455978068181, -122.436212108036) 2 7 5 63 22
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
52065 60182 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 64 Dearborn St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1982 12:00:00 AM     Permit Number 19715 6005801.28958409 2105727.07873438 37.7622534608678 -122.423072435179 (37.7622534608678, -122.423072435179) 8 4 5 28859 19
53276 37921 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1433 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/02/2002 12:00:00 AM     Permit Number 44597 6013051.43972244 2106572.53658415 37.7649813631667 -122.398056045773 (37.7649813631667, -122.398056045773) 14 3 8 28856 29
53579 66397 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 508 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29523 6007446.33784222 2096483.57459282 37.7369655813708 -122.416727947771 (37.7369655813708, -122.416727947771) 2 7 7 28859 2
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
58332 231961 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007544.54493 2097042.23546 37.7385050642556 -122.416427960701 (37.7385050642556, -122.416427960701) 2 7 7 28859 2
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
61575 49822 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1600X 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2003 12:00:00 AM 7   Permit Number 46611 6012816.10881 2105676.13284 37.7625069273679 -122.398807086097 (37.7625069273679, -122.398807086097) 14 3 8 28856 29
62954 103530 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 155 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x9   5993328.74433 2114475.40992 37.7855623136611 -122.466845895101 (37.7855623136611, -122.466845895101) 11 6 2 54 11
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
64919 65535 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 3811 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1996 12:00:00 AM     Permit Number 28426 6004188.15426377 2105377.14964975 37.7612014771427 -122.428626716937 (37.7612014771427, -122.428626716937) 2 4 5 28862 3
66509 67173 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 308 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30617 6006778.80431339 2096277.81486238 37.7363630429498 -122.419021324056 (37.7363630429498, -122.419021324056) 2 7 7 28859 2
67134 69042 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1315 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1994 12:00:00 AM     Permit Number 33049 5983966.84504954 2106204.15933041 37.7623070738116 -122.498623613567 (37.7623070738116, -122.498623613567) 1 8 3 56 35
67409 131191 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2451 Steiner St 14 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002287.41432 2116178.40828 37.7907512828973 -122.435973460016 (37.7907512828973, -122.435973460016) 13 9 1 29490 27
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
68621 64828 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 268 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/1989 12:00:00 AM     Permit Number 25837 6004831.1974382 2099031.73640655 37.7438148210139 -122.425950995798 (37.7438148210139, -122.425950995798) 2 7 5 63 22
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
70776 49472 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 3330@ VALENCIA 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/08/2003 12:00:00 AM     Permit Number 46397 6006124.66921915 2103195.53921104 37.7553206868527 -122.421774162179 (37.7553206868527, -122.421774162179) 2 4 5 28859 19
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
73861 64877 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 2578 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/27/1989 12:00:00 AM     Permit Number 25899 5989272.97531246 2097804.00173263 37.7395522287807 -122.479657246034 (37.7395522287807, -122.479657246034) 1 8 3 29491 35
74510 121050 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
74527 231974 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 138 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6004099.54085 2102284.63466 37.7527051471301 -122.428712732201 (37.7527051471301, -122.428712732201) 2 4 5 28862 22
76546 177523 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 321 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5998908.35184 2087935.66658 37.7130110981499 -122.44563295221 (37.7130110981499, -122.44563295221) 9 7 6 28861 25
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
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

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