trees

2,365 rows where qSpecies_id = 31 sorted by XCoord

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord ▼ YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
31630 109498 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2440 23rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   5989239.6228 2098735.6386 37.7421083236068 -122.479840718717 (37.7421083236068, -122.479840718717) 1 8 3 29491 35
8224 254835 Private 9 Ulmus parvifolia :: Chinese Elm 31 250 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2019 12:00:00 AM 3 4x3 Permit Number 784635 5989365 2113673 37.7831295589045 -122.480500378386 (37.7831295589045, -122.480500378386) 11 6 2 55 26
58417 31777 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2126 Ulloa St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35251 5989451.98537783 2098364.25532499 37.7411009369348 -122.479079284327 (37.7411009369348, -122.479079284327) 1 8 3 29491 35
104535 183426 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2419 22nd Ave 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 0ft   5989497.0526 2098869.9717 37.7424921196482 -122.478960440771 (37.7424921196482, -122.478960440771) 1 8 3 29491 35
129503 183427 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2419 22nd Ave 3 Sidewalk: Curb side : Yard Tree Private 2     13 Width 0ft   5989498.023 2098855.9096 37.7424535651362 -122.478956057135 (37.7424535651362, -122.478956057135) 1 8 3 29491 35
157351 120817 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 125 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5989574.75375 2114524.02395 37.7854784191704 -122.47983701814 (37.7854784191704, -122.47983701814) 11 6 2 55 26
162990 110079 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2751x Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5990053.53958 2111933.09723 37.7783922604051 -122.477991095219 (37.7783922604051, -122.477991095219) 11 6 2 55 26
50402 121875 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 198 18th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   5990257.12502 2114144.50591 37.784475988028 -122.477448493001 (37.784475988028, -122.477448493001) 11 6 2 55 26
130145 121876 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 198 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 5ft   5990258.7771 2114125.11195 37.7844228334992 -122.477441359496 (37.7844228334992, -122.477441359496) 11 6 2 55 26
60 264971 Private 9 Ulmus parvifolia :: Chinese Elm 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26
14091 65135 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 29 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1989 12:00:00 AM 24 6x25 Permit Number 27110 5990777 2114840 37.7864157730855 -122.475700726719 (37.7864157730855, -122.475700726719) 11 6 1 54 33
176570 68218 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 233 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/04/2010 12:00:00 AM 4   Permit Number 53885 5990842.3093 2113821.79414 37.7836238495535 -122.475400406913 (37.7836238495535, -122.475400406913) 11 6 2 54 26
175636 88555 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 609 16th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/24/2008 12:00:00 AM   3x3 Permit Number 51500 5990920.3 2111212.9 37.7764650666065 -122.474940092984 (37.7764650666065, -122.474940092984) 11 6 2 54 26
146491 54984 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 609 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1972 12:00:00 AM 5   Permit Number 10862 5990934.1509 2111213.50842 37.7764675398398 -122.474892223692 (37.7764675398398, -122.474892223692) 11 6 2 54 26
97054 11630 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 400X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   5991380.578 2094219.03 37.7298310098579 -122.472108899465 (37.7298310098579, -122.472108899465) 9 8 4 64 40
108007 11876 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree PUC 8     12 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
118544 11877 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
176701 11878 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1501X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree PUC 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
190727 180562 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4101 Alemany Blvd 1 : Tree Private 2     12 Width 3ft   5991620.89043 2086817.03581 37.7095208535614 -122.470739173794 (37.7095208535614, -122.470739173794) 9 8 4 64 24
61112 1325 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4051X Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   5991764.76245 2086963.37686 37.7099309898835 -122.470252581934 (37.7099309898835, -122.470252581934) 9 8 4 64 24
169265 110630 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1050X MANDALAY LN 1 Unaccepted Street : Cutout Tree Private 2           5991857 2101850 37.7508112705894 -122.471017566011 (37.7508112705894, -122.471017566011) 1 8 4 29491 12
67600 215522 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2669 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5992094.03809 2097402.04556 37.738612033229 -122.469874065536 (37.738612033229, -122.469874065536) 1 8 4 59 40
18136 112514 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1014 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5992342.97239 2113476.2606 37.7827619817135 -122.47018356399 (37.7827619817135, -122.47018356399) 11 6 2 54 11
185571 215478 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1283 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   5992361.60735 2106714.7447 37.7641977589329 -122.4696267106 (37.7641977589329, -122.4696267106) 11 8 11 56 12
76895 123896 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 175 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5992405.8238 2114312.44896 37.7850615586191 -122.470027031648 (37.7850615586191, -122.470027031648) 11 6 2 54 11
51709 173899 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
68264 173898 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
58392 215480 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 55 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 8ft   5992620.87783 2096424.47164 37.7359583002413 -122.467981434219 (37.7359583002413, -122.467981434219) 1 8 4 59 40
16709 215479 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 85 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992627.2877 2096233.38868 37.7354340044744 -122.467945378584 (37.7354340044744, -122.467945378584) 1 8 4 59 40
24709 123166 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 579 10th Ave 1 Sidewalk: Property side : Yard Tree Private 2     6     5992807.48236 2111535.86844 37.7774610360275 -122.468435352622 (37.7774610360275, -122.468435352622) 11 6 2 54 11
187586 123153 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 506 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5992845.37698 2111963.44852 37.7786372439018 -122.468335378208 (37.7786372439018, -122.468335378208) 11 6 2 54 11
106204 100368 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 718 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 6x9   5992896.29545 2110550.04844 37.7747593697556 -122.468056394721 (37.7747593697556, -122.468056394721) 11 6 2 54 11
156222 94494 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 750 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14     5992906.29601 2110338.45907 37.7741789797645 -122.468006407076 (37.7741789797645, -122.468006407076) 11 6 2 54 11
161347 123129 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 758 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992907.03183 2110299.16217 37.7740711235286 -122.468001002791 (37.7740711235286, -122.468001002791) 11 6 2 54 11
151438 215474 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1421 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5993009.42995 2105791.52331 37.7617002561925 -122.467318962122 (37.7617002561925, -122.467318962122) 1 8 4 56 12
83460 108482 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 195x 09TH AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993013.6 2114237 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
89743 108480 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 195x 09TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993013.6 2114237 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
135352 108481 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 195x 09TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993013.6 2114237 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
3772 215475 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993086.32041 2105916.03813 37.7620465797188 -122.467062084267 (37.7620465797188, -122.467062084267) 1 8 4 56 12
43197 215476 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993096.43343 2105917.73669 37.7620518272484 -122.467027231034 (37.7620518272484, -122.467027231034) 1 8 4 56 12
23867 215521 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1750 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5993133.83624 2103556.81567 37.755571512239 -122.466726245046 (37.755571512239, -122.466726245046) 1 8 4 56 12
110943 215520 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1750 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993138.05131 2103539.75101 37.7555249003588 -122.466710427759 (37.7555249003588, -122.466710427759) 1 8 4 56 12
25389 215519 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1800 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993153.53472 2103109.22386 37.7543436777209 -122.466625589315 (37.7543436777209, -122.466625589315) 1 8 4 56 12
133326 54971 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 558 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1974 12:00:00 AM 14   Permit Number 14440 5993167.14361 2111676.47154 37.7778678620954 -122.467201401573 (37.7778678620954, -122.467201401573) 11 6 2 54 11
4061 46914 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44969 5993172.81345795 2105910.62938376 37.7620367208125 -122.466762547601 (37.7620367208125, -122.466762547601) 1 8 4 56 12
168239 46913 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44969 5993172.81345795 2105910.62938376 37.7620367208125 -122.466762547601 (37.7620367208125, -122.466762547601) 1 8 4 56 12
184925 46912 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44969 5993172.81345795 2105910.62938376 37.7620367208125 -122.466762547601 (37.7620367208125, -122.466762547601) 1 8 4 56 12
47344 215477 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1639 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5993371.53162 2104323.9029 37.7576914499066 -122.465959963285 (37.7576914499066, -122.465959963285) 1 8 4 56 12
140749 48645 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1639 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/30/2002 12:00:00 AM     Permit Number 45938 5993372.07519062 2104329.12614097 37.7577058229285 -122.465958462939 (37.7577058229285, -122.465958462939) 1 8 4 56 12
23318 112503 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 645 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   5993489.26776 2113460.89025 37.7827859823771 -122.46621678157 (37.7827859823771, -122.46621678157) 11 6 2 54 11
115870 97643 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 642 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5993491.08963 2113521.49369 37.7829524880612 -122.466214884321 (37.7829524880612, -122.466214884321) 11 6 2 54 11
163238 111056 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 623 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5993570.9875 2113459.71956 37.7827874825496 -122.46593398292 (37.7827874825496, -122.46593398292) 11 6 2 54 11
179496 55354 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 601 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/1972 12:00:00 AM 10 3x3 Permit Number 11287 5993641.36369 2113466.98214 37.782811483217 -122.465691040743 (37.782811483217, -122.465691040743) 11 6 2 54 11
107535 68693 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 600 Clement St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM 12 3x3 Permit Number 32603 5993650.82821 2113525.78591 37.7829734883164 -122.46566257132 (37.7829734883164, -122.46566257132) 11 6 2 54 11
92558 215569 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 262 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993829.85654 2096316.71457 37.735732168414 -122.463793725799 (37.735732168414, -122.463793725799) 9 8 4 59 40
105110 215568 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 262 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993854.87202 2096314.65378 37.7357279514923 -122.463707088708 (37.7357279514923, -122.463707088708) 9 8 4 59 40
101388 215515 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993879.1268 2096286.34679 37.7356516251168 -122.463621177382 (37.7356516251168, -122.463621177382) 9 8 4 59 40
21205 215567 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 254 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993893.11792 2096318.45791 37.735740600456 -122.463575134792 (37.735740600456, -122.463575134792) 9 8 4 59 40
159604 215514 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993902.74076 2096288.82132 37.7356597801802 -122.463539714991 (37.7356597801802, -122.463539714991) 9 8 4 59 40
152752 215513 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Santa Paula Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993924.28661 2096292.23015 37.7356703813878 -122.463465470563 (37.7356703813878, -122.463465470563) 9 8 4 59 40
182709 123995 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 57 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5993926.48607 2115175.33347 37.7875185929993 -122.464828746995 (37.7875185929993, -122.464828746995) 11 6 1 54 11
187931 123996 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 57 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5993927.17847 2115159.11926 37.7874741131307 -122.464825173506 (37.7874741131307, -122.464825173506) 11 6 1 54 11
32785 115468 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 83 06th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   5993932.33914 2114999.07157 37.7870349634341 -122.464795691681 (37.7870349634341, -122.464795691681) 11 6 1 54 11
30298 215566 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 250 Santa Paula Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993936.1007 2096327.5375 37.7357680072927 -122.463427186434 (37.7357680072927, -122.463427186434) 9 8 4 59 40
103735 215540 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 80 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993944.90834 2097392.63187 37.7386929991944 -122.46347400603 (37.7386929991944, -122.46347400603) 1 8 4 59 40
170664 215542 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993945.30252 2097292.64109 37.7384184721345 -122.463465388735 (37.7384184721345, -122.463465388735) 1 8 4 59 40
39873 215541 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993946.31928 2097307.15629 37.7384583858397 -122.463462926386 (37.7384583858397, -122.463462926386) 1 8 4 59 40
29434 215512 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Santa Paula Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993946.59661 2096298.31331 37.7356883696217 -122.463388778181 (37.7356883696217, -122.463388778181) 9 8 4 59 40
78452 215539 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 70 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993947.30597 2097439.02694 37.7388205266356 -122.463469082233 (37.7388205266356, -122.463469082233) 1 8 4 59 40
48815 215543 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993948.48206 2097274.4923 37.7383688232683 -122.46345307882 (37.7383688232683, -122.46345307882) 1 8 4 59 40
154022 215544 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 5 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993951.56494 2097251.7365 37.738306519129 -122.463440768884 (37.738306519129, -122.463440768884) 1 8 4 59 40
73294 215538 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 66 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   5993953.05441 2097475.42453 37.7389207965449 -122.463451847631 (37.7389207965449, -122.463451847631) 1 8 4 59 40
84691 215565 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 250 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993953.18487 2096333.32123 37.7357848722665 -122.463368539821 (37.7357848722665, -122.463368539821) 9 8 4 59 40
21448 215545 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5993953.28384 2097231.84575 37.7382520031164 -122.463433382759 (37.7382520031164, -122.463433382759) 1 8 4 59 40
88788 215537 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 66 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993955.64334 2097496.99749 37.7389801796769 -122.463444461504 (37.7389801796769, -122.463444461504) 1 8 4 59 40
170437 215536 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 56 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993957.82429 2097516.0973 37.7390327486488 -122.463438306534 (37.7390327486488, -122.463438306534) 1 8 4 59 40
188869 215535 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 56 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993961.10276 2097536.59197 37.739089210791 -122.463428458058 (37.739089210791, -122.463428458058) 1 8 4 59 40
147287 215534 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 50 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993970.3948 2097572.2061 37.7391875336652 -122.463398914422 (37.7391875336652, -122.463398914422) 1 8 4 59 40
47939 215564 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 250 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993972.9824 2096339.81611 37.7358038461725 -122.463300563692 (37.7358038461725, -122.463300563692) 9 8 4 59 40
71575 215533 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 42 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993973.16117 2097585.26638 37.7392235533179 -122.463390297139 (37.7392235533179, -122.463390297139) 1 8 4 59 40
6913 215496 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 69 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993975.72153 2097357.94979 37.7385995461283 -122.463364953343 (37.7385995461283, -122.463364953343) 1 8 4 59 40
43335 215497 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 73 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993976.24019 2097340.186 37.738550801067 -122.46336187137 (37.738550801067, -122.46336187137) 1 8 4 59 40
122804 215495 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 69 Santa Paula Ave 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993977.51854 2097401.11032 37.7387181577226 -122.463361871354 (37.7387181577226, -122.463361871354) 1 8 4 59 40
112923 215498 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95 Santa Paula Ave 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993979.5407 2097285.08347 37.7383996933922 -122.463346462392 (37.7383996933922, -122.463346462392) 1 8 4 59 40
46213 215494 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 61 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993979.60004 2097443.67302 37.7388351442124 -122.463357762357 (37.7388351442124, -122.463357762357) 1 8 4 59 40
50726 215532 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 42 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993980.35431 2097605.67891 37.7392800154546 -122.463366907564 (37.7392800154546, -122.463366907564) 1 8 4 59 40
192053 215563 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 244 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5993985.88408 2096348.37502 37.7358280900889 -122.463256578734 (37.7358280900889, -122.463256578734) 9 8 4 59 40
168331 215493 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 51 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993987.93159 2097500.89824 37.7389927504044 -122.463333107436 (37.7389927504044, -122.463333107436) 1 8 4 59 40
113352 215546 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5993989.26357 2097198.82691 37.7381634145006 -122.463306588246 (37.7381634145006, -122.463306588246) 1 8 4 59 40
91736 215531 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 40 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 3ft   5993990.15739 2097631.70954 37.7393520538516 -122.463334901582 (37.7393520538516, -122.463334901582) 1 8 4 59 40
172535 215499 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 95 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993991.18061 2097202.58443 37.7381738421581 -122.463300232714 (37.7381738421581, -122.463300232714) 1 8 4 59 40
166658 215492 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 51 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5993992.82093 2097521.50716 37.7390496190449 -122.463317697564 (37.7390496190449, -122.463317697564) 1 8 4 59 40
38863 215511 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Santa Paula Ave 5 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5993997.50574 2096315.53912 37.7357386003548 -122.463214016518 (37.7357386003548, -122.463214016518) 9 8 4 59 40
19733 215491 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 45 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 6ft   5993998.37881 2097545.6525 37.7391162363258 -122.463300232728 (37.7391162363258, -122.463300232728) 1 8 4 59 40
165653 215490 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 45 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5994002.63682 2097564.49911 37.7391682297257 -122.463286877796 (37.7391682297257, -122.463286877796) 1 8 4 59 40
193879 215489 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 37 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   5994010.31675 2097590.67092 37.7392405334333 -122.463262222872 (37.7392405334333, -122.463262222872) 1 8 4 59 40
121563 215547 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 200 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5994018.95115 2096748.46759 37.7369285500121 -122.46317127534 (37.7369285500121, -122.46317127534) 9 8 4 59 40
151442 215510 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 299 Santa Paula Ave 6 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994019.70982 2096325.72526 37.73576784809 -122.463137987822 (37.73576784809, -122.463137987822) 9 8 4 59 40
9179 215530 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 20 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994021.33126 2097709.05499 37.7395662211057 -122.463232727835 (37.7395662211057, -122.463232727835) 1 8 4 59 40
42812 215548 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 200 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5994023.18881 2096729.95205 37.7368779550533 -122.463155280903 (37.7368779550533, -122.463155280903) 9 8 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);