trees

665 rows where qSpecies_id = 89 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)
2382 255210 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1 Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
9003 259743 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1300x Quesada Ave 1 Side Yard : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
14680 259744 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1300x Quesada Ave 2 Side Yard : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
14704 255211 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 7 Burrows St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF                            
15364 259745 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1300x Quesada Ave 3 Side Yard : Cutout Tree DPW 1 FUF 10/13/2018 12:00:00 AM 3                        
823 33293 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 166 Sproule Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM 10   Permit Number 37451 6009221.08576 2116982.79677 37.7933513902069 -122.412040085683 (37.7933513902069, -122.412040085683) 3 1 10 28857 21
1264 125499 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 10 Hastings Ter 1 Sidewalk: Property side : Yard Tree Private 2     2     6007355.47144 2119286.08851 37.7995708047014 -122.418658671469 (37.7995708047014, -122.418658671469) 5 1 1 28858 32
1616 249984 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 226 Filbert St 2 Front Yard : Yard Tree Private 2     10 Width 0ft   6011604.5053 2120111.99388 37.8020768465317 -122.404013554575 (37.8020768465317, -122.404013554575) 3 1 10 308 23
3711 125506 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 7 Fallon Pl 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   6008920.97468 2118571.47788 37.7976966751291 -122.413190886946 (37.7976966751291, -122.413190886946) 3 1 10 308 21
6257 125500 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 12 Hastings Ter 6 Sidewalk: Property side : Yard Tree Private 2     2     6007269.76384 2119273.06582 37.7995302219096 -122.418954327193 (37.7995302219096, -122.418954327193) 5 1 1 28858 32
10180 125521 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 33 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008568.41134 2119026.06198 37.7989250510158 -122.414443039112 (37.7989250510158, -122.414443039112) 5 1 10 308 32
16090 70151 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 846 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6007647.41454 2114440.4952 37.786282435643 -122.417304870747 (37.786282435643, -122.417304870747) 13 1 9 28858 36
21355 125539 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 31 Spofford St 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6010570.5264 2117382.56278 37.7945246709392 -122.407399099212 (37.7945246709392, -122.407399099212) 3 1 10 28857 4
23673 125501 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1115 Filbert St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 4ft   6007553.74728 2119514.62481 37.8002094690578 -122.417988773678 (37.8002094690578, -122.417988773678) 5 1 1 28858 32
24223 125520 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 32 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6008570.50339 2119026.46396 37.7989262722777 -122.414435828363 (37.7989262722777, -122.414435828363) 5 1 10 308 32
24271 125480 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 70 Pleasant St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6008592.70141 2116811.84206 37.7928467140568 -122.414202246537 (37.7928467140568, -122.414202246537) 5 1 10 28857 21
24487 125483 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1471 Washington St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6007681.40554 2117137.66068 37.7936901018702 -122.417378482047 (37.7936901018702, -122.417378482047) 5 1 10 28858 32
24813 125514 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 24 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008590.31929 2119027.39259 37.7989299352366 -122.414367324317 (37.7989299352366, -122.414367324317) 5 1 10 308 32
29202 125468 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1177 California St 4 Sidewalk: Curb side : Pot Tree Private 2     5 Width 4ft   6008726.14199 2116272.16952 37.7913723996763 -122.413702344902 (37.7913723996763, -122.413702344902) 5 1 10 28857 21
31391 125527 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 29 Miller Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010066.41664 2116970.44466 37.7933648665474 -122.409114296086 (37.7933648665474, -122.409114296086) 3 1 10 28857 4
31461 249983 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 226 Filbert St 1 Front Yard : Yard Tree Private 2     13 Width 0ft   6011603.53088 2120119.93244 37.8020985894405 -122.404017485543 (37.8020985894405, -122.404017485543) 3 1 10 308 23
33069 125528 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 29 Miller Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6010067.56823 2116961.57421 37.7933405749546 -122.409109685279 (37.7933405749546, -122.409109685279) 3 1 10 28857 4
34525 125530 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010077.84381 2116891.68093 37.7931492405824 -122.40906919691 (37.7931492405824, -122.40906919691) 3 1 10 28857 4
34762 249988 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 228 Filbert St 4 Front Yard : Yard Tree Private 2     3 Width 0ft   6011583.89861 2120104.21147 37.8020543265962 -122.404084315938 (37.8020543265962, -122.404084315938) 3 1 10 308 23
34872 125482 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1 Nob Hill Pl 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 1ft   6009469.59091 2116291.78471 37.7914679787239 -122.411131403485 (37.7914679787239, -122.411131403485) 5 1 10 28857 21
35518 125505 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 45 Havens St 1 Sidewalk: Property side : Yard Tree Private 2     11     6007613.99229 2119386.63886 37.7998614422209 -122.41777122496 (37.7998614422209, -122.41777122496) 5 1 1 28858 32
37925 125477 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 150 Sproule Ln 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009239.02025 2116870.71678 37.793044652131 -122.411970106748 (37.793044652131, -122.411970106748) 3 1 10 28857 21
41938 125534 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6010079.0906 2116883.16981 37.793125940953 -122.409064282098 (37.793125940953, -122.409064282098) 3 1 10 28857 4
44498 32128 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 45 Ross Aly 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35490 6010568.1937078 2117713.19841403 37.7954323857446 -122.407430491589 (37.7954323857446, -122.407430491589) 3 1 10 28857 4
44724 125536 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 8 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010079.47478 2116878.80155 37.7931139682908 -122.409062644439 (37.7931139682908, -122.409062644439) 3 1 10 28857 4
50122 125517 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 29 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008575.41519 2119026.37821 37.7989263127569 -122.414418825785 (37.7989263127569, -122.414418825785) 5 1 10 308 32
51514 125509 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 13 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   6008633.29576 2119030.27082 37.7989402522368 -122.414218814773 (37.7989402522368, -122.414218814773) 5 1 10 308 32
51653 125485 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1237x Robert C Levy Tunl 3 Median : Yard Tree DPW 1     10     6007640.9414 2118138.07584 37.796434716745 -122.417589429708 (37.796434716745, -122.417589429708) 5 1 10 28858 32
54016 249820 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1690 Kearny St 2 Front Yard : Yard Tree Private 2     13 Width 0ft   6010902.80513 2120614.31353 37.8034168633488 -122.406477200573 (37.8034168633488, -122.406477200573) 3 1 10 308 23
54339 249939 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 331 Filbert St 1 Front Yard : Yard Tree Private 2     7 Width 0ft   6011281.55151 2120038.154 37.8018560512652 -122.40512593233 (37.8018560512652, -122.40512593233) 3 1 10 308 23
55080 32135 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 858 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35495 6010580.68586277 2117592.53204935 37.7951017643418 -122.40737875552 (37.7951017643418, -122.40737875552) 3 1 10 28857 4
55157 125470 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 655 Powell St 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6010075.12389 2116032.87575 37.7907910167417 -122.409017984115 (37.7907910167417, -122.409017984115) 5 1 10 28857 21
55814 125511 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 15 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008625.76186 2119029.22421 37.7989369553212 -122.414244810558 (37.7989369553212, -122.414244810558) 5 1 10 308 32
62900 32709 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1005 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37107 6007675.42771265 2115829.29953352 37.7900973284958 -122.417306405748 (37.7900973284958, -122.417306405748) 13 1 10 28858 21
64447 125502 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1001 Lombard St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 7ft   6007468.42884 2120195.87716 37.8020752142594 -122.418332338987 (37.8020752142594, -122.418332338987) 5 1 1 28858 32
64506 125523 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 220 Lombard St 7 Sidewalk: Property side : Yard Tree Private 2     6 Width 9ft   6011207.16585 2120734.52957 37.8037639692824 -122.405432414094 (37.8037639692824, -122.405432414094) 3 1 10 308 23
64779 125512 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 17 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6008620.72695 2119028.05639 37.7989334659598 -122.414262150401 (37.7989334659598, -122.414262150401) 5 1 10 308 32
64944 249989 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 228 Filbert St 5 Front Yard : Yard Tree Private 2     2 Width 0ft   6011581.89407 2120103.40396 37.8020519973709 -122.404091195777 (37.8020519973709, -122.404091195777) 3 1 10 308 23
67291 249985 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 228 Filbert St 1 Front Yard : Yard Tree Private 2     4 Width 0ft   6011591.62105 2120106.88257 37.802062092258 -122.404057780558 (37.802062092258, -122.404057780558) 3 1 10 308 23
68453 125538 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 10 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6010079.83492 2116873.25499 37.7930987589554 -122.409061006782 (37.7930987589554, -122.409061006782) 3 1 10 28857 4
68515 65417 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 887 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/27/1989 12:00:00 AM     Permit Number 28274 6009256.60978604 2115652.27846796 37.7897001035195 -122.411823108686 (37.7897001035195, -122.411823108686) 5 1 10 28857 21
70085 249947 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 305 Filbert St 2 Front Yard : Yard Tree Private 2     7 Width 0ft   6011342.9125 2120054.18632 37.8019035022036 -122.40491472295 (37.8019035022036, -122.40491472295) 3 1 10 308 23
71615 125510 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6008630.57528 2119029.65242 37.7989384014533 -122.414228184789 (37.7989384014533, -122.414228184789) 5 1 10 308 32
72741 125513 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 22 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6008593.29487 2119027.33171 37.798929935227 -122.414357023482 (37.798929935227, -122.414357023482) 5 1 10 308 32
77931 32708 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 1005 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37107 6007675.42771265 2115829.29953352 37.7900973284958 -122.417306405748 (37.7900973284958, -122.417306405748) 13 1 10 28858 21
77941 125515 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 25 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6008587.48018 2119026.85751 37.7989283065533 -122.414377110727 (37.7989283065533, -122.414377110727) 5 1 10 308 32
80015 125526 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 29 Miller Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010063.61505 2116985.54141 37.7934061616158 -122.409125055588 (37.7934061616158, -122.409125055588) 3 1 10 28857 4
80070 107943 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 44x MacOndray Ln 5 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6008438.53642 2119159.8208 37.7992850226339 -122.41490192268 (37.7992850226339, -122.41490192268) 5 1 10 308 32
80095 125508 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 7 Fallon Pl 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 6ft   6008930.42147 2118571.4914 37.7976972425915 -122.413158199313 (37.7976972425915, -122.413158199313) 3 1 10 308 21
84618 125504 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1001 Lombard St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 7ft   6007489.69173 2120199.07294 37.8020851859507 -122.418258985774 (37.8020851859507, -122.418258985774) 5 1 1 28858 32
87547 125475 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 150 Sproule Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009249.92549 2116801.26294 37.7928545606515 -122.411927463576 (37.7928545606515, -122.411927463576) 3 1 10 28857 21
88185 125529 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6010076.61244 2116904.10673 37.793183289838 -122.40907433472 (37.793183289838, -122.40907433472) 3 1 10 28857 4
88253 125522 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1087 Greenwich St 3 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6007750.4574 2119887.81691 37.8012452299295 -122.417334539369 (37.8012452299295, -122.417334539369) 5 1 1 308 32
88407 125488 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1322 Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007633.45937 2115824.47806 37.7900817286446 -122.417451271357 (37.7900817286446, -122.417451271357) 13 1 10 28858 21
90963 32134 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 842 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35494 6010631.11006318 2117599.53652258 37.7951238190257 -122.407204773258 (37.7951238190257, -122.407204773258) 3 1 10 28857 4
95831 125519 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 31 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6008571.89831 2119026.74658 37.7989271266439 -122.414431021472 (37.7989271266439, -122.414431021472) 5 1 10 308 32
97400 97940 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 491 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2           6010516 2120277 37.8024690368502 -122.407791962119 (37.8024690368502, -122.407791962119) 3 1 10 308 23
101180 125474 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 150 Sproule Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009252.35721 2116781.07333 37.792799261332 -122.411917622313 (37.792799261332, -122.411917622313) 3 1 10 28857 21
104422 125479 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1133 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6009244.74147 2117035.03683 37.7934961558667 -122.411961928316 (37.7934961558667, -122.411961928316) 3 1 10 28857 21
105236 249818 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1690 Kearny St 7 Front Yard : Yard Tree Private 2     24 Width 0ft   6010887.46579 2120660.30432 37.803542284602 -122.406533525994 (37.803542284602, -122.406533525994) 3 1 10 308 23
105628 33291 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 166 Sproule Ln 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM 9   Permit Number 37451 6009219.70147 2117007.84258 37.7934200822178 -122.412046646261 (37.7934200822178, -122.412046646261) 3 1 10 28857 21
106323 125469 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1177 California St 5 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6008779.73096 2116281.55689 37.7914011842588 -122.413517591782 (37.7914011842588, -122.413517591782) 5 1 10 28857 21
106507 249823 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1690 Kearny St 5 Front Yard : Yard Tree Private 2     14 Width 0ft   6010881.14413 2120640.5408 37.8034876651725 -122.406554008974 (37.8034876651725, -122.406554008974) 3 1 10 308 23
115378 125533 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010078.6629 2116885.41787 37.7931320896218 -122.409065920669 (37.7931320896218, -122.409065920669) 3 1 10 28857 4
115820 125476 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 150 Sproule Ln 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6009246.74599 2116823.51326 37.7929154762237 -122.41194003791 (37.7929154762237, -122.41194003791) 3 1 10 28857 21
116144 249990 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 228 Filbert St 6 Front Yard : Yard Tree Private 2     2 Width 0ft   6011580.18498 2120103.15607 37.802051221233 -122.404097092619 (37.802051221233, -122.404097092619) 3 1 10 308 23
121322 249948 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 305 Filbert St 3 Front Yard : Yard Tree Private 2     18 Width 0ft   6011338.9869 2120052.71472 37.8018992421182 -122.40492820377 (37.8018992421182, -122.40492820377) 3 1 10 308 23
121928 125490 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1322 Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6007597.86895 2115819.15526 37.7900651109764 -122.417574034214 (37.7900651109764, -122.417574034214) 13 1 10 28858 21
125066 249987 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 228 Filbert St 3 Front Yard : Yard Tree Private 2     3 Width 0ft   6011587.32256 2120104.99043 37.802056656736 -122.404072522227 (37.802056656736, -122.404072522227) 3 1 10 308 23
125349 113957 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1644 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM 1 3x3   6008801.14182 2118530.39041 37.7975771309301 -122.413602635263 (37.7975771309301, -122.413602635263) 3 1 10 308 21
125968 125466 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1177 California St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 4ft   6008683.65979 2116266.52541 37.7913545166392 -122.413848933479 (37.7913545166392, -122.413848933479) 5 1 10 28857 21
127021 249949 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 303 Filbert St 6 Side Yard : Yard Tree Private 2     14 Width 0ft   6011354.62644 2120055.4997 37.801907763195 -122.404874279527 (37.801907763195, -122.404874279527) 3 1 10 308 23
129704 32136 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 858 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35495 6010580.68586277 2117592.53204935 37.7951017643418 -122.40737875552 (37.7951017643418, -122.40737875552) 3 1 10 28857 4
131179 125473 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 655 Powell St 6 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6010077.67437 2116003.04391 37.7907092485717 -122.409007053757 (37.7907092485717, -122.409007053757) 5 1 10 28857 21
132125 125489 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1322 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007615.82669 2115821.73144 37.7900731949784 -122.417512084408 (37.7900731949784, -122.417512084408) 13 1 10 28858 21
133816 249986 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 228 Filbert St 2 Front Yard : Yard Tree Private 2     4 Width 0ft   6011589.33259 2120106.08083 37.802059763014 -122.404065643309 (37.802059763014, -122.404065643309) 3 1 10 308 23
133904 125537 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010079.43392 2116876.79887 37.7931084671277 -122.409062644443 (37.7931084671277, -122.409062644443) 3 1 10 28857 4
134207 33294 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 158 Sproule Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37451 6009246.88754349 2116916.88448981 37.7931718587847 -122.411946149383 (37.7931718587847, -122.411946149383) 3 1 10 28857 21
136839 125531 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6010078.15064 2116889.31743 37.7931427681724 -122.409067968409 (37.7931427681724, -122.409067968409) 3 1 10 28857 4
137492 125478 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 150 Sproule Ln 5 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009235.21214 2116893.1375 37.7931060003053 -122.411984868232 (37.7931060003053, -122.411984868232) 3 1 10 28857 21
141657 33290 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 166 Sproule Ln 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM 8   Permit Number 37451 6009219.4283 2116994.47406 37.7933833601996 -122.412046646255 (37.7933833601996, -122.412046646255) 3 1 10 28857 21
142171 33292 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 160 Sproule Ln 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37451 6009246.88754349 2116916.88448981 37.7931718587847 -122.411946149383 (37.7931718587847, -122.411946149383) 3 1 10 28857 21
142938 125484 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1237x Robert C Levy Tunl 1 Median : Yard Tree DPW 1     18     6007648.69076 2118115.73393 37.796373807471 -122.417561030927 (37.796373807471, -122.417561030927) 5 1 10 28858 32
144847 125525 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 220 Lombard St 9 Sidewalk: Property side : Yard Tree Private 2     8 Width 9ft   6011203.66326 2120729.63027 37.8037503211682 -122.405444189817 (37.8037503211682, -122.405444189817) 3 1 10 308 23
144868 97942 Undocumented 4 Afrocarpus gracilior :: Fern Pine 89 491 Greenwich St 4 Sidewalk: Curb side : Cutout Tree Private 2           6010516 2120277 37.8024690368502 -122.407791962119 (37.8024690368502, -122.407791962119) 3 1 10 308 23
146670 125518 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 30 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6008573.08581 2119026.43144 37.7989263280573 -122.414426890005 (37.7989263280573, -122.414426890005) 5 1 10 308 32
148426 125487 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1322 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007652.60673 2115828.99311 37.7900952031746 -122.417385342985 (37.7900952031746, -122.417385342985) 13 1 10 28858 21
150432 249991 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 228 Filbert St 7 Front Yard : Yard Tree Private 2     2 Width 0ft   6011578.47013 2120102.62532 37.8020496681084 -122.404102989475 (37.8020496681084, -122.404102989475) 3 1 10 308 23
153761 125481 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1 Nob Hill Pl 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   6009481.63749 2116293.53202 37.7914734519756 -122.411089845832 (37.7914734519756, -122.411089845832) 5 1 10 28857 21
154365 125535 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 11 Miller Pl 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6010079.40223 2116881.04203 37.7931201160419 -122.409063053629 (37.7931201160419, -122.409063053629) 3 1 10 28857 4
157337 125471 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 655 Powell St 4 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6010076.95545 2116019.41648 37.7907541634305 -122.409010696908 (37.7907541634305, -122.409010696908) 5 1 10 28857 21
159811 125516 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 900 Green St 26 Sidewalk: Property side : Yard Tree Private 2     1 Width 5ft   6008584.50737 2119027.0667 37.7989287139392 -122.414387412476 (37.7989287139392, -122.414387412476) 5 1 10 308 32
161804 249822 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1690 Kearny St 4 Front Yard : Yard Tree Private 2     10 Width 0ft   6010893.58143 2120633.65684 37.8034694593133 -122.406510483572 (37.8034694593133, -122.406510483572) 3 1 10 308 23
169681 125486 DPW Maintained 1 Afrocarpus gracilior :: Fern Pine 89 1237x Robert C Levy Tunl 4 Median : Yard Tree DPW 1     6     6007645.27033 2118136.8198 37.7964315115565 -122.417574361577 (37.7964315115565, -122.417574361577) 5 1 10 28858 32
174368 32129 Permitted Site 7 Afrocarpus gracilior :: Fern Pine 89 35 Spofford Ln 1 Sidewalk: Curb side : Pot Tree Private 2 FUF 08/15/1995 12:00:00 AM     Permit Number 35491 6010554.96159279 2117351.45133924 37.7944383752725 -122.407450761229 (37.7944383752725, -122.407450761229) 3 1 10 28857 4

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