305 rows where qSpecies_id = 49 sorted by SiteOrder

View and edit SQL

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)
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
3933 258362 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 520 Silliman St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF     4x5   6009260.75409 2093887.69259 37.7299397304564 -122.410271448334 (37.7299397304564, -122.410271448334) 9 3 7 309 28
5082 258116 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2245 Jones St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6008057.63672 2120117.2159 37.8018923796488 -122.416287818099 (37.8018923796488, -122.416287818099) 5 1 10 308 32
9531 258361 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 508 Silliman St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF     4x5   6009293.67894 2093897.78594 37.7299692902001 -122.410158335055 (37.7299692902001, -122.410158335055) 9 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
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
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
143429 108627 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 223 Douglass St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 772318 6001122.48631 2104986.51759 37.7599549235553 -122.439201532761 (37.7599549235553, -122.439201532761) 2 4 5 28862 3
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
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
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
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
1355 172161 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 224 Dwight St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x5   6010825.0191 2091483.87945 37.7234269210881 -122.404694409734 (37.7234269210881, -122.404694409734) 10 3 7 309 28
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
3719 258151 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 500X Bryant St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
4238 193153 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 33 Clementina St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2020 12:00:00 AM 3 Width 2ft Permit Number 785449 6013826.51313 2114547.38647 37.7869216386586 -122.395934124458 (37.7869216386586, -122.395934124458) 6 2 9 28855 6
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
5799 29248 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 470X Bay Shore Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 3X3   6010243.1599 2097486.61497 37.7398766239144 -122.40712872252 (37.7398766239144, -122.40712872252) 10 3 7 58 2
6939 177453 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1651 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6001481.52618 2094146.78927 37.7302120154671 -122.437183661494 (37.7302120154671, -122.437183661494) 9 7 6 28861 25
7352 49629 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1591 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 3   Permit Number 46483 6007726.58715 2109200.55407 37.7718992687552 -122.416659614369 (37.7718992687552, -122.416659614369) 8 2 9 28853 19
7720 109781 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1335 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775057 5991737.5 2106325 37.7630915327801 -122.471756892939 (37.7630915327801, -122.471756892939) 1 8 11 56 12
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
9834 166214 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 3066 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6009114.2324 2101605.68016 37.7511234258036 -122.411323007657 (37.7511234258036, -122.411323007657) 2 4 7 28859 19
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
12735 216702 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 251 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2017 08:30:00 AM 3 Width 2ft   5994715.94794 2090284.84641 37.7192211417229 -122.460293291913 (37.7192211417229, -122.460293291913) 9 8 6 28861 24
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
14395 258175 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 221 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 3x4   6010133.63921 2094113.44484 37.7306084895202 -122.40726967409 (37.7306084895202, -122.40726967409) 10 3 7 309 28
14623 171726 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1151 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   0 4x5   6007369.69842 2093265.62582 37.7281254849051 -122.416765017588 (37.7281254849051, -122.416765017588) 9 3 7 309 5
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
15309 16874 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 269 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781998 6005705.9301 2110300.3269 37.7748051262311 -122.423727430112 (37.7748051262311, -122.423727430112) 7 9 11 28852 10
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
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
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
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
29129 34304 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1248 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2016 12:00:00 AM     Permit Number 777415 6010821.325282 2102511.88817286 37.7537072691799 -122.405483487001 (37.7537072691799, -122.405483487001) 10 4 8 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
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
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
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
40245 180646 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 451 Rolph St 1 Sidewalk: Curb side : Yard Tree Private 2     0 Width 6ft   6002230.18825 2087673.61332 37.7124806510226 -122.434132874236 (37.7124806510226, -122.434132874236) 9 7 6 28861 5
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
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
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
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
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
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
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
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
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
52174 99998 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 1 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013420 2115433 37.7893307029327 -122.397402707509 (37.7893307029327, -122.397402707509) 12 2 9 28855 6
54675 87806 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 291 28th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 3 3x12 Permit Number 50584 5987096.8 2114028.5 37.7839735823988 -122.48837346173 (37.7839735823988, -122.48837346173) 11 6 1 55 33
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
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
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
58698 254582 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 3239 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2018 12:00:00 AM 3 3x3   6001867 2119344 37.799419281227 -122.437654876352 (37.799419281227, -122.437654876352) 13 9 1 57 17
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
60445 251757 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 233 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001887 2086528 37.7093155646434 -122.43523714505 (37.7093155646434, -122.43523714505) 9 7 6 28861 5
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
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
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
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
73814 99874 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1301X San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/2011 12:00:00 AM 3 3x3 Permit Number 770597 6003616.3 2095455.7 37.7339271085192 -122.429896797189 (37.7339271085192, -122.429896797189) 2 7 5 28861 25
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
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
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
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
81653 109448 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 143 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/18/2015 12:00:00 AM 3 3x3 Permit Number 770854 6005451.2 2102876.8 37.7544075015735 -122.424080557223 (37.7544075015735, -122.424080557223) 2 4 5 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
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
89203 108393 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 321 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/2014 12:00:00 AM 3 3x3 Permit Number 772685 6006734.79675 2104244.32387 37.7582347949878 -122.419738566409 (37.7582347949878, -122.419738566409) 2 4 7 28859 19
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
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
94211 117589 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2698 VALLEJO ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000707 2117582 37.7945152706116 -122.441542364689 (37.7945152706116, -122.441542364689) 13 9 1 57 27
94441 89392 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1532 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/27/2018 11:13:00 AM 3 3x3   5993876.23543 2112127.34483 37.779146745751 -122.464781174904 (37.779146745751, -122.464781174904) 11 6 2 54 11
95414 160423 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 525 France Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 03:43:00 PM 3 Width 0ft   6002340.52441 2089668.33181 37.7179639695305 -122.433894007997 (37.7179639695305, -122.433894007997) 9 7 6 28861 5
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
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
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
109946 64806 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1375 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2012 12:00:00 AM 22 5x5 Permit Number 768180 6003293.30156995 2100236.74825313 37.747036468941 -122.43135467592 (37.747036468941, -122.43135467592) 2 7 5 63 22

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);