Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56962 | 56962 | 220618 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 237 Murray St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6005720.296519999 | 2095375.55283 | 37.7338259689755 | -122.422616936749 | (37.7338259689755, -122.422616936749) | |||
| 132179 | 132179 | 220641 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 859 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007571.590369999 | 2095340.9683400001 | 37.7338352787826 | -122.416213992189 | (37.7338352787826, -122.416213992189) | |||
| 184201 | 184201 | 220660 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003703.338380001 | 2095523.5259999998 | 37.734118272040604 | -122.429600714704 | (37.7341182720406, -122.429600714704) | |||
| 26515 | 26515 | 220605 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6006588.43416 | 2095556.2784900002 | 37.7343711416034 | -122.419628336682 | (37.7343711416034, -122.419628336682) | |||
| 157605 | 157605 | 220640 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 821 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007587.8208800005 | 2095563.9191 | 37.7344483655074 | -122.416173662982 | (37.7344483655074, -122.416173662982) | |||
| 155798 | 155798 | 203493 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 227 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999314.08769 | 2095746.28692 | 37.7344804146435 | -122.444791684116 | (37.7344804146435, -122.444791684116) | |||
| 150901 | 150901 | 220636 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 628 Chenery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002799.74223 | 2095713.6411400002 | 37.734589079726 | -122.43273830362699 | (37.734589079726, -122.432738303627) | |||
| 47594 | 47594 | 220635 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 628 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002826.10631 | 2095715.4099400002 | 37.7345954316319 | -122.432647280541 | (37.7345954316319, -122.432647280541) | |||
| 63596 | 63596 | 220634 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 628 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002844.7092 | 2095716.3109400002 | 37.7345989605548 | -122.432583028494 | (37.7345989605548, -122.432583028494) | |||
| 37791 | 37791 | 220646 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.41404494431801 | (37.7346828016745, -122.414044944318) | |||
| 128812 | 128812 | 51459 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | ||
| 138603 | 138603 | 51460 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47775 | 6008159.08468648 | 2095638.69714743 | 37.7346857944121 | -122.414203898561 | (37.7346857944121, -122.414203898561) | ||
| 133342 | 133342 | 220645 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008216.9228300005 | 2095637.5252200002 | 37.7346858251821 | -122.414003848906 | (37.7346858251821, -122.414003848906) | |||
| 136680 | 136680 | 203485 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998424.41404 | 2096025.6755 | 37.7351967372311 | -122.447887674883 | (37.7351967372311, -122.447887674883) | |||
| 128511 | 128511 | 45268 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 656 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44114 | 6008478.34688269 | 2095821.77218586 | 37.7352064067106 | -122.41311303777901 | (37.7352064067106, -122.413113037779) | ||
| 60506 | 60506 | 203484 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.23469 | 2096036.13552 | 37.7352253905456 | -122.447892505138 | (37.7352253905456, -122.447892505138) | |||
| 72861 | 72861 | 32513 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 777 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 12 | Permit Number 37015 | 6007618.09597 | 2095855.6295900003 | 37.735251041008794 | -122.416089643829 | (37.7352510410088, -122.416089643829) | |
| 165566 | 165566 | 203486 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 101 Los Palmos Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5998423.088169999 | 2096045.87835 | 37.7352521336624 | -122.447893712922 | (37.7352521336624, -122.447893712922) | |||
| 137268 | 137268 | 203489 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 296 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996836.5401099995 | 2096166.78672 | 37.7354933057555 | -122.45338768751101 | (37.7354933057555, -122.453387687511) | |||
| 163571 | 163571 | 203488 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 296 Cresta Vista Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996843.32855 | 2096168.5125900002 | 37.735498433689706 | -122.45336434200199 | (37.7354984336897, -122.453364342002) | |||
| 172296 | 172296 | 220606 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 382 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007224.12082 | 2095985.37984 | 37.735585147237295 | -122.41746095616999 | (37.7355851472373, -122.41746095617) | |||
| 47327 | 47327 | 201923 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 125 Elmira St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6011215.48386 | 2096005.8192 | 37.735865039640395 | -122.403662651736 | (37.7358650396404, -122.403662651736) | |||
| 63824 | 63824 | 220654 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008103.73158 | 2096079.3451 | 37.735892608341 | -122.414426443037 | (37.735892608341, -122.414426443037) | |||
| 152079 | 152079 | 220653 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008119.35429 | 2096079.0254799998 | 37.7358926083592 | -122.41437240636002 | (37.7358926083592, -122.41437240636) | |||
| 107302 | 107302 | 45289 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 600 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2001 12:00:00 AM | Permit Number 44129 | 6008139.59757362 | 2096081.06824752 | 37.7358993545079 | -122.414302561575 | (37.7358993545079, -122.414302561575) | |||
| 121616 | 121616 | 45290 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 600 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2001 12:00:00 AM | Permit Number 44129 | 6008139.59757362 | 2096081.06824752 | 37.7358993545079 | -122.414302561575 | (37.7358993545079, -122.414302561575) | |||
| 38930 | 38930 | 220655 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008083.69599 | 2096082.2563599998 | 37.735899476465704 | -122.41449592016599 | (37.7358994764657, -122.414495920166) | |||
| 186515 | 186515 | 189172 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1947 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6013391.6303 | 2095988.7563900002 | 37.735939510689605 | -122.396137605077 | (37.7359395106896, -122.396137605077) | |||
| 148423 | 148423 | 189174 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 14 Waterville St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6011435.762019999 | 2096086.73565 | 37.7360995216629 | -122.40290674814301 | (37.7360995216629, -122.402906748143) | |||
| 37156 | 37156 | 189173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1960 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.73616197508429 | -122.396301660307 | (37.7361619750843, -122.396301660307) | |||
| 161762 | 161762 | 220642 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 565 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008547.4442300005 | 2096175.62445 | 37.7361818869891 | -122.41289915230101 | (37.7361818869891, -122.412899152301) | |||
| 172151 | 172151 | 220652 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 324 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006873.24491 | 2096273.48816 | 37.7363564804515 | -122.418694495969 | (37.7363564804515, -122.418694495969) | |||
| 132173 | 132173 | 203487 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 828 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998282.181969999 | 2096469.8668799999 | 37.736408249925 | -122.44841139867201 | (37.736408249925, -122.448411398672) | |||
| 147861 | 147861 | 220661 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005456.84136 | 2096363.09768 | 37.7365226796806 | -122.423597969391 | (37.7365226796806, -122.423597969391) | |||
| 175507 | 175507 | 220607 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007434.64615 | 2096337.1519400002 | 37.7365628793641 | -122.416758001093 | (37.7365628793641, -122.416758001093) | |||
| 174293 | 174293 | 220662 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005443.37587 | 2096387.81015 | 37.7365897745051 | -122.42364628187599 | (37.7365897745051, -122.423646281876) | |||
| 179987 | 179987 | 221769 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6001830.02285 | 2096488.5302 | 37.7366617013818 | -122.436146377158 | (37.7366617013818, -122.436146377158) | |||
| 183969 | 183969 | 221770 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6001816.47531 | 2096513.16567 | 37.736728574973604 | -122.436194979235 | (37.7367285749736, -122.436194979235) | |||
| 30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
| 104904 | 104904 | 66399 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 512 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1991 12:00:00 AM | 11 | 4.5x12 | Permit Number 29525 | 6007445.41695715 | 2096473.5258201 | 37.736937937856496 | -122.41673042001001 | (37.7369379378565, -122.41673042001) | |
| 44032 | 44032 | 220657 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008343.07833 | 2096482.99595 | 37.737014388512996 | -122.41362746465799 | (37.737014388513, -122.413627464658) | |||
| 66877 | 66877 | 220656 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 505 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008322.74158 | 2096484.8015599998 | 37.737018204322 | -122.41369790583 | (37.737018204322, -122.41369790583) | |||
| 87495 | 87495 | 51467 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 450X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.41357047046199 | (37.7370397099418, -122.413570470462) | ||
| 90780 | 90780 | 51468 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 450X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/20/2004 12:00:00 AM | 10 | 3x3 | Permit Number 47780 | 6008359.74436357 | 2096491.87705801 | 37.7370397099418 | -122.41357047046199 | (37.7370397099418, -122.413570470462) |
| 178896 | 178896 | 220609 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6008945.60793 | 2096515.87148 | 37.737138473362 | -122.411546563846 | (37.737138473362, -122.411546563846) | |||
| 183859 | 183859 | 220608 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 385 Nevada St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 6008946.36134 | 2096525.7454799998 | 37.7371656274845 | -122.41154465636801 | (37.7371656274845, -122.411544656368) | |||
| 65850 | 65850 | 92445 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2646 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52836 | 5982487.2 | 2097095.3 | 37.737209800771296 | -122.503066669454 | (37.7372098007713, -122.503066669454) |
| 24633 | 24633 | 220637 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003700.73164 | 2096802.6587900002 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | |||
| 144354 | 144354 | 69515 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 443 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1997 12:00:00 AM | Permit Number 33643 | 6008794.13528985 | 2096723.61704292 | 37.737700399871294 | -122.412084952925 | (37.7377003998713, -122.412084952925) | ||
| 38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
| 88226 | 88226 | 81183 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 461 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50918 | 6007526.59353608 | 2096789.07906061 | 37.7378089430444 | -122.416472100986 | (37.7378089430444, -122.416472100986) | ||
| 88563 | 88563 | 50078 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46810 | 5991411.04399471 | 2097301.04699111 | 37.7382952135341 | -122.47222815003599 | (37.7382952135341, -122.472228150036) | ||
| 28571 | 28571 | 203474 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | |||
| 31567 | 31567 | 203453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.738340446961104 | -122.47206749851001 | (37.7383404469611, -122.47206749851) | |||
| 18805 | 18805 | 27714 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001610.45471 | 2097108.7336400002 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | |||
| 105572 | 105572 | 50076 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2659 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46808 | 5991410.12918009 | 2097327.15671334 | 37.738366851245104 | -122.472233215714 | (37.7383668512451, -122.472233215714) | ||
| 31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
| 133444 | 133444 | 221774 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6001628.85719 | 2097123.02869 | 37.7383924556487 | -122.43688730163 | (37.7383924556487, -122.43688730163) | |||
| 82919 | 82919 | 50074 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2654 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46807 | 5991461.18247601 | 2097355.08728319 | 37.7384464959625 | -122.472058735315 | (37.7384464959625, -122.472058735315) | ||
| 169779 | 169779 | 220610 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 243 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6009545.72231 | 2097174.03837 | 37.7389793010447 | -122.40951812496 | (37.7389793010447, -122.40951812496) | |||
| 155006 | 155006 | 221772 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 71 Miguel St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003850.95701 | 2097297.26656 | 37.7389969178725 | -122.429216785123 | (37.7389969178725, -122.429216785123) | |||
| 20258 | 20258 | 50073 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.739019597898505 | -122.472099259809 | (37.7390195978985, -122.472099259809) | ||
| 133637 | 133637 | 189200 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 625 Mendell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6016323.4017 | 2097117.36023 | 37.7392011179238 | -122.38607986071699 | (37.7392011179238, -122.386079860717) | |||
| 119063 | 119063 | 86884 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2534 46th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49809 | 5982151.4 | 2097835.7 | 37.73922299278121 | -122.504282496051 | (37.7392229927812, -122.504282496051) | |||
| 58297 | 58297 | 220644 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6009354.03531 | 2097334.2588400003 | 37.7394084890188 | -122.410192201918 | (37.7394084890188, -122.410192201918) | |||
| 91999 | 91999 | 66176 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 16 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29249 | 6009344.53220754 | 2097370.35407631 | 37.739507066017794 | -122.41022760736601 | (37.7395070660178, -122.410227607366) | ||
| 163606 | 163606 | 220643 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009355.21688 | 2097375.10372 | 37.739520706418396 | -122.410190999519 | (37.7395207064184, -122.410190999519) | |||
| 89015 | 89015 | 66177 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 10 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29250 | 6009347.85081362 | 2097405.9142613 | 37.739604892580296 | -122.41021864302 | (37.7396048925803, -122.41021864302) | ||
| 54933 | 54933 | 203443 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995223.6819 | 2097798.00617 | 37.7398796519151 | -122.459081986971 | (37.7398796519151, -122.459081986971) | |||
| 178983 | 178983 | 203444 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995221.104719999 | 2097808.00302 | 37.7399069526404 | -122.459091621397 | (37.7399069526404, -122.459091621397) | |||
| 171195 | 171195 | 203445 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.972519999 | 2097817.06527 | 37.7399317127649 | -122.459099649629 | (37.7399317127649, -122.459099649629) | |||
| 187869 | 187869 | 203446 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Marne Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 2ft | 5995218.706569999 | 2097826.55093 | 37.739957742754704 | -122.459101255842 | (37.7399577427547, -122.459101255842) | |||
| 180841 | 180841 | 221768 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1888 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004580.21183 | 2097666.30062 | 37.740051458397495 | -122.426721628722 | (37.7400514583975, -122.426721628722) | |||
| 163457 | 163457 | 189152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1665 Hudson Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6015368.44602 | 2097645.0372099997 | 37.7405971121722 | -122.389418536259 | (37.7405971121722, -122.389418536259) | |||
| 100296 | 100296 | 66897 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 147 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | Permit Number 30215 | 6007611.30400663 | 2097973.85799157 | 37.7410668478925 | -122.416263104572 | (37.7410668478925, -122.416263104572) | ||
| 100127 | 100127 | 66898 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/1991 12:00:00 AM | Permit Number 30216 | 6007565.29124938 | 2098045.32566765 | 37.7412604948415 | -122.416427261414 | (37.7412604948415, -122.416427261414) | ||
| 101512 | 101512 | 66924 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 118 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1991 12:00:00 AM | Permit Number 30245 | 6007569.63661842 | 2098095.56578905 | 37.7413986874365 | -122.41641579438298 | (37.7413986874365, -122.416415794383) | ||
| 64810 | 64810 | 220647 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 157 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007230.99534 | 2098247.75396 | 37.7417975128515 | -122.41759748493999 | (37.7417975128515, -122.41759748494) | |||
| 40602 | 40602 | 203478 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2453 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992323.79318 | 2098755.04508 | 37.74234030496479 | -122.469178135975 | (37.7423403049648, -122.469178135975) | |||
| 50442 | 50442 | 220612 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 9 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009640.52107 | 2098655.41337 | 37.743052146240295 | -122.409294863773 | (37.7430521462403, -122.409294863773) | |||
| 154701 | 154701 | 220611 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009641.7814 | 2098664.7156700003 | 37.743077758937105 | -122.40929116218399 | (37.7430777589371, -122.409291162184) | |||
| 182457 | 182457 | 246824 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 402 Franconia St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009972.67277 | 2098701.6792900003 | 37.7431977860534 | -122.408149630203 | (37.7431977860534, -122.408149630203) | |||
| 33827 | 33827 | 203454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993011.06637 | 2099068.7919400004 | 37.743241463417796 | -122.466824576891 | (37.7432414634178, -122.466824576891) | |||
| 142286 | 142286 | 38961 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 407 Holladay Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | Permit Number 42707 | 6010377.89521168 | 2098716.86029543 | 37.743262151009496 | -122.406749540855 | (37.7432621510095, -122.406749540855) | ||
| 164035 | 164035 | 203455 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993020.02718 | 2099098.31016 | 37.7433230301343 | -122.466795738355 | (37.7433230301343, -122.466795738355) | |||
| 105569 | 105569 | 50096 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2005 12:00:00 AM | Permit Number 47882 | 5993030.04532242 | 2099099.0201688 | 37.743325557815105 | -122.466761150098 | (37.7433255578151, -122.466761150098) | ||
| 36428 | 36428 | 203476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.743979223173106 | -122.472790471621 | (37.7439792231731, -122.472790471621) | |||
| 24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
| 31906 | 31906 | 220602 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003653.16044 | 2099206.97915 | 37.744229349819896 | -122.43003686791401 | (37.7442293498199, -122.430036867914) | |||
| 120323 | 120323 | 37067 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39669 | 6003676.44308345 | 2099207.16082517 | 37.7442311672419 | -122.42995637453899 | (37.7442311672419, -122.429956374539) | ||
| 33839 | 33839 | 220603 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 418 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003167.3476 | 2099231.48151 | 37.744269101647795 | -122.43171845176501 | (37.7442691016478, -122.431718451765) | |||
| 58639 | 58639 | 203477 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2331 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5990713.76496 | 2099522.32344 | 37.7443538888309 | -122.47480105801701 | (37.7443538888309, -122.474801058017) | |||
| 56741 | 56741 | 220619 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 618 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6001863.58646 | 2099454.0588599998 | 37.744806257700205 | -122.43624249671801 | (37.7448062577002, -122.436242496718) | ||||
| 126745 | 126745 | 220651 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6008064.96703 | 2099392.46104 | 37.74498751697679 | -122.41479487098101 | (37.7449875169768, -122.414794870981) | |||
| 157432 | 157432 | 220650 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6008081.1542 | 2099392.86215 | 37.744989527842996 | -122.41473892687999 | (37.744989527843, -122.41473892688) | |||
| 94467 | 94467 | 42095 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | |||
| 125757 | 125757 | 42094 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 45 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42400 | 6008105.01217426 | 2099392.98476779 | 37.744991204982 | -122.414656438734 | (37.744991204982, -122.414656438734) | ||
| 104262 | 104262 | 42093 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 41 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42399 | 6008132.14946535 | 2099394.72931137 | 37.7449975197465 | -122.414562726014 | (37.7449975197465, -122.414562726014) | ||
| 125905 | 125905 | 42092 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 37 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42398 | 6008159.28675644 | 2099396.47385495 | 37.745003834436396 | -122.414469013279 | (37.7450038344364, -122.414469013279) | ||
| 59975 | 59975 | 220649 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 41 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008103.651880001 | 2099402.16609 | 37.7450163384242 | -122.414661792014 | (37.7450163384242, -122.414661792014) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");