Street_Tree_List

Data source: data.sfgov.org

3,264 rows where qSpecies = 28 sorted by SiteOrder descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder ▲ qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
147633 147633 204392 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 900 Junipero Serra Blvd 111 : 4 Tree 1 Private 1     2 Width 0ft   5991121.6593 2090321.7694700002 37.7191151143447 -122.47271995398 (37.7191151143447, -122.47271995398)
40952 40952 204391 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 900 Junipero Serra Blvd 97 : 4 Tree 1 Private 1     4 Width 0ft   5991142.0541199995 2090528.37768 37.7196835902046 -122.472664513466 (37.7196835902046, -122.472664513466)
185997 185997 204390 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 900 Junipero Serra Blvd 94 : 4 Tree 1 Private 1     5 Width 0ft   5991146.571880001 2090545.43725 37.719730693094796 -122.47265014049499 (37.7197306930948, -122.472650140495)
141527 141527 204542 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 76 Median : Cutout 11 Tree 1 DPW 2     10 Width 3ft   5999719.35071 2097204.76728 37.738508176809 -122.44349529248801 (37.738508176809, -122.443495292488)
136448 136448 204543 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 75 Median : Cutout 11 Tree 1 DPW 2     13 Width 3ft   5999719.20316 2097210.6996400002 37.7385244572495 -122.44349622866301 (37.7385244572495, -122.443496228663)
152488 152488 204544 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 74 Median : Cutout 11 Tree 1 DPW 2     16 Width 3ft   5999721.65299 2097224.39457 37.7385621999964 -122.443488741827 (37.7385621999964, -122.443488741827)
27066 27066 204545 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 73 Median : Cutout 11 Tree 1 DPW 2     15 Width 3ft   5999723.14356 2097244.03838 37.7386162222515 -122.44348499883999 (37.7386162222515, -122.44348499884)
186128 186128 204546 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 69 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999726.305480001 2097318.0909700003 37.738819733438504 -122.443479384359 (37.7388197334385, -122.443479384359)
54902 54902 204547 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 68 Median : Cutout 11 Tree 1 DPW 2     15 Width 5ft   5999723.97514 2097336.19746 37.738869316670204 -122.443488741839 (37.7388693166702, -122.443488741839)
180985 180985 204548 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 67 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999721.47669 2097346.22168 37.738896698316005 -122.443498100161 (37.738896698316, -122.443498100161)
180648 180648 204549 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 66 Median : Cutout 11 Tree 1 DPW 2     12 Width 5ft   5999718.509930001 2097359.75923 37.7389337000243 -122.44350932999 (37.7389337000243, -122.44350932999)
67188 67188 204553 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 64 Median : Cutout 11 Tree 1 DPW 2     14 Width 5ft   5999694.8834 2097395.01803 37.7390291648714 -122.443593551518 (37.7390291648714, -122.443593551518)
133892 133892 204554 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 63 Median : Cutout 11 Tree 1 DPW 2     17 Width 5ft   5999684.52262 2097404.39689 37.7390543260871 -122.443630047808 (37.7390543260871, -122.443630047808)
45970 45970 204550 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 62 Median : Cutout 11 Tree 1 DPW 2     12 Width 5ft   5999656.91248 2097430.30525 37.739123889545496 -122.44372737153499 (37.7391238895455, -122.443727371535)
136728 136728 204551 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 61 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999648.64901 2097436.4062 37.739140169982 -122.44375638096201 (37.739140169982, -122.443756380962)
26004 26004 204552 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 60 Median : Cutout 11 Tree 1 DPW 2     11 Width 5ft   5999641.44525 2097441.40723 37.7391534907361 -122.443781647414 (37.7391534907361, -122.443781647414)
68371 68371 204555 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 59 Median : Cutout 11 Tree 1 DPW 2     14 Width 5ft   5999635.81986 2097444.2193400003 37.7391608912586 -122.443801299384 (37.7391608912586, -122.443801299384)
134194 134194 204556 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 58 Median : Cutout 11 Tree 1 DPW 2     15 Width 5ft   5999628.6217 2097449.4898200002 37.739174952168206 -122.443826565843 (37.7391749521682, -122.443826565843)
146647 146647 204557 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 57 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999620.61184 2097454.77716 37.7391890130662 -122.443854640005 (37.7391890130662, -122.443854640005)
175385 175385 204558 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 56 Median : Cutout 11 Tree 1 DPW 2     13 Width 5ft   5999610.45434 2097460.9174599997 37.739205293478896 -122.44389020099399 (37.7392052934789, -122.443890200994)
174282 174282 204559 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 55 Median : Cutout 11 Tree 1 DPW 2     16 Width 5ft   5999606.142519999 2097461.8157099998 37.739207513906706 -122.443905173798 (37.7392075139067, -122.443905173798)
56579 56579 204560 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 54 Median : Cutout 11 Tree 1 DPW 2     16 Width 5ft   5999598.12734 2097466.8336099996 37.7392208346642 -122.443933247029 (37.7392208346642, -122.443933247029)
46636 46636 188264 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1322 Hudson Ave 53 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6017261.07145 2095318.2805299999 37.7343130553028 -122.382712629894 (37.7343130553028, -122.382712629894)
185560 185560 188263 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1322 Hudson Ave 52 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6017270.30063 2095300.86237 37.7342657383686 -122.382679509676 (37.7342657383686, -122.382679509676)
133038 133038 125868 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 50 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   6011397.07627 2120306.83138 37.80260023127779 -122.404745086537 (37.8026002312778, -122.404745086537)
131510 131510 125867 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 49 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6011400.22925 2120293.8654 37.802564806093294 -122.40473326224199 (37.8025648060933, -122.404733262242)
66335 66335 204517 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 48 Median : Cutout 11 Tree 1 DPW 2     17 Width 3ft   5998995.15377 2096935.4716400001 37.7377274276678 -122.445979843191 (37.7377274276678, -122.445979843191)
73337 73337 125866 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 48 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6011400.87154 2120290.44992 37.802555463919 -122.40473079899401 (37.802555463919, -122.404730798994)
38657 38657 204518 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 47 Median : Cutout 11 Tree 1 DPW 2     17 Width 3ft   5999003.37096 2096940.1521400001 37.737740748427704 -122.445951769058 (37.7377407484277, -122.445951769058)
47847 47847 125865 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 47 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6011401.82838 2120281.49833 37.8025309385205 -122.404726857271 (37.8025309385205, -122.404726857271)
159084 159084 188262 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1322 Hudson Ave 47 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6017323.3407 2095203.1701099998 37.7340004248815 -122.38248933632 (37.7340004248815, -122.38248933632)
131755 131755 125864 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 46 Median : Yard 3 Tree 1 DPW 2     11 Width 8ft   6011404.31889 2120270.9561400004 37.8025021314422 -122.404717496217 (37.8025021314422, -122.404717496217)
42569 42569 175629 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 44 Median : Cutout 11 Tree 1 DPW 2     17 Width 0ft   6009095.75789 2089908.2938299999 37.719003889795104 -122.410560964431 (37.7190038897951, -122.410560964431)
28651 28651 175628 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 43 Median : Cutout 11 Tree 1 DPW 2     9 Width 0ft   6009091.54392 2089913.6992400002 37.719018495673396 -122.41057591204701 (37.7190184956734, -122.410575912047)
152169 152169 204519 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 43 Median : Cutout 11 Tree 1 DPW 2     15 Width 3ft   5999085.31812 2096976.1812599998 37.7378443548231 -122.445671029498 (37.7378443548231, -122.445671029498)
39440 39440 175627 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 42 Median : Cutout 11 Tree 1 DPW 2     14 Width 0ft   6009089.91396 2089921.0786400002 37.7190386665864 -122.410582067034 (37.7190386665864, -122.410582067034)
153519 153519 204520 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 42 Median : Cutout 11 Tree 1 DPW 2     15 Width 3ft   5999096.78187 2096980.7946099997 37.7378576764863 -122.445631725539 (37.7378576764863, -122.445631725539)
162994 162994 188866 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 900x Carolina St 42 Median : Yard 3 Tree 1 DPW 2     9     6012505.62203 2103079.77232 37.7553605879327 -122.39969864337499 (37.7553605879327, -122.399698643375)
29288 29288 204521 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 41 Median : Cutout 11 Tree 1 DPW 2     15 Width 3ft   5999107.98616 2096985.95215 37.737872477539604 -122.445593357764 (37.7378724775396, -122.445593357764)
76804 76804 175626 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 41 Median : Cutout 11 Tree 1 DPW 2     12 Width 0ft   6009096.33692 2089936.65243 37.7190817890677 -122.410560964424 (37.7190817890677, -122.410560964424)
150115 150115 188865 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 900x Carolina St 41 Median : Yard 3 Tree 1 DPW 2     12     6012505.22674 2103087.46941 37.7553817004262 -122.39970055083401 (37.7553817004262, -122.399700550834)
44817 44817 204522 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 40 Median : Cutout 11 Tree 1 DPW 2     15 Width 3ft   5999115.3748 2096989.84123 37.7378835778536 -122.445568091304 (37.7378835778536, -122.445568091304)
45103 45103 204523 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 39 Median : Cutout 11 Tree 1 DPW 2     5 Width 3ft   5999123.85141 2096993.9772599998 37.7378954183401 -122.445539080959 (37.7378954183401, -122.445539080959)
30631 30631 205755 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 36 Median : Yard 3 Tree 1 DPW 2     5     5993878.86602 2096471.7721400002 37.7361607421118 -122.463635532375 (37.7361607421118, -122.463635532375)
30835 30835 204524 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 36 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   5999142.13445 2097001.14376 37.7379161396038 -122.445476382943 (37.7379161396038, -122.445476382943)
38482 38482 204525 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 35 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   5999144.59173 2097002.1709099999 37.7379191001944 -122.44546796078998 (37.7379191001944, -122.44546796079)
46065 46065 205754 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 35 Median : Yard 3 Tree 1 DPW 2     5     5993872.8693 2096472.5281599998 37.7361624724174 -122.46365632018 (37.7361624724174, -122.46365632018)
48438 48438 204526 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 34 Median : Cutout 11 Tree 1 DPW 2     10 Width 3ft   5999151.1241 2097003.92167 37.737924280281206 -122.445445501119 (37.7379242802812, -122.445445501119)
51953 51953 205753 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 34 Median : Yard 3 Tree 1 DPW 2     4     5993866.87232 2096473.28451 37.7361642036105 -122.463677108908 (37.7361642036105, -122.463677108908)
73197 73197 205752 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Terrace Dr 33 Median : Yard 3 Tree 1 DPW 2     5     5993857.73884 2096475.3667 37.7361693944936 -122.46370883791501 (37.7361693944936, -122.463708837915)
136443 136443 222181 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 500x 27th St 32 Median : Cutout 11 Tree 1 DPW 2     23 Width 4ft   6003013.920940001 2100069.89733 37.7465624978683 -122.432308835085 (37.7465624978683, -122.432308835085)
54400 54400 204527 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 31 Median : Cutout 11 Tree 1 DPW 2     3 Width 3ft   5999174.36675 2097015.2976799998 37.737956842928 -122.44536595789101 (37.737956842928, -122.445365957891)
56104 56104 222180 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 500x 27th St 31 Median : Cutout 11 Tree 1 DPW 2     15 Width 4ft   6003010.48164 2100075.576 37.7465778951541 -122.432321133307 (37.7465778951541, -122.432321133307)
74641 74641 205772 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 31 Median : Cutout 11 Tree 1 DPW 2     23 Width 5ft   5999313.6439 2097558.6392200002 37.7394566791949 -122.444923457253 (37.7394566791949, -122.444923457253)
29933 29933 188870 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1300x De Haro St 30 Median : Yard 3 Tree 1 DPW 2     15     6012283.09076 2102020.40062 37.7524393767806 -122.40039382202299 (37.7524393767806, -122.400393822023)
35532 35532 222179 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 500x 27th St 30 Median : Cutout 11 Tree 1 DPW 2     5 Width 4ft   6003006.9083 2100074.76415 37.74657546338779 -122.432333431553 (37.7465754633878, -122.432333431553)
63932 63932 204528 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 30 Median : Cutout 11 Tree 1 DPW 2     10 Width 3ft   5999178.73464 2097017.09345 37.7379620230245 -122.44535098508301 (37.7379620230245, -122.445350985083)
67893 67893 188931 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6012684.2362 2101844.7949200002 37.751979563304 -122.398994261091 (37.751979563304, -122.398994261091)
35162 35162 220782 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Florida St 29 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009149.20371 2106999.46315 37.7659354919643 -122.411583121262 (37.7659354919643, -122.411583121262)
68755 68755 222178 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 500x 27th St 29 Median : Cutout 11 Tree 1 DPW 2     10 Width 4ft   6003005.10045 2100073.32596 37.7465714119449 -122.432339580201 (37.7465714119449, -122.432339580201)
162271 162271 188930 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6012673.63731 2101844.0519999997 37.7519769327872 -122.399030861684 (37.7519769327872, -122.399030861684)
179590 179590 204529 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 29 Median : Cutout 11 Tree 1 DPW 2     11 Width 3ft   5999184.7705 2097021.0106799998 37.7379731233579 -122.44533039778999 (37.7379731233579, -122.44533039779)
23678 23678 204530 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 28 Median : Cutout 11 Tree 1 DPW 2     9 Width 3ft   5999185.819 2097019.3718599998 37.7379686834 -122.44532665482299 (37.7379686834, -122.445326654823)
31242 31242 220781 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Florida St 28 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009143.97471 2107042.08959 37.766052241031296 -122.411604219381 (37.7660522410313, -122.411604219381)
47481 47481 188929 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   6012662.881519999 2101843.47178 37.751974740254504 -122.39906801628 (37.7519747402545, -122.39906801628)
53874 53874 222177 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 500x 27th St 28 Median : Cutout 11 Tree 1 DPW 2     4 Width 4ft   6003006.81083 2100070.04416 37.7465624978721 -122.432333431547 (37.7465624978721, -122.432333431547)
48255 48255 220780 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Florida St 27 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009142.9779 2107062.20163 37.7661074081421 -122.411609088298 (37.7661074081421, -122.411609088298)
64910 64910 220816 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 100 Alemany Blvd 27 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6009324.41886 2095855.6736400002 37.735346953705104 -122.410190239591 (37.7353469537051, -122.410190239591)
188631 188631 204531 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 400x Marietta Dr 27 Median : Cutout 11 Tree 1 DPW 2     14 Width 3ft   5999192.435380001 2097025.16393 37.7379849647319 -122.44530419514999 (37.7379849647319, -122.44530419515)
33762 33762 220779 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Florida St 26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009143.243480001 2107098.17408 37.7662061950939 -122.41161071156 (37.7662061950939, -122.41161071156)
69230 69230 222176 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 500x 27th St 26 Median : Cutout 11 Tree 1 DPW 2     15 Width 4ft   6002985.78905 2100071.06849 37.7465641184368 -122.432406195695 (37.7465641184368, -122.432406195695)
186697 186697 188928 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6012639.77007 2101842.50365 37.7519707940373 -122.39914787158001 (37.7519707940373, -122.39914787158)
43277 43277 220778 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Florida St 25 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009139.51861 2107122.54701 37.7662729085954 -122.411625317449 (37.7662729085954, -122.411625317449)
181228 181228 217834 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2 Cranleigh Dr 25 Front Yard : Yard 7 Tree 1 Private 1     15     5991396.17639 2095791.9232400001 37.734150681791796 -122.472169581465 (37.7341506817918, -122.472169581465)
137491 137491 220777 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Florida St 24 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009140.42638 2107144.02197 37.76633192480371 -122.41162369509199 (37.7663319248037, -122.411623695092)
150403 150403 188927 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012620.56924 2101841.4528799998 37.7519668387962 -122.399214197496 (37.7519668387962, -122.399214197496)
92789 92789 77219 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 499X Hearst Ave 23 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
133527 133527 220776 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Florida St 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009138.53931 2107166.48847 37.766393506776204 -122.411631809669 (37.7663935067762, -122.411631809669)
27949 27949 175625 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 22 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   6009376.03196 2090018.08104 37.719321051904295 -122.40959990662701 (37.7193210519043, -122.409599906627)
149146 149146 205771 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 22 Median : Cutout 11 Tree 1 DPW 2     17 Width 5ft   5999270.55629 2097571.10979 37.7394884612284 -122.445073331084 (37.7394884612284, -122.445073331084)
164329 164329 188926 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6012598.03871 2101840.63611 37.751963340458104 -122.39929205448601 (37.7519633404581, -122.399292054486)
23617 23617 205782 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 451 Hearst Ave 21 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5998547.56823 2094367.17005 37.730649912448605 -122.447342555315 (37.7306499124486, -122.447342555315)
40811 40811 175624 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 21 Median : Cutout 11 Tree 1 DPW 2     10 Width 0ft   6009382.81472 2090013.8898 37.719309923703605 -122.409576165411 (37.7193099237036, -122.409576165411)
69863 69863 188925 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6012587.76707 2101840.20592 37.7519615867766 -122.399327545327 (37.7519615867766, -122.399327545327)
91332 91332 77217 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 499X Hearst Ave 21 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
151693 151693 205770 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 21 Median : Cutout 11 Tree 1 DPW 2     6 Width 5ft   5999265.98235 2097572.41051 37.7394917716315 -122.445089239201 (37.7394917716315, -122.445089239201)
47077 47077 205769 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 20 Median : Cutout 11 Tree 1 DPW 2     8 Width 5ft   5999260.68226 2097573.72632 37.7394950820195 -122.44510765910499 (37.7394950820195, -122.445107659105)
68873 68873 175623 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 700x Mansell St 20 Median : Cutout 11 Tree 1 DPW 2     6 Width 0ft   6009402.84406 2090023.10643 37.719336352976 -122.409507581334 (37.719336352976, -122.409507581334)
152233 152233 220815 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 100 Alemany Blvd 20 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6009430.07123 2095925.78909 37.7355453971844 -122.40982990642999 (37.7355453971844, -122.40982990643)
175454 175454 188924 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   6012576.69697 2101839.95145 37.7519602710713 -122.399365809709 (37.7519602710713, -122.399365809709)
39765 39765 175617 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 200x Mansell St 19 Median : Cutout 11 Tree 1 DPW 2     11 Width 0ft   6011092.2529 2090548.7162099998 37.720874087550705 -122.40370485781601 (37.7208740875507, -122.403704857816)
41943 41943 218261 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1400x Portola Dr 19 Median : Yard 3 Tree 1 DPW 2     8     5992797.06764 2097201.3875599997 37.738101689549296 -122.467428758544 (37.7381016895493, -122.467428758544)
64798 64798 188923 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6012568.02494 2101839.32896 37.751958078509205 -122.399395755332 (37.7519580785092, -122.399395755332)
93801 93801 77212 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 499X Hearst Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/15/1999 12:00:00 AM 4 3x3   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
94089 94089 42360 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 380X Flood Ave 19 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 06/23/2000 12:00:00 AM 5 3x3 Permit Number 42547 5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
25911 25911 205719 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 141 Taraval St 18 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5993232.44961 2099151.4105700003 37.7434810877719 -122.466065100337 (37.7434810877719, -122.466065100337)
33017 33017 218260 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1400x Portola Dr 18 Median : Yard 3 Tree 1 DPW 2     12     5992795.95946 2097207.23373 37.738117677685 -122.46743301504 (37.738117677685, -122.46743301504)
52500 52500 188922 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6012559.84354 2101839.17569 37.7519572016621 -122.399424037211 (37.7519572016621, -122.399424037211)
100207 100207 77211 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 499X Hearst Ave 18 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2 05/15/1999 12:00:00 AM 8 3x3   5998132.77434913 2094246.31790382 37.730294369809705 -122.44876785322901 (37.7302943698097, -122.448767853229)
163504 163504 205768 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 18 Median : Cutout 11 Tree 1 DPW 2     10 Width 5ft   5999248.63953 2097576.8704 37.7395030275415 -122.445149523442 (37.7395030275415, -122.445149523442)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 1316.989ms · Data source: data.sfgov.org