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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60026 | 60026 | 193530 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Ardath Ct | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017359.71186 | 2095444.3083400002 | 37.7346645517157 | -122.382380360088 | (37.7346645517157, -122.382380360088) | |||
| 182369 | 182369 | 246706 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Bonview St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6007716.07 | 2099142.6271 | 37.7442819187879 | -122.415983608356 | (37.7442819187879, -122.415983608356) | ||||
| 21876 | 21876 | 3876 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001972.79866 | 2108696.56564 | 37.7701901557853 | -122.43652626967199 | (37.7701901557853, -122.436526269672) | |||
| 119485 | 119485 | 250243 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Mulford Aly | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6009270.11228 | 2115820.15514 | 37.7901618096679 | -122.41178825844601 | (37.7901618096679, -122.411788258446) | |||
| 43309 | 43309 | 231938 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002328.37989 | 2096518.1207400002 | 37.7367712513805 | -122.43442545876499 | (37.7367712513805, -122.434425458765) | |||
| 149582 | 149582 | 231939 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 2ft | 6002331.25514 | 2096517.0119 | 37.7367683699712 | -122.434415438526 | (37.7367683699712, -122.434415438526) | |||
| 141736 | 141736 | 66862 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1 Seward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1991 12:00:00 AM | Permit Number 30169 | 6001132.20475531 | 2104197.53815823 | 37.7577891313172 | -122.43911137402 | (37.7577891313172, -122.43911137402) | ||
| 35660 | 35660 | 209755 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Sola Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5994990.41955 | 2100663.0993 | 37.7477330707391 | -122.460096016616 | (37.7477330707391, -122.460096016616) | |||
| 47835 | 47835 | 209753 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Sola Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994934.9423400005 | 2100694.176 | 37.74781520851371 | -122.460290103799 | (37.7478152085137, -122.460290103799) | |||
| 134362 | 134362 | 209752 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Sola Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5994913.426469999 | 2100704.86051 | 37.7478433078201 | -122.46036527813999 | (37.7478433078201, -122.46036527814) | |||
| 158368 | 158368 | 209754 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Sola Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5994960.11314 | 2100688.13828 | 37.7478000783086 | -122.46020262764799 | (37.7478000783086, -122.460202627648) | |||
| 58572 | 58572 | 131079 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5996978.93733 | 2116192.9947200003 | 37.7904883355148 | -122.454341475191 | (37.7904883355148, -122.454341475191) | |||
| 105996 | 105996 | 122397 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Alton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994396.0 | 2101619.0 | 37.750323525001505 | -122.462220788578 | (37.7503235250015, -122.462220788578) | ||||
| 115566 | 115566 | 122396 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Alton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994396.0 | 2101619.0 | 37.750323525001505 | -122.462220788578 | (37.7503235250015, -122.462220788578) | ||||
| 181137 | 181137 | 209196 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Alton Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994412.6536 | 2101611.0800799998 | 37.7503027377971 | -122.462162625424 | (37.7503027377971, -122.462162625424) | |||
| 182394 | 182394 | 209195 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Alton Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994396.94389 | 2101602.65423 | 37.7502786980137 | -122.462216339236 | (37.7502786980137, -122.462216339236) | |||
| 187372 | 187372 | 209194 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Alton Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5994381.32008 | 2101598.31256 | 37.7502658772735 | -122.462270052143 | (37.7502658772735, -122.462270052143) | |||
| 89465 | 89465 | 114506 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 LOMBARD ST | 1 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 125405 | 125405 | 114508 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 LOMBARD ST | 3 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 84389 | 84389 | 50619 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47217 | 5993598.39647465 | 2101142.75642422 | 37.7489699240447 | -122.464944350004 | (37.7489699240447, -122.464944350004) | |||
| 102493 | 102493 | 50620 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47217 | 5993598.39647465 | 2101142.75642422 | 37.7489699240447 | -122.464944350004 | (37.7489699240447, -122.464944350004) | |||
| 125023 | 125023 | 50618 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2003 12:00:00 AM | Permit Number 47217 | 5993598.39647465 | 2101142.75642422 | 37.7489699240447 | -122.464944350004 | (37.7489699240447, -122.464944350004) | |||
| 150244 | 150244 | 209791 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993547.16244 | 2101152.75355 | 37.7489944193626 | -122.465122242113 | (37.7489944193626, -122.465122242113) | |||
| 187041 | 187041 | 209792 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993535.26452 | 2101156.63413 | 37.7490043883534 | -122.46516366667801 | (37.7490043883534, -122.465163666678) | |||
| 187051 | 187051 | 209793 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Mendosa Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993519.722 | 2101160.59093 | 37.7490143564374 | -122.465217699739 | (37.7490143564374, -122.465217699739) | |||
| 59278 | 59278 | 209514 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993182.505 | 2093140.5472099998 | 37.7269738733435 | -122.46580115471001 | (37.7269738733435, -122.46580115471) | |||
| 42443 | 42443 | 141468 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 10 Temescal Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997468.6387 | 2111521.5634 | 37.777689889643 | -122.452309921659 | (37.777689889643, -122.452309921659) | |||
| 38538 | 38538 | 231617 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Alma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998123.42502 | 2106230.56525 | 37.7631996517731 | -122.449663433939 | (37.7631996517731, -122.449663433939) | |||
| 73662 | 73662 | 231618 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Alma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998109.06601 | 2106228.1505 | 37.7631921999805 | -122.449712922719 | (37.7631921999805, -122.449712922719) | |||
| 147353 | 147353 | 231619 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Alma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998095.451280001 | 2106228.77319 | 37.763193130794 | -122.449760056188 | (37.763193130794, -122.449760056188) | |||
| 157130 | 157130 | 231616 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998136.42211 | 2106233.00838 | 37.7632071035549 | -122.449618657601 | (37.7632071035549, -122.449618657601) | |||
| 108787 | 108787 | 87337 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 100 Belgrave Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50332 | 5998085.1 | 2104938.4 | 37.7596494981433 | -122.449702865409 | (37.7596494981433, -122.449702865409) | |||
| 142208 | 142208 | 102053 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6000816.5 | 2105709.0 | 37.7619212664781 | -122.440311602097 | (37.7619212664781, -122.440311602097) | |||
| 163997 | 163997 | 231851 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000766.9484 | 2105685.1852 | 37.761853055488 | -122.440481273089 | (37.761853055488, -122.440481273089) | |||
| 30369 | 30369 | 209572 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5999439.81114 | 2096263.84796 | 37.7359086891413 | -122.444394200825 | (37.7359086891413, -122.444394200825) | ||||
| 36362 | 36362 | 209568 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 5999462.29955 | 2096158.98515 | 37.735622043705 | -122.444308916343 | (37.735622043705, -122.444308916343) | ||||
| 63908 | 63908 | 209571 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | 5999439.63659 | 2096255.44813 | 37.7358856152333 | -122.44439420083799 | (37.7358856152333, -122.444394200838) | ||||
| 148544 | 148544 | 209567 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5999456.224880001 | 2096147.79912 | 37.7355909829225 | -122.44432911512101 | (37.7355909829225, -122.444329115121) | ||||
| 175080 | 175080 | 209570 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5999443.64359 | 2096167.12972 | 37.7356433423607 | -122.444374002057 | (37.7356433423607, -122.444374002057) | ||||
| 182160 | 182160 | 209569 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5999443.592130001 | 2096149.0311099999 | 37.7355936449146 | -122.444372879724 | (37.7355936449146, -122.444372879724) | ||||
| 136894 | 136894 | 230864 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003759.242740001 | 2096500.30891 | 37.73680346149621 | -122.429477071432 | (37.7368034614962, -122.429477071432) | |||
| 115247 | 115247 | 231690 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Newman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007174.58944 | 2096767.10804 | 37.7377288135273 | -122.41768759610599 | (37.7377288135273, -122.417687596106) | |||
| 155864 | 155864 | 231689 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Newman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007155.57854 | 2096770.32686 | 37.7377365818831 | -122.417753554192 | (37.7377365818831, -122.417753554192) | |||
| 175904 | 175904 | 231688 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Newman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007140.58353 | 2096771.44252 | 37.737738801389 | -122.417805478352 | (37.737738801389, -122.417805478352) | |||
| 5341 | 5341 | 19786 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 14146 | 14146 | 19784 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 14308 | 14308 | 19785 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY19 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 10131 | 10131 | 19871 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100 STAIRWAY33 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 53856 | 53856 | 209565 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Vista Verde Ct | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 10ft | 5999227.17931 | 2096044.0537400001 | 37.7352930519305 | -122.445113554158 | (37.7352930519305, -122.445113554158) | |||
| 56334 | 56334 | 209564 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Vista Verde Ct | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5999241.97097 | 2096026.72351 | 37.735246311473205 | -122.445061168644 | (37.7352463114732, -122.445061168644) | |||
| 61062 | 61062 | 209563 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Vista Verde Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 10ft | 5999260.30614 | 2096011.6408400002 | 37.735205944503704 | -122.444996693557 | (37.7352059445037, -122.444996693557) | |||
| 177722 | 177722 | 209566 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Vista Verde Ct | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 10ft | 5999221.63808 | 2096039.13937 | 37.735279241951794 | -122.445132358965 | (37.7352792419518, -122.445132358965) | |||
| 120449 | 120449 | 209508 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993353.27658 | 2093730.40386 | 37.728603324364 | -122.465253632157 | (37.728603324364, -122.465253632157) | |||
| 136334 | 136334 | 231593 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1000 Dolores St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005048.36716 | 2102478.62607 | 37.753291456535 | -122.425445323452 | (37.753291456535, -122.425445323452) | |||
| 172526 | 172526 | 231594 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1000 Dolores St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005049.89174 | 2102457.5273 | 37.75323361036221 | -122.42543854975 | (37.7532336103622, -122.42543854975) | |||
| 19891 | 19891 | 3908 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1000X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3x3 | 6002158.12916 | 2107670.14517 | 37.767382387801796 | -122.435811763721 | (37.7673823878018, -122.435811763721) | |||
| 68534 | 68534 | 209673 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990858.11769 | 2102435.44411 | 37.7523609235396 | -122.474514476462 | (37.7523609235396, -122.474514476462) | |||
| 152820 | 152820 | 209674 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990846.75859 | 2102434.93048 | 37.7523588550955 | -122.47455372019199 | (37.7523588550955, -122.474553720192) | |||
| 169155 | 169155 | 209672 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 Ortega St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990876.6765 | 2102436.55915 | 37.7523650604238 | -122.47445037909999 | (37.7523650604238, -122.4744503791) | |||
| 169702 | 169702 | 209675 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990815.69064 | 2102432.57246 | 37.7523505804348 | -122.47466098502501 | (37.7523505804348, -122.474660985025) | |||
| 32077 | 32077 | 231557 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6005302.15218 | 2097157.06832 | 37.738694011804796 | -122.424189245746 | (37.7386940118048, -122.424189245746) | ||||
| 155704 | 155704 | 231558 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 44 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6005302.642109999 | 2097155.21655 | 37.738688954924605 | -122.424187420138 | (37.7386889549246, -122.424187420138) | ||||
| 163281 | 163281 | 231560 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 47 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6005307.33696 | 2097165.86428 | 37.7387184562788 | -122.424171944599 | (37.7387184562788, -122.424171944599) | ||||
| 172949 | 172949 | 231559 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1001 San Jose Ave | 45 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6005304.59502 | 2097156.92605 | 37.738693759094296 | -122.424180789438 | (37.7386937590943, -122.424180789438) | ||||
| 3075 | 3075 | 231047 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1006 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1989 12:00:00 AM | 6 | Width 3ft | Permit Number 27195 | 6003118.79075 | 2102352.8042 | 37.752836769210504 | -122.432109206276 | (37.7528367692105, -122.432109206276) | |
| 78521 | 78521 | 65209 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1006 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27195 | 6003121.38880969 | 2102376.35777972 | 37.7529015890661 | -122.432101903573 | (37.7529015890661, -122.432101903573) | ||
| 89192 | 89192 | 57448 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1006 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/1983 12:00:00 AM | Permit Number 20307 | 6001737.33085914 | 2109453.64268678 | 37.7722555179061 | -122.43739496982599 | (37.7722555179061, -122.437394969826) | ||
| 49480 | 49480 | 39560 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1007 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 4 | Permit Number 40982 | 6012211.61681 | 2103677.23576 | 37.7569846978905 | -122.40075738017299 | (37.7569846978905, -122.400757380173) | |
| 52832 | 52832 | 39561 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1007 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 3 | Permit Number 40982 | 6012211.61021 | 2103687.83014 | 37.7570137873623 | -122.400758147269 | (37.7570137873623, -122.400758147269) | |
| 1491 | 1491 | 110535 | Private 5 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | Private 3 | 04/21/2015 04:52:00 PM | 3 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |
| 121101 | 121101 | 110540 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | City College 13 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |||
| 144922 | 144922 | 110534 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X ASHBURY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | City College 13 | 3x3 | 5998750.0 | 2110223.0 | 37.7741976920008 | -122.447783765196 | (37.7741976920008, -122.447783765196) | |||
| 93335 | 93335 | 27710 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100X Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5995275.65547 | 2110816.5707799997 | 37.7756282907435 | -122.459845067186 | (37.7756282907435, -122.459845067186) | |||
| 142136 | 142136 | 27709 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5995296.856269999 | 2110817.73341 | 37.7756327022365 | -122.45977181314899 | (37.7756327022365, -122.459771813149) | |||
| 10149 | 10149 | 173884 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100X Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2017 12:00:00 AM | 3 | 3x3 | |||||||
| 141232 | 141232 | 32505 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 100x OGDEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/15/1996 12:00:00 AM | Permit Number 37009 | 6007659.0 | 2096105.0 | 37.7359380573488 | -122.41596587682 | (37.7359380573488, -122.41596587682) | |||
| 53156 | 53156 | 209769 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100x Pacheco St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5994792.885 | 2099741.94773 | 37.745192456276705 | -122.460712331024 | (37.7451924562767, -122.460712331024) | |||
| 152005 | 152005 | 209768 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 100x Pacheco St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5994733.37028 | 2099685.92288 | 37.7450352017206 | -122.460914061546 | (37.7450352017206, -122.460914061546) | |||
| 157208 | 157208 | 209600 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5994123.38139 | 2090627.1141599999 | 37.7201268228771 | -122.462366365921 | (37.7201268228771, -122.462366365921) | |||
| 152886 | 152886 | 209740 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 3ft | 5993933.66757 | 2099963.27953 | 37.7457507050442 | -122.46369939591001 | (37.7457507050442, -122.46369939591) | |||
| 162618 | 162618 | 209739 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5993947.2712900005 | 2099975.72655 | 37.7457856652897 | -122.4636532598 | (37.7457856652897, -122.4636532598) | |||
| 39810 | 39810 | 30874 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 101 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/16/1995 12:00:00 AM | 8 | Permit Number 34708 | 6001364.285619999 | 2094914.2380400002 | 37.7323125880576 | -122.437643917455 | (37.7323125880576, -122.437643917455) | |
| 55260 | 55260 | 230867 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003782.93168 | 2096519.77323 | 37.7368582472959 | -122.429396556007 | (37.7368582472959, -122.429396556007) | |||
| 118936 | 118936 | 104842 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 101 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6x9 | 6003794.8 | 2096529.7 | 37.736886175879995 | -122.429356229664 | (37.73688617588, -122.429356229664) | |||
| 57877 | 57877 | 209521 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Northgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994395.59714 | 2094064.85895 | 37.7295817103289 | -122.46167453636002 | (37.7295817103289, -122.46167453636) | |||
| 176473 | 176473 | 209522 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Northgate Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994404.43509 | 2094028.5000900002 | 37.729482386506 | -122.461641347789 | (37.729482386506, -122.461641347789) | |||
| 169443 | 169443 | 140835 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996827.4802 | 2113787.2507 | 37.783874117868294 | -122.454691624261 | (37.7838741178683, -122.454691624261) | |||
| 78325 | 78325 | 115791 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 SAN ALESO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5993432.0 | 2094808.0 | 37.7315666775405 | -122.465059716371 | (37.7315666775405, -122.465059716371) | ||||
| 27574 | 27574 | 209504 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993419.2745 | 2094823.7451799999 | 37.731609176122 | -122.465104853721 | (37.731609176122, -122.465104853721) | |||
| 38725 | 38725 | 209503 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 101 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993405.19491 | 2094799.6453 | 37.7315421919093 | -122.46515177943998 | (37.7315421919093, -122.46515177944) | |||
| 20717 | 20717 | 121 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1010 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6002120.21923 | 2107665.1776900003 | 37.767366594808 | -122.435942533236 | (37.767366594808, -122.435942533236) | |||
| 26778 | 26778 | 245098 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1010 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001676.4288 | 2109440.6119999997 | 37.7722162763824 | -122.437604701673 | (37.7722162763824, -122.437604701673) | |||
| 19166 | 19166 | 122 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1012 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002100.28496 | 2107666.1128700003 | 37.767368030136204 | -122.436011549918 | (37.7673680301362, -122.436011549918) | |||
| 179608 | 179608 | 231751 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1015 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001960.3978699995 | 2101086.7299200003 | 37.7492946868066 | -122.436024547794 | (37.7492946868066, -122.436024547794) | |||
| 112163 | 112163 | 65211 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1016 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27197 | 6003124.55718604 | 2102319.29263915 | 37.7527450813219 | -122.432086871991 | (37.7527450813219, -122.432086871991) | ||
| 105793 | 105793 | 41976 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 101X NORTHGATE DR | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 3x3 | Permit Number 42322 | 5994409.0 | 2094096.0 | 37.7296679875594 | -122.461630458557 | (37.7296679875594, -122.461630458557) | |
| 111280 | 111280 | 41979 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 101X NORTHGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51393 | 5994409.0 | 2094096.0 | 37.7296679875594 | -122.461630458557 | (37.7296679875594, -122.461630458557) | ||
| 126829 | 126829 | 61687 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 102 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22600 | 6000834.13705442 | 2105698.15099784 | 37.7618924819567 | -122.440249824562 | (37.7618924819567, -122.440249824562) | ||
| 52964 | 52964 | 140291 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 102 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997338.9753 | 2110181.2993 | 37.77400244404821 | -122.452661716157 | (37.7740024440482, -122.452661716157) | |||
| 169197 | 169197 | 140292 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 102 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997354.6293 | 2110183.2217 | 37.7740086193981 | -122.452607705364 | (37.7740086193981, -122.452607705364) |
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");