trees
665 rows where qSpecies_id = 89 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27231 | 118929 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 875 La Playa | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5980750.23602 | 2109645.2788 | 37.7715662158284 | -122.510004109936 | (37.7715662158284, -122.510004109936) | 11 | 6 | 2 | 55 | 26 | |||
| 27574 | 203500 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 77 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999471.94159 | 2093749.5809 | 37.729006934723 | -122.444102506626 | (37.729006934723, -122.444102506626) | 9 | 7 | 4 | 63 | 40 | |||
| 27673 | 34184 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2010 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
| 28238 | 31130 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.15586 | 37.7295250449277 | -122.448917737661 | (37.7295250449277, -122.448917737661) | 9 | 7 | 4 | 28861 | 40 |
| 28791 | 34191 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2701 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38079 | 5987120.3446635 | 2114449.05125045 | 37.7851296693951 | -122.488322923297 | (37.7851296693951, -122.488322923297) | 11 | 6 | 1 | 55 | 33 | ||
| 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 | |||
| 29617 | 50533 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2003 12:00:00 AM | Permit Number 47172 | 6014106.88689945 | 2104884.78697192 | 37.760405899811 | -122.394287314563 | (37.760405899811, -122.394287314563) | 10 | 3 | 8 | 28856 | 29 | |||
| 30160 | 34278 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 239 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1997 12:00:00 AM | Permit Number 38235 | 5987102.15938314 | 2114264.59763142 | 37.7846221515938 | -122.488372277385 | (37.7846221515938, -122.488372277385) | 11 | 6 | 1 | 55 | 33 | ||
| 30380 | 220601 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010687.7942 | 2100021.12984 | 37.7468607265348 | -122.405769837005 | (37.7468607265348, -122.405769837005) | 2 | 7 | 7 | 28859 | 2 | |||
| 30401 | 42094 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 45 Stoneman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | 2 | 7 | 7 | 28859 | 2 | ||
| 30576 | 220607 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007434.64615 | 2096337.15194 | 37.7365628793641 | -122.416758001093 | (37.7365628793641, -122.416758001093) | 2 | 7 | 7 | 28859 | 2 | |||
| 30986 | 7123 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 9 | 3x3 | 6005797.9204 | 2115035.94869 | 37.7878131752727 | -122.423746004087 | (37.7878131752727, -122.423746004087) | 13 | 9 | 1 | 28858 | 41 | ||
| 31145 | 220664 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003819.11819 | 2101351.99344 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | 2 | 4 | 5 | 28862 | 22 | |||
| 31167 | 220602 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6003653.16044 | 2099206.97915 | 37.7442293498199 | -122.430036867914 | (37.7442293498199, -122.430036867914) | 2 | 7 | 5 | 63 | 22 | |||
| 31263 | 30606 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 40 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.419697886953 | (37.773818193258, -122.419697886953) | 8 | 2 | 9 | 28853 | 19 | ||
| 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 | |||
| 32049 | 249535 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6006279.61488 | 2114039.53426 | 37.7851044469537 | -122.422008617322 | (37.7851044469537, -122.422008617322) | 13 | 9 | 11 | 28858 | 41 | |||
| 32554 | 99407 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2200X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | ||
| 33000 | 220606 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007224.12082 | 2095985.37984 | 37.7355851472373 | -122.41746095617 | (37.7355851472373, -122.41746095617) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 33164 | 96256 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 192@ Congdon Ney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2011 12:00:00 AM | 3x3 | Permit Number 58762 | 6004645 | 2094034 | 37.7300816406458 | -122.42623908205 | (37.7300816406458, -122.42623908205) | 9 | 7 | 6 | 28861 | 5 | ||
| 33499 | 246911 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Frederick St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 5997556.58518 | 2107424.48902 | 37.7664454174412 | -122.451710064262 | (37.7664454174412, -122.451710064262) | 15 | 5 | 11 | 29492 | 9 | |||
| 34102 | 31948 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1677 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | Permit Number 35359 | 6005487.56868066 | 2115128.64858681 | 37.7880501818667 | -122.424826361466 | (37.7880501818667, -122.424826361466) | 13 | 9 | 1 | 28858 | 41 | ||
| 34435 | 118571 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 7940 Geary Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 6 | 5982344.86422 | 2112440.78156 | 37.7793357732303 | -122.504695460976 | (37.7793357732303, -122.504695460976) | 11 | 6 | 2 | 55 | 26 | ||||
| 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 | |||
| 34602 | 97033 | Property Tree 8 | Afrocarpus gracilior :: Fern Pine 89 | 61 Vicksburg St | Back Yard : Yard | Tree | Private 2 | Possible significant tree; Nellie RoW; rear yard | 6004120 | 2102703 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | 2 | 4 | 5 | 28862 | 22 | |||||
| 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 | |||
| 34992 | 125491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6005994.09185 | 2120329.47146 | 37.8023589278732 | -122.423443758146 | (37.8023589278732, -122.423443758146) | 5 | 9 | 1 | 28858 | 32 | |||
| 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 | ||||
| 35568 | 51459 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | 2 | 7 | 7 | 28859 | 2 | ||
| 36154 | 64967 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1671 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004948.17442 | 2119151.63157 | 37.7990657940144 | -122.426979209822 | (37.7990657940144, -122.426979209822) | 13 | 9 | 1 | 57 | 17 | |
| 36532 | 175163 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.441826421457 | (37.7251102235329, -122.441826421457) | 9 | 7 | 6 | 28861 | 25 | |||
| 37305 | 189152 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1665 Hudson Ave | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6015368.44602 | 2097645.03721 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | 10 | 3 | 8 | 58 | 1 | |||
| 37507 | 17121 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1931 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997743.85041 | 2109170.01524 | 37.7712489089965 | -122.451188245827 | (37.7712489089965, -122.451188245827) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 38146 | 220652 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 324 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | 2 | 7 | 7 | 28859 | 2 | |||
| 38197 | 28058 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.03901 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | 13 | 9 | 1 | 28858 | 41 | ||
| 38269 | 175168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004674.59943 | 2093952.62434 | 37.7298598742113 | -122.426130962075 | (37.7298598742113, -122.426130962075) | 9 | 7 | 6 | 28861 | 5 | |||
| 38406 | 220594 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008571.39642 | 2107977.23283 | 37.7685877923289 | -122.413650808341 | (37.7685877923289, -122.413650808341) | 8 | 4 | 7 | 28853 | 19 | |||
| 40013 | 203466 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 480 Hearst Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 5998189.16786 | 2094420.93356 | 37.7307770478103 | -122.448585465162 | (37.7307770478103, -122.448585465162) | 9 | 7 | 4 | 59 | 40 | |||
| 40160 | 125440 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3517 Divisadero St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6000220.82214 | 2120372.11662 | 37.8021484793247 | -122.443425105788 | (37.8021484793247, -122.443425105788) | 13 | 9 | 1 | 57 | 17 | |||
| 41103 | 175165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004671.92277 | 2094015.32561 | 37.730031886663 | -122.42614467765 | (37.730031886663, -122.42614467765) | 9 | 7 | 6 | 28861 | 5 | |||
| 41180 | 220663 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1190 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003819.29636 | 2101374.54384 | 37.7501903863949 | -122.42961696547 | (37.7501903863949, -122.42961696547) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 41972 | 248095 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 8 Brewster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6010444.10359 | 2099844.52048 | 37.746362164885 | -122.406600056945 | (37.746362164885, -122.406600056945) | 2 | 7 | 7 | 28859 | 2 | |||
| 42265 | 96059 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 101 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767687 | 6010479 | 2099916 | 37.7465603843487 | -122.406484424587 | (37.7465603843487, -122.406484424587) | 2 | 7 | 7 | 28859 | 2 | |
| 43086 | 203451 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | Width 8ft | 5991183.11857 | 2105012.94014 | 37.7594568739424 | -122.473578579008 | (37.7594568739424, -122.473578579008) | 1 | 8 | 4 | 56 | 12 | |||
| 43231 | 99401 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 12 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
| 43617 | 189198 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 450 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010926.82993 | 2112099.93954 | 37.7800397781655 | -122.405793955035 | (37.7800397781655, -122.405793955035) | 14 | 2 | 9 | 28853 | 34 | |||
| 43755 | 256846 | Undocumented 4 | Afrocarpus gracilior :: Fern Pine 89 | 1298x Post St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006137 | 2114500 | 37.7863607279306 | -122.422534752155 | (37.7863607279306, -122.422534752155) | 13 | 9 | 11 | 28858 | 41 | ||||
| 44125 | 120266 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 24th Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5988365.77159 | 2115120.59325 | 37.7870461179038 | -122.484063450514 | (37.7870461179038, -122.484063450514) | 11 | 6 | 1 | 55 | 33 | ||||
| 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 | ||
| 44580 | 16399 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 12 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
| 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 | |||
| 45527 | 189170 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 360 Texas St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6013732.7365 | 2105419.19303 | 37.7618524574395 | -122.395618779897 | (37.7618524574395, -122.395618779897) | 10 | 3 | 8 | 28856 | 29 | |||
| 45630 | 120025 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 743 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5987224.82866 | 2110876.63769 | 37.7753269317853 | -122.487698901899 | (37.7753269317853, -122.487698901899) | 11 | 6 | 2 | 55 | 26 | |||
| 45637 | 40782 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 140 Lunado Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1999 12:00:00 AM | Permit Number 41738 | 5991628.17520198 | 2092552.84395046 | 37.7252704029333 | -122.471131595058 | (37.7252704029333, -122.471131595058) | 9 | 8 | 4 | 59 | 40 | ||
| 45841 | 249532 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006202.66878 | 2114026.79682 | 37.7850651330954 | -122.422273921828 | (37.7850651330954, -122.422273921828) | 13 | 9 | 11 | 28858 | 41 | |||
| 46149 | 220646 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.414044944318 | (37.7346828016745, -122.414044944318) | 2 | 7 | 7 | 28859 | 2 | |||
| 46336 | 125437 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1921 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6000052.89269 | 2121248.37983 | 37.8045448847905 | -122.444069220022 | (37.8045448847905, -122.444069220022) | 13 | 9 | 1 | 57 | 17 | |||
| 46462 | 189178 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Anthony St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 5ft | 6012651.66778 | 2115316.04533 | 37.7889667644596 | -122.400052847677 | (37.7889667644596, -122.400052847677) | 12 | 2 | 9 | 28855 | 6 | |||
| 46905 | 175167 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | 9 | 7 | 6 | 28861 | 5 | |||
| 47611 | 189171 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 672 Missouri St | 2 | : | Tree | Private 2 | 4 | Width 1ft | 6013547.27138 | 2103937.27162 | 37.7577731065529 | -122.396156373043 | (37.7577731065529, -122.396156373043) | 10 | 3 | 8 | 28856 | 29 | |||
| 48346 | 203469 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998711.43854 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | 9 | 7 | 4 | 28861 | 40 | ||||
| 48353 | 175174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003793.29108 | 2091173.56486 | 37.7221793437874 | -122.428979687879 | (37.7221793437874, -122.428979687879) | 9 | 7 | 6 | 28861 | 5 | |||
| 48506 | 125464 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 887 Eddy St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6006280.54306 | 2113153.33425 | 37.7826712115607 | -122.4219424317 | (37.7826712115607, -122.4219424317) | 7 | 9 | 11 | 28852 | 41 | |||
| 49047 | 92416 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1507 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52808 | 5984617.9 | 2104898.8 | 37.758761083263 | -122.496275574595 | (37.758761083263, -122.496275574595) | 1 | 8 | 3 | 56 | 35 | |
| 49713 | 189182 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Bluxome St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013480.92655 | 2110921.93119 | 37.7769477380782 | -122.3968755078 | (37.7769477380782, -122.3968755078) | 6 | 2 | 9 | 28856 | 34 | |||
| 49839 | 175172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003774.22148 | 2091143.66189 | 37.7220961573958 | -122.42904347589 | (37.7220961573958, -122.42904347589) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 50975 | 189168 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 606 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011490.76938 | 2105489.27118 | 37.7619199120061 | -122.40337783013 | (37.7619199120061, -122.40337783013) | 10 | 3 | 8 | 28856 | 29 | |||
| 51090 | 220645 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008216.92283 | 2095637.52522 | 37.7346858251821 | -122.414003848906 | (37.7346858251821, -122.414003848906) | 2 | 7 | 7 | 28859 | 2 | |||
| 51119 | 220615 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3117 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009011.32623 | 2104478.69915 | 37.75900631631 | -122.411881867955 | (37.75900631631, -122.411881867955) | 2 | 4 | 7 | 28859 | 19 | |||
| 51367 | 65437 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 175 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/1989 12:00:00 AM | Permit Number 28311 | 6009164.55626174 | 2113209.72407625 | 37.7829882723647 | -122.411968925085 | (37.7829882723647, -122.411968925085) | 14 | 10 | 9 | 28852 | 36 | ||
| 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 | |||
| 51637 | 125493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1207 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6006021.47381 | 2120333.65457 | 37.8023719590496 | -122.423349300554 | (37.8023719590496, -122.423349300554) | 5 | 9 | 1 | 28858 | 32 | |||
| 51677 | 251747 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002959 | 2087321 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | 9 | 7 | 6 | 28861 | 5 | ||||
| 51778 | 102757 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6002051.95846 | 2117801.73169 | 37.7951951298959 | -122.436904386043 | (37.7951951298959, -122.436904386043) | 13 | 9 | 1 | 57 | 27 | |||
| 52978 | 220603 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 418 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003167.3476 | 2099231.48151 | 37.7442691016478 | -122.431718451765 | (37.7442691016478, -122.431718451765) | 2 | 7 | 5 | 63 | 22 | |||
| 53152 | 50074 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2654 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46807 | 5991461.18247601 | 2097355.08728319 | 37.7384464959625 | -122.472058735315 | (37.7384464959625, -122.472058735315) | 1 | 8 | 4 | 29491 | 40 | ||
| 53345 | 79776 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2331 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/2015 12:00:00 AM | 1 | Permit Number 774959 | 6011828.97856 | 2101840.08638 | 37.7519189391152 | -122.401951552136 | (37.7519189391152, -122.401951552136) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |||
| 54441 | 125460 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2416 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003175.77984 | 2117097.00502 | 37.7933239410913 | -122.432965418428 | (37.7933239410913, -122.432965418428) | 13 | 9 | 1 | 29490 | 27 | |||
| 54594 | 220611 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6009641.7814 | 2098664.71567 | 37.7430777589371 | -122.409291162184 | (37.7430777589371, -122.409291162184) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 55420 | 189193 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6012073.86009 | 2107513.44954 | 37.7675104026963 | -122.401503402873 | (37.7675104026963, -122.401503402873) | 14 | 3 | 8 | 28856 | 20 | |||
| 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 | |||
| 56067 | 203470 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5999333.68862 | 2093807.88656 | 37.72915914047 | -122.444584644873 | (37.72915914047, -122.444584644873) | 9 | 7 | 4 | 28861 | 40 | ||||
| 56489 | 220609 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 385 Nevada St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 2ft | 6008945.60793 | 2096515.87148 | 37.737138473362 | -122.411546563846 | (37.737138473362, -122.411546563846) | 10 | 7 | 7 | 28859 | 2 | |||
| 56555 | 220659 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 998 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009137.78882 | 2103468.55533 | 37.756239784054 | -122.411373136768 | (37.756239784054, -122.411373136768) | 2 | 4 | 7 | 28859 | 19 | |||
| 57639 | 189157 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.7810840205508 | -122.401309519845 | (37.7810840205508, -122.401309519845) | 6 | 2 | 9 | 28856 | 34 | |||
| 57858 | 189153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6012332.53447 | 2112551.48713 | 37.7813581348078 | -122.400962694499 | (37.7813581348078, -122.400962694499) | 6 | 2 | 9 | 28856 | 34 | |||
| 58064 | 189174 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 14 Waterville St | 1 | : | Tree | Private 2 | 10 | Width 1ft | 6011435.76202 | 2096086.73565 | 37.7360995216629 | -122.402906748143 | (37.7360995216629, -122.402906748143) | 10 | 3 | 8 | 58 | 1 | |||
| 58068 | 51467 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 450X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.413570470462 | (37.7370397099418, -122.413570470462) | 2 | 7 | 7 | 28859 | 2 | ||
| 58303 | 81183 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 461 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50918 | 6007526.59353608 | 2096789.07906061 | 37.7378089430444 | -122.416472100986 | (37.7378089430444, -122.416472100986) | 2 | 7 | 7 | 28859 | 2 | ||
| 58880 | 33006 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 255 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/2002 12:00:00 AM | Permit Number 45106 | 6012763.62735273 | 2113645.89457982 | 37.7843871619555 | -122.399548173715 | (37.7843871619555, -122.399548173715) | 6 | 2 | 9 | 28853 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );