trees
305 rows where qSpecies_id = 49 sorted by qAddress descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45560 | 93296 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 999X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004559.2 | 2103505.3 | 37.7560828122733 | -122.427210089969 | (37.7560828122733, -122.427210089969) | 2 | 4 | 5 | 28862 | 22 | ||
| 33563 | 230402 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 995 Potrero Ave | 3 | : | Tree | Private 2 | 7 | Width 4ft | 6010527.0507 | 2103856.48907 | 37.7573827855076 | -122.406595905697 | (37.7573827855076, -122.406595905697) | 10 | 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 | |||
| 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 | |||
| 38416 | 93248 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 990 Church St | 4 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 62081 | 93297 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 985 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004420 | 2103163 | 37.7551350639762 | -122.427667103261 | (37.7551350639762, -122.427667103261) | 2 | 4 | 5 | 28862 | 22 | ||
| 188069 | 95808 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 974 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767552 | 6011863.56882 | 2103875.82821 | 37.7575105701687 | -122.401975028944 | (37.7575105701687, -122.401975028944) | 10 | 3 | 8 | 28856 | 29 |
| 194394 | 160700 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 932 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 0ft | 6003612.41439 | 2089600.12112 | 37.7178487735724 | -122.429492779881 | (37.7178487735724, -122.429492779881) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |
| 27287 | 255049 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 925 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779631 | 6009075.60356 | 2091383.60862 | 37.7230536656288 | -122.410734764023 | (37.7230536656288, -122.410734764023) | 9 | 3 | 7 | 309 | 28 | |
| 5303 | 254848 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 914 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | 5999583 | 2111627 | 37.7781002923949 | -122.445003231417 | (37.7781002923949, -122.445003231417) | 15 | 5 | 11 | 29490 | 16 | |||
| 31136 | 93244 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 910X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004315 | 2103566.4 | 37.7562367654726 | -122.428058969621 | (37.7562367654726, -122.428058969621) | 2 | 4 | 5 | 28862 | 22 | ||
| 156269 | 8129 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 899 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2013 12:00:00 AM | 12 | 3X3 | Permit Number 770378 | 6003470.39544 | 2111382.10126 | 37.7776489625125 | -122.431537848369 | (37.7776489625125, -122.431537848369) | 7 | 9 | 11 | 29492 | 10 | |
| 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 | |||
| 20891 | 93298 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 869 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004381 | 2103841 | 37.7569944861757 | -122.427850284713 | (37.7569944861757, -122.427850284713) | 2 | 4 | 5 | 28862 | 3 | ||
| 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 | ||
| 15123 | 171866 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 845 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Width 3ft | 6009218.01961 | 2091423.53982 | 37.7231712923965 | -122.410245276296 | (37.7231712923965, -122.410245276296) | 9 | 3 | 7 | 309 | 28 | ||
| 185674 | 82560 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 832 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52208 | 6009084.37207289 | 2104307.27777207 | 37.7585397298832 | -122.411617128308 | (37.7585397298832, -122.411617128308) | 2 | 4 | 7 | 28859 | 19 | ||
| 979 | 171867 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 825 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | Width 3ft | 6009309.97305 | 2091452.93347 | 37.7232571551673 | -122.409929483882 | (37.7232571551673, -122.409929483882) | 9 | 3 | 7 | 309 | 28 | ||
| 60765 | 109580 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 822 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 10:16:00 AM | 3 | 3x3 | Permit Number 775019 | 6004058.45374 | 2090883.76652 | 37.7213986270377 | -122.428042443214 | (37.7213986270377, -122.428042443214) | 9 | 7 | 6 | 28861 | 5 |
| 40221 | 193426 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 807 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6015414.46793 | 2103902.85001 | 37.7577823075377 | -122.389696374594 | (37.7577823075377, -122.389696374594) | 10 | 3 | 8 | 28856 | 29 | |||
| 184892 | 93299 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 801X Church St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004394.3 | 2104124.7 | 37.7577742117678 | -122.427824502367 | (37.7577742117678, -122.427824502367) | 2 | 4 | 5 | 28862 | 3 | ||
| 46204 | 251736 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 8 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 11:28:00 AM | 3 | 3x3 | 6002228 | 2087184 | 37.7111361560163 | -122.434105459048 | (37.7111361560163, -122.434105459048) | 9 | 7 | 6 | 28861 | 5 | ||
| 15803 | 150046 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 790 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6015435.45037 | 2105401.72927 | 37.7618990720098 | -122.389728496571 | (37.7618990720098, -122.389728496571) | 10 | 3 | 8 | 28856 | 29 | |||
| 57776 | 18381 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 768 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010390.09454 | 2104720.536 | 37.7597476013854 | -122.407130460918 | (37.7597476013854, -122.407130460918) | 10 | 4 | 8 | 28859 | 19 | |||
| 16517 | 162307 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 757 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6010810.72096 | 2091174.85054 | 37.7225775923629 | -122.404722090874 | (37.7225775923629, -122.404722090874) | 10 | 3 | 7 | 309 | 28 | |||
| 160733 | 108628 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 741 Ellis St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774600 | 6007319.99858 | 2113650.90643 | 37.7840959912819 | -122.418381641984 | (37.7840959912819, -122.418381641984) | 7 | 9 | 9 | 28858 | 36 | |
| 56180 | 255527 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 730 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782016 | 6003494.63141 | 2110038.24994 | 37.7739604525435 | -122.431358054188 | (37.7739604525435, -122.431358054188) | 15 | 9 | 11 | 29492 | 10 |
| 36606 | 160510 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 706 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 03:18:00 PM | 3 | Width 0ft | 6001927.69711 | 2089831.31409 | 37.7183880466434 | -122.435332621096 | (37.7183880466434, -122.435332621096) | 9 | 7 | 6 | 28861 | 5 | |
| 44917 | 230408 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Potrero Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010466.90309 | 2104889.86859 | 37.7602168487345 | -122.40687675138 | (37.7602168487345, -122.40687675138) | 10 | 4 | 8 | 28859 | 19 | |||
| 51788 | 230409 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Potrero Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010459.52552 | 2104963.6053 | 37.7604189003367 | -122.406907464126 | (37.7604189003367, -122.406907464126) | 10 | 4 | 8 | 28859 | 19 | |||
| 64907 | 230406 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010469.85138 | 2104738.84531 | 37.7598023377254 | -122.406855910494 | (37.7598023377254, -122.406855910494) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 15663 | 117153 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6014462.23102 | 2103712.78244 | 37.757207574192 | -122.392976332502 | (37.757207574192, -122.392976332502) | 10 | 3 | 8 | 28856 | 29 | |||
| 39719 | 117155 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6014460.76675 | 2103748.99279 | 37.757306918684 | -122.392983929988 | (37.757306918684, -122.392983929988) | 10 | 3 | 8 | 28856 | 29 | |||
| 39991 | 117156 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6014458.77622 | 2103767.54398 | 37.7573577456892 | -122.392992112005 | (37.7573577456892, -122.392992112005) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 184363 | 117158 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 701 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014455.94065 | 2103803.29799 | 37.7574557609929 | -122.393004420141 | (37.7574557609929, -122.393004420141) | 10 | 3 | 8 | 28856 | 29 | |||
| 49816 | 46416 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 700 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2002 12:00:00 AM | 5 | 3x3 | Permit Number 44641 | 6015974.86179 | 2105759.18936 | 37.7629104774528 | -122.387887811877 | (37.7629104774528, -122.387887811877) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |
| 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 | |||
| 11491 | 160766 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 695 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6003187.32082 | 2089217.65008 | 37.7167745145126 | -122.430934858059 | (37.7167745145126, -122.430934858059) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 180617 | 101611 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 681 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x6 | 6011008.34199 | 2105144.37638 | 37.7609459516243 | -122.40502208042 | (37.7609459516243, -122.40502208042) | 10 | 3 | 8 | 28856 | 29 | |||
| 44046 | 230395 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 675 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010455.48203 | 2105111.38251 | 37.7608244370314 | -122.406931864509 | (37.7608244370314, -122.406931864509) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 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 | ||
| 26988 | 5478 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 655 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2013 12:00:00 AM | 2 | 3X3 | 6005024.7062 | 2104455.06021 | 37.7587169450524 | -122.425667807635 | (37.7587169450524, -122.425667807635) | 2 | 4 | 5 | 28859 | 19 | ||
| 174483 | 108870 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 636 Lyon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773421 | 6000111.40758 | 2111064.83155 | 37.7765868652264 | -122.443134899814 | (37.7765868652264, -122.443134899814) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | ||
| 7487 | 18369 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 635 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/02/2016 12:00:00 AM | 3 | 4X4 | 6010448.75923 | 2105261.1592 | 37.7612353138857 | -122.406965672731 | (37.7612353138857, -122.406965672731) | 10 | 4 | 8 | 28859 | 19 | ||
| 15316 | 230398 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 635 Potrero Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 4x4 | 6010498 | 2105292 | 37.7613227510593 | -122.406797542609 | (37.7613227510593, -122.406797542609) | 10 | 4 | 8 | 28859 | 19 | |||
| 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 | |||
| 182962 | 230399 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 635 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6010446.03903 | 2105294.43136 | 37.761326519519 | -122.406977425991 | (37.761326519519, -122.406977425991) | 10 | 4 | 8 | 28859 | 19 | |||
| 7799 | 112881 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 634 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2015 12:00:00 AM | Permit Number 773545 | 5985072.5 | 2111537.7 | 37.7770162467569 | -122.495192953952 | (37.7770162467569, -122.495192953952) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | ||
| 190715 | 18367 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 625 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/17/2015 09:59:00 AM | 3 | 4X3 | 6010438.66394 | 2105366.85434 | 37.7615249639888 | -122.407008038291 | (37.7615249639888, -122.407008038291) | 10 | 4 | 8 | 28859 | 19 | ||
| 12250 | 75673 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 618X Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6013545.06469 | 2104202.26889 | 37.7585006086339 | -122.396182576568 | (37.7585006086339, -122.396182576568) | 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 | |||
| 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 | |||
| 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 | |||
| 40989 | 5473 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 05:56:00 AM | 3 | 4X4 | 6005007.93466 | 2104733.32137 | 37.7594800368996 | -122.425745616993 | (37.7594800368996, -122.425745616993) | 2 | 4 | 5 | 28859 | 19 | ||
| 2951 | 258117 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010889.02957 | 2091945.92933 | 37.724699191929 | -122.404505645081 | (37.724699191929, -122.404505645081) | 10 | 3 | 7 | 309 | 28 | ||
| 3543 | 258123 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Brussels St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010889.02957 | 2091945.92933 | 37.724699191929 | -122.404505645081 | (37.724699191929, -122.404505645081) | 10 | 3 | 7 | 309 | 28 | ||
| 6295 | 258118 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 601 Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010889.02957 | 2091945.92933 | 37.724699191929 | -122.404505645081 | (37.724699191929, -122.404505645081) | 10 | 3 | 7 | 309 | 28 | ||
| 18701 | 4660 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | 3 | 1 | 10 | 308 | 23 | |||
| 19186 | 261345 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Columbus Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2020 02:12:00 PM | 3 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | 3 | 1 | 10 | 308 | 23 | ||
| 19221 | 4665 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Columbus Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2020 02:10:00 PM | 3 | 5X5 | 6009675.3838 | 2119664.5956 | 37.8007404309352 | -122.410657649881 | (37.8007404309352, -122.410657649881) | 3 | 1 | 10 | 308 | 23 | ||
| 34741 | 93240 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Church St | 3 | 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 | ||
| 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 | ||
| 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 | ||
| 3314 | 193435 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600 Missouri St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6013537.44197 | 2104295.86136 | 37.7587571690323 | -122.396215498963 | (37.7587571690323, -122.396215498963) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |
| 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 | |
| 21356 | 193433 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 588 Missouri St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6013536.39974 | 2104342.74788 | 37.758885851209 | -122.396222389564 | (37.758885851209, -122.396222389564) | 10 | 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 | |||
| 50257 | 193431 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 568 Missouri St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013531.88693 | 2104447.0848 | 37.7591720865425 | -122.396245309678 | (37.7591720865425, -122.396245309678) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 155215 | 109566 | Permitted Site 7 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 56 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775012 | 6000375.8 | 2089821 | 37.7182714712375 | -122.440696127295 | (37.7182714712375, -122.440696127295) | 9 | 7 | 6 | 28861 | 25 |
| 49364 | 35383 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 557 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 6 | Permit Number 38839 | 6011254.22436 | 2105785.28099 | 37.7627194740588 | -122.4042167852 | (37.7627194740588, -122.4042167852) | 8 | 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 | |||
| 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 | |||
| 3337 | 261748 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 11461 | 261747 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 15024 | 261746 | Section 806 (d) 5 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 540 De Haro St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
| 14386 | 160654 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 527 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2017 12:00:00 AM | 3 | 3x3 | 6001557.28645 | 2090682.81807 | 37.7207050428777 | -122.436673891586 | (37.7207050428777, -122.436673891586) | 9 | 7 | 6 | 28861 | 5 | ||
| 3354 | 258363 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 526 Silliman St | Sidewalk: Property side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6009244.29167 | 2093882.64592 | 37.7299249505577 | -122.410328004922 | (37.7299249505577, -122.410328004922) | 9 | 3 | 7 | 309 | 28 | ||||
| 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 |
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) );