Street_Tree_List

Data source: data.sfgov.org

302 rows where qSiteInfo = 19 sorted by qSpecies descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies ▲ qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
90997 90997 86768 Permitted Site 1 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 500 Brotherhood Way   unknown : Yard 19 Tree 1 Private 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
74158 74158 138257 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 2600 GEARY BLVD 2 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5999359.7213 2113228.3471 37.7824844323354 -122.445890830511 (37.7824844323354, -122.445890830511)
150075 150075 186582 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1501 Sunset Blvd 53 unknown : Yard 19 Tree 1 Private 1     6 Width 0ft   5984722.9379 2104579.1806 37.757889649764294 -122.495888732757 (37.7578896497643, -122.495888732757)
162494 162494 186583 Undocumented 2 Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 1501 Sunset Blvd 54 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   5984720.8443 2104581.693 37.757896425499794 -122.49589615853 (37.7578964254998, -122.49589615853)
46337 46337 185407 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2300 Sunset Blvd 22 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985075.6429 2099093.4159999997 37.742847892869 -122.49426460522899 (37.742847892869, -122.494264605229)
53840 53840 185397 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2300 Sunset Blvd 10 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985126.1289 2099011.9385 37.742627131937 -122.49408403757799 (37.742627131937, -122.494084037578)
57892 57892 185452 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2400 Sunset Blvd 2 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985111.1125 2098241.4711 37.7405107574318 -122.49407918667299 (37.7405107574318, -122.494079186673)
64449 64449 185478 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2400 Sunset Blvd 30 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985137.6741 2098467.2445 37.7411322246193 -122.494003983523 (37.7411322246193, -122.494003983523)
117606 117606 86758 Permitted Site 1 Quercus agrifolia :: Coast Live Oak 180 500 Brotherhood Way   unknown : Yard 19 Tree 1 Private 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
131257 131257 185403 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2300 Sunset Blvd 17 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985110.6332 2099073.9214 37.742796413512 -122.49414218382499 (37.742796413512, -122.494142183825)
152435 152435 185402 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 2300 Sunset Blvd 16 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985125.6291 2099042.93 37.742712196982495 -122.494088049359 (37.7427121969825, -122.494088049359)
35616 35616 185394 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2300 Sunset Blvd 4 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985078.642000001 2098945.9568 37.7424431852403 -122.494243368761 (37.7424431852403, -122.494243368761)
152791 152791 185391 Undocumented 2 Podocarpus macrophyllus :: Yew Pine 168 2300 Sunset Blvd 2 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985125.1292 2098935.9595 37.7424184556167 -122.49408189561899 (37.7424184556167, -122.494081895619)
146760 146760 186517 Undocumented 2 Pinus halepensis :: Allepo Pine 164 1400 Lower Great Hwy 3 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   5980906.8218 2104997.2844 37.7588134060814 -122.509117272676 (37.7588134060814, -122.509117272676)
160873 160873 185390 Undocumented 2 Araucaria araucana :: Monkey puzzle 154 2300 Sunset Blvd 1 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985092.6382 2098924.4627 37.742384987274704 -122.49419339090001 (37.7423849872747, -122.4941933909)
174794 174794 186572 Undocumented 2 Araucaria araucana :: Monkey puzzle 154 1501 Sunset Blvd 43 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984761.0418 2104653.2947 37.7580953780168 -122.495762422342 (37.7580953780168, -122.495762422342)
180584 180584 186563 Undocumented 2 Araucaria araucana :: Monkey puzzle 154 1501 Sunset Blvd 34 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984717.9132 2104705.2165 37.7582354149831 -122.495915407531 (37.7582354149831, -122.495915407531)
53419 53419 186531 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 1501 Sunset Blvd 2 unknown : Yard 19 Tree 1 Private 1     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.49581571217699 (37.7588251541556, -122.495815712177)
149365 149365 185409 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2300 Sunset Blvd 24 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985081.6412 2099150.9001 37.7430060796886 -122.494248101225 (37.7430060796886, -122.494248101225)
170252 170252 185410 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 2300 Sunset Blvd 25 unknown : Yard 19 Tree 1 Private 1     8 Width 0ft   5985099.6362 2099155.3989 37.7430194852088 -122.494186211855 (37.7430194852088, -122.494186211855)
134829 134829 186518 Undocumented 2 Syagrus romanzoffianum :: Queen Palm 142 1400 Lower Great Hwy 4 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5980903.7154 2105000.9085 37.758823173681606 -122.50912828496901 (37.7588231736816, -122.509128284969)
55505 55505 186565 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 36 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984733.8247 2104692.236 37.7582007060302 -122.49585942192302 (37.7582007060302, -122.495859421923)
137799 137799 186560 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 31 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984754.3422 2104716.1033 37.7582674405997 -122.495790225123 (37.7582674405997, -122.495790225123)
146842 146842 186566 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984742.1992 2104682.6054 37.7581747535408 -122.49582974929 (37.7581747535408, -122.49582974929)
179756 179756 186570 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 41 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984760.623 2104719.4531 37.7582770060448 -122.495768750789 (37.7582770060448, -122.495768750789)
182562 182562 186564 Undocumented 2 Cordyline australis :: Dracena Palm 141 1501 Sunset Blvd 35 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984731.3124 2104697.6794 37.7582155049555 -122.49586851196199 (37.7582155049555, -122.495868511962)
157249 157249 200733 Undocumented 2 Schinus molle :: California Pepper 138 1462 Oakdale Ave 3 unknown : Yard 19 Tree 1 Private 1     14 Width 0ft   6015790.512 2094948.0194 37.7332150397253 -122.387771048105 (37.7332150397253, -122.387771048105)
48606 48606 185487 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 40 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985139.0022 2098533.6484 37.7413146295557 -122.49400428423901 (37.7413146295557, -122.494004284239)
55166 55166 185499 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 53 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985130.3697 2098685.0494 37.741729830798995 -122.494045287668 (37.741729830799, -122.494045287668)
70982 70982 185472 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 24 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985147.6347 2098429.3943 37.741028880966894 -122.493966755049 (37.7410288809669, -122.493966755049)
163100 163100 185482 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 35 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985148.9628 2098503.7667 37.741233165261896 -122.49396764279498 (37.7412331652619, -122.493967642795)
184474 184474 185501 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 2400 Sunset Blvd 55 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985131.6978 2098729.54 37.741852067703704 -122.494043973834 (37.7418520677037, -122.494043973834)
47580 47580 186579 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1501 Sunset Blvd 50 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984739.2681 2104595.0921 37.7579342947119 -122.495833430643 (37.7579342947119, -122.495833430643)
75550 75550 186581 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1501 Sunset Blvd 52 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984771.5099 2104576.6683 37.75788559627829 -122.495720567601 (37.7578855962783, -122.495720567601)
24598 24598 186532 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 3 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984706.503 2104907.5647 37.7587903384946 -122.49596979583599 (37.7587903384946, -122.495969795836)
34988 34988 186555 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 26 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5984748.8988 2104750.8574 37.7583625468943 -122.495811614145 (37.7583625468943, -122.495811614145)
35633 35633 185470 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 22 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985119.081 2098414.7854 37.7409870981235 -122.49406440544399 (37.7409870981235, -122.494064405444)
37834 37834 185476 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 28 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985139.6662 2098449.3154 37.741083112699 -122.49399577462098 (37.741083112699, -122.493995774621)
47539 47539 186530 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 1 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984710.6902 2104914.2643 37.7588089789692 -122.495955809021 (37.7588089789692, -122.495955809021)
48044 48044 186542 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 13 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984733.3013 2104876.5792 37.7587068304654 -122.495874830593 (37.7587068304654, -122.495874830593)
48440 48440 186534 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 5 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984706.503 2104895.4217 37.758756997201 -122.49596890002701 (37.758756997201, -122.495968900027)
57323 57323 185506 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 60 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985096.5037 2098790.6317 37.7420177496615 -122.494170163503 (37.7420177496615, -122.494170163503)
59949 59949 186544 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 15 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984717.8085 2104869.8796 37.7586875278599 -122.495927916751 (37.7586875278599, -122.495927916751)
60508 60508 185418 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 34 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985092.1383 2099264.8686 37.7433196206545 -122.494220204145 (37.7433196206545, -122.494220204145)
62916 62916 186533 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 4 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984732.4639 2104901.2839 37.7587746136444 -122.495879549084 (37.7587746136444, -122.495879549084)
67708 67708 185471 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 23 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985135.682 2098419.4337 37.7410008324731 -122.494007348608 (37.7410008324731, -122.494007348608)
76866 76866 185401 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 14 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985086.14 2099023.9352 37.74265773164 -122.494223189599 (37.74265773164, -122.494223189599)
77313 77313 185489 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 42 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985101.1519 2098546.2652 37.7413470571288 -122.494136085042 (37.7413470571288, -122.494136085042)
147307 147307 186567 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 38 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984755.1796 2104685.1177 37.7581824118079 -122.49578504343799 (37.7581824118079, -122.495785043438)
147893 147893 185424 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 40 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985084.6404 2099301.8584 37.7434207458763 -122.49424885544599 (37.7434207458763, -122.494248855446)
159555 159555 185466 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 18 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985111.7766 2098394.8642 37.740931972462796 -122.494088193127 (37.7409319724628, -122.494088193127)
159653 159653 185399 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 12 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985110.1333 2099026.9344 37.7426673706481 -122.49414044992399 (37.7426673706481, -122.494140449924)
167557 167557 185404 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 18 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985080.6415 2099060.4251 37.7427576012847 -122.494244890555 (37.7427576012847, -122.494244890555)
169801 169801 186556 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 27 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984748.0613 2104746.2514 37.7583498510528 -122.495814170782 (37.7583498510528, -122.495814170782)
174524 174524 185420 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 36 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985096.6371 2099279.3646 37.7433596860109 -122.494205716911 (37.7433596860109, -122.494205716911)
174920 174920 186558 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 29 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5984755.5984 2104741.6454 37.7583376456641 -122.495787764797 (37.7583376456641, -122.495787764797)
176577 176577 185492 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2400 Sunset Blvd 45 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985138.3382 2098590.7558 37.7414713922408 -122.494010787869 (37.7414713922408, -122.494010787869)
177017 177017 185421 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 37 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985094.1378 2099288.8619999997 37.7433856170495 -122.494215058601 (37.7433856170495, -122.494215058601)
179741 179741 185419 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 35 unknown : Yard 19 Tree 1 Private 1     3 Width 0ft   5985098.1367 2099271.3668 37.7433378139676 -122.49419994238899 (37.7433378139676, -122.494199942389)
181170 181170 185396 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 8 unknown : Yard 19 Tree 1 Private 1     5 Width 0ft   5985088.1394 2098992.4439 37.742571382036 -122.49421395573499 (37.742571382036, -122.494213955735)
187425 187425 186568 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1501 Sunset Blvd 39 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984708.7013 2104680.5118 37.7581670432315 -122.495945443345 (37.7581670432315, -122.495945443345)
187450 187450 185422 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 2300 Sunset Blvd 38 unknown : Yard 19 Tree 1 Private 1     4 Width 0ft   5985084.6404 2099285.363 37.7433754539691 -122.494247639854 (37.7433754539691, -122.494247639854)
28544 28544 185496 Undocumented 2 Pinus Spp :: Pine Spp 105 2400 Sunset Blvd 50 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5985141.6583 2098649.8553 37.7416338578085 -122.49400366283501 (37.7416338578085, -122.494003662835)
167264 167264 186490 Undocumented 2 Pinus Spp :: Pine Spp 105 1400 Lower Great Hwy 36 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5980883.265 2105397.7493 37.7599115788226 -122.509228480711 (37.7599115788226, -122.509228480711)
183371 183371 185462 Undocumented 2 Pinus Spp :: Pine Spp 105 2400 Sunset Blvd 13 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5985138.3382 2098374.943 37.740878828405 -122.49399488645399 (37.740878828405, -122.493994886454)
89080 89080 106004 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 695X CAMPBELL AVE   unknown : Yard 19 Tree 1 Rec/Park 3           6009136.9 2088912.4 37.716271678506 -122.41034847162202 (37.716271678506, -122.410348471622)
106936 106936 105441 Private 5 Eucalyptus globulus :: Blue Gum 103 425 WAWONA ST   unknown : Yard 19 Tree 1 Private 1           5991587.6 2097036.5 37.737579050883106 -122.471598439568 (37.7375790508831, -122.471598439568)
86739 86739 86757 Permitted Site 1 Prunus spp :: Cherry 84 500 Brotherhood Way   unknown : Yard 19 Tree 1 Private 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
114979 114979 118322 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 82 720 BATTERY ST 1 unknown : Yard 19 Tree 1 Private 1           6012486.0 2118560.0 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686)
114230 114230 86759 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 500 Brotherhood Way   unknown : Yard 19 Tree 1 Private 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
120349 120349 86760 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 500 Brotherhood Way   unknown : Yard 19 Tree 1 Private 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
125822 125822 86761 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 500 Brotherhood Way   unknown : Yard 19 Tree 1 Private 1         Permit Number 49739 5992573.4 2087955.0 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031)
28131 28131 200245 Undocumented 2 :: 54 1075 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013768.3263 2090118.3656 37.71984155975311 -122.394424294358 (37.7198415597531, -122.394424294358)
28513 28513 200177 Undocumented 2 :: 54 1041 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014650.3204 2089811.8475 37.7190489123065 -122.39135410876001 (37.7190489123065, -122.39135410876)
29647 29647 200249 Undocumented 2 :: 54 1067 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013803.2037 2090093.549 37.7197753570889 -122.394301997885 (37.7197753570889, -122.394301997885)
29863 29863 200176 Undocumented 2 :: 54 1047 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014610.748 2089844.7127 37.7191369573176 -122.391493192738 (37.7191369573176, -122.391493192738)
30792 30792 200164 Undocumented 2 :: 54 1027 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014014.4798 2089939.2839 37.7193635176037 -122.393560894555 (37.7193635176037, -122.393560894555)
37581 37581 200170 Undocumented 2 :: 54 1001 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014099.661 2089867.5171 37.71917119290661 -122.393261433304 (37.7191711929066, -122.393261433304)
39813 39813 200248 Undocumented 2 :: 54 1107 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014274.7183 2090092.8783 37.719799714154504 -122.392672078819 (37.7197997141545, -122.392672078819)
40807 40807 200183 Undocumented 2 :: 54 1197 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013828.6909 2090422.2008 37.7206791862384 -122.39423689451401 (37.7206791862384, -122.394236894514)
42125 42125 200722 Undocumented 2 :: 54 1476 Oakdale Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6015747.1852 2094980.6714 37.7333022953684 -122.387923119588 (37.7333022953684, -122.387923119588)
43519 43519 200180 Undocumented 2 :: 54 1031 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014690.5634 2089785.0188 37.7189774793874 -122.391213128817 (37.7189774793874, -122.391213128817)
44928 44928 200155 Undocumented 2 :: 54 1091 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014363.9238 2090021.1115 37.719607610680704 -122.39235870744899 (37.7196076106807, -122.392358707449)
52467 52467 200157 Undocumented 2 :: 54 1091 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014392.094 2090006.3557 37.7195686584119 -122.39226030100401 (37.7195686584119, -122.392260301004)
55366 55366 200178 Undocumented 2 :: 54 3201 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014218.378 2089782.3359 37.7189438969212 -122.39284511455 (37.7189438969212, -122.39284511455)
58301 58301 200156 Undocumented 2 :: 54 1047 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013914.5428 2090009.7093 37.7195513382693 -122.39391126933 (37.7195513382693, -122.39391126933)
61127 61127 200498 Undocumented 2 :: 54 1055 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013869.6047 2090039.2209 37.7196298737115 -122.394068670065 (37.7196298737115, -122.394068670065)
73420 73420 200232 Undocumented 2 :: 54 923 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014491.3602 2089577.767 37.7183973497527 -122.391887217647 (37.7183973497527, -122.391887217647)
74346 74346 200162 Undocumented 2 :: 54 1035 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013970.2124 2089969.4662 37.7194439323961 -122.393716023061 (37.7194439323961, -122.393716023061)
131768 131768 200212 Undocumented 2 :: 54 1101 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013545.647999999 2090276.655 37.720263809593604 -122.395205102903 (37.7202638095936, -122.395205102903)
133594 133594 200166 Undocumented 2 :: 54 1023 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014031.9185 2089919.1624 37.7193092369184 -122.393499207549 (37.7193092369184, -122.393499207549)
144780 144780 200169 Undocumented 2 :: 54 1061 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014525.5668 2089911.1138 37.719314553356206 -122.391792274296 (37.7193145533562, -122.391792274296)
147039 147039 200193 Undocumented 2 :: 54 975 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014303.5592 2089724.6542 37.7187902452961 -122.392546641558 (37.7187902452961, -122.392546641558)
150420 150420 200167 Undocumented 2 :: 54 1019 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014049.3571 2089910.4430000002 37.7192862641022 -122.393438318502 (37.7192862641022, -122.393438318502)
156632 156632 200165 Undocumented 2 :: 54 1071 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014485.3238 2089939.2839 37.7193896687982 -122.39193334918501 (37.7193896687982, -122.391933349185)
157610 157610 200239 Undocumented 2 :: 54 1131 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014148.6234 2090188.791 37.7200560674381 -122.39311465541401 (37.7200560674381, -122.393114655414)
165416 165416 200238 Undocumented 2 :: 54 917 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014595.9922 2089500.6344 37.7181913669776 -122.391520156023 (37.7181913669776, -122.391520156023)
168399 168399 200213 Undocumented 2 :: 54 1101 Ingerson Ave 2 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013590.5861 2090251.1677 37.7201963256026 -122.395047981349 (37.7201963256026, -122.395047981349)
168550 168550 200246 Undocumented 2 :: 54 1071 Ingerson Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6013781.7407 2090110.9877 37.719822047209 -122.394377408818 (37.719822047209, -122.394377408818)
171950 171950 200244 Undocumented 2 :: 54 1123 Hollister Ave 1 unknown : Yard 19 Tree 1 Private 1     0 Width 0ft   6014193.5615 2090152.5722 37.7199591140845 -122.39295678576201 (37.7199591140845, -122.392956785762)

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