trees
3,267 rows where qSpecies_id = 67 sorted by Supervisor Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
336 | 189035 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010091.10409 | 2111787.20644 | 37.7791343146469 | -122.408663052281 | (37.7791343146469, -122.408663052281) | 14 | 2 | 9 | 28853 | 34 | |||
6660 | 189023 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010789.05197 | 2109573.65252 | 37.7730954749965 | -122.406092565024 | (37.7730954749965, -122.406092565024) | 14 | 2 | 9 | 28853 | 34 | ||
6771 | 43351 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 385 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1977 12:00:00 AM | 26 | 3x3 | Permit Number 43103 | 6010005.03169 | 2109964.91982 | 37.7741259209126 | -122.408832212936 | (37.7741259209126, -122.408832212936) | 8 | 2 | 9 | 28853 | 34 | |
10766 | 189037 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010129.26407 | 2111748.29533 | 37.7790296110535 | -122.408528295169 | (37.7790296110535, -122.408528295169) | 14 | 2 | 9 | 28853 | 34 | |||
10778 | 189038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010137.33918 | 2111739.58339 | 37.7790061423445 | -122.408499745276 | (37.7790061423445, -122.408499745276) | 14 | 2 | 9 | 28853 | 34 | |||
10999 | 31902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 965 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 14 | Permit Number 35327 | 6008027.66279 | 2109898.08591 | 37.7738314549808 | -122.415667565898 | (37.7738314549808, -122.415667565898) | 8 | 2 | 9 | 28853 | 34 | |
12381 | 65434 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/1999 12:00:00 AM | Permit Number 33170 | 6008638.12512872 | 2114173.69680574 | 37.785605560242 | -122.41385837708 | (37.785605560242, -122.41385837708) | 7 | 10 | 9 | 28852 | 36 | ||
12936 | 189036 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010111.83402 | 2111767.71706 | 37.7790819623998 | -122.408589963453 | (37.7790819623998, -122.408589963453) | 14 | 2 | 9 | 28853 | 34 | |||
16254 | 189034 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010058.78317 | 2111821.06751 | 37.7792254789148 | -122.408777253584 | (37.7792254789148, -122.408777253584) | 14 | 2 | 9 | 28853 | 34 | |||
16632 | 42238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010497.26908 | 2112250.8624 | 37.7804301450699 | -122.407290649051 | (37.7804301450699, -122.407290649051) | 14 | 2 | 9 | 28853 | 34 | |
17297 | 189039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010144.76793 | 2111731.54232 | 37.7789844794824 | -122.408473478765 | (37.7789844794824, -122.408473478765) | 14 | 2 | 9 | 28853 | 34 | |||
17841 | 107624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 467 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011064.4697 | 2111919.17259 | 37.7795511306237 | -122.405305061079 | (37.7795511306237, -122.405305061079) | 14 | 2 | 9 | 28853 | 34 | |||
20306 | 121801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6008572.2717 | 2110960.39862 | 37.7767789137416 | -122.413858829626 | (37.7767789137416, -122.413858829626) | 8 | 2 | 9 | 28853 | 34 | |||
20794 | 60190 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1982 12:00:00 AM | 10 | Permit Number 19735 | 6008544.7327 | 2110936.08659 | 37.776710612043 | -122.413952375309 | (37.776710612043, -122.413952375309) | 8 | 2 | 9 | 28853 | 34 | ||
23301 | 121802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 6008587.55783 | 2110975.09573 | 37.776820126979 | -122.413806990012 | (37.776820126979, -122.413806990012) | 8 | 2 | 9 | 28853 | 34 | ||||
26334 | 82890 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
29618 | 189028 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009991.59212 | 2111891.52885 | 37.7794151855119 | -122.409014669189 | (37.7794151855119, -122.409014669189) | 14 | 2 | 9 | 28853 | 34 | |||
38323 | 100251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 540 Delancey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6015234.41692 | 2113622.27838 | 37.7844597292764 | -122.390998376191 | (37.7844597292764, -122.390998376191) | 6 | 2 | 9 | 28856 | 6 | |||
40381 | 42165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 354 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.402562043425 | (37.7794657219919, -122.402562043425) | 14 | 2 | 9 | 28856 | 34 | ||
41108 | 189025 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010814.25369 | 2109596.96764 | 37.7731609024948 | -122.406007031421 | (37.7731609024948, -122.406007031421) | 14 | 2 | 9 | 28853 | 34 | ||
43263 | 189033 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010004.52225 | 2111908.19053 | 37.779461658872 | -122.408971114137 | (37.779461658872, -122.408971114137) | 14 | 2 | 9 | 28853 | 34 | |||
45547 | 189024 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010801.22197 | 2109583.73033 | 37.7731238270259 | -122.406051177336 | (37.7731238270259, -122.406051177336) | 14 | 2 | 9 | 28853 | 34 | ||
47135 | 189026 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010848.73344 | 2109624.73915 | 37.7732390850389 | -122.405889717541 | (37.7732390850389, -122.405889717541) | 14 | 2 | 9 | 28853 | 34 | ||
49535 | 188849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6010631.69356 | 2110389.62029 | 37.7753271309641 | -122.406694404849 | (37.7753271309641, -122.406694404849) | 8 | 2 | 9 | 28853 | 34 | |||
54750 | 81857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/24/2007 12:00:00 AM | 2 | 3x3 | Permit Number 49819 | 6013442.18813 | 2112205.75243 | 37.780470662242 | -122.397099557694 | (37.780470662242, -122.397099557694) | 6 | 2 | 9 | 28856 | 34 | |
60912 | 89040 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
65906 | 83449 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
66369 | 188856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 355 11th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6008743.51462 | 2108952.72037 | 37.7712759171908 | -122.413124449536 | (37.7712759171908, -122.413124449536) | 8 | 2 | 9 | 28853 | 34 | |||
67708 | 189044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007758.60706 | 2109046.49036 | 37.7714780470117 | -122.416537939674 | (37.7714780470117, -122.416537939674) | 8 | 2 | 9 | 28853 | 19 | |||
74588 | 67715 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.7815181053298 | -122.396258423594 | (37.7815181053298, -122.396258423594) | 6 | 2 | 9 | 28856 | 34 |
75123 | 42164 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | Permit Number 42459 | 6011853.6 | 2111898.2 | 37.7795376326187 | -122.40257363052 | (37.7795376326187, -122.40257363052) | 14 | 2 | 9 | 28856 | 34 | |||
75499 | 189027 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010574.88593 | 2112325.7775 | 37.7806401880397 | -122.40702741658 | (37.7806401880397, -122.40702741658) | 14 | 2 | 9 | 28853 | 34 | |||
78230 | 83448 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
85199 | 188855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Heron St | 3 | : | Tree | Private 2 | 11 | Width 2ft | 6010012.0343 | 2110035.42428 | 37.77431990198 | -122.408812964744 | (37.77431990198, -122.408812964744) | 8 | 2 | 9 | 28853 | 34 | |||
87196 | 89041 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
91611 | 65941 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 28962 | 6007255.62038472 | 2113291.4844342 | 37.7831054816789 | -122.418578871955 | (37.7831054816789, -122.418578871955) | 7 | 9 | 9 | 28852 | 36 | ||
94346 | 188852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 397 08th St | 2 | : | Tree | Private 2 | 22 | Width 3ft | 6010041.33013 | 2109925.85439 | 37.77402068943 | -122.408703893195 | (37.77402068943, -122.408703893195) | 8 | 2 | 9 | 28853 | 34 | |||
96914 | 83450 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
99179 | 82893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008675.9193 | 2110180.49816 | 37.774643311661 | -122.413445110902 | (37.774643311661, -122.413445110902) | 8 | 2 | 9 | 28853 | 34 | |
107416 | 189041 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010127.95445 | 2111781.19498 | 37.7791198724184 | -122.408535147085 | (37.7791198724184, -122.408535147085) | 14 | 2 | 9 | 28853 | 34 | |||
109238 | 188851 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 397 08th St | 1 | : | Tree | Private 2 | 22 | Width 3ft | 6010057.61121 | 2109905.66708 | 37.7739661716411 | -122.408646149513 | (37.7739661716411, -122.408646149513) | 8 | 2 | 9 | 28853 | 34 | |||
109302 | 189032 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010018.15477 | 2111897.569 | 37.7794332582881 | -122.408923203654 | (37.7794332582881, -122.408923203654) | 14 | 2 | 9 | 28853 | 34 | |||
111556 | 189043 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 70 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010322.24625 | 2111201.84362 | 37.7775399884207 | -122.407822145684 | (37.7775399884207, -122.407822145684) | 14 | 2 | 9 | 28853 | 34 | |||
112588 | 82741 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
118309 | 82892 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
119379 | 188857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Minna St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007556.32266 | 2109725.24267 | 37.7733303617494 | -122.417285761027 | (37.7733303617494, -122.417285761027) | 8 | 2 | 9 | 28853 | 19 | |||
123801 | 15228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
128587 | 189029 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010013.13639 | 2111867.58146 | 37.7793506384549 | -122.408938448056 | (37.7793506384549, -122.408938448056) | 14 | 2 | 9 | 28853 | 34 | |||
128724 | 89039 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
128802 | 82891 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
135264 | 42188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.406223676993 | (37.7730141185867, -122.406223676993) | 14 | 2 | 9 | 28853 | 34 | ||
142634 | 189042 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010077.81986 | 2111831.85617 | 37.7792561682811 | -122.408712158837 | (37.7792561682811, -122.408712158837) | 14 | 2 | 9 | 28853 | 34 | |||
143662 | 189020 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 525 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013269.599 | 2111809.84086 | 37.7793739704569 | -122.397668851936 | (37.7793739704569, -122.397668851936) | 6 | 2 | 9 | 28856 | 34 | |||
144953 | 15230 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
146417 | 188854 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Heron St | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6010001.1667 | 2110025.48762 | 37.7742920095037 | -122.408849856745 | (37.7742920095037, -122.408849856745) | 8 | 2 | 9 | 28853 | 34 | |||
146725 | 89038 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
148834 | 42235 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010547.8419 | 2112298.97398 | 37.7805650784617 | -122.407119085392 | (37.7805650784617, -122.407119085392) | 14 | 2 | 9 | 28853 | 34 | |
150453 | 82895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008648.23533 | 2110155.46088 | 37.7745730107591 | -122.413539104453 | (37.7745730107591, -122.413539104453) | 8 | 2 | 9 | 28853 | 34 | |
152630 | 89037 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 272 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51778 | 6014884 | 2115520 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | 6 | 2 | 9 | 28855 | 6 | |||
153789 | 189040 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010153.15667 | 2111754.38254 | 37.7790476631438 | -122.408446070136 | (37.7790476631438, -122.408446070136) | 14 | 2 | 9 | 28853 | 34 | |||
154339 | 28892 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 525 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6013279.98389 | 2111799.84006 | 37.7793470888229 | -122.397632224368 | (37.7793470888229, -122.397632224368) | 6 | 2 | 9 | 28856 | 34 | ||
155201 | 82946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52441 | 6008626.20144 | 2110135.25412 | 37.7745162905198 | -122.41361389477 | (37.7745162905198, -122.41361389477) | 8 | 2 | 9 | 28853 | 34 | |
155675 | 30673 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1018 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 7 | Permit Number 34598 | 6007663.01696 | 2109836.11415 | 37.7736407906294 | -122.416924546537 | (37.7736407906294, -122.416924546537) | 8 | 2 | 9 | 28853 | 19 | |
159951 | 43090 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 146 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | Permit Number 42926 | 6008611.57202226 | 2112975.23965235 | 37.7823133939911 | -122.413865436957 | (37.7823133939911, -122.413865436957) | 7 | 10 | 9 | 28852 | 36 | |||
169368 | 42187 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.406223676993 | (37.7730141185867, -122.406223676993) | 14 | 2 | 9 | 28853 | 34 | ||
170526 | 189022 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010767.85313 | 2109551.04982 | 37.7730322274755 | -122.406164302148 | (37.7730322274755, -122.406164302148) | 14 | 2 | 9 | 28853 | 34 | ||
170806 | 188850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6010617.59281 | 2110376.13956 | 37.7752893270638 | -122.406742232588 | (37.7752893270638, -122.406742232588) | 8 | 2 | 9 | 28853 | 34 | |||
172394 | 42237 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010511.20245 | 2112266.55567 | 37.7804740149056 | -122.407243553343 | (37.7804740149056, -122.407243553343) | 14 | 2 | 9 | 28853 | 34 | |
173024 | 29053 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 340 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008751.06899 | 2108844.78645 | 37.770979979973 | -122.413090685387 | (37.770979979973, -122.413090685387) | 8 | 2 | 9 | 28853 | 19 | ||
177519 | 188853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 385 08th St | 2 | : | Tree | Private 2 | 17 | Width 3ft | 6009987.41661 | 2109987.90496 | 37.7741880460757 | -122.408894768882 | (37.7741880460757, -122.408894768882) | 8 | 2 | 9 | 28853 | 34 | |||
181438 | 189021 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010755.67796 | 2109540.70716 | 37.7730031478998 | -122.406205688962 | (37.7730031478998, -122.406205688962) | 14 | 2 | 9 | 28853 | 34 | ||
181749 | 222496 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006343.14991 | 2109555.37804 | 37.7727956257483 | -122.42147023457 | (37.7727956257483, -122.42147023457) | 8 | 2 | 9 | 28853 | 19 | |||
185189 | 15229 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
185378 | 82894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52441 | 6008668.81492 | 2110175.98825 | 37.7746305296131 | -122.413469367432 | (37.7746305296131, -122.413469367432) | 8 | 2 | 9 | 28853 | 34 | |
186897 | 82990 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 737 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/18/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50125 | 6009298.17418 | 2110240.35937 | 37.7748425951352 | -122.411296828379 | (37.7748425951352, -122.411296828379) | 8 | 2 | 9 | 28853 | 34 | |
190348 | 42166 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 354 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011846.02554 | 2111882.36991 | 37.7794937439822 | -122.402598720465 | (37.7794937439822, -122.402598720465) | 14 | 2 | 9 | 28856 | 34 | ||
191017 | 189031 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010032.2441 | 2111878.47542 | 37.7793816210166 | -122.408873115008 | (37.7793816210166, -122.408873115008) | 14 | 2 | 9 | 28853 | 34 | |||
191984 | 7409 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010471.6875 | 2111110.743 | 37.7772982123977 | -122.407298752214 | (37.7772982123977, -122.407298752214) | 14 | 2 | 9 | 28853 | 34 | |||
192422 | 189030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010021.47788 | 2111859.88889 | 37.7793299837179 | -122.408909048327 | (37.7793299837179, -122.408909048327) | 14 | 2 | 9 | 28853 | 34 | |||
298 | 107634 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2431 24TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011247.3 | 2102253.3 | 37.7530210518745 | -122.403992166267 | (37.7530210518745, -122.403992166267) | 10 | 4 | 8 | 28859 | 19 | |||
1578 | 10783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
3736 | 38554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.7383941607708 | -122.392199668106 | (37.7383941607708, -122.392199668106) | 10 | 3 | 8 | 58 | 1 | |
4862 | 113857 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 SAN BRUNO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011184 | 2102716 | 37.7542879873687 | -122.40424363426 | (37.7542879873687, -122.40424363426) | 10 | 4 | 8 | 28859 | 19 | ||||
5159 | 83758 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1640 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013046.15855 | 2104759.52511 | 37.7600029395994 | -122.397947120176 | (37.7600029395994, -122.397947120176) | 10 | 3 | 8 | 28856 | 29 | |||
6333 | 189017 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1715 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014919.07097 | 2096583.11887 | 37.7376563776397 | -122.390898117058 | (37.7376563776397, -122.390898117058) | 10 | 3 | 8 | 58 | 1 | |||
6802 | 188921 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012543.15348 | 2101838.55647 | 37.751954571155 | -122.399481710736 | (37.751954571155, -122.399481710736) | 10 | 3 | 8 | 28856 | 29 | |||
7081 | 199881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1411 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015892.5426 | 2093410.4263 | 37.7289987677543 | -122.387311077708 | (37.7289987677543, -122.387311077708) | 10 | 3 | 8 | 58 | 1 | |||
7440 | 78070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 818 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011825.39206 | 2104537.71061 | 37.7593258220597 | -122.402153592937 | (37.7593258220597, -122.402153592937) | 10 | 3 | 8 | 28856 | 29 | |||
7441 | 101155 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400X 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013491.9 | 2105242.3 | 37.7613533485104 | -122.396439344349 | (37.7613533485104, -122.396439344349) | 10 | 3 | 8 | 28856 | 29 | |||
7526 | 54915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 491 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10781 | 6011237.02996 | 2106095.07508 | 37.7635691382211 | -122.404298060519 | (37.7635691382211, -122.404298060519) | 8 | 3 | 8 | 28856 | 29 | ||
7645 | 56389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.7277249515347 | -122.386350953513 | (37.7277249515347, -122.386350953513) | 10 | 3 | 8 | 58 | 1 | ||
7769 | 199923 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6017238.3952 | 2092867.7981 | 37.7275832604461 | -122.382620574427 | (37.7275832604461, -122.382620574427) | 10 | 3 | 8 | 58 | 1 | |||
8896 | 56726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1523 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 769408 | 6015773.2097 | 2095596.9346 | 37.7349958716637 | -122.387876131204 | (37.7349958716637, -122.387876131204) | 10 | 3 | 8 | 58 | 1 | |||
9504 | 74038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014092.75077 | 2101968.09189 | 37.7523964980076 | -122.394132008099 | (37.7523964980076, -122.394132008099) | 10 | 3 | 8 | 28856 | 1 | |||
9642 | 53732 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 11 | 3x3 | Permit Number 9411 | 6012636.58641 | 2095202.58654 | 37.7337388121015 | -122.398692955821 | (37.7337388121015, -122.398692955821) | 10 | 3 | 8 | 58 | 1 | |
10012 | 175625 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 22 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.7193210519043 | -122.409599906627 | (37.7193210519043, -122.409599906627) | 9 | 3 | 8 | 309 | 18 | |||
10062 | 199899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1829 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015967.4581 | 2093314.0277 | 37.7287382249947 | -122.387045366056 | (37.7287382249947, -122.387045366056) | 10 | 3 | 8 | 58 | 1 | |||
10420 | 105551 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6017214 | 2092838 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | 10 | 3 | 8 | 58 | 1 | |||
10973 | 10788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
11604 | 54558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 8 | Permit Number 10353 | 6012731.08144 | 2095469.91543 | 37.7344781060868 | -122.398385007285 | (37.7344781060868, -122.398385007285) | 10 | 3 | 8 | 58 | 1 |
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) );