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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
30582 | 30582 | 137004 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2009 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6000928.49211 | 2115336.76015 | 37.7883630432624 | -122.440614856585 | (37.7883630432624, -122.440614856585) | |||
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) | ||
30655 | 30655 | 180517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6004131.62894 | 2090104.3716099998 | 37.719262719168896 | -122.42773399285299 | (37.7192627191689, -122.427733992853) | |||
30676 | 30676 | 242550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2498 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008196.7112300005 | 2103917.2718599997 | 37.7574190299918 | -122.414659469074 | (37.7574190299918, -122.414659469074) | |||
30762 | 30762 | 242600 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 Surrey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002217.824030001 | 2096159.0098299999 | 37.735778939431896 | -122.434782025597 | (37.7357789394319, -122.434782025597) | |||
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) | |||
32732 | 32732 | 242571 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008126.47482 | 2106341.38137 | 37.7640711307933 | -122.415073955818 | (37.7640711307933, -122.415073955818) | |||
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) | |||
32913 | 32913 | 198472 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 704 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015328.96766 | 2105817.04022 | 37.7630335209151 | -122.390125796375 | (37.7630335209151, -122.390125796375) | |||
33088 | 33088 | 198470 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 704 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6015369.36264 | 2105816.80106 | 37.7630351046092 | -122.38998606601601 | (37.7630351046092, -122.389986066016) | |||
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) | |||
33491 | 33491 | 105218 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2100 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 772439 | 5999896.69925 | 2116138.83336 | 37.790506517101996 | -122.44424234131701 | (37.790506517102, -122.444242341317) | |
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) |
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");