trees
305 rows where qSpecies_id = 49 sorted by PermitNotes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66243 | 252996 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 68717 | 193421 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015817.08868 | 2105796.2011 | 37.763003362128 | -122.388436082669 | (37.763003362128, -122.388436082669) | 14 | 3 | 8 | 28856 | 29 | |||
| 69180 | 93242 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 636 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004253 | 2105189 | 37.7606885326436 | -122.428389032489 | (37.7606885326436, -122.428389032489) | 2 | 4 | 5 | 28862 | 3 | ||
| 69881 | 230397 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 635 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010452.60466 | 2105203.30463 | 37.7610766734566 | -122.406948295125 | (37.7610766734566, -122.406948295125) | 10 | 4 | 8 | 28859 | 19 | |||
| 70355 | 27621 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1143 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 3x3 | 6010597.97715 | 2102516.55151 | 37.7537075827479 | -122.406256207463 | (37.7537075827479, -122.406256207463) | 10 | 4 | 8 | 28859 | 19 | ||
| 70881 | 202020 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6013858.20959 | 2091166.1399 | 37.7227235352339 | -122.394186913506 | (37.7227235352339, -122.394186913506) | 10 | 3 | 8 | 58 | 1 | |||
| 71239 | 160422 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 591 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:59:00 PM | 3 | Width 0ft | 6002364.11048 | 2089653.56999 | 37.7179247752893 | -122.43381142685 | (37.7179247752893, -122.43381142685) | 9 | 7 | 6 | 28861 | 5 | |
| 72649 | 230400 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 898 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6010432.287 | 2104046.52081 | 37.7578992679501 | -122.406937031143 | (37.7578992679501, -122.406937031143) | 10 | 4 | 7 | 28859 | 19 | |||
| 73067 | 180648 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 6ft | 6001751.26715 | 2087361.8508 | 37.7115974268507 | -122.435765878508 | (37.7115974268507, -122.435765878508) | 9 | 7 | 6 | 28861 | 5 | |||
| 74218 | 193430 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 560 Missouri St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6013531.28257 | 2104470.66699 | 37.7592368044652 | -122.396249052661 | (37.7592368044652, -122.396249052661) | 10 | 3 | 8 | 28856 | 29 | |||
| 74568 | 252992 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 75137 | 193419 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 610 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015956.40459 | 2106139.49843 | 37.7639537018206 | -122.387978189259 | (37.7639537018206, -122.387978189259) | 14 | 3 | 8 | 28856 | 29 | |||
| 75169 | 193432 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 572 Missouri St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6013532.898 | 2104416.89533 | 37.7590892490991 | -122.396239697014 | (37.7590892490991, -122.396239697014) | 10 | 3 | 8 | 28856 | 29 | |||
| 75265 | 216653 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 307 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:20:00 AM | 3 | Width 1ft | 5994722.80826 | 2090636.95151 | 37.7201883328984 | -122.46029507616 | (37.7201883328984, -122.46029507616) | 9 | 8 | 6 | 28861 | 24 | ||
| 76061 | 252998 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 80556 | 230423 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 387 Shotwell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007832.95914 | 2105672.86461 | 37.7622190400112 | -122.416041797198 | (37.7622190400112, -122.416041797198) | 8 | 4 | 7 | 28859 | 19 | |||
| 83854 | 193416 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1425 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6015128.54714 | 2101843.94886 | 37.7521131441083 | -122.390541350608 | (37.7521131441083, -122.390541350608) | 10 | 3 | 8 | 28856 | 1 | |||
| 84177 | 230425 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 70 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001023.25881 | 2106016.57579 | 37.7627775639463 | -122.439618557053 | (37.7627775639463, -122.439618557053) | 15 | 5 | 5 | 28862 | 3 | |||
| 84205 | 230410 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Potrero Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010454.77139 | 2105010.44358 | 37.7605472416892 | -122.406927207828 | (37.7605472416892, -122.406927207828) | 10 | 4 | 8 | 28859 | 19 | |||
| 86035 | 230419 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003538.97469 | 2095464.77113 | 37.7339476364774 | -122.430164781185 | (37.7339476364774, -122.430164781185) | 2 | 7 | 5 | 28861 | 25 | |||
| 87561 | 93246 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
| 89910 | 177456 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001539.4565 | 2094159.89194 | 37.7302512852618 | -122.436984326781 | (37.7302512852618, -122.436984326781) | 9 | 7 | 6 | 28861 | 25 | |||
| 90681 | 193412 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2200 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011187.90739 | 2105585.43525 | 37.7621670366875 | -122.404432085586 | (37.7621670366875, -122.404432085586) | 8 | 3 | 8 | 28856 | 29 | |||
| 91411 | 230405 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010473.72719 | 2104680.02328 | 37.7596410425128 | -122.406838360202 | (37.7596410425128, -122.406838360202) | 10 | 4 | 8 | 28859 | 19 | |||
| 91708 | 193434 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 598 Missouri St | 3 | : | Tree | Private 2 | 6 | Width 3ft | 6013537.98707 | 2104307.61874 | 37.7587894825673 | -122.396214437761 | (37.7587894825673, -122.396214437761) | 10 | 3 | 8 | 28856 | 29 | |||
| 93417 | 94253 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 94176 | 193427 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014474.19771 | 2103855.91322 | 37.7576012452178 | -122.392944960565 | (37.7576012452178, -122.392944960565) | 10 | 3 | 8 | 28856 | 29 | |||
| 94195 | 193422 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015855.7958 | 2105797.31045 | 37.763008553013 | -122.388302284235 | (37.763008553013, -122.388302284235) | 14 | 3 | 8 | 28856 | 29 | |||
| 94211 | 117589 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2698 VALLEJO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000707 | 2117582 | 37.7945152706116 | -122.441542364689 | (37.7945152706116, -122.441542364689) | 13 | 9 | 1 | 57 | 27 | ||||
| 94441 | 89392 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1532 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:13:00 AM | 3 | 3x3 | 5993876.23543 | 2112127.34483 | 37.779146745751 | -122.464781174904 | (37.779146745751, -122.464781174904) | 11 | 6 | 2 | 54 | 11 | ||
| 95414 | 160423 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 525 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:43:00 PM | 3 | Width 0ft | 6002340.52441 | 2089668.33181 | 37.7179639695305 | -122.433894007997 | (37.7179639695305, -122.433894007997) | 9 | 7 | 6 | 28861 | 5 | |
| 102453 | 202021 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6013834.37055 | 2091185.24466 | 37.722774667999 | -122.394270657471 | (37.722774667999, -122.394270657471) | 10 | 3 | 8 | 58 | 1 | |||
| 103794 | 193429 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1151 22nd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014506.85634 | 2103858.18885 | 37.7576093076281 | -122.392832172067 | (37.7576093076281, -122.392832172067) | 10 | 3 | 8 | 28856 | 29 | |||
| 104009 | 193411 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 681 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011009.79725 | 2105127.16685 | 37.7608987794618 | -122.40501583552 | (37.7608987794618, -122.40501583552) | 10 | 3 | 8 | 28856 | 29 | |||
| 104384 | 230422 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 387 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007833.76172 | 2105654.72593 | 37.7621692805159 | -122.416037736769 | (37.7621692805159, -122.416037736769) | 8 | 4 | 7 | 28859 | 19 | |||
| 104540 | 143848 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2900 Balboa St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5986608 | 2111175 | 37.7761101535306 | -122.489854574072 | (37.7761101535306, -122.489854574072) | 11 | 6 | 2 | 55 | 26 | ||
| 106536 | 252993 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 107920 | 251756 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 233 Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001887 | 2086528 | 37.7093155646434 | -122.43523714505 | (37.7093155646434, -122.43523714505) | 9 | 7 | 6 | 28861 | 5 | ||||
| 109916 | 230413 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 310 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2016 08:33:00 AM | 1 | Width 7ft | 6004826.22566 | 2106515.98799 | 37.7643645463025 | -122.426500991746 | (37.7643645463025, -122.426500991746) | 8 | 4 | 5 | 28859 | 3 | ||
| 109949 | 117154 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014461.75742 | 2103731.13458 | 37.757257938912 | -122.3929792544 | (37.757257938912, -122.3929792544) | 10 | 3 | 8 | 28856 | 29 | |||
| 111101 | 18346 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 447 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/21/2006 12:00:00 AM | 3 | 3x3 | 6010394.89315 | 2106204.37839 | 37.7638221660807 | -122.407218464984 | (37.7638221660807, -122.407218464984) | 8 | 4 | 8 | 28859 | 19 | ||
| 113355 | 93239 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | 2 | 4 | 5 | 28862 | 3 | ||
| 113466 | 208858 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 438 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995058.10493 | 2088636.31029 | 37.7147143277695 | -122.458991293911 | (37.7147143277695, -122.458991293911) | 9 | 8 | 6 | 28861 | 24 | |||
| 117782 | 230407 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Potrero Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010466.98 | 2104784.69833 | 37.7599280791473 | -122.406869072951 | (37.7599280791473, -122.406869072951) | 10 | 4 | 8 | 28859 | 19 | |||
| 119888 | 117157 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6014459.2864 | 2103784.30474 | 37.7574037954676 | -122.39299152025 | (37.7574037954676, -122.39299152025) | 10 | 3 | 8 | 28856 | 29 | |||
| 120121 | 177457 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001558.28444 | 2094165.30046 | 37.7302672059603 | -122.436919623235 | (37.7302672059603, -122.436919623235) | 9 | 7 | 6 | 28861 | 25 | |||
| 120530 | 230415 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003663.13723 | 2095538.7313 | 37.7341577459882 | -122.429740786804 | (37.7341577459882, -122.429740786804) | 2 | 7 | 5 | 28861 | 25 | |||
| 120857 | 252995 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 120990 | 18472 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1245 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/11/2015 07:25:00 AM | 3 | 3X3 | 6010625.30786 | 2102050.90235 | 37.7524305418599 | -122.406128887762 | (37.7524305418599, -122.406128887762) | 10 | 4 | 8 | 28859 | 19 | ||
| 121854 | 160421 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 591 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 04:04:00 PM | 3 | Width 0ft | 6002387.35536 | 2089638.81491 | 37.7178855801363 | -122.433730025613 | (37.7178855801363, -122.433730025613) | 9 | 7 | 6 | 28861 | 5 | |
| 122662 | 93247 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
| 124024 | 177454 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001501.63972 | 2094151.35591 | 37.7302256977428 | -122.43711445329 | (37.7302256977428, -122.43711445329) | 9 | 7 | 6 | 28861 | 25 | |||
| 124156 | 216755 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 115 Harold Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/04/2017 01:38:00 PM | 3 | Width 3ft | 5996789.87728 | 2090654.02957 | 37.720353912481 | -122.453151180205 | (37.720353912481, -122.453151180205) | 9 | 8 | 6 | 28861 | 24 | ||
| 125437 | 251758 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 241 Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 10:31:00 AM | 3 | 3x3 | 6001856 | 2086522 | 37.7092973294849 | -122.435343856961 | (37.7092973294849, -122.435343856961) | 9 | 7 | 6 | 28861 | 5 | ||
| 127114 | 251755 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 201X Winding Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:50:00 AM | 3 | 3x3 | 6002020 | 2086565 | 37.7094247104414 | -122.434780120464 | (37.7094247104414, -122.434780120464) | 9 | 7 | 6 | 28861 | 5 | ||
| 127494 | 25480 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2006 12:00:00 AM | 3 | 3x3 | 6010409.92318 | 2105901.91388 | 37.7629925082126 | -122.407145158522 | (37.7629925082126, -122.407145158522) | 8 | 4 | 8 | 28859 | 19 | ||
| 128424 | 230404 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 995 Potrero Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010493.00859 | 2104414.71875 | 37.7589136546545 | -122.406752977672 | (37.7589136546545, -122.406752977672) | 10 | 4 | 8 | 28859 | 19 | |||
| 132776 | 193436 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 608 Missouri St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013540.38062 | 2104266.7592 | 37.7586774243529 | -122.396203296069 | (37.7586774243529, -122.396203296069) | 10 | 3 | 8 | 28856 | 29 | |||
| 134923 | 230418 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003572.46167 | 2095485.43499 | 37.7340062713591 | -122.430050480067 | (37.7340062713591, -122.430050480067) | 2 | 7 | 5 | 28861 | 25 | |||
| 135804 | 101613 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 681 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 9x7 | 6011003.32363 | 2105183.63205 | 37.7610534583629 | -122.405042200948 | (37.7610534583629, -122.405042200948) | 10 | 3 | 8 | 28856 | 29 | |||
| 135873 | 193409 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 551 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010674.14728 | 2105512.66894 | 37.7619385126714 | -122.406203867837 | (37.7619385126714, -122.406203867837) | 10 | 4 | 8 | 28859 | 19 | |||
| 136360 | 251754 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 201X Winding Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 12:00:00 AM | 3 | 3x3 | 6002020 | 2086565 | 37.7094247104414 | -122.434780120464 | (37.7094247104414, -122.434780120464) | 9 | 7 | 6 | 28861 | 5 | ||
| 136380 | 230403 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 995 Potrero Ave | 10 | : | Tree | Private 2 | 4 | Width 2ft | 6010508.06667 | 2104211.71419 | 37.7583570921231 | -122.406686593337 | (37.7583570921231, -122.406686593337) | 10 | 4 | 8 | 28859 | 19 | |||
| 136965 | 101612 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 681 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 7x5 | 6011003.08602 | 2105162.84205 | 37.7609963604006 | -122.405041558844 | (37.7609963604006, -122.405041558844) | 10 | 3 | 8 | 28856 | 29 | |||
| 139187 | 202028 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 10 | : | Tree | Private 2 | 3 | Width 3ft | 6013610.79633 | 2091351.15014 | 37.7232177810632 | -122.395055126189 | (37.7232177810632, -122.395055126189) | 10 | 3 | 8 | 58 | 1 | |||
| 140390 | 90247 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3026 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5986141.47877 | 2111169.78384 | 37.7760685803771 | -122.49146798939 | (37.7760685803771, -122.49146798939) | 11 | 6 | 2 | 55 | 26 | ||
| 141793 | 94257 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2777X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.409573390285 | (37.7597963985886, -122.409573390285) | 2 | 4 | 8 | 28859 | 19 | |||
| 141844 | 178825 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 927 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 09:33:00 AM | 3 | Width 3ft | 6004370.89542 | 2090731.88415 | 37.7209992632754 | -122.42695160694 | (37.7209992632754, -122.42695160694) | 9 | 7 | 6 | 28861 | 5 | |
| 143414 | 93243 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 656 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004259 | 2105076 | 37.7603786010488 | -122.428360227113 | (37.7603786010488, -122.428360227113) | 2 | 4 | 5 | 28862 | 3 | ||
| 143815 | 94250 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2125 BRYANT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009652 | 2104721 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | 2 | 4 | 8 | 28859 | 19 | |||
| 144366 | 123782 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992174.17281 | 2110703.76964 | 37.7751397174253 | -122.470565540203 | (37.7751397174253, -122.470565540203) | 11 | 6 | 2 | 54 | 11 | |||
| 145383 | 202026 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6013645.7458 | 2091325.32173 | 37.7231488048702 | -122.394932503635 | (37.7231488048702, -122.394932503635) | 10 | 3 | 8 | 58 | 1 | |||
| 145867 | 252999 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 146568 | 202019 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1350 Fitzgerald Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013890.08621 | 2091145.17982 | 37.7226677548035 | -122.394075255469 | (37.7226677548035, -122.394075255469) | 10 | 3 | 8 | 58 | 1 | |||
| 146871 | 253002 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 148064 | 117159 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014455.78719 | 2103822.04979 | 37.7575072408736 | -122.393006262848 | (37.7575072408736, -122.393006262848) | 10 | 3 | 8 | 28856 | 29 | |||
| 148422 | 251775 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 10:17:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.78866 | 37.7115791562393 | -122.435864336264 | (37.7115791562393, -122.435864336264) | 9 | 7 | 6 | 28861 | 5 | ||
| 153082 | 18993 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2965 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1999 12:00:00 AM | 3 | 3X3 | 6000621.16815 | 2115478.56365 | 37.7887348935356 | -122.441688325582 | (37.7887348935356, -122.441688325582) | 13 | 6 | 1 | 29490 | 27 | ||
| 153197 | 230396 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 675 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010452.66825 | 2105159.82839 | 37.7609573010551 | -122.406945010817 | (37.7609573010551, -122.406945010817) | 10 | 4 | 8 | 28859 | 19 | |||
| 153352 | 93238 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004217.7 | 2105335.5 | 37.761088789181 | -122.428521561971 | (37.761088789181, -122.428521561971) | 2 | 4 | 5 | 28862 | 3 | ||
| 154077 | 123781 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992148.27248 | 2110704.3151 | 37.7751397174227 | -122.47065517412 | (37.7751397174227, -122.47065517412) | 11 | 6 | 2 | 54 | 11 | |||
| 154731 | 93241 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 626 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004249 | 2105248 | 37.7608503062499 | -122.428407072017 | (37.7608503062499, -122.428407072017) | 2 | 4 | 5 | 28862 | 3 | ||
| 155778 | 94256 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2777X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6009684.4 | 2104752.7 | 37.7597963985886 | -122.409573390285 | (37.7597963985886, -122.409573390285) | 2 | 4 | 8 | 28859 | 19 | |||
| 156552 | 93245 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004369 | 2103119 | 37.7550113653552 | -122.427840341146 | (37.7550113653552, -122.427840341146) | 2 | 4 | 5 | 28862 | 22 | ||
| 160551 | 193414 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 563 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011255.16087 | 2105737.93689 | 37.762589530116 | -122.40421021384 | (37.762589530116, -122.40421021384) | 8 | 3 | 8 | 28856 | 29 | |||
| 160673 | 18475 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1260 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2013 12:00:00 AM | 3 | 3x3 | 6010550.21333 | 2101942.07688 | 37.7521275305728 | -122.406380911075 | (37.7521275305728, -122.406380911075) | 10 | 4 | 7 | 28859 | 19 | ||
| 160987 | 253001 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 161364 | 193420 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015798.54633 | 2105794.6845 | 37.7629981703438 | -122.38850010901 | (37.7629981703438, -122.38850010901) | 14 | 3 | 8 | 28856 | 29 | |||
| 162230 | 17176 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1601 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/1999 12:00:00 AM | 3 | 4X4 | 6004921.1693652 | 2114736.5058392 | 37.7869414485048 | -122.426758067349 | (37.7869414485048, -122.426758067349) | 13 | 9 | 11 | 28858 | 27 | ||
| 164144 | 6738 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1300X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2016 12:00:00 AM | 1 | 3x3 | 6016982.91603 | 2097217.69187 | 37.7395130873532 | -122.383806518479 | (37.7395130873532, -122.383806518479) | 10 | 3 | 8 | 58 | 1 | ||
| 164163 | 193418 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 610 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015955.04058 | 2106161.79394 | 37.7640148449206 | -122.387984462917 | (37.7640148449206, -122.387984462917) | 14 | 3 | 8 | 28856 | 29 | |||
| 166488 | 193413 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2200 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011171.17043 | 2105584.01117 | 37.7621621911485 | -122.404489872412 | (37.7621621911485, -122.404489872412) | 8 | 3 | 8 | 28856 | 29 | |||
| 167252 | 193415 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1425 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6015129.4675 | 2101818.79874 | 37.7520441382513 | -122.390536410622 | (37.7520441382513, -122.390536410622) | 10 | 3 | 8 | 28856 | 1 | |||
| 168745 | 252997 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | 10 | 3 | 8 | 28856 | 29 | |||
| 169178 | 78830 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 35 Laura St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/2017 04:01:00 PM | 3 | 5997431.0713 | 2086896.39523 | 37.7100730444948 | -122.450664016958 | (37.7100730444948, -122.450664016958) | 9 | 7 | 6 | 28861 | 25 | ||
| 172302 | 230416 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003629.87373 | 2095518.06271 | 37.7340991110765 | -122.429854315422 | (37.7340991110765, -122.429854315422) | 2 | 7 | 5 | 28861 | 25 | |||
| 174645 | 230412 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 310 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2016 08:29:00 AM | 1 | Width 6ft | 6004822.22232 | 2106544.83878 | 37.7644435373721 | -122.426516892666 | (37.7644435373721, -122.426516892666) | 8 | 4 | 5 | 28862 | 3 | ||
| 175505 | 193417 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1425 Indiana St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6015126.28801 | 2101884.04231 | 37.7522231069197 | -122.390551964402 | (37.7522231069197, -122.390551964402) | 10 | 3 | 8 | 28856 | 1 | |||
| 175595 | 117160 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014455.03317 | 2103837.45298 | 37.7575494928317 | -122.393009948265 | (37.7575494928317, -122.393009948265) | 10 | 3 | 8 | 28856 | 29 | |||
| 176400 | 193410 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 551 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010705.60274 | 2105553.43771 | 37.7620522139578 | -122.406097947485 | (37.7620522139578, -122.406097947485) | 8 | 4 | 8 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );