Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19435 | 19435 | 16276 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 690 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5997552.36845 | 2094747.2906 | 37.7316367142582 | -122.45081049312799 | (37.7316367142582, -122.450810493128) | |||
| 97792 | 97792 | 89263 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775142 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | |
| 108143 | 108143 | 110651 | Section 143 8 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 127 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 5999845.0 | 2108967.0 | 37.770811558248 | -122.44390571748998 | (37.770811558248, -122.44390571749) | |||
| 22300 | 22300 | 248974 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 716 Goettingen St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010713.0 | 2091306.0 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | ||||
| 78854 | 78854 | 101901 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Ocean Ave | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) | ||||
| 7743 | 7743 | 121449 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1274 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 10x6 | 6006927.94593 | 2119481.89109 | 37.800084349978 | -122.420151970562 | (37.800084349978, -122.420151970562) | |||
| 11570 | 11570 | 174950 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 309 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987294.0 | 2096147.0 | 37.7348873783654 | -122.486377975564 | (37.7348873783654, -122.486377975564) | ||||
| 80217 | 80217 | 92320 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2733 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2008 12:00:00 AM | 3 | 3x3 | 5984522.0 | 2096783.0 | 37.736471699686206 | -122.49600850837099 | (37.7364716996862, -122.496008508371) | |
| 89532 | 89532 | 112366 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2224 Baker St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 775823 | 5999858.5 | 2116547.8 | 37.791627252722 | -122.444403911295 | (37.791627252722, -122.444403911295) | |||
| 96972 | 96972 | 120593 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 499x Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 34 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | |||
| 99263 | 99263 | 101435 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 102016 | 102016 | 105368 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 180 CLIFFORD TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999283.1 | 2106587.2 | 37.7642451591147 | -122.44567816768298 | (37.7642451591147, -122.445678167683) | ||||||
| 105471 | 105471 | 101436 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 106295 | 106295 | 113380 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 63 Potomac St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4x4 | Permit Number 776311 | 6003081.0 | 2108682.5 | 37.7702144463181 | -122.432692008068 | (37.7702144463181, -122.432692008068) | |||
| 117761 | 117761 | 101439 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 123027 | 123027 | 101440 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 128404 | 128404 | 101438 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 600X Grant Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010995.6 | 2116632.0 | 37.7924875884206 | -122.40587538693701 | (37.7924875884206, -122.405875386937) | |||||
| 1081 | 1081 | 3617 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.742454020638796 | -122.380579893948 | (37.7424540206388, -122.380579893948) | ||
| 2640 | 2640 | 183247 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2890 Rivera St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984262.8939 | 2100232.1038 | 37.7459268239815 | -122.49715885534201 | (37.7459268239815, -122.497158855342) | |
| 2648 | 2648 | 183237 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2001 37th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984780.1717 | 2100543.2827 | 37.7468115375468 | -122.495393151852 | (37.7468115375468, -122.495393151852) | |
| 2656 | 2656 | 183240 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2001 37th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984790.3243 | 2100348.3517 | 37.7462769046122 | -122.495343672098 | (37.7462769046122, -122.495343672098) | |
| 2668 | 2668 | 183245 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2706 Rivera St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984600.1313 | 2100244.4562 | 37.745980498085295 | -122.495993663284 | (37.7459804980853, -122.495993663284) | |
| 2672 | 2672 | 183250 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2107 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780393 | 5984200.2859 | 2100804.8827 | 37.7474958486327 | -122.497417620086 | (37.7474958486327, -122.497417620086) | |
| 22313 | 22313 | 3602 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.4470599997 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | ||
| 22341 | 22341 | 3629 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017712.663240001 | 2098437.04484 | 37.7429014981049 | -122.38136811194201 | (37.7429014981049, -122.381368111942) | |||
| 22348 | 22348 | 3623 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.7555299997 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | ||
| 93974 | 93974 | 121246 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 94513 | 94513 | 121248 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 100736 | 100736 | 121249 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 109183 | 109183 | 105072 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 88X PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5x6 | 6007074.0 | 2099135.0 | 37.7442248567037 | -122.41820321383699 | (37.7442248567037, -122.418203213837) | |||
| 113673 | 113673 | 121247 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
| 139890 | 139890 | 9241 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6442 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/1993 12:00:00 AM | 6 | 3x3 | 5986987.758640001 | 2112604.7127900003 | 37.7800579063209 | -122.488646014596 | (37.7800579063209, -122.488646014596) | ||
| 140147 | 140147 | 121245 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 145570 | 145570 | 104552 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 STARVIEW WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5997447.0 | 2102183.0 | 37.752047331058705 | -122.45171095800501 | (37.7520473310587, -122.451710958005) | |||
| 224 | 224 | 117019 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008121.68381 | 2113004.40875 | 37.782365960952 | -122.41556230388201 | (37.782365960952, -122.415562303882) | |
| 5296 | 5296 | 117021 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008114.19003 | 2113031.70239 | 37.7824404814865 | -122.415590162171 | (37.7824404814865, -122.415590162171) | |
| 5744 | 5744 | 117020 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008118.25915 | 2113018.6658799998 | 37.7824049150971 | -122.41557516146601 | (37.7824049150971, -122.415575161466) | |
| 5966 | 5966 | 117017 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008130.7573 | 2112963.51283 | 37.7822541806174 | -122.415528017206 | (37.7822541806174, -122.415528017206) | |
| 6755 | 6755 | 117018 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 168 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008125.664580001 | 2112987.05621 | 37.78231853881321 | -122.415547303188 | (37.7823185388132, -122.415547303188) | |
| 23422 | 23422 | 54948 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1531 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/28/1972 12:00:00 AM | 15 | 6x3 | Permit Number 779312 | 5982470.8167 | 2104681.2673 | 37.758037793894204 | -122.503684942327 | (37.7580377938942, -122.503684942327) | |
| 97256 | 97256 | 94315 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 399X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777550 | 6008122.0 | 2112982.0 | 37.7823044496932 | -122.415559622955 | (37.7823044496932, -122.415559622955) | |
| 140550 | 140550 | 116849 | Planning Code 138.1 required 4 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 83 Panorama Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 124 | 124 | 20281 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 20X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 140 | 140 | 6337 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1916 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001700.9234 | 2112915.307 | 37.7817583075946 | -122.437768878541 | (37.7817583075946, -122.437768878541) | |||
| 148 | 148 | 175046 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 3ft | 5991566.54873 | 2087591.2585200001 | 37.7116435395983 | -122.47098334961399 | (37.7116435395983, -122.470983349614) | |||
| 173 | 173 | 175044 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 3ft | 5991568.948890001 | 2087568.2224599998 | 37.7115804269636 | -122.470973377029 | (37.7115804269636, -122.470973377029) | |||
| 196 | 196 | 251246 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | ||||
| 218 | 218 | 11423 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | |||
| 222 | 222 | 251247 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 722X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6016169.292972799 | 2097000.9113916 | 37.738872842648796 | -122.38660458641 | (37.7388728426488, -122.38660458641) | ||||
| 242 | 242 | 194017 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 717 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 4ft | 6016141.23024 | 2096883.95841 | 37.7385501598741 | -122.386693461838 | (37.7385501598741, -122.386693461838) | |||
| 244 | 244 | 9908 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.79042290624211 | -122.425793311632 | (37.7904229062421, -122.425793311632) | |||
| 275 | 275 | 818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1385 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 5982124.8821 | 2105687.3873 | 37.7607799675436 | -122.504955867812 | (37.7607799675436, -122.504955867812) | |||
| 447 | 447 | 27524 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999021.2149 | 2114925.4479 | 37.787124893549795 | -122.447184087894 | (37.7871248935498, -122.447184087894) | |||
| 475 | 475 | 6052 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1900 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2003 12:00:00 AM | 3 | 3X3 | 6001270.4508 | 2112511.2313 | 37.7806243318768 | -122.439229137442 | (37.7806243318768, -122.439229137442) | ||
| 497 | 497 | 14419 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998835.1676 | 2113089.5942 | 37.7820734871416 | -122.447695558807 | (37.7820734871416, -122.447695558807) | ||||
| 704 | 704 | 2199 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1100 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000885.4114 | 2112518.5919999997 | 37.7806226245627 | -122.440561697516 | (37.7806226245627, -122.440561697516) | |||
| 738 | 738 | 20446 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 495X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
| 811 | 811 | 175379 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 5991355.5778 | 2088944.15197 | 37.7153460520673 | -122.47181104966499 | (37.7153460520673, -122.471811049665) | |||
| 822 | 822 | 177714 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80X Junipero Serra Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 4ft | 5991271.7328699995 | 2089255.2484 | 37.7161953951732 | -122.472123514597 | (37.7161953951732, -122.472123514597) | |||
| 848 | 848 | 2190 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1055 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000864.0909 | 2112351.4116 | 37.7801623757286 | -122.44062346036199 | (37.7801623757286, -122.440623460362) | |||
| 1071 | 1071 | 177641 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 4ft | 5996637.80016 | 2086397.8441299999 | 37.708658698704795 | -122.45336973165199 | (37.7086586987048, -122.453369731652) | |||
| 1141 | 1141 | 251461 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/1993 12:00:00 AM | 3x3 | 5987191.0 | 2112582.0 | 37.7800074013317 | -122.48794125088699 | (37.7800074013317, -122.487941250887) | |||
| 1245 | 1245 | 6073 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1944 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001125.2679 | 2112488.2186 | 37.7805528822601 | -122.439729742976 | (37.7805528822601, -122.439729742976) | |||
| 1352 | 1352 | 8658 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2807 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/20/1994 12:00:00 AM | 6 | 3X3 | 5998399.1111 | 2113100.5929 | 37.7820787552534 | -122.44920490204599 | (37.7820787552534, -122.449204902046) | ||
| 1497 | 1497 | 20382 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 262X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 1538 | 1538 | 3145 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998356.8929 | 2114831.5358 | 37.7868290555036 | -122.449475716773 | (37.7868290555036, -122.449475716773) | |||
| 1542 | 1542 | 6967 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 720 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003956.4801 | 2110455.6856 | 37.7751327920886 | -122.42979022245899 | (37.7751327920886, -122.429790222459) | |||
| 1606 | 1606 | 8736 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3240 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1986 12:00:00 AM | 3 | 3X3 | 5997038.8246 | 2113016.8335 | 37.781770875875004 | -122.45390479883801 | (37.781770875875, -122.453904798838) | ||
| 1653 | 1653 | 14428 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 12 | 5998837.5365 | 2113112.2684 | 37.782135879985205 | -122.447688996293 | (37.7821358799852, -122.447688996293) | |||
| 1760 | 1760 | 14433 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998837.1981 | 2113100.4237 | 37.7821033381799 | -122.447689314061 | (37.7821033381799, -122.447689314061) | |||
| 1794 | 1794 | 81999 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005960.45556 | 2120727.0973099996 | 37.803448808170295 | -122.423588442877 | (37.8034488081703, -122.423588442877) |
| 1953 | 1953 | 10672 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1099X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002688.4855 | 2110577.4857 | 37.775395340044 | -122.43418520195 | (37.775395340044, -122.43418520195) | |||
| 1976 | 1976 | 8649 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2800 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998323.3892 | 2113195.774 | 37.7823357663321 | -122.449473724518 | (37.7823357663321, -122.449473724518) | |||
| 2067 | 2067 | 252866 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
| 2075 | 2075 | 252867 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
| 2083 | 2083 | 252865 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1660 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000023.0 | 2106990.0 | 37.7653933634599 | -122.443148003218 | (37.7653933634599, -122.443148003218) | ||||
| 2125 | 2125 | 117673 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7600x Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983555.0 | 2112529.0 | 37.779649107322506 | -122.50051568716002 | (37.7796491073225, -122.50051568716) | |||
| 2128 | 2128 | 114975 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 5982783.76519 | 2112486.06679 | 37.7794859217892 | -122.50318049806101 | (37.7794859217892, -122.503180498061) | |||
| 2138 | 2138 | 113191 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 11:27:00 AM | 3 | 3X3 | 5982732.526959999 | 2112491.91452 | 37.7794989659934 | -122.50335818303499 | (37.7794989659934, -122.503358183035) | ||
| 2145 | 2145 | 113190 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 25 Point Lobos Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 11:22:00 AM | 3 | 3X3 | 5982767.26188 | 2112487.6869200002 | 37.7794894001028 | -122.503237709063 | (37.7794894001028, -122.503237709063) | ||
| 2499 | 2499 | 8641 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999196.602000001 | 2113264.8967 | 37.7825754726316 | -122.446457780402 | (37.7825754726316, -122.446457780402) | |||
| 2559 | 2559 | 19580 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100 STAIRWAY4 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 8 | ||||||||
| 2845 | 2845 | 2651 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1958 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004155.6542 | 2114999.6285 | 37.787620606441294 | -122.429425346374 | (37.7876206064413, -122.429425346374) | |||
| 2851 | 2851 | 18919 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2645 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002161.66396 | 2115714.10413 | 37.7894692786198 | -122.43637530499201 | (37.7894692786198, -122.436375304992) | |||
| 2967 | 2967 | 90257 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3230 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5985539.08481 | 2111145.48476 | 37.775966641531504 | -122.49355000935199 | (37.7759666415315, -122.493550009352) | ||
| 3175 | 3175 | 10515 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1801 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/23/2017 12:00:00 AM | 3 | 3X3 | 5997497.7686 | 2108463.8393 | 37.7692958388006 | -122.451988492124 | (37.7692958388006, -122.451988492124) | ||
| 3381 | 3381 | 8153 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1052 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002732.6953 | 2111326.1234 | 37.777453421805895 | -122.434085798199 | (37.7774534218059, -122.434085798199) | |||
| 3426 | 3426 | 8640 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5999291.3601 | 2113278.772 | 37.782618982387596 | -122.446130957827 | (37.7826189823876, -122.446130957827) | |||
| 3529 | 3529 | 6070 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1930 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 11:12:00 AM | 3 | 3X3 | 6001158.0948 | 2112492.6181 | 37.78056683058671 | -122.43961649489799 | (37.7805668305867, -122.439616494898) | ||
| 3807 | 3807 | 90290 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4825X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980449.0 | 2110794.0 | 37.7747024934985 | -122.51113148443301 | (37.7747024934985, -122.511131484433) | ||
| 3910 | 3910 | 14420 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 5998841.5976 | 2113071.3194 | 37.7820236767836 | -122.44767199806299 | (37.7820236767836, -122.447671998063) | ||||
| 3911 | 3911 | 11896 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 603 Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/04/2017 12:00:00 AM | 3 | 3x3 | 6017299.30184 | 2096353.9074400002 | 37.7371587926313 | -122.382652493121 | (37.7371587926313, -122.382652493121) | ||
| 4039 | 4039 | 3143 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3333 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5998281.9325 | 2114822.5676 | 37.7868001428071 | -122.449734414591 | (37.7868001428071, -122.449734414591) | |||
| 4170 | 4170 | 6079 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1968 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001023.7414 | 2112472.9897 | 37.780505288271705 | -122.44007987815701 | (37.7805052882717, -122.440079878157) | |||
| 4225 | 4225 | 6366 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2072 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000952.842 | 2112811.2423 | 37.7814300071208 | -122.44034941736601 | (37.7814300071208, -122.440349417366) | |||
| 4323 | 4323 | 5070 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5549 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001778.0 | 2097299.0 | 37.738884107486 | -122.43638423012699 | (37.738884107486, -122.436384230127) | |||
| 4641 | 4641 | 177599 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2901 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 2ft | 5997064.2298099995 | 2087562.19472 | 37.7118801719014 | -122.451979889667 | (37.7118801719014, -122.451979889667) | |||
| 4647 | 4647 | 177597 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2969 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | Width 2ft | 5996885.021480001 | 2087397.68975 | 37.7114182126546 | -122.45258741589399 | (37.7114182126546, -122.452587415894) |
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");