trees
1,196 rows where SiteOrder = 1 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4213 | 251107 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
4570 | 119828 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
8918 | 119708 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
9906 | 46304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44564 | ||||||||||||||
10127 | 119793 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
12068 | 26637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X3 | ||||||||||||
15738 | 119781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
18373 | 259350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
85844 | 119675 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
156235 | 119817 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
166196 | 119736 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
2305 | 251465 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 129 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008072 | 2112894 | 37.7820600122669 | -122.415726368353 | (37.7820600122669, -122.415726368353) | 7 | 10 | 9 | 28852 | 36 | ||||
2333 | 246547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.7723771523117 | -122.423530217156 | (37.7723771523117, -122.423530217156) | 7 | 9 | 11 | 28852 | 10 | |||
15645 | 137035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 128 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008088.76932 | 2112909.47489 | 37.7821034452579 | -122.415669449996 | (37.7821034452579, -122.415669449996) | 7 | 10 | 9 | 28852 | 36 | |||
29511 | 244254 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005646.3317 | 2110018.1063 | 37.7740268522621 | -122.423913520847 | (37.7740268522621, -122.423913520847) | 7 | 9 | 11 | 28852 | 10 | |||
32217 | 242427 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005044.68577 | 2109860.00586 | 37.77355876256 | -122.425983461566 | (37.77355876256, -122.425983461566) | 7 | 9 | 11 | 28852 | 10 | |||
35000 | 244311 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005501.4183 | 2110598.8748 | 37.7756133196055 | -122.424456119453 | (37.7756133196055, -122.424456119453) | 7 | 9 | 11 | 28852 | 10 | |||
37182 | 109162 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | |||
53252 | 244930 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005316.3896 | 2109945.8285 | 37.7738097625345 | -122.425049704262 | (37.7738097625345, -122.425049704262) | 7 | 9 | 11 | 28852 | 10 | |||
64742 | 245869 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 265 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005113.693 | 2109858.5889 | 37.7735587716848 | -122.425744654224 | (37.7735587716848, -122.425744654224) | 7 | 9 | 11 | 28852 | 10 | |||
64986 | 245225 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/26/2018 12:00:00 AM | 3 | Width 0ft | 6005059 | 2109842 | 37.7735101318079 | -122.425932664502 | (37.7735101318079, -122.425932664502) | 7 | 9 | 11 | 28852 | 10 | ||
73424 | 242432 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004922.33437 | 2109891.99021 | 37.7736396682718 | -122.426408971312 | (37.7736396682718, -122.426408971312) | 7 | 9 | 11 | 28852 | 10 | |||
75735 | 54877 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 317 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1972 12:00:00 AM | 4x3 | Permit Number 10739 | 6005042.77490786 | 2109859.41873684 | 37.7735570424684 | -122.425990029724 | (37.7735570424684, -122.425990029724) | 7 | 9 | 11 | 28852 | 10 | ||
86066 | 69124 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 471 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 2 | Permit Number 33294 | 6005151.1076 | 2110757.242 | 37.7760283687547 | -122.425679204983 | (37.7760283687547, -122.425679204983) | 7 | 9 | 11 | 28852 | 10 | |
95773 | 244344 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005605.8565 | 2109917.6606 | 37.7737487675431 | -122.424046387097 | (37.7737487675431, -122.424046387097) | 7 | 9 | 11 | 28852 | 10 | |||
96695 | 12261 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 624 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2000 12:00:00 AM | 3 | 3X3 | 6004982.9117 | 2111116.4652 | 37.7770052022278 | -122.426286620749 | (37.7770052022278, -122.426286620749) | 7 | 9 | 11 | 28852 | 10 | ||
98566 | 242426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 317 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005001.43117 | 2109853.31909 | 37.7735379576528 | -122.426132609638 | (37.7735379576528, -122.426132609638) | 7 | 9 | 11 | 28852 | 10 | |||
99529 | 103588 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 101X Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6005198.60314 | 2109385.58511 | 37.772264815602 | -122.425417269432 | (37.772264815602, -122.425417269432) | 7 | 9 | 5 | 28852 | 10 | |||||
115223 | 91160 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007065.15922 | 2112579.7073 | 37.7811403900434 | -122.419187285764 | (37.7811403900434, -122.419187285764) | 7 | 9 | 9 | 28852 | 36 | |
120641 | 100077 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 260 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005310 | 2109942 | 37.7737988894613 | -122.425071534475 | (37.7737988894613, -122.425071534475) | 7 | 9 | 11 | 28852 | 10 | ||||
120909 | 245848 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 251 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2018 12:00:00 AM | 3 | Width 0ft | 6005123.1957 | 2109797.771 | 37.7733923174645 | -122.425707453362 | (37.7733923174645, -122.425707453362) | 7 | 9 | 11 | 28852 | 10 | ||
124514 | 244421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005693.2117 | 2109673.0661 | 37.7730821016693 | -122.423726816669 | (37.7730821016693, -122.423726816669) | 7 | 9 | 11 | 28852 | 10 | |||
131533 | 47022 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 340 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769670 | 6004925.00265887 | 2109895.52879881 | 37.7736495352098 | -122.426399993288 | (37.7736495352098, -122.426399993288) | 7 | 9 | 11 | 28852 | 10 |
135919 | 244410 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005558.4964 | 2110254.116 | 37.7746699186287 | -122.424234147092 | (37.7746699186287, -122.424234147092) | 7 | 9 | 11 | 28852 | 10 | |||
150725 | 63592 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 294 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | 3x3 | Permit Number 24223 | 6005148 | 2109920 | 37.7737293302527 | -122.425630352746 | (37.7737293302527, -122.425630352746) | 7 | 9 | 11 | 28852 | 10 | ||
153189 | 244353 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005598.6806 | 2110351.942 | 37.7749407940225 | -122.424102100187 | (37.7749407940225, -122.424102100187) | 7 | 9 | 11 | 28852 | 10 | |||
173249 | 242434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004879.95955 | 2109886.96936 | 37.773623486774 | -122.426555194781 | (37.773623486774, -122.426555194781) | 7 | 9 | 11 | 28852 | 10 | |||
190137 | 244936 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 294 Page St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | 7 | 9 | 11 | 28852 | 10 | |||
190456 | 103270 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004879 | 2109882 | 37.7736097878739 | -122.426558160091 | (37.7736097878739, -122.426558160091) | 7 | 9 | 11 | 28852 | 10 | ||||
1683 | 85790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | 8 | 2 | 9 | 28853 | 34 | ||
5237 | 200943 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1595 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008270.8642 | 2108872.4279 | 37.7710289077095 | -122.41475368939 | (37.7710289077095, -122.41475368939) | 8 | 2 | 9 | 28853 | 19 | |||
6194 | 198430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 312 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010577.37661 | 2106819.14849 | 37.7655203963654 | -122.406630632998 | (37.7655203963654, -122.406630632998) | 8 | 4 | 8 | 28853 | 19 | |||
8503 | 80188 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1435 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6008710.7243 | 2109332.6568 | 37.7723172927739 | -122.413264744885 | (37.7723172927739, -122.413264744885) | 8 | 2 | 9 | 28853 | 34 | |||
9720 | 242385 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005896.47931 | 2107288.01777 | 37.7665448015394 | -122.422854150009 | (37.7665448015394, -122.422854150009) | 8 | 4 | 5 | 28853 | 19 | |||
10265 | 242383 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005959.30946 | 2107292.9046 | 37.7665617645426 | -122.422637178672 | (37.7665617645426, -122.422637178672) | 8 | 4 | 5 | 28853 | 19 | |||
11968 | 242397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1784 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x8 | 6005589.03646 | 2107271.34136 | 37.7664816601377 | -122.423916355479 | (37.7664816601377, -122.423916355479) | 8 | 4 | 5 | 28853 | 19 | |||
17960 | 81238 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008758.1555 | 2109381.0971 | 37.7724529612773 | -122.41310410127 | (37.7724529612773, -122.41310410127) | 8 | 2 | 9 | 28853 | 34 | |||
18804 | 85789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 8 | 3x3 | 6009966.4934 | 2110538.8397 | 37.7756996123582 | -122.409006027185 | (37.7756996123582, -122.409006027185) | 8 | 2 | 9 | 28853 | 34 | ||
20199 | 46505 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 1 | 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 | |||
20821 | 85762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1246 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009446.0112 | 2110126.3604 | 37.7745378709641 | -122.410777374473 | (37.7745378709641, -122.410777374473) | 8 | 2 | 9 | 28853 | 34 | ||
24697 | 91031 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.148 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | 14 | 2 | 9 | 28853 | 34 | ||
25001 | 242526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1922 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008013.77103 | 2107241.1183 | 37.7665352651235 | -122.415527471335 | (37.7665352651235, -122.415527471335) | 8 | 4 | 7 | 28853 | 19 | ||
25694 | 242395 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1772 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005651.81735 | 2107273.82605 | 37.7664920266105 | -122.423699384137 | (37.7664920266105, -122.423699384137) | 8 | 4 | 5 | 28853 | 19 | |||
29360 | 201851 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1119 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010210.791 | 2110772.6508 | 37.7763552850367 | -122.408177430978 | (37.7763552850367, -122.408177430978) | 8 | 2 | 9 | 28853 | 34 | |||
30695 | 255050 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199x 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008753 | 2110574 | 37.7757281025158 | -122.413206304146 | (37.7757281025158, -122.413206304146) | 8 | 2 | 9 | 28853 | 34 | ||||
37320 | 85785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 5 | 3x3 | 6009541.3755 | 2110133.2543 | 37.7745621465765 | -122.410447976342 | (37.7745621465765, -122.410447976342) | 8 | 2 | 9 | 28853 | 34 | ||
38035 | 85764 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1350 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008969.0729 | 2109678.3998 | 37.7732811230446 | -122.412395532912 | (37.7732811230446, -122.412395532912) | 8 | 2 | 9 | 28853 | 34 | ||
38457 | 85775 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008458.3046 | 2109095.9531 | 37.7716531852784 | -122.4141211414 | (37.7716531852784, -122.4141211414) | 8 | 2 | 9 | 28853 | 19 | ||
41142 | 49606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1245 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009457.5009 | 2110055.1245 | 37.7743429180698 | -122.410732597335 | (37.7743429180698, -122.410732597335) | 8 | 2 | 9 | 28853 | 34 | |
45722 | 242776 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 50 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6006653.46745 | 2109553.97521 | 37.7728092657628 | -122.420396709346 | (37.7728092657628, -122.420396709346) | 8 | 2 | 9 | 28853 | 19 | |||
47321 | 198686 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 165 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6008676.95515 | 2110436.09505 | 37.7753451785803 | -122.413459607989 | (37.7753451785803, -122.413459607989) | 8 | 2 | 9 | 28853 | 34 | |||
47938 | 85786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | 8 | 2 | 9 | 28853 | 34 | ||
52055 | 85766 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2012 12:00:00 AM | 3 | 3x3 | 6008764.4124 | 2109484.6384 | 37.7727376126497 | -122.413089780599 | (37.7727376126497, -122.413089780599) | 8 | 2 | 9 | 28853 | 34 | ||
56109 | 242522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1746 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007972.88605 | 2108208.63163 | 37.7691895323108 | -122.415737399173 | (37.7691895323108, -122.415737399173) | 8 | 4 | 7 | 28853 | 19 | |||
56130 | 102719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1681 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6008087.4331 | 2108473.4904 | 37.7699232110184 | -122.41535993867 | (37.7699232110184, -122.41535993867) | 8 | 2 | 9 | 28853 | 19 | |||
59292 | 242774 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 77 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006712.32772 | 2109620.22361 | 37.7729944847468 | -122.420197807195 | (37.7729944847468, -122.420197807195) | 8 | 2 | 9 | 28853 | 19 | |||
60275 | 98855 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008612.62439 | 2110507.04759 | 37.7755363852191 | -122.413687163434 | (37.7755363852191, -122.413687163434) | 8 | 2 | 9 | 28853 | 34 | |||
61371 | 198671 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 193 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010614.462 | 2111291.13573 | 37.7778015184645 | -122.406817563387 | (37.7778015184645, -122.406817563387) | 14 | 2 | 9 | 28853 | 34 | |||
63920 | 32998 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013208.8867 | 2113734.0736 | 37.7846540898483 | -122.398013908317 | (37.7846540898483, -122.398013908317) | 6 | 2 | 9 | 28853 | 6 | |
64330 | 85794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | 14 | 2 | 9 | 28853 | 34 | ||
65753 | 242398 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1790 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005569.03303 | 2107270.72289 | 37.7664788326491 | -122.423985499825 | (37.7664788326491, -122.423985499825) | 8 | 4 | 5 | 28853 | 19 | |||
73466 | 85777 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1355 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008992.8894 | 2109607.7576 | 37.7730884926028 | -122.412308154132 | (37.7730884926028, -122.412308154132) | 8 | 2 | 9 | 28853 | 34 | ||
75925 | 198668 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 132 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010340.42701 | 2111499.42905 | 37.7783581061813 | -122.407780240888 | (37.7783581061813, -122.407780240888) | 14 | 2 | 9 | 28853 | 34 | |||
76316 | 94343 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 735 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53631 | 6009320.52267 | 2110260.04995 | 37.7748979142358 | -122.411220911221 | (37.7748979142358, -122.411220911221) | 8 | 2 | 9 | 28853 | 34 | |
76318 | 103752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1631 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008153.338 | 2108655.6685 | 37.7704271332463 | -122.415144871631 | (37.7704271332463, -122.415144871631) | 8 | 2 | 9 | 28853 | 19 | ||
76767 | 198689 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 52 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008817.54549 | 2109866.355 | 37.7737886994331 | -122.412932980298 | (37.7737886994331, -122.412932980298) | 8 | 2 | 9 | 28853 | 34 | |||
77425 | 85855 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1530 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008286.9019 | 2109012.2565 | 37.771413745293 | -122.414708111421 | (37.771413745293, -122.414708111421) | 8 | 2 | 9 | 28853 | 19 | ||
79257 | 200937 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1460 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008533.1097 | 2109264.6384 | 37.7721205568757 | -122.413874319686 | (37.7721205568757, -122.413874319686) | 8 | 2 | 9 | 28853 | 34 | |||
79565 | 92521 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1350 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2009 12:00:00 AM | 3x3 | Permit Number 52874 | 6009005 | 2109688 | 37.773309499002 | -122.412271934387 | (37.773309499002, -122.412271934387) | 8 | 2 | 9 | 28853 | 34 | ||
82255 | 88990 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 690 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012998.85994 | 2113529.84786 | 37.7840816336096 | -122.398726198376 | (37.7840816336096, -122.398726198376) | 6 | 2 | 9 | 28853 | 6 | |||
82606 | 242386 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1726 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005876.46884 | 2107287.05597 | 37.766541031574 | -122.422923294401 | (37.766541031574, -122.422923294401) | 8 | 4 | 5 | 28853 | 19 | |||
85837 | 242780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 95 McCoppin St | 1 | : | Tree | Private 2 | 3 | Width 9ft | 6006179.77173 | 2109125.10938 | 37.7716049979898 | -122.422004807797 | (37.7716049979898, -122.422004807797) | 8 | 2 | 9 | 28853 | 19 | |||
85971 | 120895 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005798 | 2107491 | 37.7670965853784 | -122.423209202949 | (37.7670965853784, -122.423209202949) | 8 | 4 | 5 | 28853 | 19 | ||||
87031 | 85761 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1228 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009463.2457 | 2110145.8929 | 37.7745924689532 | -122.410719136445 | (37.7745924689532, -122.410719136445) | 8 | 2 | 9 | 28853 | 34 | ||
89717 | 112625 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1811 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008061 | 2107870 | 37.7682646820652 | -122.415408640275 | (37.7682646820652, -122.415408640275) | 8 | 4 | 7 | 28853 | 19 | |||
90769 | 85756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 956 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011236.2364 | 2111841.2613 | 37.7793468061687 | -122.404705356954 | (37.7793468061687, -122.404705356954) | 14 | 2 | 9 | 28853 | 34 | ||
91200 | 242577 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1811 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008043.01248 | 2107858.0308 | 37.7682308064267 | -122.41547001005 | (37.7682308064267, -122.41547001005) | 8 | 4 | 7 | 28853 | 19 | |||
96038 | 198683 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009066.22564 | 2110952.30823 | 37.7767844274995 | -122.412149517004 | (37.7767844274995, -122.412149517004) | 8 | 2 | 9 | 28853 | 34 | |||
102071 | 242390 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1752 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005758.82416 | 2107281.5797 | 37.7665193561146 | -122.42332981762 | (37.7665193561146, -122.42332981762) | 8 | 4 | 5 | 28853 | 19 | |||
102983 | 242391 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1754 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005735.36143 | 2107280.34604 | 37.7665146445612 | -122.4234108834 | (37.7665146445612, -122.4234108834) | 8 | 4 | 5 | 28853 | 19 | |||
105868 | 28961 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 207 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/02/2011 12:00:00 AM | 3 | 3x3 | 6008851.69192 | 2110257.83982 | 37.7748655413382 | -122.412842545373 | (37.7748655413382, -122.412842545373) | 8 | 2 | 9 | 28853 | 34 | ||
107502 | 101947 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008537 | 2110562 | 37.7756830245653 | -122.413952655551 | (37.7756830245653, -122.413952655551) | 8 | 2 | 9 | 28853 | 34 | |||
107680 | 200975 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1275 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6009315.029 | 2109918.3974 | 37.7739595082871 | -122.411215775633 | (37.7739595082871, -122.411215775633) | 8 | 2 | 9 | 28853 | 34 | |||
108503 | 242388 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1736 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005832.62988 | 2107283.8382 | 37.7665297225864 | -122.423074697036 | (37.7665297225864, -122.423074697036) | 8 | 4 | 5 | 28853 | 19 | |||
110020 | 66997 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 816 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/1992 12:00:00 AM | 5 | Permit Number 30351 | 6012151.3036 | 2112714.2862 | 37.7817950322681 | -122.401601114371 | (37.7817950322681, -122.401601114371) | 6 | 2 | 9 | 28853 | 34 | ||
114714 | 242384 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1716 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005916.49708 | 2107289.32235 | 37.7665495130686 | -122.422785004724 | (37.7665495130686, -122.422785004724) | 8 | 4 | 5 | 28853 | 19 | |||
115214 | 200946 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1609 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6008197.4416 | 2108743.8758 | 37.7706718082156 | -122.414998560902 | (37.7706718082156, -122.414998560902) | 8 | 2 | 9 | 28853 | 19 | |||
118750 | 85788 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1161 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009943.5141 | 2110517.0093 | 37.775638383908 | -122.409083977926 | (37.775638383908, -122.409083977926) | 8 | 2 | 9 | 28853 | 34 | ||
119953 | 85744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 868 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011811.5337 | 2112389.6274 | 37.780884629613 | -122.402753726875 | (37.780884629613, -122.402753726875) | 6 | 2 | 9 | 28853 | 34 | ||
121104 | 98858 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008557.54308 | 2110566.5981 | 37.7756968035946 | -122.413881917042 | (37.7756968035946, -122.413881917042) | 8 | 2 | 9 | 28853 | 34 |
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) );