Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 333 | 333 | 242579 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 11 | Width 3ft | Permit Number 778239 | 6001257.943419999 | 2101462.97247 | 37.7502878270446 | -122.438480597209 | (37.7502878270446, -122.438480597209) | |
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 1166 | 1166 | 251466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1178 | 1178 | 251465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008072.0 | 2112894.0 | 37.782060012266896 | -122.415726368353 | (37.7820600122669, -122.415726368353) | ||||
| 1525 | 1525 | 251581 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5984701.0 | 2111577.0 | 37.777102396300705 | -122.496480968893 | (37.7771023963007, -122.496480968893) | ||||
| 2483 | 2483 | 201850 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 911 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6011602.0 | 2112119.0 | 37.7801298483764 | -122.403459565618 | (37.7801298483764, -122.403459565618) | |||
| 2753 | 2753 | 198672 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 193 Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/2017 12:00:00 AM | 3 | Width 4ft | 6010593.523440001 | 2111314.08538 | 37.777863361242105 | -122.406891615375 | (37.7778633612421, -122.406891615375) | ||
| 3378 | 3378 | 242510 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2808 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008305.34942 | 2102000.42568 | 37.75216190805129 | -122.41414814334 | (37.7521619080513, -122.41414814334) | |||
| 5079 | 5079 | 137895 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1944 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2017 12:00:00 AM | 3 | Width 0ft | 6003925.565 | 2115178.3301 | 37.788098246385395 | -122.430234163647 | (37.7880982463854, -122.430234163647) | ||
| 5186 | 5186 | 180527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 543 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6003103.45709 | 2090752.9991099997 | 37.720985491961 | -122.43133426946301 | (37.720985491961, -122.431334269463) | |||
| 7448 | 7448 | 106350 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1853 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001488.8508 | 2114881.6293 | 37.7871452647326 | -122.43864348553001 | (37.7871452647326, -122.43864348553) | |||
| 7715 | 7715 | 101523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001809.9749300005 | 2118762.85825 | 37.7978203759732 | -122.43781055733801 | (37.7978203759732, -122.437810557338) | |||
| 8832 | 8832 | 101524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2326 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6001795.96309 | 2118760.54126 | 37.7978132173675 | -122.437858876082 | (37.7978132173675, -122.437858876082) | |||
| 9736 | 9736 | 173668 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014587.0 | 2096103.0 | 37.7363196386473 | -122.392012689283 | (37.7363196386473, -122.392012689283) | ||||
| 10054 | 10054 | 173830 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1801 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000494.0 | 2114864.0 | 37.7870402148899 | -122.442084176412 | (37.7870402148899, -122.442084176412) | ||||
| 10167 | 10167 | 110034 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008245.7 | 2102789.4 | 37.754324902547204 | -122.414410241803 | (37.7543249025472, -122.414410241803) | |||||
| 10325 | 10325 | 109498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2440 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5989239.6228 | 2098735.6386 | 37.74210832360679 | -122.479840718717 | (37.7421083236068, -122.479840718717) | |||
| 13721 | 13721 | 98856 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008586.80061 | 2110533.83683 | 37.7756084919722 | -122.413778389761 | (37.7756084919722, -122.413778389761) | |||
| 13792 | 13792 | 98860 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008529.07758 | 2110594.62185 | 37.7757721514991 | -122.41398236951099 | (37.7757721514991, -122.413982369511) | |||
| 14290 | 14290 | 111683 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 915 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6x7 | 6015271.38469 | 2104348.4426599997 | 37.758997874376796 | -122.390222350301 | (37.7589978743768, -122.390222350301) | |||
| 14529 | 14529 | 102719 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1681 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008087.4331 | 2108473.4904 | 37.7699232110184 | -122.41535993867 | (37.7699232110184, -122.41535993867) | |||
| 14834 | 14834 | 74054 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 194X Russ St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1998 12:00:00 AM | 5 | 5x5 | 6010549.99954 | 2111279.17691 | 37.7777650752333 | -122.407039719318 | (37.7777650752333, -122.407039719318) | ||
| 14994 | 14994 | 98857 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008572.87311 | 2110548.2851 | 37.775647381359995 | -122.41382759079501 | (37.77564738136, -122.413827590795) | |||
| 15108 | 15108 | 117609 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1227 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6009518.3962 | 2110117.1687 | 37.774516691037505 | -122.41052633045099 | (37.7745166910375, -122.410526330451) | |||
| 15274 | 15274 | 110633 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 631 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013429.5241 | 2113847.0849 | 37.7849766786955 | -122.397258498892 | (37.7849766786955, -122.397258498892) | |||
| 15403 | 15403 | 98861 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008516.35298 | 2110609.93053 | 37.7758134708437 | -122.414027470493 | (37.7758134708437, -122.414027470493) | |||
| 15420 | 15420 | 98859 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008542.44899 | 2110581.95524 | 37.775738122962295 | -122.413935218038 | (37.7757381229623, -122.413935218038) | |||
| 15718 | 15718 | 98858 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008557.54308 | 2110566.5981 | 37.775696803594606 | -122.413881917042 | (37.7756968035946, -122.413881917042) | |||
| 16550 | 16550 | 112173 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 190 Russ St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010499.33864 | 2111330.08185 | 37.7779020131996 | -122.407218562985 | (37.7779020131996, -122.407218562985) | |||
| 16662 | 16662 | 105993 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6015232.0353 | 2104000.8036599997 | 37.758041149501096 | -122.39033415130501 | (37.7580411495011, -122.390334151305) | |||
| 16739 | 16739 | 98855 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008612.6243900005 | 2110507.04759 | 37.775536385219105 | -122.41368716343399 | (37.7755363852191, -122.413687163434) | |||
| 18487 | 18487 | 115018 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4311 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6000722.0 | 2105756.0 | 37.7620449359843 | -122.440641810954 | (37.7620449359843, -122.440641810954) | |||
| 19559 | 19559 | 106645 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | Permit Number 772901 | 6001633.7 | 2104049.1 | 37.75741007891521 | -122.437366369677 | (37.7574100789152, -122.437366369677) | |||
| 20397 | 20397 | 117536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 601 WALLER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002803.0 | 2108833.0 | 37.7706119122875 | -122.433664364997 | (37.7706119122875, -122.433664364997) | ||||
| 22293 | 22293 | 242425 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1626 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009679.80342 | 2100181.3375 | 37.7472442001585 | -122.40926669339899 | (37.7472442001585, -122.409266693399) | |||
| 23752 | 23752 | 242656 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 502 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001805.42394 | 2102865.73386 | 37.75417060141171 | -122.436687776224 | (37.7541706014117, -122.436687776224) | |||
| 23864 | 23864 | 123995 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 57 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993926.48607 | 2115175.33347 | 37.7875185929993 | -122.464828746995 | (37.7875185929993, -122.464828746995) | |||
| 23988 | 23988 | 242589 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 662 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6002096.62567 | 2102091.27853 | 37.7520606767596 | -122.43562532796801 | (37.7520606767596, -122.435625327968) | |||
| 24096 | 24096 | 242684 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 415 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002983.5288 | 2105821.24462 | 37.7623526073126 | -122.432824725778 | (37.7623526073126, -122.432824725778) | |||
| 24157 | 24157 | 242668 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3956 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6003431.93143 | 2102453.4748 | 37.7531309356663 | -122.431033493027 | (37.7531309356663, -122.431033493027) | |||
| 24162 | 24162 | 215566 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993936.1007 | 2096327.5375 | 37.735768007292705 | -122.463427186434 | (37.7357680072927, -122.463427186434) | |||
| 24271 | 24271 | 242734 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 161 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6000369.04926 | 2105610.16538 | 37.761624404675004 | -122.44185206023998 | (37.761624404675, -122.44185206024) | |||
| 24337 | 24337 | 198558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6014602.581680001 | 2096122.3818299999 | 37.73637372225429 | -122.391960171423 | (37.7363737222543, -122.391960171423) | |||
| 24472 | 24472 | 242424 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 209 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005453.21466 | 2102408.07888 | 37.7531206159404 | -122.424040259559 | (37.7531206159404, -122.424040259559) | |||
| 24564 | 24564 | 242476 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2843 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008369.73896 | 2101880.11255 | 37.751835171760796 | -122.413916963601 | (37.7518351717608, -122.413916963601) | |||
| 24593 | 24593 | 242660 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 536 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6002865.43982 | 2102718.0317700002 | 37.753825230272206 | -122.43301143134899 | (37.7538252302722, -122.433011431349) | |||
| 24594 | 24594 | 115551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.39019037219299 | (37.7585616474178, -122.390190372193) | ||
| 24769 | 24769 | 244936 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 294 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | |||
| 24836 | 24836 | 242630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2135 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008454.6994199995 | 2100396.0019400003 | 37.7477649076301 | -122.41351820420799 | (37.7477649076301, -122.413518204208) | |||
| 24976 | 24976 | 180546 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 228 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002372.12567 | 2091162.28093 | 37.722067814370206 | -122.433891501616 | (37.7220678143702, -122.433891501616) | |||
| 25132 | 25132 | 242416 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3652 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.79468 | 2101978.6432 | 37.7519371701822 | -122.424273995163 | (37.7519371701822, -122.424273995163) | |||
| 25133 | 25133 | 198661 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6013934.2668 | 2107404.04412 | 37.7673136301584 | -122.39506079103 | (37.7673136301584, -122.39506079103) | |||
| 25187 | 25187 | 242534 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2360 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008152.44131 | 2104693.50741 | 37.7595479078416 | -122.414867509238 | (37.7595479078416, -122.414867509238) | |||
| 25289 | 25289 | 215519 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1800 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993153.53472 | 2103109.22386 | 37.7543436777209 | -122.466625589315 | (37.7543436777209, -122.466625589315) | |||
| 25433 | 25433 | 137020 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6002995.15639 | 2117477.21245 | 37.7943576461387 | -122.433617572612 | (37.7943576461387, -122.433617572612) | |||
| 25444 | 25444 | 198476 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6015193.91802 | 2104744.93458 | 37.7600822588968 | -122.390517973622 | (37.7600822588968, -122.390517973622) | |||
| 25485 | 25485 | 198641 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015975.52657 | 2108754.29642 | 37.7711344286414 | -122.388094538146 | (37.7711344286414, -122.388094538146) | ||||
| 25498 | 25498 | 138314 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2400 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002354.5046 | 2115095.0933 | 37.7877805887944 | -122.435663794316 | (37.7877805887944, -122.435663794316) | |||
| 25512 | 25512 | 242466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3035 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008425.69646 | 2100850.8377799997 | 37.7490121566833 | -122.41365066085501 | (37.7490121566833, -122.413650660855) | |||
| 25770 | 25770 | 198550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6014437.8332 | 2096238.2314099998 | 37.736682673554895 | -122.392537881536 | (37.7366826735549, -122.392537881536) | |||
| 25771 | 25771 | 198601 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6016359.83761 | 2108655.37305 | 37.770884091558706 | -122.386758280474 | (37.7708840915587, -122.386758280474) | ||||
| 25994 | 25994 | 198552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1737 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6014479.14008 | 2096215.50605 | 37.7366225682648 | -122.39239347560499 | (37.7366225682648, -122.392393475605) | |||
| 26007 | 26007 | 215558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994076.83101 | 2096438.6024200001 | 37.7360810711916 | -122.46294868592699 | (37.7360810711916, -122.462948685927) | |||
| 26126 | 26126 | 121876 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 198 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 5990258.7771 | 2114125.11195 | 37.7844228334992 | -122.477441359496 | (37.7844228334992, -122.477441359496) | |||
| 26146 | 26146 | 136958 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Divisadero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6000568.04629 | 2118355.71273 | 37.7966317645105 | -122.44207872445801 | (37.7966317645105, -122.442078724458) | |||
| 26682 | 26682 | 198540 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6014330.01059 | 2096395.8315299999 | 37.7371094225658 | -122.39292169687401 | (37.7371094225658, -122.392921696874) | |||
| 26697 | 26697 | 200627 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1360 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016371.342 | 2094881.4594 | 37.7330644372172 | -122.385758304658 | (37.7330644372172, -122.385758304658) | |||
| 26832 | 26832 | 242461 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 206 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006823.0502 | 2098332.30015 | 37.7420066942676 | -122.41901402330099 | (37.7420066942676, -122.419014023301) | |||
| 26996 | 26996 | 180571 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009971.64388 | 2093913.4655400002 | 37.7300503209452 | -122.40781562289801 | (37.7300503209452, -122.407815622898) | |||
| 27071 | 27071 | 137049 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008515.90058 | 2116780.9457099997 | 37.7927575660663 | -122.414465794683 | (37.7927575660663, -122.414465794683) | |||
| 27196 | 27196 | 198667 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 124 Russ St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6010302.39718 | 2111555.70743 | 37.778510504382794 | -122.407915770511 | (37.7785105043828, -122.407915770511) | |||
| 27464 | 27464 | 215498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993979.5407 | 2097285.08347 | 37.7383996933922 | -122.46334646239201 | (37.7383996933922, -122.463346462392) | |||
| 27511 | 27511 | 215496 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 69 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993975.721530001 | 2097357.94979 | 37.7385995461283 | -122.46336495334299 | (37.7385995461283, -122.463364953343) | |||
| 27525 | 27525 | 215551 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 212 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994048.13405 | 2096632.6874900002 | 37.7366123276804 | -122.46306197983401 | (37.7366123276804, -122.463061979834) | |||
| 27718 | 27718 | 137031 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1752 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005234.06309 | 2117850.62901 | 37.795509733448604 | -122.42589727954599 | (37.7955097334486, -122.425897279546) | |||
| 27777 | 27777 | 112787 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 913 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6015266.54568 | 2104367.00121 | 37.7590485637711 | -122.390240382605 | (37.7590485637711, -122.390240382605) | |||
| 27992 | 27992 | 242717 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 799 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002466.2295 | 2103597.2889400003 | 37.7562168081645 | -122.434454852233 | (37.7562168081645, -122.434454852233) | |||
| 28058 | 28058 | 215555 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994079.01038 | 2096505.73845 | 37.7362655356317 | -122.46294602033701 | (37.7362655356317, -122.462946020337) | |||
| 28071 | 28071 | 198653 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6014062.16151 | 2107274.8882299997 | 37.7669661078202 | -122.39460937273701 | (37.7669661078202, -122.394609372737) | |||
| 28099 | 28099 | 215484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.739679229001496 | -122.46304340523001 | (37.7396792290015, -122.46304340523) | |||
| 28150 | 28150 | 242672 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3996 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003206.21918 | 2102449.14663 | 37.753106259167204 | -122.431813741205 | (37.7531062591672, -122.431813741205) | |||
| 28275 | 28275 | 198639 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015936.8101699995 | 2108752.54325 | 37.7711274696967 | -122.38822833839 | (37.7711274696967, -122.38822833839) | ||||
| 28346 | 28346 | 180535 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010393.23752 | 2092315.54751 | 37.7256863661069 | -122.406245574796 | (37.7256863661069, -122.406245574796) | |||
| 28363 | 28363 | 198495 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015477.3225 | 2104627.00235 | 37.7597741601603 | -122.389529568345 | (37.7597741601603, -122.389529568345) | |||
| 28445 | 28445 | 115740 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4075 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6001859.0 | 2105815.0 | 37.7622716175276 | -122.43671359817499 | (37.7622716175276, -122.436713598175) | |||
| 28480 | 28480 | 198590 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013501.44813 | 2107135.10099 | 37.766551094088996 | -122.39653900576599 | (37.766551094089, -122.396539005766) | |||
| 28496 | 28496 | 180552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001906.70426 | 2091457.0894099998 | 37.722850869347205 | -122.435521425698 | (37.7228508693472, -122.435521425698) | |||
| 28505 | 28505 | 242649 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6008827.11611 | 2103342.8072099998 | 37.755877078492 | -122.41243866522301 | (37.755877078492, -122.412438665223) | |||
| 28718 | 28718 | 242531 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2108 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008079.16093 | 2106076.64679 | 37.7633415719814 | -122.415218859973 | (37.7633415719814, -122.415218859973) | |||
| 28746 | 28746 | 215520 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1750 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993138.05131 | 2103539.75101 | 37.75552490035879 | -122.466710427759 | (37.7555249003588, -122.466710427759) | |||
| 28754 | 28754 | 242395 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1772 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005651.81735 | 2107273.82605 | 37.7664920266105 | -122.423699384137 | (37.7664920266105, -122.423699384137) | |||
| 28826 | 28826 | 247019 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 530 Valley St | 1 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6002475.46095 | 2099175.15499 | 37.744075198804204 | -122.43410681909799 | (37.7440751988042, -122.434106819098) | |||
| 28845 | 28845 | 242449 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 150 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997972.72284 | 2105963.31603 | 37.7624572299272 | -122.450165395921 | (37.7624572299272, -122.450165395921) | |||
| 28851 | 28851 | 136992 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2299 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000906.27756 | 2119628.7307700003 | 37.8001464049771 | -122.44099974484699 | (37.8001464049771, -122.440999744847) | |||
| 29292 | 29292 | 242538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2394 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008164.432019999 | 2104565.65474 | 37.7591975274662 | -122.41481699071001 | (37.7591975274662, -122.41481699071) | |||
| 29366 | 29366 | 99109 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1814 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6001553.766 | 2114786.5748 | 37.7868879621167 | -122.43841208081999 | (37.7868879621167, -122.43841208082) | |||
| 29606 | 29606 | 242493 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2500 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008201.36551 | 2103826.65132 | 37.7571704681572 | -122.414636959936 | (37.7571704681572, -122.414636959936) | |||
| 29755 | 29755 | 242554 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2471 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008247.70974 | 2104059.3837900003 | 37.75781210207129 | -122.414493151139 | (37.7578121020713, -122.414493151139) | |||
| 29756 | 29756 | 215492 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993992.82093 | 2097521.50716 | 37.7390496190449 | -122.463317697564 | (37.7390496190449, -122.463317697564) | |||
| 29855 | 29855 | 198531 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 7ft | 6014434.12864 | 2096316.99865 | 37.736898746479895 | -122.392556198035 | (37.7368987464799, -122.392556198035) |
JSON shape: default, array, newline-delimited
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");