trees
1,196 rows where SiteOrder = 1 and qSpecies_id = 31 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
820 | 41547 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 244 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2000 12:00:00 AM | Permit Number 42070 | 6001730.08855162 | 2104417.99791196 | 37.7584284625233 | -122.437059430993 | (37.7584284625233, -122.437059430993) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||
3271 | 260494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
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) | ||||||||||
7090 | 52720 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 710@ 20th ST Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2006 12:00:00 AM | Permit Number 48773 | 6002386.64959974 | 2104032.25895211 | 37.757406613771 | -122.434761169877 | (37.757406613771, -122.434761169877) | 2 | 4 | 5 | 28862 | 3 | |||
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) | ||||||||||
9357 | 106645 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | Permit Number 772901 | 6001633.7 | 2104049.1 | 37.7574100789152 | -122.437366369677 | (37.7574100789152, -122.437366369677) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||||||||||||
9914 | 259754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4041 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x9 | 6003639.19109 | 2100382.47433 | 37.7474561955544 | -122.430169014304 | (37.7474561955544, -122.430169014304) | 2 | 4 | 5 | 63 | 22 | ||||
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) | ||||||||||
10797 | 49734 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2940REVISED Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/26/2005 12:00:00 AM | Permit Number 46534 | 6008347.91771108 | 2101298.08089598 | 37.7502358181357 | -122.413951255275 | (37.7502358181357, -122.413951255275) | 2 | 4 | 7 | 28859 | 19 | ||
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) | ||||||||||
15764 | 258890 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 | ||||
15809 | 54753 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4140-4142 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1972 12:00:00 AM | Permit Number 10601 | 6002268.53854801 | 2101815.27696084 | 37.7513126050411 | -122.435011090977 | (37.7513126050411, -122.435011090977) | 2 | 4 | 5 | 28862 | 22 | |||
16717 | 262293 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2418 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002408 | 2117119 | 37.7933407549318 | -122.435623560602 | (37.7933407549318, -122.435623560602) | 13 | 9 | 1 | 29490 | 27 | ||||
17144 | 48943 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1344 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/2005 12:00:00 AM | Permit Number 46130 | 6010846.48741491 | 2102064.8294817 | 37.7524811515419 | -122.40536498901 | (37.7524811515419, -122.40536498901) | 10 | 4 | 8 | 28859 | 19 | ||
17803 | 117536 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 601 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002803 | 2108833 | 37.7706119122875 | -122.433664364997 | (37.7706119122875, -122.433664364997) | 15 | 5 | 5 | 29492 | 9 | ||||
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 | |||
22843 | 55859 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 206 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2011 12:00:00 AM | 3x3 | Permit Number 56866 | 6005405.07087572 | 2102495.68659096 | 37.7533584481258 | -122.424212980631 | (37.7533584481258, -122.424212980631) | 2 | 4 | 5 | 28859 | 19 | ||
23291 | 41906 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 60 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42269 | 6003134.36765804 | 2107953.23072837 | 37.7682150777502 | -122.432455314129 | (37.7682150777502, -122.432455314129) | 15 | 5 | 5 | 28862 | 3 | ||
23356 | 258198 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1918 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003441 | 2115348 | 37.7885366590719 | -122.431922793308 | (37.7885366590719, -122.431922793308) | 13 | 9 | 1 | 29490 | 27 | ||||
23618 | 112386 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2200 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999398 | 2116386 | 37.7911567075357 | -122.445985588475 | (37.7911567075357, -122.445985588475) | 13 | 6 | 1 | 29490 | 27 | ||||
26544 | 50045 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3x3 | Permit Number 46776 | 6003593.46976323 | 2102471.5753466 | 37.753189787602 | -122.430476153053 | (37.753189787602, -122.430476153053) | 2 | 4 | 5 | 28862 | 22 | |
26567 | 110786 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 410 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012080 | 2118442 | 37.7975180016372 | -122.402250623365 | (37.7975180016372, -122.402250623365) | 3 | 1 | 10 | 308 | 23 | ||||
29074 | 109434 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 7 DANVERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999816.1 | 2105451.8 | 37.7611580492101 | -122.443753102957 | (37.7611580492101, -122.443753102957) | 15 | 5 | 5 | 28862 | 3 | ||||
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 | ||||
36978 | 97271 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3099 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2011 12:00:00 AM | 3x3 | Permit Number 768129 | 5999886 | 2116055 | 37.790275722262 | -122.444273332996 | (37.790275722262, -122.444273332996) | 13 | 6 | 1 | 29490 | 27 | ||
37218 | 256504 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3579 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997147.04528 | 2116001.57364 | 37.7899723836566 | -122.453746006699 | (37.7899723836566, -122.453746006699) | 11 | 6 | 1 | 54 | 31 | |||||
38280 | 66565 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 195 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/1994 12:00:00 AM | Permit Number 29754 | 6004459.66256991 | 2092267.48419115 | 37.725220702439 | -122.426754065425 | (37.725220702439, -122.426754065425) | 9 | 7 | 6 | 28861 | 5 | ||
38837 | 52664 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1328C. CHAVEZ Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50454 | 6003228.63897895 | 2100503.21297012 | 37.7477644538986 | -122.431597294154 | (37.7477644538986, -122.431597294154) | 2 | 4 | 5 | 63 | 22 | ||
41418 | 64129 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 662 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2009 12:00:00 AM | 3x3 | Permit Number 52075 | 6002246.83688253 | 2098888.05007266 | 37.7432738978208 | -122.434876821092 | (37.7432738978208, -122.434876821092) | 2 | 7 | 5 | 63 | 22 | ||
44866 | 50808 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 499 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2006 12:00:00 AM | Permit Number 47332 | 6008981.38895406 | 2105919.05287132 | 37.7629595191577 | -122.412087198232 | (37.7629595191577, -122.412087198232) | 8 | 4 | 7 | 28859 | 19 | ||
44900 | 55226 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1973 12:00:00 AM | 3x3 | Permit Number 51714 | 6015214.86332087 | 2104389.48828919 | 37.7591074416555 | -122.390420697382 | (37.7591074416555, -122.390420697382) | 10 | 3 | 8 | 28856 | 29 | ||
47966 | 173668 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014587 | 2096103 | 37.7363196386473 | -122.392012689283 | (37.7363196386473, -122.392012689283) | 10 | 3 | 8 | 58 | 1 | ||||
49994 | 107991 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4410x 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000358 | 2102265 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | 2 | 4 | 5 | 28862 | 22 | ||||
51352 | 87967 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51002 | 6000425.8 | 2112036.7 | 37.7792732897886 | -122.442117107328 | (37.7792732897886, -122.442117107328) | 15 | 5 | 1 | 29490 | 16 | ||
54430 | 33935 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1932 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/1997 12:00:00 AM | Permit Number 43529 | 6003424.24641356 | 2115332.27843331 | 37.7884925418667 | -122.431979635032 | (37.7884925418667, -122.431979635032) | 13 | 9 | 1 | 29490 | 27 | |||
55545 | 114012 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 952 CAPP ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x5 | 6007364 | 2101732 | 37.7513719527851 | -122.417384460989 | (37.7513719527851, -122.417384460989) | 2 | 4 | 7 | 28859 | 19 | ||||
56170 | 46874 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1360 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | Permit Number 44937 | 6008040.39641169 | 2117081.79459414 | 37.7935568987708 | -122.416132380604 | (37.7935568987708, -122.416132380604) | 5 | 1 | 10 | 28858 | 21 | ||
58093 | 48676 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | 15 | 5 | 11 | 29492 | 9 | ||
58417 | 31777 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2126 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35251 | 5989451.98537783 | 2098364.25532499 | 37.7411009369348 | -122.479079284327 | (37.7411009369348, -122.479079284327) | 1 | 8 | 3 | 29491 | 35 | ||
59353 | 45650 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3001 Washington St | 1 | 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 | |||
68264 | 173898 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 1762 12th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779465 | 5992511.90241 | 2103608.89481 | 37.7556785957656 | -122.468880856653 | (37.7556785957656, -122.468880856653) | 1 | 8 | 4 | 56 | 12 | |||
73437 | 51550 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1247 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2005 12:00:00 AM | Permit Number 47849 | 5999742.39026173 | 2108428.18336747 | 37.7693262500826 | -122.444221920277 | (37.7693262500826, -122.444221920277) | 15 | 5 | 11 | 29492 | 9 | |||
73546 | 53738 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 660-662 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/1972 12:00:00 AM | 4x4 | Permit Number 9418 | 6002127 | 2102089 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | 2 | 4 | 5 | 28862 | 22 | ||
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 | ||
79111 | 50430 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 53REVISED Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2004 12:00:00 AM | Permit Number 47083 | 5998656.22086914 | 2105364.79387751 | 37.7608529276064 | -122.447758347691 | (37.7608529276064, -122.447758347691) | 15 | 5 | 11 | 29492 | 12 | ||
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 | ||
81332 | 52332 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.459292150941 | (37.7353714395789, -122.459292150941) | 9 | 7 | 4 | 59 | 40 | ||||
84560 | 110034 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2690 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008245.7 | 2102789.4 | 37.7543249025472 | -122.414410241803 | (37.7543249025472, -122.414410241803) | 2 | 4 | 7 | 28859 | 19 | |||||
84706 | 103143 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 2620 Buchanan St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003626 | 2117322 | 37.7939672460834 | -122.431423695166 | (37.7939672460834, -122.431423695166) | 13 | 9 | 1 | 29490 | 27 | ||||
85066 | 47527 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 277 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2003 12:00:00 AM | Permit Number 45400 | 6004720.64686455 | 2100142.45310534 | 37.7468583456276 | -122.426412322279 | (37.7468583456276, -122.426412322279) | 2 | 7 | 5 | 63 | 22 | ||
85126 | 34988 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 25 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2005 12:00:00 AM | Permit Number 47856 | 6004110.40789501 | 2102908.72400582 | 37.7544193649252 | -122.428719637491 | (37.7544193649252, -122.428719637491) | 2 | 4 | 5 | 28862 | 22 | |||
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) | ||||||||||
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 | ||||
86168 | 44116 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1201 Treat Ave | 1 | 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 | |||
86900 | 103275 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2800X Pine St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6000456.3 | 2114876.5 | 37.7870723881298 | -122.442215507279 | (37.7870723881298, -122.442215507279) | 13 | 6 | 1 | 29490 | 27 | ||||
89743 | 108480 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 195x 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993013.6 | 2114237 | 37.7848895119291 | -122.467918846049 | (37.7848895119291, -122.467918846049) | 11 | 6 | 2 | 54 | 11 | ||||
95745 | 251581 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 600 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5984701 | 2111577 | 37.7771023963007 | -122.496480968893 | (37.7771023963007, -122.496480968893) | 11 | 6 | 2 | 55 | 26 | ||||
96419 | 81863 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.7293018063197 | -122.459920577502 | (37.7293018063197, -122.459920577502) | 9 | 7 | 4 | 28861 | 40 | ||
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 | |||||
102563 | 99187 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 198X Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000112.3 | 2105690.3 | 37.761829801242 | -122.442745803115 | (37.761829801242, -122.442745803115) | 15 | 5 | 5 | 28862 | 3 | ||||
102627 | 117577 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 701x CALIFORNIA ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6010911 | 2116555 | 37.7922714332447 | -122.406162679671 | (37.7922714332447, -122.406162679671) | 5 | 1 | 10 | 28857 | 6 | ||||
105246 | 36930 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 395 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/2002 12:00:00 AM | Permit Number 45859 | 6001519.66406839 | 2103540.62826183 | 37.7560074548941 | -122.437724334797 | (37.7560074548941, -122.437724334797) | 2 | 4 | 5 | 28862 | 3 | ||
107227 | 86696 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 248 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2007 12:00:00 AM | Permit Number 49695 | 6006131 | 2101708.4 | 37.7512377023769 | -122.421646649176 | (37.7512377023769, -122.421646649176) | 2 | 4 | 5 | 28859 | 19 | |||
109904 | 40800 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 167 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1999 12:00:00 AM | Permit Number 41749 | 5995317.58858632 | 2087395.72139247 | 37.7113228744096 | -122.458004690935 | (37.7113228744096, -122.458004690935) | 9 | 8 | 6 | 28861 | 24 | |||
111191 | 87288 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 131 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096 | 2105951 | 37.7624304670172 | -122.449738139948 | (37.7624304670172, -122.449738139948) | 15 | 5 | 11 | 29492 | 9 | ||
116688 | 40378 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 211 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | Permit Number 41491 | 6005458.18007856 | 2102476.17721451 | 37.7533078785176 | -122.424027930453 | (37.7533078785176, -122.424027930453) | 2 | 4 | 5 | 28859 | 19 | |||
116748 | 45798 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Clipper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/28/2001 12:00:00 AM | Permit Number 44433 | 5999675.79411068 | 2100284.35240189 | 37.7469614974882 | -122.443867085897 | (37.7469614974882, -122.443867085897) | 2 | 4 | 5 | 63 | 22 | |||
117636 | 51892 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2005 12:00:00 AM | Permit Number 48104 | 6004381.23162594 | 2089955.54800101 | 37.7188681982632 | -122.42686061692 | (37.7188681982632, -122.42686061692) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||
128168 | 98270 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
129449 | 46210 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3720 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | Permit Number 44526 | 6003610.24375185 | 2103058.68100506 | 37.7548027913083 | -122.430460032532 | (37.7548027913083, -122.430460032532) | 2 | 4 | 5 | 28862 | 22 | |||
139032 | 114306 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997219 | 2107398 | 37.7663533458689 | -122.452875791584 | (37.7663533458689, -122.452875791584) | 15 | 5 | 11 | 29492 | 9 | ||||
140296 | 43563 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 511 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43224 | 6003260.27136522 | 2098892.12079733 | 37.7433425627255 | -122.431372921103 | (37.7433425627255, -122.431372921103) | 2 | 7 | 5 | 63 | 22 | ||
140749 | 48645 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1639 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2002 12:00:00 AM | Permit Number 45938 | 5993372.07519062 | 2104329.12614097 | 37.7577058229285 | -122.465958462939 | (37.7577058229285, -122.465958462939) | 1 | 8 | 4 | 56 | 12 | ||
143782 | 43394 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 625 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43137 | 6002354.2327444 | 2102058.9743147 | 37.7519866054834 | -122.434732175811 | (37.7519866054834, -122.434732175811) | 2 | 4 | 5 | 28862 | 22 | ||
144725 | 97832 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
147410 | 108134 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2055 FOLSOM ST | 1 | 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 | ||||
147538 | 50047 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 622 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/28/2003 12:00:00 AM | Permit Number 46778 | 6002356.09000511 | 2104575.82706483 | 37.7588973859125 | -122.434905729534 | (37.7588973859125, -122.434905729534) | 2 | 4 | 5 | 28862 | 3 | |||
148761 | 44268 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 315 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2001 12:00:00 AM | Permit Number 43696 | 6009681.81388664 | 2099574.48898013 | 37.7455780401568 | -122.409216925278 | (37.7455780401568, -122.409216925278) | 2 | 7 | 7 | 28859 | 2 | ||
149916 | 115484 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1924 20TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012266 | 2104770 | 37.7599882208521 | -122.400646065117 | (37.7599882208521, -122.400646065117) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||
151627 | 108869 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2360 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008129 | 2104684.1 | 37.7595207600627 | -122.414947915343 | (37.7595207600627, -122.414947915343) | 2 | 4 | 7 | 28859 | 19 | ||||
151881 | 47711 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 134 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45506 | 6002059.65562663 | 2096599.51529402 | 37.7369794845402 | -122.435360375218 | (37.7369794845402, -122.435360375218) | 2 | 7 | 5 | 63 | 7 | ||
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) | ||||||||||
157733 | 82639 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52220 | 6007782.82233026 | 2105835.06197207 | 37.7626615773847 | -122.416226690034 | (37.7626615773847, -122.416226690034) | 8 | 4 | 7 | 28859 | 19 | ||
158775 | 32532 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 70 Porter St | 1 | 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 | ||
159935 | 43393 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 621 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43136 | 6002378.82516016 | 2102060.30692007 | 37.7519916606466 | -122.434647227061 | (37.7519916606466, -122.434647227061) | 2 | 4 | 5 | 28862 | 22 | ||
160961 | 35492 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3711 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/05/2002 12:00:00 AM | Permit Number 44720 | 6005570.32724281 | 2104283.24490329 | 37.7582759965632 | -122.423768581299 | (37.7582759965632, -122.423768581299) | 2 | 4 | 5 | 28859 | 19 | ||
164751 | 40844 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 41772 | 6003136.41051744 | 2107916.36050667 | 37.7681139569619 | -122.432445614329 | (37.7681139569619, -122.432445614329) | 15 | 5 | 5 | 28862 | 3 | ||||
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) | ||||||||||
168553 | 107830 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 145 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999377 | 2107392 | 37.7664602988917 | -122.445411267501 | (37.7664602988917, -122.445411267501) | 15 | 5 | 5 | 29492 | 9 | |||||
169265 | 110630 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1050X MANDALAY LN | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 5991857 | 2101850 | 37.7508112705894 | -122.471017566011 | (37.7508112705894, -122.471017566011) | 1 | 8 | 4 | 29491 | 12 | |||||
169881 | 52081 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 477 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2005 12:00:00 AM | Permit Number 48278 | 5998529.03039776 | 2106418.21564482 | 37.7637380891551 | -122.448274099423 | (37.7637380891551, -122.448274099423) | 15 | 5 | 11 | 29492 | 9 | |||
172713 | 49790 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2862 & YORK 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2003 12:00:00 AM | Permit Number 46574 | 6010228.54978873 | 2101669.78710325 | 37.7513618837191 | -122.40747408248 | (37.7513618837191, -122.40747408248) | 2 | 4 | 7 | 28859 | 19 | |||
177167 | 254242 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
177900 | 63730 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 531 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1987 12:00:00 AM | 3x3 | Permit Number 24397 | 6003608.14995212 | 2110143.86487572 | 37.7742568780009 | -122.430972913922 | (37.7742568780009, -122.430972913922) | 15 | 9 | 11 | 29492 | 10 | |
180002 | 258222 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2997 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3x3 | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 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) );