305 rows where qSpecies_id = 49 sorted by qLegalStatus_id

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                        
666 49628 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1591 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2003 12:00:00 AM 3   Permit Number 46483 6007746.40275 2109230.16933 37.7719816997133 -122.416593168865 (37.7719816997133, -122.416593168865) 8 2 9 28853 19
979 171867 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 825 Woolsey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 Width 3ft   6009309.97305 2091452.93347 37.7232571551673 -122.409929483882 (37.7232571551673, -122.409929483882) 9 3 7 309 28
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
2615 193428 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1151 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6014491.22334 2103857.32403 37.7576060646987 -122.392886177259 (37.7576060646987, -122.392886177259) 10 3 8 28856 29
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
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
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
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
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
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
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                        
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
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
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
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
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
6816 46977 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1310 Minnesota St 8 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2002 12:00:00 AM 2   Permit Number 44998 6015323.66021 2102361.18474 37.7535441867291 -122.389902741142 (37.7535441867291, -122.389902741142) 10 3 8 28856 29
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
7487 18369 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 635 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/02/2016 12:00:00 AM 3 4X4   6010448.75923 2105261.1592 37.7612353138857 -122.406965672731 (37.7612353138857, -122.406965672731) 10 4 8 28859 19
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
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
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
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
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
12250 75673 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 618X Missouri St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     6013545.06469 2104202.26889 37.7585006086339 -122.396182576568 (37.7585006086339, -122.396182576568) 10 3 8 28856 29
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
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

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