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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105502 | 105502 | 98375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 106 De Soto St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5993231.0 | 2091825.0 | 37.7233644995117 | -122.465537980019 | (37.7233644995117, -122.465537980019) | |||||
| 77652 | 77652 | 31202 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 276 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/1969 12:00:00 AM | Permit Number 34894 | 5995678.83964111 | 2091843.96330625 | 37.7235574477937 | -122.45707767911101 | (37.7235574477937, -122.457077679111) | |||
| 70914 | 70914 | 177848 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 25 Karen Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010462.0616 | 2091541.1514400002 | 37.7235638851352 | -122.40595312605 | (37.7235638851352, -122.40595312605) | |||
| 109527 | 109527 | 41271 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 229 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/1999 12:00:00 AM | Permit Number 41954 | 5994679.37055115 | 2091871.07942789 | 37.723574453453494 | -122.460534605902 | (37.7235744534535, -122.460534605902) | |||
| 165720 | 165720 | 177844 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1545 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007019.074580001 | 2091714.87456 | 37.723847729182296 | -122.417867259073 | (37.7238477291823, -122.417867259073) | |||
| 157191 | 157191 | 177845 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1533 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007070.86377 | 2091727.73406 | 37.7238859530695 | -122.417689142941 | (37.7238859530695, -122.417689142941) | |||
| 162697 | 162697 | 177846 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1533 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007122.13957 | 2091744.78081 | 37.723935645089895 | -122.417513097957 | (37.7239356450899, -122.417513097957) | |||
| 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) | |||
| 11806 | 11806 | 15748 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 4617 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002094.7066 | 2092005.3194 | 37.7243668615839 | -122.43491072988998 | (37.7243668615839, -122.43491072989) | |||
| 138760 | 138760 | 25260 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5995011.81264 | 2092264.9607400002 | 37.7246750767236 | -122.45941393184799 | (37.7246750767236, -122.459413931848) | |||
| 23165 | 23165 | 25259 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 1630 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5994884.3509 | 2092299.7091 | 37.724763157858796 | -122.45985706395399 | (37.7247631578588, -122.459857063954) | |||
| 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) | |||
| 92138 | 92138 | 101902 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1100 Ocean Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 40576 | 40576 | 177849 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 104 Woolsey St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | 6011561.92381 | 2092191.20992 | 37.7254102643617 | -122.40219675676799 | (37.7254102643617, -122.402196756768) | ||||
| 93132 | 93132 | 13300 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 168 LUNADO CT | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 3 | 15 | 5991818.0 | 2092671.0 | 37.7256058079955 | -122.47048399681299 | (37.7256058079955, -122.470483996813) | ||
| 124428 | 124428 | 13298 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 168 LUNADO CT | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 3 | 15 | 5991818.0 | 2092671.0 | 37.7256058079955 | -122.47048399681299 | (37.7256058079955, -122.470483996813) | ||
| 142185 | 142185 | 13299 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 168 LUNADO CT | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/26/2016 12:00:00 AM | 3 | 15 | 5991818.0 | 2092671.0 | 37.7256058079955 | -122.47048399681299 | (37.7256058079955, -122.470483996813) | ||
| 175127 | 175127 | 177839 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 652 Peru Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6005114.3651 | 2092558.89448 | 37.7260578454775 | -122.42451154118 | (37.7260578454775, -122.42451154118) | ||||
| 149889 | 149889 | 177838 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 652 Peru Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6005106.92486 | 2092561.69197 | 37.7260651065947 | -122.42453746056101 | (37.7260651065947, -122.424537460561) | ||||
| 28873 | 28873 | 177837 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | ||||
| 37741 | 37741 | 177836 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005089.4768199995 | 2092569.03703 | 37.7260842891429 | -122.424598299682 | (37.7260842891429, -122.424598299682) | ||||
| 153822 | 153822 | 177840 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 655 Peru Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6005146.609019999 | 2092568.42927 | 37.7260858467747 | -122.424400753697 | (37.7260858467747, -122.424400753697) | ||||
| 158989 | 158989 | 177835 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 650 Peru Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6005084.25734 | 2092571.43545 | 37.7260905799026 | -122.42461651366301 | (37.7260905799026, -122.424616513663) | ||||
| 93493 | 93493 | 121630 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 96x Valmar Ter | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12 | 3x3 | 6005224.0 | 2092573.0 | 37.726102766942205 | -122.42413354236 | (37.7261027669422, -122.42413354236) | |||
| 52509 | 52509 | 177834 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6005075.62014 | 2092583.76802 | 37.7261239546294 | -122.424647248878 | (37.7261239546294, -122.424647248878) | ||||
| 175058 | 175058 | 177833 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6005045.58694 | 2092601.1582099998 | 37.726170008036 | -122.42475230858601 | (37.726170008036, -122.424752308586) | ||||
| 130946 | 130946 | 177832 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 648 Peru Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6005040.015980001 | 2092604.7564 | 37.7261795732245 | -122.424771822965 | (37.7261795732245, -122.424771822965) | ||||
| 65623 | 65623 | 177843 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6005078.05129 | 2092608.48476 | 37.726191958666796 | -122.424640601997 | (37.7261919586668, -122.424640601997) | ||||
| 168100 | 168100 | 177841 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6005100.14116 | 2092616.6598200002 | 37.726215653124704 | -122.424564819721 | (37.7262156531247, -122.424564819721) | ||||
| 154289 | 154289 | 177842 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 653 Peru Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6005092.77094 | 2092617.82642 | 37.726218440119 | -122.42459038114599 | (37.726218440119, -122.424590381146) | ||||
| 91357 | 91357 | 49091 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 113123 | 113123 | 49092 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 101 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46240 | 6005012.04174128 | 2092633.4383737 | 37.7262567475706 | -122.424870568097 | (37.7262567475706, -122.424870568097) | ||||
| 31490 | 31490 | 199752 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1555 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6014842.8005 | 2092447.5888 | 37.7262968166738 | -122.39087288178601 | (37.7262968166738, -122.390872881786) | |||
| 79542 | 79542 | 115664 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 96239 | 96239 | 115665 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 3 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 124140 | 124140 | 115663 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 139585 | 139585 | 115666 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 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) | |||
| 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) | |||
| 127812 | 127812 | 40861 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 196 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1999 12:00:00 AM | Permit Number 41784 | 5994083.13181366 | 2093531.57356405 | 37.728099447432896 | -122.462716082104 | (37.7280994474329, -122.462716082104) | |||
| 109844 | 109844 | 105371 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5993373.5 | 2093728.3 | 37.7285987139119 | -122.465183566455 | (37.7285987139119, -122.465183566455) | |||
| 74822 | 74822 | 194102 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1000 Oakdale Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018083.18788 | 2093260.00153 | 37.7287068084484 | -122.379727324058 | (37.7287068084484, -122.379727324058) | ||||
| 175481 | 175481 | 210498 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5993345.020690001 | 2093786.1908599997 | 37.728756025647606 | -122.465286223606 | (37.7287560256476, -122.465286223606) | |||
| 99758 | 99758 | 105372 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 115 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2x3 | 5993334.2 | 2093792.7 | 37.728773274118204 | -122.46532410375 | (37.7287732741182, -122.46532410375) | |||
| 83272 | 83272 | 105373 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 130 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5993430.1 | 2093832.6 | 37.7288883598425 | -122.464995470532 | (37.7288883598425, -122.464995470532) | |||
| 105906 | 105906 | 121628 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 371 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997638.0 | 2093763.0 | 37.7289389875261 | -122.450443518449 | (37.7289389875261, -122.450443518449) | ||||
| 42977 | 42977 | 105374 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 127 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x3 | 5993372.2 | 2093864.2 | 37.7289717869451 | -122.46519792761299 | (37.7289717869451, -122.465197927613) | |||
| 86493 | 86493 | 105369 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 134 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5993447.9 | 2093869.1 | 37.7289896062208 | -122.46493658491501 | (37.7289896062208, -122.464936584915) | |||
| 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) | |||
| 80904 | 80904 | 105375 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 133 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 5993389.1 | 2093898.7 | 37.7290674900164 | -122.465142008345 | (37.7290674900164, -122.465142008345) | |||
| 162072 | 162072 | 210516 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 212 Staples Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5998671.88838 | 2093815.67028 | 37.7291427269309 | -122.44687309392401 | (37.7291427269309, -122.446873093924) | ||||
| 159389 | 159389 | 210517 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 212 Staples Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998717.163269999 | 2093815.2255099998 | 37.7291440921051 | -122.44671654353998 | (37.7291440921051, -122.44671654354) | ||||
| 125509 | 125509 | 105376 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 150 WESTGATE DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 5993482.0 | 2093943.9 | 37.729196954758294 | -122.464824129449 | (37.7291969547583, -122.464824129449) | |||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 67557 | 67557 | 100121 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 690 Miramar Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5995444.4 | 2093941.6 | 37.729303587844704 | -122.45803982404199 | (37.7293035878447, -122.458039824042) | |||||
| 74089 | 74089 | 210499 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 160 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993481.65554 | 2093993.4036700001 | 37.7293328598099 | -122.46482891383499 | (37.7293328598099, -122.464828913835) | |||
| 156821 | 156821 | 210500 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 170 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993493.64939 | 2094026.17588 | 37.729423535752204 | -122.46478982929199 | (37.7294235357522, -122.464789829292) | |||
| 151760 | 151760 | 210497 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 157 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5993465.86739 | 2094043.4542099999 | 37.729469375994896 | -122.46488712785 | (37.7294693759949, -122.46488712785) | |||
| 112784 | 112784 | 105377 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 157 WESTGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 2x3 | 5993452.0 | 2094045.4 | 37.729473919085706 | -122.46493520963999 | (37.7294739190857, -122.46493520964) | |||
| 78233 | 78233 | 40342 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 170 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1999 12:00:00 AM | Permit Number 41473 | 5993510.486220299 | 2094049.6713278 | 37.7294890191855 | -122.464733328734 | (37.7294890191855, -122.464733328734) | |||
| 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) | |||
| 162406 | 162406 | 210576 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 230 Flood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5999218.09022 | 2094097.3571400002 | 37.729947362078704 | -122.44500507794599 | (37.7299473620787, -122.445005077946) | |||
| 73143 | 73143 | 210502 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 105 Upland Dr | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993378.93248 | 2094262.38115 | 37.7300654826285 | -122.46520356329201 | (37.7300654826285, -122.465203563292) | |||
| 118289 | 118289 | 114805 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 210X GELLERT DR | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 3x3 | 5985389.0 | 2094462.0 | 37.73014959142171 | -122.492840061243 | (37.7301495914217, -122.492840061243) | |||
| 141356 | 141356 | 86901 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 370 Santa Ana Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 3x3 | Permit Number 49847 | 5992482.1 | 2094336.7 | 37.73021778542579 | -122.468309402689 | (37.7302177854258, -122.468309402689) | |||
| 47816 | 47816 | 210501 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 105 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993140.2263400005 | 2094328.28998 | 37.73023268367729 | -122.46603358088899 | (37.7302326836773, -122.466033580889) | |||
| 167409 | 167409 | 210548 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1535 Plymouth Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 3ft | 5995792.50445 | 2094281.41203 | 37.7302566245384 | -122.456860970872 | (37.7302566245384, -122.456860970872) | |||
| 132685 | 132685 | 210561 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 198 El Verano Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5994417.76995 | 2094342.8854599998 | 37.730346379576396 | -122.46161803285601 | (37.7303463795764, -122.461618032856) | |||
| 104139 | 104139 | 87677 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 651 Upland Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992947.0 | 2094378.0 | 37.7303580257382 | -122.46670519643499 | (37.7303580257382, -122.466705196435) | ||
| 93516 | 93516 | 121154 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | |||
| 112601 | 112601 | 97287 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | ||
| 124262 | 124262 | 121153 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 50X Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 778630 | 6003754.0 | 2094198.0 | 37.730481544978794 | -122.429331070998 | (37.7304815449788, -122.429331070998) | |||
| 191 | 191 | 210495 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | Permit Number 779799 | 5992304.44524 | 2094447.3559700001 | 37.7305113566072 | -122.468931622808 | (37.7305113566072, -122.468931622808) | ||
| 100025 | 100025 | 121675 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||||
| 116224 | 116224 | 53992 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 365 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | Permit Number 9709 | 5992325.42312898 | 2094471.30725357 | 37.7305783328736 | -122.46886084210199 | (37.7305783328736, -122.468860842102) | |||
| 183582 | 183582 | 210494 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 357 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5992317.252180001 | 2094479.3094400002 | 37.7305998328129 | -122.468889672143 | (37.7305998328129, -122.468889672143) | |||
| 136262 | 136262 | 177829 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6003826.80299 | 2094267.18245 | 37.7306756258798 | -122.429084311385 | (37.7306756258798, -122.429084311385) | |||
| 137153 | 137153 | 177830 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 3ft | 6003869.42584 | 2094268.83295 | 37.7306825704475 | -122.42893707528201 | (37.7306825704475, -122.428937075282) | |||
| 56750 | 56750 | 210493 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 357 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992327.09677 | 2094511.14412 | 37.730687811688 | -122.468857953946 | (37.730687811688, -122.468857953946) | |||
| 161127 | 161127 | 177831 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 100 Trumbull St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 3ft | 6003962.8397 | 2094273.86284 | 37.730701668441895 | -122.428614487595 | (37.7307016684419, -122.428614487595) | |||
| 128916 | 128916 | 33827 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 405 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/1997 12:00:00 AM | Permit Number 37843 | 5999402.87583246 | 2094395.39820181 | 37.730776257944 | -122.44438766473101 | (37.730776257944, -122.444387664731) | |||
| 10258 | 10258 | 173932 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1109x Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003491.0 | 2094313.0 | 37.7307824159859 | -122.430248501015 | (37.7307824159859, -122.430248501015) | |||||
| 186525 | 186525 | 210514 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 405 Detroit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5999413.51386 | 2094469.4998 | 37.7309803305562 | -122.44435621076599 | (37.7309803305562, -122.444356210766) | |||
| 161079 | 161079 | 210496 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 329 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992628.41273 | 2094670.44138 | 37.7311426060501 | -122.467827848878 | (37.7311426060501, -122.467827848878) | |||
| 85418 | 85418 | 117526 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 329 SANTA ANA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x3 | 5992655.0 | 2094678.0 | 37.7311648953586 | -122.467736482345 | (37.7311648953586, -122.467736482345) | |||
| 101180 | 101180 | 117525 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 329 SANTA ANA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2016 12:00:00 AM | 3 | 2x3 | 5992655.0 | 2094678.0 | 37.7311648953586 | -122.467736482345 | (37.7311648953586, -122.467736482345) | ||
| 123749 | 123749 | 210492 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 329 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5992368.752180001 | 2094716.2048900002 | 37.7312532640314 | -122.46872886166 | (37.7312532640314, -122.46872886166) | |||
| 148527 | 148527 | 210534 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2523 Ocean Ave | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5991267.17989 | 2094746.77146 | 37.731273492456495 | -122.472539386291 | (37.7312734924565, -122.472539386291) | |||
| 177387 | 177387 | 210491 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 325 San Leandro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5992370.72105 | 2094745.70098 | 37.7313343666897 | -122.46872420046499 | (37.7313343666897, -122.468724200465) | |||
| 148483 | 148483 | 210490 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 325 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5992372.68285 | 2094774.8615 | 37.7314145475467 | -122.468719539293 | (37.7314145475467, -122.468719539293) | |||
| 133478 | 133478 | 210575 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 222 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5996813.55952 | 2094844.51305 | 37.7318613433091 | -122.45337170476299 | (37.7318613433091, -122.453371704763) | |||
| 26669 | 26669 | 210574 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 222 Ridgewood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5996816.481980001 | 2094866.93739 | 37.731923082681206 | -122.453363219651 | (37.7319230826812, -122.453363219651) | |||
| 170902 | 170902 | 210533 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2645 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5990808.42077 | 2095014.9868299998 | 37.731983379510496 | -122.474144946842 | (37.7319833795105, -122.474144946842) | |||
| 135025 | 135025 | 210515 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 443 Gennessee St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997431.02942 | 2094954.3994200001 | 37.732198438912604 | -122.451244915116 | (37.7321984389126, -122.451244915116) | ||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 114895 | 114895 | 116578 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 11 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | ||
| 151195 | 151195 | 247574 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350x Alemany Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6008213.28818 | 2095041.8138700002 | 37.7330499269008 | -122.413974287302 | (37.7330499269008, -122.413974287302) | ||||
| 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) | |||
| 79648 | 79648 | 94502 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 60 Fernwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 53693 | 5994613.0 | 2095460.0 | 37.733424938715 | -122.461024038199 | (37.733424938715, -122.461024038199) | ||||
| 54380 | 54380 | 194099 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 84 Whitney Young Cir | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 43 | 6016735.93504 | 2095074.45923 | 37.733614544669706 | -122.384511236201 | (37.7336145446697, -122.384511236201) |
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");