trees
305 rows where qSpecies_id = 49 sorted by qLegalStatus_id 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 15725 | 128091 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 103 North Point St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:22:00 PM | 3 | Width 3ft | 6009972.30221 | 2121930.59441 | 37.8069789439766 | -122.409790224757 | (37.8069789439766, -122.409790224757) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | |||
| 16233 | 258379 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1139 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007502.57934 | 2093306.87278 | 37.728246213244 | -122.416308562579 | (37.728246213244, -122.416308562579) | 9 | 3 | 7 | 309 | 5 | |||
| 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 | |||
| 17164 | 258124 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 231 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011067.40482 | 2091994.16139 | 37.7248415942661 | -122.403892413165 | (37.7248415942661, -122.403892413165) | 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 | ||
| 19235 | 258172 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 251 Harvard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6006263.61536 | 2092702.55059 | 37.726517128556 | -122.420548839119 | (37.726517128556, -122.420548839119) | 9 | 7 | 7 | 309 | 5 | |||
| 19242 | 202025 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013662.90177 | 2091312.27446 | 37.7231139336312 | -122.394872285044 | (37.7231139336312, -122.394872285044) | 10 | 3 | 8 | 58 | 1 | |||
| 19244 | 128105 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 102 North Point St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/17/2020 12:20:00 PM | 3 | Width 3ft | 6009886.88129 | 2121974.64206 | 37.8070951004301 | -122.410088954368 | (37.8070951004301, -122.410088954368) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 21263 | 18341 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 425 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2014 12:00:00 AM | 3 | 3x3 | 6010391.567 | 2106310.47571 | 37.7641132991006 | -122.407237448759 | (37.7641132991006, -122.407237448759) | 8 | 4 | 8 | 28859 | 19 | ||
| 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 | |||
| 21662 | 81651 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1100@ 12th Ave Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | Permit Number 767881 | 5992197.33713 | 2110704.35062 | 37.7751426520596 | -122.470485452724 | (37.7751426520596, -122.470485452724) | 11 | 6 | 2 | 54 | 11 | ||
| 21726 | 251776 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 12:12:00 PM | 3 | Width 6ft | 6001722.65495 | 2087355.78866 | 37.7115791562393 | -122.435864336264 | (37.7115791562393, -122.435864336264) | 9 | 7 | 6 | 28861 | 5 | ||
| 22368 | 202024 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6013681.0358 | 2091298.8599 | 37.7230781082384 | -122.394808659817 | (37.7230781082384, -122.394808659817) | 10 | 3 | 8 | 58 | 1 | |||
| 24838 | 230411 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 2901 Cesar Chavez St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6010009.79778 | 2100525.6899 | 37.7482081987543 | -122.408149874844 | (37.7482081987543, -122.408149874844) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||
| 30060 | 193438 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 170 Scotia Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6012250.26105 | 2094642.58391 | 37.7321796295918 | -122.399989292576 | (37.7321796295918, -122.399989292576) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 32699 | 251774 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 120 Seville St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 10:14:00 AM | 3 | Width 6ft | 6001722.65495 | 2087355.78866 | 37.7115791562393 | -122.435864336264 | (37.7115791562393, -122.435864336264) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | |||
| 34144 | 252994 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 3 | 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 | |||
| 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 | ||
| 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 | |
| 37230 | 208859 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 157 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995398.10832 | 2089609.60714 | 37.7174063107347 | -122.457886500157 | (37.7174063107347, -122.457886500157) | 9 | 8 | 6 | 28861 | 24 | |||
| 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 | ||
| 38708 | 230420 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 143 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005428.86473 | 2102882.34915 | 37.7544214771723 | -122.424158193041 | (37.7544214771723, -122.424158193041) | 2 | 4 | 5 | 28859 | 19 | |||
| 39558 | 202027 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 9 | : | Tree | Private 2 | 3 | Width 3ft | 6013629.18756 | 2091337.20695 | 37.72318051856 | -122.39499057468 | (37.72318051856, -122.39499057468) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 41646 | 193424 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015930.41591 | 2105802.18595 | 37.7630260745267 | -122.388044536748 | (37.7630260745267, -122.388044536748) | 14 | 3 | 8 | 28856 | 29 | |||
| 42544 | 37824 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 450X Moscow St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/07/1998 12:00:00 AM | 3 | 3x3 | Permit Number 40134 | 6003906.75378 | 2090460.71651 | 37.7202284408775 | -122.428536688136 | (37.7202284408775, -122.428536688136) | 9 | 7 | 6 | 28861 | 5 |
| 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 | |||
| 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 | |||
| 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 | ||
| 45745 | 243005 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 301 Dolores St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 6ft | 6004912.59389 | 2106510.65164 | 37.7643547760633 | -122.42620188801 | (37.7643547760633, -122.42620188801) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | ||
| 46667 | 230424 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 387 Shotwell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007831.12637 | 2105698.03942 | 37.7622880611692 | -122.416049918991 | (37.7622880611692, -122.416049918991) | 8 | 4 | 7 | 28859 | 19 | |||
| 47271 | 106182 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 26 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2014 12:00:00 AM | 9 | Permit Number 772520 | 5996564.2 | 2114395.4 | 37.7855288291914 | -122.455646443632 | (37.7855288291914, -122.455646443632) | 11 | 6 | 1 | 54 | 31 | ||
| 47719 | 108874 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 138 Cole St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781829 | 5997812.45112 | 2110130.24113 | 37.773889369558 | -122.451020208331 | (37.773889369558, -122.451020208331) | 15 | 5 | 11 | 29492 | 16 | |
| 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 | |
| 49718 | 93670 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 12 Robblee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 54071 | 6012650.87025 | 2095997.96753 | 37.7359235585191 | -122.398699370703 | (37.7359235585191, -122.398699370703) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |
| 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 | |||
| 50817 | 193425 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 501 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015950.63788 | 2105804.61367 | 37.7630338608554 | -122.387974764648 | (37.7630338608554, -122.387974764648) | 14 | 3 | 8 | 28856 | 29 | |||
| 51035 | 89723 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1535 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 11:16:00 AM | 3 | 3x3 | 5993886.8268 | 2112071.32228 | 37.7789935335335 | -122.464740465973 | (37.7789935335335, -122.464740465973) | 11 | 6 | 2 | 54 | 11 | ||
| 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 | |||
| 52022 | 131012 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1661 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006845.95984 | 2116366.0433 | 37.7915243922801 | -122.420214413174 | (37.7915243922801, -122.420214413174) | 13 | 9 | 10 | 28858 | 21 | |||
| 55581 | 18458 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1136 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/01/2006 12:00:00 AM | 3 | 4X4 | 6010508.18213 | 2102591.02821 | 37.7539070559711 | -122.406571988228 | (37.7539070559711, -122.406571988228) | 10 | 4 | 7 | 28859 | 19 | ||
| 55856 | 160433 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 401 France Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/2017 12:12:00 PM | 3 | Width 0ft | 6002070.28716 | 2089835.8834 | 37.7184086896908 | -122.43484007413 | (37.7184086896908, -122.43484007413) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 58149 | 216756 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 106 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 01:41:00 PM | 3 | Width 3ft | 5996820.43291 | 2090638.75117 | 37.7203137127762 | -122.45304445763 | (37.7203137127762, -122.45304445763) | 9 | 8 | 6 | 28861 | 24 | ||
| 59736 | 18476 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1263 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/1997 12:00:00 AM | 18 | 3X3 | 6010629.32405 | 2101956.3743 | 37.7521712133345 | -122.406108340032 | (37.7521712133345, -122.406108340032) | 10 | 4 | 8 | 28859 | 19 | ||
| 59820 | 26560 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 430 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6010280.19543 | 2097760.62921 | 37.7406310804714 | -122.407019977396 | (37.7406310804714, -122.407019977396) | 10 | 3 | 7 | 58 | 2 | ||
| 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 |
| 61010 | 230401 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010508.63913 | 2102581.4092 | 37.7538806698698 | -122.406569730021 | (37.7538806698698, -122.406569730021) | 10 | 4 | 7 | 28859 | 19 | |||
| 61091 | 177455 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1651 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001518.96973 | 2094154.72477 | 37.7302359329302 | -122.437054782357 | (37.7302359329302, -122.437054782357) | 9 | 7 | 6 | 28861 | 25 | |||
| 61398 | 202023 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1330 Fitzgerald Ave | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6013701.15269 | 2091283.23076 | 37.7230363122648 | -122.394738025239 | (37.7230363122648, -122.394738025239) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||
| 63056 | 216749 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 26 Granada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2017 08:25:00 AM | 3 | Width 3ft | 5995639.97816 | 2090086.85434 | 37.7187306119189 | -122.457084975807 | (37.7187306119189, -122.457084975807) | 9 | 8 | 6 | 28861 | 24 | ||
| 63510 | 16928 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 518 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/02/2007 12:00:00 AM | 3 | 2.5 X3 | 6004333.80114 | 2110174.91218 | 37.7743832165186 | -122.42846496782 | (37.7743832165186, -122.42846496782) | 7 | 9 | 11 | 28852 | 10 | ||
| 64671 | 253000 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 1201 Tennessee St | 9 | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 82789 | 67599 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 380 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 5 | Permit Number 31168 | 6014306.36915 | 2105365.66412 | 37.7617373703071 | -122.393631049748 | (37.7617373703071, -122.393631049748) | 10 | 3 | 8 | 28856 | 29 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );