trees

256 rows where qSpecies_id = 151 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
185697 69014 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2190 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1994 12:00:00 AM 0   Permit Number 33018 5982359.98589934 2100209.73898476 37.7457537141944 -122.503737083774 (37.7457537141944, -122.503737083774) 1 8 3 29491 35
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
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
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
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
99696 66392 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 736 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1991 12:00:00 AM     Permit Number 29518 6007726.21493711 2095490.25955401 37.7342538931553 -122.41568997407 (37.7342538931553, -122.41568997407) 2 7 7 28859 2
128399 66439 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 256 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/09/1991 12:00:00 AM     Permit Number 29583 6006068.54082746 2096076.77967326 37.7357710232065 -122.421462732945 (37.7357710232065, -122.421462732945) 2 7 7 28859 2
115516 69060 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 1254 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33068 5992404.85704232 2106915.96776858 37.7647527637413 -122.4694917724 (37.7647527637413, -122.4694917724) 11 8 11 56 12
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
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
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
131257 83949 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 4800 17TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM   3x3 Permit Number 50899 5998201 2105706 37.7617637654108 -122.449357332436 (37.7617637654108, -122.449357332436) 15 5 11 29492 9
177910 59774 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 460 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/24/1991 12:00:00 AM     Permit Number 29632 6007462.52860048 2096660.25076168 37.7374516058806 -122.416684481311 (37.7374516058806, -122.416684481311) 2 7 7 28859 2
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
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
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
122547 67014 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 26 Brighton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1992 12:00:00 AM     Permit Number 30369 5996236.04729315 2090068.29308484 37.7187138605807 -122.455023275935 (37.7187138605807, -122.455023275935) 9 8 6 28861 24
83403 9925 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2010 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/21/2008 12:00:00 AM 12 3x3   6005193.66561 2116589.42028 37.7920444900059 -122.425947239584 (37.7920444900059, -122.425947239584) 13 9 1 28858 27
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
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
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                    
87351 67921 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 136 Marsily St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31632 6004231.25027354 2095231.88967626 37.7333473817874 -122.427754784883 (37.7333473817874, -122.427754784883) 9 7 5 28861 25
98619 67938 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 86 Saint Mary's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31651 6004312.01802966 2095698.91217619 37.7346342889879 -122.427508808325 (37.7346342889879, -122.427508808325) 2 7 5 28861 2
100849 67916 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 28 Cuvier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31626 6003939.73244877 2095599.86834432 37.7343412731947 -122.428788866832 (37.7343412731947, -122.428788866832) 2 7 5 28861 25
111329 67925 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 118 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31638 6003735.12063535 2095135.9515003 37.7330558796375 -122.42946320321 (37.7330558796375, -122.42946320321) 9 7 5 28861 25
152979 59014 Permitted Site 7 Melaleuca ericifolia :: Heath Melaleuca 151 3758 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38904 6005263.8024452 2104318.31785235 37.7583549902775 -122.424831174315 (37.7583549902775, -122.424831174315) 2 4 5 28859 19
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
97256 87303 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 2426 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2008 12:00:00 AM 38 3x3 Permit Number 50313 6001931.96776 2117738.10536 37.7950136080408 -122.43731501379 (37.7950136080408, -122.43731501379) 13 9 1 57 27
97377 77990 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 8 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 9 7 6 28861 5
163496 77992 DPW Maintained 1 Melaleuca ericifolia :: Heath Melaleuca 151 163X London St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 04/01/2000 12:00:00 AM 16 3x3   6002837 2092721 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389) 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)
);