trees
256 rows where qSpecies_id = 151 sorted by qLegalStatus_id
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 | ||
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 | |||
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 | |||
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 |
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 | |||
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 | |||||||||||||
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 | |||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 |
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 | |||
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 | ||
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 | |||
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 | |
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 | |
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 | |
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 | |||
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 | |||
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 | |
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 | |
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 | |
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 | |
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 | ||
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 | |||
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 | |||
135882 | 49824 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012781.37184 | 2105676.15617 | 37.7625050558738 | -122.398927231008 | (37.7625050558738, -122.398927231008) | 14 | 3 | 8 | 28856 | 29 | ||
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 | |
144783 | 47523 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 253 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 10 | Permit Number 45394 | 6001752.07719 | 2094109.13644 | 37.7301240051048 | -122.436245638924 | (37.7301240051048, -122.436245638924) | 9 | 7 | 6 | 28861 | 25 | |
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 |
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 | |||
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 | |
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 | |||
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 | |
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 | |||
153122 | 67227 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 807 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1992 12:00:00 AM | 6 | Permit Number 30686 | 5983524.12809 | 2110277.94013 | 37.7734665377075 | -122.500456000342 | (37.7734665377075, -122.500456000342) | 11 | 6 | 2 | 55 | 26 | |
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 | |
157444 | 49819 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012718.30127 | 2105671.30189 | 37.7624882124737 | -122.39914502972 | (37.7624882124737, -122.39914502972) | 14 | 3 | 8 | 28856 | 29 | ||
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 | |
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 | |||
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 | |
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 | |||
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 | |
164137 | 49823 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012798.82942 | 2105676.31317 | 37.7625064597174 | -122.398866862242 | (37.7625064597174, -122.398866862242) | 14 | 3 | 8 | 28856 | 29 | ||
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 | ||
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 | |
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 | |||
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 | |
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 | ||
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 |
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 | |||
174822 | 75386 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
174951 | 47805 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 51 Escondido Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2002 12:00:00 AM | 0 | Permit Number 45573 | 5986262.03154998 | 2096094.88833599 | 37.7346840880203 | -122.489941970727 | (37.7346840880203, -122.489941970727) | 1 | 8 | 3 | 64 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );