305 rows where qSpecies_id = 49 sorted by YCoord

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)
102 258152 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3                        
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                        
125437 251758 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 241 Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2017 10:31:00 AM 3 3x3   6001856 2086522 37.7092973294849 -122.435343856961 (37.7092973294849, -122.435343856961) 9 7 6 28861 5
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
107920 251756 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 233 Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001887 2086528 37.7093155646434 -122.43523714505 (37.7093155646434, -122.43523714505) 9 7 6 28861 5
127114 251755 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 201X Winding Way 2 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 11:50:00 AM 3 3x3   6002020 2086565 37.7094247104414 -122.434780120464 (37.7094247104414, -122.434780120464) 9 7 6 28861 5
136360 251754 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 201X Winding Way 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/2017 12:00:00 AM 3 3x3   6002020 2086565 37.7094247104414 -122.434780120464 (37.7094247104414, -122.434780120464) 9 7 6 28861 5
24902 180669 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 171 Winding Way 3 Sidewalk: Curb side : Yard Tree Private 2     0 Width 6ft   6002170.18422 2086635.71157 37.7096273944518 -122.434266111507 (37.7096273944518, -122.434266111507) 9 7 6 28861 5
169178 78830 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 35 Laura St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/10/2017 04:01:00 PM 3     5997431.0713 2086896.39523 37.7100730444948 -122.450664016958 (37.7100730444948, -122.450664016958) 9 7 6 28861 25
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
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
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
148422 251775 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 120 Seville St 4 Sidewalk: Curb side : Yard Tree Private 2   10/10/2017 10:17:00 AM 3 Width 6ft   6001722.65495 2087355.78866 37.7115791562393 -122.435864336264 (37.7115791562393, -122.435864336264) 9 7 6 28861 5
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
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
113466 208858 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 438 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   5995058.10493 2088636.31029 37.7147143277695 -122.458991293911 (37.7147143277695, -122.458991293911) 9 8 6 28861 24
175364 115252 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 438 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM     Permit Number 772344 5995084 2088641.7 37.7147306151804 -122.458902180491 (37.7147306151804, -122.458902180491) 9 8 6 28861 24
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
192201 84013 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 207 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2016 12:00:00 AM   3x3 Permit Number 771913 5997093.91103174 2089409.10522836 37.7169530610701 -122.452010468882 (37.7169530610701, -122.452010468882) 9 8 6 28861 24
139355 114987 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 157 Thrift St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2015 12:00:00 AM     Permit Number 775985 5995400.7 2089591.3 37.7173561925503 -122.457876217939 (37.7173561925503, -122.457876217939) 9 8 6 28861 24
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
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
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
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
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
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
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
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
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
2698 216704 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 251 Faxon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2017 08:35:00 AM 3 Width 2ft   5994715.27121 2090263.18688 37.7191616308917 -122.460294062627 (37.7191616308917, -122.460294062627) 9 8 6 28861 24
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
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
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
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
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
124156 216755 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 115 Harold Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/04/2017 01:38:00 PM 3 Width 3ft   5996789.87728 2090654.02957 37.720353912481 -122.453151180205 (37.720353912481, -122.453151180205) 9 8 6 28861 24
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
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
194397 160660 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 118 Russia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/2017 12:00:00 AM 3 Width 0ft   6001728.7088 2090784.69907 37.7209945256629 -122.436088625395 (37.7209945256629, -122.436088625395) 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
146568 202019 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1350 Fitzgerald Ave 1 : Tree Private 2     3 Width 3ft   6013890.08621 2091145.17982 37.7226677548035 -122.394075255469 (37.7226677548035, -122.394075255469) 10 3 8 58 1
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
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
102453 202021 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1330 Fitzgerald Ave 3 : Tree Private 2     4 Width 3ft   6013834.37055 2091185.24466 37.722774667999 -122.394270657471 (37.722774667999, -122.394270657471) 10 3 8 58 1
179385 202022 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1330 Fitzgerald Ave 4 : Tree Private 2     3 Width 3ft   6013717.54523 2091271.83204 37.7230059250686 -122.394680561262 (37.7230059250686, -122.394680561262) 10 3 8 58 1
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
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
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
145383 202026 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1330 Fitzgerald Ave 8 : Tree Private 2     3 Width 3ft   6013645.7458 2091325.32173 37.7231488048702 -122.394932503635 (37.7231488048702, -122.394932503635) 10 3 8 58 1
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
139187 202028 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1330 Fitzgerald Ave 10 : Tree Private 2     3 Width 3ft   6013610.79633 2091351.15014 37.7232177810632 -122.395055126189 (37.7232177810632, -122.395055126189) 10 3 8 58 1
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
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
129187 94327 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1132 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/15/2010 12:00:00 AM   3x3 Permit Number 53627 5995101.4 2091446 37.7224315574184 -122.459044970295 (37.7224315574184, -122.459044970295) 9 8 4 28861 24
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
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
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
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
194377 171274 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 134 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2017 12:00:00 AM 3 Width 3ft   6004391.75762 2092740.75057 37.726516347746 -122.427022498699 (37.726516347746, -122.427022498699) 9 7 6 28861 5
136676 43256 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 400 Burrows St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 07/12/2000 12:00:00 AM 5   Permit Number 43041 6010098.35132 2093185.30376 37.7280580348411 -122.407326264919 (37.7280580348411, -122.407326264919) 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
3712 171727 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1151 Silliman St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   0 4x5   6007391.28997 2093272.37114 37.7281452205055 -122.416690852302 (37.7281452205055, -122.416690852302) 9 3 7 309 5
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
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
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
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
181396 172046 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 255 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 2ft   6009960.33149 2094057.74194 37.730445840099 -122.407864901243 (37.730445840099, -122.407864901243) 10 3 7 309 28
8578 258179 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 255 Silliman St 5 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3 4x5   6010040.21914 2094084.80619 37.7305246249549 -122.4075906244 (37.7305246249549, -122.4075906244) 10 3 7 309 28
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
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
124024 177454 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1651 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6001501.63972 2094151.35591 37.7302256977428 -122.43711445329 (37.7302256977428, -122.43711445329) 9 7 6 28861 25
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
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
120121 177457 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1651 San Jose Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6001558.28444 2094165.30046 37.7302672059603 -122.436919623235 (37.7302672059603, -122.436919623235) 9 7 6 28861 25
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
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
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
134923 230418 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1301 San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003572.46167 2095485.43499 37.7340062713591 -122.430050480067 (37.7340062713591, -122.430050480067) 2 7 5 28861 25
188741 230417 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1301 San Jose Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003609.08364 2095506.47935 37.7340661284367 -122.429925367268 (37.7340661284367, -122.429925367268) 2 7 5 28861 25
172302 230416 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1301 San Jose Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003629.87373 2095518.06271 37.7340991110765 -122.429854315422 (37.7340991110765, -122.429854315422) 2 7 5 28861 25
120530 230415 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1301 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003663.13723 2095538.7313 37.7341577459882 -122.429740786804 (37.7341577459882, -122.429740786804) 2 7 5 28861 25
187792 230414 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1295 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003749.35106 2095592.34196 37.7343098303216 -122.429446540326 (37.7343098303216, -122.429446540326) 2 7 5 28861 25
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
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
191716 56557 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 27 Ardenwood Way 1 Sidewalk: Curb side : Cutout Tree Private 2   04/09/2010 12:00:00 AM     Permit Number 53358 5991301.89931547 2096270.47961182 37.7354592201324 -122.472530401662 (37.7354592201324, -122.472530401662) 1 8 4 29491 40
121448 115375 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 230 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 776301 6007067.3 2096865.5 37.7379929380378 -122.418065521541 (37.7379929380378, -122.418065521541) 2 7 7 28859 2
164144 6738 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1300X Fairfax Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1   08/19/2016 12:00:00 AM 1 3x3   6016982.91603 2097217.69187 37.7395130873532 -122.383806518479 (37.7395130873532, -122.383806518479) 10 3 8 58 1
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
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
186140 193437 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 420 Bay Shore Blvd 1 : Tree Private 2     4 Width 3ft   6010286.5563 2097785.62722 37.7407000755616 -122.406999745365 (37.7407000755616, -122.406999745365) 10 3 7 58 2
38581 29817 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1695X Evans Ave 14 Sidewalk: Curb side : Cutout Tree Purchasing Dept 18   09/11/2006 12:00:00 AM 3 4x4   6015152.5117442 2098858.5096741 37.7439170824372 -122.390249918369 (37.7439170824372, -122.390249918369) 10 3 8 58 1
104688 117301 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2238 34th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778520 5985801.3 2099978.9 37.7453216318219 -122.491820695636 (37.7453216318219, -122.491820695636) 1 8 3 29491 35
151715 117300 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2238 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 778520 5985801.3 2099978.9 37.7453216318219 -122.491820695636 (37.7453216318219, -122.491820695636) 1 8 3 29491 35
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
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
11787 149766 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1100 Cesar Chavez St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6015500.66268 2101160.05686 37.7502559568697 -122.389206758507 (37.7502559568697, -122.389206758507) 10 3 8 28856 1

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