trees
213 rows where SiteOrder = 3 and qSpecies_id = 31 sorted by Zip Codes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||||||||
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 | ||||||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
127662 | 119677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
189843 | 119701 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 3 | Median : Cutout | Tree | DPW 1 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||||||||
191279 | 119748 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
138929 | 246537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | 7 | 9 | 11 | 28852 | 10 | |||
157796 | 244256 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005639.4577 | 2110060.8783 | 37.7741439057581 | -122.423940341347 | (37.7741439057581, -122.423940341347) | 7 | 9 | 11 | 28852 | 10 | |||
171503 | 246549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 6005737.248 | 2109452.92689 | 37.7724801381679 | -122.423558835368 | (37.7724801381679, -122.423558835368) | 7 | 9 | 11 | 28852 | 10 | |||
181645 | 244373 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | 7 | 9 | 11 | 28852 | 10 | |||
182106 | 244315 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005508.5005 | 2110550.2437 | 37.7754801903482 | -122.424428160556 | (37.7754801903482, -122.424428160556) | 7 | 9 | 11 | 28852 | 10 | |||
182723 | 244355 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.424130226226 | (37.7750804055544, -122.424130226226) | 7 | 9 | 11 | 28852 | 10 | |||
187670 | 142236 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 689 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004695.4808 | 2110855.1353 | 37.77627140325 | -122.427262313822 | (37.77627140325, -122.427262313822) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |
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 | |||
105551 | 91033 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.7774769212136 | -122.406759301284 | (37.7774769212136, -122.406759301284) | 14 | 2 | 9 | 28853 | 34 | ||
107724 | 85857 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1530 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008243.2994 | 2108951.1128 | 37.7712434091602 | -122.414854606958 | (37.7712434091602, -122.414854606958) | 8 | 2 | 9 | 28853 | 19 | ||
110224 | 198670 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 194 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010573.77225 | 2111256.57135 | 37.7777043359308 | -122.406955887221 | (37.7777043359308, -122.406955887221) | 14 | 2 | 9 | 28853 | 34 | |||
110810 | 101949 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 10 | 3x3 | Permit Number 769636 | 6008537 | 2110562 | 37.7756830245653 | -122.413952655551 | (37.7756830245653, -122.413952655551) | 8 | 2 | 9 | 28853 | 34 | |
118557 | 198684 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009045.18869 | 2110977.41659 | 37.7768521887265 | -122.412224065387 | (37.7768521887265, -122.412224065387) | 8 | 2 | 9 | 28853 | 34 | |||
135105 | 98860 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008529.07758 | 2110594.62185 | 37.7757721514991 | -122.413982369511 | (37.7757721514991, -122.413982369511) | 8 | 2 | 9 | 28853 | 34 | |||
155571 | 200942 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1595 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008302.9396 | 2108913.0233 | 37.7711421752939 | -122.414645612489 | (37.7711421752939, -122.414645612489) | 8 | 2 | 9 | 28853 | 19 | |||
155936 | 102761 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 100X Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2013 12:00:00 AM | 3 | 3x3 | Permit Number 54619 | 6010215.5 | 2111581.3 | 37.7785759102049 | -122.408218187711 | (37.7785759102049, -122.408218187711) | 14 | 2 | 9 | 28853 | 34 |
165025 | 30641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80x 13th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34584 | 6008099.08967 | 2108395.87431 | 37.7697107505788 | -122.415314123362 | (37.7697107505788, -122.415314123362) | 8 | 4 | 9 | 28853 | 19 | |
170581 | 72754 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 181 RUSS ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1998 12:00:00 AM | 3 | 5x5 | 6010587 | 2111361.1 | 37.7779920873886 | -122.40691749682 | (37.7779920873886, -122.40691749682) | 14 | 2 | 9 | 28853 | 34 | ||
185130 | 30619 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1645 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 4 | Permit Number 34580 | 6008146.3215 | 2108637.1249 | 37.7703758225592 | -122.415167828975 | (37.7703758225592, -122.415167828975) | 8 | 2 | 9 | 28853 | 19 | |
187127 | 85768 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008662.6876 | 2109384.932 | 37.7724581311851 | -122.41343460644 | (37.7724581311851, -122.41343460644) | 8 | 2 | 9 | 28853 | 34 | ||
191098 | 255052 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199x 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008753 | 2110574 | 37.7757281025158 | -122.413206304146 | (37.7757281025158, -122.413206304146) | 8 | 2 | 9 | 28853 | 34 | ||||
92342 | 198565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014744.18848 | 2114165.67532 | 37.7859245585079 | -122.392732439056 | (37.7859245585079, -122.392732439056) | 6 | 2 | 9 | 28855 | 6 | |||
163268 | 198575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014794.5907 | 2114154.82505 | 37.7858975653617 | -122.392557300594 | (37.7858975653617, -122.392557300594) | 6 | 2 | 9 | 28855 | 6 | |||
183902 | 253394 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
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 | ||
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 | |||
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 | |||
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 | |
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
107524 | 97834 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
126663 | 198465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015348.3409 | 2105766.19544 | 37.7628949866348 | -122.390055238278 | (37.7628949866348, -122.390055238278) | 14 | 3 | 8 | 28856 | 29 | |||
127376 | 105993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 980 Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6015232.0353 | 2104000.80366 | 37.7580411495011 | -122.390334151305 | (37.7580411495011, -122.390334151305) | 10 | 3 | 8 | 28856 | 29 | |||
129944 | 115551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 18x7 | 6015277.41921 | 2104189.44931 | 37.7585616474178 | -122.390190372193 | (37.7585616474178, -122.390190372193) | 10 | 3 | 8 | 28856 | 29 | ||
142223 | 103419 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
142251 | 198484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6015200.57665 | 2104577.87924 | 37.7596239302292 | -122.390483271483 | (37.7596239302292, -122.390483271483) | 10 | 3 | 8 | 28856 | 29 | |||
143260 | 198595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013296.53525 | 2107120.49149 | 37.7664995737224 | -122.397246743447 | (37.7664995737224, -122.397246743447) | 14 | 3 | 8 | 28856 | 20 | |||
157109 | 3749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 934 Carolina St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6012421.5071398 | 2103592.6632765 | 37.756764184951 | -122.400025556542 | (37.756764184951, -122.400025556542) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
147272 | 137039 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009772.70737 | 2116813.88249 | 37.7929185267084 | -122.410119497111 | (37.7929185267084, -122.410119497111) | 3 | 1 | 10 | 28857 | 21 | |||
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 | |||
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 | |||
97382 | 137049 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008515.90058 | 2116780.94571 | 37.7927575660663 | -122.414465794683 | (37.7927575660663, -122.414465794683) | 5 | 1 | 10 | 28858 | 21 | |||
104664 | 17810 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1900X Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 4 | 3X3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | 13 | 9 | 11 | 28858 | 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 | |||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
95943 | 108135 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2055 FOLSOM ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008137.2 | 2106486.4 | 37.7644699210537 | -122.415047125765 | (37.7644699210537, -122.415047125765) | 8 | 4 | 7 | 28859 | 19 | ||||
99200 | 242647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3000 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008809.14525 | 2102757.20392 | 37.7542681355747 | -122.412459422473 | (37.7542681355747, -122.412459422473) | 2 | 4 | 7 | 28859 | 19 | |||
102300 | 113801 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 806 SHOTWELL ST | 3 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
106451 | 18526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
107317 | 242514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2948 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008345.17157 | 2101253.04618 | 37.7501120086795 | -122.413957566206 | (37.7501120086795, -122.413957566206) | 2 | 4 | 7 | 28859 | 19 | |||
114039 | 44114 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.412744337506 | (37.7509254812099, -122.412744337506) | 2 | 4 | 7 | 28859 | 19 | |||
119476 | 98272 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | ||
129015 | 242568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2121 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008133.25009 | 2106138.47369 | 37.7635143740114 | -122.415036159087 | (37.7635143740114, -122.415036159087) | 8 | 4 | 7 | 28859 | 19 | |||
140465 | 7662 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4x4 | 6008466.34336 | 2099149.15248 | 37.7443419898261 | -122.413389775903 | (37.7443419898261, -122.413389775903) | 2 | 7 | 7 | 28859 | 2 | |||
142346 | 242571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008126.47482 | 2106341.38137 | 37.7640711307933 | -122.415073955818 | (37.7640711307933, -122.415073955818) | 8 | 4 | 7 | 28859 | 19 | |||
163070 | 36147 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2201 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/1998 12:00:00 AM | Permit Number 39234 | 6010900.97776393 | 2106452.95281145 | 37.7645330054499 | -122.405485571016 | (37.7645330054499, -122.405485571016) | 8 | 4 | 8 | 28859 | 19 | ||
166644 | 242459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 434 Banks St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008569.03881 | 2096702.15608 | 37.7376288403924 | -122.412861705413 | (37.7376288403924, -122.412861705413) | 10 | 7 | 7 | 28859 | 2 | |||
171620 | 87306 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
175468 | 23643 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 195 Virginia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2005 12:00:00 AM | 3 | 3X3 | 6006665.30474 | 2098482.56394 | 37.7424104008083 | -122.419570116381 | (37.7424104008083, -122.419570116381) | 2 | 7 | 7 | 28859 | 2 | ||
179870 | 112877 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 300x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x2 | 6010100 | 2099291 | 37.7448230609493 | -122.407750909418 | (37.7448230609493, -122.407750909418) | 2 | 7 | 7 | 28859 | 2 | |||
180073 | 7610 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3201X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008468.12704 | 2100135.33382 | 37.7470499250079 | -122.413453339725 | (37.7470499250079, -122.413453339725) | 2 | 7 | 7 | 28859 | 2 | |||
192321 | 242417 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3652 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005352.57915 | 2101976.52488 | 37.7519299863868 | -122.424357585351 | (37.7519299863868, -122.424357585351) | 2 | 4 | 5 | 28859 | 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) );