trees
119 rows where SiteOrder = 4 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||||||||
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 | ||||||||||||||
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) | ||||||||||
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) | ||||||||||
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) | |||||||||
180678 | 119831 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
188233 | 109165 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
190593 | 244374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.424012927889 | (37.7735554657504, -122.424012927889) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |
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 | |||
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 | ||
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 | |
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 | |||
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 | ||
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 | |||
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 | |||
177447 | 31075 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 7 | Permit Number 34816 | 6005979.98097 | 2107292.47987 | 37.7665617645507 | -122.422565649286 | (37.7665617645507, -122.422565649286) | 8 | 4 | 5 | 28853 | 19 | |
178759 | 198685 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 08th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009031.35533 | 2110985.92555 | 37.7768747760941 | -122.412272520887 | (37.7768747760941, -122.412272520887) | 8 | 2 | 9 | 28853 | 34 | |||
184046 | 46506 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 4 | 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 | |||
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 | ||||
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 | |||
174939 | 198566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014751.35168 | 2114157.00483 | 37.785901149169 | -122.392707049386 | (37.785901149169, -122.392707049386) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
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 | |
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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
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 | |||
163797 | 198485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015200.26669 | 2104562.53753 | 37.7595817879946 | -122.3904832715 | (37.7595817879946, -122.3904832715) | 10 | 3 | 8 | 28856 | 29 | |||
181698 | 198507 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701 Rhode Island St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6011858.82974 | 2105091.40426 | 37.7608480082603 | -122.402076874465 | (37.7608480082603, -122.402076874465) | 10 | 3 | 8 | 28856 | 29 | |||
189071 | 97835 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
164216 | 98273 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | |
187128 | 23644 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 197 Virginia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2005 12:00:00 AM | 8 | 3X3 | 6006643.75963 | 2098486.48829 | 37.7424199625796 | -122.41964489142 | (37.7424199625796, -122.41964489142) | 2 | 7 | 7 | 28859 | 2 | ||
189918 | 31036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.7375542956049 | -122.418102817609 | (37.7375542956049, -122.418102817609) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
188402 | 180550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002268.14618 | 2091228.59703 | 37.7222440023296 | -122.434255671279 | (37.7222440023296, -122.434255671279) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
170637 | 141787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1461 Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003867.7567 | 2113170.8508 | 37.7825829380566 | -122.430290891107 | (37.7825829380566, -122.430290891107) | 7 | 9 | 11 | 29490 | 41 | |||
173965 | 137008 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2110 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6000406.08095 | 2115938.23713 | 37.7899847799168 | -122.44246550939 | (37.7899847799168, -122.44246550939) | 13 | 6 | 1 | 29490 | 27 | |||
189386 | 137009 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3099 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999994.90207 | 2116065.86366 | 37.7903117635268 | -122.443897321805 | (37.7903117635268, -122.443897321805) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | |||
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 |
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) );