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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47698 | 47698 | 114416 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 814 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2016 12:00:00 AM | 16 | 3x3 | Permit Number 777152 | 5982641.87614 | 2110195.3692 | 37.7731879935855 | -122.50350167093399 | (37.7731879935855, -122.503501670934) | |
| 64474 | 64474 | 248576 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 811 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 0ft | 5997625.7139 | 2107687.8398 | 37.7671724703286 | -122.45148995870599 | (37.7671724703286, -122.451489958706) | |||
| 159750 | 159750 | 118517 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8101 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 5981864.43372 | 2112332.50185 | 37.779010196034996 | -122.506349410333 | (37.779010196035, -122.506349410333) | |||
| 179361 | 179361 | 118518 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 8101 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5981838.6124 | 2112334.07721 | 37.7790130012815 | -122.506438851987 | (37.7790130012815, -122.506438851987) | |||
| 101700 | 101700 | 86749 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 115297 | 115297 | 86750 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 81 Parker Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49713 | 5996801.8 | 2114038.7 | 37.7845630578844 | -122.454798641129 | (37.7845630578844, -122.454798641129) | |||||
| 130548 | 130548 | 232315 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007376.9436800005 | 2098899.7250599996 | 37.7435958916461 | -122.41713902944599 | (37.7435958916461, -122.417139029446) | |||
| 102848 | 102848 | 115367 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 ELSIE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 35296 | 35296 | 75017 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Dorman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1997 12:00:00 AM | 14 | 6011095.51982 | 2097238.5902400003 | 37.7392432646533 | -122.40416415145201 | (37.7392432646533, -122.404164151452) | ||
| 93562 | 93562 | 110425 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 DORMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27x18 | 6011518.0 | 2097294.0 | 37.7394190054764 | -122.402707291584 | (37.7394190054764, -122.402707291584) | ||||
| 30242 | 30242 | 247859 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6009590.028030001 | 2098126.55062 | 37.741597175379894 | -122.409432139892 | (37.7415971753799, -122.409432139892) | ||||
| 60467 | 60467 | 247863 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6009595.21098 | 2098157.48801 | 37.7416824131186 | -122.409416401771 | (37.7416824131186, -122.409416401771) | ||||
| 69757 | 69757 | 247862 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6009589.386530001 | 2098133.6831900002 | 37.7416167239206 | -122.40943486124701 | (37.7416167239206, -122.409434861247) | ||||
| 73078 | 73078 | 247860 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 Bradford St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6009586.93034 | 2098129.5986 | 37.7416053709039 | -122.40944306575899 | (37.7416053709039, -122.409443065759) | ||||
| 64076 | 64076 | 123971 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 81 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5993620.07911 | 2114990.4545400003 | 37.7869932953347 | -122.465875406459 | (37.7869932953347, -122.465875406459) | |||
| 35286 | 35286 | 210569 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 808 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 5999463.6871 | 2095582.4040700002 | 37.7340389671147 | -122.444262698378 | (37.7340389671147, -122.444262698378) | |||
| 83799 | 83799 | 108198 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 808 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2014 12:00:00 AM | 3 | 2x2 | Permit Number 774168 | 5999486.009 | 2095579.2645400001 | 37.7340316201973 | -122.444185299389 | (37.7340316201973, -122.444185299389) | |
| 102337 | 102337 | 122407 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 801X Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999408.0 | 2095548.0 | 37.7339413243955 | -122.444452753551 | (37.7339413243955, -122.444452753551) | ||||
| 68763 | 68763 | 139062 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 PRESIDIO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999329.3818 | 2113770.5925 | 37.7839715649771 | -122.446034805746 | (37.7839715649771, -122.446034805746) | |||
| 69048 | 69048 | 139064 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 PRESIDIO AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5999320.1425 | 2113807.5496 | 37.78407251195679 | -122.44606942936001 | (37.7840725119568, -122.44606942936) | |||
| 121786 | 121786 | 139068 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 PRESIDIO AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999311.3652 | 2113860.6755 | 37.7842178806251 | -122.446103618119 | (37.7842178806251, -122.446103618119) | |||
| 137104 | 137104 | 139067 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 PRESIDIO AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5999313.675 | 2113848.6645 | 37.7841850334474 | -122.44609476283001 | (37.7841850334474, -122.44609476283) | |||
| 151885 | 151885 | 139063 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 PRESIDIO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5999323.3763 | 2113790.9189 | 37.7840270330457 | -122.446057045016 | (37.7840270330457, -122.446057045016) | |||
| 164443 | 164443 | 139065 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 PRESIDIO AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999317.8327 | 2113824.1804 | 37.784118043906105 | -122.44607861703001 | (37.7841180439061, -122.44607861703) | |||
| 165036 | 165036 | 139066 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 PRESIDIO AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999316.4468 | 2113836.1914 | 37.7841509438451 | -122.44608427595101 | (37.7841509438451, -122.446084275951) | |||
| 82981 | 82981 | 110866 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 INDIANA ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 141460 | 141460 | 110877 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 INDIANA ST | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 83432 | 83432 | 113936 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 EL CAMINO DEL MAR | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 776988 | 5985966.0 | 2115003.0 | 37.7865832348262 | -122.49235734524099 | (37.7865832348262, -122.492357345241) | |||
| 27011 | 27011 | 210522 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 800 Capitol Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5995082.26055 | 2089674.2189 | 37.717565568077504 | -122.45898290776 | (37.7175655680775, -122.45898290776) | |||
| 122215 | 122215 | 210513 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 80 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 2ft | 5994133.52144 | 2093284.9810400002 | 37.7274252664575 | -122.46252400540001 | (37.7274252664575, -122.4625240054) | |||
| 11349 | 11349 | 104508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 80 Dichiera Ct | 1 | Sidewalk: Curb side : Hanging Pot 15 | Tree 1 | Private 1 | 14 | 5998566.299869999 | 2087993.98473 | 37.7131516918716 | -122.446819386407 | (37.7131516918716, -122.446819386407) | ||||
| 117435 | 117435 | 116953 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 80 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778114 | 5993978.14384 | 2115037.85395 | 37.7871440899951 | -122.464640036112 | (37.7871440899951, -122.464640036112) | |
| 24447 | 24447 | 201523 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 799 Earl St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 6020371.96237 | 2093662.3098400002 | 37.729937451546704 | -122.371842613372 | (37.7299374515467, -122.371842613372) | |||
| 35675 | 35675 | 248578 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 798 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5998643.5224 | 2107650.8947 | 37.76712925981371 | -122.447966864543 | (37.7671292598137, -122.447966864543) | |||
| 128594 | 128594 | 99800 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 795-797 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001281.0 | 2102008.0 | 37.7517856535599 | -122.438439910597 | (37.7517856535599, -122.438439910597) | ||||
| 32461 | 32461 | 232382 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 795 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6001307.04772 | 2102006.18851 | 37.7517821612399 | -122.438349704471 | (37.7517821612399, -122.438349704471) | |||
| 114602 | 114602 | 123085 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 791 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 5992248.35007 | 2110069.1867 | 37.773401613050204 | -122.470262725333 | (37.7734016130502, -122.470262725333) | ||||
| 116093 | 116093 | 122335 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 791 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992232.0 | 2110077.0 | 37.773422120973294 | -122.47031985112801 | (37.7734221209733, -122.470319851128) | ||||
| 88289 | 88289 | 61437 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 788 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2016 12:00:00 AM | 3 | Permit Number 778418 | 5993530.07441 | 2110197.53457 | 37.7738280413865 | -122.46583842282101 | (37.7738280413865, -122.465838422821) | ||
| 133821 | 133821 | 131769 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 787 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007533.34863 | 2120903.60484 | 37.804022109787 | -122.418157889387 | (37.804022109787, -122.418157889387) | |||
| 103266 | 103266 | 113354 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7802x GEARY BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5982855.0 | 2112422.0 | 37.7793142001238 | -122.502929326548 | (37.7793142001238, -122.502929326548) | |||
| 143205 | 143205 | 117682 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7800 Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/2016 12:00:00 AM | 3 | Width 3ft | Permit Number 778742 | 5982589.466109999 | 2112438.09785 | 37.779342790231794 | -122.503849096172 | (37.7793427902318, -122.503849096172) | |
| 76432 | 76432 | 119184 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 780 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5980778.38631 | 2110329.2751 | 37.773445928821 | -122.50995756013201 | (37.773445928821, -122.509957560132) | |||
| 149703 | 149703 | 119185 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 780 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5980776.33193 | 2110309.65746 | 37.773391943392895 | -122.50996320873999 | (37.7733919433929, -122.50996320874) | |||
| 60866 | 60866 | 119183 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 770 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5980769.13154 | 2110513.52409 | 37.773951276407296 | -122.510003263739 | (37.7739512764073, -122.510003263739) | |||
| 74443 | 74443 | 119182 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 770 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5980768.60163 | 2110516.49212 | 37.7739593944882 | -122.510005317294 | (37.7739593944882, -122.510005317294) | |||
| 157863 | 157863 | 50783 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 770 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/2004 12:00:00 AM | 14 | Permit Number 47309 | 5980766.08534 | 2110461.55309 | 37.7738083996933 | -122.51000993912201 | (37.7738083996933, -122.510009939122) | ||
| 85539 | 85539 | 115935 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 76 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2016 12:00:00 AM | 3 | 4x4 | Permit Number 777731 | 5993976.17903 | 2115057.9216 | 37.7871990770116 | -122.46464829162501 | (37.7871990770116, -122.464648291625) | |
| 65922 | 65922 | 119179 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 756 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5980765.91375 | 2110586.65735 | 37.7741518889865 | -122.51001982865499 | (37.7741518889865, -122.510019828655) | |||
| 72413 | 72413 | 119180 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 756 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5980766.807680001 | 2110581.0869 | 37.774136646898704 | -122.510016322531 | (37.7741366468987, -122.510016322531) | |||
| 187547 | 187547 | 119178 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 756 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5980765.96509 | 2110596.91774 | 37.7741800640196 | -122.510020413475 | (37.7741800640196, -122.510020413475) | |||
| 32892 | 32892 | 131757 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 755 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008986.6989400005 | 2115264.8401099998 | 37.788621146006605 | -122.412729575233 | (37.7886211460066, -122.412729575233) | |||
| 168348 | 168348 | 232381 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6001515.59518 | 2102015.31372 | 37.7518190765997 | -122.437629173953 | (37.7518190765997, -122.437629173953) | |||
| 74023 | 74023 | 76347 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 15 | 6013052.749419999 | 2119171.30409 | 37.7995747464454 | -122.398935843819 | (37.7995747464454, -122.398935843819) | ||
| 148556 | 148556 | 53965 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 17 | Permit Number 9680 | 6013049.6563099995 | 2119205.04164 | 37.799667209323 | -122.39894891638001 | (37.799667209323, -122.39894891638) | |
| 160901 | 160901 | 76366 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 753 Davis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 7 | 6013050.90203 | 2119190.90632 | 37.7996284665342 | -122.398943613057 | (37.7996284665342, -122.398943613057) | ||
| 38712 | 38712 | 119177 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 750 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5980764.81035 | 2110613.93297 | 37.7742267147145 | -122.51002567219601 | (37.7742267147145, -122.510025672196) | |||
| 123095 | 123095 | 63455 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 746 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1990 12:00:00 AM | Permit Number 28489 | 6007346.89818679 | 2095405.54054849 | 37.7339999430548 | -122.41699539620001 | (37.7339999430548, -122.4169953962) | ||
| 56572 | 56572 | 119176 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 742 La Playa | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 5980756.08521 | 2110656.0073 | 37.7743417237871 | -122.51005897992701 | (37.7743417237871, -122.510058979927) | |||
| 154259 | 154259 | 119175 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 742 La Playa | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5980756.90149 | 2110662.55033 | 37.7743597371632 | -122.510056642513 | (37.7743597371632, -122.510056642513) | |||
| 64765 | 64765 | 232392 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 740 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6004282.37729 | 2104575.33754 | 37.7590052236258 | -122.428243693507 | (37.7590052236258, -122.428243693507) | |||
| 98878 | 98878 | 121566 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 740 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004294.0 | 2104553.0 | 37.7589445476691 | -122.42820190474801 | (37.7589445476691, -122.428201904748) | ||||
| 146205 | 146205 | 121565 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 740 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6004294.0 | 2104553.0 | 37.7589445476691 | -122.42820190474801 | (37.7589445476691, -122.428201904748) | |||
| 160444 | 160444 | 232391 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 740 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6004280.91328 | 2104592.0184 | 37.759050942474204 | -122.428249945578 | (37.7590509424742, -122.428249945578) | |||
| 74293 | 74293 | 210566 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 739 Ulloa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 5993848.55082 | 2098110.04723 | 37.7406572903047 | -122.463859221646 | (37.7406572903047, -122.463859221646) | |||
| 137577 | 137577 | 119173 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 738 La Playa | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5980756.1033 | 2110688.30545 | 37.774430406044296 | -122.510061317362 | (37.7744304060443, -122.510061317362) | |||
| 160807 | 160807 | 119174 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 738 La Playa | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5980754.24139 | 2110680.27075 | 37.7744082353086 | -122.51006716089898 | (37.7744082353086, -122.510067160899) | |||
| 4023 | 4023 | 232380 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 6001617.91184 | 2102022.2796 | 37.7518440201921 | -122.437275848296 | (37.7518440201921, -122.437275848296) | |||
| 99570 | 99570 | 56660 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 737 ELIZABETH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 5x5 | 6001647.0 | 2102006.0 | 37.7518009738438 | -122.437174092108 | (37.7518009738438, -122.437174092108) | |||
| 150114 | 150114 | 119172 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 734 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5980761.412719999 | 2110715.27486 | 37.7745047692475 | -122.510044955434 | (37.7745047692475, -122.510044955434) | |||
| 167806 | 167806 | 119171 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 734 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5980760.66584 | 2110719.83278 | 37.774517239898294 | -122.510047877677 | (37.7745172398983, -122.510047877677) | |||
| 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) | |||
| 9861 | 9861 | 118901 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980648.88475 | 2109606.3629099997 | 37.7714533859213 | -122.510351791198 | (37.7714533859213, -122.510351791198) | |
| 9874 | 9874 | 118902 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980610.1556400005 | 2109606.19987 | 37.771450653513206 | -122.510485742594 | (37.7714506535132, -122.510485742594) | |
| 88588 | 88588 | 118899 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7300 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5980716.90165 | 2109609.13106 | 37.771464998604 | -122.510116727255 | (37.771464998604, -122.510116727255) | ||||
| 71815 | 71815 | 232416 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Digby St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 6002653.7216300005 | 2097679.65766 | 37.7399790261155 | -122.433383588775 | (37.7399790261155, -122.433383588775) | |||
| 172858 | 172858 | 187572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 73 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6010864.17104 | 2089487.4487 | 37.7179473203875 | -122.404418609237 | (37.7179473203875, -122.404418609237) | ||||
| 36377 | 36377 | 119170 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 728 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980760.8194 | 2110774.16468 | 37.774666428317104 | -122.51005138377701 | (37.7746664283171, -122.510051383777) | |||
| 111711 | 111711 | 98201 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 727 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001823.0 | 2099994.0 | 37.746286502669896 | -122.436421473679 | (37.7462865026699, -122.436421473679) | ||||
| 127929 | 127929 | 106934 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 725 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 9x6 | 6002468.8 | 2103993.4 | 37.7573045800385 | -122.43447428318501 | (37.7573045800385, -122.434474283185) | |||
| 35056 | 35056 | 137701 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 724 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000080.8136 | 2111324.1322 | 37.7772970942344 | -122.44325936134399 | (37.7772970942344, -122.443259361344) | |||
| 179327 | 179327 | 109508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7200X Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5981051.27607 | 2109621.18503 | 37.771517812403296 | -122.508961024865 | (37.7715178124033, -122.508961024865) | |||
| 118624 | 118624 | 109510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 7200X FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5980935.0 | 2109588.0 | 37.7714198408482 | -122.509360757847 | (37.7714198408482, -122.509360757847) | ||||
| 27203 | 27203 | 210530 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 717 Sargent St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 5992156.75064 | 2089178.54268 | 37.7160359561589 | -122.46905891645399 | (37.7160359561589, -122.469058916454) | |||
| 46531 | 46531 | 119167 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 716 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980755.1675 | 2110858.13796 | 37.7748966607872 | -122.510077174438 | (37.7748966607872, -122.510077174438) | |||
| 148637 | 148637 | 119168 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 716 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5980756.29412 | 2110846.59632 | 37.77486503730329 | -122.510072419645 | (37.7748650373033, -122.510072419645) | |||
| 169814 | 169814 | 104246 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 715 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 770520 | 5999995.1 | 2111472.0 | 37.7776982134721 | -122.443566496179 | (37.7776982134721, -122.443566496179) | |||
| 110927 | 110927 | 52190 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 71 Eagle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48381 | 5999969.39262726 | 2104422.33072392 | 37.758340122613795 | -122.44314899255 | (37.7583401226138, -122.44314899255) | ||||
| 126881 | 126881 | 40087 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 708 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/1999 12:00:00 AM | Permit Number 41310 | 6002385.65008555 | 2104050.52983918 | 37.7574567244894 | -122.434765933114 | (37.7574567244894, -122.434765933114) | |||
| 127923 | 127923 | 81254 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2016 12:00:00 AM | 3 | 3x3 | 5989768.37779 | 2110442.38687 | 37.7742826266156 | -122.478868506685 | (37.7742826266156, -122.478868506685) | |
| 10039 | 10039 | 106657 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 706 20TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2016 12:00:00 AM | 10 | 3x3 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | ||
| 87683 | 87683 | 24704 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 7040 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5985122.8914 | 2112550.40448 | 37.7797997921083 | -122.49509333148701 | (37.7797997921083, -122.495093331487) | |||
| 117745 | 117745 | 120739 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 704 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5989768.45154 | 2110490.84197 | 37.774415675251795 | -122.47887179631 | (37.7744156752518, -122.47887179631) | ||||
| 117949 | 117949 | 98373 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 701@ de Soto Urbano Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993201.0 | 2091808.0 | 37.7233160913053 | -122.46564044909799 | (37.7233160913053, -122.465640449098) | |||||
| 694 | 694 | 120738 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700x 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Width 4ft | 5989768.19982 | 2110516.41697 | 37.7744858825371 | -122.478874537994 | (37.7744858825371, -122.478874537994) | ||
| 720 | 720 | 104746 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989767.16587 | 2110527.4876599996 | 37.774516219561704 | -122.478878924469 | (37.7745162195617, -122.478878924469) | |
| 717 | 717 | 106656 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 700X 20TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779658 | 5989753.9107099995 | 2110247.9151 | 37.773747820615704 | -122.47890432357 | (37.7737478206157, -122.47890432357) | |
| 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) | |||
| 29143 | 29143 | 248220 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007112.652530001 | 2099342.90806 | 37.7447979012027 | -122.41808429785499 | (37.7447979012027, -122.418084297855) | ||||
| 56892 | 56892 | 248221 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 70 Fair Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6007127.43713 | 2099336.46972 | 37.744781055094705 | -122.418032719051 | (37.7447810550947, -122.418032719051) |
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");