trees
213 rows where SiteOrder = 3 and qSpecies_id = 31
This data as json, CSV (advanced)
These facets timed out: SiteOrder
| 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 428 | 119830 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 969 | 198677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010377.80869 | 2111537.89689 | 37.7784658224798 | -122.407653636128 | (37.7784658224798, -122.407653636128) | 14 | 2 | 9 | 28853 | 34 | |||
| 1830 | 85780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.411697620327 | (37.7735740897245, -122.411697620327) | 8 | 2 | 9 | 28853 | 34 | ||
| 2754 | 198688 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 165 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008649.71032 | 2110465.86433 | 37.7754253882045 | -122.413555960437 | (37.7754253882045, -122.413555960437) | 8 | 2 | 9 | 28853 | 34 | |||
| 2974 | 260217 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010872 | 2093992 | 37.7303163237311 | -122.404708489988 | (37.7303163237311, -122.404708489988) | 10 | 3 | 7 | 309 | 28 | ||||
| 3023 | 137045 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008938.66451 | 2116698.53363 | 37.7925550234358 | -122.412997178389 | (37.7925550234358, -122.412997178389) | 5 | 1 | 10 | 28857 | 21 | |||
| 3172 | 138586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2702 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000914.7508 | 2114889.5525 | 37.7871343442132 | -122.440630309715 | (37.7871343442132, -122.440630309715) | 13 | 6 | 1 | 29490 | 27 | |||
| 3611 | 242616 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Highland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006874 | 2096520 | 37.7370333899893 | -122.418709361786 | (37.7370333899893, -122.418709361786) | 2 | 7 | 7 | 28859 | 2 | |||
| 4061 | 46914 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
| 4228 | 254718 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
| 6749 | 242499 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008244.84467 | 2103100.98301 | 37.7551803907701 | -122.414435245603 | (37.7551803907701, -122.414435245603) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||||||||||||
| 8303 | 180530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||||||||||||||
| 9031 | 74649 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010746.42629 | 2106444.22464 | 37.7645003969982 | -122.406019510419 | (37.7645003969982, -122.406019510419) | 8 | 4 | 8 | 28859 | 19 | |||
| 9242 | 119783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 14091 | 65135 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 29 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1989 12:00:00 AM | 24 | 6x25 | Permit Number 27110 | 5990777 | 2114840 | 37.7864157730855 | -122.475700726719 | (37.7864157730855, -122.475700726719) | 11 | 6 | 1 | 54 | 33 | |
| 14903 | 91162 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007112.34702 | 2112584.78934 | 37.7811570014217 | -122.419024399678 | (37.7811570014217, -122.419024399678) | 7 | 9 | 9 | 28852 | 36 | |
| 16049 | 258892 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 | ||||
| 16269 | 198600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1050 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013090.52825 | 2107110.01033 | 37.7664593236741 | -122.397958554166 | (37.7664593236741, -122.397958554166) | 14 | 3 | 8 | 28856 | 20 | |||
| 19980 | 98857 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008572.87311 | 2110548.2851 | 37.77564738136 | -122.413827590795 | (37.77564738136, -122.413827590795) | 8 | 2 | 9 | 28853 | 34 | |||
| 20869 | 198471 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015348.95336 | 2105815.25959 | 37.7630297401524 | -122.390056547668 | (37.7630297401524, -122.390056547668) | 14 | 3 | 8 | 28856 | 29 | |||
| 21183 | 254244 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
| 23251 | 119710 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 24118 | 97269 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2050X Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 769192 | 5999973.8 | 2116027.1 | 37.79020412496 | -122.443967546887 | (37.79020412496, -122.443967546887) | 13 | 6 | 1 | 29490 | 27 | |||
| 24826 | 198583 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013760.46871 | 2107146.56354 | 37.7665969793027 | -122.395643896153 | (37.7665969793027, -122.395643896153) | 14 | 3 | 8 | 28856 | 20 | |
| 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 | |||
| 25561 | 101710 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 990 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2016 12:00:00 AM | 3 | 3x3 | 6011874 | 2103773 | 37.7572288087602 | -122.401931725179 | (37.7572288087602, -122.401931725179) | 10 | 3 | 8 | 28856 | 29 | ||
| 26272 | 9765 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.7782631876883 | -122.440226567073 | (37.7782631876883, -122.440226567073) | 15 | 5 | 11 | 29490 | 41 | ||
| 28621 | 198494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015476.06266 | 2104658.66701 | 37.7598610346751 | -122.389536136987 | (37.7598610346751, -122.389536136987) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 30156 | 198691 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016677.93992 | 2094927.14945 | 37.7332068541071 | -122.384701486 | (37.7332068541071, -122.384701486) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 30309 | 137034 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1756 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6005175.40466 | 2117844.84093 | 37.7954905257115 | -122.426099835651 | (37.7954905257115, -122.426099835651) | 13 | 9 | 1 | 28858 | 27 | |||
| 31677 | 138807 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | 13 | 9 | 11 | 29490 | 27 | |||
| 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 | |||
| 33215 | 198644 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6016180.11848 | 2108766.38719 | 37.7711789603624 | -122.387387684488 | (37.7711789603624, -122.387387684488) | 14 | 3 | 9 | 310 | 20 | ||||
| 34642 | 198561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014636.30194 | 2096168.28095 | 37.7365016238531 | -122.391846793904 | (37.7365016238531, -122.391846793904) | 10 | 3 | 8 | 58 | 1 | |||
| 35624 | 38383 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3815-3817 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 769372 | 6003483 | 2105926 | 37.762668556024 | -122.431104719068 | (37.762668556024, -122.431104719068) | 15 | 4 | 5 | 28862 | 3 | ||||
| 36744 | 136985 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5998649.64618 | 2115048.5568 | 37.7874416806303 | -122.448478497988 | (37.7874416806303, -122.448478497988) | 13 | 6 | 1 | 54 | 31 | |||
| 37362 | 242429 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005025.33066 | 2109905.44475 | 37.7736824328302 | -122.426053649163 | (37.7736824328302, -122.426053649163) | 7 | 9 | 11 | 28852 | 10 | |||
| 37614 | 119819 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
| 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 | |||
| 38103 | 242736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6000751.24207 | 2105647.23063 | 37.761747947223 | -122.440532872599 | (37.761747947223, -122.440532872599) | 15 | 5 | 5 | 28862 | 3 | |||
| 39111 | 200598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.7329562777939 | -122.385302911931 | (37.7329562777939, -122.385302911931) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 41548 | 89025 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2724 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774819 | 6000906.5 | 2116912.2 | 37.7926875389812 | -122.440804001611 | (37.7926875389812, -122.440804001611) | 13 | 6 | 1 | 29490 | 27 | |
| 43146 | 7599 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3106 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6008391.53469 | 2100462.67214 | 37.7479444222008 | -122.413741340393 | (37.7479444222008, -122.413741340393) | 2 | 7 | 7 | 28859 | 2 | |||
| 43659 | 17498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.434870362385 | (37.72266164479, -122.434870362385) | 9 | 7 | 6 | 28861 | 5 | |||
| 44141 | 242625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3198X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008400.82271 | 2100348.16336 | 37.747630528223 | -122.413701124526 | (37.747630528223, -122.413701124526) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 46833 | 110635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013464.4845 | 2113882.0453 | 37.7850746181572 | -122.397139998491 | (37.7850746181572, -122.397139998491) | 6 | 2 | 9 | 28856 | 6 | |||
| 48013 | 17920 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | |||
| 48109 | 242378 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005393.3739 | 2103473.26085 | 37.7560419790638 | -122.424322955135 | (37.7560419790638, -122.424322955135) | 2 | 4 | 5 | 28859 | 19 | |||
| 50402 | 121875 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 198 18th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 5990257.12502 | 2114144.50591 | 37.784475988028 | -122.477448493001 | (37.784475988028, -122.477448493001) | 11 | 6 | 2 | 55 | 26 | |||
| 51129 | 242492 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2507 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6008258.15624 | 2103821.5698 | 37.7571597059716 | -122.414440195483 | (37.7571597059716, -122.414440195483) | 2 | 4 | 7 | 28859 | 19 | |||
| 51199 | 119795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 53194 | 138169 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1884 BUSH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004466.1638 | 2115036.3369 | 37.7877389735872 | -122.428353661193 | (37.7877389735872, -122.428353661193) | 13 | 9 | 11 | 28858 | 27 | |||
| 53336 | 17515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002425.76888 | 2091174.41595 | 37.7221041784351 | -122.433706937351 | (37.7221041784351, -122.433706937351) | 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 | |||
| 58932 | 31077 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6005999.97732 | 2107292.75552 | 37.7665636495047 | -122.422496504935 | (37.7665636495047, -122.422496504935) | 8 | 4 | 5 | 28853 | 19 | |
| 58992 | 136977 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 304 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5998585.82745 | 2115521.28488 | 37.7887360181866 | -122.448733358666 | (37.7887360181866, -122.448733358666) | 13 | 6 | 1 | 54 | 31 | |||
| 59964 | 93910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2690 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 3x3 | 6001101.2138 | 2114914.769 | 37.7872141986511 | -122.439986998855 | (37.7872141986511, -122.439986998855) | 13 | 6 | 1 | 29490 | 27 | ||
| 60396 | 245223 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 321 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6005094.6874 | 2109989.2967 | 37.7739165895729 | -122.425819703011 | (37.7739165895729, -122.425819703011) | 7 | 9 | 11 | 28852 | 10 | |||
| 60909 | 85783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1265 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009394.3077 | 2109993.0802 | 37.7741690156078 | -122.410946812123 | (37.7741690156078, -122.410946812123) | 8 | 2 | 9 | 28853 | 34 | ||
| 61263 | 16420 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016497.09656 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | 10 | 3 | 8 | 58 | 1 | |||
| 61272 | 608 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2785X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6008346.15887 | 2102213.06871 | 37.7527480699909 | -122.414022059281 | (37.7527480699909, -122.414022059281) | 2 | 4 | 7 | 28859 | 19 | |||
| 61528 | 136986 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 689 Hayes St | 3 | : | Tree | Private 2 | 19 | Width 4ft | 6004705.5479 | 2110850.60835 | 37.7762595426756 | -122.427227166401 | (37.7762595426756, -122.427227166401) | 7 | 9 | 11 | 28852 | 10 | |||
| 62676 | 32534 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 3 | 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 | ||
| 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 | |||
| 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 | |||
| 69027 | 45652 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3001 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | 13 | 6 | 1 | 29490 | 27 | |||
| 69088 | 136964 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2590 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6000622.04414 | 2118252.24291 | 37.7963507407448 | -122.441884450223 | (37.7963507407448, -122.441884450223) | 13 | 9 | 1 | 57 | 17 | |||
| 69505 | 46504 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.412275670972 | (37.7768559207247, -122.412275670972) | 8 | 2 | 9 | 28853 | 34 | |||
| 69763 | 200749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6014757.0105 | 2094768.5741 | 37.7326650143875 | -122.391331632933 | (37.7326650143875, -122.391331632933) | 10 | 3 | 8 | 58 | 1 | |||
| 70010 | 14840 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.433664099691 | (37.7783201948721, -122.433664099691) | 15 | 5 | 11 | 29492 | 41 | ||
| 74737 | 137014 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2795 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000218.16422 | 2117453.42518 | 37.7941343759438 | -122.443224553374 | (37.7941343759438, -122.443224553374) | 13 | 9 | 1 | 57 | 27 | |||
| 74815 | 198475 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015192.04095 | 2104775.13196 | 37.7601650702756 | -122.390526575643 | (37.7601650702756, -122.390526575643) | 10 | 3 | 8 | 28856 | 29 | |||
| 75234 | 13323 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 3 | 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 | |||
| 77331 | 198504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 785 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 6011870.75445 | 2104712.89725 | 37.7598093776163 | -122.402009022396 | (37.7598093776163, -122.402009022396) | 10 | 3 | 8 | 28856 | 29 | |||
| 77576 | 180549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002285.83786 | 2091218.55546 | 37.7222174345718 | -122.43419379793 | (37.7222174345718, -122.43419379793) | 9 | 7 | 6 | 28861 | 5 | |||
| 78156 | 198614 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015943.0209 | 2108631.53953 | 37.7707955640939 | -122.388198408934 | (37.7707955640939, -122.388198408934) | 14 | 3 | 9 | 310 | 20 | ||||
| 78591 | 198554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | : | Tree | Private 2 | 2 | Width 0ft | 6014551.87687 | 2096170.80222 | 37.7365038595638 | -122.392138865814 | (37.7365038595638, -122.392138865814) | 10 | 3 | 8 | 58 | 1 | |||
| 79347 | 32996 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013182.02247 | 2113705.96324 | 37.7845754090665 | -122.398104877431 | (37.7845754090665, -122.398104877431) | 6 | 2 | 9 | 28853 | 6 | |
| 79500 | 242723 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 291 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004435.5728 | 2103937.20176 | 37.7572617205823 | -122.42766840527 | (37.7572617205823, -122.42766840527) | 2 | 4 | 5 | 28862 | 3 | |||
| 79927 | 7583 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
| 80826 | 141750 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 HOLLIS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004009.3479 | 2113234.7782 | 37.7827664857396 | -122.429805607802 | (37.7827664857396, -122.429805607802) | 7 | 9 | 11 | 29490 | 41 | |||
| 83460 | 108482 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 195x 09TH AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993013.6 | 2114237 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | 11 | 6 | 2 | 54 | 11 | ||||
| 83633 | 200746 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014691.6022 | 2094572.3492 | 37.732122590278 | -122.391544053582 | (37.732122590278, -122.391544053582) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 84939 | 200792 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1582 McKinnon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6015444.6863 | 2095914.5624 | 37.7358498081793 | -122.389034132513 | (37.7358498081793, -122.389034132513) | 10 | 3 | 8 | 58 | 1 | |||
| 86019 | 17537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/1999 12:00:00 AM | 3 | 3x3 | 6002961.1307 | 2090844.10696 | 37.7212275867697 | -122.431832751099 | (37.7212275867697, -122.431832751099) | 9 | 7 | 6 | 28861 | 5 | ||
| 86976 | 22316 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 3 | 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 | |||
| 87612 | 244235 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005565.3705 | 2110205.2337 | 37.774536087812 | -122.424206890938 | (37.774536087812, -122.424206890938) | 7 | 9 | 11 | 28852 | 10 | |||
| 88042 | 244423 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005687.7306 | 2109711.4339 | 37.7731871409862 | -122.423748505092 | (37.7731871409862, -122.423748505092) | 7 | 9 | 11 | 28852 | 10 | |||
| 88315 | 198603 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016318.41228 | 2108651.0285 | 37.7708698687754 | -122.386901269979 | (37.7708698687754, -122.386901269979) | 14 | 3 | 9 | 310 | 20 | ||||
| 88381 | 180555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201 Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002345.73736 | 2091226.34505 | 37.7222422225842 | -122.433987296498 | (37.7222422225842, -122.433987296498) | 9 | 7 | 6 | 28861 | 5 | |||
| 90005 | 7488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6008316.60225 | 2102810.93946 | 37.7543880278024 | -122.414166566835 | (37.7543880278024, -122.414166566835) | 2 | 4 | 7 | 28859 | 19 | |||
| 90577 | 198693 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6016661.34411 | 2095009.85168 | 37.733433020107 | -122.384764621992 | (37.733433020107, -122.384764621992) | 10 | 3 | 8 | 58 | 1 | |||
| 91758 | 200948 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1665 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008110.2367 | 2108543.9059 | 37.7701178370902 | -122.415286046702 | (37.7701178370902, -122.415286046702) | 8 | 2 | 9 | 28853 | 19 |
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) );