trees
665 rows where qSpecies_id = 89 sorted by DBH descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4217 | 220655 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008083.69599 | 2096082.25636 | 37.7358994764657 | -122.414495920166 | (37.7358994764657, -122.414495920166) | 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 | ||
| 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 | |||
| 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 | |||
| 73766 | 189195 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6012037.52857 | 2107512.72185 | 37.7675063773463 | -122.401629018386 | (37.7675063773463, -122.401629018386) | 14 | 3 | 8 | 28856 | 20 | |||
| 94900 | 34852 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 481 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1997 12:00:00 AM | 9 | Permit Number 38475 | 6014107.65557 | 2104887.53933 | 37.760413499915 | -122.394284848775 | (37.760413499915, -122.394284848775) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 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 | |
| 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 | |||
| 153760 | 203450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1515 16th Ave | 3 | Side Yard : Yard | Tree | Private 2 | 9 | Width 8ft | 5991181.21192 | 2105021.0246 | 37.7594789613077 | -122.4735857628 | (37.7594789613077, -122.4735857628) | 1 | 8 | 4 | 56 | 12 | |||
| 182215 | 249950 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 303 Filbert St | 5 | Side Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.8019120241928 | -122.404858102512 | (37.8019120241928, -122.404858102512) | 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 | |||
| 8425 | 175169 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 728 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009133.75655 | 2092888.51191 | 37.7271890729929 | -122.41063996266 | (37.7271890729929, -122.41063996266) | 9 | 3 | 7 | 309 | 28 | |||
| 11971 | 220654 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008103.73158 | 2096079.3451 | 37.735892608341 | -122.414426443037 | (37.735892608341, -122.414426443037) | 2 | 7 | 7 | 28859 | 2 | |||
| 14396 | 220653 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 390X Ogden Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008119.35429 | 2096079.02548 | 37.7358926083592 | -122.41437240636 | (37.7358926083592, -122.41437240636) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 79287 | 189192 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012099.20346 | 2107516.84427 | 37.7675211379264 | -122.401415981588 | (37.7675211379264, -122.401415981588) | 14 | 3 | 8 | 28856 | 20 | |||
| 81158 | 203493 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 227 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5999314.08769 | 2095746.28692 | 37.7344804146435 | -122.444791684116 | (37.7344804146435, -122.444791684116) | 9 | 7 | 4 | 59 | 40 | |||
| 90579 | 125457 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.7951716162211 | -122.436898435221 | (37.7951716162211, -122.436898435221) | 13 | 9 | 1 | 57 | 27 | |||
| 90775 | 249549 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6005525.06192 | 2114997.09858 | 37.7876910959164 | -122.424687279516 | (37.7876910959164, -122.424687279516) | 13 | 9 | 1 | 28858 | 41 | |||
| 95335 | 203497 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 585 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997548.43133 | 2095250.42463 | 37.7330179748995 | -122.450860369523 | (37.7330179748995, -122.450860369523) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 130229 | 203475 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991280.39863 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | 1 | 8 | 4 | 29491 | 40 | |||
| 138069 | 250078 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 399 Austin St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6005435.52045 | 2115308.45101 | 37.7885409345647 | -122.425019237271 | (37.7885409345647, -122.425019237271) | 13 | 9 | 1 | 28858 | 41 | |||
| 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 | |
| 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 | |||
| 148572 | 220620 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 747 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6001698.74806 | 2099680.01267 | 37.745417306567 | -122.43682864783 | (37.745417306567, -122.43682864783) | 2 | 7 | 5 | 63 | 22 | |||
| 165994 | 221762 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001705.95618 | 2104074.38405 | 37.7574836102927 | -122.437118289774 | (37.7574836102927, -122.437118289774) | 2 | 4 | 5 | 28862 | 3 | |||
| 170126 | 220628 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 907 Elizabeth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000553.10276 | 2101957.71166 | 37.751606143208 | -122.440953463952 | (37.751606143208, -122.440953463952) | 2 | 4 | 5 | 28862 | 22 | |||
| 188953 | 220660 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003703.33838 | 2095523.526 | 37.7341182720406 | -122.429600714704 | (37.7341182720406, -122.429600714704) | 2 | 7 | 5 | 28861 | 25 | |||
| 189345 | 125524 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 220 Lombard St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6011207.68462 | 2120726.93894 | 37.8037431562814 | -122.405430083952 | (37.8037431562814, -122.405430083952) | 3 | 1 | 10 | 308 | 23 | |||
| 191914 | 125472 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 655 Powell St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6010077.81978 | 2116010.1713 | 37.7907288268122 | -122.409007053754 | (37.7907288268122, -122.409007053754) | 5 | 1 | 10 | 28857 | 21 | |||
| 194134 | 125498 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1154 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6006270.07079 | 2120429.11585 | 37.8026480985929 | -122.422495818752 | (37.8026480985929, -122.422495818752) | 5 | 9 | 1 | 28858 | 32 | |||
| 15512 | 203483 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 459 Colon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5995499.06215 | 2095368.93495 | 37.7332258441801 | -122.457954104018 | (37.7332258441801, -122.457954104018) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 20384 | 189165 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1000 Pennsylvania Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6014460.44489 | 2102480.94268 | 37.753825107047 | -122.392896328823 | (37.753825107047, -122.392896328823) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 62927 | 221751 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 4000 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003801.92979 | 2101310.951 | 37.7500147919711 | -122.429672485102 | (37.7500147919711, -122.429672485102) | 2 | 4 | 5 | 28862 | 22 | |||
| 67061 | 220629 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 907 Elizabeth St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6000561.39368 | 2101957.84527 | 37.7516069822761 | -122.440924802556 | (37.7516069822761, -122.440924802556) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 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 | |||
| 93816 | 189197 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 453 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014136.4691 | 2112772.98188 | 37.7820667700107 | -122.394737429894 | (37.7820667700107, -122.394737429894) | 6 | 2 | 9 | 28856 | 6 | |||
| 96919 | 249550 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 2 | : | Tree | Private 2 | 7 | Width 2ft | 6005507.22761 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | 13 | 9 | 1 | 28858 | 41 | |||
| 102290 | 221763 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3816 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002948.35464 | 2103602.92928 | 37.7562596509731 | -122.432787903054 | (37.7562596509731, -122.432787903054) | 2 | 4 | 5 | 28862 | 3 | |||
| 103501 | 99402 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2201X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768917 | 6014766.6 | 2092880.6 | 37.7274815503989 | -122.391166558925 | (37.7274815503989, -122.391166558925) | 10 | 3 | 8 | 58 | 1 | |
| 108852 | 189154 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 100 Shipley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6012314.00092 | 2112536.43535 | 37.7813157722581 | -122.401025754031 | (37.7813157722581, -122.401025754031) | 6 | 2 | 9 | 28856 | 34 | |||
| 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 | |||
| 124968 | 221767 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 287 Hermann St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003902.82897 | 2108654.79623 | 37.770184952298 | -122.429847331292 | (37.770184952298, -122.429847331292) | 7 | 9 | 5 | 29492 | 10 | |||
| 129489 | 203476 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.7439792231731 | -122.472790471621 | (37.7439792231731, -122.472790471621) | 1 | 8 | 4 | 29491 | 40 | |||
| 132440 | 125450 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 44 Normandie Ter | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000949.24806 | 2117425.20451 | 37.7940985496517 | -122.44069290605 | (37.7940985496517, -122.44069290605) | 13 | 9 | 1 | 57 | 27 | |||
| 133628 | 52182 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 626 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | 7 | Permit Number 48372 | 6009510.44618 | 2111352.38647 | 37.7779078632967 | -122.410641078729 | (37.7779078632967, -122.410641078729) | 8 | 2 | 9 | 28853 | 34 | |
| 136754 | 220618 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 237 Murray St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6005720.29652 | 2095375.55283 | 37.7338259689755 | -122.422616936749 | (37.7338259689755, -122.422616936749) | 2 | 7 | 7 | 28861 | 2 | |||
| 141457 | 33132 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2927 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1996 12:00:00 AM | 7 | 4x5 | Permit Number 37362 | 6001472.71004 | 2118540.58919 | 37.7971908999849 | -122.438961648188 | (37.7971908999849, -122.438961648188) | 13 | 9 | 1 | 57 | 17 |
| 149326 | 189194 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 30 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012053.23647 | 2107512.8913 | 37.7675077191257 | -122.40157469843 | (37.7675077191257, -122.40157469843) | 14 | 3 | 8 | 28856 | 20 | |||
| 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 | |||
| 160224 | 203492 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 23 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5999946.35958 | 2095464.23555 | 37.7337420298607 | -122.442585473564 | (37.7337420298607, -122.442585473564) | 9 | 7 | 4 | 63 | 40 | |||
| 164597 | 203471 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | 9 | 8 | 4 | 28861 | 24 | |||
| 170059 | 125445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003103.29494 | 2120784.42 | 37.8034445139256 | -122.433479854917 | (37.8034445139256, -122.433479854917) | 13 | 9 | 1 | 57 | 17 | |||
| 170340 | 125439 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 99 Collins St | 0 | Side Yard : Yard | Tree | Private 2 | 7 | 5998117.25486 | 2114050.06951 | 37.7846696436241 | -122.450248453727 | (37.7846696436241, -122.450248453727) | 15 | 6 | 1 | 54 | 31 | ||||
| 178524 | 249534 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6006252.35701 | 2114034.72493 | 37.7850897043627 | -122.422102579373 | (37.7850897043627, -122.422102579373) | 13 | 9 | 11 | 28858 | 41 | |||
| 178906 | 249551 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 380 Fern St | 3 | : | Tree | Private 2 | 7 | Width 2ft | 6005490.31575 | 2114993.82461 | 37.7876801439695 | -122.424807261672 | (37.7876801439695, -122.424807261672) | 13 | 9 | 1 | 28858 | 41 | |||
| 192892 | 220637 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003700.73164 | 2096802.65879 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | 2 | 7 | 5 | 63 | 7 | |||
| 192901 | 203478 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.7423403049648 | -122.469178135975 | (37.7423403049648, -122.469178135975) | 1 | 8 | 4 | 29491 | 40 | |||
| 12247 | 16942 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 599X Oak St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
| 20069 | 249536 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 201 Myrtle St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6006331.73852 | 2114045.88325 | 37.7851248193023 | -122.421828736708 | (37.7851248193023, -122.421828736708) | 13 | 9 | 11 | 28858 | 41 | |||
| 20279 | 7125 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.17658 | 2115026.96294 | 37.7877851299198 | -122.423952067531 | (37.7877851299198, -122.423952067531) | 13 | 9 | 1 | 28858 | 41 | ||
| 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 | |||
| 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 | ||||
| 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 | |||
| 45904 | 27672 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 48705 | 27670 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 61917 | 27665 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
| 62733 | 27668 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 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 | |||
| 66789 | 16404 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
| 69039 | 16401 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 299X Myrtle St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006028.76056 | 2113989.39072 | 37.7849526140265 | -122.422872930887 | (37.7849526140265, -122.422872930887) | 13 | 9 | 11 | 28858 | 41 | ||
| 74610 | 125446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 3615 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003103.60158 | 2120772.63456 | 37.8034121715947 | -122.433477951057 | (37.8034121715947, -122.433477951057) | 13 | 9 | 1 | 57 | 17 | |||
| 76087 | 203454 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993011.06637 | 2099068.79194 | 37.7432414634178 | -122.466824576891 | (37.7432414634178, -122.466824576891) | 1 | 8 | 4 | 59 | 40 | |||
| 77242 | 27669 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 310 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005758.15165 | 2115391.49838 | 37.7887871812497 | -122.423908889223 | (37.7887871812497, -122.423908889223) | 13 | 9 | 1 | 28858 | 41 | |||
| 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 | |||
| 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 | |||
| 87861 | 27666 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 300 Austin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005803.78776 | 2115397.87528 | 37.7888072668978 | -122.423751448163 | (37.7888072668978, -122.423751448163) | 13 | 9 | 1 | 28858 | 41 | |||
| 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 | |||
| 94418 | 249544 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 298 Myrtle St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6006142.87898 | 2114042.34322 | 37.7851044469485 | -122.422481881052 | (37.7851044469485, -122.422481881052) | 13 | 9 | 11 | 28858 | 41 | |||
| 99030 | 125463 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 935 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6006804.24109 | 2113922.09635 | 37.7848115656375 | -122.420185233786 | (37.7848115656375, -122.420185233786) | 7 | 9 | 9 | 28858 | 36 | |||
| 100277 | 220612 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 9 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009640.52107 | 2098655.41337 | 37.7430521462403 | -122.409294863773 | (37.7430521462403, -122.409294863773) | 10 | 7 | 7 | 28859 | 2 | |||
| 103751 | 175153 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 783 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6001323.55262 | 2092431.04941 | 37.7254920046417 | -122.437606970601 | (37.7254920046417, -122.437606970601) | 9 | 7 | 6 | 28861 | 25 | |||
| 105504 | 18245 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1815X Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003482.1216 | 2114150.20266 | 37.7852501414757 | -122.431694966286 | (37.7852501414757, -122.431694966286) | 13 | 9 | 11 | 29490 | 13 |
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) );