trees
305 rows where qSpecies_id = 49 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 73843 | 93629 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/16/2010 12:00:00 AM | 3x3 | Permit Number 53264 | 5985797 | 2114222 | 37.7844289534299 | -122.492884487425 | (37.7844289534299, -122.492884487425) | 11 | 6 | 1 | 55 | 33 | ||
| 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 | |||
| 74860 | 39178 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1050 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | |
| 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 | |||
| 77890 | 115285 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 32 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775365 | 6004721.1 | 2096171.8 | 37.7359558621574 | -122.426128127271 | (37.7359558621574, -122.426128127271) | 2 | 7 | 5 | 28861 | 2 | |||
| 78395 | 132020 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1028 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782077 | 6007946.58222 | 2119968.79133 | 37.8014785977268 | -122.416661599167 | (37.8014785977268, -122.416661599167) | 5 | 1 | 10 | 308 | 32 | |
| 79191 | 55909 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Permit Number 11967 | 5986171.45599 | 2111171.12387 | 37.7760740114518 | -122.491364390312 | (37.7760740114518, -122.491364390312) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||
| 88404 | 100008 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501X Mission St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 06/26/2012 12:00:00 AM | Permit Number 768978 | 6013380.8 | 2115570.5 | 37.7897060631976 | -122.397547983339 | (37.7897060631976, -122.397547983339) | 12 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 90449 | 115264 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1634 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.479740639367 | (37.7571489820097, -122.479740639367) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||
| 96348 | 115319 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 86 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | Permit Number 777439 | 6000946.9 | 2101238.5 | 37.7496537815844 | -122.439540113547 | (37.7496537815844, -122.439540113547) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 102625 | 52820 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:00:00 PM | 3 | Permit Number 775537 | 5989777.02787 | 2111978.29339 | 37.778500303461 | -122.478950948669 | (37.778500303461, -122.478950948669) | 11 | 6 | 2 | 55 | 26 | ||
| 103176 | 54058 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/24/2011 12:00:00 AM | Permit Number 767754 | 5994238.69785688 | 2106641.55496777 | 37.7641051091536 | -122.463129131181 | (37.7641051091536, -122.463129131181) | 1 | 5 | 11 | 56 | 12 | |||
| 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 | |||
| 104437 | 106758 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 445 Grafton Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | Permit Number 772911 | 5995409.1 | 2090523.2 | 37.7199154518997 | -122.457914582927 | (37.7199154518997, -122.457914582927) | 9 | 8 | 6 | 28861 | 24 | ||||
| 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 | ||
| 104688 | 117301 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2238 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.491820695636 | (37.7453216318219, -122.491820695636) | 1 | 8 | 3 | 29491 | 35 | ||
| 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 | |||
| 115784 | 115265 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1634 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775141 | 5989384.4 | 2104210.4 | 37.7571489820097 | -122.479740639367 | (37.7571489820097, -122.479740639367) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | ||
| 121448 | 115375 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 230 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776301 | 6007067.3 | 2096865.5 | 37.7379929380378 | -122.418065521541 | (37.7379929380378, -122.418065521541) | 2 | 7 | 7 | 28859 | 2 | ||
| 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 | ||
| 126697 | 46981 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1310 Minnesota St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | 1 | Permit Number 44998 | 6015319.9852 | 2102418.03165 | 37.7537000725041 | -122.389919420856 | (37.7537000725041, -122.389919420856) | 10 | 3 | 8 | 28856 | 29 | ||
| 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 | |||
| 129187 | 94327 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1132 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2010 12:00:00 AM | 3x3 | Permit Number 53627 | 5995101.4 | 2091446 | 37.7224315574184 | -122.459044970295 | (37.7224315574184, -122.459044970295) | 9 | 8 | 4 | 28861 | 24 | ||
| 132572 | 54713 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2701 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2018 12:00:00 AM | 3 | Permit Number 781936 | 6001165.76206 | 2116883.2589 | 37.7926228359235 | -122.43990487064 | (37.7926228359235, -122.43990487064) | 13 | 6 | 1 | 29490 | 27 | ||
| 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 | |||
| 133579 | 39177 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1050 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2015 12:00:00 AM | 3 | 4x4 | Permit Number 775243 | 6007589.88726975 | 2103539.15878969 | 37.7563467058962 | -122.416731326975 | (37.7563467058962, -122.416731326975) | 2 | 4 | 7 | 28859 | 19 | |
| 134063 | 62821 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 165 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2010 12:00:00 AM | 3x3 | Permit Number 53769 | 6004060.48554268 | 2101568.78877881 | 37.7507373914484 | -122.42879676445 | (37.7507373914484, -122.42879676445) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | |||
| 139324 | 115273 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1314 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775588 | 5985278.7 | 2106245.9 | 37.7624985311794 | -122.49408954164 | (37.7624985311794, -122.49408954164) | 1 | 8 | 3 | 56 | 35 | |||
| 139355 | 114987 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2015 12:00:00 AM | Permit Number 775985 | 5995400.7 | 2089591.3 | 37.7173561925503 | -122.457876217939 | (37.7173561925503, -122.457876217939) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | |||
| 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 | |||
| 143820 | 46415 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 700 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015975.28241 | 2105780.03754 | 37.7629677453768 | -122.3878878119 | (37.7629677453768, -122.3878878119) | 10 | 3 | 8 | 28856 | 29 | |
| 144083 | 88518 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 133 Kenwood Way | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51449 | 5994469.5 | 2093573.6 | 37.7282370866894 | -122.46138344933 | (37.7282370866894, -122.46138344933) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 146964 | 52821 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2850@ ANZA Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 12:32:00 PM | 3 | Permit Number 775537 | 5989762.54787 | 2111977.16007 | 37.7784963508186 | -122.479000957003 | (37.7784963508186, -122.479000957003) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 148083 | 104967 | Undocumented 4 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143-147 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | Permit Number 770854 | 6005451.2 | 2102876.8 | 37.7544075015735 | -122.424080557223 | (37.7544075015735, -122.424080557223) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | ||
| 151715 | 117300 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2238 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778520 | 5985801.3 | 2099978.9 | 37.7453216318219 | -122.491820695636 | (37.7453216318219, -122.491820695636) | 1 | 8 | 3 | 29491 | 35 | ||
| 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 |
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) );