trees

379 rows where qSpecies_id = 86 sorted by Police Districts

✎ 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)
73562 59560 Permitted Site 7 Taxus baccata :: Irish Yew 86 5 Eureka St 1 Sidewalk: Property side : Cutout Tree Private 2   02/03/1981 12:00:00 AM   1x1 Permit Number 18946 6001393.95326629 2105805.98956595 37.7622204371899 -122.438321370904 (37.7622204371899, -122.438321370904) 15 5 5 28862 3
78875 247550 DPW Maintained 1 Taxus baccata :: Irish Yew 86 815 Buena Vista Ave West 7 Sidewalk: Property side : Yard Tree Private 2     18 Width 2ft   6000097.50297 2108400.91643 37.7692716350156 -122.442991647843 (37.7692716350156, -122.442991647843) 15 5 11 29492 9
112775 241073 DPW Maintained 1 Taxus baccata :: Irish Yew 86 9 Eureka St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 1ft   6001398.38872 2105751.17643 37.7620701860117 -122.438302103356 (37.7620701860117, -122.438302103356) 15 5 5 28862 3
137739 241056 DPW Maintained 1 Taxus baccata :: Irish Yew 86 4864 17th St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 5ft   5997871.31028 2105665.38567 37.7616333843862 -122.450494663794 (37.7616333843862, -122.450494663794) 15 5 11 29492 9
144237 241072 DPW Maintained 1 Taxus baccata :: Irish Yew 86 121 Buena Vista Ter 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6001500.23395 2107474.74915 37.7668084854387 -122.43807332932 (37.7668084854387, -122.43807332932) 15 5 5 28862 3
182035 241074 DPW Maintained 1 Taxus baccata :: Irish Yew 86 5 Eureka St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 1ft   6001396.61944 2105774.83467 37.762135045117 -122.438309917572 (37.762135045117, -122.438309917572) 15 5 5 28862 3
290 72670 DPW Maintained 1 Taxus baccata :: Irish Yew 86 203 04th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5994586.71732 2114106.61682 37.7846222306097 -122.462466948558 (37.7846222306097, -122.462466948558) 11 6 2 54 11
1950 71713 DPW Maintained 1 Taxus baccata :: Irish Yew 86 782 40th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5983564.60428 2110493.72832 37.7740614056929 -122.500331946576 (37.7740614056929, -122.500331946576) 11 6 2 55 26
3404 74737 DPW Maintained 1 Taxus baccata :: Irish Yew 86 151X Palm Ave 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5995889.08215 2113282.06845 37.7824331529909 -122.457901543211 (37.7824331529909, -122.457901543211) 11 6 1 54 31
5035 103624 Permitted Site 7 Taxus baccata :: Irish Yew 86 333 El Camino Del Mar 1 Sidewalk: Property side : Cutout Tree Private 2   06/04/2013 12:00:00 AM     Permit Number 770205 5987603.5 2115303.5 37.7875039187234 -122.486714142272 (37.7875039187234, -122.486714142272) 11 6 1 55 33
5140 70173 DPW Maintained 1 Taxus baccata :: Irish Yew 86 246 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     5992471.1879 2113801.97828 37.7836637247597 -122.469763717453 (37.7836637247597, -122.469763717453) 11 6 2 54 11
5435 70223 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2011 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5989310.46344 2111227.07993 37.776410575875 -122.480509949706 (37.776410575875, -122.480509949706) 11 6 2 55 26
5717 72392 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2220 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     5988673.5466 2110578.22329 37.7745919608967 -122.48266563867 (37.7745919608967, -122.48266563867) 11 6 2 55 26
6245 75019 DPW Maintained 1 Taxus baccata :: Irish Yew 86 151X Palm Ave 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   6 3x3   5995892.05475 2113163.21783 37.782106991639 -122.457882656117 (37.782106991639, -122.457882656117) 11 6 1 54 31
6392 70172 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3027 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5989237.11171 2111905.73167 37.7782697016213 -122.480813388031 (37.7782697016213, -122.480813388031) 11 6 2 55 26
7366 444 DPW Maintained 1 Taxus baccata :: Irish Yew 86 700X 23rd Ave 5 Median : Cutout Tree DPW 1     3 8-HOA   5988817.90932 2110395.27546 37.774098034723 -122.482152859676 (37.774098034723, -122.482152859676) 11 6 2 55 26
7835 258799 Significant Tree 6 Taxus baccata :: Irish Yew 86 566 29th Ave 1 Front Yard : Cutout Tree Private 2       3x3   5986943 2112080 37.7786145821325 -122.488762272653 (37.7786145821325, -122.488762272653) 11 6 2 55 26
11629 47454 DPW Maintained 1 Taxus baccata :: Irish Yew 86 5135 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/14/2002 12:00:00 AM 6   Permit Number 45360 5982684.34734 2111666.51211 37.7772298203102 -122.50346371712 (37.7772298203102, -122.50346371712) 11 6 2 55 26
13058 260903 Significant Tree 6 Taxus baccata :: Irish Yew 86 51 Shore View Ave 1 Sidewalk: Property side : Yard Tree Private 2       Width 4ft   5984536 2112849 37.7805852728313 -122.497145662996 (37.7805852728313, -122.497145662996) 11 6 2 55 26
21064 45165 DPW Maintained 1 Taxus baccata :: Irish Yew 86 227 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/23/2001 12:00:00 AM 3   Permit Number 44015 5987719.09382 2114404.67144 37.7850427307042 -122.486248205367 (37.7850427307042, -122.486248205367) 11 6 1 55 26
22738 120295 DPW Maintained 1 Taxus baccata :: Irish Yew 86 191 24th Ave 4 Sidewalk: Property side : Yard Tree Private 2     17 Width 3ft   5988321.26869 2114707.42753 37.7859090914651 -122.484187107183 (37.7859090914651, -122.484187107183) 11 6 1 55 33
41820 68457 DPW Maintained 1 Taxus baccata :: Irish Yew 86 119 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/04/1993 12:00:00 AM 12   Permit Number 32319 5991463.79981 2114626.05304 37.7858681269791 -122.473308986123 (37.7858681269791, -122.473308986123) 11 6 2 54 26
44958 136637 DPW Maintained 1 Taxus baccata :: Irish Yew 86 91 Mayfair Dr 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5997659.79036 2114483.77284 37.7858342881777 -122.451862419331 (37.7858342881777, -122.451862419331) 15 6 1 54 31
60405 120082 DPW Maintained 1 Taxus baccata :: Irish Yew 86 261 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5987725.3967 2114231.06843 37.7845664337094 -122.486213650773 (37.7845664337094, -122.486213650773) 11 6 1 55 26
69558 84155 DPW Maintained 1 Taxus baccata :: Irish Yew 86 770 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/23/2009 12:00:00 AM 5 3x3 Permit Number 52704 5981697.89996 2110507.76717 37.7739902053501 -122.506790127416 (37.7739902053501, -122.506790127416) 11 6 2 55 26
72527 120265 DPW Maintained 1 Taxus baccata :: Irish Yew 86 100 24th Ave 3 Side Yard : Yard Tree Private 2     20     5988361.48129 2115164.47421 37.7871663527314 -122.484081512932 (37.7871663527314, -122.484081512932) 11 6 1 55 33
73016 120230 DPW Maintained 1 Taxus baccata :: Irish Yew 86 154 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5988064.78369 2114963.42937 37.7865970627596 -122.485093253087 (37.7865970627596, -122.485093253087) 11 6 1 55 33
85219 136636 DPW Maintained 1 Taxus baccata :: Irish Yew 86 91 Mayfair Dr 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5997648.25188 2114482.46822 37.7858300451643 -122.451902244894 (37.7858300451643, -122.451902244894) 15 6 1 54 31
94393 68663 DPW Maintained 1 Taxus baccata :: Irish Yew 86 142 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/1993 12:00:00 AM 10   Permit Number 32570 5993373.867 2114549.20899 37.7857675498482 -122.466695151518 (37.7857675498482, -122.466695151518) 11 6 2 54 11
106864 103625 Permitted Site 7 Taxus baccata :: Irish Yew 86 333 El Camino Del Mar 2 Sidewalk: Property side : Cutout Tree Private 2   06/04/2013 12:00:00 AM     Permit Number 770205 5987603.5 2115303.5 37.7875039187234 -122.486714142272 (37.7875039187234, -122.486714142272) 11 6 1 55 33
115107 123109 DPW Maintained 1 Taxus baccata :: Irish Yew 86 534 11th Ave 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   5992552.3957 2111792.37608 37.7781505989958 -122.469336449069 (37.7781505989958, -122.469336449069) 11 6 2 54 11
118052 52756 DPW Maintained 1 Taxus baccata :: Irish Yew 86 176@ GEARY Palm Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2006 12:00:00 AM 7   Permit Number 48800 5995950.25747 2113100.83881 37.7819390591214 -122.457676787394 (37.7819390591214, -122.457676787394) 11 6 1 54 31
127245 123108 DPW Maintained 1 Taxus baccata :: Irish Yew 86 534 11th Ave 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   5992553.53653 2111802.27469 37.7781778438173 -122.469333223241 (37.7781778438173, -122.469333223241) 11 6 2 54 11
129943 123960 DPW Maintained 1 Taxus baccata :: Irish Yew 86 241 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft Permit Number 782043 5993663.58723 2113895.36148 37.7839889783025 -122.465645289525 (37.7839889783025, -122.465645289525) 11 6 2 54 11
133639 121844 DPW Maintained 1 Taxus baccata :: Irish Yew 86 518 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   5990041.13259 2111807.14387 37.7780457072257 -122.478024804476 (37.7780457072257, -122.478024804476) 11 6 2 55 26
135535 120845 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 19th Ave 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   5989915.85655 2113416.78862 37.7824580717728 -122.478575916409 (37.7824580717728, -122.478575916409) 11 6 2 55 26
150071 67960 DPW Maintained 1 Taxus baccata :: Irish Yew 86 819 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM 12   Permit Number 31680 5987243.89988 2110346.29905 37.7738718832899 -122.487593962509 (37.7738718832899, -122.487593962509) 11 6 2 55 26
161074 41928 DPW Maintained 1 Taxus baccata :: Irish Yew 86 524 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 9   Permit Number 42287 5994708.51972 2111929.51477 37.7786515066402 -122.461887634901 (37.7786515066402, -122.461887634901) 11 6 2 54 11
164736 136638 DPW Maintained 1 Taxus baccata :: Irish Yew 86 98 Blake St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5997852.8228 2113221.03458 37.7823781953411 -122.451103490434 (37.7823781953411, -122.451103490434) 15 6 1 54 31
169423 41927 DPW Maintained 1 Taxus baccata :: Irish Yew 86 524 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 6   Permit Number 42287 5994711.05634 2111911.6847 37.7786026960614 -122.46187756658 (37.7786026960614, -122.46187756658) 11 6 2 54 11
175109 120844 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 19th Ave 3 Sidewalk: Property side : Yard Tree Private 2     1 Width 2ft   5989915.94097 2113420.78105 37.7824690387717 -122.478575916411 (37.7824690387717, -122.478575916411) 11 6 2 55 26
191808 103623 DPW Maintained 1 Taxus baccata :: Irish Yew 86 333 El Camino Del Mar 1 Sidewalk: Property side : Cutout Landscaping Private 2   06/04/2013 12:00:00 AM   13x2 Permit Number 770205 5987603.5 2115303.5 37.7875039187234 -122.486714142272 (37.7875039187234, -122.486714142272) 11 6 1 55 33
193341 120231 DPW Maintained 1 Taxus baccata :: Irish Yew 86 154 25th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   5988063.88277 2114955.73403 37.7865758810738 -122.485095805195 (37.7865758810738, -122.485095805195) 11 6 1 55 33
4496 74361 DPW Maintained 1 Taxus baccata :: Irish Yew 86 299 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6005755.65434 2092345.08491 37.7255069657486 -122.422279456248 (37.7255069657486, -122.422279456248) 9 7 7 309 5
5600 241053 DPW Maintained 1 Taxus baccata :: Irish Yew 86 201 Coso Ave 3 Side Yard : Yard Tree Private 2     11 Width 5ft   6007672.87316 2099533.13544 37.7453517387841 -122.416160625529 (37.7453517387841, -122.416160625529) 2 7 7 28859 2
8931 215339 DPW Maintained 1 Taxus baccata :: Irish Yew 86 637 Detroit St 5 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5999420.83111 2095184.41503 37.7329437376643 -122.444382272244 (37.7329437376643, -122.444382272244) 9 7 4 59 40
9034 179812 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1349 Cayuga Ave 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 0ft   5999375.14619 2089880.54718 37.71837793826 -122.444159228684 (37.71837793826, -122.444159228684) 9 7 6 28861 25
12934 16022 DPW Maintained 1 Taxus baccata :: Irish Yew 86 123 Monterey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6001242.37794 2094603.69246 37.7314529692816 -122.438043142671 (37.7314529692816, -122.438043142671) 9 7 4 63 40
14728 62484 DPW Maintained 1 Taxus baccata :: Irish Yew 86 81 Delano Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/08/1986 12:00:00 AM 10   Permit Number 22655 6000565.24487 2092874.98588 37.7266678079605 -122.440260189157 (37.7266678079605, -122.440260189157) 9 7 6 28861 25
20054 179816 DPW Maintained 1 Taxus baccata :: Irish Yew 86 300 Ellington Ave 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 1ft   5998896.47943 2087985.98749 37.713148590116 -122.445677603554 (37.713148590116, -122.445677603554) 9 7 6 28861 25
20747 215303 DPW Maintained 1 Taxus baccata :: Irish Yew 86 681 Joost Ave 4 Sidewalk: Property side : Yard Tree Private 2     15     5997546.26853 2094964.87379 37.7322337966419 -122.450847264584 (37.7322337966419, -122.450847264584) 9 7 4 59 40
21045 179811 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1367 Cayuga Ave 3 Sidewalk: Curb side : Pot Tree Private 2     10 Width 0ft   5999338.15399 2089837.49101 37.7182576053899 -122.444284002399 (37.7182576053899, -122.444284002399) 9 7 6 28861 25
23212 179853 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   5998760.78346 2089904.78247 37.7184094145512 -122.446284557804 (37.7184094145512, -122.446284557804) 9 7 6 28861 25
24655 215338 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998226.11251 2096380.78786 37.7361604543418 -122.448598839867 (37.7361604543418, -122.448598839867) 9 7 4 59 40
27027 179833 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1468 Alemany Blvd 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6002155.36157 2093545.08036 37.7285981406774 -122.434811114144 (37.7285981406774, -122.434811114144) 9 7 6 28861 25
27598 179854 DPW Maintained 1 Taxus baccata :: Irish Yew 86 339 Mount Vernon Ave 1 Sidewalk: Property side : Yard Tree Private 2     11     5998465.19432 2089720.01475 37.7178851988142 -122.447292991002 (37.7178851988142, -122.447292991002) 9 7 6 28861 25
29990 215341 DPW Maintained 1 Taxus baccata :: Irish Yew 86 185 Hearst Ave 1 Sidewalk: Property side : Yard Tree Private 2     20 Width 3ft   6000114.95424 2094335.27384 37.7306517731413 -122.441921590428 (37.7306517731413, -122.441921590428) 9 7 4 63 40
33262 116307 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 7 Sidewalk: Property side : Yard Tree Private 2     5 3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
34915 215298 DPW Maintained 1 Taxus baccata :: Irish Yew 86 185 Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6000134.87473 2094332.54938 37.7306454275316 -122.441852526992 (37.7306454275316, -122.441852526992) 9 7 4 63 40
34996 31114 DPW Maintained 1 Taxus baccata :: Irish Yew 86 450 Edna St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 5   Permit Number 34839 5998792.19171 2094330.53052 37.7305632843566 -122.44649422303 (37.7305632843566, -122.44649422303) 9 7 4 28861 40
35059 116297 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 3 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
35581 179842 DPW Maintained 1 Taxus baccata :: Irish Yew 86 212 Silver Ave 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002649.41519 2093884.99893 37.7295595177473 -122.433127421409 (37.7295595177473, -122.433127421409) 9 7 6 28861 25
37032 215337 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Foerster St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998231.9169 2096387.51631 37.7361792609492 -122.448579256245 (37.7361792609492, -122.448579256245) 9 7 4 59 40
37296 179836 DPW Maintained 1 Taxus baccata :: Irish Yew 86 201 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 2ft   6002646.43295 2094204.87454 37.7304376544756 -122.433160577611 (37.7304376544756, -122.433160577611) 9 7 5 28861 25
38090 949 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1468 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/06/1990 12:00:00 AM 6 3X6   6002168.03285 2093561.19975 37.7286431202677 -122.434768461095 (37.7286431202677, -122.434768461095) 9 7 6 28861 25
40383 105515 DPW Maintained 1 Taxus baccata :: Irish Yew 86 701 Vienna St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6002668.24171 2089385.75875 37.7172066783264 -122.432741059164 (37.7172066783264, -122.432741059164) 9 7 6 28861 5
40385 215342 DPW Maintained 1 Taxus baccata :: Irish Yew 86 450 Circular Ave 7 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   5999549.56796 2093580.96212 37.7285483748934 -122.443822037778 (37.7285483748934, -122.443822037778) 9 7 4 63 40
42725 215295 DPW Maintained 1 Taxus baccata :: Irish Yew 86 25 Burnside Ave 5 Sidewalk: Property side : Yard Tree Private 2     14 Width 3ft   6001248.26665 2095899.59415 37.7350115506281 -122.43811558039 (37.7350115506281, -122.43811558039) 2 7 5 63 7
44377 116296 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 2 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
44578 179805 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1475 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5998972.41815 2089460.57977 37.7172018201812 -122.445521103537 (37.7172018201812, -122.445521103537) 9 7 6 28861 25
46050 215344 DPW Maintained 1 Taxus baccata :: Irish Yew 86 450 Circular Ave 6 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   5999563.31377 2093588.13313 37.7285688488645 -122.443775032896 (37.7285688488645, -122.443775032896) 9 7 4 63 40
46559 179844 DPW Maintained 1 Taxus baccata :: Irish Yew 86 19 Camellia Ave 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6003286.16791 2094080.48748 37.7301323849801 -122.430940049855 (37.7301323849801, -122.430940049855) 9 7 6 28861 25
46837 179803 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1481 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5998958.13876 2089448.31197 37.7171673203931 -122.445569578776 (37.7171673203931, -122.445569578776) 9 7 6 28861 25
47539 31120 DPW Maintained 1 Taxus baccata :: Irish Yew 86 450 Edna St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 9   Permit Number 34839 5998792.22814 2094324.02861 37.7305454337211 -122.446493629496 (37.7305454337211, -122.446493629496) 9 7 4 28861 40
48837 241065 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1801 Castro St 5 Sidewalk: Property side : Yard Tree Private 2     12     6002656.66446 2100292.18739 37.7471525907236 -122.433560071737 (37.7471525907236, -122.433560071737) 2 7 5 63 22
49026 179810 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1367 Cayuga Ave 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 0ft   5999324.75892 2089823.48937 37.7182183958423 -122.444329297662 (37.7182183958423, -122.444329297662) 9 7 6 28861 25
49209 179799 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 Foote Ave 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 4ft   5998244.59243 2088714.20474 37.7151108676608 -122.447983134341 (37.7151108676608, -122.447983134341) 9 7 6 28861 25
51255 215297 DPW Maintained 1 Taxus baccata :: Irish Yew 86 615 Hearst Ave 5 Sidewalk: Property side : Yard Tree Private 2     12 Width 5ft   5997404.12695 2094370.52949 37.7305937308948 -122.45129582845 (37.7305937308948, -122.45129582845) 9 7 4 28861 40
51532 179818 DPW Maintained 1 Taxus baccata :: Irish Yew 86 25 Dichiera Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5998665.00636 2087845.19043 37.7127487749191 -122.446467526652 (37.7127487749191, -122.446467526652) 9 7 6 28861 25
54331 215340 DPW Maintained 1 Taxus baccata :: Irish Yew 86 637 Detroit St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   5999417.92849 2095175.79644 37.7329199074284 -122.444391688153 (37.7329199074284, -122.444391688153) 9 7 4 59 40
54533 215301 DPW Maintained 1 Taxus baccata :: Irish Yew 86 123 Monterey Blvd 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6001252.93679 2094603.03258 37.7314517578791 -122.438006591549 (37.7314517578791, -122.438006591549) 9 7 4 63 40
55838 179815 DPW Maintained 1 Taxus baccata :: Irish Yew 86 300 Ellington Ave 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 1ft   5998907.25749 2087996.54696 37.713178199383 -122.445641109954 (37.713178199383, -122.445641109954) 9 7 6 28861 25
56720 116300 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 6 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
56948 179838 DPW Maintained 1 Taxus baccata :: Irish Yew 86 212 Silver Ave 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 2ft   6002614.6695 2093907.99697 37.7296206941164 -122.433249183323 (37.7296206941164, -122.433249183323) 9 7 6 28861 25
57951 179814 DPW Maintained 1 Taxus baccata :: Irish Yew 86 522 Sunnydale Ave 1 Sidewalk: Curb side : Pot Tree Private 2     8     6010066.66697 2086413.12079 37.7094612429124 -122.406958677794 (37.7094612429124, -122.406958677794) 9 7 8 309 39
59411 179908 DPW Maintained 1 Taxus baccata :: Irish Yew 86 316 Chicago Way 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6002616.49516 2086635.08435 37.7096509944651 -122.432723539456 (37.7096509944651, -122.432723539456) 9 7 6 28861 5
63554 241060 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6005928.78547 2095826.36488 37.7350755589952 -122.421928139697 (37.7350755589952, -122.421928139697) 2 7 7 28859 2
63804 179827 DPW Maintained 1 Taxus baccata :: Irish Yew 86 701 Vienna St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002666.48138 2089402.27505 37.7172519286027 -122.432748322975 (37.7172519286027, -122.432748322975) 9 7 6 28861 5
65143 241059 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6005916.72603 2095826.92897 37.7350764277358 -122.421969873622 (37.7350764277358, -122.421969873622) 2 7 7 28859 2
65645 179865 DPW Maintained 1 Taxus baccata :: Irish Yew 86 279 Moscow St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6004627.95191 2091486.48414 37.7230857614719 -122.426116731211 (37.7230857614719, -122.426116731211) 9 7 6 28861 5
67559 179809 DPW Maintained 1 Taxus baccata :: Irish Yew 86 114 Niagara Ave 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 0ft   5999497.59387 2089483.70241 37.7172952777295 -122.443707485722 (37.7172952777295, -122.443707485722) 9 7 6 28861 25
68300 241061 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   6005940.184 2095824.54912 37.7350712161596 -122.421888601897 (37.7350712161596, -122.421888601897) 2 7 7 28859 2
70182 179871 DPW Maintained 1 Taxus baccata :: Irish Yew 86 9 Athens St 6 Sidewalk: Property side : Yard Tree Private 2     11     6005395.25697 2093256.97645 37.7279904840704 -122.423590123686 (37.7279904840704, -122.423590123686) 9 7 6 28861 5
70723 179829 DPW Maintained 1 Taxus baccata :: Irish Yew 86 700 France Ave 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 2ft   6002680.04915 2089397.80932 37.7172404361776 -122.432701106797 (37.7172404361776, -122.432701106797) 9 7 6 28861 5
79283 179800 DPW Maintained 1 Taxus baccata :: Irish Yew 86 228 Rome St 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   5998609.28877 2088802.95321 37.7153753906268 -122.446728973961 (37.7153753906268, -122.446728973961) 9 7 6 28861 25
79418 179867 DPW Maintained 1 Taxus baccata :: Irish Yew 86 985 Avalon Ave 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   6005404.97601 2092232.73416 37.7251786880381 -122.423483738408 (37.7251786880381, -122.423483738408) 9 7 6 309 5
80235 179835 DPW Maintained 1 Taxus baccata :: Irish Yew 86 134 Cotter St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6001963.44434 2093526.42722 37.7285360253961 -122.435473248114 (37.7285360253961, -122.435473248114) 9 7 6 28861 25
87428 215300 DPW Maintained 1 Taxus baccata :: Irish Yew 86 185 Hearst Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 2ft   6000205.65358 2094331.35281 37.730646174877 -122.441607748599 (37.730646174877, -122.441607748599) 9 7 4 63 40
87437 179846 DPW Maintained 1 Taxus baccata :: Irish Yew 86 29 Colonial Way 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 3ft   6000367.54069 2093586.66565 37.7286106583386 -122.440994678056 (37.7286106583386, -122.440994678056) 9 7 6 28861 25
88824 179826 DPW Maintained 1 Taxus baccata :: Irish Yew 86 838 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6001050.56087 2088944.05849 37.7159019895732 -122.438300979212 (37.7159019895732, -122.438300979212) 9 7 6 28861 5

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