trees
2,365 rows where qSpecies_id = 31 sorted by Zip Codes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 9914 | 259754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4041 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x9 | 6003639.19109 | 2100382.47433 | 37.7474561955544 | -122.430169014304 | (37.7474561955544, -122.430169014304) | 2 | 4 | 5 | 63 | 22 | ||||
| 12480 | 47528 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
| 18889 | 242437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 155 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004941.65866 | 2098698.95529 | 37.7429073221216 | -122.425545367634 | (37.7429073221216, -122.425545367634) | 2 | 7 | 5 | 63 | 22 | |||
| 25820 | 25189 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3733 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6000311.6199976 | 2102932.6354717 | 37.7542692908961 | -122.441858505139 | (37.7542692908961, -122.441858505139) | 2 | 4 | 5 | 63 | 38 | |||
| 29698 | 242600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002217.82403 | 2096159.00983 | 37.7357789394319 | -122.434782025597 | (37.7357789394319, -122.434782025597) | 2 | 7 | 5 | 63 | 7 | |||
| 31801 | 242443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1331 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003922.38967 | 2100509.16496 | 37.7478200945407 | -122.429198764536 | (37.7478200945407, -122.429198764536) | 2 | 4 | 5 | 63 | 22 | |||
| 36983 | 25188 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3741 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000279.55164 | 2102883.22055 | 37.7541317821777 | -122.441965858665 | (37.7541317821777, -122.441965858665) | 2 | 4 | 5 | 63 | 38 | |||
| 37774 | 111106 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199X Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6002254 | 2096173 | 37.7358194070146 | -122.43465795136 | (37.7358194070146, -122.43465795136) | 2 | 7 | 5 | 63 | 7 | |||
| 38837 | 52664 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1328C. CHAVEZ Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50454 | 6003228.63897895 | 2100503.21297012 | 37.7477644538986 | -122.431597294154 | (37.7477644538986, -122.431597294154) | 2 | 4 | 5 | 63 | 22 | ||
| 39514 | 108244 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 Conrad St | 1 | Back Yard : Cutout | Tree | Private 2 | 20 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
| 41418 | 64129 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 662 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52075 | 6002246.83688253 | 2098888.05007266 | 37.7432738978208 | -122.434876821092 | (37.7432738978208, -122.434876821092) | 2 | 7 | 5 | 63 | 22 | ||
| 49721 | 30802 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 109 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 10 | 4x6 | Permit Number 34667 | 6001649.83524 | 2095450.83021 | 37.733802178321 | -122.43669510479 | (37.733802178321, -122.43669510479) | 9 | 7 | 5 | 63 | 40 |
| 52862 | 9361 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 252 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 2x2 | 6001048.03235 | 2098320.17238 | 37.7416465022772 | -122.43898127679 | (37.7416465022772, -122.43898127679) | 2 | 7 | 5 | 63 | 7 | |||
| 54596 | 242599 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 Surrey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002203.4241 | 2096143.28973 | 37.7357349581026 | -122.434830687885 | (37.7357349581026, -122.434830687885) | 2 | 7 | 5 | 63 | 7 | |||
| 54882 | 247019 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 530 Valley St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6002475.46095 | 2099175.15499 | 37.7440751988042 | -122.434106819098 | (37.7440751988042, -122.434106819098) | 2 | 7 | 5 | 63 | 22 | |||
| 85066 | 47527 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
| 92961 | 242597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 70 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001781.35899 | 2096768.45536 | 37.7374275460493 | -122.436334656543 | (37.7374275460493, -122.436334656543) | 2 | 7 | 5 | 63 | 7 | |||
| 96267 | 116355 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 148 28TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777724 | 6004916 | 2099631 | 37.7454650539376 | -122.425700412207 | (37.7454650539376, -122.425700412207) | 2 | 7 | 5 | 63 | 22 | |
| 97747 | 246419 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 Duncan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003875.90135 | 2099856.3033 | 37.7460248561553 | -122.429312971222 | (37.7460248561553, -122.429312971222) | 2 | 7 | 5 | 63 | 22 | |||
| 101321 | 25190 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3715 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000334.29791 | 2102971.06917 | 37.7543761126861 | -122.441782837633 | (37.7543761126861, -122.441782837633) | 2 | 4 | 5 | 63 | 38 | |||
| 112236 | 242598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002194.2893 | 2096133.69005 | 37.735708080954 | -122.434861584105 | (37.735708080954, -122.434861584105) | 2 | 7 | 5 | 63 | 7 | |||
| 115297 | 242442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1331 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6003921.27501 | 2100487.34298 | 37.7477601133553 | -122.429201063205 | (37.7477601133553, -122.429201063205) | 2 | 4 | 5 | 63 | 22 | |||
| 116748 | 45798 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Clipper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44433 | 5999675.79411068 | 2100284.35240189 | 37.7469614974882 | -122.443867085897 | (37.7469614974882, -122.443867085897) | 2 | 4 | 5 | 63 | 22 | |||
| 119820 | 4476 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1524 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/16/2003 12:00:00 AM | 6 | 3X3 | 6004536.76102 | 2099988.71011 | 37.7464258062985 | -122.427037234079 | (37.7464258062985, -122.427037234079) | 2 | 7 | 5 | 63 | 22 | ||
| 133424 | 254076 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 416 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2017 12:00:00 AM | 3 | 3x3 | 6003139 | 2099532 | 37.7450926486102 | -122.431837924964 | (37.7450926486102, -122.431837924964) | 2 | 7 | 5 | 63 | 22 | ||
| 140017 | 242441 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1331 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003923.41449 | 2100462.14454 | 37.7476910454126 | -122.429191868514 | (37.7476910454126, -122.429191868514) | 2 | 4 | 5 | 63 | 22 | |||
| 140296 | 43563 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 511 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | 2 | 7 | 5 | 63 | 22 | ||
| 151881 | 47711 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.7369794845402 | -122.435360375218 | (37.7369794845402, -122.435360375218) | 2 | 7 | 5 | 63 | 7 | ||
| 153215 | 242436 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 511 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003224.69175 | 2098893.05033 | 37.7433430984977 | -122.431496012531 | (37.7433430984977, -122.431496012531) | 2 | 7 | 5 | 63 | 22 | |||
| 158352 | 4231 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3992 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2003 12:00:00 AM | 3 | 3X3 | 6003972.48487 | 2100441.01893 | 37.7476358171535 | -122.429020679863 | (37.7476358171535, -122.429020679863) | 2 | 4 | 5 | 63 | 22 | ||
| 165393 | 242440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 146 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004908.86847 | 2099616.53087 | 37.7454249220351 | -122.425724042258 | (37.7454249220351, -122.425724042258) | 2 | 7 | 5 | 63 | 22 | |||
| 166938 | 215571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 32 Malta Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5999675.11481 | 2095972.75757 | 37.7351228462426 | -122.443559761297 | (37.7351228462426, -122.443559761297) | 9 | 7 | 4 | 63 | 40 | |||
| 174881 | 242439 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 229 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004390.15569 | 2099542.0601 | 37.7451911171707 | -122.427512363901 | (37.7451911171707, -122.427512363901) | 2 | 7 | 5 | 63 | 22 | |||
| 179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
| 182891 | 242438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 155 Day St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004951.72488 | 2098699.71043 | 37.7429099643322 | -122.425510615143 | (37.7429099643322, -122.425510615143) | 2 | 7 | 5 | 63 | 22 | |||
| 193971 | 242595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1328 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003227.3356 | 2100480.54153 | 37.7477021295503 | -122.431600182828 | (37.7477021295503, -122.431600182828) | 2 | 4 | 5 | 63 | 22 | |||
| 6477 | 215562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 244 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994036.57489 | 2096375.72 | 37.735906092783 | -122.463083305449 | (37.735906092783, -122.463083305449) | 9 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 21307 | 215486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.7395492454888 | -122.463120453749 | (37.7395492454888, -122.463120453749) | 1 | 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 | |||
| 22837 | 215572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 745 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5999421.36042 | 2095348.4772 | 37.7333942440298 | -122.44439222862 | (37.7333942440298, -122.44439222862) | 9 | 7 | 4 | 59 | 40 | |||
| 24238 | 215561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994051.56415 | 2096391.91316 | 37.7359514186289 | -122.463032656549 | (37.7359514186289, -122.463032656549) | 9 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 40087 | 215483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.462953960472 | (37.7397934743851, -122.462953960472) | 1 | 8 | 4 | 59 | 40 | |||
| 40289 | 215500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 223 Santa Paula Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994062.94348 | 2096703.04121 | 37.736806354618 | -122.463015880573 | (37.736806354618, -122.463015880573) | 9 | 8 | 4 | 59 | 40 | |||
| 40473 | 215488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 33 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994033.38086 | 2097656.16741 | 37.7394216991581 | -122.463187229312 | (37.7394216991581, -122.463187229312) | 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 | |||
| 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 | |||
| 44710 | 215501 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 225 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994092.6368 | 2096583.02497 | 37.7364785301452 | -122.462904513945 | (37.7364785301452, -122.462904513945) | 9 | 8 | 4 | 59 | 40 | |||
| 45197 | 215559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994067.05947 | 2096413.85404 | 37.7360125554181 | -122.462980674831 | (37.7360125554181, -122.462980674831) | 9 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 57450 | 215485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 21 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994064.51337 | 2097723.86139 | 37.7396093633696 | -122.463084497953 | (37.7396093633696, -122.463084497953) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 59271 | 215556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5994083.61734 | 2096486.44711 | 37.7362128317539 | -122.462928693117 | (37.7362128317539, -122.462928693117) | 9 | 8 | 4 | 59 | 40 | |||
| 59298 | 215558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994076.83101 | 2096438.60242 | 37.7360810711916 | -122.462948685927 | (37.7360810711916, -122.462948685927) | 9 | 8 | 4 | 59 | 40 | |||
| 63563 | 215484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.7396792290015 | -122.46304340523 | (37.7396792290015, -122.46304340523) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 68728 | 215503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 233 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994106.38436 | 2096527.49502 | 37.7363268505023 | -122.462852955799 | (37.7363268505023, -122.462852955799) | 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 | |||
| 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 | |||
| 73412 | 215570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 96 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995600.39767 | 2096198.59734 | 37.7355097165874 | -122.457663772269 | (37.7355097165874, -122.457663772269) | 9 | 7 | 4 | 59 | 40 | |||
| 75740 | 215550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994032.03336 | 2096692.14483 | 37.7367746553097 | -122.463121959218 | (37.7367746553097, -122.463121959218) | 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 | |||
| 81332 | 52332 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.459292150941 | (37.7353714395789, -122.459292150941) | 9 | 7 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 117216 | 215529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 14 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994038.78637 | 2097743.43372 | 37.7396616220783 | -122.46317486995 | (37.7396616220783, -122.46317486995) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 121544 | 215482 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994118.54253 | 2097814.90929 | 37.7398624703831 | -122.462904293614 | (37.7398624703831, -122.462904293614) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );