trees
2,365 rows where qSpecies_id = 31 sorted by Fire Prevention Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87922 | 180542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 990 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004004.09033 | 2090139.32192 | 37.7193514696869 | -122.42817733523 | (37.7193514696869, -122.42817733523) | 9 | 7 | 6 | 28861 | 5 | |||
88059 | 17545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 543 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6003118.20236 | 2090743.39426 | 37.7209599548222 | -122.431282614218 | (37.7209599548222, -122.431282614218) | 9 | 7 | 6 | 28861 | 5 | |||
88227 | 17627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/27/2005 12:00:00 AM | 3 | 3X3 | 6004380.7126814 | 2089954.6929998 | 37.718865821274 | -122.426862349848 | (37.718865821274, -122.426862349848) | 9 | 7 | 6 | 28861 | 5 | ||
88381 | 180555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002345.73736 | 2091226.34505 | 37.7222422225842 | -122.433987296498 | (37.7222422225842, -122.433987296498) | 9 | 7 | 6 | 28861 | 5 | |||
89450 | 215555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994079.01038 | 2096505.73845 | 37.7362655356317 | -122.462946020337 | (37.7362655356317, -122.462946020337) | 9 | 8 | 4 | 59 | 40 | |||
90891 | 17497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.434919765734 | (37.7226823390961, -122.434919765734) | 9 | 7 | 6 | 28861 | 5 | |||
91303 | 215573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 151 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999107.62839 | 2095480.41733 | 37.7337386151486 | -122.445486368125 | (37.7337386151486, -122.445486368125) | 9 | 7 | 4 | 59 | 40 | |||
91679 | 17550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6003170.84982 | 2090661.1447 | 37.7207370992233 | -122.431094760237 | (37.7207370992233, -122.431094760237) | 9 | 7 | 6 | 28861 | 5 | |||
91687 | 17522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 307 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6002546.66743 | 2091098.28956 | 37.7219020117492 | -122.433283584179 | (37.7219020117492, -122.433283584179) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
92927 | 17581 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003766.78664 | 2090331.92818 | 37.7198668945342 | -122.429011330508 | (37.7198668945342, -122.429011330508) | 9 | 7 | 6 | 28861 | 5 | |||
93532 | 17520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/1998 12:00:00 AM | 18 | 3x3 | 6002494.30852 | 2091085.91322 | 37.7218650586013 | -122.433463691421 | (37.7218650586013, -122.433463691421) | 9 | 7 | 6 | 28861 | 5 | ||
93680 | 17549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6003191.59323 | 2090648.1169 | 37.7207025031963 | -122.431022127369 | (37.7207025031963, -122.431022127369) | 9 | 7 | 6 | 28861 | 5 | |||
94852 | 13322 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002777.3722738 | 2090962.3160144 | 37.7215417439498 | -122.432476389775 | (37.7215417439498, -122.432476389775) | 9 | 7 | 6 | 28861 | 5 | |||
95546 | 180564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003993.12546 | 2092482.75388 | 37.7257853967595 | -122.428382173808 | (37.7257853967595, -122.428382173808) | 9 | 7 | 6 | 28861 | 5 | |||
96419 | 81863 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.7293018063197 | -122.459920577502 | (37.7293018063197, -122.459920577502) | 9 | 7 | 4 | 28861 | 40 | ||
96880 | 180553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002310.38587 | 2091249.45614 | 37.7223036741654 | -122.434111149317 | (37.7223036741654, -122.434111149317) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
97426 | 17495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002027.05349 | 2091378.72089 | 37.722642521628 | -122.43509980193 | (37.722642521628, -122.43509980193) | 9 | 7 | 6 | 28861 | 5 | |||
98386 | 46780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.433571759353 | (37.7283552769641, -122.433571759353) | 9 | 7 | 6 | 28861 | 25 | |
99531 | 215507 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 255 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994095.64493 | 2096399.41615 | 37.7359745590736 | -122.462880797029 | (37.7359745590736, -122.462880797029) | 9 | 8 | 4 | 59 | 40 | |||
99578 | 180557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 391 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002620.62071 | 2091051.67634 | 37.7217782173661 | -122.433024618098 | (37.7217782173661, -122.433024618098) | 9 | 7 | 6 | 28861 | 5 | |||
100860 | 180521 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2016 07:58:00 AM | 1 | Width 3ft | 6003571.91283 | 2090460.55428 | 37.7202090407058 | -122.429694110218 | (37.7202090407058, -122.429694110218) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
101647 | 17621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1100 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6004336.28169 | 2089926.31484 | 37.7187853887157 | -122.427013910159 | (37.7187853887157, -122.427013910159) | 9 | 7 | 6 | 28861 | 5 | |||
102357 | 180567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 79 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003968.93484 | 2094040.31559 | 37.7300607449837 | -122.428576774521 | (37.7300607449837, -122.428576774521) | 9 | 7 | 6 | 28861 | 5 | |||
103729 | 17547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 548X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003010.1465759 | 2090756.9744765 | 37.7209911187853 | -122.431657099656 | (37.7209911187853, -122.431657099656) | 9 | 7 | 6 | 28861 | 5 | |||
103898 | 17519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6002513.47081 | 2091072.78557 | 37.7218301001725 | -122.433396514735 | (37.7218301001725, -122.433396514735) | 9 | 7 | 6 | 28861 | 5 | |||
103950 | 17572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003493.5133628 | 2090512.2555079 | 37.7203465611878 | -122.429968797048 | (37.7203465611878, -122.429968797048) | 9 | 7 | 6 | 28861 | 5 | |||
104490 | 17518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002537.72422 | 2091058.53445 | 37.7217923457343 | -122.433311659211 | (37.7217923457343, -122.433311659211) | 9 | 7 | 6 | 28861 | 5 | |||
104879 | 180558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 391 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6002652.45848 | 2091031.88145 | 37.7217256708875 | -122.432913149844 | (37.7217256708875, -122.432913149844) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | |||
109904 | 40800 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 167 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41749 | 5995317.58858632 | 2087395.72139247 | 37.7113228744096 | -122.458004690935 | (37.7113228744096, -122.458004690935) | 9 | 8 | 6 | 28861 | 24 | |||
114947 | 17521 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002512.93657 | 2091121.04264 | 37.7219625730029 | -122.433401808174 | (37.7219625730029, -122.433401808174) | 9 | 7 | 6 | 28861 | 5 | |||
115411 | 13321 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/1997 12:00:00 AM | 5 | 3X3 | 6002797.38385 | 2090943.99635 | 37.7214925769985 | -122.432405907456 | (37.7214925769985, -122.432405907456) | 9 | 7 | 6 | 28861 | 5 | ||
115721 | 17526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 349X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002579.5148665 | 2091086.6599396 | 37.7218719428007 | -122.433169208527 | (37.7218719428007, -122.433169208527) | 9 | 7 | 6 | 28861 | 5 | |||
116215 | 180527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 543 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6003103.45709 | 2090752.99911 | 37.720985491961 | -122.431334269463 | (37.720985491961, -122.431334269463) | 9 | 7 | 6 | 28861 | 5 | |||
116487 | 56779 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 118 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1974 12:00:00 AM | 10 | 3x3 | Permit Number 14000 | 6004445.70809 | 2092827.36067 | 37.7267572104766 | -122.426842159439 | (37.7267572104766, -122.426842159439) | 9 | 7 | 6 | 28861 | 5 | |
117168 | 17594 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 808 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6003660.5889 | 2090352.70298 | 37.719917925661 | -122.42937989966 | (37.719917925661, -122.42937989966) | 9 | 7 | 6 | 28861 | 5 | |||
117220 | 17542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/29/2011 12:00:00 AM | 3 | 3x3 | 6003053.24569 | 2090786.85001 | 37.7210755932558 | -122.431510250621 | (37.7210755932558, -122.431510250621) | 9 | 7 | 6 | 28861 | 5 | ||
117431 | 180547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002320.38624 | 2091195.17926 | 37.7221552095645 | -122.434072702398 | (37.7221552095645, -122.434072702398) | 9 | 7 | 6 | 28861 | 5 | |||
117636 | 51892 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48104 | 6004381.23162594 | 2089955.54800101 | 37.7188681982632 | -122.42686061692 | (37.7188681982632, -122.42686061692) | 9 | 7 | 6 | 28861 | 5 | |||
117696 | 215508 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 261 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994073.52001 | 2096368.39822 | 37.7358881171279 | -122.462955041436 | (37.7358881171279, -122.462955041436) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
119390 | 17564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4.5x8 | 6003386.5742173 | 2090579.4616613 | 37.7205250375642 | -122.430343243034 | (37.7205250375642, -122.430343243034) | 9 | 7 | 6 | 28861 | 5 | |||
119925 | 17600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003845.6513541 | 2090290.953545 | 37.7197588510105 | -122.428735803294 | (37.7197588510105, -122.428735803294) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
122274 | 215553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 224 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994066.55371 | 2096555.13843 | 37.736400458215 | -122.462992670901 | (37.736400458215, -122.462992670901) | 9 | 8 | 4 | 59 | 40 | |||
122734 | 17534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002799.2909021 | 2090948.5412155 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | 9 | 7 | 6 | 28861 | 5 | |||
123382 | 17591 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003659.63671 | 2090407.22668 | 37.7200675818369 | -122.429387077163 | (37.7200675818369, -122.429387077163) | 9 | 7 | 6 | 28861 | 5 | |||
123821 | 17535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003034.53059 | 2090798.32089 | 37.7211060289883 | -122.431575761713 | (37.7211060289883, -122.431575761713) | 9 | 7 | 6 | 28861 | 5 | |||
125359 | 17583 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6003749.15172 | 2090342.65671 | 37.7198953544779 | -122.429073052804 | (37.7198953544779, -122.429073052804) | 9 | 7 | 6 | 28861 | 5 | |||
126038 | 180544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 790 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6003493.29821 | 2090458.51189 | 37.7201989808773 | -122.429965709077 | (37.7201989808773, -122.429965709077) | 9 | 7 | 6 | 28861 | 5 | |||
126316 | 17496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2003 12:00:00 AM | 3 | 2X2 | 6002048.59392 | 2091411.20621 | 37.7227329421421 | -122.435027663714 | (37.7227329421421, -122.435027663714) | 9 | 7 | 6 | 28861 | 5 | ||
126507 | 180540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2134 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5998917.8755 | 2091146.49396 | 37.7218278392563 | -122.445830812055 | (37.7218278392563, -122.445830812055) | 9 | 7 | 6 | 28861 | 25 | |||
126898 | 215552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994058.81672 | 2096590.61886 | 37.7364974330117 | -122.463021994195 | (37.7364974330117, -122.463021994195) | 9 | 8 | 4 | 59 | 40 | |||
127492 | 17584 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.429104673852 | (37.7199371612464, -122.429104673852) | 9 | 7 | 6 | 28861 | 5 | |||
129288 | 180561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1134 Naples St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 8ft | 6001348.51244 | 2087850.78247 | 37.7129170389625 | -122.437192888562 | (37.7129170389625, -122.437192888562) | 9 | 7 | 6 | 28861 | 5 | |||
130037 | 17554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 620 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6003227.93089 | 2090625.05216 | 37.7206412314956 | -122.430894874199 | (37.7206412314956, -122.430894874199) | 9 | 7 | 6 | 28861 | 5 | |||
131024 | 180543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 790 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1997 12:00:00 AM | 15 | Width 3ft | 6003544.62604 | 2090426.48739 | 37.7201139553758 | -122.429786002948 | (37.7201139553758, -122.429786002948) | 9 | 7 | 6 | 28861 | 5 | ||
131848 | 17492 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 43 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3X3 | 6001974.03166 | 2091459.77916 | 37.7228620784977 | -122.435288881679 | (37.7228620784977, -122.435288881679) | 9 | 7 | 6 | 28861 | 5 | |||
132025 | 180524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6003506.14684 | 2090499.61443 | 37.7203125670408 | -122.429924226024 | (37.7203125670408, -122.429924226024) | 9 | 7 | 6 | 28861 | 5 | |||
133641 | 17557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6003296.79143 | 2090629.3686 | 37.7206569849073 | -122.430657152829 | (37.7206569849073, -122.430657152829) | 9 | 7 | 6 | 28861 | 5 | |||
137339 | 17609 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004106.27078 | 2090068.65464 | 37.7191632136975 | -122.42781910287 | (37.7191632136975, -122.42781910287) | 9 | 7 | 6 | 28861 | 5 | |||
137860 | 215557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994081.97838 | 2096463.44747 | 37.7361495860356 | -122.462932691498 | (37.7361495860356, -122.462932691498) | 9 | 8 | 4 | 59 | 40 | |||
139802 | 180554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002324.53042 | 2091240.40597 | 37.722279627184 | -122.434061608377 | (37.722279627184, -122.434061608377) | 9 | 7 | 6 | 28861 | 5 | |||
140908 | 180569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007329.33398 | 2093756.28906 | 37.729470469574 | -122.416939308919 | (37.729470469574, -122.416939308919) | 9 | 3 | 7 | 309 | 28 | |||
141268 | 17596 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 822 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6003747.62953 | 2090297.4937 | 37.71977126061 | -122.429075096066 | (37.71977126061, -122.429075096066) | 9 | 7 | 6 | 28861 | 5 | |||
141476 | 17588 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003687.80932 | 2090380.02196 | 37.7199944786431 | -122.429287755146 | (37.7199944786431, -122.429287755146) | 9 | 7 | 6 | 28861 | 5 | |||
141496 | 180533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 401 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002751.65611 | 2090978.09371 | 37.7215836076762 | -122.432566409917 | (37.7215836076762, -122.432566409917) | 9 | 7 | 6 | 28861 | 5 | |||
143107 | 180568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 136 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007069.51192 | 2093001.96725 | 37.7273846467688 | -122.417784094277 | (37.7273846467688, -122.417784094277) | 9 | 3 | 7 | 309 | 5 | |||
144740 | 17625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1132 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6004425.09493 | 2089870.49616 | 37.7186371444562 | -122.426702945308 | (37.7186371444562, -122.426702945308) | 9 | 7 | 6 | 28861 | 5 | |||
144805 | 17610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004083.79011 | 2090083.69021 | 37.7192032263241 | -122.427897880781 | (37.7192032263241, -122.427897880781) | 9 | 7 | 6 | 28861 | 5 | |||
145910 | 17499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002048.76612 | 2091365.28566 | 37.7226068644033 | -122.435023785838 | (37.7226068644033, -122.435023785838) | 9 | 7 | 6 | 28861 | 5 | ||
148137 | 17616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1030 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004194.38835 | 2090014.04434 | 37.719018250172 | -122.427510625535 | (37.719018250172, -122.427510625535) | 9 | 7 | 6 | 28861 | 5 | |||
148912 | 17511 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 226 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/1999 12:00:00 AM | 12 | 3X3 | 6002275.9984778 | 2091218.3515509 | 37.7222163162231 | -122.434227795703 | (37.7222163162231, -122.434227795703) | 9 | 7 | 6 | 28861 | 5 | ||
149754 | 180570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007772.76642 | 2093897.53246 | 37.7298832269189 | -122.415416310622 | (37.7298832269189, -122.415416310622) | 9 | 3 | 7 | 309 | 28 | |||
151128 | 180548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002299.71139 | 2091209.35662 | 37.7221929640283 | -122.434145183247 | (37.7221929640283, -122.434145183247) | 9 | 7 | 6 | 28861 | 5 | |||
151388 | 180556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002572.40601 | 2091082.8372 | 37.7218610431436 | -122.433193508995 | (37.7218610431436, -122.433193508995) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
152147 | 17565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 4.5x4.5 | 6003438.97081 | 2090543.76547 | 37.7204299915223 | -122.430159579516 | (37.7204299915223, -122.430159579516) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
152862 | 180514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 4ft | 6004210.58168 | 2090053.82189 | 37.7191283865346 | -122.427457483699 | (37.7191283865346, -122.427457483699) | 9 | 7 | 6 | 28861 | 5 | |||
152997 | 215517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 164 Howth St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997515.64352 | 2090995.97654 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | 9 | 8 | 6 | 28861 | 24 | |||
153301 | 17587 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 11 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003703.48138 | 2090378.19842 | 37.7199903588363 | -122.429233452259 | (37.7199903588363, -122.429233452259) | 9 | 7 | 6 | 28861 | 5 | |||
153988 | 17544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 537 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6003083.60804 | 2090766.94886 | 37.7210226699524 | -122.431403876997 | (37.7210226699524, -122.431403876997) | 9 | 7 | 6 | 28861 | 5 | |||
154623 | 17608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/26/1999 12:00:00 AM | 40 | 6x9 | 6004130.9636 | 2090056.2016 | 37.7191304172171 | -122.427732862395 | (37.7191304172171, -122.427732862395) | 9 | 7 | 6 | 28861 | 5 | ||
154845 | 17483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
155254 | 215551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 212 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994048.13405 | 2096632.68749 | 37.7366123276804 | -122.463061979834 | (37.7366123276804, -122.463061979834) | 9 | 8 | 4 | 59 | 40 | |||
157561 | 17579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003783.82433 | 2090321.42028 | 37.7198390065544 | -122.428951688396 | (37.7198390065544, -122.428951688396) | 9 | 7 | 6 | 28861 | 5 | |||
157575 | 17619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
159643 | 215504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 235 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5994113.80383 | 2096483.08652 | 37.7362053431037 | -122.462824083076 | (37.7362053431037, -122.462824083076) | 9 | 8 | 4 | 59 | 40 | |||
159756 | 180546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 228 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002372.12567 | 2091162.28093 | 37.7220678143702 | -122.433891501616 | (37.7220678143702, -122.433891501616) | 9 | 7 | 6 | 28861 | 5 | |||
160147 | 180541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 762 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002189.48033 | 2089236.03979 | 37.7167684188988 | -122.434385210533 | (37.7167684188988, -122.434385210533) | 9 | 7 | 6 | 28861 | 5 | |||
160933 | 180523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003530.18037 | 2090485.12312 | 37.720274138132 | -122.429840116925 | (37.720274138132, -122.429840116925) | 9 | 7 | 6 | 28861 | 5 | |||
161490 | 180526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6003462.66428 | 2090526.46403 | 37.7203838275255 | -122.430076445277 | (37.7203838275255, -122.430076445277) | 9 | 7 | 6 | 28861 | 5 | |||
162379 | 215509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 265 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994040.68753 | 2096338.79291 | 37.7358049370452 | -122.463066408082 | (37.7358049370452, -122.463066408082) | 9 | 8 | 4 | 59 | 40 | |||
163125 | 215506 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 255 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994105.35353 | 2096421.48762 | 37.7360357210632 | -122.462848831512 | (37.7360357210632, -122.462848831512) | 9 | 8 | 4 | 59 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );