Street_Tree_List

Data source: data.sfgov.org

3,264 rows where qSpecies = 28 sorted by PlotSize 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
50425 50425 175713 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 637 Hamilton St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 9ft   6009802.3378800005 2091425.9949299998 37.7232107699499 -122.40822556625099 (37.7232107699499, -122.408225566251)
28590 28590 222186 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2103 Castro St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   6002703.56288 2099413.26301 37.7447419309924 -122.433335105435 (37.7447419309924, -122.433335105435)
28988 28988 175585 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1711 Cayuga Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   5998173.65271 2088704.87448 37.7150811936116 -122.448227659988 (37.7150811936116, -122.448227659988)
32704 32704 188943 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2250 Revere Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 8ft   6011566.68451 2097067.8193299999 37.738800679498404 -122.402523060487 (37.7388006794984, -122.402523060487)
33993 33993 188915 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012439.14392 2101833.80139 37.751935716861404 -122.39984105913 (37.7519357168614, -122.39984105913)
37278 37278 125781 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 75 Emerson St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   5998685.74713 2113372.01859 37.7828404099945 -122.448232826606 (37.7828404099945, -122.448232826606)
37838 37838 188942 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2250 Revere Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   6011601.74393 2097042.7843 37.7387338958451 -122.402400080905 (37.7387338958451, -122.402400080905)
39127 39127 247002 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 401 Valley St 2 Side Yard : Yard 17 Tree 1 Private 1     10 Width 8ft   6003223.72191 2099183.9093400002 37.7441416748926 -122.431520126078 (37.7441416748926, -122.431520126078)
47556 47556 117652 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 5101 Anza St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 8ft   5982828.88915 2111662.8174900003 37.7772281723606 -122.502963435462 (37.7772281723606, -122.502963435462)
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)
49919 49919 188941 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2250 Revere Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   6011606.7054 2097039.0351 37.738723878306 -122.402382662836 (37.738723878306, -122.402382662836)
51794 51794 246728 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 101 Ripley St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 8ft   6008612.87637 2099109.67638 37.7442418234114 -122.412880303405 (37.7442418234114, -122.412880303405)
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)
53771 53771 222241 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 233 Downey St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 8ft   5998966.85678 2106784.6526 37.76476925382789 -122.44678616725099 (37.7647692538279, -122.446786167251)
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)
69689 69689 204366 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 544 Ramsell St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 8ft   5993020.52615 2090799.19022 37.720535733807296 -122.466191031497 (37.7205357338073, -122.466191031497)
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)
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)
130591 130591 188919 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012522.72897 2101837.16706 37.7519496176856 -122.399552244535 (37.7519496176856, -122.399552244535)
131193 131193 188913 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   6012415.40438 2101833.48488 37.7519335243109 -122.399923132139 (37.7519335243109, -122.399923132139)
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)
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)
132722 132722 188918 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012503.474230001 2101836.59993 37.7519469871825 -122.399618790794 (37.7519469871825, -122.399618790794)
132761 132761 188920 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012536.08431 2101837.90146 37.75195237861271 -122.399506111115 (37.7519523786127, -122.399506111115)
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)
136965 136965 125780 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 75 Emerson St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5998681.19546 2113401.84982 37.7829220585575 -122.44825072220101 (37.7829220585575, -122.448250722201)
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)
155415 155415 188916 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 8ft   6012464.32295 2101833.92886 37.7519374705385 -122.39975399485 (37.7519374705385, -122.39975399485)
161396 161396 117651 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 5101 Anza St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   5982808.62425 2111663.8514799997 37.77722982032 -122.503033613638 (37.77722982032, -122.503033613638)
162628 162628 188921 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012543.15348 2101838.55647 37.751954571155 -122.39948171073601 (37.751954571155, -122.399481710736)
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)
169597 169597 222228 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 5735 Diamond Heights Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 8ft   6000718.4413 2097027.5957400003 37.738078632721795 -122.440028227017 (37.7380786327218, -122.440028227017)
170547 170547 188917 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6012491.9137699995 2101835.87627 37.751944355754205 -122.399658717969 (37.7519443557542, -122.399658717969)
173533 173533 204367 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 544 Ramsell St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   5993020.48058 2090812.3003 37.7205717282756 -122.46619214125201 (37.7205717282756, -122.466192141252)
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)
176202 176202 222498 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 749 Dolores St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   6005048.62848 2104037.34369 37.7575713454444 -122.42555534471799 (37.7575713454444, -122.425555344718)
176477 176477 204582 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 90 Melrose Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   5999570.33408 2095534.33569 37.7339130665349 -122.443890535522 (37.7339130665349, -122.443890535522)
184139 184139 188882 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 869 Vermont St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 8ft   6011336.637130001 2104304.99863 37.7586595539197 -122.403827579285 (37.7586595539197, -122.403827579285)
184522 184522 188914 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2001 25th St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6012427.94611 2101835.1466 37.751938786244104 -122.399879877452 (37.7519387862441, -122.399879877452)
185057 185057 220805 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1300 San Jose Ave 4 Front Yard : Yard 7 Tree 1 Private 1     5 Width 8ft   6003673.53965 2095753.0634 37.7347468423996 -122.429720104197 (37.7347468423996, -122.429720104197)
186689 186689 204602 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 200 Judson Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 8ft   5998668.22296 2093529.8736400001 37.7283577869805 -122.446865208659 (37.7283577869805, -122.446865208659)
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)
63142 63142 247672 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 170 Divisadero St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 7ft   6001935.4229999995 2108631.3332700003 37.7700089198994 -122.436650881551 (37.7700089198994, -122.436650881551)
166265 166265 202030 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1327 Fitzgerald Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 7ft   6013974.71046 2090993.7917 37.7222567763217 -122.393772134473 (37.7222567763217, -122.393772134473)
28772 28772 175741 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 262 Chicago Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 6ft   6002753.09913 2086743.14922 37.709955463542 -122.432259125067 (37.709955463542, -122.432259125067)
36617 36617 175739 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 275 Chicago Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6002794.41849 2086722.1369599998 37.709900111181604 -122.432114818072 (37.7099001111816, -122.432114818072)
37680 37680 175596 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 861 Lisbon St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6001043.54225 2088836.75005 37.715606945381 -122.438317555522 (37.715606945381, -122.438317555522)
38691 38691 204377 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 718 Head St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   5993540.82966 2090600.12558 37.720019156046796 -122.464378076488 (37.7200191560468, -122.464378076488)
39662 39662 204605 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 450 Circular Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 6ft   5999601.48923 2093614.0273 37.728642125620006 -122.44364491807501 (37.72864212562, -122.443644918075)
40486 40486 220806 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1300 San Jose Ave 5 Front Yard : Yard 7 Tree 1 Private 1     8 Width 6ft   6003687.50559 2095763.3116799998 37.7347757726743 -122.42967254985099 (37.7347757726743, -122.429672549851)
45523 45523 175591 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2 Moneta Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   5997970.372380001 2088102.3991200002 37.713415311033 -122.44888690892 (37.713415311033, -122.44888690892)
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)
49009 49009 188889 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 812 Rhode Island St 2 : 4 Tree 1 Private 1     3 Width 6ft   6011824.00346 2104560.8876 37.7593893834298 -122.402160024888 (37.7593893834298, -122.402160024888)
52577 52577 205871 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 111 Monticello St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   5991654.88774 2089307.44903 37.7163608911211 -122.470802959995 (37.7163608911211, -122.470802959995)
57235 57235 175648 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Cardenas Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5990403.32902 2090274.19266 37.7189428716957 -122.475199448694 (37.7189428716957, -122.475199448694)
57394 57394 204389 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 45 Rossmoor Dr 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 6ft   5991049.04584 2094416.57218 37.730354219869206 -122.473269434337 (37.7303542198692, -122.473269434337)
67037 67037 175746 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 52 Baltimore Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6002987.27121 2086606.3933299999 37.7095932364015 -122.43144002615401 (37.7095932364015, -122.431440026154)
67405 67405 175650 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Cardenas Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5990453.87404 2090277.7472299999 37.718955561137705 -122.475024995517 (37.7189555611377, -122.475024995517)
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)
72193 72193 125788 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2812 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 6ft   5999154.819180001 2118474.67758 37.7968777722368 -122.44697735234502 (37.7968777722368, -122.446977352345)
74650 74650 175744 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 46 Baltimore Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6003028.75595 2086646.47615 37.709705646261796 -122.431299507078 (37.7097056462618, -122.431299507078)
132995 132995 175742 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 262 Chicago Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 6ft   6002727.11736 2086720.5871400002 37.709892039762295 -122.43234731259399 (37.7098920397623, -122.432347312594)
135528 135528 204398 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1346 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 6ft   5994282.41464 2106337.33342 37.7632723142903 -122.46295585533899 (37.7632723142903, -122.462955855339)
135688 135688 204606 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 450 Circular Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 6ft   5999593.89835 2093609.0830400002 37.7286281168878 -122.44367080506201 (37.7286281168878, -122.443670805062)
137396 137396 175750 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 348 Naylor St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6002816.75765 2086477.59625 37.7092299219895 -122.43202015901899 (37.7092299219895, -122.432020159019)
150121 150121 175745 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 52 Baltimore Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6003007.00361 2086627.02122 37.7096509944604 -122.431373299139 (37.7096509944604, -122.431373299139)
151869 151869 118809 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 894 46th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   5981738.19338 2109667.15136 37.771684492567395 -122.50658839183001 (37.7716844925674, -122.50658839183)
154901 154901 175733 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1183 Munich St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6001131.654490001 2087116.6540599999 37.710888955334 -122.437889869445 (37.710888955334, -122.437889869445)
157366 157366 204607 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 450 Circular Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   5999588.132619999 2093605.9799099998 37.7286192675636 -122.443690514623 (37.7286192675636, -122.443690514623)
158558 158558 175602 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 521 Lisbon St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6002031.92275 2090419.60953 37.7200092931862 -122.435014408592 (37.7200092931862, -122.435014408592)
161218 161218 205761 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1 Malta Dr 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   5999812.15419 2095813.64108 37.7346937644012 -122.443074544653 (37.7346937644012, -122.443074544653)
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)
167207 167207 175740 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 262 Chicago Way 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6002767.48185 2086755.4515900002 37.709990058672794 -122.432210293693 (37.7099900586728, -122.432210293693)
168667 168667 175660 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 61 Gorham St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   6002127.949990001 2094431.27872 37.7310298832205 -122.43496923026899 (37.7310298832205, -122.434969230269)
169081 169081 205760 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1 Malta Dr 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   5999813.178859999 2095831.7198 37.7347434627438 -122.443072299967 (37.7347434627438, -122.443072299967)
169725 169725 175749 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 348 Naylor St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6002804.80085 2086492.5452299998 37.7092702907661 -122.432062550353 (37.7092702907661, -122.432062550353)
172456 172456 204592 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 80 Congo St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6000106.35116 2094008.9908599998 37.7297553855902 -122.441927922547 (37.7297553855902, -122.441927922547)
174042 174042 205849 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 438 Orizaba Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   5994041.34174 2089295.5439900002 37.7164659256374 -122.46255340963002 (37.7164659256374, -122.46255340963)
175628 175628 175659 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 61 Gorham St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 6ft   6002127.87669 2094427.73374 37.7310201453528 -122.434969230247 (37.7310201453528, -122.434969230247)
180905 180905 175649 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Cardenas Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   5990437.61377 2090276.93523 37.7189523892072 -122.47508114108 (37.7189523892072, -122.47508114108)
180939 180939 205850 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 438 Orizaba Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   5994044.85216 2089294.81203 37.7164641180118 -122.46254122291599 (37.7164641180118, -122.462541222916)
184257 184257 175743 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 262 Chicago Way 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 6ft   6002717.2522 2086712.6010099999 37.7098695521959 -122.43238083839701 (37.7098695521959, -122.432380838397)
184393 184393 222175 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 4220 Cesar Chavez St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 6ft   6002470.36275 2100366.71232 37.7473466464472 -122.434209614287 (37.7473466464472, -122.434209614287)
185753 185753 175651 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 0 Cardenas Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5990482.39675 2090282.34445 37.7189698369625 -122.47492674008001 (37.7189698369625, -122.47492674008)
187073 187073 220786 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 100 27th St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   6005806.54234 2100249.31165 37.747213079126 -122.42266498479601 (37.747213079126, -122.422664984796)
187151 187151 125789 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2812 Lyon St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 6ft   5999154.23094 2118479.17049 37.79689007496071 -122.44697971126699 (37.7968900749607, -122.446979711267)
188830 188830 118808 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 894 46th Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5981738.117319999 2109674.1043 37.771703578835 -122.50658917067 (37.771703578835, -122.50658917067)
23609 23609 125847 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1752 Taylor St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 5ft   6008754.651330001 2118947.56933 37.7987199902862 -122.413793029843 (37.7987199902862, -122.413793029843)
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)
32880 32880 222384 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 552 Noe St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6002973.50824 2104978.67687 37.7600385509657 -122.43279918955601 (37.7600385509657, -122.432799189556)
33718 33718 205774 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 367 Kensington Way 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 5ft   5994104.037819999 2099097.57437 37.743383512235496 -122.46304748455401 (37.7433835122355, -122.463047484554)
34604 34604 121854 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 594 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   5990047.88808 2111338.1020400003 37.7767582401401 -122.477967136227 (37.7767582401401, -122.477967136227)
37657 37657 202112 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1833 Egbert Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 5ft   6011990.44763 2092817.4555099998 37.72715371615929 -122.400759355986 (37.7271537161593, -122.400759355986)
38487 38487 222382 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 532 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   6002964.941219999 2105091.2167 37.7603470723843 -122.432836858561 (37.7603470723843, -122.432836858561)
39319 39319 205763 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 12 Median : Cutout 11 Tree 1 DPW 2     3 Width 5ft   5999213.2528 2097587.01076 37.739528850671 -122.445272603768 (37.739528850671, -122.445272603768)
40021 40021 175705 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 101 Dartmouth St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 5ft   6008531.54001 2093517.9032700001 37.728883464995704 -122.412766304433 (37.7288834649957, -122.412766304433)
40527 40527 125855 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 2843 Larkin St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 5ft   6006460.99405 2121028.21686 37.8043038458052 -122.421877708416 (37.8043038458052, -122.421877708416)
40906 40906 205764 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 300x Marietta Dr 13 Median : Cutout 11 Tree 1 DPW 2     5 Width 5ft   5999220.2422400005 2097585.41843 37.7395248774812 -122.445248322956 (37.7395248774812, -122.445248322956)
42309 42309 175688 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1849 Felton St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 5ft   6005530.78221 2092211.86243 37.7251284788867 -122.42304735585199 (37.7251284788867, -122.423047355852)
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)

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 1278.673ms · Data source: data.sfgov.org