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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107475 | 107475 | 110612 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586.0 | 2101167.0 | 37.7490933856104 | -122.46153099469801 | (37.7490933856104, -122.461530994698) | ||
115379 | 115379 | 107599 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 177 CORBETT AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000269.8 | 2105595.5 | 37.7615784812961 | -122.44219426929199 | (37.7615784812961, -122.442194269292) | ||||||
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) | |
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) | |||
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) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
30116 | 30116 | 242559 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2335 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008205.80175 | 2104824.21254 | 37.7599097923189 | -122.41469221159201 | (37.7599097923189, -122.414692211592) | |||
30152 | 30152 | 138627 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2691 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001082.2561 | 2114862.4803 | 37.7870695481569 | -122.44004883746 | (37.7870695481569, -122.44004883746) | |||
30273 | 30273 | 242422 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 211 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6005454.341019999 | 2102381.96532 | 37.7530489777513 | -122.424034507499 | (37.7530489777513, -122.424034507499) | |||
30387 | 30387 | 242452 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 55 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998623.14382 | 2105365.8187700002 | 37.760853851139395 | -122.447872819878 | (37.7608538511394, -122.447872819878) | |||
30427 | 30427 | 242542 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2438 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008177.760869999 | 2104227.05215 | 37.758268551175796 | -122.41474692993299 | (37.7582685511758, -122.414746929933) | |||
30589 | 30589 | 80188 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1435 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2002 12:00:00 AM | 5 | 6008710.7243 | 2109332.6568 | 37.7723172927739 | -122.41326474488501 | (37.7723172927739, -122.413264744885) | ||
30837 | 30837 | 123696 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995493.19231 | 2113537.8911 | 37.7831128208781 | -122.45928967118799 | (37.7831128208781, -122.459289671188) | |||
31057 | 31057 | 242727 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 227 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003563.38806 | 2106917.83048 | 37.7653964383127 | -122.430897473255 | (37.7653964383127, -122.430897473255) | |||
31822 | 31822 | 137651 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1356 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002685.3767 | 2111663.7322 | 37.778377725595 | -122.434273630973 | (37.778377725595, -122.434273630973) | |||
32130 | 32130 | 242465 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3049 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008428.65131 | 2100831.41677 | 37.74895899686 | -122.41363906948 | (37.74895899686, -122.41363906948) | |||
32521 | 32521 | 136996 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2241 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003218.2854 | 2116412.88242 | 37.791447926534794 | -122.432769452565 | (37.7914479265348, -122.432769452565) | |||
32812 | 32812 | 242726 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003143.88793 | 2107880.88822 | 37.7680169827249 | -122.432417216901 | (37.7680169827249, -122.432417216901) | |||
33042 | 33042 | 242763 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 230 States St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6000829.7469 | 2106510.44882 | 37.764122601704 | -122.440323264923 | (37.764122601704, -122.440323264923) | |||
33321 | 33321 | 242437 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 155 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004941.65866 | 2098698.95529 | 37.7429073221216 | -122.42554536763399 | (37.7429073221216, -122.425545367634) | |||
33539 | 33539 | 242644 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3352 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006651.71456 | 2102639.84296 | 37.7538245800571 | -122.419912046731 | (37.7538245800571, -122.419912046731) | |||
33611 | 33611 | 72449 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3687 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 11 | 5997241.71464 | 2115032.69529 | 37.7873175292136 | -122.45334848155899 | (37.7873175292136, -122.453348481559) | ||
34463 | 34463 | 180569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 39 Tulane St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007329.333980001 | 2093756.2890599999 | 37.729470469574 | -122.416939308919 | (37.729470469574, -122.416939308919) | |||
34504 | 34504 | 141466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 347 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999002.8448 | 2111571.7056 | 37.777915339520604 | -122.447006209301 | (37.7779153395206, -122.447006209301) | |||
34627 | 34627 | 123587 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 62 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994280.07322 | 2115179.97331 | 37.78755171256329 | -122.463605752716 | (37.7875517125633, -122.463605752716) | |||
34676 | 34676 | 242606 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 906 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997226.54796 | 2107348.00991 | 37.7662165183906 | -122.45284607618099 | (37.7662165183906, -122.452846076181) | |||
34788 | 34788 | 242635 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6008498.0823800005 | 2099637.09031 | 37.745683540962794 | -122.41331452755101 | (37.7456835409628, -122.413314527551) | |||
35154 | 35154 | 123692 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 11 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995433.731430001 | 2113533.85695 | 37.7830983254289 | -122.45949508803699 | (37.7830983254289, -122.459495088037) | |||
35262 | 35262 | 242578 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3027 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006618.78415 | 2106687.4416799997 | 37.764936489945796 | -122.4203131902 | (37.7649364899458, -122.4203131902) | |||
35735 | 35735 | 242393 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1762 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005694.97443 | 2107277.4007900003 | 37.7665042780669 | -122.42355036555901 | (37.7665042780669, -122.423550365559) | |||
35835 | 35835 | 242642 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 952 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007375.48933 | 2101738.08123 | 37.751389296887396 | -122.41734516035801 | (37.7513892968874, -122.417345160358) | |||
35859 | 35859 | 137027 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2057 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003211.766559999 | 2118215.6872 | 37.7963975954305 | -122.432920859704 | (37.7963975954305, -122.432920859704) | |||
36126 | 36126 | 215491 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 45 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5993998.37881 | 2097545.6525 | 37.7391162363258 | -122.463300232728 | (37.7391162363258, -122.463300232728) | |||
36255 | 36255 | 242720 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 851 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004370.3751300005 | 2103913.58582 | 37.757193188642894 | -122.427892201578 | (37.7571931886429, -122.427892201578) | |||
36271 | 36271 | 136969 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2640 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000252.03874 | 2118890.8974200003 | 37.7980832262203 | -122.443210635483 | (37.7980832262203, -122.443210635483) | |||
36294 | 36294 | 136971 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2416 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6000253.905669999 | 2119587.5912099998 | 37.799996268582 | -122.4432542409 | (37.799996268582, -122.4432542409) | |||
36418 | 36418 | 215485 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994064.51337 | 2097723.86139 | 37.7396093633696 | -122.46308449795299 | (37.7396093633696, -122.463084497953) | |||
36864 | 36864 | 242706 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 255 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6002732.58022 | 2104426.20482 | 37.7585079282189 | -122.43359295906099 | (37.7585079282189, -122.433592959061) | |||
36925 | 36925 | 242527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1942 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008018.225869999 | 2107131.69026 | 37.7662350516233 | -122.415504314688 | (37.7662350516233, -122.415504314688) | |||
37788 | 37788 | 137884 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1928 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003417.2048 | 2115384.0895 | 37.7886344027041 | -122.432007699107 | (37.7886344027041, -122.432007699107) | |||
38030 | 38030 | 242765 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 64 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002894.46914 | 2108642.40455 | 37.7700937736426 | -122.43333435091499 | (37.7700937736426, -122.433334350915) |
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");