Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1969 | 1969 | 198010 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 213 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | Permit Number 779305 | 6011863.46506 | 2111836.2655700003 | 37.7793681257663 | -122.40253514649099 | (37.7793681257663, -122.402535146491) | ||
| 24128 | 24128 | 198134 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6013337.1330699995 | 2095632.7165299999 | 37.7349588665628 | -122.396301078452 | (37.7349588665628, -122.396301078452) | |||
| 24340 | 24340 | 241638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005425.11854 | 2107744.6412400003 | 37.767771973225 | -122.424516988391 | (37.767771973225, -122.424516988391) | |||
| 24404 | 24404 | 246777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009797.217759999 | 2098767.51115 | 37.743368720206206 | -122.408760953364 | (37.7433687202062, -122.408760953364) | |||
| 24956 | 24956 | 198140 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 152 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6013267.76129 | 2095794.5918400001 | 37.7353994821874 | -122.396552266301 | (37.7353994821874, -122.396552266301) | |||
| 24967 | 24967 | 241232 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 127 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005861.10215 | 2108452.80959 | 37.7697410460526 | -122.42305931235201 | (37.7697410460526, -122.423059312352) | |||
| 25060 | 25060 | 85220 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 3 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.776221041753296 | -122.48131384215401 | (37.7762210417533, -122.481313842154) | ||
| 25109 | 25109 | 241253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 398 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005480.91961 | 2106731.68653 | 37.764993792043 | -122.424251927594 | (37.764993792043, -122.424251927594) | |||
| 25735 | 25735 | 246806 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 132 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6010286.59808 | 2099166.12262 | 37.744490619049294 | -122.407096884714 | (37.7444906190493, -122.407096884714) | |||
| 26511 | 26511 | 218506 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 331 Tara St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5997624.737980001 | 2089991.46593 | 37.7185824800643 | -122.450217619562 | (37.7185824800643, -122.450217619562) | |||
| 27314 | 27314 | 218570 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 98 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990761.96187 | 2094481.85885 | 37.7305168532543 | -122.47426667546002 | (37.7305168532543, -122.47426667546) | |||
| 27501 | 27501 | 198028 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Langton St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010225.17287 | 2110701.2793 | 37.7761601208299 | -122.40812264516 | (37.7761601208299, -122.40812264516) | |||
| 27759 | 27759 | 218515 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 312 Vernon St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992482.76796 | 2089904.38544 | 37.7180477764537 | -122.46798482193701 | (37.7180477764537, -122.467984821937) | |||
| 27858 | 27858 | 198136 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 27 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6014000.75949 | 2095429.8898900002 | 37.7344388515748 | -122.393992476471 | (37.7344388515748, -122.393992476471) | |||
| 27867 | 27867 | 241239 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 McCoppin St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6005928.367769999 | 2109150.09439 | 37.7716594186857 | -122.42287620587601 | (37.7716594186857, -122.422876205876) | |||
| 28080 | 28080 | 198006 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 238 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011475.496280001 | 2111728.4985 | 37.7790505553711 | -122.403869715215 | (37.7790505553711, -122.403869715215) | |||
| 28632 | 28632 | 198138 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 134 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6013340.1556400005 | 2095686.7025099997 | 37.7351072690864 | -122.396294410852 | (37.7351072690864, -122.396294410852) | |||
| 29242 | 29242 | 246450 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 425 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003711.71796 | 2099797.01906 | 37.7458527789913 | -122.429876467534 | (37.7458527789913, -122.429876467534) | |||
| 29757 | 29757 | 198021 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 217 Clara St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011882.31824 | 2111817.0211 | 37.7793163374183 | -122.40246857147699 | (37.7793163374183, -122.402468571477) | |||
| 29892 | 29892 | 247666 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 136 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6001948.31125 | 2108443.5233 | 37.7694939725921 | -122.436592856397 | (37.7694939725921, -122.436592856397) | |||
| 29994 | 29994 | 218514 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 312 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992482.71781 | 2089883.86567 | 37.71799143124971 | -122.467983503544 | (37.7179914312497, -122.467983503544) | |||
| 30269 | 30269 | 218547 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Elmhurst Dr | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991211.4167599995 | 2094496.23075 | 37.7305823428046 | -122.472713906928 | (37.7305823428046, -122.472713906928) | |||
| 30660 | 30660 | 198122 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Williams Ave | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013771.43179 | 2093619.4653599998 | 37.7294550480043 | -122.394658605233 | (37.7294550480043, -122.394658605233) | |||
| 31534 | 31534 | 202322 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 149 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6012943.5875699995 | 2093025.90325 | 37.727779187458296 | -122.39747895112 | (37.7277791874583, -122.39747895112) | |||
| 31648 | 31648 | 198026 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 370 07th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010608.77532 | 2110557.1414900003 | 37.7757858229832 | -122.406785493561 | (37.7757858229832, -122.406785493561) | |||
| 31723 | 31723 | 247796 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 410 30th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003801.70372 | 2098385.09969 | 37.7419810698755 | -122.429464637397 | (37.7419810698755, -122.429464637397) | |||
| 31750 | 31750 | 218522 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 516 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993271.7065 | 2090620.2984799999 | 37.7200590292793 | -122.465309800203 | (37.7200590292793, -122.465309800203) | |||
| 31831 | 31831 | 218523 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 506 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993270.87957 | 2090565.6413599998 | 37.7199089063619 | -122.465308690447 | (37.7199089063619, -122.465308690447) | |||
| 31853 | 31853 | 180223 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3602 Alemany Blvd | 8 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993236.04296 | 2087638.25257 | 37.7118689906411 | -122.46521658728099 | (37.7118689906411, -122.465216587281) | |||
| 33181 | 33181 | 218540 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5991304.84344 | 2094334.7083700001 | 37.7301442506463 | -122.472379149601 | (37.7301442506463, -122.472379149601) | |||
| 33587 | 33587 | 198007 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 274 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011297.08858 | 2111564.84003 | 37.7785912185545 | -122.404475379844 | (37.7785912185545, -122.404475379844) | |||
| 33686 | 33686 | 241242 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1320 Stevenson St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6006249.62904 | 2109085.1733 | 37.771499282705605 | -122.421760329799 | (37.7714992827056, -122.421760329799) | |||
| 33953 | 33953 | 247763 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6001651.1462 | 2108480.6901700003 | 37.769579132108205 | -122.43762339851101 | (37.7695791321082, -122.437623398511) | |||
| 34019 | 34019 | 218545 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 30 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5991243.29595 | 2094455.3235900002 | 37.730471867362205 | -122.47260071555799 | (37.7304718673622, -122.472600715558) | |||
| 35926 | 35926 | 198013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011579.13499 | 2111530.21874 | 37.778511914541895 | -122.403497231313 | (37.7785119145419, -122.403497231313) | |||
| 36358 | 36358 | 198143 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1655 Jerrold Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015049.24886 | 2097178.829 | 37.7392992978216 | -122.390489638682 | (37.7392992978216, -122.390489638682) | |||
| 37341 | 37341 | 218521 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 569 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993243.831619999 | 2090944.1329400002 | 37.7209465926795 | -122.46542966546801 | (37.7209465926795, -122.465429665468) | |||
| 37453 | 37453 | 198113 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 453 Mississippi St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014103.66815 | 2105000.08777 | 37.760722311801096 | -122.394306519737 | (37.7607223118011, -122.394306519737) | |||
| 37537 | 37537 | 247760 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 67 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6001664.39466 | 2108401.08395 | 37.769361306418 | -122.43757187093901 | (37.769361306418, -122.437571870939) | |||
| 37759 | 37759 | 241234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006307.196819999 | 2108475.9991099997 | 37.7698298819675 | -122.42151792831801 | (37.7698298819675, -122.421517928318) | |||
| 38237 | 38237 | 218573 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990744.9353 | 2094437.13782 | 37.73039307417179 | -122.474322276075 | (37.7303930741718, -122.474322276075) | |||
| 38718 | 38718 | 241233 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 121 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005881.34596 | 2108456.5771 | 37.7697525330713 | -122.422989557315 | (37.7697525330713, -122.422989557315) | |||
| 38834 | 38834 | 202325 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 135 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012883.64623 | 2093069.27547 | 37.7278949409987 | -122.39768921171199 | (37.7278949409987, -122.397689211712) | |||
| 38884 | 38884 | 180226 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2901 Ocean Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5989906.43638 | 2095240.30742 | 37.7325497599557 | -122.47727972718398 | (37.7325497599557, -122.477279727184) | |||
| 40089 | 40089 | 198130 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 81 Topeka Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012344.64179 | 2095362.1885400002 | 37.7341607757888 | -122.399713503797 | (37.7341607757888, -122.399713503797) | |||
| 40137 | 40137 | 218559 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990923.4815 | 2094514.63427 | 37.730616202260705 | -122.473710674116 | (37.7306162022607, -122.473710674116) | |||
| 40628 | 40628 | 247798 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 436 30th St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6003746.333330001 | 2098382.8174900003 | 37.7419716683528 | -122.429655927686 | (37.7419716683528, -122.429655927686) | |||
| 40931 | 40931 | 218564 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 77 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5990836.12868 | 2094496.30946 | 37.7305608273977 | -122.47401132646401 | (37.7305608273977, -122.474011326464) | |||
| 40989 | 40989 | 241240 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1301 Jessie St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6006461.320719999 | 2109025.58866 | 37.771347612922604 | -122.42102384438101 | (37.7713476129226, -122.421023844381) | |||
| 41290 | 41290 | 218537 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 169 Eucalyptus Dr | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991155.07657 | 2094656.4445 | 37.7310189879395 | -122.47292035978901 | (37.7310189879395, -122.472920359789) | |||
| 41395 | 41395 | 218560 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5990937.78345 | 2094514.9257599998 | 37.730617830926796 | -122.47366125186899 | (37.7306178309268, -122.473661251869) | |||
| 41570 | 41570 | 247781 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 266 30th St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6004850.70069 | 2098447.83797 | 37.7422126713879 | -122.425842004521 | (37.7422126713879, -122.425842004521) | |||
| 43133 | 43133 | 180229 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990564.5240400005 | 2094381.66097 | 37.7302302950786 | -122.47494192874201 | (37.7302302950786, -122.474941928742) | |||
| 43255 | 43255 | 218551 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 60 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991187.9738300005 | 2094540.77517 | 37.730703293514 | -122.47279819858 | (37.730703293514, -122.47279819858) | |||
| 43525 | 43525 | 250638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2609 Lake St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987350.36914 | 2114602.8431 | 37.7855653557873 | -122.487538422371 | (37.7855653557873, -122.487538422371) | |||
| 44252 | 44252 | 218541 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991287.109209999 | 2094336.12276 | 37.730147107779395 | -122.47244056159401 | (37.7301471077794, -122.472440561594) | |||
| 44387 | 44387 | 202306 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 160 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012951.54895 | 2092971.8033599998 | 37.7276310834963 | -122.397447635807 | (37.7276310834963, -122.397447635807) | |||
| 44655 | 44655 | 218546 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Elmhurst Dr | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991216.07157 | 2094485.7269 | 37.730553771324 | -122.472697049151 | (37.730553771324, -122.472697049151) | |||
| 45491 | 45491 | 198139 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 150 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013283.18276 | 2095780.0515 | 37.735360415658704 | -122.396497929253 | (37.7353604156587, -122.396497929253) | |||
| 45762 | 45762 | 198117 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 500 Toland St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012558.18705 | 2098832.22604 | 37.7437006707628 | -122.39921870850401 | (37.7437006707628, -122.399218708504) | |||
| 45821 | 45821 | 247817 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 564 30th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002957.26382 | 2098344.63275 | 37.7418221102078 | -122.432381547978 | (37.7418221102078, -122.432381547978) | |||
| 46171 | 46171 | 180230 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990563.35981 | 2094357.1779099999 | 37.7301630033059 | -122.474944167152 | (37.7301630033059, -122.474944167152) | |||
| 47484 | 47484 | 241647 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 50 Scott St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002452.37921 | 2108374.6636099997 | 37.769333532638505 | -122.434844382773 | (37.7693335326385, -122.434844382773) | |||
| 47751 | 47751 | 201529 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 718 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020227.99181 | 2093752.40727 | 37.7301769329099 | -122.372346575457 | (37.7301769329099, -122.372346575457) | |||
| 47758 | 47758 | 198126 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Williams Ave | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013842.551630001 | 2093605.35504 | 37.729420257733295 | -122.394411747628 | (37.7294202577333, -122.394411747628) | |||
| 48210 | 48210 | 217808 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Lee Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5996522.50518 | 2091865.3991200002 | 37.7236647198324 | -122.454162841049 | (37.7236647198324, -122.454162841049) | |||
| 48372 | 48372 | 241235 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006333.55405 | 2108477.41029 | 37.7698352428425 | -122.421426859387 | (37.7698352428425, -122.421426859387) | |||
| 48625 | 48625 | 241557 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3750 Market St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000178.6391 | 2102857.41231 | 37.7540551680289 | -122.442312985266 | (37.7540551680289, -122.442312985266) | |||
| 48753 | 48753 | 198110 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 500 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012942.32537 | 2104667.3106299997 | 37.7597439555289 | -122.398299761419 | (37.7597439555289, -122.398299761419) | |||
| 49427 | 49427 | 85218 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 1 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989075.71612 | 2111192.27037 | 37.7763013532486 | -122.481319447652 | (37.7763013532486, -122.481319447652) | ||
| 49912 | 49912 | 246603 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Waller St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6005584.08918 | 2109245.7263700003 | 37.7719025692852 | -122.42407388970899 | (37.7719025692852, -122.424073889709) | |||
| 51043 | 51043 | 218527 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 183 Eucalyptus Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5990817.95884 | 2094667.89607 | 37.7310309084509 | -122.474086656376 | (37.7310309084509, -122.474086656376) | |||
| 52517 | 52517 | 198125 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Williams Ave | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013825.74476 | 2093610.0448599998 | 37.72943220072 | -122.394470179266 | (37.72943220072, -122.394470179266) | |||
| 52578 | 52578 | 198141 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 162 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013199.84699 | 2095813.32575 | 37.7354471417785 | -122.396788385978 | (37.7354471417785, -122.396788385978) | |||
| 52791 | 52791 | 198120 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1715 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011096.260480001 | 2095120.5890400002 | 37.7334277240045 | -122.40401257884199 | (37.7334277240045, -122.404012578842) | |||
| 53379 | 53379 | 241254 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005428.00897 | 2107706.60063 | 37.767667686033896 | -122.42450428455 | (37.7676676860339, -122.42450428455) | |||
| 53730 | 53730 | 198131 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6013157.52169 | 2095742.10645 | 37.7352492324546 | -122.39692972971599 | (37.7352492324546, -122.396929729716) | |||
| 54019 | 54019 | 218510 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 330 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5996781.43157 | 2089689.53525 | 37.7177051527504 | -122.453110785357 | (37.7177051527504, -122.453110785357) | |||
| 54285 | 54285 | 247758 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 89 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6001675.24031 | 2108330.5572200003 | 37.769168274117796 | -122.43752930513 | (37.7691682741178, -122.43752930513) | |||
| 54848 | 54848 | 218569 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 95 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5990765.45397 | 2094449.75445 | 37.7304289049727 | -122.474252261144 | (37.7304289049727, -122.474252261144) | |||
| 55148 | 55148 | 247779 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 254 30th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6004930.81683 | 2098452.72536 | 37.74223061823729 | -122.42556533528999 | (37.7422306182373, -122.42556533529) | |||
| 55310 | 55310 | 198023 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 336 07th St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6010479.15286 | 2110685.94265 | 37.776132227452706 | -122.407242974182 | (37.7761322274527, -122.407242974182) | |||
| 55328 | 55328 | 241558 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 184 Marview Way | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5998169.83766 | 2103394.0693099997 | 37.7554139986847 | -122.449298535803 | (37.7554139986847, -122.449298535803) | |||
| 55453 | 55453 | 218520 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 286 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992992.28014 | 2089088.20524 | 37.7158361528844 | -122.466164394478 | (37.7158361528844, -122.466164394478) | |||
| 56078 | 56078 | 180232 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3353 19th Ave | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5990560.881159999 | 2094301.1206099999 | 37.7300089404634 | -122.47494864576001 | (37.7300089404634, -122.47494864576) | |||
| 56527 | 56527 | 201482 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019833.06925 | 2094138.86397 | 37.731216363049704 | -122.373738644125 | (37.7312163630497, -122.373738644125) | |||
| 57715 | 57715 | 241248 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1346 Stevenson St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6006262.59994 | 2108856.22438 | 37.7708713751436 | -122.421699198355 | (37.7708713751436, -122.421699198355) | |||
| 58256 | 58256 | 247669 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 154 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001934.24111 | 2108541.81832 | 37.7697630668318 | -122.436648561282 | (37.7697630668318, -122.436648561282) | |||
| 58259 | 58259 | 241644 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 415 Oak St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 5ft | 6004982.83626 | 2110199.4621900003 | 37.774487331444895 | -122.426221580476 | (37.7744873314449, -122.426221580476) | |||
| 58775 | 58775 | 202307 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 172 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6012991.60594 | 2092941.53695 | 37.7275502083622 | -122.397307035804 | (37.7275502083622, -122.397307035804) | |||
| 59731 | 59731 | 218550 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 25 Elmhurst Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5991159.53615 | 2094513.6265200002 | 37.7306271038561 | -122.472894532173 | (37.7306271038561, -122.472894532173) | |||
| 60837 | 60837 | 218562 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 71 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5990887.70773 | 2094513.01623 | 37.730609687575495 | -122.473834230193 | (37.7306096875755, -122.473834230193) | |||
| 61188 | 61188 | 198016 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 950 Clara St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6011600.73372 | 2111552.6255799998 | 37.7785746449277 | -122.40342408946199 | (37.7785746449277, -122.403424089462) | |||
| 61357 | 61357 | 198106 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 878 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011838.88261 | 2104286.50365 | 37.7586368163639 | -122.40208927521999 | (37.7586368163639, -122.40208927522) | |||
| 61703 | 61703 | 217809 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 199 Lee Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5996519.87412 | 2091846.99673 | 37.7236140403522 | -122.454170607597 | (37.7236140403522, -122.454170607597) | |||
| 62105 | 62105 | 241229 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 291 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004995.489019999 | 2108399.8809 | 37.769546832063 | -122.426049676848 | (37.769546832063, -122.426049676848) | |||
| 62659 | 62659 | 201486 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 934 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6019032.21192 | 2094642.96183 | 37.7325564518085 | -122.376542332772 | (37.7325564518085, -122.376542332772) | |||
| 62688 | 62688 | 198132 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 151 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6013262.28061 | 2095747.20787 | 37.7352690706072 | -122.39656789470101 | (37.7352690706072, -122.396567894701) | |||
| 62876 | 62876 | 218524 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 213 Bright St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5993735.17777 | 2088595.3117 | 37.7145256185467 | -122.463560865244 | (37.7145256185467, -122.463560865244) | |||
| 63123 | 63123 | 198020 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 217 Clara St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011870.90395 | 2111808.74197 | 37.7792929676258 | -122.402507476166 | (37.7792929676258, -122.402507476166) |
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");