Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▼ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 9884 | 9884 | 173718 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 906 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | 3x3 | 6012418.0 | 2103694.0 | 37.757042237838796 | -122.400044801952 | (37.7570422378388, -122.400044801952) | |||
| 13219 | 13219 | 24279 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350X Winding Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000809.6312 | 2086798.35513 | 37.709996659695 | -122.43898005820299 | (37.709996659695, -122.438980058203) | |||
| 14667 | 14667 | 3750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012463.2126 | 2103693.82662 | 37.7570442824941 | -122.39988842642401 | (37.7570442824941, -122.399888426424) | |||
| 17169 | 17169 | 29607 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.48666 | 2091034.59302 | 37.7210755258009 | -122.472582381082 | (37.7210755258009, -122.472582381082) | ||
| 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) | |||
| 18018 | 18018 | 4976 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 5200X Diamond Heights Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
| 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) | |||
| 18962 | 18962 | 29617 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991168.23882 | 2090896.94142 | 37.7206970910675 | -122.472600860348 | (37.7206970910675, -122.472600860348) | ||
| 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) | |||
| 20519 | 20519 | 29614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.98096 | 2090921.81223 | 37.720765307364395 | -122.47260702069599 | (37.7207653073644, -122.472607020696) | ||
| 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) | |||
| 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) | |||
| 24433 | 24433 | 232350 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 500x 27th St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 4ft | 6002774.61344 | 2100063.62492 | 37.746531703279096 | -122.433135885834 | (37.7465317032791, -122.433135885834) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 80182 | 80182 | 106625 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 500X 27TH ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 5x400 | 6003184.0 | 2100084.0 | 37.7466108627938 | -122.431721727073 | (37.7466108627938, -122.431721727073) | |||
| 84555 | 84555 | 2254 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 410X Brotherhood Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 3232 | 3232 | 253369 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 449X Trumbull St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | Width 10ft | 6005840.0 | 2094317.0 | 37.730926169648 | -122.42212790794599 | (37.730926169648, -122.422127907946) | ||||
| 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) | ||||
| 5094 | 5094 | 253788 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1663X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991413.0 | 2103963.0 | 37.756587325686105 | -122.472706989611 | (37.7565873256861, -122.472706989611) | ||||
| 5115 | 5115 | 14434 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998899.8061 | 2113051.3525 | 37.781972179426205 | -122.447469186406 | (37.7819721794262, -122.447469186406) | |||
| 5947 | 5947 | 8624 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999301.8512 | 2113214.4718 | 37.782443029823206 | -122.446090036766 | (37.7824430298232, -122.446090036766) | |||
| 6165 | 6165 | 14421 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 3X3 | 5998843.9665 | 2113055.4136 | 37.7819801389805 | -122.44766265742399 | (37.7819801389805, -122.447662657424) | |||
| 6290 | 6290 | 14424 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 12 | 5998854.1192 | 2113097.3779 | 37.7820959422738 | -122.44763055563999 | (37.7820959422738, -122.44763055564) | |||
| 6368 | 6368 | 8674 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5998029.5545 | 2113103.6387 | 37.7820659737765 | -122.45048361361201 | (37.7820659737765, -122.450483613612) | |||
| 6382 | 6382 | 8738 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3300X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x10 | 5996893.3032 | 2112947.7955 | 37.7815729712314 | -122.45440324333 | (37.7815729712314, -122.45440324333) | |||
| 6919 | 6919 | 8636 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999097.4445 | 2113192.4744 | 37.782370955794605 | -122.446795608488 | (37.7823709557946, -122.446795608488) | |||
| 7003 | 7003 | 14431 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998857.8418 | 2113111.93 | 37.7821361113043 | -122.44761872504499 | (37.7821361113043, -122.447618725045) | |||
| 7214 | 7214 | 14423 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 90X Masonic Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 12 | 5998895.4066 | 2113040.8614 | 37.7819431221776 | -122.44748365121 | (37.7819431221776, -122.44748365121) | |||
| 7547 | 7547 | 8637 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999081.877 | 2113180.2912 | 37.7823366145664 | -122.44684858803001 | (37.7823366145664, -122.44684858803) | |||
| 7591 | 7591 | 14429 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2X Masonic Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 3X3 | 5998837.1981 | 2113128.5127 | 37.7821804632664 | -122.44769133675501 | (37.7821804632664, -122.447691336755) | |||
| 8216 | 8216 | 8619 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999326.2176 | 2113214.8103 | 37.782445350683496 | -122.44600576434601 | (37.7824453506835, -122.446005764346) | |||
| 11290 | 11290 | 1302 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4000X Alemany Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 10 | 5991739.11571 | 2087020.66511 | 37.7100868068254 | -122.470345390352 | (37.7100868068254, -122.470345390352) | |||
| 17726 | 17726 | 18123 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5992892.904130001 | 2097317.3728099996 | 37.7384256882798 | -122.467105837168 | (37.7384256882798, -122.467105837168) | |||
| 17782 | 17782 | 18122 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5992903.1878 | 2097320.00878 | 37.7384335195858 | -122.46707047313 | (37.7384335195858, -122.46707047313) | |||
| 19057 | 19057 | 8617 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
| 19215 | 19215 | 29612 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991180.99541 | 2090994.8659400002 | 37.7209667060276 | -122.472563900905 | (37.7209667060276, -122.472563900905) | ||
| 20133 | 20133 | 18124 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5992890.67521 | 2097308.6601400003 | 37.738401636818296 | -122.467112910341 | (37.7384016368183, -122.467112910341) | |||
| 20554 | 20554 | 24378 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/1995 12:00:00 AM | 20 | 5x5 | 5990557.6196800005 | 2091079.0001599998 | 37.7211616152093 | -122.474724840503 | (37.7211616152093, -122.474724840503) | ||
| 20883 | 20883 | 18125 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5992881.81399 | 2097305.58715 | 37.7383926876616 | -122.46714332449801 | (37.7383926876616, -122.467143324498) | |||
| 21056 | 21056 | 29615 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991180.193109999 | 2090928.63197 | 37.720784797453206 | -122.47256184775 | (37.7207847974532, -122.47256184775) | ||
| 21663 | 21663 | 29964 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991360.1549 | 2093767.2009599998 | 37.728589218496296 | -122.472146582199 | (37.7285892184963, -122.472146582199) | ||
| 21822 | 21822 | 18126 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5992880.89673 | 2097291.14293 | 37.7383529745158 | -122.46714544600799 | (37.7383529745158, -122.467145446008) | |||
| 22182 | 22182 | 24383 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Holloway Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/27/1995 12:00:00 AM | 6 | 5X5 | 5990686.40185 | 2091107.5721200001 | 37.721247528335 | -122.474281766115 | (37.721247528335, -122.474281766115) | ||
| 22425 | 22425 | 9012 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5317 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5990521.6823 | 2112683.6213 | 37.7804801526055 | -122.476426471359 | (37.7804801526055, -122.476426471359) | |||
| 22499 | 22499 | 9221 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6300 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5987257.696 | 2112564.9029 | 37.7799643479314 | -122.487709266059 | (37.7799643479314, -122.487709266059) | |||
| 22532 | 22532 | 9220 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6300 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5987312.697000001 | 2112569.5982 | 37.779980447765396 | -122.487519340495 | (37.7799804477654, -122.487519340495) | |||
| 22564 | 22564 | 9174 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6100 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5988054.2055 | 2112594.5834 | 37.7800922677689 | -122.484955995928 | (37.7800922677689, -122.484955995928) | |||
| 22589 | 22589 | 9159 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6000 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 3x3 | 5988363.5866 | 2112600.7878 | 37.7801273186276 | -122.48388617463999 | (37.7801273186276, -122.48388617464) | |||
| 22625 | 22625 | 9089 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8M | 5989272.6654 | 2112633.6176 | 37.7802703397174 | -122.480743697915 | (37.7802703397174, -122.480743697915) | |||
| 22644 | 22644 | 9160 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6000 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8M | 5988323.3419 | 2112601.1232 | 37.7801258966338 | -122.484025422258 | (37.7801258966338, -122.484025422258) | |||
| 22756 | 22756 | 9141 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5900 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8M | 5988494.0465 | 2112606.8245 | 37.78015148750371 | -122.483435302646 | (37.7801514875037, -122.483435302646) | |||
| 22777 | 22777 | 8978 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5100 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5991036.9282 | 2112701.8385 | 37.780560040555 | -122.47464534097999 | (37.780560040555, -122.47464534098) | |||
| 24169 | 24169 | 232579 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500x 27th St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002958.22552 | 2100071.04753 | 37.746562497872205 | -122.43250150584801 | (37.7465624978722, -122.432501505848) | |||
| 36741 | 36741 | 213231 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1x Minerva St | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 5996543.8328 | 2088997.86009 | 37.7157923540991 | -122.45388213025299 | (37.7157923540991, -122.453882130253) | |||
| 42987 | 42987 | 9238 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 6400 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8M | 5987194.656872401 | 2112586.3612843 | 37.7800195894976 | -122.48792892082399 | (37.7800195894976, -122.487928920824) | |||
| 45040 | 45040 | 231439 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101x Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 5999775.11781 | 2101292.59964 | 37.749735565955795 | -122.443596051626 | (37.7497355659558, -122.443596051626) | |||
| 47272 | 47272 | 8631 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) | |||
| 63650 | 63650 | 18119 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1400 Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 10 | 5993139.262904599 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | |||
| 67186 | 67186 | 177683 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500x Mansell St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 6010362.00483 | 2090329.22139 | 37.7202305794682 | -122.40621366053301 | (37.7202305794682, -122.406213660533) | |||
| 69886 | 69886 | 8776 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5996225.73725 | 2112888.16755 | 37.7813709415224 | -122.45670837476601 | (37.7813709415224, -122.456708374766) | |||
| 71859 | 71859 | 231438 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101x Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 5ft | 5999777.38069 | 2101303.6444900003 | 37.749766021497706 | -122.443589019842 | (37.7497660214977, -122.443589019842) | |||
| 76514 | 76514 | 210024 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 400x Marietta Dr | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999068.6414 | 2096968.17305 | 37.737821414033796 | -122.445728113076 | (37.7378214140338, -122.445728113076) | |||
| 77657 | 77657 | 99736 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 900X Ocean Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5997264.7 | 2091625.4 | 37.7230482703916 | -122.45157991133101 | (37.7230482703916, -122.451579911331) | |||||
| 77741 | 77741 | 8858 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5994165.98943 | 2112811.42847 | 37.7810417566011 | -122.463828472047 | (37.7810417566011, -122.463828472047) | |||
| 78386 | 78386 | 8950 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4800 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | |||
| 78560 | 78560 | 22874 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951X Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | |||
| 80067 | 80067 | 8623 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.44579788601101 | (37.7825637442266, -122.445797886011) |
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");