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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 129592 | 129592 | 186830 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 93 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984826.8059 | 2106580.9981 | 37.7633921640535 | -122.49567717299999 | (37.7633921640535, -122.495677173) | |||
| 46675 | 46675 | 186799 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984838.6936 | 2106905.4238 | 37.764283642033 | -122.495659989112 | (37.764283642033, -122.495659989112) | |||
| 182075 | 182075 | 186798 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 76 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984847.2394 | 2106906.9776 | 37.7642884087703 | -122.495630546663 | (37.7642884087703, -122.495630546663) | |||
| 46399 | 46399 | 186797 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984845.6856 | 2106903.6111 | 37.7642790743182 | -122.495635672409 | (37.7642790743182, -122.495635672409) | |||
| 35348 | 35348 | 194039 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 74 | Median : Yard 3 | Tree 1 | DPW 2 | 38 | 6012510.33858 | 2102789.20195 | 37.754563007990896 | -122.399661931254 | (37.7545630079909, -122.399661931254) | ||||
| 45849 | 45849 | 185928 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2000 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985021.4097 | 2101486.4323 | 37.7494152911337 | -122.494628506041 | (37.7494152911337, -122.494628506041) | |||
| 177097 | 177097 | 181430 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984894.5136 | 2104851.8242 | 37.7586483004402 | -122.495315467353 | (37.7586483004402, -122.495315467353) | |||
| 181337 | 181337 | 186724 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1300 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 0ft | 5984849.7405 | 2106204.9407 | 37.762360958924106 | -122.49557011228998 | (37.7623609589241, -122.49557011229) | |||
| 30884 | 30884 | 181424 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984916.7919 | 2104797.7992 | 37.7585012671882 | -122.495234435961 | (37.7585012671882, -122.495234435961) | |||
| 36721 | 36721 | 210535 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700 Junipero Serra Blvd | 57 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991233.67359 | 2092413.03561 | 37.7248636977911 | -122.472485147273 | (37.7248636977911, -122.472485147273) | |||
| 64729 | 64729 | 194038 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900x Carolina St | 53 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6012502.8583 | 2102970.8089 | 37.7550612440971 | -122.39970055084 | (37.7550612440971, -122.39970055084) | ||||
| 130581 | 130581 | 187395 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2100 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985039.3656 | 2100676.2331 | 37.7471917561772 | -122.494506696584 | (37.7471917561772, -122.494506696584) | |||
| 24948 | 24948 | 186573 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 44 | unknown : Yard 19 | Tree 1 | Private 1 | 15 | Width 0ft | 5984743.4554 | 2104652.876 | 37.758093198452 | -122.49582321186399 | (37.758093198452, -122.495823211864) | |||
| 149963 | 149963 | 187179 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2301 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984914.0932 | 2099227.6174 | 37.7432069184805 | -122.494833083055 | (37.7432069184805, -122.494833083055) | |||
| 136891 | 136891 | 187355 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2200 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985062.7652 | 2099776.5974 | 37.744722970464395 | -122.494359480034 | (37.7447229704644, -122.494359480034) | |||
| 135181 | 135181 | 232295 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6006547.43699 | 2098127.1164599997 | 37.7414277817691 | -122.419952450553 | (37.7414277817691, -122.419952450553) | ||||
| 137429 | 137429 | 187354 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2200 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985070.2132 | 2099768.1337 | 37.7447001673089 | -122.49433310291401 | (37.7447001673089, -122.494333102914) | |||
| 62149 | 62149 | 232294 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6006564.33926 | 2098135.6208099998 | 37.7414520850542 | -122.41989461157301 | (37.7414520850542, -122.419894611573) | ||||
| 150810 | 150810 | 186483 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 38 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980878.6055 | 2105409.1394 | 37.7599425780444 | -122.509245441233 | (37.7599425780444, -122.509245441233) | |||
| 167996 | 167996 | 186482 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 37 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980889.9955 | 2105407.5862 | 37.7599389849374 | -122.50920593411199 | (37.7599389849374, -122.509205934112) | |||
| 182248 | 182248 | 232293 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6006572.50895 | 2098130.46557 | 37.741438390175205 | -122.41986599782301 | (37.7414383901752, -122.419865997823) | ||||
| 169301 | 169301 | 138761 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 36 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 5999027.0527 | 2113220.9018 | 37.7824449885745 | -122.44704117852 | (37.7824449885745, -122.44704117852) | |||
| 61319 | 61319 | 186489 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 35 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980878.6055 | 2105387.9124 | 37.759884294807 | -122.509243864844 | (37.759884294807, -122.509243864844) | |||
| 163978 | 163978 | 232291 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 9ft | 6004778.102000001 | 2096680.6709599998 | 37.737356328728104 | -122.42596726120001 | (37.7373563287281, -122.4259672612) | |||
| 167980 | 167980 | 232292 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 200 Eugenia Ave | 35 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 10ft | 6006575.0369 | 2098117.47597 | 37.7414028660575 | -122.41985633551701 | (37.7414028660575, -122.419856335517) | |||
| 168081 | 168081 | 185107 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2801 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5985026.6173 | 2095934.5241 | 37.73417155402829 | -122.49420133916 | (37.7341715540283, -122.49420133916) | |||
| 27451 | 27451 | 232290 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1100 San Jose Ave | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 9ft | 6004782.10663 | 2096684.4357 | 37.737366892177704 | -122.425953683239 | (37.7373668921777, -122.425953683239) | |||
| 51431 | 51431 | 186843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 7 | Width 0ft | 5980882.2296 | 2105351.6713 | 37.759785000838704 | -122.509228639712 | (37.7597850008387, -122.509228639712) | |||
| 131528 | 131528 | 186676 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984702.3158 | 2105448.5558 | 37.76027550382771 | -122.496024187798 | (37.7602755038277, -122.496024187798) | |||
| 176494 | 176494 | 186562 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 33 | unknown : Yard 19 | Tree 1 | Private 1 | 10 | Width 0ft | 5984757.692000001 | 2104711.0786 | 37.758253840349205 | -122.495778269581 | (37.7582538403492, -122.495778269581) | |||
| 187810 | 187810 | 138265 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 33 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999027.3911 | 2113166.4159 | 37.7822954037862 | -122.447036085573 | (37.7822954037862, -122.447036085573) | |||
| 49608 | 49608 | 186504 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980883.7828 | 2105343.3876 | 37.7597623477539 | -122.50922265288601 | (37.7597623477539, -122.509222652886) | |||
| 120079 | 120079 | 186675 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984701.897000001 | 2105453.5805 | 37.760289275720204 | -122.496026006908 | (37.7602892757202, -122.496026006908) | |||
| 67056 | 67056 | 138263 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 17 | Width 0ft | 5999038.5591 | 2113167.7696 | 37.7822997587534 | -122.44699754685101 | (37.7822997587534, -122.446997546851) | |||
| 70661 | 70661 | 186503 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 31 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980885.336 | 2105334.0684 | 37.759736851483396 | -122.50921658916701 | (37.7597368514834, -122.509216589167) | |||
| 122028 | 122028 | 186674 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984709.4341 | 2105459.8614 | 37.760306962768205 | -122.49600040337201 | (37.7603069627682, -122.496000403372) | |||
| 37732 | 37732 | 185698 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2101 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984860.7612 | 2100520.7355 | 37.7467543474647 | -122.495112822862 | (37.7467543474647, -122.495112822862) | |||
| 48124 | 48124 | 186292 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1800 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984989.7259 | 2102642.6308 | 37.752588040554 | -122.494823302768 | (37.752588040554, -122.494823302768) | |||
| 182255 | 182255 | 186502 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 30 | unknown : Yard 19 | Tree 1 | Private 1 | 5 | Width 0ft | 5980892.5842 | 2105334.0684 | 37.7597372788194 | -122.509191521679 | (37.7597372788194, -122.509191521679) | |||
| 188549 | 188549 | 138262 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 30 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999046.0043 | 2113182.6602 | 37.7823410698302 | -122.44697286174801 | (37.7823410698302, -122.446972861748) | |||
| 46239 | 46239 | 185697 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2101 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984860.4343 | 2100522.6969999997 | 37.746759714071004 | -122.49511409785102 | (37.746759714071, -122.495114097851) | |||
| 47007 | 47007 | 186501 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 29 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980893.6197 | 2105317.501 | 37.7596918505514 | -122.50918671014799 | (37.7596918505514, -122.509186710148) | |||
| 155691 | 155691 | 138261 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 29 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 0ft | 5999049.3886 | 2113169.4617 | 37.782305023527606 | -122.44696020353999 | (37.7823050235276, -122.44696020354) | |||
| 147843 | 147843 | 186500 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980882.7473 | 2105316.9833 | 37.7596897880858 | -122.509224273257 | (37.7596897880858, -122.509224273257) | |||
| 31980 | 31980 | 185695 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2101 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984855.8577 | 2100528.9081 | 37.74677650012389 | -122.49513038098499 | (37.7467765001239, -122.495130380985) | |||
| 53561 | 53561 | 138259 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2600 GEARY BLVD | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 19 | Width 0ft | 5999063.9407 | 2113176.2302 | 37.782324439437204 | -122.44691034713499 | (37.7823244394372, -122.446910347135) | |||
| 63349 | 63349 | 186499 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 27 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980882.7473 | 2105311.2882 | 37.7596741509783 | -122.50922385032601 | (37.7596741509783, -122.509223850326) | |||
| 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) | ||
| 65556 | 65556 | 186486 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 26 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.8182 | 2105306.6287 | 37.759661479426796 | -122.509216342217 | (37.7596614794268, -122.509216342217) | |||
| 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) | |||
| 182170 | 182170 | 185694 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2101 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984861.0881 | 2100529.8889 | 37.7467794993444 | -122.495112367353 | (37.7467794993444, -122.495112367353) | |||
| 47839 | 47839 | 185966 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2001 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984856.249 | 2101288.6271 | 37.7488625039545 | -122.49518504258499 | (37.7488625039545, -122.495185042585) | |||
| 52894 | 52894 | 186485 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 25 | unknown : Yard 19 | Tree 1 | Private 1 | 9 | Width 0ft | 5980894.6551 | 2105298.8627 | 37.7596407361809 | -122.50918174518299 | (37.7596407361809, -122.509181745183) | |||
| 136974 | 136974 | 185882 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2000 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985026.8493 | 2101115.2901 | 37.7483965544335 | -122.494582338742 | (37.7483965544335, -122.494582338742) | |||
| 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) | ||
| 148409 | 148409 | 186553 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1501 Sunset Blvd | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 12 | Width 0ft | 5984733.406 | 2104758.3944 | 37.7583823340555 | -122.495865750271 | (37.7583823340555, -122.495865750271) | |||
| 157531 | 157531 | 186484 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 24 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980883.7828 | 2105293.6854 | 37.7596258798004 | -122.50921896188801 | (37.7596258798004, -122.509218961888) | |||
| 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) | |||
| 30380 | 30380 | 186493 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 23 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.8182 | 2105286.9549 | 37.7596074608269 | -122.509214881201 | (37.7596074608269, -122.509214881201) | |||
| 55566 | 55566 | 186757 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1200 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984856.9891 | 2106704.9578 | 37.7637342900898 | -122.49558192416201 | (37.7637342900898, -122.495581924162) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 58818 | 58818 | 186492 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980885.336 | 2105278.6712 | 37.759584746696 | -122.509212475259 | (37.759584746696, -122.509212475259) | |||
| 64716 | 64716 | 181389 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984901.4336 | 2104544.1716 | 37.7578039770978 | -122.495268847164 | (37.7578039770978, -122.495268847164) | |||
| 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) | |||
| 58408 | 58408 | 186491 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 21 | unknown : Yard 19 | Tree 1 | Private 1 | 8 | Width 0ft | 5980895.1728 | 2105273.4939 | 37.759571111269004 | -122.509178070846 | (37.759571111269, -122.509178070846) | |||
| 72243 | 72243 | 184831 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984632.352999999 | 2106892.4051 | 37.76423581086029 | -122.496372691447 | (37.7642358108603, -122.496372691447) | |||
| 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) | |||
| 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) | |||
| 129570 | 129570 | 186495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 20 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5980891.5487 | 2105262.6215 | 37.7595410451172 | -122.509189797166 | (37.7595410451172, -122.509189797166) | |||
| 49038 | 49038 | 186494 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 19 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980884.3005 | 2105262.6215 | 37.7595406177816 | -122.50921486458799 | (37.7595406177816, -122.509214864588) | |||
| 109788 | 109788 | 113131 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 185068 | 185068 | 194059 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 6011016.84858 | 2097513.47253 | 37.7399936365049 | -122.404455506617 | (37.7399936365049, -122.404455506617) | |||
| 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) | |||
| 36763 | 36763 | 194034 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 24th St | 18 | : Yard 23 | Tree 1 | Private 1 | 25 | 6017329.2954 | 2102592.85695 | 37.754291333594395 | -122.382982871671 | (37.7542913335944, -122.382982871671) | ||||
| 61230 | 61230 | 131762 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 24 Priest St | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 10ft | 6008325.68222 | 2117173.18984 | 37.793823884108896 | -122.41515173816799 | (37.7938238841089, -122.415151738168) | |||
| 69350 | 69350 | 186498 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 18 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980888.4423 | 2105252.2669 | 37.7595124312164 | -122.5091997715 | (37.7595124312164, -122.5091997715) | |||
| 75022 | 75022 | 210512 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 18 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 5997479.74459 | 2098569.7593 | 37.7421281351089 | -122.45133715141199 | (37.7421281351089, -122.451337151412) | |||
| 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) | |||
| 94966 | 94966 | 113130 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 151495 | 151495 | 194058 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 540 Barneveld Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6011019.935319999 | 2097525.87575 | 37.7400278655929 | -122.40444570672199 | (37.7400278655929, -122.404445706722) | |||
| 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) | |||
| 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) | |||
| 23747 | 23747 | 186497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980894.6551 | 2105244.501 | 37.7594914745751 | -122.509177708249 | (37.7594914745751, -122.509177708249) | |||
| 66632 | 66632 | 185873 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2000 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985024.9554 | 2101062.8913 | 37.748252570783 | -122.49458502538401 | (37.748252570783, -122.494585025384) | |||
| 120329 | 120329 | 113129 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 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) | ||
| 35294 | 35294 | 177823 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | Width 3ft | 6009246.7312 | 2086449.12039 | 37.7095141743011 | -122.409795064007 | (37.7095141743011, -122.409795064007) | |||
| 46197 | 46197 | 186496 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 16 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980891.5487 | 2105237.2527 | 37.7594713896823 | -122.509187913256 | (37.7594713896823, -122.509187913256) | |||
| 58476 | 58476 | 184827 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984631.5936 | 2106907.2141 | 37.764276427718 | -122.49637641074301 | (37.764276427718, -122.496376410743) | |||
| 74548 | 74548 | 210511 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 16 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997410.29084 | 2098566.36293 | 37.742114832343 | -122.451577054547 | (37.742114832343, -122.451577054547) | |||
| 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) | |||
| 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) | |||
| 100041 | 100041 | 113128 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1x TOMASO CT | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009323.0 | 2086334.0 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | |||||
| 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) | |||
| 133386 | 133386 | 181383 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1500 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984896.421 | 2104481.2352 | 37.757630877743395 | -122.495281541299 | (37.7576308777434, -122.495281541299) | |||
| 181863 | 181863 | 131761 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 24 Priest St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6008326.19973 | 2117161.77492 | 37.7937925706325 | -122.415149139144 | (37.7937925706325, -122.415149139144) | |||
| 27012 | 27012 | 186514 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 15 | unknown : Yard 19 | Tree 1 | Private 1 | 4 | Width 0ft | 5980897.7615 | 2105153.3803 | 37.759241466452295 | -122.509160198369 | (37.7592414664523, -122.509160198369) |
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");