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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6092 | 6092 | 46303 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 7478 | 7478 | 46291 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10371 | 10371 | 46304 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11759 | 11759 | 46302 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 12993 | 12993 | 19985 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | ||||||||
| 13945 | 13945 | 46285 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 16163 | 16163 | 26637 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X3 | |||||||
| 130427 | 130427 | 34703 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 591 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50359 | 5981606.7893900005 | 2111740.24587 | 37.777368864087 | -122.50719674082501 | (37.777368864087, -122.507196740825) | |
| 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) | ||||
| 176276 | 176276 | 183730 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2259 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5985737.4508 | 2099845.7715 | 37.7449523648453 | -122.492031672537 | (37.7449523648453, -122.492031672537) | |||
| 162741 | 162741 | 33151 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2434 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 7 | Permit Number 37374 | 5987066.8878 | 2098694.8228 | 37.741869787152204 | -122.487350256926 | (37.7418697871522, -122.487350256926) | |
| 132989 | 132989 | 120388 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 151 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5988095.61955 | 2115306.5323400004 | 37.787540921662604 | -122.485011751628 | (37.7875409216626, -122.485011751628) | |||
| 155211 | 155211 | 120236 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 554 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5988464.64157 | 2112199.70467 | 37.779031939395296 | -122.483507171476 | (37.7790319393953, -122.483507171476) | |||
| 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) | |||
| 89302 | 89302 | 31777 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.74110093693479 | -122.47907928432699 | (37.7411009369348, -122.479079284327) | ||
| 57254 | 57254 | 120817 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 125 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5989574.75375 | 2114524.02395 | 37.785478419170396 | -122.47983701813999 | (37.7854784191704, -122.47983701814) | |||
| 178687 | 178687 | 110079 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2751x Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5990053.539580001 | 2111933.09723 | 37.7783922604051 | -122.477991095219 | (37.7783922604051, -122.477991095219) | |||
| 40222 | 40222 | 121875 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 198 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5990257.12502 | 2114144.50591 | 37.784475988028 | -122.477448493001 | (37.784475988028, -122.477448493001) | |||
| 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) | |||
| 103909 | 103909 | 65135 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 29 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1989 12:00:00 AM | 24 | 6x25 | Permit Number 27110 | 5990805.90423 | 2114815.75298 | 37.7863508732035 | -122.475598955261 | (37.7863508732035, -122.475598955261) | |
| 52546 | 52546 | 68218 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 233 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/2010 12:00:00 AM | 4 | Permit Number 53885 | 5990842.3093 | 2113821.7941400004 | 37.7836238495535 | -122.475400406913 | (37.7836238495535, -122.475400406913) | |
| 143524 | 143524 | 88555 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 609 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3x3 | Permit Number 51500 | 5990920.3 | 2111212.9 | 37.7764650666065 | -122.47494009298401 | (37.7764650666065, -122.474940092984) | |||
| 134625 | 134625 | 54984 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 609 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 5 | Permit Number 10862 | 5990934.1509 | 2111213.50842 | 37.7764675398398 | -122.474892223692 | (37.7764675398398, -122.474892223692) | ||
| 102460 | 102460 | 11630 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 5991380.578 | 2094219.03 | 37.7298310098579 | -122.47210889946501 | (37.7298310098579, -122.472108899465) | |||
| 97919 | 97919 | 11876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 107376 | 107376 | 11877 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 139746 | 139746 | 11878 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 85950 | 85950 | 1325 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 4051X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5991764.76245 | 2086963.37686 | 37.709930989883496 | -122.47025258193399 | (37.7099309898835, -122.470252581934) | |||
| 165536 | 165536 | 215522 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2669 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992094.03809 | 2097402.04556 | 37.738612033228996 | -122.469874065536 | (37.738612033229, -122.469874065536) | |||
| 120689 | 120689 | 112514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1014 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5992342.97239 | 2113476.2606 | 37.7827619817135 | -122.47018356398998 | (37.7827619817135, -122.47018356399) | |||
| 62314 | 62314 | 215478 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1283 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5992361.60735 | 2106714.7447 | 37.7641977589329 | -122.4696267106 | (37.7641977589329, -122.4696267106) | |||
| 50736 | 50736 | 123896 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 175 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5992405.8238 | 2114312.4489599997 | 37.785061558619105 | -122.470027031648 | (37.7850615586191, -122.470027031648) | |||
| 41264 | 41264 | 123153 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 506 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992845.37698 | 2111963.44852 | 37.7786372439018 | -122.46833537820801 | (37.7786372439018, -122.468335378208) | |||
| 75127 | 75127 | 100368 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 718 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6x9 | 5992896.29545 | 2110550.04844 | 37.7747593697556 | -122.46805639472099 | (37.7747593697556, -122.468056394721) | |||
| 107805 | 107805 | 94494 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 750 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5992906.29601 | 2110338.45907 | 37.7741789797645 | -122.46800640707599 | (37.7741789797645, -122.468006407076) | ||||
| 160672 | 160672 | 123129 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 758 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992907.031830001 | 2110299.16217 | 37.7740711235286 | -122.468001002791 | (37.7740711235286, -122.468001002791) | |||
| 41971 | 41971 | 215474 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1421 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5993009.42995 | 2105791.52331 | 37.7617002561925 | -122.46731896212201 | (37.7617002561925, -122.467318962122) | |||
| 94890 | 94890 | 108482 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 195x 09TH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993013.6 | 2114237.0 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | ||||
| 97310 | 97310 | 108480 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 195x 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993013.6 | 2114237.0 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | ||||
| 114456 | 114456 | 108481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 195x 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993013.6 | 2114237.0 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | ||||
| 180659 | 180659 | 215475 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993086.32041 | 2105916.03813 | 37.76204657971879 | -122.467062084267 | (37.7620465797188, -122.467062084267) | |||
| 185665 | 185665 | 215476 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993096.43343 | 2105917.73669 | 37.7620518272484 | -122.467027231034 | (37.7620518272484, -122.467027231034) | |||
| 51217 | 51217 | 215521 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1750 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993133.83624 | 2103556.81567 | 37.755571512239 | -122.466726245046 | (37.755571512239, -122.466726245046) | |||
| 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) | |||
| 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) | |||
| 47292 | 47292 | 54971 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 558 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1974 12:00:00 AM | 14 | Permit Number 14440 | 5993167.14361 | 2111676.4715400003 | 37.7778678620954 | -122.467201401573 | (37.7778678620954, -122.467201401573) | ||
| 17976 | 17976 | 46914 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 120581 | 120581 | 46913 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 144802 | 144802 | 46912 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | ||
| 159220 | 159220 | 215477 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5993371.53162 | 2104323.9029 | 37.7576914499066 | -122.465959963285 | (37.7576914499066, -122.465959963285) | |||
| 115214 | 115214 | 48645 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45938 | 5993372.07519062 | 2104329.12614097 | 37.7577058229285 | -122.465958462939 | (37.7577058229285, -122.465958462939) | ||
| 67472 | 67472 | 112503 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 645 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5993489.26776 | 2113460.89025 | 37.7827859823771 | -122.46621678157 | (37.7827859823771, -122.46621678157) | |||
| 123554 | 123554 | 97643 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 642 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5993491.08963 | 2113521.4936900004 | 37.782952488061206 | -122.466214884321 | (37.7829524880612, -122.466214884321) | |||
| 111916 | 111916 | 111056 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 623 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5993570.9875 | 2113459.7195599996 | 37.7827874825496 | -122.46593398291999 | (37.7827874825496, -122.46593398292) | |||
| 29948 | 29948 | 55354 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 601 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1972 12:00:00 AM | 10 | 3x3 | Permit Number 11287 | 5993641.36369 | 2113466.98214 | 37.782811483217 | -122.46569104074301 | (37.782811483217, -122.465691040743) | |
| 141515 | 141515 | 68693 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 600 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1993 12:00:00 AM | 12 | 3x3 | Permit Number 32603 | 5993650.82821 | 2113525.7859099996 | 37.7829734883164 | -122.46566257132 | (37.7829734883164, -122.46566257132) |
| 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) | |||
| 169568 | 169568 | 123996 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 57 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993927.17847 | 2115159.11926 | 37.787474113130706 | -122.46482517350599 | (37.7874741131307, -122.464825173506) | |||
| 137221 | 137221 | 115468 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 83 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 4x4 | 5993932.33914 | 2114999.07157 | 37.7870349634341 | -122.464795691681 | (37.7870349634341, -122.464795691681) | |||
| 188123 | 188123 | 215516 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 88 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994119.69741 | 2093345.3808900001 | 37.7275903136211 | -122.462576174158 | (37.7275903136211, -122.462576174158) | |||
| 103898 | 103898 | 96758 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 24 | 4x4 | Permit Number 771133 | 5994277.344819999 | 2115214.0458299997 | 37.7876451092051 | -122.46361766617201 | (37.7876451092051, -122.463617666172) | |
| 176776 | 176776 | 105953 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | ||
| 169065 | 169065 | 123586 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 62 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994279.04973 | 2115190.28174 | 37.787579957729 | -122.463610042193 | (37.787579957729, -122.463610042193) | |||
| 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) | |||
| 30311 | 30311 | 56524 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 623 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5994686.99201 | 2111263.70978 | 37.776822144368 | -122.461913814497 | (37.776822144368, -122.461913814497) | ||||
| 171432 | 171432 | 113444 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 742 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5994761.5711 | 2110535.58365 | 37.7748271966325 | -122.461603021673 | (37.7748271966325, -122.461603021673) | |||
| 40244 | 40244 | 113443 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 742 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5994762.07163 | 2110522.4331099996 | 37.7747911175465 | -122.46160033660699 | (37.7747911175465, -122.461600336607) | |||
| 103372 | 103372 | 81863 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.729301806319704 | -122.459920577502 | (37.7293018063197, -122.459920577502) | ||
| 149318 | 149318 | 36939 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.78649992768511 | -122.461372345087 | (37.7864999276851, -122.461372345087) | |
| 97468 | 97468 | 52332 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.45929215094101 | (37.7353714395789, -122.459292150941) | ||||
| 109476 | 109476 | 19301 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5995247.10654 | 2111496.409 | 37.7774933045144 | -122.459993084378 | (37.7774933045144, -122.459993084378) | |||
| 98502 | 98502 | 40800 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 167 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1999 12:00:00 AM | Permit Number 41749 | 5995317.58858632 | 2087395.72139247 | 37.711322874409596 | -122.458004690935 | (37.7113228744096, -122.458004690935) | |||
| 69582 | 69582 | 123690 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 36 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995350.47696 | 2113583.46561 | 37.7832297501219 | -122.459786707236 | (37.7832297501219, -122.459786707236) | |||
| 147833 | 147833 | 123691 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 35 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995371.26757 | 2113529.88581 | 37.7830838299438 | -122.45971089838801 | (37.7830838299438, -122.459710898388) | |||
| 152615 | 152615 | 123689 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 32 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995378.065669999 | 2113584.47155 | 37.783234098680296 | -122.45969133488501 | (37.7832340986803, -122.459691334885) | |||
| 156497 | 156497 | 123688 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 26 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995407.44637 | 2113586.67183 | 37.7832418295416 | -122.45958984952699 | (37.7832418295416, -122.459589849527) | |||
| 170681 | 170681 | 123687 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 24 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995428.99259 | 2113586.04452 | 37.7832413460359 | -122.459515263281 | (37.7832413460359, -122.459515263281) | |||
| 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) | |||
| 164598 | 164598 | 123686 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 14 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995454.47999 | 2113587.9744700002 | 37.7832481106401 | -122.459427227483 | (37.7832481106401, -122.459427227483) | |||
| 150723 | 150723 | 215523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Northwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995460.486769999 | 2094242.81923 | 37.7301315873058 | -122.458006001202 | (37.7301315873058, -122.458006001202) | |||
| 179766 | 179766 | 123693 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 9 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995461.176580001 | 2113536.44974 | 37.7831070225625 | -122.45940032745101 | (37.7831070225625, -122.459400327451) | |||
| 73654 | 73654 | 123685 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 8 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995474.7934 | 2113587.5491 | 37.7832481106245 | -122.459356920862 | (37.7832481106245, -122.459356920862) | |||
| 74854 | 74854 | 123694 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 7 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995476.231380001 | 2113538.07017 | 37.7831123374099 | -122.45934836169701 | (37.7831123374099, -122.459348361697) | |||
| 157153 | 157153 | 215524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995481.220919999 | 2094239.1346200001 | 37.730122661531205 | -122.457934054513 | (37.7301226615312, -122.457934054513) | |||
| 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) | |||
| 155708 | 155708 | 123695 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995508.22475 | 2113538.45627 | 37.7831152369297 | -122.459237706338 | (37.7831152369297, -122.459237706338) | |||
| 70174 | 70174 | 124598 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3999 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5995587.6492800005 | 2115135.34669 | 37.7875044349012 | -122.45907859763399 | (37.7875044349012, -122.459078597634) | |||
| 50126 | 50126 | 215570 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 96 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995600.39767 | 2096198.59734 | 37.7355097165874 | -122.457663772269 | (37.7355097165874, -122.457663772269) | |||
| 64836 | 64836 | 124680 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3885 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995618.999559999 | 2115788.29783 | 37.7892990644884 | -122.459017428632 | (37.7892990644884, -122.459017428632) | |||
| 156401 | 156401 | 43942 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3885 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2000 12:00:00 AM | 11 | Permit Number 43530 | 5995636.78457 | 2115791.89347 | 37.789309959494204 | -122.45895615544701 | (37.7893099594942, -122.458956155447) | ||
| 48967 | 48967 | 47103 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.777158358184295 | -122.45799622921801 | (37.7771583581843, -122.457996229218) | ||
| 78358 | 78358 | 1208 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3141 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5995992.87885 | 2086942.4061599998 | 37.7101169521706 | -122.455637985173 | (37.7101169521706, -122.455637985173) | |||
| 130639 | 130639 | 136976 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 340 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996232.2691 | 2114976.93638 | 37.7871065186035 | -122.456836895121 | (37.7871065186035, -122.456836895121) | |||
| 40626 | 40626 | 136975 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 340 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996232.67992 | 2114967.11027 | 37.7870795623305 | -122.456834762835 | (37.7870795623305, -122.456834762835) | |||
| 151867 | 151867 | 141076 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 189 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5996534.5761 | 2113062.8589 | 37.781868325512704 | -122.45565257993401 | (37.7818683255127, -122.455652579934) | |||
| 11281 | 11281 | 1166 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.1618700002 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | ||
| 111950 | 111950 | 114306 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997219.0 | 2107398.0 | 37.7663533458689 | -122.45287579158399 | (37.7663533458689, -122.452875791584) | ||||
| 152569 | 152569 | 74234 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 13 | 5997222.04614 | 2115031.5317599997 | 37.787313207081795 | -122.45341644603 | (37.7873132070818, -122.45341644603) | ||
| 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) | |||
| 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) |
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");