305 rows where qSpecies_id = 49

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)
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
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
54991 94248 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
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
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
60679 87807 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 291 28th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM 3 3x3 Permit Number 50584 5987096.8 2114028.5 37.7839735823988 -122.48837346173 (37.7839735823988, -122.48837346173) 11 6 1 55 33
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
69262 58794 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 2 Sidewalk: Curb side : Cutout Tree Private 2   09/17/1979 12:00:00 AM     Permit Number 18041 6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
69881 230397 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 635 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6010452.60466 2105203.30463 37.7610766734566 -122.406948295125 (37.7610766734566, -122.406948295125) 10 4 8 28859 19
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
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
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
74860 39178 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1050 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2015 12:00:00 AM 3 4x4 Permit Number 775243 6007589.88726975 2103539.15878969 37.7563467058962 -122.416731326975 (37.7563467058962, -122.416731326975) 2 4 7 28859 19
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
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
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
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
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
88404 100008 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501X Mission St 4 Sidewalk: Curb side : Pot Tree Private 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.7897060631976 -122.397547983339 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
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
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
93417 94253 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 12 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
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
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
100823 37947 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 255 Connecticut St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 8   Permit Number 40187 6013212.35398 2105880.56458 37.7630903220716 -122.39745094713 (37.7630903220716, -122.39745094713) 14 3 8 28856 29
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
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
103794 193429 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1151 22nd St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6014506.85634 2103858.18885 37.7576093076281 -122.392832172067 (37.7576093076281, -122.392832172067) 10 3 8 28856 29
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
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
104540 143848 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2900 Balboa St 10 Sidewalk: Curb side : Cutout Tree DPW 1   03/17/2018 12:00:00 AM 3 Width 4ft   5986608 2111175 37.7761101535306 -122.489854574072 (37.7761101535306, -122.489854574072) 11 6 2 55 26
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
106536 252993 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1201 Tennessee St 2 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
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
109916 230413 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 310 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2016 08:33:00 AM 1 Width 7ft   6004826.22566 2106515.98799 37.7643645463025 -122.426500991746 (37.7643645463025, -122.426500991746) 8 4 5 28859 3
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
109949 117154 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 701 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6014461.75742 2103731.13458 37.757257938912 -122.3929792544 (37.757257938912, -122.3929792544) 10 3 8 28856 29
111101 18346 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 447 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2006 12:00:00 AM 3 3x3   6010394.89315 2106204.37839 37.7638221660807 -122.407218464984 (37.7638221660807, -122.407218464984) 8 4 8 28859 19
113355 93239 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 600X Church St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004217.7 2105335.5 37.761088789181 -122.428521561971 (37.761088789181, -122.428521561971) 2 4 5 28862 3
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
115784 115265 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1634 22nd Ave 2 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
117782 230407 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 701 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010466.98 2104784.69833 37.7599280791473 -122.406869072951 (37.7599280791473, -122.406869072951) 10 4 8 28859 19
119888 117157 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 701 Pennsylvania Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014459.2864 2103784.30474 37.7574037954676 -122.39299152025 (37.7574037954676, -122.39299152025) 10 3 8 28856 29
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
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
120857 252995 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1201 Tennessee St 4 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
120990 18472 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1245 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/11/2015 07:25:00 AM 3 3X3   6010625.30786 2102050.90235 37.7524305418599 -122.406128887762 (37.7524305418599, -122.406128887762) 10 4 8 28859 19
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
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
122662 93247 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 990 Church St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/01/2008 12:00:00 AM 3 3x3   6004369 2103119 37.7550113653552 -122.427840341146 (37.7550113653552, -122.427840341146) 2 4 5 28862 22

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