Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125 | 125 | 119758 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 151X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 5341 | 5341 | 19786 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 10131 | 10131 | 19871 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY33 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 10149 | 10149 | 173884 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 11717 | 11717 | 61760 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3739 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/19/1984 12:00:00 AM | Permit Number 21774 | |||||||
| 11810 | 11810 | 30642 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1500 Houston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | Permit Number 34585 | ||||||||
| 14146 | 14146 | 19784 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 14308 | 14308 | 19785 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 15410 | 15410 | 30596 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 451 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34563 | ||||||||
| 16505 | 16505 | 30597 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 461 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34564 | ||||||||
| 142348 | 142348 | 37363 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 399 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39869 | 5999946.93855513 | 2086126.88642813 | 37.7081038333344 | -122.441913518536 | (37.7081038333344, -122.441913518536) | ||
| 72925 | 72925 | 37362 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 389 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 5 | Permit Number 39868 | 5999904.39956 | 2086205.97532 | 37.7083185697068 | -122.44206621039899 | (37.7083185697068, -122.442066210399) | |
| 161932 | 161932 | 72806 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 382 Guttenberg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/1998 12:00:00 AM | 6 | 5999864.9815 | 2086214.70068 | 37.70834028115829 | -122.44220306922399 | (37.7083402811583, -122.442203069224) | ||
| 169985 | 169985 | 177495 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 818 Brunswick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997608.02587 | 2086258.36889 | 37.7083312969119 | -122.45000647583299 | (37.7083312969119, -122.450006475833) | |||
| 109852 | 109852 | 112633 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 800x BRUNSWICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 5x6 | 5997602.0 | 2086276.0 | 37.70837936312 | -122.450028571713 | (37.70837936312, -122.450028571713) | |||
| 65303 | 65303 | 50949 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 46 Niantic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2004 12:00:00 AM | Permit Number 47444 | 5992462.89572875 | 2086742.39043465 | 37.7093645519695 | -122.46782366028499 | (37.7093645519695, -122.467823660285) | |||
| 12389 | 12389 | 44404 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1171 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | 5x5 | Permit Number 43757 | 6001253.36024 | 2087074.10385 | 37.710779041984296 | -122.437466181726 | (37.7107790419843, -122.437466181726) |
| 35554 | 35554 | 177521 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1144 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6001479.66195 | 2087076.7013400001 | 37.7107990375076 | -122.43668421852199 | (37.7107990375076, -122.436684218522) | |||
| 171226 | 171226 | 177522 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1144 Munich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6001464.73041 | 2087077.9074900001 | 37.7108015007545 | -122.43673591154 | (37.7108015007545, -122.43673591154) | |||
| 39224 | 39224 | 44403 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1171 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 5 | Permit Number 43757 | 6001229.01614 | 2087080.5529 | 37.7107953655799 | -122.437550781868 | (37.7107953655799, -122.437550781868) | |
| 154497 | 154497 | 64391 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 26 Naylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1988 12:00:00 AM | 17 | Permit Number 25233 | 6002287.36873 | 2087141.043 | 37.711021574766505 | -122.43389719790501 | (37.7110215747665, -122.433897197905) | ||
| 36775 | 36775 | 67683 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1184 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 16 | Permit Number 31287 | 6001136.68439 | 2087160.96282 | 37.711010903415605 | -122.437875656534 | (37.7110109034156, -122.437875656534) | ||
| 167496 | 167496 | 65727 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 312 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 4 | Permit Number 28661 | 6000508.37092 | 2087245.71828 | 37.711207873825394 | -122.44005332621599 | (37.7112078738254, -122.440053326216) | |
| 131576 | 131576 | 65726 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 306 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/1990 12:00:00 AM | 4 | Permit Number 28660 | 6000500.93901 | 2087267.80568 | 37.7112680978128 | -122.44008059547 | (37.7112680978128, -122.44008059547) | |
| 134634 | 134634 | 177496 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 50 Dichiera Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5998635.9912 | 2087923.9252400002 | 37.7129633054989 | -122.446573473097 | (37.7129633054989, -122.446573473097) | |||
| 121436 | 121436 | 37351 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 99 Curtis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39857 | 6000722.91615892 | 2087924.83898491 | 37.7130847996496 | -122.43936045434401 | (37.7130847996496, -122.439360454344) | ||
| 124829 | 124829 | 37350 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 99 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39857 | 6000722.91615892 | 2087924.83898491 | 37.7130847996496 | -122.43936045434401 | (37.7130847996496, -122.439360454344) | ||
| 138321 | 138321 | 37349 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 99 Curtis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39857 | 6000722.91615892 | 2087924.83898491 | 37.7130847996496 | -122.43936045434401 | (37.7130847996496, -122.439360454344) | ||
| 156984 | 156984 | 177509 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 110 Morse St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000763.73419 | 2087926.3737400002 | 37.7130913365653 | -122.439219483794 | (37.7130913365653, -122.439219483794) | |||
| 89214 | 89214 | 177508 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 110 Morse St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000777.68509 | 2087930.7673099998 | 37.7131041941905 | -122.439171579615 | (37.7131041941905, -122.439171579615) | |||
| 51158 | 51158 | 177507 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 110 Morse St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000791.64594 | 2087935.6536 | 37.7131184052617 | -122.43912367632099 | (37.7131184052617, -122.439123676321) | |||
| 47848 | 47848 | 209611 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 77 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 13 | 5992168.85342 | 2088365.8404 | 37.7138051716457 | -122.468957974754 | (37.7138051716457, -122.468957974754) | ||||
| 148516 | 148516 | 37348 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 14 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 11 | Permit Number 39856 | 6000461.110640001 | 2088601.2716299999 | 37.714927229669705 | -122.440313820238 | (37.7149272296697, -122.440313820238) | |
| 10433 | 10433 | 50855 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 638 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2004 12:00:00 AM | 8 | 6x9 | Permit Number 47370 | 6002852.60741 | 2089781.5433900002 | 37.718303870103 | -122.432132042771 | (37.718303870103, -122.432132042771) | |
| 163830 | 163830 | 177501 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 600 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003196.59797 | 2089819.73332 | 37.7184282283581 | -122.43094573716299 | (37.7184282283581, -122.430945737163) | |||
| 34904 | 34904 | 177500 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 600 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003202.56607 | 2089830.2820400002 | 37.7184575309817 | -122.430925860366 | (37.7184575309817, -122.430925860366) | |||
| 48724 | 48724 | 177497 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 683 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6001012.66507 | 2089830.75462 | 37.71833450281579 | -122.438495457598 | (37.7183345028158, -122.438495457598) | ||||
| 156392 | 156392 | 177498 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 683 London St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6001010.13628 | 2089832.4440000001 | 37.7183389976271 | -122.43850431951799 | (37.7183389976271, -122.438504319518) | ||||
| 120857 | 120857 | 65229 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 780 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 28016 | 6003185.29952819 | 2089863.30201471 | 37.718547218198104 | -122.430987898978 | (37.7185472181981, -122.430987898978) | ||
| 29053 | 29053 | 113579 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 624 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001181.7605800005 | 2090176.14615 | 37.7192924876344 | -122.437935692598 | (37.7192924876344, -122.437935692598) | |||
| 67800 | 67800 | 177502 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 601 Edinburgh St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002543.97095 | 2090223.4242599998 | 37.719499673459296 | -122.433230424356 | (37.7194996734593, -122.433230424356) | |||
| 69371 | 69371 | 65225 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 500 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 28012 | 6002551.42222049 | 2090262.71018244 | 37.7196079665756 | -122.43320747365401 | (37.7196079665756, -122.433207473654) | ||
| 109147 | 109147 | 49794 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 274 Tara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2003 12:00:00 AM | Permit Number 46581 | 5997725.28262665 | 2090268.91208935 | 37.71935003623221 | -122.44989006385401 | (37.7193500362322, -122.449890063854) | ||
| 177542 | 177542 | 209605 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 274 Tara St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997733.16955 | 2090269.0506799999 | 37.7193508680382 | -122.44986281181299 | (37.7193508680382, -122.449862811813) | |||
| 43670 | 43670 | 209602 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 53 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995305.97896 | 2090273.56584 | 37.7192240905989 | -122.458252975721 | (37.7192240905989, -122.458252975721) | |||
| 178860 | 178860 | 177503 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 624 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6002207.67318 | 2090275.57342 | 37.7196237799002 | -122.43439660764099 | (37.7196237799002, -122.434396607641) | |||
| 11588 | 11588 | 17577 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 801X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/1992 12:00:00 AM | 10 | 3x3 | 6003802.45105 | 2090312.9257 | 37.719816736620395 | -122.428886697071 | (37.7198167366204, -122.428886697071) | ||
| 178575 | 178575 | 209603 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 66 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996233.93649 | 2090322.9655900002 | 37.71941301028421 | -122.455048964665 | (37.7194130102842, -122.455048964665) | |||
| 113476 | 113476 | 67979 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 66 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31703 | 5996240.591528599 | 2090324.78151956 | 37.7194183781903 | -122.455026091942 | (37.7194183781903, -122.455026091942) | ||
| 37038 | 37038 | 209604 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 74 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5996234.98769 | 2090373.27723 | 37.719551214510496 | -122.455048964643 | (37.7195512145105, -122.455048964643) | |||
| 123270 | 123270 | 43709 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 971 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | Permit Number 43350 | 5995009.56168601 | 2090375.88388061 | 37.719487994099005 | -122.45928497646099 | (37.719487994099, -122.459284976461) | ||
| 92017 | 92017 | 67981 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 74 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31705 | 5996241.50037603 | 2090376.07922528 | 37.7195592817543 | -122.455026655149 | (37.7195592817543, -122.455026655149) | ||
| 65886 | 65886 | 209601 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 971 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5995014.25887 | 2090376.62985 | 37.719490312409 | -122.459268794119 | (37.719490312409, -122.459268794119) | |||
| 75798 | 75798 | 209607 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 488 Arch St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 6ft | 5992758.831730001 | 2090447.2277099998 | 37.719554228122504 | -122.46707004236099 | (37.7195542281225, -122.467070042361) | |||
| 13193 | 13193 | 17566 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 701X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 25 | 4.5x6 | 6003419.22785 | 2090557.86639 | 37.7204675912996 | -122.43022883000201 | (37.7204675912996, -122.430228830002) | ||
| 12365 | 12365 | 17561 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 644 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/1992 12:00:00 AM | 8 | 3X3 | 6003309.034969999 | 2090573.8726599999 | 37.7205052989509 | -122.430610872798 | (37.7205052989509, -122.430610872798) | ||
| 171699 | 171699 | 65207 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 509 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 12 | Permit Number 27193 | 6003087.47679 | 2090583.31422 | 37.720518669177295 | -122.43137740184099 | (37.7205186691773, -122.431377401841) | |
| 12849 | 12849 | 17560 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 636 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003292.50024 | 2090584.1150200001 | 37.720532485468205 | -122.43066875855601 | (37.7205324854682, -122.430668758556) | |||
| 157208 | 157208 | 209600 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5994123.38139 | 2090627.1141599999 | 37.7201268228771 | -122.462366365921 | (37.7201268228771, -122.462366365921) | |||
| 159452 | 159452 | 68162 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 482 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1993 12:00:00 AM | 17 | 12x9 | Permit Number 31926 | 6003408.25632 | 2090663.44468 | 37.720756864529 | -122.430274283529 | (37.720756864529, -122.430274283529) | |
| 53039 | 53039 | 177506 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 522 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002800.47146 | 2090713.17965 | 37.720858980741205 | -122.432378757398 | (37.7208589807412, -122.432378757398) | |||
| 110184 | 110184 | 83365 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 519 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52314 | 6002861.74307965 | 2090721.37693042 | 37.7208849628012 | -122.432167545235 | (37.7208849628012, -122.432167545235) | |
| 69134 | 69134 | 177499 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 590 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003024.63841 | 2090752.49122 | 37.720979630183 | -122.43160668580799 | (37.720979630183, -122.431606685808) | |||
| 106719 | 106719 | 17546 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 548X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/1992 12:00:00 AM | 12 | 3X3 | 6003010.146575901 | 2090756.9744765 | 37.72099111878529 | -122.431657099656 | (37.7209911187853, -122.431657099656) | ||
| 100639 | 100639 | 65186 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 454 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | Permit Number 27170 | 6002238.91412718 | 2090843.4397919998 | 37.7211847875141 | -122.434329196588 | (37.7211847875141, -122.434329196588) | ||
| 38792 | 38792 | 209609 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 562 Bright St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5993802.84348 | 2090885.4872 | 37.7208177899974 | -122.463493089652 | (37.7208177899974, -122.463493089652) | ||||
| 48975 | 48975 | 209610 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 562 Bright St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5993801.59682 | 2090894.0331 | 37.720841183149 | -122.463498018815 | (37.720841183149, -122.463498018815) | ||||
| 151824 | 151824 | 65223 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 463 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 16 | Permit Number 28010 | 6002023.99966 | 2090921.41259 | 37.7213866822256 | -122.435077666903 | (37.7213866822256, -122.435077666903) | |
| 166144 | 166144 | 65222 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 451 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1989 12:00:00 AM | 12 | Permit Number 28009 | 6002055.85341 | 2090969.8629599998 | 37.7215215247894 | -122.43497102081498 | (37.7215215247894, -122.434971020815) | |
| 73317 | 73317 | 209606 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 498 Vernon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 5992503.53481 | 2091073.22765 | 37.7212583318809 | -122.46799801320499 | (37.7212583318809, -122.467998013205) | |||
| 170507 | 170507 | 193523 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6012042.90878 | 2091133.14188 | 37.72253186184621 | -122.400459737844 | (37.7225318618462, -122.400459737844) | |||
| 154111 | 154111 | 209608 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 582 Ramsell St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5993026.783969999 | 2091158.11551 | 37.7215216165087 | -122.46619547055501 | (37.7215216165087, -122.466195470555) | |||
| 57557 | 57557 | 177505 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 444 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001820.68504 | 2091182.5670099999 | 37.722092206671796 | -122.435799143529 | (37.7220922066718, -122.435799143529) | |||
| 188662 | 188662 | 177504 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 440 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001848.47565 | 2091226.67857 | 37.7222149056849 | -122.435706232752 | (37.7222149056849, -122.435706232752) | |||
| 151882 | 151882 | 193522 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6012004.88224 | 2091261.4102900003 | 37.7228819400315 | -122.40060019395 | (37.7228819400315, -122.40060019395) | |||
| 80248 | 80248 | 31203 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 422 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 34895 | 6001889.76810275 | 2091302.66010949 | 37.722425879300395 | -122.435568927878 | (37.7224258793004, -122.435568927878) | ||||
| 10501 | 10501 | 17501 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 124 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002114.94221 | 2091325.72307 | 37.722501991763004 | -122.434792202295 | (37.722501991763, -122.434792202295) | |||
| 12307 | 12307 | 17505 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 137 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002178.53273 | 2091331.3237299998 | 37.7225209800456 | -122.434572784827 | (37.7225209800456, -122.434572784827) | |||
| 166455 | 166455 | 46858 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 358 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 13 | 9x12 | Permit Number 44927 | 6003840.59678 | 2091356.7817900002 | 37.7226850946194 | -122.4288292187 | (37.7226850946194, -122.4288292187) |
| 161317 | 161317 | 193521 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6011967.2301900005 | 2091387.43743 | 37.7232258848472 | -122.40073919945299 | (37.7232258848472, -122.400739199453) | |||
| 31133 | 31133 | 193520 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6011963.497280001 | 2091396.5487400002 | 37.7232506944377 | -122.40075274327101 | (37.7232506944377, -122.400752743271) | |||
| 72888 | 72888 | 193519 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6011960.51121 | 2091404.06752 | 37.7232711729205 | -122.40076359357201 | (37.7232711729205, -122.400763593572) | |||
| 184044 | 184044 | 193518 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 6011952.63782 | 2091425.36702 | 37.7233292178447 | -122.40079230621402 | (37.7233292178447, -122.400792306214) | |||
| 24474 | 24474 | 193517 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6011952.06769 | 2091431.9694299998 | 37.7233473149134 | -122.400794740685 | (37.7233473149134, -122.400794740685) | |||
| 185869 | 185869 | 65219 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 365 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | Permit Number 28006 | 6002368.83021 | 2091466.24215 | 37.722902236828396 | -122.433924609245 | (37.7229022368284, -122.433924609245) | |
| 62135 | 62135 | 193516 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1600 Bay Shore Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6011933.86087 | 2091488.8209799998 | 37.723502402108004 | -122.400861670948 | (37.723502402108, -122.400861670948) | |||
| 69522 | 69522 | 60187 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 347 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52324 | 6003686.27135 | 2091532.10803 | 37.7231577656936 | -122.429375184541 | (37.7231577656936, -122.429375184541) | |
| 89079 | 89079 | 67561 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 635 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31113 | 6011632.15915746 | 2091599.32600472 | 37.7237889929604 | -122.401912369908 | (37.7237889929604, -122.401912369908) | ||
| 95262 | 95262 | 38174 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 664 Brussels St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40310 | 6010927.90399368 | 2091661.84808929 | 37.7239213360715 | -122.404351274172 | (37.7239213360715, -122.404351274172) | ||
| 100114 | 100114 | 38175 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 664 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40310 | 6010927.90399368 | 2091661.84808929 | 37.7239213360715 | -122.404351274172 | (37.7239213360715, -122.404351274172) | ||
| 176943 | 176943 | 177520 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 367 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6003167.029130001 | 2091722.1707099997 | 37.7236502245544 | -122.43118366180201 | (37.7236502245544, -122.431183661802) | |||
| 186753 | 186753 | 177516 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 263 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6004455.15755 | 2091731.1970799998 | 37.7237479215176 | -122.42673146548 | (37.7237479215176, -122.42673146548) | ||||
| 137662 | 137662 | 177510 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 349 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5999811.62163 | 2091821.31222 | 37.7237317265241 | -122.44278980400298 | (37.7237317265241, -122.442789804003) | |||
| 95628 | 95628 | 66995 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 500 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/1992 12:00:00 AM | Permit Number 30349 | 5992613.77425874 | 2091862.9135908 | 37.723432982057204 | -122.46767435181101 | (37.7234329820572, -122.467674351811) | ||
| 41162 | 41162 | 80743 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 804 Avalon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50647 | 6004694.46295 | 2092041.6733 | 37.724613947971704 | -122.42592631683998 | (37.7246139479717, -122.42592631684) | |
| 179876 | 179876 | 43274 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 561 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 10 | Permit Number 43046 | 6010834.02048 | 2092127.20509 | 37.725193863182994 | -122.40470856146099 | (37.725193863183, -122.404708561461) | |
| 107936 | 107936 | 118318 | Property Tree 7 | Maytenus boaria :: Mayten 22 | 20 Norton St | 1 | Front Yard : Yard 7 | Tree 1 | MTA 6 | 6002015.686319999 | 2092167.12899 | 37.724806667280895 | -122.435195459751 | (37.7248066672809, -122.435195459751) | |||||
| 37890 | 37890 | 177511 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 14 Norton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6001995.5788 | 2092177.41495 | 37.7248337683496 | -122.435265704348 | (37.7248337683496, -122.435265704348) | |||
| 127213 | 127213 | 68088 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 252 Delano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31830 | 5999963.42960009 | 2092209.02773134 | 37.724804957551605 | -122.442292851355 | (37.7248049575516, -122.442292851355) | ||
| 12317 | 12317 | 75378 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1739X Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 10 | 3x3 | 6005787.8485 | 2092298.2096 | 37.7253800723092 | -122.422164834944 | (37.7253800723092, -122.422164834944) |
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");