trees

3,267 rows where qSpecies_id = 67 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts ▼ Supervisor Districts Zip Codes Neighborhoods (old)
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
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
140025 220768 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 46 Elgin Park 1 : Tree Private 2     6 Width 3ft   6005807.87841 2108828.68491 37.7707701060921 -122.423270135033 (37.7707701060921, -122.423270135033) 8 2 5 28853 19
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
148480 220769 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 46 Elgin Park 2 : Tree Private 2     7 Width 3ft   6005807.61785 2108816.0076 37.7707352825335 -122.423270135003 (37.7707352825335, -122.423270135003) 8 2 5 28853 19
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
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
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
3642 41464 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 51 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/06/2000 12:00:00 AM 6   Permit Number 42049 6010232.6367 2095048.38707 37.7331811829475 -122.406993296305 (37.7331811829475, -122.406993296305) 10 3 7 309 28
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
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
6979 42994 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 500 Yale St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2000 12:00:00 AM     Permit Number 42870 6007553.67502493 2091408.33369541 37.7230361052022 -122.415997529963 (37.7230361052022, -122.415997529963) 9 3 7 309 28
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
12140 260108 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 921 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008890 2090823 37.7215039438499 -122.411336776053 (37.7215039438499, -122.411336776053) 9 3 7 309 28
12851 188928 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2001 25th St 26 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6012639.77007 2101842.50365 37.7519707940373 -122.39914787158 (37.7519707940373, -122.39914787158) 10 3 8 28856 29
13274 188254 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1039 Jamestown Ave 5 Sidewalk: Curb side : Yard Tree Private 2     8     6013780.02718 2089753.49239 37.7188403408752 -122.39435831441 (37.7188403408752, -122.39435831441) 10 3 8 58 1
14798 199912 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1319 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6016381.1458 2093047.4167 37.728029062608 -122.385596634641 (37.728029062608, -122.385596634641) 10 3 8 58 1
14824 188911 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 2001 25th St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6012384.77523 2101833.46813 37.751931770655 -122.400029051595 (37.751931770655, -122.400029051595) 10 3 8 28856 29
14853 188956 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1706 La Salle Ave 1 : Tree Private 2     13 Width 3ft   6014961.30392 2096622.74747 37.7377675329349 -122.390754864938 (37.7377675329349, -122.390754864938) 10 3 8 58 1
15208 56135 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 719 Carolina St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/1973 12:00:00 AM 10   Permit Number 12238 6012444.68154 2104578.12119 37.7594713278533 -122.400014612979 (37.7594713278533, -122.400014612979) 10 3 8 28856 29
15502 78224 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1214 Bowdoin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6009704.84764 2090538.93921 37.7207696402774 -122.408500030351 (37.7207696402774, -122.408500030351) 9 3 7 309 28
15573 10975 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1468X Hudson Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016410.2814628 2096936.3836856 37.7387090009717 -122.385766856192 (37.7387090009717, -122.385766856192) 10 3 8 58 1
15816 26895 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1245X Lane St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4   6015870.9547371 2095407.1210845 37.7344800964063 -122.387524951 (37.7344800964063, -122.387524951) 10 3 8 58 1
16154 188901 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1640 20th St 2 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6013030.31907 2104757.32999 37.7599960301161 -122.39800174768 (37.7599960301161, -122.39800174768) 10 3 8 28856 29
16361 188907 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1551 19th St 3 : Tree Private 2     8 Width 3ft   6013010.92349 2105173.17566 37.7611367706692 -122.398098002138 (37.7611367706692, -122.398098002138) 10 3 8 28856 29
17440 188953 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1723 La Salle Ave 1 : Tree Private 2     12 Width 3ft   6014879.29111 2096612.07207 37.7377336698595 -122.391037679267 (37.7377336698595, -122.391037679267) 10 3 8 58 1
18481 37776 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 449 Felton St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/06/1998 12:00:00 AM     Permit Number 40114 6009618.93348363 2093468.47161568 37.7288087098037 -122.409003606238 (37.7288087098037, -122.409003606238) 10 3 7 309 28
18815 199909 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1335 Shafter Ave 1 Sidewalk: Curb side : Pot Tree Private 2     11 Width 0ft   6016305.1286 2093102.5016 37.7281761084423 -122.385863268846 (37.7281761084423, -122.385863268846) 10 3 8 58 1
19003 188986 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 98 Maddux Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012667.64033 2095215.60548 37.7337762895405 -122.398586505788 (37.7337762895405, -122.398586505788) 10 3 8 58 1
19471 188996 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1770 La Salle Ave 1 : Tree Private 2     9 Width 3ft   6014669.28207 2096840.44612 37.7383490822538 -122.391779751256 (37.7383490822538, -122.391779751256) 10 3 8 58 1
19634 53513 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1370 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/17/1973 12:00:00 AM 11   Permit Number 12550 6015991.6954 2093066.1456 37.7280589319949 -122.386944294451 (37.7280589319949, -122.386944294451) 10 3 8 58 1
19837 200793 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 1574 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6015536.4716 2095847.5097 37.7356707824742 -122.388712112413 (37.7356707824742, -122.388712112413) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);