trees
180 rows where qSpecies_id = 150
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
875 | 19954 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
1404 | 19975 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY45 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 30ST | |||||||||||||
1491 | 181698 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1801 Lincoln Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5990006.9617 | 2107176.8497 | 37.7653302032624 | -122.477804448514 | (37.7653302032624, -122.477804448514) | 1 | 8 | 3 | 56 | 35 | |||
1595 | 19920 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY36 | -2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1772 | 72077 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 140 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5989623.30395 | 2114484.58501 | 37.7853729513779 | -122.479666163956 | (37.7853729513779, -122.479666163956) | 11 | 6 | 2 | 55 | 26 | |||
1837 | 19878 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY33 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
2169 | 19944 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
2897 | 62561 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 263 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22761 | 6002735.54596737 | 2109434.34982555 | 37.7722592430025 | -122.433940680004 | (37.7722592430025, -122.433940680004) | 15 | 5 | 11 | 29492 | 9 | ||
6286 | 19771 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY17 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
7165 | 181321 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1801 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5990078.1902 | 2107177.6156 | 37.7653364397928 | -122.477558144457 | (37.7653364397928, -122.477558144457) | 1 | 8 | 3 | 56 | 35 | |||
7321 | 20302 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 50X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
7936 | 188547 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013501.25195 | 2102912.88665 | 37.754957806785 | -122.396243734071 | (37.754957806785, -122.396243734071) | 10 | 3 | 8 | 28856 | 29 | ||||
9811 | 181699 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1801 Lincoln Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5990039.1294 | 2107177.6156 | 37.7653341730561 | -122.477693245166 | (37.7653341730561, -122.477693245166) | 1 | 8 | 3 | 56 | 35 | |||
9985 | 19773 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY17 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 20ST | |||||||||||||
10494 | 62550 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 851 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22746 | 6002504.62213879 | 2109507.36231307 | 37.7724466097716 | -122.43474468697 | (37.7724466097716, -122.43474468697) | 15 | 5 | 11 | 29492 | 9 | ||
11264 | 74002 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 140 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989624.30976 | 2114465.16508 | 37.7853196881434 | -122.47966126275 | (37.7853196881434, -122.47966126275) | 11 | 6 | 2 | 55 | 26 | |||
11575 | 19874 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY33 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
12424 | 19961 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY41 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
14073 | 19821 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY25 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10ST | |||||||||||||
14871 | 188551 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013445.60553 | 2102908.48406 | 37.7549426217134 | -122.396435867938 | (37.7549426217134, -122.396435867938) | 10 | 3 | 8 | 28856 | 29 | ||||
15240 | 74217 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 140 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5989626.45991 | 2114449.60046 | 37.7852770769798 | -122.479652684717 | (37.7852770769798, -122.479652684717) | 11 | 6 | 2 | 55 | 26 | |||
15340 | 62553 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 932 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22750 | 6002100.93353536 | 2109504.64892618 | 37.7724162326817 | -122.436140888716 | (37.7724162326817, -122.436140888716) | 15 | 5 | 11 | 29492 | 9 | ||
16086 | 181700 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1801 Lincoln Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5990060.5745 | 2107178.3815 | 37.7653375205099 | -122.477619128372 | (37.7653375205099, -122.477619128372) | 1 | 8 | 3 | 56 | 35 | |||
17173 | 124764 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 138 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5997570.27212 | 2115851.1781 | 37.7895836921739 | -122.45227082935 | (37.7895836921739, -122.45227082935) | 11 | 6 | 1 | 54 | 31 | |||
17397 | 19895 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY33 | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
17450 | 19946 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY39 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 25ST | |||||||||||||
17793 | 19777 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 STAIRWAY18 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
19388 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
20756 | 96094 | Undocumented 4 | Acacia longifolia :: Golden Wattle 150 | 1524 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999743.8 | 2107236.2 | 37.7660534433338 | -122.444131380779 | (37.7660534433338, -122.444131380779) | 15 | 5 | 5 | 29492 | 9 | ||||
20937 | 124765 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 138 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997565.1935 | 2115884.13609 | 37.7896738950858 | -122.452290779906 | (37.7896738950858, -122.452290779906) | 11 | 6 | 1 | 54 | 31 | |||
21577 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
22213 | 188548 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013494.18064 | 2102912.22652 | 37.7549556007366 | -122.396268142573 | (37.7549556007366, -122.396268142573) | 10 | 3 | 8 | 28856 | 29 | ||||
22410 | 182140 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1414 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5988688.758 | 2105677.7715 | 37.7611375509737 | -122.482253913011 | (37.7611375509737, -122.482253913011) | 1 | 8 | 3 | 56 | 35 | |||
22571 | 220121 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 67 | Front Yard : Yard | Tree | Private 2 | 8 | 6005092.0847 | 2097087.14126 | 37.7384901445062 | -122.424910586579 | (37.7384901445062, -122.424910586579) | 2 | 7 | 5 | 63 | 7 | ||||
23013 | 62551 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 873 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22748 | 6002404.22700345 | 2109493.88447514 | 37.7724039027427 | -122.435090998906 | (37.7724039027427, -122.435090998906) | 15 | 5 | 11 | 29492 | 9 | ||
24584 | 188556 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6013320.20258 | 2102893.09045 | 37.7548933748448 | -122.396868470618 | (37.7548933748448, -122.396868470618) | 10 | 3 | 8 | 28856 | 29 | ||||
25182 | 30293 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 2101 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1956 12:00:00 AM | Permit Number 136 | 6003511.17021246 | 2117907.12338032 | 37.795567335959 | -122.431862816552 | (37.795567335959, -122.431862816552) | 13 | 9 | 1 | 29490 | 27 | |||
25860 | 244488 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1192 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6000913.4497 | 2109333.087 | 37.7718776296576 | -122.440236193644 | (37.7718776296576, -122.440236193644) | 15 | 5 | 11 | 29492 | 9 | |||
26055 | 21441 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2692X Sunset Blvd | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
26226 | 247413 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 963 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | Permit Number 782288 | 6001970.4339 | 2109438.2533 | 37.7722265117572 | -122.436587545425 | (37.7722265117572, -122.436587545425) | 15 | 5 | 11 | 29492 | 9 | ||
26761 | 124763 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 55 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998922.83859 | 2116354.04272 | 37.7910418169751 | -122.447627323869 | (37.7910418169751, -122.447627323869) | 13 | 6 | 1 | 54 | 31 | |||
27121 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
27746 | 54159 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 262 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 13 | Permit Number 9894 | 6012942.04708 | 2095291.83842 | 37.7340008934128 | -122.397643138528 | (37.7340008934128, -122.397643138528) | 10 | 3 | 8 | 58 | 1 | ||
28787 | 65914 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 431 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28924 | 5994447.75768828 | 2106990.5338514 | 37.7650753550186 | -122.462431373492 | (37.7650753550186, -122.462431373492) | 11 | 5 | 11 | 56 | 12 | ||
30455 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
32255 | 120027 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 5250 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5987077.12189 | 2109838.60933 | 37.7724681813772 | -122.488133553564 | (37.7724681813772, -122.488133553564) | 11 | 6 | 2 | 55 | 26 | |||
33671 | 247415 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 995 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001860.534 | 2109422.6502 | 37.7721774236453 | -122.436966580829 | (37.7721774236453, -122.436966580829) | 15 | 5 | 11 | 29492 | 9 | |||
34835 | 71106 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 4235 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/23/2015 07:32:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | 2 | 4 | 5 | 28862 | 3 | |
35757 | 220118 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000 San Jose Ave | 42 | Front Yard : Yard | Tree | Private 2 | 12 | 6005108.52091 | 2097145.57569 | 37.7386515206473 | -122.424857914163 | (37.7386515206473, -122.424857914163) | 2 | 7 | 5 | 63 | 7 | ||||
38129 | 114239 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1300x JUNIPERO SERRA BLVD | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||||
40967 | 63210 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 3601 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23753 | 5984371.56597884 | 2113133.02236934 | 37.7813554779566 | -122.497735487323 | (37.7813554779566, -122.497735487323) | 11 | 6 | 2 | 55 | 26 | ||
41079 | 6157 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1000X Ellis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005895.06272 | 2113497.50021 | 37.7835944591715 | -122.423300504237 | (37.7835944591715, -122.423300504237) | 7 | 9 | 11 | 28858 | 41 | |||
43781 | 188558 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013273.06711 | 2102892.5718 | 37.7548893269913 | -122.397031443052 | (37.7548893269913, -122.397031443052) | 10 | 3 | 8 | 28856 | 29 | ||||
44804 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
45212 | 254126 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1291 Bosworth St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000129 | 2096323 | 37.7361104052088 | -122.44201565285 | (37.7361104052088, -122.44201565285) | 2 | 7 | 5 | 63 | 7 | ||||
46207 | 101131 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1477 Grove St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000788.3 | 2110635.6 | 37.7754468763902 | -122.44076254186 | (37.7754468763902, -122.44076254186) | 15 | 5 | 11 | 29492 | 10 | ||||
47455 | 188552 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013433.23441 | 2102906.76929 | 37.7549372248775 | -122.396478530878 | (37.7549372248775, -122.396478530878) | 10 | 3 | 8 | 28856 | 29 | ||||
49488 | 188559 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6013256.52558 | 2102904.20918 | 37.7549203598944 | -122.397089464634 | (37.7549203598944, -122.397089464634) | 10 | 3 | 8 | 28856 | 29 | ||||
50068 | 86923 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 195 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49881 | 6004763 | 2102539 | 37.7534411018365 | -122.426436480741 | (37.7534411018365, -122.426436480741) | 2 | 4 | 5 | 28862 | 22 | |||
51132 | 85506 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 49678 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | ||||
53426 | 12824 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2201 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5 | 5988584.5219 | 2114647.39179 | 37.7857595743157 | -122.48327193233 | (37.7857595743157, -122.48327193233) | 11 | 6 | 2 | 55 | 26 | |||
54153 | 87313 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 230 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2008 12:00:00 AM | 3x3 | Permit Number 768785 | 6005882 | 2110375 | 37.7750200980063 | -122.423123675956 | (37.7750200980063, -122.423123675956) | 7 | 9 | 11 | 28852 | 10 | ||
57534 | 64732 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/28/1988 12:00:00 AM | Permit Number 25691 | 6001783.83117373 | 2109148.55885484 | 37.7714204770503 | -122.437212273367 | (37.7714204770503, -122.437212273367) | 15 | 5 | 11 | 29492 | 9 | ||
58313 | 62564 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 401 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22765 | 6001708.19271751 | 2109769.06982879 | 37.7731199456311 | -122.437518353384 | (37.7731199456311, -122.437518353384) | 15 | 5 | 11 | 29492 | 9 | ||
60011 | 85505 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009335 | 2098038 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | 10 | 7 | 7 | 28859 | 2 | |||||
61467 | 188560 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013253.43645 | 2102897.8837 | 37.7549028195293 | -122.397099704282 | (37.7549028195293, -122.397099704282) | 10 | 3 | 8 | 28856 | 29 | ||||
62078 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
63539 | 188544 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1501 22nd St | 15 | Front Yard : Yard | Tree | Private 2 | 12 | 6013369.71631 | 2103799.38115 | 37.757384608426 | -122.396760769601 | (37.757384608426, -122.396760769601) | 10 | 3 | 8 | 28856 | 29 | ||||
63575 | 44253 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1375 Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.384281551427 | (37.7404816352752, -122.384281551427) | 10 | 3 | 8 | 58 | 1 | |||
64708 | 188554 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013414.60293 | 2102900.51315 | 37.7549190100055 | -122.396542525734 | (37.7549190100055, -122.396542525734) | 10 | 3 | 8 | 28856 | 29 | ||||
64792 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard | Tree | Private 2 | 10 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
69552 | 19347 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 600 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5992459.1729484 | 2089876.0608299 | 37.7179686413438 | -122.468064319729 | (37.7179686413438, -122.468064319729) | 9 | 8 | 6 | 64 | 24 | |||
70416 | 12836 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2255 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2017 03:44:00 PM | 60 | 3x3 | 5988409.73159 | 2114642.30176 | 37.7857354248176 | -122.483876276617 | (37.7857354248176, -122.483876276617) | 11 | 6 | 2 | 55 | 26 | ||
70471 | 247305 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 873 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002334.5255 | 2109487.5806 | 37.7723826357595 | -122.435331651709 | (37.7723826357595, -122.435331651709) | 15 | 5 | 11 | 29492 | 9 | |||
71222 | 2429 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 319X Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6004581.20934 | 2109449.43359 | 37.7724052264427 | -122.427557439719 | (37.7724052264427, -122.427557439719) | 7 | 9 | 11 | 28852 | 10 | |||
71879 | 120392 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 735 24th Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5988458.4501 | 2110868.62788 | 37.7753768145809 | -122.483430984429 | (37.7753768145809, -122.483430984429) | 11 | 6 | 2 | 55 | 26 | ||||
72951 | 23661 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 308 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006889.9376932 | 2098288.2721449 | 37.7418895695178 | -122.418779625482 | (37.7418895695178, -122.418779625482) | 2 | 7 | 7 | 28859 | 2 | |||
73044 | 56310 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | Permit Number 21650 | 5993077.11990526 | 2114307.36148956 | 37.7850863731263 | -122.467704208587 | (37.7850863731263, -122.467704208587) | 11 | 6 | 2 | 54 | 11 | ||
74203 | 1916 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 11 Bell Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016651.8152009 | 2095266.4928857 | 37.734137178639 | -122.384815438972 | (37.734137178639, -122.384815438972) | 10 | 3 | 8 | 58 | 1 | |||
74665 | 23658 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 302 Virginia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1997 12:00:00 AM | 8 | 3X3 | 6006870.1278442 | 2098321.8073815 | 37.7419805343744 | -122.418850499491 | (37.7419805343744, -122.418850499491) | 2 | 7 | 7 | 28859 | 2 | ||
77670 | 106400 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 100 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x4 | 5989617.86074 | 2114578.87225 | 37.7856315213945 | -122.479691897092 | (37.7856315213945, -122.479691897092) | 11 | 6 | 2 | 55 | 26 | |||
78456 | 124766 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 138 Locust St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997561.15086 | 2115901.77792 | 37.7897221032522 | -122.452306040493 | (37.7897221032522, -122.452306040493) | 11 | 6 | 1 | 54 | 31 | |||
85297 | 65918 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1346 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1990 12:00:00 AM | Permit Number 28933 | 5994594.09113824 | 2106359.56698751 | 37.7633513097166 | -122.461879489309 | (37.7633513097166, -122.461879489309) | 15 | 5 | 11 | 56 | 12 | ||
85742 | 62544 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22739 | 6001803.31467833 | 2109086.42479932 | 37.7712509798957 | -122.437140429673 | (37.7712509798957, -122.437140429673) | 15 | 5 | 11 | 29492 | 9 | ||
87585 | 10279 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 321 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004595.17399 | 2109451.15702 | 37.7724107484201 | -122.42750925745 | (37.7724107484201, -122.42750925745) | 7 | 9 | 11 | 28852 | 10 | |||
88192 | 1711 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 5 Bass Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016572.54474 | 2095129.81679 | 37.7337575087508 | -122.385079984921 | (37.7337575087508, -122.385079984921) | 10 | 3 | 8 | 58 | 1 | |||
88490 | 188557 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1790 23rd St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 6013310.23031 | 2102900.17201 | 37.7549122641975 | -122.39690345423 | (37.7549122641975, -122.39690345423) | 10 | 3 | 8 | 28856 | 29 | ||||
88750 | 62552 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 925 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22749 | 6002145.34756636 | 2109458.3701838 | 37.7722916859717 | -122.435983944483 | (37.7722916859717, -122.435983944483) | 15 | 5 | 11 | 29492 | 9 | ||
94332 | 29878 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 1500X La Salle Ave | 12 | Median : Cutout | Tree | DPW 1 | 14 | 12x31 | 6015992.6911276 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | 10 | 3 | 8 | 58 | 1 | |||
98334 | 20270 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2290 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x3 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
98863 | 100365 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 450X Baker St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769344 | 6000745 | 2110655 | 37.7754976778855 | -122.44091371844 | (37.7754976778855, -122.44091371844) | 15 | 5 | 11 | 29492 | 10 | ||||
101683 | 44252 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 1375 Evans Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.384281551427 | (37.7404816352752, -122.384281551427) | 10 | 3 | 8 | 58 | 1 | |||
103757 | 99113 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2105 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | 6000888.78727 | 2115636.76287 | 37.7891845118984 | -122.440773756903 | (37.7891845118984, -122.440773756903) | 13 | 6 | 1 | 29490 | 27 | ||||
108542 | 62546 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 324 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22741 | 6001810.43023006 | 2109526.13327918 | 37.7724587144958 | -122.437147304211 | (37.7724587144958, -122.437147304211) | 15 | 5 | 11 | 29492 | 9 | ||
109646 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 150 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 5990948 | 2088640 | 37.7144873339183 | -122.473197635313 | (37.7144873339183, -122.473197635313) | 1 | 8 | 4 | 64 | 14 | ||||
110526 | 99111 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2105 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 6000887.06837 | 2115666.65288 | 37.7892664842201 | -122.440781849024 | (37.7892664842201, -122.440781849024) | 13 | 6 | 1 | 29490 | 27 | ||||
110890 | 122957 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 178 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993071.35373 | 2114313.86484 | 37.7851038966064 | -122.467724630713 | (37.7851038966064, -122.467724630713) | 11 | 6 | 2 | 54 | 11 | |||
115625 | 188542 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 900x Carolina St | 54 | Median : Yard | Tree | DPW 1 | 16 | 6012509.86374 | 2102962.70315 | 37.75503937799 | -122.399675754754 | (37.75503937799, -122.399675754754) | 10 | 3 | 8 | 28856 | 29 | ||||
119874 | 62548 | Permitted Site 7 | Acacia longifolia :: Golden Wattle 150 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/08/1986 12:00:00 AM | Permit Number 22743 | 6001791.89658849 | 2109658.78296356 | 37.7728218839519 | -122.437220913321 | (37.7728218839519, -122.437220913321) | 15 | 5 | 11 | 29492 | 9 | ||
119879 | 120360 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2420 Lake St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5987898.73747 | 2114688.56086 | 37.7858326787598 | -122.48564754506 | (37.7858326787598, -122.48564754506) | 11 | 6 | 1 | 55 | 33 |
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) );