trees
1,196 rows where SiteOrder = 1 and qSpecies_id = 31 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4213 | 251107 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 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 | ||||||||||||||
| 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 | ||||||||||||
| 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 | ||||||||||||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 169437 | 17563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4.5x4.5 | 6003386.5742173 | 2090579.4616613 | 37.7205250375642 | -122.430343243034 | (37.7205250375642, -122.430343243034) | 9 | 7 | 6 | 28861 | 5 | |||
| 178765 | 17558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 632 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6003270.54295 | 2090597.85658 | 37.7205689727677 | -122.430745637999 | (37.7205689727677, -122.430745637999) | 9 | 7 | 6 | 28861 | 5 | |||
| 176437 | 17562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 645 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003332.52001 | 2090606.8773 | 37.7205972528473 | -122.43053204633 | (37.7205972528473, -122.43053204633) | 9 | 7 | 6 | 28861 | 5 | |||
| 26514 | 17556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6003246.79786 | 2090613.71944 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | 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 | |||
| 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 | |||
| 58201 | 17555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 625 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6003276.00472 | 2090644.70105 | 37.7206979067656 | -122.430730099534 | (37.7206979067656, -122.430730099534) | 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 | |||
| 187731 | 17553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 615 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 2X2 | 6003240.95528 | 2090665.71698 | 37.7207536260542 | -122.430852753549 | (37.7207536260542, -122.430852753549) | 9 | 7 | 6 | 28861 | 5 | |||
| 64022 | 17552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 611 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6003214.50174 | 2090682.11363 | 37.7207971487572 | -122.430945364856 | (37.7207971487572, -122.430945364856) | 9 | 7 | 6 | 28861 | 5 | |||
| 28588 | 17551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6003191.74591 | 2090695.76954 | 37.7208333554501 | -122.431024998907 | (37.7208333554501, -122.431024998907) | 9 | 7 | 6 | 28861 | 5 | |||
| 169451 | 180545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 590 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003050.74777 | 2090737.10045 | 37.720938850417 | -122.431515335386 | (37.720938850417, -122.431515335386) | 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 73784 | 17543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 531 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002997.1960546 | 2090824.1673225 | 37.7211748813523 | -122.431706660652 | (37.7211748813523, -122.431706660652) | 9 | 7 | 6 | 28861 | 5 | |||
| 173093 | 17531 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 444 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002851.30461 | 2090860.81338 | 37.7212672324683 | -122.432213580703 | (37.7212672324683, -122.432213580703) | 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 | |||
| 16945 | 180528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
| 41669 | 17530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002769.64699 | 2090910.44177 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | 9 | 7 | 6 | 28861 | 5 | |||
| 47077 | 17528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002717.3851 | 2090942.27549 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | 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 | ||
| 35263 | 17532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 1 | 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 | |||
| 17212 | 17525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6002628.09189 | 2091001.66682 | 37.7216413261572 | -122.432995221074 | (37.7216413261572, -122.432995221074) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 40235 | 17524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | 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 | |||
| 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 | |||
| 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 | |||
| 66323 | 17517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002447.6310917 | 2091110.4885814 | 37.7219298886661 | -122.433626798632 | (37.7219298886661, -122.433626798632) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 25513 | 17523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002491.854148 | 2091141.7505443 | 37.7220182361725 | -122.433476163825 | (37.7220182361725, -122.433476163825) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 175594 | 17513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002376.23219 | 2091204.63173 | 37.7221843332317 | -122.433880332025 | (37.7221843332317, -122.433880332025) | 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 | ||
| 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 | |||
| 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 | |||
| 85661 | 17503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002145.06129 | 2091350.82839 | 37.7225726352947 | -122.434689881929 | (37.7225726352947, -122.434689881929) | 9 | 7 | 6 | 28861 | 5 | |||
| 4856 | 17502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002131.24887 | 2091360.19572 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | 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 | ||
| 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 | |||
| 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 | ||
| 182809 | 180551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001942.54043 | 2091434.19539 | 37.7227900428055 | -122.435395910889 | (37.7227900428055, -122.435395910889) | 9 | 7 | 6 | 28861 | 5 | |||
| 173502 | 17493 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 98X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6001898.43212 | 2091454.2052 | 37.722842480127 | -122.435549814469 | (37.722842480127, -122.435549814469) | 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 | |||
| 182257 | 17491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 33 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001944.766 | 2091477.89942 | 37.7229101706379 | -122.435391342346 | (37.7229101706379, -122.435391342346) | 9 | 7 | 6 | 28861 | 5 | |||
| 70144 | 17490 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 11 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3X3 | 6001895.26392 | 2091509.73666 | 37.7229947770751 | -122.435564737019 | (37.7229947770751, -122.435564737019) | 9 | 7 | 6 | 28861 | 5 | |||
| 2748 | 51918 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 374 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 9 | Permit Number 48916 | 5999699.92432 | 2091688.24542 | 37.7233599872689 | -122.443166369055 | (37.7233599872689, -122.443166369055) | 9 | 7 | 6 | 28861 | 25 | |
| 56016 | 51434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 277 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2004 12:00:00 AM | 9 | Permit Number 47754 | 6002446.43605 | 2092096.42043 | 37.7246369688192 | -122.433701359735 | (37.7246369688192, -122.433701359735) | 9 | 7 | 6 | 28861 | 5 | ||
| 38280 | 66565 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702439 | -122.426754065425 | (37.725220702439, -122.426754065425) | 9 | 7 | 6 | 28861 | 5 | ||
| 68959 | 180563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 88 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001669.16687 | 2092383.58847 | 37.7253813322715 | -122.436408819134 | (37.7253813322715, -122.436408819134) | 9 | 7 | 6 | 28861 | 25 | |||
| 76321 | 180535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010393.23752 | 2092315.54751 | 37.7256863661069 | -122.406245574796 | (37.7256863661069, -122.406245574796) | 10 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 5574 | 259351 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 443 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010386.58434 | 2092559.48475 | 37.7263557946777 | -122.406285753959 | (37.7263557946777, -122.406285753959) | 10 | 3 | 7 | 309 | 28 | ||
| 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 |
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) );