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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161999 | 161999 | 218270 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1456 Portola Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 5992782.12061 | 2097251.65776 | 37.73823885594471 | -122.46748409202 | (37.7382388559447, -122.46748409202) | |||
| 84733 | 84733 | 116949 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 123 WEST PORTAL AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992936.0 | 2097647.0 | 37.7393332491746 | -122.46698079132099 | (37.7393332491746, -122.466980791321) | ||||
| 121155 | 121155 | 116948 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 123 WEST PORTAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992936.0 | 2097647.0 | 37.7393332491746 | -122.46698079132099 | (37.7393332491746, -122.466980791321) | ||||
| 110263 | 110263 | 52957 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 227 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | Permit Number 48944 | 5992946.65383726 | 2088708.6513983002 | 37.714791356792 | -122.46629453065701 | (37.714791356792, -122.466294530657) | ||
| 131290 | 131290 | 204620 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993064.41106 | 2105672.78897 | 37.7613774166458 | -122.467120173251 | (37.7613774166458, -122.467120173251) | |||
| 80681 | 80681 | 110721 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1898X 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | |||||
| 123646 | 123646 | 110722 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1898X 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | |||||
| 126160 | 126160 | 110720 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1898X 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993137.43282 | 2102888.05903 | 37.753735486992 | -122.466665198088 | (37.753735486992, -122.466665198088) | |||||
| 82665 | 82665 | 39219 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 347 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1998 12:00:00 AM | Permit Number 40862 | 5993215.94072133 | 2089494.769314 | 37.7169653816902 | -122.465420843024 | (37.7169653816902, -122.465420843024) | |||
| 28372 | 28372 | 204655 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 452 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.46529981143298 | (37.7188834957636, -122.465299811433) | |||
| 120200 | 120200 | 47376 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 454 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45293 | 5993277.02762299 | 2090193.33113846 | 37.718886987019 | -122.46526040964899 | (37.718886987019, -122.465260409649) | ||
| 32793 | 32793 | 67326 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 714 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 12 | Permit Number 30809 | 5993329.61616 | 2111427.9815700003 | 37.7771949529998 | -122.466621290245 | (37.7771949529998, -122.466621290245) | |
| 103622 | 103622 | 48643 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45936 | 5993334.71771315 | 2105415.01360696 | 37.7606852319988 | -122.466166570005 | (37.7606852319988, -122.466166570005) | ||
| 187499 | 187499 | 204621 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993335.30038 | 2105432.94132 | 37.7607344904344 | -122.466165857685 | (37.7607344904344, -122.466165857685) | |||
| 27101 | 27101 | 124082 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3220 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993384.863369999 | 2110069.41246 | 37.773467874758296 | -122.466331413768 | (37.7734678747583, -122.466331413768) | |||
| 31785 | 31785 | 124081 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3220 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993396.8995199995 | 2110067.15404 | 37.7734623682136 | -122.46628961516399 | (37.7734623682136, -122.466289615164) | |||
| 154732 | 154732 | 204656 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5993464.3561 | 2089166.2811200002 | 37.716077755750206 | -122.464538359982 | (37.7160777557502, -122.464538359982) | |||
| 60672 | 60672 | 204624 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1830 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993464.78312 | 2103004.20884 | 37.7540732902536 | -122.465541593278 | (37.7540732902536, -122.465541593278) | |||
| 173962 | 173962 | 123230 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 785 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5993487.30033 | 2110174.28885 | 37.7737617473343 | -122.465984694601 | (37.7737617473343, -122.465984694601) | |||
| 154132 | 154132 | 123824 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1665 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993487.5757 | 2112056.30859 | 37.7789292839599 | -122.466120533372 | (37.7789292839599, -122.466120533372) | |||
| 156878 | 156878 | 56952 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 795 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1974 12:00:00 AM | 7 | Permit Number 14204 | 5993489.41899 | 2110144.08424 | 37.7736789357713 | -122.465975170673 | (37.7736789357713, -122.465975170673) | ||
| 150124 | 150124 | 123229 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 785 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993489.53527 | 2110160.53271 | 37.773724105582296 | -122.465975963885 | (37.7737241055823, -122.465975963885) | |||
| 113808 | 113808 | 89718 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1655 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5993507.69164 | 2112056.80986 | 37.778931820846296 | -122.46605098131501 | (37.7789318208463, -122.466050981315) | ||
| 172522 | 172522 | 204657 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200 Mesa Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993588.18999 | 2100755.25284 | 37.7479053493615 | -122.46495150490601 | (37.7479053493615, -122.464951504906) | |||
| 169508 | 169508 | 204622 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1518 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993700.04012 | 2105141.70568 | 37.7599558699739 | -122.46488324546499 | (37.7599558699739, -122.464883245465) | |||
| 147889 | 147889 | 204616 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 621 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993775.2241 | 2107303.2691599997 | 37.7658952931499 | -122.46478019575198 | (37.7658952931499, -122.464780195752) | |||
| 24896 | 24896 | 204623 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1880 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5993786.05175 | 2102711.73048 | 37.7532887441949 | -122.46440934321801 | (37.7532887441949, -122.464409343218) | |||
| 149380 | 149380 | 204617 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 621 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993792.5560800005 | 2107303.5698 | 37.7658971178728 | -122.464720270343 | (37.7658971178728, -122.464720270343) | |||
| 9115 | 9115 | 90912 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 545 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 5993886.17439 | 2110710.21085 | 37.775256248873895 | -122.464643860229 | (37.7752562488739, -122.464643860229) | ||
| 87473 | 87473 | 121683 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1645 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993978.0 | 2104308.0 | 37.757682752419896 | -122.46386140871401 | (37.7576827524199, -122.463861408714) | ||||
| 141162 | 141162 | 121682 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993978.0 | 2104308.0 | 37.757682752419896 | -122.46386140871401 | (37.7576827524199, -122.463861408714) | ||||
| 86680 | 86680 | 39663 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 90504 | 90504 | 39664 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41054 | 5994040.07409456 | 2090558.08173508 | 37.719932478931796 | -122.46264932396299 | (37.7199324789318, -122.462649323963) | ||
| 67938 | 67938 | 204649 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 508 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994044.084530001 | 2090032.62859 | 37.7184899416364 | -122.46259736577 | (37.7184899416364, -122.46259736577) | |||
| 92664 | 92664 | 39671 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 99326 | 99326 | 39673 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 112900 | 112900 | 39672 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 127185 | 127185 | 39670 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 500 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41059 | 5994056.18580091 | 2089950.78311256 | 37.7182659104704 | -122.462549603412 | (37.7182659104704, -122.462549603412) | ||
| 82360 | 82360 | 39674 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 510 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41060 | 5994056.62807806 | 2090013.39911729 | 37.718437864492394 | -122.462552614145 | (37.7184378644924, -122.462552614145) | ||
| 107272 | 107272 | 39648 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/25/2002 12:00:00 AM | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.720220556524204 | -122.462345612464 | (37.7202205565242, -122.462345612464) | ||
| 145840 | 145840 | 39649 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1998 12:00:00 AM | 5 | 3x20 | Permit Number 41042 | 5994130.09830184 | 2090661.11089351 | 37.720220556524204 | -122.462345612464 | (37.7202205565242, -122.462345612464) | |
| 54422 | 54422 | 204645 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994132.807630001 | 2090689.3393400002 | 37.7202982210683 | -122.462338293601 | (37.7202982210683, -122.462338293601) | |||
| 107581 | 107581 | 39652 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 141 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41045 | 5994132.92951736 | 2090837.78725757 | 37.7207058303918 | -122.462348633516 | (37.7207058303918, -122.462348633516) | ||
| 164499 | 164499 | 204646 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Ashton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994133.91606 | 2090657.47285 | 37.7202107871682 | -122.462332152117 | (37.7202107871682, -122.462332152117) | |||
| 65031 | 65031 | 204644 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994179.89282 | 2090937.7889 | 37.7209831150476 | -122.46219354590099 | (37.7209831150476, -122.462193545901) | |||
| 103711 | 103711 | 39650 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 114 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41043 | 5994182.55528924 | 2090689.21166175 | 37.7203007349832 | -122.462166324336 | (37.7203007349832, -122.462166324336) | ||
| 139952 | 139952 | 39653 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 150 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41046 | 5994186.17432148 | 2090915.05015887 | 37.7209210416097 | -122.462170184545 | (37.7209210416097, -122.462170184545) | ||
| 107537 | 107537 | 39654 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 326 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | Permit Number 41047 | 5994205.8673586 | 2092067.47591786 | 37.7240864587641 | -122.46218564714898 | (37.7240864587641, -122.462185647149) | ||
| 158419 | 158419 | 204619 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1367 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5994238.00536 | 2106214.43805 | 37.762932317501004 | -122.463100533768 | (37.762932317501, -122.463100533768) | |||
| 170503 | 170503 | 204618 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1379 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5994241.53027 | 2106136.0721 | 37.7627173480462 | -122.463082656152 | (37.7627173480462, -122.463082656152) | |||
| 105338 | 105338 | 54365 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1426 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 10129 | 5994302.95595576 | 2105800.34386055 | 37.7617990637215 | -122.46284585058999 | (37.7617990637215, -122.46284585059) | |||
| 106992 | 106992 | 54367 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1434 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | Permit Number 10133 | 5994304.74891037 | 2105748.22696325 | 37.7616560675176 | -122.462835868431 | (37.7616560675176, -122.462835868431) | |||
| 109326 | 109326 | 54368 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10134 | 5994306.09362611 | 2105709.13929636 | 37.76154882037861 | -122.462828381839 | (37.7615488203786, -122.462828381839) | ||
| 92646 | 92646 | 54369 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1444 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 4x6 | Permit Number 10135 | 5994306.99010384 | 2105683.08083554 | 37.761477322240005 | -122.462823390787 | (37.76147732224, -122.462823390787) | ||
| 18373 | 18373 | 54772 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1446 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1972 12:00:00 AM | 4x5 | Permit Number 10621 | 5994307.43834186 | 2105670.05162948 | 37.7614415732371 | -122.46282089526899 | (37.7614415732371, -122.462820895269) | ||
| 82171 | 82171 | 46798 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 151 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44888 | 5994310.21524684 | 2095607.50798883 | 37.7338125312017 | -122.46208153607701 | (37.7338125312017, -122.462081536077) | ||
| 109661 | 109661 | 100285 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1426 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 10129 | 5994323.3 | 2105790.0 | 37.761771833907794 | -122.462774738749 | (37.7617718339078, -122.462774738749) | ||||
| 89747 | 89747 | 39705 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 95766 | 95766 | 39704 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 El Verano Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/1999 12:00:00 AM | Permit Number 41089 | 5994595.05199927 | 2094752.76443113 | 37.7314820102104 | -122.461034845634 | (37.7314820102104, -122.461034845634) | ||
| 90190 | 90190 | 59352 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 469 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1980 12:00:00 AM | 11 | 4x4 | Permit Number 18701 | 5994737.99829015 | 2091686.56057322 | 37.7230711817022 | -122.460318578759 | (37.7230711817022, -122.460318578759) | |
| 133067 | 133067 | 204658 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5994773.2638 | 2095284.74721 | 37.732952958415105 | -122.46045727068001 | (37.7329529584151, -122.46045727068) | |||
| 4156 | 4156 | 213178 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 629 Grafton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 08:23:00 AM | 3 | Width 3ft | Permit Number 20774 | 5994856.22066 | 2090552.89382 | 37.7199652039099 | -122.45982783161502 | (37.7199652039099, -122.459827831615) | |
| 117199 | 117199 | 51289 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 875 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47661 | 5995029.72941729 | 2089837.87433116 | 37.718011907210204 | -122.45917632673999 | (37.7180119072102, -122.45917632674) | |||
| 112096 | 112096 | 51290 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 738 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2004 12:00:00 AM | Permit Number 47662 | 5995079.16819472 | 2089446.39884805 | 37.716939850408394 | -122.458977110473 | (37.7169398504084, -122.458977110473) | |||
| 38724 | 38724 | 204643 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995381.41136 | 2092014.7979700002 | 37.7240094335681 | -122.458118187113 | (37.7240094335681, -122.458118187113) | |||
| 113716 | 113716 | 35090 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 122 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2003 12:00:00 AM | Permit Number 38632 | 5995399.98940883 | 2107075.75682232 | 37.7653641436682 | -122.459144031764 | (37.7653641436682, -122.459144031764) | ||
| 175753 | 175753 | 204641 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995679.43604 | 2091904.4278 | 37.7237235031239 | -122.45707998907601 | (37.7237235031239, -122.457079989076) | |||
| 54861 | 54861 | 204642 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5995680.91746 | 2091957.8181099999 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | |||
| 78376 | 78376 | 36468 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1469 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39366 | 5995883.06149021 | 2093810.4895036 | 37.728968784247705 | -122.456513863949 | (37.7289687842477, -122.456513863949) | ||
| 110193 | 110193 | 41345 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 733 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/2000 12:00:00 AM | Permit Number 41999 | 5995888.07123287 | 2089420.5370121002 | 37.716915305937796 | -122.4561792734 | (37.7169153059378, -122.4561792734) | |||
| 32795 | 32795 | 204648 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 733 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5995892.41562 | 2089491.7886299998 | 37.71711119551271 | -122.456169405709 | (37.7171111955127, -122.456169405709) | |||
| 144749 | 144749 | 16346 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 900X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996119.1686597 | 2094698.5315602 | 37.7314206866198 | -122.45576179592301 | (37.7314206866198, -122.455761795923) | ||
| 134307 | 134307 | 204647 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996124.76777 | 2089322.40375 | 37.716659439069794 | -122.455354045254 | (37.7166594390698, -122.455354045254) | |||
| 80412 | 80412 | 99239 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 940 Laguna Honda Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2012 12:00:00 AM | Permit Number 768814 | 5996167.3 | 2098870.1 | 37.7428775588654 | -122.45589685275 | (37.7428775588654, -122.45589685275) | ||||
| 121726 | 121726 | 106704 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 179 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5996189.7 | 2091071.1 | 37.7214646729593 | -122.45525590980199 | (37.7214646729593, -122.455255909802) | |||
| 80689 | 80689 | 106706 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199X BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | |||
| 146237 | 146237 | 41633 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42113 | 5996241.92564567 | 2113793.75965037 | 37.7838583861175 | -122.456717884501 | (37.7838583861175, -122.456717884501) | |||
| 61227 | 61227 | 140862 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100 Jordan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5996243.3642 | 2113769.3144 | 37.783791348572706 | -122.456711139169 | (37.7837913485727, -122.456711139169) | |||
| 115519 | 115519 | 46180 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 321 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2001 12:00:00 AM | Permit Number 44508 | 5996626.00544099 | 2106611.60599874 | 37.7641601102413 | -122.45487001246599 | (37.7641601102413, -122.454870012466) | ||
| 10145 | 10145 | 173881 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996703.0 | 2107106.0 | 37.7655220059747 | -122.45463943175601 | (37.7655220059747, -122.454639431756) | ||||
| 75181 | 75181 | 66828 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 154 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1992 12:00:00 AM | 5 | Permit Number 30314 | 5996849.4776 | 2111929.315 | 37.7787739785332 | -122.454481262068 | (37.7787739785332, -122.454481262068) | |
| 4201 | 4201 | 252891 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:13:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4203 | 4203 | 252894 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:10:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4213 | 4213 | 252892 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:08:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4246 | 4246 | 252893 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300x Howth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 04:25:00 PM | 3 | 3x3 | 5997131.0 | 2090234.0 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | ||
| 4212 | 4212 | 204652 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:45:00 PM | 3 | Width 3ft | 5997137.29551 | 2090290.56774 | 37.719375836806705 | -122.45192406695601 | (37.7193758368067, -122.451924066956) | ||
| 106583 | 106583 | 46402 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 324 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | Permit Number 44632 | 5997151.20329152 | 2090327.07955038 | 37.7194768863059 | -122.451878625824 | (37.7194768863059, -122.451878625824) | ||
| 4291 | 4291 | 252895 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 790x Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:29:00 PM | 3 | 3x3 | 5997282.0 | 2090432.0 | 37.719772464034904 | -122.45143407539 | (37.7197724640349, -122.45143407539) | ||
| 181555 | 181555 | 204650 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 254 Howth St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5997292.004269999 | 2090577.4247599998 | 37.720172339354704 | -122.451409977591 | (37.7201723393547, -122.451409977591) | |||
| 43337 | 43337 | 204651 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 27 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.45097974552401 | (37.7179774953307, -122.450979745524) | |||
| 13269 | 13269 | 187626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 298x Molimo Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5997428.0 | 2096652.0 | 37.7368594694916 | -122.451377782024 | (37.7368594694916, -122.451377782024) | ||||
| 72610 | 72610 | 204630 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 304 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5997471.23605 | 2094490.2943 | 37.7309264189197 | -122.45107245665501 | (37.7309264189197, -122.451072456655) | |||
| 188602 | 188602 | 204669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997556.3797699995 | 2095278.95948 | 37.7330967797945 | -122.45083494657 | (37.7330967797945, -122.45083494657) | |||
| 67823 | 67823 | 246058 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 610 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997562.1198 | 2108443.0956 | 37.769242567665295 | -122.451764409004 | (37.7692425676653, -122.451764409004) | |||
| 41865 | 41865 | 204668 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997569.23018 | 2095279.46651 | 37.7330989075946 | -122.45079055604499 | (37.7330989075946, -122.450790556045) | |||
| 63204 | 63204 | 204667 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997581.48097 | 2095279.2111 | 37.7330989075759 | -122.45074818359899 | (37.7330989075759, -122.450748183599) | |||
| 73619 | 73619 | 248397 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 710 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997610.5725 | 2108098.1732 | 37.7682982739336 | -122.451571931383 | (37.7682982739336, -122.451571931383) | |||
| 63668 | 63668 | 175754 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997730.99268 | 2086963.4604 | 37.7102743532383 | -122.449632264321 | (37.7102743532383, -122.449632264321) | |||
| 7114 | 7114 | 45767 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997811.6954 | 2113198.143 | 37.782312986330794 | -122.45124412099399 | (37.7823129863308, -122.451244120994) |
| 7399 | 7399 | 45765 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 99 Blake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44690 | 5997815.0796 | 2113173.4382 | 37.782245347199996 | -122.451230630986 | (37.7822453472, -122.451230630986) |
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");