trees

1,626 rows where qSpecies_id = 53 sorted by SiteOrder descending

✎ 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)
26170 124732 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
27391 6825 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1450X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree Fire Dept 16     12 3X3   6016306.5293484 2097712.5542014 37.740834465841 -122.386179680893 (37.740834465841, -122.386179680893) 10 3 8 58 1
38667 21584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1499 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005574.52113 2114792.70084 37.787132663766 -122.424501615425 (37.787132663766, -122.424501615425) 13 9 1 28858 41
43330 113005 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
43639 111595 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
43818 24454 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
48251 23814 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Webster St 6 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6003795.89428 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234) 7 9 11 29490 41
51739 19375 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390X 06th St 6 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6011348.29286 2111104.97037 37.7773313845055 -122.404265868127 (37.7773313845055, -122.404265868127) 14 2 9 28853 34
51996 17674 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1015X Pierce St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002359.74374 2112046.46454 37.7794101245475 -122.435427501131 (37.7794101245475, -122.435427501131) 15 5 11 29490 41
52578 112111 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
53203 110987 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 6 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
55250 112408 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
56222 121122 Undocumented 4 Ficus nitida :: Laurel Fig 53 2701X 24th St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   6010429 2102109 37.7525790830309 -122.406811850318 (37.7525790830309, -122.406811850318) 10 4 7 28859 19
56413 111223 Undocumented 4 Ficus nitida :: Laurel Fig 53 3150x 19TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008324 2105048 37.7605309015758 -122.41429925401 (37.7605309015758, -122.41429925401) 2 4 7 28859 19
58538 15152 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
66108 92850 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3150 Washington St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4 Permit Number 53071 5999589 2116381 37.7911538835614 -122.445324377175 (37.7911538835614, -122.445324377175) 13 6 1 29490 27
73524 101763 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
77953 4657 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 599X Columbus Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     75 3x3   6009795.85928 2119479.51144 37.8002389893085 -122.41022767808 (37.8002389893085, -122.41022767808) 3 1 10 308 4
80144 96411 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2012 12:00:00 AM     Permit Number 768662 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
83449 106526 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 6 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
84798 48704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
85954 15110 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014281.21891 2116519.09631 37.7923607834286 -122.394499049528 (37.7923607834286, -122.394499049528) 12 2 9 28855 6
90466 21986 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2585 03rd St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x9   6015885.54141 2103557.92781 37.7568613347581 -122.388043123198 (37.7568613347581, -122.388043123198) 10 3 8 28856 29
91802 8767 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3360 Geary Blvd 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5996663.11405 2112992.0555 37.7816812935668 -122.455202782638 (37.7816812935668, -122.455202782638) 11 6 1 54 31
94054 21691 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6003627.3299403 2114521.0871369 37.7862767266181 -122.431219072895 (37.7862767266181, -122.431219072895) 13 9 11 29490 13
97800 115748 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X POND ST 6 Sidewalk: Curb side : Cutout Tree Public Library 12 Rec/Park   24 3x3   6003250 2106477 37.764168263012 -122.431949928803 (37.764168263012, -122.431949928803) 15 4 5 28862 3
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
99259 111393 Undocumented 4 Ficus nitida :: Laurel Fig 53 298x CLINTON PARK 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004911 2108307 37.7692870280045 -122.426335307428 (37.7692870280045, -122.426335307428) 8 4 5 28862 19
102193 6752 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1215 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     16 3x3   6017539.76894 2096719.16796 37.738175006759 -122.381846478456 (37.738175006759, -122.381846478456) 10 3 8 58 1
105308 111809 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
109251 17295 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007087.86369 2109540.24307 37.7727960300261 -122.418893105705 (37.7727960300261, -122.418893105705) 8 2 9 28853 19
109441 127217 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 6 Front Yard : Yard Tree Private 2     7 Width 4ft Permit Number 782825 5999928.92975 2117120.95639 37.7932050075467 -122.444201430254 (37.7932050075467, -122.444201430254) 13 9 1 57 27
114077 100108 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
121871 7220 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 41
122363 116519 Undocumented 4 Ficus nitida :: Laurel Fig 53 2050 BRYANT ST 6 Sidewalk: Curb side : Cutout Tree DPW 1     32 3x3   6009415 2105202 37.7610149749795 -122.410536843727 (37.7610149749795, -122.410536843727) 2 4 7 28859 19
122861 103633 Undocumented 4 Ficus nitida :: Laurel Fig 53 1450X Stevenson St 6 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 777592 6006328.29748 2108087.53462 37.7687644406503 -122.421417350008 (37.7687644406503, -122.421417350008) 8 4 7 28853 19
122954 6709 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017621.9936242 2096730.3826429 37.7382103402349 -122.381562963191 (37.7382103402349, -122.381562963191) 10 3 8 58 1
127461 120149 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
130690 109005 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 6 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
134290 94304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
135359 120138 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
138111 111582 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1501-1555 Mariposa St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012875.34483574 2106095.24513094 37.7636610173266 -122.398631621456 (37.7636610173266, -122.398631621456) 14 3 8 28856 29
141424 95044 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 6 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
147266 26947 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002779.24505 2114452.89969 37.786041404384 -122.434148347649 (37.786041404384, -122.434148347649) 13 9 11 29490 27
150414 117403 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
150564 102603 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
155915 6134 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 900X Ellis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6006541.37151 2113590.32225 37.7838857802496 -122.421071112727 (37.7838857802496, -122.421071112727) 7 9 11 28858 41
158929 101720 Undocumented 4 Ficus nitida :: Laurel Fig 53 560 Wisconsin St 6 Sidewalk: Curb side : Cutout Tree Private 2           6012536 2104936 37.760459075101 -122.399723915341 (37.760459075101, -122.399723915341) 10 3 8 28856 29
163561 101313 Undocumented 4 Ficus nitida :: Laurel Fig 53 4244X 19th St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5     14 5x6   6001912 2104709 37.7592378221466 -122.436451128899 (37.7592378221466, -122.436451128899) 2 4 5 28862 3
168485 25273 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1800 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     6 2X2   5994503.82801 2092400.83619 37.725018937185 -122.461179802839 (37.725018937185, -122.461179802839) 9 8 4 28861 40
173445 15262 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007448.14843 2109975.86864 37.774012434525 -122.417677719037 (37.774012434525, -122.417677719037) 8 2 9 28853 19
174050 49256 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
176242 41192 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM     Permit Number 41907 6015636.41824938 2107244.95796966 37.7669713213554 -122.389162129842 (37.7669713213554, -122.389162129842) 14 3 9 310 20
177482 255340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1           6003626.50122 2114526.01983 37.7862902235864 -122.431222292272 (37.7862902235864, -122.431222292272) 13 9 11 29490 13
187443 22718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 6 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
189496 255885 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
3630 258965 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 398x Bryant St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014405 2113268 37.7834409032593 -122.393843088876 (37.7834409032593, -122.393843088876) 6 2 9 28856 6
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
7085 260395 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
20084 115908 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 5 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
21359 87146 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2405 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM   3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
32254 26946 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6002793.58315 2114456.84816 37.7860530596313 -122.434099024105 (37.7860530596313, -122.434099024105) 13 9 11 29490 27
32399 102602 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
34758 15261 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
37162 18698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 5 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
37194 4729 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1075 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008196.257 2120907.29394 37.8040695291651 -122.41586410452 (37.8040695291651, -122.41586410452) 5 1 10 308 32
37409 112110 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 699x COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6009471 2119722 37.8008865881446 -122.411368963081 (37.8008865881446, -122.411368963081) 3 1 10 308 4
38327 17368 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2308X Gough St 5 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005067.32521 2117488.78546 37.794506778582 -122.426448444628 (37.794506778582, -122.426448444628) 13 9 1 28858 27
38641 102621 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
38742 113004 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
38859 115059 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
41773 120139 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
43430 112751 Undocumented 4 Ficus nitida :: Laurel Fig 53 135X TRENTON ST 5 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private     3x3   6009947 2118097 37.7964514227226 -122.409607037418 (37.7964514227226, -122.409607037418) 3 1 10 308 4
43740 9577 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 5x5   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
44254 20167 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1175 Steiner St 5 Sidewalk: Curb side : Cutout Tree Private 2     50 4X4   6002828.6579039 2112263.6806979 37.7800331654734 -122.433820860908 (37.7800331654734, -122.433820860908) 15 9 11 29490 41
45498 22719 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 5 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
47614 4599 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 170 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     45 3X3   6011285.22621 2118219.63855 37.7968630551885 -122.404985101368 (37.7968630551885, -122.404985101368) 3 1 10 308 4
48110 108103 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 5 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
50984 95035 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 5 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
52126 22281 Permitted Site 7 Ficus nitida :: Laurel Fig 53 4755X 03rd St 5 Sidewalk: Curb side : Cutout Tree Arts Commission 19     18 3X3   6015037.5047362 2095657.5026115 37.7351213950345 -122.390423975921 (37.7351213950345, -122.390423975921) 10 3 8 58 1
52557 106525 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2510 Jackson St 5 Sidewalk: Property side : Cutout Tree Private 2         Permit Number 772624 6002049.7 2116744.4 37.7922918429251 -122.436836472971 (37.7922918429251, -122.436836472971) 13 6 1 29490 27
53228 7198 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003395.68163 2111577.87165 37.7781822644093 -122.431810290332 (37.7781822644093, -122.431810290332) 15 9 11 29492 41
53498 24453 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
63970 111213 Undocumented 4 Ficus nitida :: Laurel Fig 53 3100x 19TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008781 2105093 37.7606801217813 -122.412721875792 (37.7606801217813, -122.412721875792) 2 4 7 28859 19
64749 17324 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
65043 100265 Undocumented 4 Ficus nitida :: Laurel Fig 53 40 Federal St 5 Sidewalk: Property side : Cutout Tree Private 2     24 3x3   6014922 2113400.9 37.7838345339316 -122.392063753471 (37.7838345339316, -122.392063753471) 6 2 9 28856 6
65259 105658 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 901X Lombard St 5 Sidewalk: Curb side : Cutout Tree DPW 1 SFUSD         6007813.03508 2120272.88823 37.8023060594642 -122.417145293832 (37.8023060594642, -122.417145293832) 5 1 1 308 32
77006 108328 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
79861 649 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3244X 24th St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007408.30918 2102098.45375 37.7523806444342 -122.417257199664 (37.7523806444342, -122.417257199664) 2 4 7 28859 19
82597 21583 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1499 Sutter St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005557.61202 2114792.21407 37.7871303723087 -122.424560082666 (37.7871303723087, -122.424560082666) 13 9 1 28858 41
83229 51761 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2005 12:00:00 AM 8   Permit Number 48028 6011451.43524212 2112543.5849209 37.781287248696 -122.404010328515 (37.781287248696, -122.404010328515) 6 2 9 28853 34
83435 14655 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 655X McAllister St 5 Sidewalk: Curb side : Cutout Tree DPW 1     60 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
85440 96410 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3828 Jackson St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767718 5995910 2115869 37.7895373746493 -122.458016450618 (37.7895373746493, -122.458016450618) 11 6 1 54 31
85979 120943 Undocumented 4 Ficus nitida :: Laurel Fig 53 485 Carolina St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012395 2105853 37.7629690927527 -122.400275979648 (37.7629690927527, -122.400275979648) 14 3 8 28856 29
86887 94302 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
90420 124731 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
93022 5387 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 325X Dolores St 5 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
94050 6131 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 900X ELLIS ST 5 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6006542 2113585 37.7838712020833 -122.421068560353 (37.7838712020833, -122.421068560353) 7 9 11 28858 41

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