256 rows where qSpecies_id = 151 sorted by TreeID

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)
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
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
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
125727 105520 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 3851X Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994314 2113544 37.7830617285902 -122.463369610154 (37.7830617285902, -122.463369610154) 11 6 2 54 11
113343 113820 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 4101x 25TH ST 13 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 SFUSD   10 3x3   6002889 2101238 37.7497627495089 -122.43282423124 (37.7497627495089, -122.43282423124) 2 4 5 28862 22
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
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
100503 121051 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
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
160327 121053 Undocumented 4 Melaleuca ericifolia :: Heath Melaleuca 151 2650 Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006281 2119745 37.8007703072153 -122.422409360755 (37.8007703072153, -122.422409360755) 13 9 1 28858 32
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
78472 123457 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 607 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5995303.78835 2111399.35412 37.7772300773628 -122.459789972595 (37.7772300773628, -122.459789972595) 11 6 2 54 11
178828 131186 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6001413.74236 2116589.85963 37.7918313506904 -122.439025814797 (37.7918313506904, -122.439025814797) 13 6 1 29490 27
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
99923 131188 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2501 Jackson St 18 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001926.62889 2116662.37015 37.7920596147963 -122.437256424752 (37.7920596147963, -122.437256424752) 13 6 1 29490 27
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
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
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
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
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
84565 177524 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 151 London St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6002754.06698 2092583.57784 37.725992044773 -122.432672702599 (37.725992044773, -122.432672702599) 9 7 6 28861 5
106884 177525 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 100 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006897.82744 2093555.37403 37.7288945185586 -122.418416832071 (37.7288945185586, -122.418416832071) 9 3 7 309 5
85647 193531 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 200 Jennings St 4 : Tree Private 2     3 Width 3ft   6018621.46299 2096962.90365 37.7389039297614 -122.378123392174 (37.7389039297614, -122.378123392174) 10 3 8 58 1
174781 193532 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 200 Jennings St 7 : Tree Private 2     2 Width 3ft   6018580.21539 2096908.74747 37.7387529542923 -122.378262250201 (37.7387529542923, -122.378262250201) 10 3 8 58 1
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
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
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
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
173277 231946 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 301 Webster St 6 : Tree Private 2     3 Width 3ft   6004139.43859 2109828.95399 37.7734222994207 -122.429112631967 (37.7734222994207, -122.429112631967) 7 9 11 29492 10
159201 231947 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 1101 San Jose Ave 64 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   6005025.65555 2096592.3987 37.7371279405099 -122.425105073942 (37.7371279405099, -122.425105073942) 2 7 5 28859 2
161821 231948 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 365 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6007200.80171 2096289.89745 37.7364199734891 -122.417563155128 (37.7364199734891, -122.417563155128) 2 7 7 28859 2
192447 231949 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 385 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007831.76681 2105714.97927 37.7623346100862 -122.416048903649 (37.7623346100862, -122.416048903649) 8 4 7 28859 19
146596 231950 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 703 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007343.45792 2103120.91973 37.7551844539259 -122.417553926284 (37.7551844539259, -122.417553926284) 2 4 7 28859 19
178945 231951 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 171 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006481.13342 2105135.05865 37.7606662525548 -122.42067907849 (37.7606662525548, -122.42067907849) 2 4 7 28859 19
177128 231952 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 195 Lexington St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006488.33791 2105047.80636 37.7604270841668 -122.420647967328 (37.7604270841668, -122.420647967328) 2 4 7 28859 19
106210 231953 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 195 Lexington St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006489.5205 2105029.86683 37.7603778930513 -122.420642603769 (37.7603778930513, -122.420642603769) 2 4 7 28859 19
135798 231954 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 215 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 3ft   6006180.99637 2101867.22963 37.751676631191 -122.421485034734 (37.751676631191, -122.421485034734) 2 4 5 28859 19
188557 231955 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 136 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004248.08815 2095120.37618 37.7330421432752 -122.42768862922 (37.7330421432752, -122.42768862922) 9 7 5 28861 25
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
181556 231957 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 643 28th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6001733.38367 2099398.81913 37.7446471838211 -122.436688759187 (37.7446471838211, -122.436688759187) 2 7 5 63 22
98723 231959 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007536.6214 2096940.11899 37.7382242293514 -122.416448125283 (37.7382242293514, -122.416448125283) 2 7 7 28859 2
99971 231960 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007542.74737 2097017.75117 37.7384377347063 -122.416432442006 (37.7384377347063, -122.416432442006) 2 7 7 28859 2
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
175004 231962 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007543.01124 2097062.2707 37.7385599903583 -122.416434682233 (37.7385599903583, -122.416434682233) 2 7 7 28859 2
91294 231963 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 500 Andover St 8 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007553.14308 2097114.00894 37.7387026219233 -122.416403314785 (37.7387026219233, -122.416403314785) 2 7 7 28859 2
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
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
106979 231966 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 189 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007085.27173 2097974.9068 37.7410401344022 -122.418082011786 (37.7410401344022, -122.418082011786) 2 7 7 28859 2
124362 231967 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 36 Gladys St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6005715.33692 2097471.12412 37.7395796596638 -122.422782959663 (37.7395796596638, -122.422782959663) 2 7 7 28859 2
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
167755 231969 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 78 Saint Marys Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004355.63348 2095669.80517 37.7345568345381 -122.427355942145 (37.7345568345381, -122.427355942145) 2 7 5 28861 2
162661 231970 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 541 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001866.38418 2102721.13376 37.7537770283888 -122.436466612253 (37.7537770283888, -122.436466612253) 2 4 5 28862 22
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
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
152389 231973 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 120 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 Width 3ft   6004325.56331 2101629.44898 37.7509189496627 -122.427884424232 (37.7509189496627, -122.427884424232) 2 4 5 28862 22
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
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
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
151858 231977 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 20 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003286.06563 2105669.78053 37.7619538776004 -122.431767549352 (37.7619538776004, -122.431767549352) 15 4 5 28862 3
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
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
124678 231980 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 48 Hartford St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002629.60405 2105594.78534 37.7617107251998 -122.434032629514 (37.7617107251998, -122.434032629514) 15 4 5 28862 3
105022 231981 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 91 Clover Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   6000469.66557 2104934.36895 37.7597745666642 -122.441455575241 (37.7597745666642, -122.441455575241) 2 4 5 28862 3
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
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
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                      
80939 30723 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 450 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34623 6004402.09076898 2109822.75168299 37.7734201339954 -122.428203638325 (37.7734201339954, -122.428203638325) 7 9 11 28852 10
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
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
116585 35845 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 478 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1998 12:00:00 AM 14   Permit Number 39072 6001935.45212 2090855.28224 37.7212000747131 -122.435379022551 (37.7212000747131, -122.435379022551) 9 7 6 28861 5
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
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
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
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
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
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
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
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
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
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
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
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
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
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
127670 45284 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 541 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44126 6008215.69383326 2096339.71567531 37.7366138182396 -122.414057758062 (37.7366138182396, -122.414057758062) 2 7 7 28859 2
123369 45291 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 678 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/13/2005 12:00:00 AM     Permit Number 47958 6007614.60724398 2096238.5150245 37.7363021643783 -122.416128813466 (37.7363021643783, -122.416128813466) 2 7 7 28859 2
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
82559 45319 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 671 Head St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/2001 12:00:00 AM     Permit Number 44156 5993486.1732944 2090289.68128716 37.7191636002321 -122.464544473629 (37.7191636002321, -122.464544473629) 9 8 6 64 24
168262 45325 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1385 Holloway Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2001 12:00:00 AM     Permit Number 44161 5991450.97971793 2091205.24216012 37.7215599710698 -122.471645977425 (37.7215599710698, -122.471645977425) 9 8 6 64 24
173866 45326 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1385 Holloway Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2001 12:00:00 AM     Permit Number 44161 5991450.97971793 2091205.24216012 37.7215599710698 -122.471645977425 (37.7215599710698, -122.471645977425) 9 8 6 64 24
153381 45327 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1385 Holloway Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2001 12:00:00 AM     Permit Number 44161 5991450.97971793 2091205.24216012 37.7215599710698 -122.471645977425 (37.7215599710698, -122.471645977425) 9 8 6 64 24
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
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
98615 46679 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1310 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/22/2002 12:00:00 AM     Permit Number 44809 5990528.41168502 2106454.94562806 37.76337829801 -122.475948167358 (37.76337829801, -122.475948167358) 1 8 3 56 12
120920 46820 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 470 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM 10   Permit Number 44898 6003678.47918 2090585.52708 37.7205582222597 -122.429334652987 (37.7205582222597, -122.429334652987) 9 7 6 28861 5
97669 46851 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 440 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM 8   Permit Number 44919 6003321.97716 2091035.01696 37.7217722323726 -122.430599024221 (37.7217722323726, -122.430599024221) 9 7 6 28861 5
135210 46920 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 174 Granville Way 3 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

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