Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11842 | 11842 | 19713 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 12182 | 12182 | 19712 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 14544 | 14544 | 19711 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY13 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 11201 | 11201 | 19747 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 10ST | ||||||||
| 14337 | 14337 | 19746 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | ||||||||
| 16592 | 16592 | 19752 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY15 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 13008 | 13008 | 19766 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY16 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 15820 | 15820 | 19764 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 100 STAIRWAY16 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30ST | ||||||||
| 867 | 867 | 5563 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005047.93676 | 2102495.8008 | 37.753338590028 | -122.42544803402399 | (37.753338590028, -122.425448034024) | |||
| 17849 | 17849 | 26939 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3 | 6005048.52765 | 2102486.42553 | 37.7533128811044 | -122.42544532345501 | (37.7533128811044, -122.425445323455) | |||
| 20958 | 20958 | 3909 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1000X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002142.832230001 | 2107666.80115 | 37.7673723370035 | -122.43586443430901 | (37.7673723370035, -122.435864434309) | |||
| 16910 | 16910 | 7017 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1055 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002366.0432 | 2110180.0215 | 37.774285696400206 | -122.435272167554 | (37.7742856964002, -122.435272167554) | |||
| 23093 | 23093 | 26475 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 106 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3X3 | 6001338.90016 | 2098832.9571 | 37.7430710337942 | -122.438012277952 | (37.7430710337942, -122.438012277952) | |||
| 9880 | 9880 | 3771 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1100X Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6012538.0 | 2102781.0 | 37.75454202913279 | -122.39956569430599 | (37.7545420291328, -122.399565694306) | |||
| 88219 | 88219 | 2210 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1145 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000813.81573 | 2112576.3555400004 | 37.7807771513392 | -122.44081352531 | (37.7807771513392, -122.44081352531) | |||
| 3267 | 3267 | 2831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 6008484.02773 | 2116302.9533599997 | 37.791443325609606 | -122.414542237062 | (37.7914433256096, -122.414542237062) | |||
| 6574 | 6574 | 2832 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008465.75544 | 2116301.4842 | 37.7914382651038 | -122.414605355047 | (37.7914382651038, -122.414605355047) | |||
| 8703 | 8703 | 2829 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1200 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6008547.0936900005 | 2116310.73962 | 37.7914682476113 | -122.414324580422 | (37.7914682476113, -122.414324580422) | |||
| 22423 | 22423 | 18155 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005677.61973 | 2114458.9667 | 37.7862221342749 | -122.42412117337099 | (37.7862221342749, -122.424121173371) | |||
| 22514 | 22514 | 18154 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005654.5988300005 | 2114457.04911 | 37.7862155692388 | -122.42420068332899 | (37.7862155692388, -122.424200683329) | |||
| 22671 | 22671 | 18156 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005730.74632 | 2114465.38856 | 37.786242766547105 | -122.42393782586399 | (37.7862427665471, -122.423937825864) | |||
| 90108 | 90108 | 18157 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1355 Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005683.2980159 | 2114458.6818444002 | 37.7862216727319 | -122.42410150769899 | (37.7862216727319, -122.424101507699) | |||
| 10811 | 10811 | 823 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1381 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5981813.5224 | 2105689.4462 | 37.760767297588295 | -122.50603285620599 | (37.7607672975883, -122.506032856206) | |||
| 10779 | 10779 | 831 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1388 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 5.5x6.5 | 5981551.002 | 2105650.5805 | 37.7606451268888 | -122.506937898142 | (37.7606451268888, -122.506937898142) | |||
| 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) | |||
| 12649 | 12649 | 24533 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1395 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5981505.7764 | 2105644.9273 | 37.7606269413357 | -122.507093890918 | (37.7606269413357, -122.507093890918) | |||
| 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) | |||
| 13014 | 13014 | 24510 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1400 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 5981246.2202 | 2105482.1578 | 37.7601647328681 | -122.507979481979 | (37.7601647328681, -122.507979481979) | |||
| 83577 | 83577 | 20596 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1401X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984800.4502922995 | 2105635.4093669 | 37.760794298851295 | -122.495698574627 | (37.7607942988513, -122.495698574627) | |||
| 17928 | 17928 | 22547 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6001443.018180001 | 2098660.99719 | 37.7426047928778 | -122.437639954147 | (37.7426047928778, -122.437639954147) | |||
| 78581 | 78581 | 20664 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1501X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
| 79364 | 79364 | 20662 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1501X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.49558761620101 | (37.7589182591611, -122.495587616201) | |||
| 29614 | 29614 | 210555 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15x San Marcos Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993274.23094 | 2100297.44327 | 37.7466302132305 | -122.466003890675 | (37.7466302132305, -122.466003890675) | |||
| 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) | |||
| 89335 | 89335 | 1457 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 160 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1996 12:00:00 AM | 18 | 3X3 | 5995550.62433 | 2115045.99929 | 37.78725698253879 | -122.459200223243 | (37.7872569825388, -122.459200223243) | ||
| 23165 | 23165 | 25259 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5994884.3509 | 2092299.7091 | 37.724763157858796 | -122.45985706395399 | (37.7247631578588, -122.459857063954) | |||
| 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) | |||
| 89711 | 89711 | 1458 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 166 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5995549.24707 | 2115014.62054 | 37.7871707457756 | -122.45920271513799 | (37.7871707457756, -122.459202715138) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 5081 | 5081 | 253792 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5085 | 5085 | 253795 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5092 | 5092 | 253791 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5097 | 5097 | 253793 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 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) | ||
| 69884 | 69884 | 6036 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1826 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001703.73225 | 2112585.2403700002 | 37.7808521880762 | -122.43773551469499 | (37.7808521880762, -122.437735514695) | |||
| 2528 | 2528 | 138185 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1865 Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6003940.6794 | 2114739.7851 | 37.786894968468 | -122.43015057261002 | (37.786894968468, -122.43015057261) | |||
| 19157 | 19157 | 22548 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 19 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 6001457.66842 | 2098646.06303 | 37.7425646201593 | -122.437588228722 | (37.7425646201593, -122.437588228722) | |||
| 120273 | 120273 | 113891 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x STORRIE ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 12 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 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) | |||
| 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) | ||
| 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) | |||
| 17299 | 17299 | 8210 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992281.31882 | 2100517.50117 | 37.7471771044468 | -122.469453261968 | (37.7471771044468, -122.469453261968) | |||
| 18335 | 18335 | 8215 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992282.36795 | 2100542.6208599997 | 37.7472461372953 | -122.469451462412 | (37.7472461372953, -122.469451462412) | |||
| 18536 | 18536 | 8217 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992282.7442 | 2100560.49724 | 37.7472952429876 | -122.469451462429 | (37.7472952429876, -122.469451462429) | |||
| 18961 | 18961 | 8216 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992283.56126 | 2100549.85323 | 37.7472660644888 | -122.469447862447 | (37.7472660644888, -122.469447862447) | |||
| 19720 | 19720 | 8219 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992283.90112 | 2100578.3571900004 | 37.747344348682795 | -122.469448761774 | (37.7473443486828, -122.469448761774) | |||
| 20399 | 20399 | 8212 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992284.57704 | 2100523.9125099997 | 37.7471948966366 | -122.46944246202 | (37.7471948966366, -122.46944246202) | |||
| 21139 | 21139 | 8218 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8X25 | 5992283.97023 | 2100569.2840400003 | 37.7473194401374 | -122.46944786245199 | (37.7473194401374, -122.469447862452) | |||
| 21615 | 21615 | 8213 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2189X Funston Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8X25 | 5992288.54504 | 2100526.93925 | 37.7472034366016 | -122.469428961394 | (37.7472034366016, -122.469428961394) | |||
| 1687 | 1687 | 18887 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2407 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003191.46268 | 2115855.10762 | 37.789914898090004 | -122.432822394747 | (37.78991489809, -122.432822394747) | |||
| 89317 | 89317 | 85483 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 123690 | 123690 | 85484 | Myoporum laetum :: Myoporum 1 | 2448 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6007028.643792 | 2120821.987554 | 37.8037695888063 | -122.419898663276 | (37.8037695888063, -122.419898663276) | ||||
| 19162 | 19162 | 9363 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 256 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2x2 | 6001113.86641 | 2098278.49055 | 37.7415357993513 | -122.43875065912901 | (37.7415357993513, -122.438750659129) | |||
| 828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
| 4979 | 4979 | 8629 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999229.0905 | 2113208.3802 | 37.78242214856029 | -122.44634131765899 | (37.7824221485603, -122.446341317659) | |||
| 5433 | 5433 | 8620 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113220.5634 | 37.7824608186771 | -122.446026081758 | (37.7824608186771, -122.446026081758) | |||
| 5798 | 5798 | 8630 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999216.9073 | 2113207.365 | 37.7824186652585 | -122.44638339297501 | (37.7824186652585, -122.446383392975) | |||
| 7236 | 7236 | 8621 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999320.4644 | 2113213.4566 | 37.782441305247104 | -122.446025570431 | (37.7824413052471, -122.446025570431) | |||
| 8476 | 8476 | 8633 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999163.0983 | 2113201.6118 | 37.7823997950612 | -122.44656913375401 | (37.7823997950612, -122.446569133754) | |||
| 78065 | 78065 | 8632 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
| 87836 | 87836 | 8626 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 7106 | 7106 | 8639 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600X Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 5999285.607000001 | 2113327.5047 | 37.7827524611939 | -122.446154367514 | (37.7827524611939, -122.446154367514) | |||
| 23048 | 23048 | 8638 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 0 | 5999322.495 | 2113336.6421 | 37.782779656634396 | -122.44602740853901 | (37.7827796566344, -122.446027408539) | |||
| 21350 | 21350 | 5101 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2629 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6002336.13825 | 2096372.73058 | 37.7363724838986 | -122.43438824303101 | (37.7363724838986, -122.434388243031) | |||
| 8762 | 8762 | 8614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2660 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5998899.9753 | 2113233.2542 | 37.782471643857896 | -122.44748169838999 | (37.7824716438579, -122.44748169839) | |||
| 23246 | 23246 | 8613 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2660 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 20 | 5998899.2985 | 2113220.7326 | 37.7824372241255 | -122.447483138223 | (37.7824372241255, -122.447483138223) | |||
| 54700 | 54700 | 186973 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2900x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 5981564.792 | 2096478.003 | 37.7354606126333 | -122.50621004103701 | (37.7354606126333, -122.506210041037) | |||
| 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) | |||
| 20254 | 20254 | 23999 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 300 West Portal Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 5992235.8832 | 2097133.9008 | 37.7378839736291 | -122.469364124733 | (37.7378839736291, -122.469364124733) | |||
| 7592 | 7592 | 98477 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3020 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5999352.2396 | 2114673.6817 | 37.7864525177898 | -122.44602070386999 | (37.7864525177898, -122.44602070387) | |||
| 8418 | 8418 | 98478 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3022 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 5999322.5683 | 2114670.9216 | 37.7864432448969 | -122.44612316014201 | (37.7864432448969, -122.446123160142) | |||
| 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) | ||
| 90226 | 90226 | 90644 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3300X 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 | 5985392.933158999 | 2110450.258895 | 37.774049198972605 | -122.49400432939699 | (37.7740491989726, -122.494004329397) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 76161 | 76161 | 90650 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3350 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 | 5985244.351217 | 2110444.86641 | 37.77402569788379 | -122.494517894729 | (37.7740256978838, -122.494517894729) | |
| 77588 | 77588 | 90649 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3350 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 | 5985244.351217 | 2110444.86641 | 37.77402569788379 | -122.494517894729 | (37.7740256978838, -122.494517894729) | |
| 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) | |
| 89204 | 89204 | 90652 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3400 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985038.957769999 | 2110446.28749 | 37.7740175766633 | -122.49522848002199 | (37.7740175766633, -122.495228480022) | ||
| 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) | |
| 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) |
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");