trees

2,365 rows where qSpecies_id = 31

✎ View and edit SQL

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)
7980 260398 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   10/20/2018 12:00:00 AM 3                        
8039 260496 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014820 2116826 37.7932334067411 -122.392656317548 (37.7932334067411, -122.392656317548) 12 2 9 28855 6
8224 254835 Private 9 Ulmus parvifolia :: Chinese Elm 31 250 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/28/2019 12:00:00 AM 3 4x3 Permit Number 784635 5989365 2113673 37.7831295589045 -122.480500378386 (37.7831295589045, -122.480500378386) 11 6 2 55 26
8303 180530 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 445 Persia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6002899 2090905 37.7213912632755 -122.432051865162 (37.7213912632755, -122.432051865162) 9 7 6 28861 5
8319 260505 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 760 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2019 12:00:00 AM 3 3x3 Permit Number 784870 6007464 2105234 37.7609932681872 -122.417286789238 (37.7609932681872, -122.417286789238) 2 4 7 28859 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
8560 242617 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300 Bennington St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007051.1369 2096685.57383 37.7374979908344 -122.418108653317 (37.7374979908344, -122.418108653317) 2 7 7 28859 2
8701 200755 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5099 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6014751.1238 2094745.6812 37.7326018284177 -122.391350385093 (37.7326018284177, -122.391350385093) 10 3 8 58 1
8784 46303 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   3 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
8844 119789 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 9 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
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)          
9012 180529 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 445 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 2ft   6002899 2090905 37.7213912632755 -122.432051865162 (37.7213912632755, -122.432051865162) 9 7 6 28861 5
9031 74649 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2233 17th St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6010746.42629 2106444.22464 37.7645003969982 -122.406019510419 (37.7645003969982, -122.406019510419) 8 4 8 28859 19
9121 46285 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   2 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
9179 215530 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 20 Santa Paula Ave 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   5994021.33126 2097709.05499 37.7395662211057 -122.463232727835 (37.7395662211057, -122.463232727835) 1 8 4 59 40
9242 119783 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 3 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
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
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
9860 261981 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 853 Church St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6004377.23368 2103892.56966 37.7571358712273 -122.427866984578 (37.7571358712273, -122.427866984578) 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
9921 220013 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 58 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6005865.66076 2102301.94093 37.7528524632741 -122.42260639579 (37.7528524632741, -122.42260639579) 2 4 5 28859 19
10022 46302 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   5 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)          
10187 242636 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3357 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6008524.39622 2099125.83566 37.7442812262921 -122.413187392191 (37.7442812262921, -122.413187392191) 2 7 7 28859 2
10263 119836 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 9 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
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
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
10305 98993 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1919 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2012 12:00:00 AM 1 3x3 Permit Number 768862 6003810 2118645 37.7976102909597 -122.430881499482 (37.7976102909597, -122.430881499482) 13 9 1 57 17
10327 198443 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015407.0439 2106284.70526 37.7643219580036 -122.389888423915 (37.7643219580036, -122.389888423915) 14 3 9 310 29
10535 258146 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1048 Folsom St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6010642.12041 2111257.36423 37.7777103373451 -122.406719502289 (37.7777103373451, -122.406719502289) 14 2 9 28853 34
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
10966 109166 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 51x OCTAVIA ST 5 Median : Cutout Tree DPW 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
11086 242374 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x McCoppin St 2 Median : Yard Tree DPW 1     5 Width 9ft   6006546.0037 2109148.19709 37.7716890396519 -122.420739627149 (37.7716890396519, -122.420739627149) 8 2 9 28853 19
11128 198446 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 14 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015345.15707 2106282.18607 37.7643116086136 -122.390102298884 (37.7643116086136, -122.390102298884) 14 3 9 310 29
11178 200944 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1595 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008285.8995 2108891.4726 37.771082044751 -122.41470302964 (37.771082044751, -122.41470302964) 8 2 9 28853 19
11525 119754 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 9 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
11729 244288 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 11 Median : Cutout Tree DPW 1     7 Width 0ft   6005589.8116 2110006.6495 37.7739922036556 -122.424108218812 (37.7739922036556, -122.424108218812) 7 9 11 28852 10
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
11978 7458 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2576 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2019 12:00:00 AM 3 5x5   6008224.65711 2103426.0166 37.7560717250334 -122.41452805924 (37.7560717250334, -122.41452805924) 2 4 7 28859 19
11980 7531 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2829 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1     60 3x3   6008362.05512 2101958.45001 37.752049837241 -122.413949076587 (37.752049837241, -122.413949076587) 2 4 7 28859 19
12015 242657 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 502 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001803.26335 2102879.5886 37.7542085204161 -122.436696239741 (37.7542085204161, -122.436696239741) 2 4 5 28862 22
12027 258891 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6003970 2113206 37.7826852397237 -122.429939681443 (37.7826852397237, -122.429939681443) 7 9 11 29490 41
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                      
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)          
12480 47528 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 277 27th St 2 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
12506 105953 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 54 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2014 12:00:00 AM 4   Permit Number 771133 5994277.8794 2115232.96253 37.7876970801078 -122.463617190077 (37.7876970801078, -122.463617190077) 11 6 1 54 11
12615 87685 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 118 Virginia Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/23/2008 12:00:00 AM   4x4 Permit Number 776560 6006594.8 2098480.6 37.7424010366351 -122.419813761733 (37.7424010366351, -122.419813761733) 2 7 7 28859 2
12738 72412 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3485 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997617.1015 2116066.53919 37.7901776988858 -122.452124350462 (37.7901776988858, -122.452124350462) 11 6 1 54 31
13245 17573 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 750 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3x3   6003469.36772 2090473.15538 37.7202378333854 -122.430049472832 (37.7202378333854, -122.430049472832) 9 7 6 28861 5
13324 119752 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 7 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
13803 74944 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2233 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6010701.03805 2106443.01503 37.7644945370101 -122.406176411522 (37.7644945370101, -122.406176411522) 8 4 8 28859 19
13822 115740 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4075 17TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 5x5   6001859 2105815 37.7622716175276 -122.436713598175 (37.7622716175276, -122.436713598175) 15 5 5 28862 3
14091 65135 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 29 16th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/26/1989 12:00:00 AM 24 6x25 Permit Number 27110 5990777 2114840 37.7864157730855 -122.475700726719 (37.7864157730855, -122.475700726719) 11 6 1 54 33
14105 180573 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 515 Burrows St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6009834.24274 2093058.41578 37.7276948418209 -122.408230355163 (37.7276948418209, -122.408230355163) 10 3 7 309 28
14201 138412 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2445 PINE ST 8 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6002175.9998 2115015.7118 37.7875524868912 -122.436275703068 (37.7875524868912, -122.436275703068) 13 6 11 29490 27
14244 46291 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   4 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
14245 242715 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3880 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6002516.60789 2103579.90107 37.7561719248109 -122.434279383699 (37.7561719248109, -122.434279383699) 2 4 5 28862 3
14326 112045 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 2418 Pacific Ave 1 Front Yard : Yard Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 785474 6002446.95594 2117111.03197 37.7933210893366 -122.435488200226 (37.7933210893366, -122.435488200226) 13 9 1 29490 27
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)          
14815 114434 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 576 NOE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   6002952 2104864 37.7597224559637 -122.432865383548 (37.7597224559637, -122.432865383548) 2 4 5 28862 3
14897 242642 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 952 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6007375.48933 2101738.08123 37.7513892968874 -122.417345160358 (37.7513892968874, -122.417345160358) 2 4 7 28859 19
14903 91162 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 525 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2009 12:00:00 AM 4 3x3 Permit Number 52035 6007112.34702 2112584.78934 37.7811570014217 -122.419024399678 (37.7811570014217, -122.419024399678) 7 9 9 28852 36
15104 16448 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1395 Newcomb Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 12 3x3   6016285.996927 2094866.016739 37.7330173117391 -122.386052291775 (37.7330173117391, -122.386052291775) 10 3 8 58 1
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
15262 73760 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3485 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5997597.70095 2116065.74811 37.7901744154595 -122.452191417426 (37.7901744154595, -122.452191417426) 11 6 1 54 31
15421 242745 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4048 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 7x4   6001990.5336 2105890.39532 37.762486108974 -122.436264069635 (37.762486108974, -122.436264069635) 15 5 5 28862 3
15550 32997 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013196.81609 2113721.08426 37.784617751847 -122.398054757315 (37.784617751847, -122.398054757315) 6 2 9 28853 6
15578 119832 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 5 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
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
15703 74054 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 194X Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 5x5   6010549.99954 2111279.17691 37.7777650752333 -122.407039719318 (37.7777650752333, -122.407039719318) 14 2 9 28853 34
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
16029 198662 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 19 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   6013921.99886 2107418.77263 37.7673533891782 -122.395104256175 (37.7673533891782, -122.395104256175) 14 3 9 310 20
16049 258892 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2       Width 0ft   6003970 2113206 37.7826852397237 -122.429939681443 (37.7826852397237, -122.429939681443) 7 9 11 29490 41
16133 7485 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2676 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008262.291899 2102845.0627354 37.7544786718635 -122.414356800841 (37.7544786718635, -122.414356800841) 2 4 7 28859 19
16163 32994 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 666 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/01/1996 12:00:00 AM 3   Permit Number 37299 6013107.84928 2113632.60044 37.7843698402516 -122.398356344087 (37.7843698402516, -122.398356344087) 6 2 9 28853 6
16269 198600 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1050 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6013090.52825 2107110.01033 37.7664593236741 -122.397958554166 (37.7664593236741, -122.397958554166) 14 3 8 28856 20
16396 242589 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 662 Elizabeth St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6002102 2102108 37.7521068951849 -122.435607938928 (37.7521068951849, -122.435607938928) 2 4 5 28862 22
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
16688 137060 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 462 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011807.58318 2118407.27 37.7974074315733 -122.403190818824 (37.7974074315733, -122.403190818824) 3 1 10 308 23
16699 97434 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1380x Newcomb Ave 5 Median : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3     6016360.63733 2094893.94179 37.7330981190079 -122.385796183605 (37.7330981190079, -122.385796183605) 10 3 8 58 1
16709 215479 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 85 Santa Ana Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   5992627.2877 2096233.38868 37.7354340044744 -122.467945378584 (37.7354340044744, -122.467945378584) 1 8 4 59 40
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
16748 96876 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2100X San Jose Ave 8 Sidewalk: Property side : Yard Tree Private 2           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923) 9 7 6 28861 25
16945 180528 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 445 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6002899 2090905 37.7213912632755 -122.432051865162 (37.7213912632755, -122.432051865162) 9 7 6 28861 5
17062 198453 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 700 Mariposa St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6015012.52649 2106269.21439 37.7642575368696 -122.391251877095 (37.7642575368696, -122.391251877095) 14 3 9 310 29
17081 17955 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2475 Pine St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002112.5991001 2115004.8317446 37.7875190105667 -122.436494277471 (37.7875190105667, -122.436494277471) 13 6 11 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
17212 17525 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 342 Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6002628.09189 2091001.66682 37.7216413261572 -122.432995221074 (37.7216413261572, -122.432995221074) 9 7 6 28861 5
17580 17622 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1100 Persia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6004279.3637264 2089959.3319014 37.7188728276872 -122.427213003456 (37.7188728276872, -122.427213003456) 9 7 6 28861 5
17600 220014 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 58X Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6005814 2102330 37.752926592326 -122.422787042427 (37.752926592326, -122.422787042427) 2 4 5 28859 19
17630 242739 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 4097 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6001725.29855 2105828.01986 37.7622997676344 -122.437176952577 (37.7622997676344, -122.437176952577) 15 5 5 28862 3
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
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
17973 17607 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 948X Persia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6003925.7500102 2090181.5613293 37.7194630169915 -122.428451137586 (37.7194630169915, -122.428451137586) 9 7 6 28861 5
17974 7452 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2567 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008279.66518 2103491.16877 37.7562537082641 -122.414342431978 (37.7562537082641, -122.414342431978) 2 4 7 28859 19
17980 180512 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1027 Persia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6004254.69534 2090025.204 37.7190523030053 -122.427302962162 (37.7190523030053, -122.427302962162) 9 7 6 28861 5
17985 242506 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2690 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6008258.82022 2102787.11957 37.7543193780408 -122.414364707265 (37.7543193780408, -122.414364707265) 2 4 7 28859 19

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);