Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6655 | 6655 | 20047 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 8287 | 8287 | 47845 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 8319 | 8319 | 47848 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12078 | 12078 | 47847 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12229 | 12229 | 47849 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 12714 | 12714 | 47846 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 13145 | 13145 | 19899 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY33 | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 15056 | 15056 | 20048 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 100 STAIRWAY52 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 16207 | 16207 | 47844 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 8250on Geary 47th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2002 12:00:00 AM | Permit Number 45605 | ||||||||
| 24192 | 24192 | 183253 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1300 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5980913.074 | 2106102.483 | 37.7618483320506 | -122.50917772189 | (37.7618483320506, -122.50917772189) | |||
| 82212 | 82212 | 31943 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1300 La Playa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767126 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807626999 | (37.761983899941, -122.50916807627) | |
| 169531 | 169531 | 183629 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1444 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5980944.3903 | 2105213.8422 | 37.759410226416605 | -122.50900342590599 | (37.7594102264166, -122.509003425906) | |||
| 28613 | 28613 | 184182 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1618 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5980983.7076 | 2104008.48 | 37.756102964650104 | -122.508777956978 | (37.7561029646501, -122.508777956978) | |||
| 136540 | 136540 | 31944 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4739X Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767126 | 5980987.9788 | 2106187.281 | 37.7620855787641 | -122.508924957063 | (37.7620855787641, -122.508924957063) |
| 122323 | 122323 | 115419 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4219 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 772533 | 5981156.8 | 2104128.1 | 37.756441608477296 | -122.508188234142 | (37.7564416084773, -122.508188234142) | ||
| 57115 | 57115 | 119235 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4647 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5981157.67824 | 2110250.28621 | 37.773251411671 | -122.508639693004 | (37.773251411671, -122.508639693004) | |||
| 23036 | 23036 | 11607 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4300 Judah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 5981158.1048 | 2105571.7891 | 37.7604056423858 | -122.50829087908899 | (37.7604056423858, -122.508290879089) | |||
| 158911 | 158911 | 184170 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4218 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5981166.9182 | 2104206.8099 | 37.7566583196438 | -122.508159084297 | (37.7566583196438, -122.508159084297) | |||
| 144796 | 144796 | 96911 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4300 JUDAH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981169.0 | 2105631.0 | 37.7605688605658 | -122.508257593382 | (37.7605688605658, -122.508257593382) | ||
| 23180 | 23180 | 11605 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4300 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 5981172.9444 | 2105571.7891 | 37.7604065168831 | -122.50823955670201 | (37.7604065168831, -122.508239556702) | |||
| 141699 | 141699 | 90728 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 4641 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2008 12:00:00 AM | 3 | 3x3 | 5981176.26351 | 2110250.76808 | 37.773253830158296 | -122.50857544098 | (37.7732538301583, -122.50857544098) | ||
| 148892 | 148892 | 81429 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1307-1307 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50178 | 5981179.1276 | 2106140.2888 | 37.7619678179525 | -122.508260370564 | (37.7619678179525, -122.508260370564) | |
| 28157 | 28157 | 181439 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1395 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981197.3238 | 2105634.1509 | 37.760579181106 | -122.50815986988 | (37.760579181106, -122.50815986988) | |||
| 61741 | 61741 | 181440 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1397 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981198.3838 | 2105604.1183 | 37.7604967826741 | -122.50815397475701 | (37.7604967826741, -122.508153974757) | |||
| 94939 | 94939 | 96910 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1399X 48TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2011 12:00:00 AM | 3x3 | Permit Number 768110 | 5981210.0 | 2105881.0 | 37.7612577047615 | -122.50813435133699 | (37.7612577047615, -122.508134351337) | ||
| 82745 | 82745 | 89549 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5601 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5981225.68793 | 2111616.8451900003 | 37.7770075886204 | -122.508505908708 | (37.7770075886204, -122.508505908708) | ||
| 132345 | 132345 | 181604 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1334 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5981230.182999999 | 2105961.3297 | 37.7614794563055 | -122.50807051030701 | (37.7614794563055, -122.508070510307) | |||
| 147646 | 147646 | 184409 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2090 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981245.0175 | 2100827.8954 | 37.747385378290794 | -122.507638275392 | (37.7473853782908, -122.507638275392) | |||
| 35966 | 35966 | 31941 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1426 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | 2 | 3x3 | Permit Number 775192 | 5981251.0367 | 2105333.6511 | 37.7597572598559 | -122.50795180273701 | (37.7597572598559, -122.507951802737) | |
| 109350 | 109350 | 115433 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2080 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777503 | 5981258.2 | 2100920.3 | 37.7476398719767 | -122.507599547529 | (37.7476398719767, -122.507599547529) | ||
| 121468 | 121468 | 115243 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 625 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | Permit Number 775511 | 5981292.5 | 2111469.1 | 37.776605861396796 | -122.50826381996201 | (37.7766058613968, -122.508263819962) | |||
| 25511 | 25511 | 119143 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 625 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5981300.41517 | 2111472.41115 | 37.776615419273895 | -122.508236685403 | (37.7766154192739, -122.508236685403) | |||
| 76825 | 76825 | 118852 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 518 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5981326.91116 | 2112159.5022400003 | 37.778503529778106 | -122.508196040224 | (37.7785035297781, -122.508196040224) | |||
| 130447 | 130447 | 118853 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 522 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5981329.7531 | 2112134.5531200003 | 37.778435194344894 | -122.50818435675899 | (37.7784351943449, -122.508184356759) | |||
| 69327 | 69327 | 118499 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5981338.204609999 | 2112298.18891 | 37.778884987819204 | -122.508167268986 | (37.7788849878192, -122.508167268986) | ||||
| 65517 | 65517 | 118496 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5981338.85751 | 2112308.63433 | 37.778913706323294 | -122.508165785879 | (37.7789137063233, -122.508165785879) | ||||
| 43770 | 43770 | 184492 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1834 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5981345.8672 | 2102562.8148 | 37.7521549190758 | -122.50741825242399 | (37.7521549190758, -122.507418252424) | |||
| 147638 | 147638 | 118498 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5981347.002859999 | 2112298.64035 | 37.7788867457895 | -122.508136866402 | (37.7788867457895, -122.508136866402) | ||||
| 52961 | 52961 | 68991 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1882 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1994 12:00:00 AM | 2 | Permit Number 32984 | 5981356.0199 | 2102264.6652 | 37.7513368825607 | -122.507361024926 | (37.7513368825607, -122.507361024926) | |
| 61119 | 61119 | 118495 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5981356.12189 | 2112314.02701 | 37.7789295303469 | -122.50810646292601 | (37.7789295303469, -122.508106462926) | ||||
| 158457 | 158457 | 118497 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5981364.20395 | 2112299.23238 | 37.7788893849054 | -122.50807740600901 | (37.7788893849054, -122.508077406009) | ||||
| 161637 | 161637 | 118494 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5981369.73448 | 2112312.23583 | 37.778925414411 | -122.508059239406 | (37.778925414411, -122.508059239406) | ||||
| 40245 | 40245 | 119163 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 879 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5981371.77833 | 2109760.61565 | 37.7719195366042 | -122.50786275896401 | (37.7719195366042, -122.507862758964) | |||
| 3033 | 3033 | 253285 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 5981372.0 | 2112274.0 | 37.7788205636315 | -122.50804856364901 | (37.7788205636315, -122.508048563649) | |||
| 131294 | 131294 | 118493 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5981395.17159 | 2112311.03986 | 37.7789236294482 | -122.507971155072 | (37.7789236294482, -122.507971155072) | ||||
| 118331 | 118331 | 107701 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1233 47TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | 5981397.7 | 2106680.5 | 37.7634639604224 | -122.50754451241998 | (37.7634639604224, -122.50754451242) | ||
| 132819 | 132819 | 80000 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 4 | 5981404.80446 | 2112378.67743 | 37.7791099097712 | -122.50794285274799 | (37.7791099097712, -122.507942852748) | ||
| 159866 | 159866 | 118492 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8245 Geary Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5981407.0833 | 2112311.43925 | 37.7789254278995 | -122.50792997809401 | (37.7789254278995, -122.507929978094) | ||||
| 46873 | 46873 | 68303 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2110 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/17/2012 12:00:00 AM | 1 | Permit Number 771923 | 5981408.8137 | 2100678.9898 | 37.746986173397104 | -122.507060845065 | (37.7469861733971, -122.507060845065) | |
| 32698 | 32698 | 92457 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2174 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52847 | 5981421.6737 | 2100290.4816 | 37.7459201959872 | -122.506987562585 | (37.7459201959872, -122.506987562585) |
| 147930 | 147930 | 184427 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3831 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981442.6558 | 2100756.8268 | 37.747201885059795 | -122.506949596938 | (37.7472018850598, -122.506949596938) | |||
| 168504 | 168504 | 183168 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2418 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981479.3746 | 2098586.5278 | 37.7412450111598 | -122.506661689382 | (37.7412450111598, -122.506661689382) | |||
| 60813 | 60813 | 183352 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2436 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981481.0667 | 2098537.4567 | 37.74111037515829 | -122.506652200233 | (37.7411103751583, -122.506652200233) | |||
| 88738 | 88738 | 84911 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 5546 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2007 12:00:00 AM | Permit No. 49266 | 5981488.0 | 2111676.0 | 37.77718546664779 | -122.507602896513 | (37.7771854666478, -122.507602896513) | |||
| 132558 | 132558 | 118546 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8200 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5981504.47396 | 2112382.5378099997 | 37.779126381287796 | -122.507598347938 | (37.7791263812878, -122.507598347938) | |||
| 54688 | 54688 | 118545 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8200 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5981515.94799 | 2112382.29163 | 37.779126381281294 | -122.50755863701201 | (37.7791263812813, -122.507558637012) | |||
| 125803 | 125803 | 31637 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2550 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3x3 | Permit Number 767125 | 5981518.05011446 | 2097722.76963447 | 37.7388756474124 | -122.506463924771 | (37.7388756474124, -122.506463924771) | |
| 135202 | 135202 | 118544 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8200 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5981537.23315 | 2112382.31128 | 37.7791276891 | -122.507485005709 | (37.7791276891, -122.507485005709) | |||
| 162186 | 162186 | 118543 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5981552.70606 | 2112382.65114 | 37.7791295337039 | -122.50743150476002 | (37.7791295337039, -122.50743150476) | |||
| 163623 | 163623 | 118542 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 8200 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5981567.00274 | 2112382.91126 | 37.77913109005671 | -122.50738206688 | (37.7791310900567, -122.50738206688) | |||
| 182756 | 182756 | 37118 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4542 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 3 | Permit Number 39708 | 5981571.384 | 2106261.3364 | 37.762323287691395 | -122.506912711859 | (37.7623232876914, -122.506912711859) | |
| 70514 | 70514 | 184281 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1506 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981580.1873 | 2104776.831 | 37.7582477792129 | -122.50677215276501 | (37.7582477792129, -122.506772152765) | |||
| 122158 | 122158 | 184263 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1518 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981581.4096 | 2104729.1637 | 37.7581169703786 | -122.50676439010701 | (37.7581169703786, -122.506764390107) | |||
| 68358 | 68358 | 81810 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1851 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51110 | 5981613.2204 | 2102489.0388 | 37.7519680958666 | -122.50648824957199 | (37.7519680958666, -122.506488249572) | |
| 80593 | 80593 | 90921 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5500 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/25/2008 12:00:00 AM | 3 | 3x3 | 5981624.853792 | 2111676.361838 | 37.777194521305496 | -122.50712951089399 | (37.7771945213055, -122.507129510894) | |
| 98076 | 98076 | 90920 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5500 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/25/2008 12:00:00 AM | 3 | 3x3 | 5981624.853792 | 2111676.361838 | 37.777194521305496 | -122.50712951089399 | (37.7771945213055, -122.507129510894) | |
| 72291 | 72291 | 118632 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 349 Point Lobos Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5981625.79815 | 2112645.61268 | 37.779855853566104 | -122.507198167376 | (37.7798558535661, -122.507198167376) | |||
| 75715 | 75715 | 118633 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 349 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5981626.779 | 2112628.37676 | 37.7798085866006 | -122.507193495207 | (37.7798085866006, -122.507193495207) | |||
| 46687 | 46687 | 92491 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4626 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52861 | 5981634.7827 | 2098098.5099 | 37.739914198678704 | -122.50608817681001 | (37.7399141986787, -122.50608817681) |
| 57054 | 57054 | 118844 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 574 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5981649.86535 | 2111848.08621 | 37.7776674988947 | -122.50705573137199 | (37.7776674988947, -122.507055731372) | |||
| 42085 | 42085 | 118832 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 650 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981668.99425 | 2111312.2373200003 | 37.7761973421342 | -122.506949801153 | (37.7761973421342, -122.506949801153) | |||
| 62769 | 62769 | 118833 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 650 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5981669.33859 | 2111307.2969 | 37.776183797471795 | -122.50694824345501 | (37.7761837974718, -122.506948243455) | |||
| 180575 | 180575 | 31649 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3626 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 4 | Permit Number 35159 | 5981671.4718 | 2097426.2101 | 37.738070408504896 | -122.505911492367 | (37.7380704085049, -122.505911492367) | |
| 48086 | 48086 | 83924 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1922 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50175 | 5981674.643999999 | 2101978.1911 | 37.750569068257604 | -122.50623796514601 | (37.7505690682576, -122.506237965146) | |
| 47520 | 47520 | 92494 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3620 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52864 | 5981698.329 | 2097425.7769 | 37.7380707998658 | -122.505818603166 | (37.7380707998658, -122.505818603166) |
| 147386 | 147386 | 184367 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2247 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981705.6881 | 2099795.5177 | 37.7445778853148 | -122.505968805958 | (37.7445778853148, -122.505968805958) | |||
| 92494 | 92494 | 92495 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3626 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/2009 12:00:00 AM | 3x3 | Permit Number 52865 | 5981730.0 | 2097424.0 | 37.7380677850415 | -122.505708970967 | (37.7380677850415, -122.505708970967) | |
| 71327 | 71327 | 184370 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2262 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981754.738 | 2099684.4742 | 37.744275877842895 | -122.505790973543 | (37.7442758778429, -122.505790973543) | |||
| 169416 | 169416 | 183302 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 4500 Irving St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5981770.8567 | 2106269.7 | 37.7623579967214 | -122.506223442565 | (37.7623579967214, -122.506223442565) | |||
| 5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
| 31716 | 31716 | 184418 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3717 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981908.8319 | 2100773.9171 | 37.7472762530428 | -122.505338890407 | (37.7472762530428, -122.505338890407) | |||
| 77886 | 77886 | 39818 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2101 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | |||
| 88355 | 88355 | 39819 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2101 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | |||
| 127302 | 127302 | 39820 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 2101 46th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/1999 12:00:00 AM | Permit Number 41148 | 5981978.01419846 | 2100783.80216684 | 37.7473074654157 | -122.505100399713 | (37.7473074654157, -122.505100399713) | |||
| 57482 | 57482 | 80573 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4133 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50192 | 5982001.0954 | 2104861.9293 | 37.758506211630795 | -122.505322801103 | (37.7585062116308, -122.505322801103) | |
| 155582 | 155582 | 64317 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 846 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1988 12:00:00 AM | 7 | Permit Number 25135 | 5982027.09526 | 2109990.6128 | 37.7725896300025 | -122.505613061298 | (37.7725896300025, -122.505613061298) | ||
| 106660 | 106660 | 88115 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 4133 Kirkham St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2008 12:00:00 AM | 3x3 | Permit Number 51116 | 5982072.0 | 2104866.0 | 37.758521560647395 | -122.505077887073 | (37.7585215606474, -122.505077887073) | |||
| 176564 | 176564 | 183150 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2322 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982078.212 | 2099262.187 | 37.7431354277951 | -122.504641206621 | (37.7431354277951, -122.504641206621) | |||
| 65060 | 65060 | 65389 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1337 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767119 | 5982116.3204 | 2105935.2005 | 37.76145988813111 | -122.50500384323 | (37.7614598881311, -122.50500384323) |
| 168327 | 168327 | 95232 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1337 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767119 | 5982117.2717 | 2105915.2232 | 37.761405092140606 | -122.504999072655 | (37.7614050921406, -122.504999072655) |
| 105142 | 105142 | 109257 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1529 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773445 | 5982142.3 | 2104666.9 | 37.7579790245493 | -122.504820009244 | (37.7579790245493, -122.504820009244) |
| 24542 | 24542 | 38375 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 3809 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | 2 | Permit Number 40434 | 5982171.278 | 2102815.4467 | 37.7528971616744 | -122.50458262013201 | (37.7528971616744, -122.504582620132) | |
| 119950 | 119950 | 89554 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5301X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982173.17195 | 2111648.65895 | 37.7771507360561 | -122.50523068261002 | (37.7771507360561, -122.50523068261) | ||
| 105926 | 105926 | 89542 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5300X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5982175.49645 | 2111704.48875 | 37.777304165081794 | -122.50522678034599 | (37.7773041650818, -122.505226780346) | ||
| 56633 | 56633 | 184398 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3622 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982186.507 | 2100840.0786 | 37.7474742497587 | -122.50438362747299 | (37.7474742497587, -122.504383627473) | |||
| 103482 | 103482 | 89555 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5301X Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982189.04125 | 2111648.71892 | 37.7771518344652 | -122.505175791066 | (37.7771518344652, -122.505175791066) | ||
| 40721 | 40721 | 184261 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1520 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5982200.8549 | 2104752.6154 | 37.7582178192579 | -122.50462385574 | (37.7582178192579, -122.50462385574) | |||
| 69259 | 69259 | 184260 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1520 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5982201.466 | 2104736.4208 | 37.758173389430205 | -122.504620542455 | (37.7581733894302, -122.504620542455) | |||
| 130868 | 130868 | 38343 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1642 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 6 | Permit Number 40410 | 5982231.0624 | 2103923.0719 | 37.755941904631 | -122.504457930287 | (37.755941904631, -122.504457930287) | |
| 146522 | 146522 | 119032 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 745 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5982268.98317 | 2110662.29991 | 37.774448119755 | -122.504826140687 | (37.774448119755, -122.504826140687) |
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");