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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 35930 | 35930 | 194083 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 6011094.10915 | 2097586.53301 | 37.74019856231661 | -122.40419351074199 | (37.7401985623166, -122.404193510742) | |||
| 52437 | 52437 | 232289 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 0 San Jose Av Off Ramp | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 9ft | 6002953.30911 | 2095259.2744599998 | 37.7333502006365 | -122.43217493415301 | (37.7333502006365, -122.432174934153) | |||
| 56393 | 56393 | 232297 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 301 Putnam St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 9ft | 6009073.4894199995 | 2095823.27697 | 37.73524393096471 | -122.411055511504 | (37.7352439309647, -122.411055511504) | |||
| 147673 | 147673 | 194031 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1101 25th St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 9ft | 6015324.74216 | 2102030.33526 | 37.7526358040022 | -122.38987589096901 | (37.7526358040022, -122.389875890969) | |||
| 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) | |||
| 167388 | 167388 | 194082 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 495 Barneveld Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 9ft | 6011088.380890001 | 2097569.3881900003 | 37.7401511662306 | -122.404212110497 | (37.7401511662306, -122.404212110497) | |||
| 26950 | 26950 | 232415 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 297 Addison St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6002483.65032 | 2097689.74607 | 37.7399970763969 | -122.43397234527201 | (37.7399970763969, -122.433972345272) | |||
| 38897 | 38897 | 177806 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009249.93875 | 2086480.54598 | 37.709600642326606 | -122.409786194885 | (37.7096006423266, -122.409786194885) | |||
| 53387 | 53387 | 232323 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 8ft | 6001401.88129 | 2099374.4805 | 37.7445615107998 | -122.43783328409599 | (37.7445615107998, -122.437833284096) | |||
| 54124 | 54124 | 232324 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 28th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 6001424.417119999 | 2099374.2637099996 | 37.7445621969905 | -122.437755344346 | (37.7445621969905, -122.437755344346) | |||
| 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) | |||
| 66158 | 66158 | 232325 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 689 28th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 6001461.4288099995 | 2099378.40597 | 37.7445756751258 | -122.43762766218599 | (37.7445756751258, -122.437627662186) | |||
| 68612 | 68612 | 232326 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 683 28th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6001524.1187 | 2099381.75589 | 37.744588437417 | -122.43741113332199 | (37.744588437417, -122.437411133322) | |||
| 133482 | 133482 | 232403 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3977 22nd St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 8ft | 6001960.85303 | 2102925.1671599997 | 37.754342622815706 | -122.43615451782301 | (37.7543426228157, -122.436154517823) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 162173 | 162173 | 177805 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 8ft | 6009236.846480001 | 2086428.13607 | 37.709456001673296 | -122.409827747151 | (37.7094560016733, -122.409827747151) | |||
| 184202 | 184202 | 177807 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 62 Tomaso Ct | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 8ft | 6009274.965480001 | 2086528.64182 | 37.7097341062031 | -122.409703090337 | (37.7097341062031, -122.409703090337) | |||
| 52622 | 52622 | 194098 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 389 Townsend St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 7ft | 6013425.60382 | 2110329.05815 | 37.7753167635898 | -122.397025307881 | (37.7753167635898, -122.397025307881) | |||
| 58531 | 58531 | 194097 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 389 Townsend St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6013417.2361 | 2110322.9726299997 | 37.775299588326995 | -122.39705382716998 | (37.775299588327, -122.39705382717) | |||
| 24344 | 24344 | 232330 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6002073.993430001 | 2098798.17814 | 37.743017315492295 | -122.435468040134 | (37.7430173154923, -122.435468040134) | |||
| 25040 | 25040 | 210510 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 13 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 6ft | 5997279.39992 | 2098558.56074 | 37.7420859128371 | -122.452029069086 | (37.7420859128371, -122.452029069086) | |||
| 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) | |||
| 27210 | 27210 | 118030 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 Shore View Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 6ft | 5984259.34297 | 2112813.72518 | 37.7804722014619 | -122.498100130783 | (37.7804722014619, -122.498100130783) | |||
| 27862 | 27862 | 194050 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2246 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 6ft | 6012135.46921 | 2099441.05415 | 37.7453488151107 | -122.400723136672 | (37.7453488151107, -122.400723136672) | |||
| 34033 | 34033 | 177850 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1260 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 6ft | 6001426.1792 | 2087609.14768 | 37.7122579779848 | -122.43690715954399 | (37.7122579779848, -122.436907159544) | |||
| 38473 | 38473 | 232296 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2648 Bryant St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 6009743.74395 | 2101924.55432 | 37.7520342699699 | -122.40916858006001 | (37.7520342699699, -122.40916858006) | |||
| 53960 | 53960 | 232354 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 6ft | 6003303.21337 | 2100010.18921 | 37.746414952387 | -122.431304232109 | (37.746414952387, -122.431304232109) | |||
| 54731 | 54731 | 232355 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Noe St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 6ft | 6003303.86784 | 2100027.43262 | 37.746462335861295 | -122.43130319968999 | (37.7464623358613, -122.43130319969) | |||
| 65349 | 65349 | 177811 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 533 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6002001.20972 | 2090373.7008099998 | 37.7198814941283 | -122.435117291057 | (37.7198814941283, -122.435117291057) | |||
| 69526 | 69526 | 177851 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1260 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 6ft | 6001405.83426 | 2087613.5591099998 | 37.712268934433 | -122.436977793197 | (37.712268934433, -122.436977793197) | |||
| 71281 | 71281 | 232353 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Noe St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 6ft | 6003304.68613 | 2099994.68694 | 37.74637247023129 | -122.43129803308099 | (37.7463724702313, -122.431298033081) | |||
| 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) | |||
| 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) | |||
| 131380 | 131380 | 194064 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1640 Davidson Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 6ft | 6014536.55143 | 2099742.5606 | 37.7463103162609 | -122.3924416073 | (37.7463103162609, -122.3924416073) | |||
| 133073 | 133073 | 210508 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 6ft | 5997156.34573 | 2098551.2278 | 37.7420587290339 | -122.452454020343 | (37.7420587290339, -122.452454020343) | |||
| 156154 | 156154 | 232331 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6002072.189119999 | 2098811.70513 | 37.7430543549658 | -122.43547524639999 | (37.7430543549658, -122.4354752464) | |||
| 160197 | 160197 | 232329 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6002075.1191 | 2098772.01072 | 37.7429455298129 | -122.435462276374 | (37.7429455298129, -122.435462276374) | |||
| 170140 | 170140 | 210506 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997067.619580001 | 2098546.7599 | 37.7420413775124 | -122.452760483218 | (37.7420413775124, -122.452760483218) | |||
| 173881 | 173881 | 232322 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1430 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 6ft | 6001368.29061 | 2099487.1068599997 | 37.7448688460173 | -122.437957499335 | (37.7448688460173, -122.437957499335) | |||
| 174795 | 174795 | 210507 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 5997086.47327 | 2098548.0515900003 | 37.7420460045079 | -122.452695386699 | (37.7420460045079, -122.452695386699) | |||
| 180202 | 180202 | 232328 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1801 Diamond St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 6ft | 6002075.48932 | 2098744.22684 | 37.742869262806295 | -122.435459009147 | (37.7428692628063, -122.435459009147) | |||
| 184351 | 184351 | 210509 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 57 Agua Way | 12 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 6ft | 5997270.91609 | 2098557.47378 | 37.7420824423506 | -122.452058324935 | (37.7420824423506, -122.452058324935) | |||
| 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) | |||
| 24632 | 24632 | 124488 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3015 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 5996527.76957 | 2111462.12046 | 37.7774727294111 | -122.45556039254299 | (37.7774727294111, -122.455560392543) | |||
| 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) | |||
| 38293 | 38293 | 232374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1401 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 5997728.65176 | 2105894.8974 | 37.7622553995774 | -122.45100460999201 | (37.7622553995774, -122.451004609992) | |||
| 38798 | 38798 | 131726 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 58 Iris Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 5ft | 5997639.46293 | 2114124.8782099998 | 37.7848476941144 | -122.451906844923 | (37.7848476941144, -122.451906844923) | |||
| 38940 | 38940 | 123608 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 121 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 5995078.16732 | 2114887.75716 | 37.7867953195114 | -122.46082333969 | (37.7867953195114, -122.46082333969) | |||
| 45881 | 45881 | 210469 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1746 Noriega St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5991258.53148 | 2103577.67743 | 37.7555203884603 | -122.47321309092399 | (37.7555203884603, -122.473213090924) | |||
| 46314 | 46314 | 124562 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3965 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 5995779.50166 | 2114828.85193 | 37.7866739098603 | -122.45839263777599 | (37.7866739098603, -122.458392637776) | |||
| 54114 | 54114 | 210568 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 163 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 5ft | 5999033.69954 | 2095485.54294 | 37.7337484681112 | -122.445742329568 | (37.7337484681112, -122.445742329568) | |||
| 56871 | 56871 | 194048 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1242 19th St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013830.06416 | 2105268.62635 | 37.761444447624 | -122.395271611894 | (37.761444447624, -122.395271611894) | |||
| 58000 | 58000 | 131742 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000648.257180001 | 2117809.9934900003 | 37.795137933933795 | -122.44176199223499 | (37.7951379339338, -122.441761992235) | |||
| 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) | |||
| 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) | |||
| 76644 | 76644 | 131743 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000645.36321 | 2117825.80498 | 37.795181183232 | -122.441773141117 | (37.795181183232, -122.441773141117) | |||
| 123490 | 123490 | 194051 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1598 Bay Shore Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 5ft | 6011883.611959999 | 2091657.73213 | 37.7239633945918 | -122.401047236139 | (37.7239633945918, -122.401047236139) | |||
| 132634 | 132634 | 121900 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 254 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 5990584.41399 | 2113700.38484 | 37.7832755410067 | -122.476283745511 | (37.7832755410067, -122.476283745511) | |||
| 133646 | 133646 | 194053 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 Patterson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 5ft | 6010891.45102 | 2098447.80375 | 37.7425521007081 | -122.40495484979999 | (37.7425521007081, -122.4049548498) | |||
| 134278 | 134278 | 124568 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3937 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5995960.78952 | 2114853.67518 | 37.786752484144394 | -122.45776722619301 | (37.7867524841444, -122.457767226193) | |||
| 137102 | 137102 | 194052 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 101 Patterson St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 5ft | 6010878.398080001 | 2098425.29219 | 37.7424895591595 | -122.404998398575 | (37.7424895591595, -122.404998398575) | |||
| 146997 | 146997 | 124563 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3961 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5995805.4951 | 2114830.61556 | 37.7866802460312 | -122.458302834998 | (37.7866802460312, -122.458302834998) | |||
| 155753 | 155753 | 194045 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 5ft | 6013807.05349 | 2105290.79153 | 37.7615040286026 | -122.395352749639 | (37.7615040286026, -122.395352749639) | |||
| 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) | |||
| 160287 | 160287 | 248281 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 105 Lundy's Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 5ft | 6006851.95643 | 2098931.00797 | 37.7436522395523 | -122.418956528726 | (37.7436522395523, -122.418956528726) | |||
| 160978 | 160978 | 131708 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3881 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5996259.7942 | 2115551.43815 | 37.7886855266525 | -122.456783230762 | (37.7886855266525, -122.456783230762) | |||
| 163421 | 163421 | 194046 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 399 Texas St | 2 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6013804.04007 | 2105323.21797 | 37.761592896918394 | -122.395365443572 | (37.7615928969184, -122.395365443572) | |||
| 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) | |||
| 177620 | 177620 | 210577 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 371 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5997627.625030001 | 2093788.53301 | 37.72900850132 | -122.45048122525499 | (37.72900850132, -122.450481225255) | |||
| 179465 | 179465 | 118837 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 600 46th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5981666.867000001 | 2111590.99028 | 37.776962590483606 | -122.506977842076 | (37.7769625904836, -122.506977842076) | |||
| 184821 | 184821 | 131744 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2760 Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6000643.38971 | 2117843.6395400004 | 37.7952300397944 | -122.44178125031401 | (37.7952300397944, -122.441781250314) | |||
| 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) | ||
| 21679 | 21679 | 210472 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 624 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 4ft | 5993801.69661 | 2106684.35823 | 37.764197452264106 | -122.464643687651 | (37.7641974522641, -122.464643687651) | ||||
| 23645 | 23645 | 131755 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1856 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6005252.93645 | 2117501.9314 | 37.7945533647075 | -122.425807142281 | (37.7945533647075, -122.425807142281) | |||
| 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) | |||
| 25983 | 25983 | 131696 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3848 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000612.30159 | 2121584.19581 | 37.805498841559896 | -122.44215746010799 | (37.8054988415599, -122.442157460108) | |||
| 26327 | 26327 | 131735 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2901 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6000766.13673 | 2116181.54807 | 37.7906733647218 | -122.441237215332 | (37.7906733647218, -122.441237215332) | |||
| 28261 | 28261 | 250625 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 148 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 4ft | 5987117.9845 | 2114972.6519400002 | 37.7865671888719 | -122.488369582106 | (37.7865671888719, -122.488369582106) | |||
| 28286 | 28286 | 123346 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 421 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5994637.6503 | 2112621.39371 | 37.7805471408016 | -122.46218298840701 | (37.7805471408016, -122.462182988407) | |||
| 30602 | 30602 | 210503 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 310 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5994323.53168 | 2100040.5869400003 | 37.7459854289939 | -122.46235691856 | (37.7459854289939, -122.46235691856) | |||
| 31033 | 31033 | 210542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 563 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5994214.54213 | 2099478.38125 | 37.7444354771197 | -122.462693010487 | (37.7444354771197, -122.462693010487) | |||
| 31048 | 31048 | 250804 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 278 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5986226.67348 | 2114062.55405 | 37.784016278077004 | -122.491386246398 | (37.784016278077, -122.491386246398) | |||
| 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) | |||
| 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) | |||
| 33386 | 33386 | 131733 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2999 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000450.462280001 | 2116133.47283 | 37.7905233758091 | -122.442325975968 | (37.7905233758091, -122.442325975968) | |||
| 35003 | 35003 | 177847 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 230 Amherst St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007482.57456 | 2092682.0687799999 | 37.726529511124504 | -122.416333484222 | (37.7265295111245, -122.416333484222) | |||
| 35943 | 35943 | 250913 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 294 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5986849.63689 | 2114000.26937 | 37.7838816450719 | -122.489226467848 | (37.7838816450719, -122.489226467848) | |||
| 36179 | 36179 | 232334 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 986 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 6000140.77216 | 2101983.38554 | 37.7516531444772 | -122.442381194354 | (37.7516531444772, -122.442381194354) | |||
| 37000 | 37000 | 194030 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 400 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6010602.35914 | 2106418.8479400002 | 37.764422659590295 | -122.40651601353001 | (37.7644226595903, -122.40651601353) | |||
| 39763 | 39763 | 232335 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 986 Elizabeth St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 6000130.35257 | 2101984.21301 | 37.751654822617795 | -122.442417285937 | (37.7516548226178, -122.442417285937) | |||
| 41165 | 41165 | 232300 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 203 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6004767.84264 | 2102447.8829200002 | 37.7531911893481 | -122.426413246674 | (37.7531911893481, -122.426413246674) | |||
| 41226 | 41226 | 131752 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1690 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005571.69035 | 2117900.5185 | 37.7956657919092 | -122.424732581057 | (37.7956657919092, -122.424732581057) | |||
| 41449 | 41449 | 210540 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 555 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5994248.82053 | 2099506.69967 | 37.7445152065234 | -122.462576537499 | (37.7445152065234, -122.462576537499) | |||
| 41476 | 41476 | 118681 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 4749 Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5980787.4165900005 | 2110915.9594099997 | 37.775057323510104 | -122.50996991648199 | (37.7750573235101, -122.509969916482) | |||
| 43960 | 43960 | 232361 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 869 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 4ft | 6000744.54456 | 2101976.60754 | 37.751668928482204 | -122.440292790492 | (37.7516689284822, -122.440292790492) | |||
| 46278 | 46278 | 232312 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 15 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6007285.12452 | 2099492.28549 | 37.745217764096104 | -122.417498505571 | (37.7452177640961, -122.417498505571) | |||
| 46518 | 46518 | 131745 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2761 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000588.687530001 | 2117833.1066900003 | 37.795198002331794 | -122.44196977160802 | (37.7951980023318, -122.441969771608) |
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");