Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4368 | 4368 | 251755 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 101X Drake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:50:00 AM | 3 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||
| 4405 | 4405 | 251754 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 101X Drake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/11/2017 11:47:00 AM | 3 | 3x3 | 6001862.0 | 2086566.0 | 37.709418484595 | -122.43532626528601 | (37.709418484595, -122.435326265286) | ||
| 86642 | 86642 | 39178 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1050 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |
| 114085 | 114085 | 39177 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1050 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | |
| 3925 | 3925 | 216756 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 106 Harold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 01:41:00 PM | 3 | Width 3ft | 5996820.43291 | 2090638.75117 | 37.7203137127762 | -122.45304445763 | (37.7203137127762, -122.45304445763) | ||
| 55809 | 55809 | 123781 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992148.272480001 | 2110704.3151 | 37.775139717422704 | -122.47065517411998 | (37.7751397174227, -122.47065517412) | |||
| 67572 | 67572 | 123782 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992174.172809999 | 2110703.76964 | 37.7751397174253 | -122.470565540203 | (37.7751397174253, -122.470565540203) | |||
| 43230 | 43230 | 81651 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100@ 12th Ave Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | Permit Number 767881 | 5992197.33713 | 2110704.35062 | 37.7751426520596 | -122.470485452724 | (37.7751426520596, -122.470485452724) | ||
| 21944 | 21944 | 18455 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1115 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/17/2015 12:46:00 PM | 3 | 3X3 | 6010591.726009999 | 2102631.1286299997 | 37.754021836464794 | -122.406285897673 | (37.7540218364648, -122.406285897673) | ||
| 108925 | 108925 | 94327 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1132 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2010 12:00:00 AM | 3x3 | Permit Number 53627 | 5995101.4 | 2091446.0 | 37.722431557418396 | -122.459044970295 | (37.7224315574184, -122.459044970295) | ||
| 17958 | 17958 | 18458 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1136 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2006 12:00:00 AM | 3 | 4X4 | 6010508.182130001 | 2102591.0282099997 | 37.753907055971105 | -122.406571988228 | (37.7539070559711, -122.406571988228) | ||
| 173435 | 173435 | 230401 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010508.63913 | 2102581.4092 | 37.753880669869794 | -122.406569730021 | (37.7538806698698, -122.406569730021) | |||
| 18510 | 18510 | 27621 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1143 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010597.97715 | 2102516.5515099997 | 37.7537075827479 | -122.406256207463 | (37.7537075827479, -122.406256207463) | ||
| 23345 | 23345 | 18460 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1146 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2006 12:00:00 AM | 5 | 3X3 | 6010512.14548 | 2102543.99159 | 37.753778125574 | -122.40655496764099 | (37.753778125574, -122.406554967641) | ||
| 3920 | 3920 | 216755 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 115 Harold Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/04/2017 01:38:00 PM | 3 | Width 3ft | 5996789.877280001 | 2090654.02957 | 37.720353912480995 | -122.453151180205 | (37.720353912481, -122.453151180205) | ||
| 54459 | 54459 | 193427 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014474.19771 | 2103855.91322 | 37.75760124521779 | -122.39294496056499 | (37.7576012452178, -122.392944960565) | |||
| 60282 | 60282 | 193428 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014491.22334 | 2103857.32403 | 37.7576060646987 | -122.392886177259 | (37.7576060646987, -122.392886177259) | |||
| 130484 | 130484 | 193429 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1151 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6014506.85634 | 2103858.18885 | 37.7576093076281 | -122.39283217206699 | (37.7576093076281, -122.392832172067) | |||
| 59900 | 59900 | 84342 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1153 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50832 | 6005241.68146 | 2120923.0691400003 | 37.8039462987346 | -122.426089751557 | (37.8039462987346, -122.426089751557) | |
| 149115 | 149115 | 93670 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 12 Robblee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 54071 | 6012650.87025 | 2095997.96753 | 37.735923558519104 | -122.39869937070299 | (37.7359235585191, -122.398699370703) | |
| 3430 | 3430 | 180648 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6001751.26715 | 2087361.8508 | 37.7115974268507 | -122.435765878508 | (37.7115974268507, -122.435765878508) | |||
| 4205 | 4205 | 251774 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 10:14:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.7886599998 | 37.711579156239296 | -122.435864336264 | (37.7115791562393, -122.435864336264) | ||
| 4296 | 4296 | 251775 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/10/2017 10:17:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.7886599998 | 37.711579156239296 | -122.435864336264 | (37.7115791562393, -122.435864336264) | ||
| 4484 | 4484 | 251776 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 120 Seville St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 12:12:00 PM | 3 | Width 6ft | 6001722.65495 | 2087355.7886599998 | 37.711579156239296 | -122.435864336264 | (37.7115791562393, -122.435864336264) | ||
| 2266 | 2266 | 253000 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2272 | 2272 | 253002 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2273 | 2273 | 252995 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2275 | 2275 | 253003 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2276 | 2276 | 252994 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2278 | 2278 | 252992 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2281 | 2281 | 252998 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2288 | 2288 | 252996 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2289 | 2289 | 252993 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2290 | 2290 | 252997 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2294 | 2294 | 252999 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 2296 | 2296 | 253001 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1201 Tennessee St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | |||
| 138542 | 138542 | 54682 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1212 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993014.13432891 | 2107214.38358529 | 37.7656073275163 | -122.467406160634 | (37.7656073275163, -122.467406160634) | |||
| 145552 | 145552 | 96632 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1212 10th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2011 12:00:00 AM | Permit Number 767886 | 5993035.2 | 2107183.3 | 37.7655231963247 | -122.467331039359 | (37.7655231963247, -122.467331039359) | |||
| 20449 | 20449 | 18472 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1245 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/11/2015 07:25:00 AM | 3 | 3X3 | 6010625.30786 | 2102050.90235 | 37.7524305418599 | -122.406128887762 | (37.7524305418599, -122.406128887762) | ||
| 127359 | 127359 | 34304 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1248 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 777415 | 6010821.325282 | 2102511.88817286 | 37.7537072691799 | -122.40548348700099 | (37.7537072691799, -122.405483487001) | ||
| 21711 | 21711 | 18473 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1255 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/15/2013 12:00:00 AM | 3 | 3x3 | 6010628.31505 | 2101997.99365 | 37.7522854344497 | -122.40611476119301 | (37.7522854344497, -122.406114761193) | ||
| 21177 | 21177 | 18475 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010550.213330001 | 2101942.07688 | 37.75212753057279 | -122.406380911075 | (37.7521275305728, -122.406380911075) | ||
| 21253 | 21253 | 18474 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 0 | Permit Number 773798 | 6010545.83787 | 2101980.95756 | 37.752234043567206 | -122.406398781502 | (37.7522340435672, -122.406398781502) |
| 21619 | 21619 | 18476 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1263 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1997 12:00:00 AM | 18 | 3X3 | 6010629.32405 | 2101956.3743 | 37.7521712133345 | -122.406108340032 | (37.7521712133345, -122.406108340032) | ||
| 532 | 532 | 6761 | DPW Maintained 3 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1275 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:35:00 PM | 3 | 3x3 | 6017199.30801 | 2096970.01555 | 37.738844977413 | -122.383041088382 | (37.738844977413, -122.383041088382) | ||
| 57863 | 57863 | 230414 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1295 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003749.35106 | 2095592.3419599999 | 37.7343098303216 | -122.429446540326 | (37.7343098303216, -122.429446540326) | |||
| 25091 | 25091 | 230419 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003538.9746900005 | 2095464.77113 | 37.733947636477396 | -122.430164781185 | (37.7339476364774, -122.430164781185) | |||
| 34840 | 34840 | 230415 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003663.13723 | 2095538.7313 | 37.7341577459882 | -122.429740786804 | (37.7341577459882, -122.429740786804) | |||
| 61446 | 61446 | 230417 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003609.08364 | 2095506.47935 | 37.7340661284367 | -122.42992536726801 | (37.7340661284367, -122.429925367268) | |||
| 75391 | 75391 | 230416 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003629.87373 | 2095518.0627099997 | 37.734099111076496 | -122.429854315422 | (37.7340991110765, -122.429854315422) | |||
| 183229 | 183229 | 230418 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003572.46167 | 2095485.4349900002 | 37.7340062713591 | -122.43005048006701 | (37.7340062713591, -122.430050480067) | |||
| 85263 | 85263 | 99874 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1301X San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 770597 | 6003616.3 | 2095455.7 | 37.733927108519204 | -122.429896797189 | (37.7339271085192, -122.429896797189) |
| 76597 | 76597 | 46980 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015320.4365300005 | 2102435.8456200003 | 37.7537490109239 | -122.38991910430799 | (37.7537490109239, -122.389919104308) | ||
| 132389 | 132389 | 46977 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44998 | 6015323.660209999 | 2102361.18474 | 37.7535441867291 | -122.38990274114201 | (37.7535441867291, -122.389902741142) | ||
| 174880 | 174880 | 46981 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1310 Minnesota St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | 1 | Permit Number 44998 | 6015319.9852 | 2102418.03165 | 37.7537000725041 | -122.389919420856 | (37.7537000725041, -122.389919420856) | ||
| 86859 | 86859 | 115273 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1314 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775588 | 5985278.7 | 2106245.9 | 37.762498531179396 | -122.49408954164 | (37.7624985311794, -122.49408954164) | |||
| 112880 | 112880 | 88518 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 133 Kenwood Way | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51449 | 5994469.5 | 2093573.6 | 37.728237086689404 | -122.46138344933 | (37.7282370866894, -122.46138344933) | |||
| 35864 | 35864 | 202028 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013610.79633 | 2091351.15014 | 37.723217781063205 | -122.395055126189 | (37.7232177810632, -122.395055126189) | |||
| 50998 | 50998 | 202024 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013681.0358 | 2091298.8599 | 37.7230781082384 | -122.394808659817 | (37.7230781082384, -122.394808659817) | |||
| 54038 | 54038 | 202020 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013858.20959 | 2091166.1399 | 37.7227235352339 | -122.39418691350599 | (37.7227235352339, -122.394186913506) | |||
| 58655 | 58655 | 202021 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013834.37055 | 2091185.2446599999 | 37.722774667999 | -122.39427065747101 | (37.722774667999, -122.394270657471) | |||
| 69513 | 69513 | 202022 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013717.54523 | 2091271.8320400002 | 37.723005925068605 | -122.39468056126199 | (37.7230059250686, -122.394680561262) | |||
| 154620 | 154620 | 202023 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013701.15269 | 2091283.23076 | 37.723036312264796 | -122.394738025239 | (37.7230363122648, -122.394738025239) | |||
| 161322 | 161322 | 202025 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013662.901769999 | 2091312.2744599998 | 37.723113933631204 | -122.394872285044 | (37.7231139336312, -122.394872285044) | |||
| 170064 | 170064 | 202026 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013645.7458 | 2091325.32173 | 37.723148804870206 | -122.394932503635 | (37.7231488048702, -122.394932503635) | |||
| 175470 | 175470 | 202027 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1330 Fitzgerald Ave | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013629.1875599995 | 2091337.20695 | 37.72318051856 | -122.39499057468001 | (37.72318051856, -122.39499057468) | |||
| 20610 | 20610 | 109781 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1335 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775057 | 5991737.5 | 2106325.0 | 37.7630915327801 | -122.471756892939 | (37.7630915327801, -122.471756892939) |
| 184780 | 184780 | 202019 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1350 Fitzgerald Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013890.086209999 | 2091145.17982 | 37.7226677548035 | -122.394075255469 | (37.7226677548035, -122.394075255469) | |||
| 103136 | 103136 | 64806 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1375 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/11/2012 12:00:00 AM | 22 | 5x5 | Permit Number 768180 | 6003293.30156995 | 2100236.74825313 | 37.747036468941005 | -122.43135467591999 | (37.747036468941, -122.43135467592) |
| 94996 | 94996 | 108874 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 138 Cole St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773404 | 5997812.451119999 | 2110130.24113 | 37.773889369558 | -122.45102020833099 | (37.773889369558, -122.451020208331) | |
| 57871 | 57871 | 193417 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6015126.28801 | 2101884.04231 | 37.7522231069197 | -122.39055196440201 | (37.7522231069197, -122.390551964402) | |||
| 151479 | 151479 | 193416 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015128.54714 | 2101843.94886 | 37.75211314410829 | -122.390541350608 | (37.7521131441083, -122.390541350608) | |||
| 159837 | 159837 | 193415 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1425 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6015129.4675 | 2101818.79874 | 37.75204413825129 | -122.390536410622 | (37.7520441382513, -122.390536410622) | |||
| 49040 | 49040 | 230420 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005428.8647300005 | 2102882.34915 | 37.7544214771723 | -122.424158193041 | (37.7544214771723, -122.424158193041) | |||
| 97188 | 97188 | 109448 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) |
| 112590 | 112590 | 104967 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 143-147 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | ||
| 79139 | 79139 | 108621 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 150-198X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | Permit Number 774592 | 6005405.0 | 2109611.0 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | |
| 39159 | 39159 | 208859 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995398.10832 | 2089609.6071400002 | 37.7174063107347 | -122.45788650015699 | (37.7174063107347, -122.457886500157) | |||
| 110498 | 110498 | 114987 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | Permit Number 775985 | 5995400.7 | 2089591.3 | 37.7173561925503 | -122.45787621793899 | (37.7173561925503, -122.457876217939) | |||
| 121754 | 121754 | 17176 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1601 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1999 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058391998 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | ||
| 82328 | 82328 | 115264 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1634 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.47974063936701 | (37.7571489820097, -122.479740639367) | |||
| 140028 | 140028 | 115265 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1634 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.47974063936701 | (37.7571489820097, -122.479740639367) | |||
| 111534 | 111534 | 62821 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 165 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2010 12:00:00 AM | 3x3 | Permit Number 53769 | 6004060.48554268 | 2101568.78877881 | 37.750737391448396 | -122.42879676445 | (37.7507373914484, -122.42879676445) | ||
| 63152 | 63152 | 177453 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001481.52618 | 2094146.78927 | 37.7302120154671 | -122.437183661494 | (37.7302120154671, -122.437183661494) | |||
| 63489 | 63489 | 177454 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001501.639719999 | 2094151.35591 | 37.730225697742796 | -122.43711445328998 | (37.7302256977428, -122.43711445329) | |||
| 137569 | 137569 | 177457 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001558.284440001 | 2094165.3004599998 | 37.730267205960295 | -122.436919623235 | (37.7302672059603, -122.436919623235) | |||
| 154854 | 154854 | 177455 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001518.96973 | 2094154.72477 | 37.7302359329302 | -122.43705478235701 | (37.7302359329302, -122.437054782357) | |||
| 171216 | 171216 | 177456 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1651 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001539.4565 | 2094159.8919400002 | 37.7302512852618 | -122.436984326781 | (37.7302512852618, -122.436984326781) | |||
| 155237 | 155237 | 131012 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1661 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6006845.959840001 | 2116366.0433 | 37.7915243922801 | -122.420214413174 | (37.7915243922801, -122.420214413174) | |||
| 80702 | 80702 | 29817 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1695X Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.74391708243721 | -122.39024991836901 | (37.7439170824372, -122.390249918369) | ||
| 70771 | 70771 | 193438 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 170 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012250.26105 | 2094642.5839099998 | 37.7321796295918 | -122.39998929257601 | (37.7321796295918, -122.399989292576) | |||
| 3405 | 3405 | 180669 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 171 Winding Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 6ft | 6002170.184219999 | 2086635.71157 | 37.70962739445179 | -122.434266111507 | (37.7096273944518, -122.434266111507) | |||
| 118363 | 118363 | 50070 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 178 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/2010 12:00:00 AM | 3x3 | Permit Number 53758 | 6003140.05481803 | 2105079.35140699 | 37.7603244234929 | -122.432230375273 | (37.7603244234929, -122.432230375273) | |
| 179427 | 179427 | 101369 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2007 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2012 12:00:00 AM | 12 | 3x3 | Permit Number 769245 | 5999888.5 | 2111553.0 | 37.7779145386147 | -122.44394108204901 | (37.7779145386147, -122.443941082049) | |
| 170163 | 170163 | 43588 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2014 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/2015 12:00:00 AM | 0 | Permit Number 774769 | 5986972.77982158 | 2101544.10082167 | 37.7496876538817 | -122.48788494443001 | (37.7496876538817, -122.48788494443) | |
| 145504 | 145504 | 84013 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 207 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2016 12:00:00 AM | 3x3 | Permit Number 771913 | 5997093.91103174 | 2089409.10522836 | 37.7169530610701 | -122.45201046888201 | (37.7169530610701, -122.452010468882) | ||
| 77661 | 77661 | 94252 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 80296 | 80296 | 94248 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 80407 | 80407 | 94251 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |||
| 83236 | 83236 | 94249 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 2125 BRYANT ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) |
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");