trees
427 rows where SiteOrder = 2 and qSpecies_id = 31 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9121 | 46285 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 18433 | 260397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 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 | |||
| 47670 | 1208 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3141 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 5995992.87885 | 2086942.40616 | 37.7101169521706 | -122.455637985173 | (37.7101169521706, -122.455637985173) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 22856 | 180559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 192 Dublin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004156.47541 | 2089333.3612 | 37.7171470982496 | -122.427593206665 | (37.7171470982496, -122.427593206665) | 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 | ||
| 17580 | 17622 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1100 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6004279.3637264 | 2089959.3319014 | 37.7188728276872 | -122.427213003456 | (37.7188728276872, -122.427213003456) | 9 | 7 | 6 | 28861 | 5 | |||
| 71134 | 17624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | 9 | 7 | 6 | 28861 | 5 | |||
| 61315 | 180513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004235.63883 | 2090036.93621 | 37.7190834393332 | -122.427369668478 | (37.7190834393332, -122.427369668478) | 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 | |||
| 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 | |||
| 174867 | 180516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004155.91588 | 2090090.60538 | 37.7192262939354 | -122.427649061763 | (37.7192262939354, -122.427649061763) | 9 | 7 | 6 | 28861 | 5 | |||
| 179430 | 17612 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
| 42118 | 180519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 919 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003897.75198 | 2090254.30542 | 37.7196611719008 | -122.428553098957 | (37.7196611719008, -122.428553098957) | 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 | |||
| 164087 | 17578 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003799.63122 | 2090323.67437 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | 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 | |||
| 18698 | 180522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6003548.0155 | 2090475.44462 | 37.7202485730803 | -122.429777776817 | (37.7202485730803, -122.429777776817) | 9 | 7 | 6 | 28861 | 5 | |||
| 192009 | 17568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6003419.61693 | 2090505.67023 | 37.720324294201 | -122.430223763218 | (37.720324294201, -122.430223763218) | 9 | 7 | 6 | 28861 | 5 | |||
| 81510 | 17570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 2 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 60340 | 17536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003012.06568 | 2090814.03767 | 37.7211479104352 | -122.431654537837 | (37.7211479104352, -122.431654537837) | 9 | 7 | 6 | 28861 | 5 | |||
| 9012 | 180529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
| 173625 | 17533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 2 | 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 | |||
| 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 | |||
| 173056 | 122420 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2200 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998886 | 2091075 | 37.7216297132481 | -122.445935857536 | (37.7216297132481, -122.445935857536) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 | |||
| 190369 | 17527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 349X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6002621.9363 | 2091050.61782 | 37.7217753855301 | -122.433019994862 | (37.7217753855301, -122.433019994862) | 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 | |||
| 180325 | 17514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002400.99383 | 2091189.19971 | 37.7221433654964 | -122.433793634664 | (37.7221433654964, -122.433793634664) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 180485 | 17484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 2 | 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 | |||
| 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 | |||
| 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 | |||
| 59946 | 17494 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 98X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6001936.09269 | 2091434.74089 | 37.7227911744411 | -122.435418238322 | (37.7227911744411, -122.435418238322) | 9 | 7 | 6 | 28861 | 5 | |||
| 45851 | 180552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001906.70426 | 2091457.08941 | 37.7228508693472 | -122.435521425698 | (37.7228508693472, -122.435521425698) | 9 | 7 | 6 | 28861 | 5 | |||
| 163774 | 198514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1601 Bay Shore Blvd | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6012038.03347 | 2091375.16372 | 37.7231961325824 | -122.400493582929 | (37.7231961325824, -122.400493582929) | 10 | 3 | 8 | 58 | 1 | |||
| 185430 | 113083 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009864 | 2093047 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | 10 | 3 | 7 | 309 | 28 | ||||
| 14105 | 180573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 515 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009834.24274 | 2093058.41578 | 37.7276948418209 | -122.408230355163 | (37.7276948418209, -122.408230355163) | 10 | 3 | 7 | 309 | 28 | |||
| 101626 | 201907 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013751.60826 | 2093257.56774 | 37.7284602485269 | -122.394701804167 | (37.7284602485269, -122.394701804167) | 10 | 3 | 8 | 58 | 1 | |||
| 103111 | 46632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.7285785323655 | -122.389527911332 | (37.7285785323655, -122.389527911332) | 10 | 3 | 8 | 58 | 1 |
| 142895 | 107048 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1478 UNDERWOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015262.9 | 2093276.2 | 37.7285953185109 | -122.389478448264 | (37.7285953185109, -122.389478448264) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 25726 | 215523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80 Northwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995460.48677 | 2094242.81923 | 37.7301315873058 | -122.458006001202 | (37.7301315873058, -122.458006001202) | 9 | 7 | 4 | 28861 | 40 | |||
| 145272 | 22327 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5155 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6014617.6908 | 2094280.6281 | 37.7313174804906 | -122.391779193474 | (37.7313174804906, -122.391779193474) | 10 | 3 | 8 | 58 | 1 | |||
| 23894 | 200745 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6014683.7532 | 2094550.1103 | 37.7320610911002 | -122.391569635286 | (37.7320610911002, -122.391569635286) | 10 | 3 | 8 | 58 | 1 | |||
| 36858 | 22315 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
| 8701 | 200755 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014751.1238 | 2094745.6812 | 37.7326018284177 | -122.391350385093 | (37.7326018284177, -122.391350385093) | 10 | 3 | 8 | 58 | 1 | |||
| 170708 | 200597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.7329696218978 | -122.385261171263 | (37.7329696218978, -122.385261171263) | 10 | 3 | 8 | 58 | 1 | |||
| 146461 | 16439 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
| 61858 | 200580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1330 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016475.5774 | 2094870.1567 | 37.7330391696694 | -122.385397144532 | (37.7330391696694, -122.385397144532) | 10 | 3 | 8 | 58 | 1 | |||
| 54742 | 200631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1354 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016389.5518 | 2094874.5522 | 37.7330464790647 | -122.385694866729 | (37.7330464790647, -122.385694866729) | 10 | 3 | 8 | 58 | 1 | |||
| 172739 | 200628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1362 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016361.9231 | 2094886.4828 | 37.7330777092621 | -122.385791218603 | (37.7330777092621, -122.385791218603) | 10 | 3 | 8 | 58 | 1 | |||
| 92198 | 254243 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
| 23232 | 32533 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37034 | 6006985.4956632 | 2095516.38069521 | 37.7342839493681 | -122.418252734879 | (37.7342839493681, -122.418252734879) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 178456 | 215554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 224 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994072.66196 | 2096533.89593 | 37.7363424834197 | -122.462970011551 | (37.7363424834197, -122.462970011551) | 9 | 8 | 4 | 59 | 40 | |||
| 116534 | 198560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014655.2828 | 2096153.01044 | 37.7364607478562 | -122.391780101069 | (37.7364607478562, -122.391780101069) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 172901 | 198526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014646.0524 | 2096160.05646 | 37.736479582376 | -122.391812507248 | (37.736479582376, -122.391812507248) | 10 | 3 | 8 | 58 | 1 | |||
| 160465 | 198522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1725 Newcomb Ave | 2 | : | Tree | Private 2 | 3 | Width 7ft | 6014552.77288 | 2096169.89847 | 37.7365014278009 | -122.392135704718 | (37.7365014278009, -122.392135704718) | 10 | 3 | 8 | 58 | 1 | |||
| 41660 | 198529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 Newcomb Ave | 2 | : | Tree | Private 2 | 7 | Width 7ft | 6014569.28946 | 2096208.90311 | 37.73660944358 | -122.392081326305 | (37.73660944358, -122.392081326305) | 10 | 3 | 8 | 58 | 1 | |||
| 162884 | 198521 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1737 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6014485.10287 | 2096211.09486 | 37.7366107871579 | -122.392372551071 | (37.7366107871579, -122.392372551071) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 168414 | 198544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 2 | : | Tree | Private 2 | 4 | Width 0ft | 6014356.36657 | 2096313.21091 | 37.7368840272751 | -122.392824793156 | (37.7368840272751, -122.392824793156) | 10 | 3 | 8 | 58 | 1 | |||
| 4812 | 198517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 2 | : | Tree | Private 2 | 5 | Width 7ft | 6014346.73951 | 2096322.78373 | 37.7369097775472 | -122.392858747949 | (37.7369097775472, -122.392858747949) | 10 | 3 | 8 | 58 | 1 | |||
| 153183 | 198533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014374.32844 | 2096361.30259 | 37.7370170747819 | -122.392766053934 | (37.7370170747819, -122.392766053934) | 10 | 3 | 8 | 58 | 1 | |||
| 7172 | 242618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007915.14616 | 2096519.82077 | 37.7370914621948 | -122.415109628301 | (37.7370914621948, -122.415109628301) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 175856 | 215481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.7399367588722 | -122.462836916405 | (37.7399367588722, -122.462836916405) | 1 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 81203 | 4566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 106X Virginia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2016 12:00:00 AM | 12 | 3X3 | 6006479.71302 | 2098542.22808 | 37.7425637694016 | -122.420216071529 | (37.7425637694016, -122.420216071529) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | |||
| 116947 | 7661 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008464.3828 | 2099163.30287 | 37.7443807335859 | -122.413397555653 | (37.7443807335859, -122.413397555653) | 2 | 7 | 7 | 28859 | 2 |
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) );