trees

305 rows where qSpecies_id = 49 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH ▲ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
35901 94252 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 10 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
39923 94251 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 9 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
45351 94249 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 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
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
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
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
143815 94250 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2125 BRYANT ST 8 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009652 2104721 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892) 2 4 8 28859 19
155778 94256 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2777X 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6009684.4 2104752.7 37.7597963985886 -122.409573390285 (37.7597963985886, -122.409573390285) 2 4 8 28859 19
160551 193414 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 563 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6011255.16087 2105737.93689 37.762589530116 -122.40421021384 (37.762589530116, -122.40421021384) 8 3 8 28856 29
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
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
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
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
135804 101613 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 681 San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 9x7   6011003.32363 2105183.63205 37.7610534583629 -122.405042200948 (37.7610534583629, -122.405042200948) 10 3 8 28856 29
136965 101612 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 681 San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 7x5   6011003.08602 2105162.84205 37.7609963604006 -122.405041558844 (37.7609963604006, -122.405041558844) 10 3 8 28856 29
148064 117159 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 701 Pennsylvania Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014455.78719 2103822.04979 37.7575072408736 -122.393006262848 (37.7575072408736, -122.393006262848) 10 3 8 28856 29
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
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
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
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
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
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
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
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
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
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
128026 35331 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2222 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/23/1998 12:00:00 AM 7   Permit Number 38797 6011102.74031 2105580.11017 37.7621476554073 -122.404726272704 (37.7621476554073, -122.404726272704) 8 3 8 28856 29
164163 193418 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 610 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6015955.04058 2106161.79394 37.7640148449206 -122.387984462917 (37.7640148449206, -122.387984462917) 14 3 8 28856 29
175595 117160 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 701 Pennsylvania Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6014455.03317 2103837.45298 37.7575494928317 -122.393009948265 (37.7575494928317, -122.393009948265) 10 3 8 28856 29
184363 117158 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 701 Pennsylvania Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6014455.94065 2103803.29799 37.7574557609929 -122.393004420141 (37.7574557609929, -122.393004420141) 10 3 8 28856 29
186428 193423 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 501 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6015877.90137 2105798.99134 37.7630143932264 -122.388225945268 (37.7630143932264, -122.388225945268) 14 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
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
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
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
91411 230405 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 701 Potrero Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6010473.72719 2104680.02328 37.7596410425128 -122.406838360202 (37.7596410425128, -122.406838360202) 10 4 8 28859 19
91708 193434 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 598 Missouri St 3 : Tree Private 2     6 Width 3ft   6013537.98707 2104307.61874 37.7587894825673 -122.396214437761 (37.7587894825673, -122.396214437761) 10 3 8 28856 29
94176 193427 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1151 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6014474.19771 2103855.91322 37.7576012452178 -122.392944960565 (37.7576012452178, -122.392944960565) 10 3 8 28856 29
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
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
141793 94257 Undocumented 4 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2777X 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6009684.4 2104752.7 37.7597963985886 -122.409573390285 (37.7597963985886, -122.409573390285) 2 4 8 28859 19
175505 193417 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1425 Indiana St 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6015126.28801 2101884.04231 37.7522231069197 -122.390551964402 (37.7522231069197, -122.390551964402) 10 3 8 28856 1
180617 101611 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 681 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   6011008.34199 2105144.37638 37.7609459516243 -122.40502208042 (37.7609459516243, -122.40502208042) 10 3 8 28856 29
192615 37946 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 255 Connecticut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM 6   Permit Number 40187 6013211.43951 2105863.92108 37.7630445717758 -122.397452942701 (37.7630445717758, -122.397452942701) 14 3 8 28856 29
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
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
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
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
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
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
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
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
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
132776 193436 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 608 Missouri St 3 : Tree Private 2     5 Width 3ft   6013540.38062 2104266.7592 37.7586774243529 -122.396203296069 (37.7586774243529, -122.396203296069) 10 3 8 28856 29
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
143820 46415 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 700 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2002 12:00:00 AM 5 3x3 Permit Number 44641 6015975.28241 2105780.03754 37.7629677453768 -122.3878878119 (37.7629677453768, -122.3878878119) 10 3 8 28856 29
144366 123782 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1100 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992174.17281 2110703.76964 37.7751397174253 -122.470565540203 (37.7751397174253, -122.470565540203) 11 6 2 54 11
154077 123781 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1100 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5992148.27248 2110704.3151 37.7751397174227 -122.47065517412 (37.7751397174227, -122.47065517412) 11 6 2 54 11
166488 193413 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2200 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6011171.17043 2105584.01117 37.7621621911485 -122.404489872412 (37.7621621911485, -122.404489872412) 8 3 8 28856 29
167252 193415 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1425 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6015129.4675 2101818.79874 37.7520441382513 -122.390536410622 (37.7520441382513, -122.390536410622) 10 3 8 28856 1
181160 18460 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 1146 Potrero Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/2006 12:00:00 AM 5 3X3   6010512.14548 2102543.99159 37.753778125574 -122.406554967641 (37.753778125574, -122.406554967641) 10 4 7 28859 19
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
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
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
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
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
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
128424 230404 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 995 Potrero Ave 14 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6010493.00859 2104414.71875 37.7589136546545 -122.406752977672 (37.7589136546545, -122.406752977672) 10 4 8 28859 19
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
136380 230403 DPW Maintained 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 995 Potrero Ave 10 : Tree Private 2     4 Width 2ft   6010508.06667 2104211.71419 37.7583570921231 -122.406686593337 (37.7583570921231, -122.406686593337) 10 4 8 28859 19
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
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
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
3337 261748 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 16 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
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
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
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
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
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
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
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
10331 128078 Permitted Site 7 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 245 North Point St 11 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:25:00 PM 3 Width 4ft   6009589.18536 2121879.68336 37.8068176775527 -122.411112486276 (37.8068176775527, -122.411112486276) 3 1 10 308 23
11461 261747 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 15 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29
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
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
15024 261746 Section 806 (d) 5 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 540 De Haro St 14 Sidewalk: Curb side : Yard Tree Private 2   02/25/2020 12:00:00 AM 3   Permit Number 774839 6012051.5879 2105883.7172 37.7630342801454 -122.401465890035 (37.7630342801454, -122.401465890035) 8 3 8 28856 29

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