trees
2,365 rows where 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2605 | 19985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | |||||||||||||
| 4213 | 251107 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 6695 | 260396 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 7980 | 260398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
| 8784 | 46303 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 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 | ||||||||||||||
| 9906 | 46304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 10022 | 46302 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 12068 | 26637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X3 | ||||||||||||
| 14244 | 46291 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
| 18373 | 259350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 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 | |||||||||||||
| 190727 | 180562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4101 Alemany Blvd | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5991620.89043 | 2086817.03581 | 37.7095208535614 | -122.470739173794 | (37.7095208535614, -122.470739173794) | 9 | 8 | 4 | 64 | 24 | |||
| 61112 | 1325 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4051X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5991764.76245 | 2086963.37686 | 37.7099309898835 | -122.470252581934 | (37.7099309898835, -122.470252581934) | 9 | 8 | 4 | 64 | 24 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 169869 | 180560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1134 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 8ft | 6001363.50733 | 2087875.35573 | 37.7129853640648 | -122.437142819708 | (37.7129853640648, -122.437142819708) | 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 | |||
| 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 | |||
| 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 | |||
| 170816 | 17626 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6004454.01436 | 2089904.4684 | 37.7187320598162 | -122.426605400341 | (37.7187320598162, -122.426605400341) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 193000 | 17623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1101 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6004371.84322 | 2089954.85636 | 37.718865768324 | -122.426893019707 | (37.718865768324, -122.426893019707) | 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 | ||
| 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 | |||
| 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 | |||
| 64445 | 17617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | 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 | |||
| 17980 | 180512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004254.69534 | 2090025.204 | 37.7190523030053 | -122.427302962162 | (37.7190523030053, -122.427302962162) | 9 | 7 | 6 | 28861 | 5 | |||
| 175502 | 17615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1018 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6004156.70512 | 2090037.90942 | 37.7190816469907 | -122.427642581247 | (37.7190816469907, -122.427642581247) | 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 60428 | 180515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6004177.13289 | 2090077.86698 | 37.7191925171931 | -122.427574815527 | (37.7191925171931, -122.427574815527) | 9 | 7 | 6 | 28861 | 5 | |||
| 18715 | 17618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 1 | 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 | |||
| 83733 | 17620 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 3 | 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 | |||
| 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 | |||
| 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 | |||
| 50995 | 180539 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2063 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000471.84431 | 2090162.7563 | 37.7192153258175 | -122.440388640236 | (37.7192153258175, -122.440388640236) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 44226 | 180517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1023 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6004131.62894 | 2090104.37161 | 37.7192627191689 | -122.427733992853 | (37.7192627191689, -122.427733992853) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 43528 | 17611 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6004077.2256201 | 2090145.4202003 | 37.7193723519994 | -122.427924968089 | (37.7193723519994, -122.427924968089) | 9 | 7 | 6 | 28861 | 5 | |||
| 169347 | 17613 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1001X Persia Ave | 3 | 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 | |||
| 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 | |||
| 37705 | 17606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 945X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004029.89293 | 2090169.1541 | 37.7194348422149 | -122.428090270065 | (37.7194348422149, -122.428090270065) | 9 | 7 | 6 | 28861 | 5 | |||
| 17973 | 17607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 948X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003925.7500102 | 2090181.5613293 | 37.7194630169915 | -122.428451137586 | (37.7194630169915, -122.428451137586) | 9 | 7 | 6 | 28861 | 5 | |||
| 171836 | 17605 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 937 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6003999.6997 | 2090190.61004 | 37.7194920472054 | -122.428196165219 | (37.7194920472054, -122.428196165219) | 9 | 7 | 6 | 28861 | 5 | |||
| 28436 | 17602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | 9 | 7 | 6 | 28861 | 5 | |||
| 167875 | 17598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6003858.86664 | 2090228.3157 | 37.71958760917 | -122.428685659924 | (37.71958760917, -122.428685659924) | 9 | 7 | 6 | 28861 | 5 | |||
| 47025 | 180518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 919 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003927.65212 | 2090238.59404 | 37.7196197239493 | -122.42844862563 | (37.7196197239493, -122.42844862563) | 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 | |||
| 64697 | 180520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 919 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6003878.61607 | 2090266.0202 | 37.7196922551652 | -122.428620079558 | (37.7196922551652, -122.428620079558) | 9 | 7 | 6 | 28861 | 5 | |||
| 82587 | 17597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 844 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003772.37846 | 2090279.52588 | 37.7197233258537 | -122.428988267402 | (37.7197233258537, -122.428988267402) | 9 | 7 | 6 | 28861 | 5 | |||
| 63979 | 17601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3x3 | 6003845.6513541 | 2090290.953545 | 37.7197588510105 | -122.428735803294 | (37.7197588510105, -122.428735803294) | 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 | |||
| 179706 | 17599 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6003845.6513541 | 2090290.953545 | 37.7197588510105 | -122.428735803294 | (37.7197588510105, -122.428735803294) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 40840 | 17595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003715.34966 | 2090318.22231 | 37.7198263494989 | -122.429188153404 | (37.7198263494989, -122.429188153404) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 41166 | 17580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003780.63082 | 2090335.55969 | 37.7198776495042 | -122.428963734788 | (37.7198776495042, -122.428963734788) | 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 | |||
| 71414 | 17582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.429028371762 | (37.7199031291015, -122.429028371762) | 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 | |||
| 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 | |||
| 51187 | 97030 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 278 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5997252 | 2090493 | 37.7199382378616 | -122.451542171872 | (37.7199382378616, -122.451542171872) | 9 | 8 | 6 | 28861 | 24 | |||
| 192705 | 215518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 278 Howth St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997249.4841 | 2090499.44451 | 37.7199557889053 | -122.451551333026 | (37.7199557889053, -122.451551333026) | 9 | 8 | 6 | 28861 | 24 | |||
| 263 | 17585 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003724.8526 | 2090366.56287 | 37.71995962001 | -122.429158750084 | (37.71995962001, -122.429158750084) | 9 | 7 | 6 | 28861 | 5 | |||
| 59722 | 17586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003709.25966 | 2090367.07531 | 37.7199601443381 | -122.429212686015 | (37.7199601443381, -122.429212686015) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 37690 | 17590 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003668.70994 | 2090393.51266 | 37.720030439842 | -122.429354736658 | (37.720030439842, -122.429354736658) | 9 | 7 | 6 | 28861 | 5 | |||
| 59632 | 17589 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003683.23846 | 2090394.91559 | 37.720035114503 | -122.42930461652 | (37.720035114503, -122.42930461652) | 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 | |||
| 31679 | 17592 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.429433892277 | (37.7200700675728, -122.429433892277) | 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 | ||
| 25169 | 17576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.7201172080443 | -122.429795147634 | (37.7201172080443, -122.429795147634) | 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 | |||
| 42975 | 17574 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1997 12:00:00 AM | 16 | 3x3 | 6003494.26805 | 2090459.52433 | 37.7202018157394 | -122.429962428847 | (37.7202018157394, -122.429962428847) | 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 | ||
| 13245 | 17573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 750 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6003469.36772 | 2090473.15538 | 37.7202378333854 | -122.430049472832 | (37.7202378333854, -122.430049472832) | 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 | |||
| 54013 | 17571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003526.33065 | 2090483.75414 | 37.7202701612065 | -122.429853326536 | (37.7202701612065, -122.429853326536) | 9 | 7 | 6 | 28861 | 5 | |||
| 166084 | 17567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2x2 | 6003448.03192 | 2090486.73855 | 37.7202739213865 | -122.430124192087 | (37.7202739213865, -122.430124192087) | 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 | |||
| 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 | |||
| 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 | |||
| 192017 | 180525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003487.94744 | 2090511.72451 | 37.7203447879672 | -122.429987998761 | (37.7203447879672, -122.429987998761) | 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 | |||
| 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 | |||
| 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 |
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) );