trees

427 rows where SiteOrder = 2 and qSpecies_id = 31 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
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                    
18433 260397 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/20/2018 12:00:00 AM 3                        
170708 200597 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1300x Newcomb Ave 2 Median : Cutout Tree DPW 1     1 Width 0ft   6016514.3807 2094844.0461 37.7329696218978 -122.385261171263 (37.7329696218978, -122.385261171263) 10 3 8 58 1
61858 200580 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1330 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6016475.5774 2094870.1567 37.7330391696694 -122.385397144532 (37.7330391696694, -122.385397144532) 10 3 8 58 1
54742 200631 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1354 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6016389.5518 2094874.5522 37.7330464790647 -122.385694866729 (37.7330464790647, -122.385694866729) 10 3 8 58 1
172739 200628 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1362 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6016361.9231 2094886.4828 37.7330777092621 -122.385791218603 (37.7330777092621, -122.385791218603) 10 3 8 58 1
146461 16439 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1395 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016285.996927 2094866.016739 37.7330173117391 -122.386052291775 (37.7330173117391, -122.386052291775) 10 3 8 58 1
73818 198602 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 456 Mission Bay Blvd South 2 Sidewalk: Curb side : Yard Tree Private 2     5     6016341.19636 2108654.11325 37.7708796003339 -122.386822673738 (37.7708796003339, -122.386822673738) 14 3 9 310 20
77725 198643 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 421 Mission Bay Blvd North 2 Sidewalk: Curb side : Yard Tree Private 2     7     6016155.89645 2108764.08817 37.7711713062286 -122.387471309764 (37.7711713062286, -122.387471309764) 14 3 9 310 20
135850 198613 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 454 Mission Bay Blvd South 2 Sidewalk: Curb side : Yard Tree Private 2     4     6015962.12973 2108632.67433 37.770799738754 -122.388132389719 (37.770799738754, -122.388132389719) 14 3 9 310 20
144684 198628 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 419 Mission Bay Blvd North 2 Sidewalk: Curb side : Yard Tree Private 2     5     6015696.32506 2108739.9117 37.7710794584904 -122.389059310163 (37.7710794584904, -122.389059310163) 14 3 9 310 20
21138 198434 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015605.2539 2106298.94966 37.7643720601453 -122.389203859978 (37.7643720601453, -122.389203859978) 14 3 9 310 29
142895 107048 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1478 UNDERWOOD AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6015262.9 2093276.2 37.7285953185109 -122.389478448264 (37.7285953185109, -122.389478448264) 10 3 8 58 1
103111 46632 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1478 Underwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2002 12:00:00 AM 9 3x3 Permit Number 44753 6015248.4747 2093270.3779 37.7285785323655 -122.389527911332 (37.7285785323655, -122.389527911332) 10 3 8 58 1
61156 198493 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 950 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6015474.58751 2104684.20174 37.7599310657768 -122.389543022191 (37.7599310657768, -122.389543022191) 10 3 8 28856 29
43816 103418 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 700X 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015432.6 2105817 37.7630391577767 -122.389767361571 (37.7630391577767, -122.389767361571) 14 3 8 28856 29
166871 198470 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 704 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6015369.36264 2105816.80106 37.7630351046092 -122.389986066016 (37.7630351046092, -122.389986066016) 14 3 8 28856 29
52070 198464 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 707 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6015333.10926 2105765.07508 37.7628910655837 -122.390107841403 (37.7628910655837, -122.390107841403) 14 3 8 28856 29
38426 115550 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 925x Minnesota St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   18 20x7   6015279.22506 2104155.94994 37.7584697654838 -122.390181786362 (37.7584697654838, -122.390181786362) 10 3 8 28856 29
30218 97985 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 980 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     16     6015230.10587 2104016.74085 37.7580848025885 -122.390341937645 (37.7580848025885, -122.390341937645) 10 3 8 28856 29
62805 105992 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 980 MINNESOTA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6015221.1 2104017.4 37.758086112912 -122.39037313012 (37.758086112912, -122.39037313012) 10 3 8 28856 29
156161 97833 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
132483 198483 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900 Minnesota St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6015197.31328 2104594.68874 37.7596699044709 -122.390495732502 (37.7596699044709, -122.390495732502) 10 3 8 28856 29
174320 198474 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 800 Minnesota St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6015187.75524 2104800.09072 37.7602333639076 -122.390543142045 (37.7602333639076, -122.390543142045) 10 3 8 28856 29
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
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
36858 22315 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 5115X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3X3   6014716.40109 2094586.27231 37.7321621967642 -122.391459290654 (37.7321621967642, -122.391459290654) 10 3 8 58 1
23894 200745 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5101 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6014683.7532 2094550.1103 37.7320610911002 -122.391569635286 (37.7320610911002, -122.391569635286) 10 3 8 58 1
145272 22327 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5155 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6014617.6908 2094280.6281 37.7313174804906 -122.391779193474 (37.7313174804906, -122.391779193474) 10 3 8 58 1
116534 198560 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1708 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6014655.2828 2096153.01044 37.7364607478562 -122.391780101069 (37.7364607478562, -122.391780101069) 10 3 8 58 1
172901 198526 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 7ft   6014646.0524 2096160.05646 37.736479582376 -122.391812507248 (37.736479582376, -122.391812507248) 10 3 8 58 1
41660 198529 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1722 Newcomb Ave 2 : Tree Private 2     7 Width 7ft   6014569.28946 2096208.90311 37.73660944358 -122.392081326305 (37.73660944358, -122.392081326305) 10 3 8 58 1
160465 198522 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1725 Newcomb Ave 2 : Tree Private 2     3 Width 7ft   6014552.77288 2096169.89847 37.7365014278009 -122.392135704718 (37.7365014278009, -122.392135704718) 10 3 8 58 1
162884 198521 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1737 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 7ft   6014485.10287 2096211.09486 37.7366107871579 -122.392372551071 (37.7366107871579, -122.392372551071) 10 3 8 58 1
45264 198574 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 425 01st St 2 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6014815.04425 2114132.68239 37.7858379025473 -122.392484987011 (37.7858379025473, -122.392484987011) 6 2 9 28855 6
153183 198533 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1762 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 7ft   6014374.32844 2096361.30259 37.7370170747819 -122.392766053934 (37.7370170747819, -122.392766053934) 10 3 8 58 1
112370 198564 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 400 01st St 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6014732.17193 2114176.27095 37.7859529842748 -122.392774754864 (37.7859529842748, -122.392774754864) 6 2 9 28855 6
168414 198544 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700 Newcomb Ave 2 : Tree Private 2     4 Width 0ft   6014356.36657 2096313.21091 37.7368840272751 -122.392824793156 (37.7368840272751, -122.392824793156) 10 3 8 58 1
4812 198517 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1763 Newcomb Ave 2 : Tree Private 2     5 Width 7ft   6014346.73951 2096322.78373 37.7369097775472 -122.392858747949 (37.7369097775472, -122.392858747949) 10 3 8 58 1
70032 253393 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
185910 198653 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 8ft   6014062.16151 2107274.88823 37.7669661078202 -122.394609372737 (37.7669661078202, -122.394609372737) 14 3 9 310 20
101626 201907 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1751 Yosemite Ave 2 : Tree Private 2     5 Width 3ft   6013751.60826 2093257.56774 37.7284602485269 -122.394701804167 (37.7284602485269, -122.394701804167) 10 3 8 58 1
80710 81876 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1209 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52375 6013966.08986 2105691.70822 37.762613702073 -122.394830783137 (37.762613702073, -122.394830783137) 10 3 8 28856 29
49512 254717 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 2 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
185470 198582 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013779.59756 2107146.17602 37.7665969792947 -122.395577705173 (37.7665969792947, -122.395577705173) 14 3 8 28856 20
110681 198594 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1000 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6013331.88607 2107121.53391 37.7665044039878 -122.39712454356 (37.7665044039878, -122.39712454356) 14 3 8 28856 20
67105 110634 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 631 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6013451.1173 2113865.5933 37.7850287006154 -122.397185091079 (37.7850287006154, -122.397185091079) 6 2 9 28856 6
143227 198599 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1050 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6013108.22745 2107111.70363 37.7664649588148 -122.397897454223 (37.7664649588148, -122.397897454223) 14 3 8 28856 20
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
104649 198511 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 678 Arkansas St 2 : Tree Private 2     11 Width 3ft   6012984.38366 2103919.05598 37.7576917548011 -122.398101807147 (37.7576917548011, -122.398101807147) 10 3 8 28856 29
81036 88994 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 680 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2008 12:00:00 AM 3 3x3 Permit Number 51742 6013026.73798 2113549.67814 37.784137636178 -122.398631141832 (37.784137636178, -122.398631141832) 6 2 9 28853 6
121624 198562 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 690 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6012963.68845 2113495.24169 37.7839846534081 -122.39884545027 (37.7839846534081, -122.39884545027) 6 2 9 28853 6
163774 198514 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1601 Bay Shore Blvd 2 : Tree Private 2     6 Width 3ft   6012038.03347 2091375.16372 37.7231961325824 -122.400493582929 (37.7231961325824, -122.400493582929) 10 3 8 58 1
187152 115485 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1924 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6012271.36264 2104713.50287 37.7598333913054 -122.400623549336 (37.7598333913054, -122.400623549336) 10 3 8 28856 29
28247 91339 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 829 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/23/2009 12:00:00 AM 1 3x3 Permit Number 52060 6012087.196 2112565.923 37.7813840839391 -122.401812466037 (37.7813840839391, -122.401812466037) 6 2 9 28856 34
138821 198506 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 743 Rhode Island St 2 : Tree Private 2     14 Width 2ft   6011861.67877 2104921.79011 37.7603824445082 -122.40205509649 (37.7603824445082, -122.40205509649) 10 3 8 28856 29
23263 137056 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 430 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012005.94187 2118434.64519 37.7974936729554 -122.402506368172 (37.7974936729554, -122.402506368172) 3 1 10 308 23
35158 100568 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 868 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6011788.1802 2112369.4793 37.780828003664 -122.40283310111 (37.780828003664, -122.40283310111) 6 2 9 28853 34
75256 137061 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 462 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011779.14715 2118403.24493 37.7973947915995 -122.403288932137 (37.7973947915995, -122.403288932137) 3 1 10 308 23
180670 35675 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 490 Pacific Ave 2 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
58501 242380 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1217 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011151.17373 2102568.66425 37.7538816015592 -122.404346786677 (37.7538816015592, -122.404346786677) 10 4 8 28859 19
81102 242382 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2612 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011032.0091 2101843.28005 37.7518831964576 -122.404707824918 (37.7518831964576, -122.404707824918) 10 4 8 28859 19
92189 36145 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2201 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1998 12:00:00 AM     Permit Number 39234 6010900.97776393 2106452.95281145 37.7645330054499 -122.405485571016 (37.7645330054499, -122.405485571016) 8 4 8 28859 19
68288 143455 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 717 CALIFORNIA ST 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 0ft   6010922.8711 2116581.0775 37.7923436997898 -122.406123443239 (37.7923436997898, -122.406123443239) 5 1 10 28857 6
161728 117578 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 701x CALIFORNIA ST 2 Sidewalk: Curb side : Pot Tree Private 2       3x3   6010911 2116555 37.7922714332447 -122.406162679671 (37.7922714332447, -122.406162679671) 5 1 10 28857 6
96327 113047 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Utah St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6010575.33708 2106849.91364 37.7656047563669 -122.406639855538 (37.7656047563669, -122.406639855538) 8 4 8 28853 19
165047 91032 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010616.6864 2111159.8673 37.7774412104334 -122.406800614681 (37.7774412104334, -122.406800614681) 14 2 9 28853 34
133704 198672 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 193 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/02/2017 12:00:00 AM 3 Width 4ft   6010593.52344 2111314.08538 37.7778633612421 -122.406891615375 (37.7778633612421, -122.406891615375) 14 2 9 28853 34
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
132415 198674 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 169 Russ St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 6ft   6010536.56916 2111353.45515 37.7779682743635 -122.407091416859 (37.7779682743635, -122.407091416859) 14 2 9 28853 34
22910 75248 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 199X RUSS ST 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1995 12:00:00 AM 2 5x5   6010421 2111456 37.7782433704481 -122.407498444933 (37.7782433704481, -122.407498444933) 14 2 9 28853 34
54233 198676 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 Russ St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6010397.30176 2111518.55677 37.7784138101995 -122.407584837978 (37.7784138101995, -122.407584837978) 14 2 9 28853 34
5056 248171 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 314 Franconia St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6010101.97177 2099246.95589 37.7447022358135 -122.407740986359 (37.7447022358135, -122.407740986359) 2 7 7 28859 2
88739 87305 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2895 25th St 2 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
185430 113083 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 501x BURROWS ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009864 2093047 37.7276651627155 -122.408126678641 (37.7276651627155, -122.408126678641) 10 3 7 309 28
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
118194 98271 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 2 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
21744 44267 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 315 Montcalm St 2 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
169533 137038 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1034 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009796.46818 2116817.71138 37.7929303716781 -122.410037553588 (37.7929303716781, -122.410037553588) 3 1 10 28857 21
49834 85787 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1211 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 4 3x3   6009621.8032 2110211.384 37.7747811809083 -122.410175277249 (37.7747811809083, -122.410175277249) 8 2 9 28853 34
4643 76181 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1200 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6009574.6956 2110252.7468 37.7748921128949 -122.410341153951 (37.7748921128949, -122.410341153951) 8 2 9 28853 34
114938 49607 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1245 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/13/2003 12:00:00 AM 3 3x3 Permit Number 46474 6009479.3313 2110073.508 37.7743946188288 -122.410658380122 (37.7743946188288, -122.410658380122) 8 2 9 28853 34
98786 31843 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1275 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM 3 3x3 Permit Number 50128 6009341.4552 2109942.5257 37.7740272409627 -122.411126067297 (37.7740272409627, -122.411126067297) 8 2 9 28853 34
6385 85779 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1301 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 3 3x3   6009155.5683 2109764.3815 37.7735276724734 -122.411756494108 (37.7735276724734, -122.411756494108) 8 2 9 28853 34
77156 142552 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 401 FRANCISCO ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6009334.5084 2121154.0569 37.8048110036751 -122.411942539139 (37.8048110036751, -122.411942539139) 3 1 10 308 23
153488 92522 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1350 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   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
141470 46502 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 165 08th St 2 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
122746 242648 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3000 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008826.30295 2102756.85325 37.7542681355744 -122.412400061838 (37.7542681355744, -122.412400061838) 2 4 7 28859 19
170564 242650 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6008804.74134 2103341.92852 37.7558734101438 -122.41251598264 (37.7558734101438, -122.41251598264) 2 4 7 28859 19
88949 85765 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1350 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 3 3x3   6008925.8803 2109636.8219 37.7731645359448 -122.412542002878 (37.7731645359448, -122.412542002878) 8 2 9 28853 34
88063 7591 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3025 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4x4   6008718.17 2100791.65733 37.7488660796272 -122.41263509881 (37.7488660796272, -122.41263509881) 2 4 7 28859 19
168446 7596 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 3085 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008718.17 2100791.65733 37.7488660796272 -122.41263509881 (37.7488660796272, -122.41263509881) 2 4 7 28859 19
189016 7593 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3065 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/28/1992 12:00:00 AM 6 3X3   6008718.17 2100791.65733 37.7488660796272 -122.41263509881 (37.7488660796272, -122.41263509881) 2 4 7 28859 19
49804 198690 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 52 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6008856.64566 2109825.7938 37.7736795226325 -122.41279485791 (37.7736795226325, -122.41279485791) 8 2 9 28853 34
18245 66733 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1133 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/06/1991 12:00:00 AM     Permit Number 29980 6008997 2116859 37.7929988993441 -122.41280668477 (37.7929988993441, -122.41280668477) 5 1 10 28857 21
163341 137046 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1149 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008987.23365 2116902.13898 37.7931168002562 -122.412843528313 (37.7931168002562, -122.412843528313) 5 1 10 28857 21
153927 137043 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1228 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6008992.0949 2117188.5729 37.7939035505658 -122.412846968238 (37.7939035505658, -122.412846968238) 3 1 10 28857 21
81493 137044 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1200 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6008949.11114 2116700.62228 37.7925613447696 -122.412961180311 (37.7925613447696, -122.412961180311) 5 1 10 28857 21
26333 85767 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1400X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 3 3x3   6008747.4583 2109466.0696 37.7726856753072 -122.41314711365 (37.7726856753072, -122.41314711365) 8 2 9 28853 34
138487 30286 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1355 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/06/1956 12:00:00 AM 10   Permit Number 132 6008896.76565 2117570.49119 37.7949468531686 -122.413203837186 (37.7949468531686, -122.413203837186) 5 1 10 28857 21

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