Street_Tree_List

Data source: data.sfgov.org

131 rows where qLegalStatus = 2 and qSpecies = 73

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1830 251757 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 233 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001887.0 2086528.0 37.7093155646434 -122.43523714505 (37.7093155646434, -122.43523714505)
1839 251756 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 233 Winding Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001887.0 2086528.0 37.7093155646434 -122.43523714505 (37.7093155646434, -122.43523714505)
3405 180669 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 171 Winding Way 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 6ft   6002170.184219999 2086635.71157 37.70962739445179 -122.434266111507 (37.7096273944518, -122.434266111507)
3413 180646 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 451 Rolph St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 6ft   6002230.18825 2087673.61332 37.7124806510226 -122.434132874236 (37.7124806510226, -122.434132874236)
3430 180648 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     0 Width 6ft   6001751.26715 2087361.8508 37.7115974268507 -122.435765878508 (37.7115974268507, -122.435765878508)
3920 216755 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 115 Harold Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/04/2017 01:38:00 PM 3 Width 3ft   5996789.877280001 2090654.02957 37.720353912480995 -122.453151180205 (37.720353912481, -122.453151180205)
3925 216756 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 106 Harold Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 01:41:00 PM 3 Width 3ft   5996820.43291 2090638.75117 37.7203137127762 -122.45304445763 (37.7203137127762, -122.45304445763)
3944 251758 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 241 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 10:31:00 AM 3 3x3   6001856.0 2086522.0 37.7092973294849 -122.435343856961 (37.7092973294849, -122.435343856961)
4131 216653 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 307 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 08:20:00 AM 3 Width 1ft   5994722.80826 2090636.9515099998 37.720188332898395 -122.46029507616001 (37.7201883328984, -122.46029507616)
4134 216704 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 251 Faxon Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 08:35:00 AM 3 Width 2ft   5994715.27121 2090263.18688 37.719161630891705 -122.46029406262699 (37.7191616308917, -122.460294062627)
4139 216702 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 251 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/06/2017 08:30:00 AM 3 Width 2ft   5994715.94794 2090284.8464099998 37.7192211417229 -122.46029329191299 (37.7192211417229, -122.460293291913)
4150 216749 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 26 Granada Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/06/2017 08:25:00 AM 3 Width 3ft   5995639.9781599995 2090086.85434 37.7187306119189 -122.45708497580699 (37.7187306119189, -122.457084975807)
4205 251774 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 10:14:00 AM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4279 78830 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 35 Laura St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/2017 04:01:00 PM 3     5997431.0713 2086896.39523 37.7100730444948 -122.450664016958 (37.7100730444948, -122.450664016958)
4296 251775 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/10/2017 10:17:00 AM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4335 251736 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 8 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 11:28:00 AM 3 3x3   6002228.0 2087184.0 37.711136156016295 -122.434105459048 (37.7111361560163, -122.434105459048)
4350 178825 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 927 Brazil Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 09:33:00 AM 3 Width 3ft   6004370.89542 2090731.88415 37.7209992632754 -122.42695160693998 (37.7209992632754, -122.42695160694)
4368 251755 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 101X Drake St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 11:50:00 AM 3 3x3   6001862.0 2086566.0 37.709418484595 -122.43532626528601 (37.709418484595, -122.435326265286)
4405 251754 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 101X Drake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/11/2017 11:47:00 AM 3 3x3   6001862.0 2086566.0 37.709418484595 -122.43532626528601 (37.709418484595, -122.435326265286)
4484 251776 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 120 Seville St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   10/13/2017 12:12:00 PM 3 Width 6ft   6001722.65495 2087355.7886599998 37.711579156239296 -122.435864336264 (37.7115791562393, -122.435864336264)
4632 160422 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 591 France Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 03:59:00 PM 3 Width 0ft   6002364.11048 2089653.5699900002 37.7179247752893 -122.43381142685 (37.7179247752893, -122.43381142685)
4680 160421 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 591 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 04:04:00 PM 3 Width 0ft   6002387.355359999 2089638.81491 37.7178855801363 -122.433730025613 (37.7178855801363, -122.433730025613)
4681 160510 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 706 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/2017 03:18:00 PM 3 Width 0ft   6001927.69711 2089831.3140900002 37.7183880466434 -122.435332621096 (37.7183880466434, -122.435332621096)
4722 160433 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 401 France Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/24/2017 12:12:00 PM 3 Width 0ft   6002070.28716 2089835.8834 37.7184086896908 -122.43484007413 (37.7184086896908, -122.43484007413)
4803 160423 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 525 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/25/2017 03:43:00 PM 3 Width 0ft   6002340.52441 2089668.33181 37.7179639695305 -122.433894007997 (37.7179639695305, -122.433894007997)
4838 243005 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 301 Dolores St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 6ft   6004912.59389 2106510.6516400003 37.7643547760633 -122.42620188801001 (37.7643547760633, -122.42620188801)
25091 230419 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1301 San Jose Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6003538.9746900005 2095464.77113 37.733947636477396 -122.430164781185 (37.7339476364774, -122.430164781185)
26296 193431 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 568 Missouri St 1 : 4 Tree 1 Private 1     6 Width 3ft   6013531.88693 2104447.0848 37.7591720865425 -122.39624530967801 (37.7591720865425, -122.396245309678)
26639 117155 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Pennsylvania Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6014460.76675 2103748.99279 37.757306918684 -122.392983929988 (37.757306918684, -122.392983929988)
26689 193419 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 610 Illinois St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6015956.40459 2106139.49843 37.763953701820604 -122.387978189259 (37.7639537018206, -122.387978189259)
30004 193411 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 681 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6011009.79725 2105127.16685 37.7608987794618 -122.40501583552 (37.7608987794618, -122.40501583552)
31334 230397 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 635 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6010452.60466 2105203.30463 37.7610766734566 -122.406948295125 (37.7610766734566, -122.406948295125)
31798 193424 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 501 18th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6015930.41591 2105802.18595 37.7630260745267 -122.38804453674801 (37.7630260745267, -122.388044536748)
34840 230415 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1301 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003663.13723 2095538.7313 37.7341577459882 -122.429740786804 (37.7341577459882, -122.429740786804)
35864 202028 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1330 Fitzgerald Ave 10 : 4 Tree 1 Private 1     3 Width 3ft   6013610.79633 2091351.15014 37.723217781063205 -122.395055126189 (37.7232177810632, -122.395055126189)
36116 75673 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 618X Missouri St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/1996 12:00:00 AM 7     6013545.06469 2104202.26889 37.7585006086339 -122.396182576568 (37.7585006086339, -122.396182576568)
36283 193430 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 560 Missouri St 4 : 4 Tree 1 Private 1     5 Width 3ft   6013531.28257 2104470.6669900003 37.7592368044652 -122.396249052661 (37.7592368044652, -122.396249052661)
36596 117159 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Pennsylvania Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 3x3   6014455.7871900005 2103822.04979 37.7575072408736 -122.39300626284799 (37.7575072408736, -122.393006262848)
37325 193426 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 807 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6015414.46793 2103902.8500099997 37.7577823075377 -122.389696374594 (37.7577823075377, -122.389696374594)
37611 230424 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 387 Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6007831.12637 2105698.0394200003 37.76228806116921 -122.41604991899099 (37.7622880611692, -122.416049918991)
39159 208859 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 157 Thrift St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5995398.10832 2089609.6071400002 37.7174063107347 -122.45788650015699 (37.7174063107347, -122.457886500157)
40746 193433 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 588 Missouri St 1 : 4 Tree 1 Private 1     7 Width 3ft   6013536.39974 2104342.74788 37.758885851209 -122.396222389564 (37.758885851209, -122.396222389564)
41687 230410 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Potrero Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6010454.77139 2105010.4435799997 37.7605472416892 -122.406927207828 (37.7605472416892, -122.406927207828)
43230 81651 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1100@ 12th Ave Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   6   Permit Number 767881 5992197.33713 2110704.35062 37.7751426520596 -122.470485452724 (37.7751426520596, -122.470485452724)
44441 230406 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Potrero Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6010469.85138 2104738.84531 37.7598023377254 -122.406855910494 (37.7598023377254, -122.406855910494)
44609 193420 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 501 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6015798.54633 2105794.6845 37.76299817034379 -122.38850010901001 (37.7629981703438, -122.38850010901)
45892 230421 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2851 19th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6009338.5093 2104971.08738 37.76037665287679 -122.41078508446002 (37.7603766528768, -122.41078508446)
46903 193418 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 610 Illinois St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6015955.040580001 2106161.7939400002 37.7640148449206 -122.387984462917 (37.7640148449206, -122.387984462917)
47570 117158 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Pennsylvania Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6014455.94065 2103803.2979900003 37.7574557609929 -122.393004420141 (37.7574557609929, -122.393004420141)
48188 117156 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Pennsylvania Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6014458.776219999 2103767.54398 37.7573577456892 -122.392992112005 (37.7573577456892, -122.392992112005)
49040 230420 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 143 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6005428.8647300005 2102882.34915 37.7544214771723 -122.424158193041 (37.7544214771723, -122.424158193041)
50998 202024 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1330 Fitzgerald Ave 6 : 4 Tree 1 Private 1     3 Width 3ft   6013681.0358 2091298.8599 37.7230781082384 -122.394808659817 (37.7230781082384, -122.394808659817)
53201 230399 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 635 Potrero Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6010446.039030001 2105294.43136 37.761326519519 -122.406977425991 (37.761326519519, -122.406977425991)
54038 202020 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1330 Fitzgerald Ave 2 : 4 Tree 1 Private 1     3 Width 3ft   6013858.20959 2091166.1399 37.7227235352339 -122.39418691350599 (37.7227235352339, -122.394186913506)
54459 193427 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1151 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6014474.19771 2103855.91322 37.75760124521779 -122.39294496056499 (37.7576012452178, -122.392944960565)
55809 123781 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1100 Cabrillo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992148.272480001 2110704.3151 37.775139717422704 -122.47065517411998 (37.7751397174227, -122.47065517412)
57863 230414 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1295 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003749.35106 2095592.3419599999 37.7343098303216 -122.429446540326 (37.7343098303216, -122.429446540326)
57871 193417 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1425 Indiana St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6015126.28801 2101884.04231 37.7522231069197 -122.39055196440201 (37.7522231069197, -122.390551964402)
58037 193432 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 572 Missouri St 2 : 4 Tree 1 Private 1     6 Width 3ft   6013532.897999999 2104416.8953299997 37.759089249099105 -122.39623969701401 (37.7590892490991, -122.396239697014)
58293 193413 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2200 18th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6011171.17043 2105584.0111700003 37.7621621911485 -122.404489872412 (37.7621621911485, -122.404489872412)
58655 202021 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1330 Fitzgerald Ave 3 : 4 Tree 1 Private 1     4 Width 3ft   6013834.37055 2091185.2446599999 37.722774667999 -122.39427065747101 (37.722774667999, -122.394270657471)
60282 193428 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1151 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6014491.22334 2103857.32403 37.7576060646987 -122.392886177259 (37.7576060646987, -122.392886177259)
61175 117154 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Pennsylvania Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6014461.75742 2103731.13458 37.757257938912 -122.3929792544 (37.757257938912, -122.3929792544)
61392 230407 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Potrero Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6010466.98 2104784.69833 37.75992807914729 -122.406869072951 (37.7599280791473, -122.406869072951)
61446 230417 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1301 San Jose Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003609.08364 2095506.47935 37.7340661284367 -122.42992536726801 (37.7340661284367, -122.429925367268)
61485 230422 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 387 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007833.76172 2105654.7259299997 37.7621692805159 -122.41603773676901 (37.7621692805159, -122.416037736769)
63056 193414 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 563 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6011255.16087 2105737.93689 37.762589530116 -122.40421021383999 (37.762589530116, -122.40421021384)
63152 177453 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1651 San Jose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6001481.52618 2094146.78927 37.7302120154671 -122.437183661494 (37.7302120154671, -122.437183661494)
63489 177454 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1651 San Jose Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6001501.639719999 2094151.35591 37.730225697742796 -122.43711445328998 (37.7302256977428, -122.43711445329)
67572 123782 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1100 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5992174.172809999 2110703.76964 37.7751397174253 -122.470565540203 (37.7751397174253, -122.470565540203)
67791 230398 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 625 Potrero Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6010441.3524 2105364.41642 37.761518420453896 -122.40699856812901 (37.7615184204539, -122.406998568129)
68017 208858 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 438 Capitol Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5995058.10493 2088636.3102900002 37.7147143277695 -122.458991293911 (37.7147143277695, -122.458991293911)
69513 202022 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1330 Fitzgerald Ave 4 : 4 Tree 1 Private 1     3 Width 3ft   6013717.54523 2091271.8320400002 37.723005925068605 -122.39468056126199 (37.7230059250686, -122.394680561262)
70356 193410 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 551 Utah St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6010705.60274 2105553.4377099997 37.762052213957794 -122.40609794748501 (37.7620522139578, -122.406097947485)
70771 193438 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 170 Scotia Ave 1 : 4 Tree 1 Private 1     1 Width 3ft   6012250.26105 2094642.5839099998 37.7321796295918 -122.39998929257601 (37.7321796295918, -122.399989292576)
71026 230404 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 995 Potrero Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6010493.00859 2104414.71875 37.7589136546545 -122.406752977672 (37.7589136546545, -122.406752977672)
74087 230423 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 387 Shotwell St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6007832.95914 2105672.86461 37.7622190400112 -122.416041797198 (37.7622190400112, -122.416041797198)
74732 117153 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6014462.23102 2103712.78244 37.757207574192 -122.392976332502 (37.757207574192, -122.392976332502)
75391 230416 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1301 San Jose Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003629.87373 2095518.0627099997 37.734099111076496 -122.429854315422 (37.7340991110765, -122.429854315422)
76703 230409 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Potrero Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6010459.52552 2104963.6053 37.7604189003367 -122.406907464126 (37.7604189003367, -122.406907464126)
77661 94252 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2125 BRYANT ST 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
80296 94248 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2125 BRYANT ST 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
80407 94251 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2125 BRYANT ST 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
83236 94249 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2125 BRYANT ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
83678 99998 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 501X Mission St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013420.0 2115433.0 37.7893307029327 -122.397402707509 (37.7893307029327, -122.397402707509)
93824 117589 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2698 VALLEJO ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000707.0 2117582.0 37.7945152706116 -122.44154236468901 (37.7945152706116, -122.441542364689)
94785 100008 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 501X Mission St 4 Sidewalk: Curb side : Pot 10 Tree 1 Private 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339)
96459 94253 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2125 BRYANT ST 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
101374 106758 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 445 Grafton Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/02/2014 12:00:00 AM     Permit Number 772911 5995409.1 2090523.2 37.7199154518997 -122.457914582927 (37.7199154518997, -122.457914582927)
112590 104967 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 143-147 FAIR OAKS ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 3x3 Permit Number 770854 6005451.2 2102876.8 37.7544075015735 -122.424080557223 (37.7544075015735, -122.424080557223)
116382 94250 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2125 BRYANT ST 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6009652.0 2104721.0 37.7597075419954 -122.40968320892 (37.7597075419954, -122.40968320892)
116397 94257 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2777X 19th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
119799 94256 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 2777X 19th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 3x3   6009684.4 2104752.7 37.7597963985886 -122.40957339028499 (37.7597963985886, -122.409573390285)
124691 100003 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 501X Mission St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339)
128958 100007 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 501X Mission St 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339)
130484 193429 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1151 22nd St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6014506.85634 2103858.18885 37.7576093076281 -122.39283217206699 (37.7576093076281, -122.392832172067)
135447 193437 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 420 Bay Shore Blvd 1 : 4 Tree 1 Private 1     4 Width 3ft   6010286.5563 2097785.62722 37.7407000755616 -122.40699974536501 (37.7407000755616, -122.406999745365)
136176 117160 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 701 Pennsylvania Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6014455.03317 2103837.45298 37.7575494928317 -122.393009948265 (37.7575494928317, -122.393009948265)
137569 177457 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 1651 San Jose Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6001558.284440001 2094165.3004599998 37.730267205960295 -122.436919623235 (37.7302672059603, -122.436919623235)
138541 230402 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 995 Potrero Ave 3 : 4 Tree 1 Private 1     7 Width 4ft   6010527.0507 2103856.48907 37.7573827855076 -122.406595905697 (37.7573827855076, -122.406595905697)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 2842.033ms · Data source: data.sfgov.org