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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93132 | 93132 | 13300 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 168 LUNADO CT | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 3 | 15 | 5991818.0 | 2092671.0 | 37.7256058079955 | -122.47048399681299 | (37.7256058079955, -122.470483996813) | ||
| 93564 | 93564 | 8627 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
| 93600 | 93600 | 11449 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3 | 5995514.85453 | 2115936.98374 | 37.789701328403794 | -122.459388527967 | (37.7897013284038, -122.459388527967) | |||
| 94469 | 94469 | 90653 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3400 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985083.076571 | 2110439.01327 | 37.7740001866718 | -122.495075331328 | (37.7740001866718, -122.495075331328) | |
| 94849 | 94849 | 16581 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 94921 | 94921 | 90651 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3350 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985244.351217 | 2110444.86641 | 37.77402569788379 | -122.494517894729 | (37.7740256978838, -122.494517894729) | |
| 95333 | 95333 | 1658 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 355 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3PL | 6005564.182695299 | 2115313.9086125 | 37.7885631867232 | -122.42457447354201 | (37.7885631867232, -122.424574473542) | |||
| 96504 | 96504 | 90648 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3326 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985315.670548 | 2110447.4548029997 | 37.774036978686105 | -122.494271383414 | (37.7740369786861, -122.494271383414) | |
| 98286 | 98286 | 30056 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 410X Brotherhood Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
| 105214 | 105214 | 16574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 107168 | 107168 | 1459 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 170 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/2016 12:00:00 AM | 3 | 3X3 | 5995550.04473 | 2115004.5648 | 37.7871431812831 | -122.45919922698299 | (37.7871431812831, -122.459199226983) | ||
| 109368 | 109368 | 16575 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 109611 | 109611 | 1678 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 315 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2000 12:00:00 AM | 3 | 3X3 | 5994577.07747 | 2111415.6823400003 | 37.7772330921215 | -122.46230506404801 | (37.7772330921215, -122.462305064048) | ||
| 110300 | 110300 | 98558 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3906 Judah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x27 | 5982438.0 | 2105598.0 | 37.7605529521075 | -122.50386633030199 | (37.7605529521075, -122.503866330302) | |||
| 110386 | 110386 | 8628 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
| 110475 | 110475 | 15781 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/03/2000 12:00:00 AM | 12 | 3X3 | 6001135.36791 | 2090627.3686 | 37.7205288045244 | -122.438128360054 | (37.7205288045244, -122.438128360054) | ||
| 110532 | 110532 | 16573 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 111630 | 111630 | 90646 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 111736 | 111736 | 8635 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
| 113763 | 113763 | 4975 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 113804 | 113804 | 2665 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2031 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1991 12:00:00 AM | 12 | 3X3 | 6003805.33763 | 2114874.02287 | 37.787255885128396 | -122.430628406293 | (37.7872558851284, -122.430628406293) | ||
| 114350 | 114350 | 105134 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 98X WINFIELD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | Neighbor said they are not going to replant trees because ther eis no one to take care of them | 6007331.0 | 2099216.0 | 37.7444617271859 | -122.417320300114 | (37.7444617271859, -122.417320300114) | ||
| 114588 | 114588 | 90645 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 117072 | 117072 | 1782 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2001X Bay Shore Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6012442.836211099 | 2088493.8744970001 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | |||
| 117689 | 117689 | 25566 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | |||
| 118289 | 118289 | 114805 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 210X GELLERT DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 3x3 | 5985389.0 | 2094462.0 | 37.73014959142171 | -122.492840061243 | (37.7301495914217, -122.492840061243) | |||
| 121298 | 121298 | 113033 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 251 06th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5993976.74262 | 2113849.61749 | 37.7838814353255 | -122.464558572154 | (37.7838814353255, -122.464558572154) | ||||
| 122129 | 122129 | 16579 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 123325 | 123325 | 90647 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3320 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985333.500383999 | 2110448.101901 | 37.7740397988057 | -122.494209755562 | (37.7740397988057, -122.494209755562) | |
| 123709 | 123709 | 113032 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 251 06th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5993976.74262 | 2113849.61749 | 37.7838814353255 | -122.464558572154 | (37.7838814353255, -122.464558572154) | ||||
| 124428 | 124428 | 13298 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 168 LUNADO CT | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 3 | 15 | 5991818.0 | 2092671.0 | 37.7256058079955 | -122.47048399681299 | (37.7256058079955, -122.470483996813) | ||
| 124560 | 124560 | 16578 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 124877 | 124877 | 16572 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 95X Nido Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999200.479133099 | 2112280.3747819 | 37.779872451802795 | -122.446373519186 | (37.7798724518028, -122.446373519186) | |||
| 126064 | 126064 | 9313 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 99X Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.743138360608704 | -122.437831565564 | (37.7431383606087, -122.437831565564) | |||
| 127092 | 127092 | 116522 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 324 08TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW for City Agency 2 | 8 | 3x3 | 5993416.0 | 2113304.0 | 37.7823509768718 | -122.466458848407 | (37.7823509768718, -122.466458848407) | ||
| 127391 | 127391 | 90662 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3518 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984718.446788 | 2110425.779815 | 37.7739424981767 | -122.49633565193199 | (37.7739424981767, -122.496335651932) | |
| 127395 | 127395 | 20582 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1392X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984737.8310875995 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | |||
| 127676 | 127676 | 4967 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 128559 | 128559 | 4968 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 138760 | 138760 | 25260 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5995011.81264 | 2092264.9607400002 | 37.7246750767236 | -122.45941393184799 | (37.7246750767236, -122.459413931848) | |||
| 139086 | 139086 | 24723 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 7328 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5 | 5984257.95448 | 2112521.20375 | 37.779668941128605 | -122.49808332519899 | (37.7796689411286, -122.498083325199) | |||
| 141454 | 141454 | 90654 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3400 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985083.076571 | 2110439.01327 | 37.7740001866718 | -122.495075331328 | (37.7740001866718, -122.495075331328) | |
| 142185 | 142185 | 13299 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 168 LUNADO CT | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 3 | 15 | 5991818.0 | 2092671.0 | 37.7256058079955 | -122.47048399681299 | (37.7256058079955, -122.470483996813) | ||
| 144084 | 144084 | 833 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5981556.8759975 | 2105533.8452968 | 37.760324951376504 | -122.50690892383801 | (37.7603249513765, -122.506908923838) | |||
| 144314 | 144314 | 5009 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5300 Diamond Heights Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
| 144391 | 144391 | 25557 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 50X Industrial St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2000 12:00:00 AM | 3 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | ||
| 145415 | 145415 | 4973 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 151195 | 151195 | 247574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6008213.28818 | 2095041.8138700002 | 37.7330499269008 | -122.413974287302 | (37.7330499269008, -122.413974287302) | ||||
| 157694 | 157694 | 210557 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15x San Marcos Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 5993258.3817300005 | 2100285.93498 | 37.746597700037604 | -122.466057859008 | (37.7465977000376, -122.466057859008) | |||
| 167073 | 167073 | 210556 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15x San Marcos Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993267.77676 | 2100290.91816 | 37.7466119245936 | -122.466025734301 | (37.7466119245936, -122.466025734301) | |||
| 184785 | 184785 | 113031 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 251 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 14 | 3x3 | 5993971.49407 | 2113867.66105 | 37.7839306754778 | -122.464578040665 | (37.7839306754778, -122.464578040665) | |||
| 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) |
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");