trees
119 rows where SiteOrder = 4 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | 119796 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
470 | 119711 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
1850 | 138602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2660 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2020 02:03:00 PM | 3 | Width 0ft | 6001218.2318 | 2114936.9229 | 37.7872816882761 | -122.439583731447 | (37.7872816882761, -122.439583731447) | 13 | 6 | 1 | 29490 | 27 | ||
2469 | 260495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
4576 | 137643 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1313 McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6002875.8523 | 2111640.465 | 37.7783246490231 | -122.43361304212 | (37.7783246490231, -122.43361304212) | 15 | 5 | 11 | 29492 | 41 | |||
4645 | 107053 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450 Walnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.448562297399 | (37.7875132600186, -122.448562297399) | 13 | 6 | 1 | 54 | 31 | |||||
7235 | 74494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010764.33667 | 2106446.7054 | 37.7645082103165 | -122.405957737757 | (37.7645082103165, -122.405957737757) | 8 | 4 | 8 | 28859 | 19 | |||
10264 | 137022 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003025.71137 | 2117483.5061 | 37.7943766605074 | -122.433512298867 | (37.7943766605074, -122.433512298867) | 13 | 9 | 1 | 29490 | 27 | |||
12246 | 119784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
14244 | 46291 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
14245 | 242715 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3880 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002516.60789 | 2103579.90107 | 37.7561719248109 | -122.434279383699 | (37.7561719248109, -122.434279383699) | 2 | 4 | 5 | 28862 | 3 | |||
14547 | 119749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
15181 | 137040 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009716.37448 | 2116806.11676 | 37.7928940462749 | -122.410313864011 | (37.7928940462749, -122.410313864011) | 3 | 1 | 10 | 28857 | 21 | ||
16481 | 242572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008125.16647 | 2106366.43702 | 37.7641398542804 | -122.415080254657 | (37.7641398542804, -122.415080254657) | 8 | 4 | 7 | 28859 | 19 | |||
19785 | 198466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015361.95352 | 2105766.343 | 37.7628961467725 | -122.390008166863 | (37.7628961467725, -122.390008166863) | 14 | 3 | 8 | 28856 | 29 | |||
21755 | 13324 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 4 | 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 | |||
22908 | 32995 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.26593 | 37.7844388182424 | -122.398280299215 | (37.7844388182424, -122.398280299215) | 6 | 2 | 9 | 28853 | 6 | |
23559 | 17486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
24238 | 215561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994051.56415 | 2096391.91316 | 37.7359514186289 | -122.463032656549 | (37.7359514186289, -122.463032656549) | 9 | 8 | 4 | 59 | 40 | |||
26225 | 244356 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005588.2934 | 2110426.5412 | 37.7751450388721 | -122.424143338216 | (37.7751450388721, -122.424143338216) | 7 | 9 | 11 | 28852 | 10 | |||
26377 | 18527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 4 | 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 | |||
27672 | 107994 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4410x 23RD ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000358 | 2102265 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | 2 | 4 | 5 | 28862 | 22 | ||||
28443 | 198576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014783.08484 | 2114165.12178 | 37.7859251988423 | -122.392597828542 | (37.7859251988423, -122.392597828542) | 6 | 2 | 9 | 28855 | 6 | |||
29434 | 215512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993946.59661 | 2096298.31331 | 37.7356883696217 | -122.463388778181 | (37.7356883696217, -122.463388778181) | 9 | 8 | 4 | 59 | 40 | |||
30451 | 242430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005000.31444 | 2109901.75025 | 37.7736708747372 | -122.426139921128 | (37.7736708747372, -122.426139921128) | 7 | 9 | 11 | 28852 | 10 | |||
31182 | 244424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005686.3603 | 2109729.9326 | 37.7732378565997 | -122.423754560713 | (37.7732378565997, -122.423754560713) | 7 | 9 | 11 | 28852 | 10 | |||
34440 | 138050 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1800 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6003471.3179 | 2114983.7695 | 37.7875382930903 | -122.431791881618 | (37.7875382930903, -122.431791881618) | 13 | 9 | 11 | 29490 | 27 | |||
35163 | 180534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 401 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6002734.62326 | 2090983.4567 | 37.7215973673155 | -122.432625670733 | (37.7215973673155, -122.432625670733) | 9 | 7 | 6 | 28861 | 5 | |||
36432 | 45653 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3001 Washington St | 4 | 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 | |||
37219 | 137015 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2795 Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000234.59127 | 2117454.54255 | 37.7941383806269 | -122.443167794482 | (37.7941383806269, -122.443167794482) | 13 | 9 | 1 | 57 | 27 | |||
40330 | 102181 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1800X Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 37814 | 6003496.6 | 2114956.8 | 37.7874656747779 | -122.431702484378 | (37.7874656747779, -122.431702484378) | 13 | 9 | 11 | 29490 | 27 | ||
41166 | 17580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003780.63082 | 2090335.55969 | 37.7198776495042 | -122.428963734788 | (37.7198776495042, -122.428963734788) | 9 | 7 | 6 | 28861 | 5 | |||
44669 | 200957 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1346 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6009030.8344 | 2109737.7393 | 37.7734475210855 | -122.41218608535 | (37.7734475210855, -122.41218608535) | 8 | 2 | 9 | 28853 | 34 | |||
46084 | 198654 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014045.10244 | 2107292.39517 | 37.7670132295924 | -122.394669603922 | (37.7670132295924, -122.394669603922) | 14 | 3 | 9 | 310 | 20 | |||
48815 | 215543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993948.48206 | 2097274.4923 | 37.7383688232683 | -122.46345307882 | (37.7383688232683, -122.46345307882) | 1 | 8 | 4 | 59 | 40 | |||
49206 | 138803 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2375 PINE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002563.9496 | 2115068.4842 | 37.7877194211645 | -122.434937251329 | (37.7877194211645, -122.434937251329) | 13 | 9 | 11 | 29490 | 27 | |||
50791 | 85769 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008582.3574 | 2109309.4458 | 37.7722463531305 | -122.413707137147 | (37.7722463531305, -122.413707137147) | 8 | 2 | 9 | 28853 | 34 | ||
53501 | 242724 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 291 Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004457.43787 | 2103936.75132 | 37.7572617205612 | -122.427592755209 | (37.7572617205612, -122.427592755209) | 2 | 4 | 5 | 28862 | 3 | |||
55149 | 97435 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.7329510434152 | -122.385341956131 | (37.7329510434152, -122.385341956131) | 10 | 3 | 8 | 58 | 1 | |||
55359 | 44113 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 4 | 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 | |||
55756 | 198584 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013716.83628 | 2107143.63605 | 37.7665865138841 | -122.395794609033 | (37.7665865138841, -122.395794609033) | 14 | 3 | 8 | 28856 | 20 | |
56148 | 246538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | 7 | 9 | 11 | 28852 | 10 | |||
60204 | 242530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2020 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008043.54028 | 2106645.81867 | 37.7649023840706 | -122.415382356711 | (37.7649023840706, -122.415382356711) | 8 | 4 | 7 | 28859 | 19 | |||
73533 | 35673 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
75740 | 215550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994032.03336 | 2096692.14483 | 37.7367746553097 | -122.463121959218 | (37.7367746553097, -122.463121959218) | 9 | 8 | 4 | 59 | 40 | |||
77310 | 119820 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
80227 | 141757 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6003947.6557 | 2113327.5266 | 37.7830176559931 | -122.430025655042 | (37.7830176559931, -122.430025655042) | 7 | 9 | 11 | 29490 | 41 | |||
80886 | 17538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 501X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 4x7.5 | 6002931.4135505 | 2090865.5085081 | 37.7212846660211 | -122.431937002131 | (37.7212846660211, -122.431937002131) | 9 | 7 | 6 | 28861 | 5 | |||
81500 | 242549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2498 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008194.17697 | 2103947.9032 | 37.7575029942757 | -122.414670401237 | (37.7575029942757, -122.414670401237) | 2 | 4 | 7 | 28859 | 19 | |||
81835 | 198436 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015560.81783 | 2106295.35578 | 37.7643597286383 | -122.389357302304 | (37.7643597286383, -122.389357302304) | 14 | 3 | 9 | 310 | 29 | |||
82749 | 101950 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/2012 12:00:00 AM | 11 | 3x3 | Permit Number 769636 | 6008537 | 2110562 | 37.7756830245653 | -122.413952655551 | (37.7756830245653, -122.413952655551) | 8 | 2 | 9 | 28853 | 34 | |
87426 | 17516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002342.1367821 | 2091235.8408171 | 37.7222680914982 | -122.434000421261 | (37.7222680914982, -122.434000421261) | 9 | 7 | 6 | 28861 | 5 | |||
88210 | 198604 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016296.79375 | 2108651.46445 | 37.7708698687766 | -122.386976080084 | (37.7708698687766, -122.386976080084) | 14 | 3 | 9 | 310 | 20 | ||||
89896 | 198555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 4 | : | Tree | Private 2 | 6 | Width 0ft | 6014573.39316 | 2096202.10779 | 37.7365910128673 | -122.39206666287 | (37.7365910128673, -122.39206666287) | 10 | 3 | 8 | 58 | 1 | |||
91210 | 14841 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315X McAllister St | 4 | 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 | ||
93532 | 17520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/20/1998 12:00:00 AM | 18 | 3x3 | 6002494.30852 | 2091085.91322 | 37.7218650586013 | -122.433463691421 | (37.7218650586013, -122.433463691421) | 9 | 7 | 6 | 28861 | 5 | ||
93874 | 109171 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
94085 | 5928 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1335 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004029.33456 | 2112693.29822 | 37.781280848415 | -122.429697830179 | (37.781280848415, -122.429697830179) | 7 | 9 | 11 | 29490 | 41 | |||
95995 | 137050 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008520.18365 | 2116745.46008 | 37.7926603718421 | -122.41444846295 | (37.7926603718421, -122.41444846295) | 5 | 1 | 10 | 28858 | 21 | |||
97038 | 98861 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008516.35298 | 2110609.93053 | 37.7758134708437 | -122.414027470493 | (37.7758134708437, -122.414027470493) | 8 | 2 | 9 | 28853 | 34 | |||
98114 | 7631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
100295 | 198472 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015328.96766 | 2105817.04022 | 37.7630335209151 | -122.390125796375 | (37.7630335209151, -122.390125796375) | 14 | 3 | 8 | 28856 | 29 | |||
103950 | 17572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 749X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6003493.5133628 | 2090512.2555079 | 37.7203465611878 | -122.429968797048 | (37.7203465611878, -122.429968797048) | 9 | 7 | 6 | 28861 | 5 | |||
104469 | 91034 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010653.2937 | 2111194.8106 | 37.7775392048064 | -122.406676440472 | (37.7775392048064, -122.406676440472) | 14 | 2 | 9 | 28853 | 34 | ||
105512 | 242614 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 195 Virginia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2005 12:00:00 AM | 8 | Width 3ft | 6006648.68245 | 2098490.72536 | 37.7424318739254 | -122.419628170307 | (37.7424318739254, -122.419628170307) | 2 | 7 | 7 | 28859 | 2 | ||
107408 | 137063 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011730.01399 | 2118396.8785 | 37.7973745667251 | -122.403458498435 | (37.7973745667251, -122.403458498435) | 3 | 1 | 10 | 308 | 23 | |||
108987 | 16441 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
111038 | 242480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008314.57727 | 2102856.37419 | 37.754512667537 | -122.41417678403 | (37.754512667537, -122.41417678403) | 2 | 4 | 7 | 28859 | 19 | |||
111570 | 254719 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 4 | 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 | ||
112923 | 215498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 95 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993979.5407 | 2097285.08347 | 37.7383996933922 | -122.463346462392 | (37.7383996933922, -122.463346462392) | 1 | 8 | 4 | 59 | 40 | |||
114670 | 137059 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Osgood Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6011878.58523 | 2118466.36717 | 37.7975736631502 | -122.402949290579 | (37.7975736631502, -122.402949290579) | 3 | 1 | 10 | 308 | 23 | |||
116529 | 198508 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 998 Rhode Island St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6011865.97365 | 2103785.48158 | 37.7572626324706 | -122.401960360989 | (37.7572626324706, -122.401960360989) | 10 | 3 | 8 | 28856 | 29 | |||
116784 | 198596 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013207.26395 | 2107117.31767 | 37.7664858887413 | -122.397555296343 | (37.7664858887413, -122.397555296343) | 14 | 3 | 8 | 28856 | 20 | |||
117379 | 242626 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3198X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6008396.65877 | 2100364.68656 | 37.7476756634146 | -122.413716691781 | (37.7476756634146, -122.413716691781) | 2 | 7 | 7 | 28859 | 2 | |||
117998 | 198645 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6016201.48613 | 2108765.95621 | 37.7711789603748 | -122.387313742229 | (37.7711789603748, -122.387313742229) | 14 | 3 | 9 | 310 | 20 | ||||
124451 | 87307 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 4 | 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 | |||
125644 | 7584 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3000X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.413820936867 | (37.7492862752884, -122.413820936867) | 2 | 4 | 7 | 28859 | 19 | |||
126107 | 16421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016475.45956 | 2094869.09162 | 37.7330362386527 | -122.385397477745 | (37.7330362386527, -122.385397477745) | 10 | 3 | 8 | 58 | 1 | |||
127336 | 244316 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005509.917 | 2110533.7186 | 37.7754348964248 | -122.424422084884 | (37.7754348964248, -122.424422084884) | 7 | 9 | 11 | 28852 | 10 | |||
128262 | 242685 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 415 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002981.98467 | 2105833.43743 | 37.7623859982461 | -122.43283093742 | (37.7623859982461, -122.43283093742) | 15 | 4 | 5 | 28862 | 3 | |||
128763 | 17951 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
132025 | 180524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6003506.14684 | 2090499.61443 | 37.7203125670408 | -122.429924226024 | (37.7203125670408, -122.429924226024) | 9 | 7 | 6 | 28861 | 5 | |||
132547 | 242604 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1311 Clayton St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 5999041.21728 | 2105197.03695 | 37.7604143056979 | -122.446414751759 | (37.7604143056979, -122.446414751759) | 15 | 5 | 5 | 28862 | 12 | |||
133252 | 242737 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6000767.45695 | 2105648.39413 | 37.7617520652142 | -122.440476875422 | (37.7617520652142, -122.440476875422) | 15 | 5 | 5 | 28862 | 3 | |||
134170 | 17921 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 4 | 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 | |||
134271 | 198678 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010359.47982 | 2111557.78745 | 37.7785194112705 | -122.407718445767 | (37.7785194112705, -122.407718445767) | 14 | 2 | 9 | 28853 | 34 | |||
138008 | 7600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3106 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008389.36019 | 2100484.75835 | 37.7480049438896 | -122.413750421747 | (37.7480049438896, -122.413750421747) | 2 | 7 | 7 | 28859 | 2 | |||
140062 | 242500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008242.75082 | 2103068.59943 | 37.7550913551842 | -122.414440195464 | (37.7550913551842, -122.414440195464) | 2 | 4 | 7 | 28859 | 19 | |||
141275 | 141751 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 HOLLIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004006.178 | 2113246.4013 | 37.7827982203661 | -122.429817403625 | (37.7827982203661, -122.429817403625) | 7 | 9 | 11 | 29490 | 41 | |||
142832 | 198630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6015737.06642 | 2108741.11663 | 37.7710850252717 | -122.388918467334 | (37.7710850252717, -122.388918467334) | 14 | 3 | 9 | 310 | 20 | ||||
143002 | 108236 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131 RUSS ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6010302 | 2111707 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | 14 | 2 | 9 | 28853 | 34 | |||
143441 | 103420 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 700X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015432.6 | 2105817 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | 14 | 3 | 8 | 28856 | 29 | ||||
146030 | 138408 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6002094.095 | 2115002.411 | 37.7875113123278 | -122.436558124502 | (37.7875113123278, -122.436558124502) | 13 | 6 | 11 | 29490 | 27 | |||
147586 | 244236 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005567.6618 | 2110181.5564 | 37.7744712050545 | -122.424197280606 | (37.7744712050545, -122.424197280606) | 7 | 9 | 11 | 28852 | 10 | |||
150944 | 244257 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005636.4025 | 2110083.7918 | 37.7742066482035 | -122.423952539557 | (37.7742066482035, -122.423952539557) | 7 | 9 | 11 | 28852 | 10 | |||
151229 | 110636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 631 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6013480.9365 | 2113896.4407 | 37.7851150604573 | -122.397084089074 | (37.7851150604573, -122.397084089074) | 6 | 2 | 9 | 28856 | 6 | |||
152759 | 198495 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015477.3225 | 2104627.00235 | 37.7597741601603 | -122.389529568345 | (37.7597741601603, -122.389529568345) | 10 | 3 | 8 | 28856 | 29 | |||
156325 | 201909 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.394593807271 | (37.728396715017, -122.394593807271) | 10 | 3 | 8 | 58 | 1 | |||
157167 | 198476 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6015193.91802 | 2104744.93458 | 37.7600822588968 | -122.390517973622 | (37.7600822588968, -122.390517973622) | 10 | 3 | 8 | 28856 | 29 | |||
163786 | 198456 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014956.86449 | 2106266.70489 | 37.7642475571079 | -122.391444222274 | (37.7642475571079, -122.391444222274) | 14 | 3 | 9 | 310 | 29 |
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) );