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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
137681 | 137681 | 183427 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2419 22nd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 5989498.022999999 | 2098855.9096 | 37.7424535651362 | -122.478956057135 | (37.7424535651362, -122.478956057135) | |||
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) | |||
148678 | 148678 | 180562 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 4101 Alemany Blvd | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5991620.890430001 | 2086817.0358099998 | 37.70952085356139 | -122.470739173794 | (37.7095208535614, -122.470739173794) | |||
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) | |||
120690 | 120690 | 110630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991857.0 | 2101850.0 | 37.7508112705894 | -122.47101756601101 | (37.7508112705894, -122.471017566011) | |||||
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) | |||
10157 | 10157 | 173899 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
10163 | 10163 | 173898 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | |||
148557 | 148557 | 215480 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 55 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 5992620.877830001 | 2096424.4716400001 | 37.7359583002413 | -122.467981434219 | (37.7359583002413, -122.467981434219) | |||
133254 | 133254 | 215479 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 85 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5992627.2877 | 2096233.3886799999 | 37.7354340044744 | -122.467945378584 | (37.7354340044744, -122.467945378584) | |||
46850 | 46850 | 123166 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 579 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5992807.48236 | 2111535.8684400003 | 37.777461036027496 | -122.468435352622 | (37.7774610360275, -122.468435352622) | ||||
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) |
47189 | 47189 | 215569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 262 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993829.85654 | 2096316.71457 | 37.735732168414 | -122.46379372579901 | (37.735732168414, -122.463793725799) | |||
49155 | 49155 | 215568 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 262 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993854.87202 | 2096314.6537799998 | 37.735727951492294 | -122.463707088708 | (37.7357279514923, -122.463707088708) | |||
131907 | 131907 | 215515 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993879.1268 | 2096286.34679 | 37.735651625116795 | -122.463621177382 | (37.7356516251168, -122.463621177382) | |||
62362 | 62362 | 215567 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 254 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993893.11792 | 2096318.4579099999 | 37.735740600456 | -122.46357513479201 | (37.735740600456, -122.463575134792) | |||
74578 | 74578 | 215514 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993902.7407599995 | 2096288.82132 | 37.7356597801802 | -122.463539714991 | (37.7356597801802, -122.463539714991) | |||
56932 | 56932 | 215513 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993924.28661 | 2096292.23015 | 37.7356703813878 | -122.463465470563 | (37.7356703813878, -122.463465470563) | |||
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) | |||
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) | |||
179962 | 179962 | 215540 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993944.908340001 | 2097392.63187 | 37.7386929991944 | -122.46347400603001 | (37.7386929991944, -122.46347400603) | |||
175108 | 175108 | 215542 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993945.302519999 | 2097292.64109 | 37.7384184721345 | -122.463465388735 | (37.7384184721345, -122.463465388735) | |||
164646 | 164646 | 215541 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993946.31928 | 2097307.1562900003 | 37.73845838583971 | -122.463462926386 | (37.7384583858397, -122.463462926386) | |||
170673 | 170673 | 215512 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993946.596609999 | 2096298.3133099999 | 37.7356883696217 | -122.463388778181 | (37.7356883696217, -122.463388778181) | |||
33083 | 33083 | 215539 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 70 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993947.30597 | 2097439.0269400002 | 37.73882052663561 | -122.463469082233 | (37.7388205266356, -122.463469082233) | |||
162282 | 162282 | 215543 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993948.48206 | 2097274.4923 | 37.738368823268296 | -122.46345307882 | (37.7383688232683, -122.46345307882) | |||
32806 | 32806 | 215544 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993951.56494 | 2097251.7365 | 37.738306519129 | -122.46344076888398 | (37.738306519129, -122.463440768884) | |||
38137 | 38137 | 215538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 66 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993953.054409999 | 2097475.42453 | 37.7389207965449 | -122.46345184763099 | (37.7389207965449, -122.463451847631) | |||
167961 | 167961 | 215565 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993953.18487 | 2096333.32123 | 37.7357848722665 | -122.46336853982099 | (37.7357848722665, -122.463368539821) | |||
47464 | 47464 | 215545 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993953.28384 | 2097231.84575 | 37.7382520031164 | -122.46343338275899 | (37.7382520031164, -122.463433382759) | |||
174423 | 174423 | 215537 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 66 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993955.64334 | 2097496.99749 | 37.7389801796769 | -122.463444461504 | (37.7389801796769, -122.463444461504) | |||
157065 | 157065 | 215536 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 56 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993957.82429 | 2097516.0973 | 37.739032748648796 | -122.463438306534 | (37.7390327486488, -122.463438306534) | |||
171609 | 171609 | 215535 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 56 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993961.10276 | 2097536.59197 | 37.739089210791 | -122.46342845805799 | (37.739089210791, -122.463428458058) | |||
156720 | 156720 | 215534 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 50 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993970.3948 | 2097572.2061 | 37.7391875336652 | -122.463398914422 | (37.7391875336652, -122.463398914422) | |||
109259 | 109259 | 215564 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 250 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993972.9824 | 2096339.8161099998 | 37.7358038461725 | -122.463300563692 | (37.7358038461725, -122.463300563692) | |||
134609 | 134609 | 215533 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 42 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993973.161169999 | 2097585.26638 | 37.7392235533179 | -122.463390297139 | (37.7392235533179, -122.463390297139) | |||
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) | |||
120433 | 120433 | 215497 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 73 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993976.24019 | 2097340.1859999998 | 37.738550801067 | -122.46336187137 | (37.738550801067, -122.46336187137) | |||
176765 | 176765 | 215495 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 69 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993977.518540001 | 2097401.11032 | 37.7387181577226 | -122.46336187135401 | (37.7387181577226, -122.463361871354) | |||
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) | |||
172608 | 172608 | 215494 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 61 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993979.60004 | 2097443.67302 | 37.7388351442124 | -122.463357762357 | (37.7388351442124, -122.463357762357) | |||
41301 | 41301 | 215532 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 42 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993980.354309999 | 2097605.67891 | 37.739280015454604 | -122.463366907564 | (37.7392800154546, -122.463366907564) | |||
135165 | 135165 | 215563 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 244 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993985.88408 | 2096348.3750200002 | 37.735828090088894 | -122.463256578734 | (37.7358280900889, -122.463256578734) | |||
134274 | 134274 | 215493 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993987.93159 | 2097500.89824 | 37.7389927504044 | -122.46333310743601 | (37.7389927504044, -122.463333107436) | |||
184959 | 184959 | 215546 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993989.2635699995 | 2097198.82691 | 37.738163414500605 | -122.463306588246 | (37.7381634145006, -122.463306588246) | |||
71787 | 71787 | 215531 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 40 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993990.15739 | 2097631.70954 | 37.7393520538516 | -122.46333490158199 | (37.7393520538516, -122.463334901582) | |||
39846 | 39846 | 215499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993991.18061 | 2097202.58443 | 37.738173842158105 | -122.463300232714 | (37.7381738421581, -122.463300232714) | |||
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) | |||
33717 | 33717 | 215511 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993997.50574 | 2096315.53912 | 37.73573860035479 | -122.463214016518 | (37.7357386003548, -122.463214016518) | |||
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) | |||
178117 | 178117 | 215490 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 45 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994002.63682 | 2097564.4991099997 | 37.739168229725706 | -122.46328687779601 | (37.7391682297257, -122.463286877796) | |||
39997 | 39997 | 215489 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 37 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994010.31675 | 2097590.67092 | 37.739240533433296 | -122.463262222872 | (37.7392405334333, -122.463262222872) | |||
39650 | 39650 | 215547 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994018.95115 | 2096748.4675900002 | 37.7369285500121 | -122.46317127533999 | (37.7369285500121, -122.46317127534) | |||
153089 | 153089 | 215510 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 299 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994019.7098199995 | 2096325.7252599997 | 37.73576784809 | -122.463137987822 | (37.73576784809, -122.463137987822) | |||
158809 | 158809 | 215530 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 20 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994021.331259999 | 2097709.05499 | 37.739566221105704 | -122.463232727835 | (37.7395662211057, -122.463232727835) | |||
133047 | 133047 | 215548 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994023.18881 | 2096729.95205 | 37.736877955053295 | -122.463155280903 | (37.7368779550533, -122.463155280903) | |||
36619 | 36619 | 215549 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994024.47246 | 2096717.6403700002 | 37.7368442241821 | -122.463149949734 | (37.7368442241821, -122.463149949734) | |||
33160 | 33160 | 215550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994032.03336 | 2096692.14483 | 37.7367746553097 | -122.463121959218 | (37.7367746553097, -122.463121959218) | |||
169976 | 169976 | 215488 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 33 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994033.38086 | 2097656.1674099998 | 37.7394216991581 | -122.463187229312 | (37.7394216991581, -122.463187229312) | |||
131337 | 131337 | 215562 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 244 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994036.57489 | 2096375.72 | 37.735906092783 | -122.463083305449 | (37.735906092783, -122.463083305449) | |||
171259 | 171259 | 215529 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 14 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994038.78637 | 2097743.43372 | 37.739661622078295 | -122.46317486995001 | (37.7396616220783, -122.46317486995) |
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");