trees
665 rows where qSpecies_id = 89 sorted by Location
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 59057 | 42581 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 175 San Rafael Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42660 | 5991893.22788807 | 2095086.42724375 | 37.7322423193031 | -122.470399771775 | (37.7322423193031, -122.470399771775) | 9 | 8 | 4 | 59 | 40 | ||
| 142702 | 203494 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 363 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999675.09138 | 2094930.6164 | 37.732261369848 | -122.443485006944 | (37.732261369848, -122.443485006944) | 9 | 7 | 4 | 63 | 40 | |||
| 77046 | 203495 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 363 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999677.59639 | 2094931.24105 | 37.7322632278502 | -122.443476391437 | (37.7322632278502, -122.443476391437) | 9 | 7 | 4 | 63 | 40 | |||
| 111073 | 51699 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 270 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2005 12:00:00 AM | 4 | Permit Number 47975 | 6009229.91351 | 2094736.03223 | 37.7322673611424 | -122.410437947053 | (37.7322673611424, -122.410437947053) | 10 | 3 | 7 | 309 | 28 | ||
| 182885 | 203490 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 29 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001874.24208 | 2094906.20617 | 37.7323195164307 | -122.435880309143 | (37.7323195164307, -122.435880309143) | 9 | 7 | 4 | 63 | 40 | |||
| 88481 | 203496 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 531 Foerster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998101.39373 | 2095150.67529 | 37.7327757263052 | -122.448941459085 | (37.7327757263052, -122.448941459085) | 9 | 7 | 4 | 59 | 40 | |||
| 87846 | 50391 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 295 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/2003 12:00:00 AM | Permit Number 47042 | 5996257.45116044 | 2095209.02576685 | 37.7328303156217 | -122.455320609685 | (37.7328303156217, -122.455320609685) | 9 | 7 | 4 | 59 | 40 | ||
| 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 | |||
| 78343 | 101466 | Significant Tree 6 | Afrocarpus gracilior :: Fern Pine 89 | 301 Hazelwood Ave | 1 | Front Yard : Yard | Tree | Private 2 | 5996219.7 | 2095283.8 | 37.7330334614805 | -122.455456526637 | (37.7330334614805, -122.455456526637) | 9 | 7 | 4 | 59 | 40 | |||||
| 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 | |||
| 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 | |||
| 179888 | 203491 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 27 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999912.45047 | 2095466.00696 | 37.7337449607507 | -122.442702834189 | (37.7337449607507, -122.442702834189) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | |||
| 88984 | 220641 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 859 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007571.59037 | 2095340.96834 | 37.7338352787826 | -122.416213992189 | (37.7338352787826, -122.416213992189) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 69444 | 220605 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6006588.43416 | 2095556.27849 | 37.7343711416034 | -122.419628336682 | (37.7343711416034, -122.419628336682) | 2 | 7 | 7 | 28859 | 2 | |||
| 164146 | 220640 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 821 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6007587.82088 | 2095563.9191 | 37.7344483655074 | -122.416173662982 | (37.7344483655074, -122.416173662982) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 60903 | 220636 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002799.74223 | 2095713.64114 | 37.734589079726 | -122.432738303627 | (37.734589079726, -122.432738303627) | 2 | 7 | 5 | 63 | 7 | |||
| 179956 | 220635 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002826.10631 | 2095715.40994 | 37.7345954316319 | -122.432647280541 | (37.7345954316319, -122.432647280541) | 2 | 7 | 5 | 63 | 7 | |||
| 180034 | 220634 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 628 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002844.7092 | 2095716.31094 | 37.7345989605548 | -122.432583028494 | (37.7345989605548, -122.432583028494) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 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 | ||
| 180503 | 51460 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 816 Crescent Ave | 2 | 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 | ||
| 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 | |||
| 133463 | 203485 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998424.41404 | 2096025.6755 | 37.7351967372311 | -122.447887674883 | (37.7351967372311, -122.447887674883) | 9 | 7 | 4 | 59 | 40 | |||
| 20586 | 45268 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 656 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2001 12:00:00 AM | Permit Number 44114 | 6008478.34688269 | 2095821.77218586 | 37.7352064067106 | -122.413113037779 | (37.7352064067106, -122.413113037779) | 10 | 7 | 7 | 28859 | 2 | ||
| 89424 | 203484 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | 9 | 7 | 4 | 59 | 40 | |||
| 193860 | 32513 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 777 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 12 | Permit Number 37015 | 6007618.09597 | 2095855.62959 | 37.7352510410088 | -122.416089643829 | (37.7352510410088, -122.416089643829) | 2 | 7 | 7 | 28859 | 2 | |
| 179693 | 203486 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998423.08817 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | 9 | 7 | 4 | 59 | 40 | |||
| 165467 | 203489 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 296 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996836.54011 | 2096166.78672 | 37.7354933057555 | -122.453387687511 | (37.7354933057555, -122.453387687511) | 9 | 7 | 4 | 59 | 40 | |||
| 77540 | 203488 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 296 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996843.32855 | 2096168.51259 | 37.7354984336897 | -122.453364342002 | (37.7354984336897, -122.453364342002) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 79988 | 201923 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 125 Elmira St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.7358650396404 | -122.403662651736 | (37.7358650396404, -122.403662651736) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 128631 | 45289 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 600 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2001 12:00:00 AM | Permit Number 44129 | 6008139.59757362 | 2096081.06824752 | 37.7358993545079 | -122.414302561575 | (37.7358993545079, -122.414302561575) | 2 | 7 | 7 | 28859 | 2 | |||
| 164516 | 45290 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 600 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2001 12:00:00 AM | Permit Number 44129 | 6008139.59757362 | 2096081.06824752 | 37.7358993545079 | -122.414302561575 | (37.7358993545079, -122.414302561575) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 162596 | 189172 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1947 Quesada Ave | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6013391.6303 | 2095988.75639 | 37.7359395106896 | -122.396137605077 | (37.7359395106896, -122.396137605077) | 10 | 3 | 8 | 58 | 1 | |||
| 6336 | 261055 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1948 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780729 | 6013389.35902 | 2096036.97619 | 37.7360717858924 | -122.396148836191 | (37.7360717858924, -122.396148836191) | 10 | 3 | 8 | 58 | 1 |
| 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 | |||
| 8824 | 261056 | Private 9 | Afrocarpus gracilior :: Fern Pine 89 | 1952 Quesada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | DPW | 11/20/2019 12:00:00 AM | 3 | 3x3 | Permit Number 780727 | 6013369.93114 | 2096051.4395 | 37.7361104181421 | -122.396217020065 | (37.7361104181421, -122.396217020065) | 10 | 3 | 8 | 58 | 1 |
| 72478 | 189173 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1960 Quesada Ave | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.7361619750843 | -122.396301660307 | (37.7361619750843, -122.396301660307) | 10 | 3 | 8 | 58 | 1 | |||
| 141532 | 220642 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008547.44423 | 2096175.62445 | 37.7361818869891 | -122.412899152301 | (37.7361818869891, -122.412899152301) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 14764 | 203487 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 828 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998282.18197 | 2096469.86688 | 37.736408249925 | -122.448411398672 | (37.736408249925, -122.448411398672) | 9 | 7 | 4 | 59 | 40 | |||
| 71039 | 220661 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Leese St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005456.84136 | 2096363.09768 | 37.7365226796806 | -122.423597969391 | (37.7365226796806, -122.423597969391) | 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 | |||
| 171957 | 220662 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 40 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005443.37587 | 2096387.81015 | 37.7365897745051 | -122.423646281876 | (37.7365897745051, -122.423646281876) | 2 | 7 | 7 | 28859 | 2 | |||
| 178418 | 221769 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | 2 | 7 | 5 | 63 | 7 | |||
| 160075 | 221770 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001816.47531 | 2096513.16567 | 37.7367285749736 | -122.436194979235 | (37.7367285749736, -122.436194979235) | 2 | 7 | 5 | 63 | 7 | |||
| 26386 | 221771 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | 2 | 7 | 5 | 63 | 7 | |||
| 115360 | 66399 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/1991 12:00:00 AM | 11 | 4.5x12 | Permit Number 29525 | 6007445.41695715 | 2096473.5258201 | 37.7369379378565 | -122.41673042001 | (37.7369379378565, -122.41673042001) | 2 | 7 | 7 | 28859 | 2 | |
| 14699 | 220657 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 498X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008343.07833 | 2096482.99595 | 37.737014388513 | -122.413627464658 | (37.737014388513, -122.413627464658) | 2 | 7 | 7 | 28859 | 2 | |||
| 2997 | 220656 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 498X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008322.74158 | 2096484.80156 | 37.737018204322 | -122.41369790583 | (37.737018204322, -122.41369790583) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 72406 | 51468 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 450X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/2004 12:00:00 AM | 10 | 3x3 | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.413570470462 | (37.7370397099418, -122.413570470462) | 2 | 7 | 7 | 28859 | 2 |
| 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 | |||
| 67909 | 220608 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 385 Nevada St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 2ft | 6008946.36134 | 2096525.74548 | 37.7371656274845 | -122.411544656368 | (37.7371656274845, -122.411544656368) | 10 | 7 | 7 | 28859 | 2 | |||
| 177681 | 92445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.7372098007713 | -122.503066669454 | (37.7372098007713, -122.503066669454) | 1 | 8 | 3 | 29491 | 35 |
| 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 | |||
| 186795 | 69515 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 443 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1997 12:00:00 AM | Permit Number 33643 | 6008794.13528985 | 2096723.61704292 | 37.7377003998713 | -122.412084952925 | (37.7377003998713, -122.412084952925) | 10 | 7 | 7 | 28859 | 2 | ||
| 194147 | 221775 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 21 Addison St | 14 | Back Yard : Yard | Tree | Private 2 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | ||
| 68653 | 50078 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2663 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46810 | 5991411.04399471 | 2097301.04699111 | 37.7382952135341 | -122.472228150036 | (37.7382952135341, -122.472228150036) | 1 | 8 | 4 | 29491 | 40 | ||
| 142886 | 203474 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | 1 | 8 | 4 | 29491 | 40 | |||
| 126408 | 203453 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.7383404469611 | -122.47206749851 | (37.7383404469611, -122.47206749851) | 1 | 8 | 4 | 29491 | 40 | |||
| 74822 | 27714 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001610.45471 | 2097108.73364 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | 2 | 7 | 5 | 63 | 7 | |||
| 116961 | 50076 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2659 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46808 | 5991410.12918009 | 2097327.15671334 | 37.7383668512451 | -122.472233215714 | (37.7383668512451, -122.472233215714) | 1 | 8 | 4 | 29491 | 40 | ||
| 86050 | 221773 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | 2 | 7 | 5 | 63 | 7 | |||
| 131367 | 221774 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | ||
| 155035 | 220610 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 243 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6009545.72231 | 2097174.03837 | 37.7389793010447 | -122.40951812496 | (37.7389793010447, -122.40951812496) | 10 | 7 | 7 | 28859 | 2 | |||
| 135354 | 221772 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 71 Miguel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003850.95701 | 2097297.26656 | 37.7389969178725 | -122.429216785123 | (37.7389969178725, -122.429216785123) | 2 | 7 | 5 | 63 | 7 | |||
| 5122 | 50073 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.7390195978985 | -122.472099259809 | (37.7390195978985, -122.472099259809) | 1 | 8 | 4 | 29491 | 40 | ||
| 111284 | 189200 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 625 Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.386079860717 | (37.7392011179238, -122.386079860717) | 10 | 3 | 8 | 58 | 1 | |||
| 159467 | 86884 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 2534 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49809 | 5982151.4 | 2097835.7 | 37.7392229927812 | -122.504282496051 | (37.7392229927812, -122.504282496051) | 1 | 8 | 3 | 29491 | 35 | |||
| 182788 | 220644 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6009354.03531 | 2097334.25884 | 37.7394084890188 | -122.410192201918 | (37.7394084890188, -122.410192201918) | 10 | 7 | 7 | 28859 | 2 | |||
| 78118 | 66176 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29249 | 6009344.53220754 | 2097370.35407631 | 37.7395070660178 | -122.410227607366 | (37.7395070660178, -122.410227607366) | 10 | 7 | 7 | 28859 | 2 | ||
| 136067 | 220643 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009355.21688 | 2097375.10372 | 37.7395207064184 | -122.410190999519 | (37.7395207064184, -122.410190999519) | 10 | 7 | 7 | 28859 | 2 | |||
| 64382 | 66177 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.7396048925803 | -122.41021864302 | (37.7396048925803, -122.41021864302) | 10 | 7 | 7 | 28859 | 2 | ||
| 75027 | 203443 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | 9 | 7 | 4 | 59 | 40 | |||
| 84837 | 203444 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995221.10472 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | 9 | 7 | 4 | 59 | 40 | |||
| 175290 | 203445 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.97252 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | 9 | 7 | 4 | 59 | 40 | |||
| 117582 | 203446 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 2ft | 5995218.70657 | 2097826.55093 | 37.7399577427547 | -122.459101255842 | (37.7399577427547, -122.459101255842) | 9 | 7 | 4 | 59 | 40 | |||
| 105770 | 221768 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004580.21183 | 2097666.30062 | 37.7400514583975 | -122.426721628722 | (37.7400514583975, -122.426721628722) | 2 | 7 | 5 | 63 | 7 | |||
| 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 | |||
| 98782 | 66897 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30215 | 6007611.30400663 | 2097973.85799157 | 37.7410668478925 | -122.416263104572 | (37.7410668478925, -122.416263104572) | 2 | 7 | 7 | 28859 | 2 | ||
| 106703 | 66898 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30216 | 6007565.29124938 | 2098045.32566765 | 37.7412604948415 | -122.416427261414 | (37.7412604948415, -122.416427261414) | 2 | 7 | 7 | 28859 | 2 | ||
| 87958 | 66924 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.416415794383 | (37.7413986874365, -122.416415794383) | 2 | 7 | 7 | 28859 | 2 | ||
| 135251 | 220647 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007230.99534 | 2098247.75396 | 37.7417975128515 | -122.41759748494 | (37.7417975128515, -122.41759748494) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 145791 | 246824 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 402 Franconia St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6009972.67277 | 2098701.67929 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 170746 | 38961 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42707 | 6010377.89521168 | 2098716.86029543 | 37.7432621510095 | -122.406749540855 | (37.7432621510095, -122.406749540855) | 10 | 7 | 7 | 28859 | 2 | ||
| 192377 | 203455 | DPW Maintained 1 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | 1 | 8 | 4 | 59 | 40 | |||
| 129213 | 50096 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2005 12:00:00 AM | Permit Number 47882 | 5993030.04532242 | 2099099.0201688 | 37.7433255578151 | -122.466761150098 | (37.7433255578151, -122.466761150098) | 1 | 8 | 4 | 59 | 40 |
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) );