Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39359 | 39359 | 192974 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012869.163480001 | 2105974.38729 | 37.763328824083295 | -122.39864451922399 | (37.7633288240833, -122.398644519224) | |||
| 41430 | 41430 | 192969 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012874.930240001 | 2105836.14542 | 37.7629495637933 | -122.398614872189 | (37.7629495637933, -122.398614872189) | |||
| 50700 | 50700 | 192970 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012874.88445 | 2105863.7088900004 | 37.763025244431894 | -122.398616964909 | (37.7630252444319, -122.398616964909) | |||
| 65989 | 65989 | 192965 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012881.021480001 | 2105727.71881 | 37.7626521876609 | -122.39858619552 | (37.7626521876609, -122.39858619552) | |||
| 74696 | 74696 | 192973 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012869.52448 | 2105946.64842 | 37.7632526794011 | -122.39864132394301 | (37.7632526794011, -122.398641323943) | |||
| 148329 | 148329 | 192967 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012878.79115 | 2105782.39393 | 37.7628021891935 | -122.398597746415 | (37.7628021891935, -122.398597746415) | |||
| 155889 | 155889 | 187486 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Width 9ft | 6006768.10436 | 2086582.6135 | 37.7097415013489 | -122.41837109707 | (37.7097415013489, -122.41837109707) | |||
| 155898 | 155898 | 192971 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012871.7630900005 | 2105891.87126 | 37.7631023981666 | -122.398629737092 | (37.7631023981666, -122.398629737092) | |||
| 157169 | 157169 | 187487 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 9ft | 6006739.4924099995 | 2086592.2880099998 | 37.709766454838096 | -122.418470670891 | (37.7097664548381, -122.418470670891) | |||
| 157488 | 157488 | 192968 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012876.85912 | 2105807.00697 | 37.762869663519 | -122.39860615594999 | (37.762869663519, -122.39860615595) | |||
| 160221 | 160221 | 130561 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 49 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 9ft | 5997335.31934 | 2114155.38722 | 37.784914038893206 | -122.452961280243 | (37.7849140388932, -122.452961280243) | |||
| 173442 | 173442 | 192966 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012878.7192 | 2105754.24297 | 37.7627248888745 | -122.398596019716 | (37.7627248888745, -122.398596019716) | |||
| 173643 | 173643 | 187485 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 700 Velasco Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 9ft | 6006777.87289 | 2086579.02758 | 37.7097322050565 | -122.41833708111 | (37.7097322050565, -122.41833708111) | |||
| 175987 | 175987 | 192972 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 200 Arkansas St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 9ft | 6012871.07375 | 2105918.34501 | 37.7631750508186 | -122.398633979195 | (37.7631750508186, -122.398633979195) | |||
| 29673 | 29673 | 230829 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 395 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 8ft | 6002328.3904099995 | 2106056.86365 | 37.7629623809248 | -122.435107455139 | (37.7629623809248, -122.435107455139) | |||
| 33276 | 33276 | 229302 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 184 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 8ft | 6005349.96021 | 2100227.3557700003 | 37.7471270229956 | -122.424242250879 | (37.7471270229956, -122.424242250879) | |||
| 41894 | 41894 | 177321 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1222 Naples St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 8ft | 6001045.82775 | 2087348.99146 | 37.71152202140421 | -122.438203139287 | (37.7115220214042, -122.438203139287) | |||
| 50949 | 50949 | 229269 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 38 Dolores St | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 8ft | 6004746.92065 | 2107892.75948 | 37.768140347222705 | -122.426873344349 | (37.7681403472227, -122.426873344349) | |||
| 70044 | 70044 | 230830 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 395 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 8ft | 6002327.0593 | 2106068.10128 | 37.7629931611385 | -122.435112862775 | (37.7629931611385, -122.435112862775) | |||
| 72174 | 72174 | 123511 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2730 Fulton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 8ft | 5994887.666180001 | 2110258.17365 | 37.774072759511796 | -122.461146723311 | (37.7740727595118, -122.461146723311) | |||
| 152043 | 152043 | 177357 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 301 Naglee Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 5997754.17366 | 2088444.4959099998 | 37.7143422638536 | -122.449658800639 | (37.7143422638536, -122.449658800639) | |||
| 153784 | 153784 | 249605 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2250 Golden Gate Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5998732.40134 | 2111478.3971700002 | 37.7776436838383 | -122.447935044877 | (37.7776436838383, -122.447935044877) | |||
| 164010 | 164010 | 230277 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 541 30th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6003113.15131 | 2098299.5142900003 | 37.7417070635275 | -122.431839319727 | (37.7417070635275, -122.431839319727) | |||
| 170942 | 170942 | 123508 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2636 Fulton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 5995184.59018 | 2110299.27472 | 37.774202694939106 | -122.460122597182 | (37.7742026949391, -122.460122597182) | |||
| 179827 | 179827 | 229732 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2749 Harrison St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6008964.54646 | 2102425.0161099997 | 37.753364742305706 | -122.41189853150101 | (37.7533647423057, -122.411898531501) | |||
| 183399 | 183399 | 230831 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 395 Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 8ft | 6002324.49364 | 2106095.2451299997 | 37.763067545860295 | -122.43512367802299 | (37.7630675458603, -122.435123678023) | |||
| 75964 | 75964 | 229301 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 7ft | 6004947.77286 | 2104335.41432 | 37.75838407807579 | -122.42592536178002 | (37.7583840780758, -122.42592536178) | |||
| 133593 | 133593 | 193111 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1780 Revere Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 7ft | 6014171.61881 | 2095122.7251400002 | 37.7336049345015 | -122.393380266612 | (37.7336049345015, -122.393380266612) | |||
| 169231 | 169231 | 229432 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 711 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 7ft | 6010163.53357 | 2104857.90652 | 37.760112108299396 | -122.407923714234 | (37.7601121082994, -122.407923714234) | |||
| 1857 | 1857 | 251765 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1870 | 1870 | 251767 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 1871 | 1871 | 176854 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | |||
| 1876 | 1876 | 251766 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 23 Seville St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Width 6ft | 6001915.0 | 2087651.0 | 37.7124006661461 | -122.435220643728 | (37.7124006661461, -122.435220643728) | ||||
| 23488 | 23488 | 124575 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3919 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5996005.35243 | 2115512.6392900003 | 37.7885643822995 | -122.457660747982 | (37.7885643822995, -122.457660747982) | |||
| 24729 | 24729 | 229359 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2955 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6009751.98039 | 2101009.98323 | 37.7495235220061 | -122.409075570392 | (37.7495235220061, -122.409075570392) | |||
| 24991 | 24991 | 123451 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 741 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 6ft | 5995333.7181 | 2110563.3374099997 | 37.774936317755206 | -122.45962587016899 | (37.7749363177552, -122.459625870169) | |||
| 28674 | 28674 | 229468 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1488 Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 6ft | 6005201.1456699995 | 2099708.91385 | 37.74569509635221 | -122.42471996447901 | (37.7456950963522, -122.424719964479) | |||
| 28675 | 28675 | 208635 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 469 Pacheco St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993695.70853 | 2101832.2366299997 | 37.7508686712517 | -122.464657906832 | (37.7508686712517, -122.464657906832) | |||
| 30962 | 30962 | 229293 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6004930.67222 | 2104696.88853 | 37.7593756346006 | -122.42601023528 | (37.7593756346006, -122.42601023528) | |||
| 30991 | 30991 | 130585 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2899 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6000543.26827 | 2118160.0514700003 | 37.7960931182463 | -122.442150409436 | (37.7960931182463, -122.442150409436) | |||
| 31171 | 31171 | 229300 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 29 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 6ft | 6004946.7397 | 2104361.09729 | 37.7584545390754 | -122.425930763098 | (37.7584545390754, -122.425930763098) | |||
| 31255 | 31255 | 120468 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 90 West Clay St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5988384.0014 | 2115083.94801 | 37.7869465618324 | -122.483997692017 | (37.7869465618324, -122.483997692017) | |||
| 32387 | 32387 | 229294 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6004933.04589 | 2104652.65087 | 37.7592543025755 | -122.42599887684099 | (37.7592543025755, -122.425998876841) | |||
| 34854 | 34854 | 208634 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 479 Pacheco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 6ft | 5993651.289030001 | 2101848.22012 | 37.7509099969154 | -122.464812672964 | (37.7509099969154, -122.464812672964) | |||
| 36529 | 36529 | 229288 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 420 Dolores St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6004867.71345 | 2105767.79402 | 37.76231252903371 | -122.42630422366699 | (37.7623125290337, -122.426304223667) | |||
| 37713 | 37713 | 192997 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1856 Illinois St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6016261.5851 | 2100510.3314 | 37.748514099551 | -122.38653011709499 | (37.748514099551, -122.386530117095) | |||
| 37756 | 37756 | 177391 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 27 Winding Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 6ft | 6002763.35309 | 2087066.1098599997 | 37.7108428246043 | -122.432246735124 | (37.7108428246043, -122.432246735124) | |||
| 38043 | 38043 | 130584 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2899 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6000542.90276 | 2118173.57115 | 37.7961302188915 | -122.442152645139 | (37.7961302188915, -122.442152645139) | |||
| 40660 | 40660 | 229299 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6004939.4926 | 2104464.28236 | 37.7587374514017 | -122.42596317197099 | (37.7587374514017, -122.425963171971) | |||
| 43863 | 43863 | 229295 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6004932.10838 | 2104636.67815 | 37.7592103922697 | -122.426000982165 | (37.7592103922697, -122.426000982165) | |||
| 44605 | 44605 | 229408 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 6009986.58763 | 2103323.08102 | 37.7558879144013 | -122.40842742538901 | (37.7558879144013, -122.408427425389) | |||
| 54796 | 54796 | 130507 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3800 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 6ft | 5996496.35751 | 2115626.9320099996 | 37.7889063929651 | -122.455970221147 | (37.7889063929651, -122.455970221147) | |||
| 57609 | 57609 | 118082 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 7300 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 5984332.1669 | 2112501.37067 | 37.7796188361138 | -122.49782513132799 | (37.7796188361138, -122.497825131328) | |||
| 57726 | 57726 | 130490 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1570 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6005308.97612 | 2119595.0943 | 37.8003038241308 | -122.425762294907 | (37.8003038241308, -122.425762294907) | |||
| 58407 | 58407 | 130963 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 227 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6011940.3019 | 2119426.7104700003 | 37.8002139800565 | -122.402803308126 | (37.8002139800565, -122.402803308126) | |||
| 58974 | 58974 | 229292 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6004929.1624300005 | 2104721.4333099998 | 37.7594429434456 | -122.42601720414801 | (37.7594429434456, -122.426017204148) | |||
| 59342 | 59342 | 120469 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 90 West Clay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5988396.77964 | 2115081.48112 | 37.7869405323669 | -122.48395330179501 | (37.7869405323669, -122.483953301795) | |||
| 60815 | 60815 | 208591 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1640 09th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 6ft | 5993421.74589 | 2104308.2592599997 | 37.7576513932025 | -122.465785166563 | (37.7576513932025, -122.465785166563) | |||
| 62413 | 62413 | 229291 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 6ft | 6004921.06881 | 2104795.19246 | 37.759645011229 | -122.426050446684 | (37.759645011229, -122.426050446684) | |||
| 68745 | 68745 | 229296 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6004931.33426 | 2104618.03138 | 37.75915914888729 | -122.42600233204901 | (37.7591591488873, -122.426002332049) | |||
| 70003 | 70003 | 193113 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1918 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 6ft | 6013201.374480001 | 2096537.6402 | 37.73743604374629 | -122.396833869195 | (37.7374360437463, -122.396833869195) | |||
| 71835 | 71835 | 229322 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2773 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6009848.961490001 | 2101182.51416 | 37.7500026861908 | -122.40875237562 | (37.7500026861908, -122.40875237562) | |||
| 72950 | 72950 | 130960 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 227 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6011885.219190001 | 2119419.39867 | 37.8001908279071 | -122.402993402343 | (37.8001908279071, -122.402993402343) | |||
| 73378 | 73378 | 208636 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 469 Pacheco St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993711.10983 | 2101824.71737 | 37.7508489131681 | -122.464604102194 | (37.7508489131681, -122.464604102194) | |||
| 122545 | 122545 | 229348 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2970 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6009679.24982 | 2101052.76499 | 37.7496369166219 | -122.409330094713 | (37.7496369166219, -122.409330094713) | |||
| 132287 | 132287 | 229405 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1447 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 6ft | 6010127.8118199995 | 2100843.97719 | 37.749088752863706 | -122.407764223942 | (37.7490887528637, -122.407764223942) | |||
| 148009 | 148009 | 229297 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6004930.83028 | 2104593.5463900003 | 37.7590918903965 | -122.426002332056 | (37.7590918903965, -122.426002332056) | |||
| 150824 | 150824 | 130962 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 227 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6011923.50138 | 2119423.1446599998 | 37.8002032511281 | -122.402861193896 | (37.8002032511281, -122.402861193896) | |||
| 152619 | 152619 | 120470 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 90 West Clay St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 5988406.93604 | 2115078.27113 | 37.7869323099126 | -122.483917927929 | (37.7869323099126, -122.483917927929) | |||
| 158411 | 158411 | 208828 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 301 Melrose Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5998172.9050900005 | 2095504.48065 | 37.7337512811885 | -122.448719701551 | (37.7337512811885, -122.448719701551) | |||
| 160743 | 160743 | 130575 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2401 Bay St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5999256.14977 | 2120225.4124 | 37.8016906092881 | -122.446752761038 | (37.8016906092881, -122.446752761038) | |||
| 161726 | 161726 | 229467 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1470 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 6ft | 6005195.161230001 | 2099816.05864 | 37.74598895342611 | -122.42474827871 | (37.7459889534261, -122.42474827871) | |||
| 162368 | 162368 | 130961 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 227 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6011905.50402 | 2119421.65978 | 37.800198169070896 | -122.40292336764601 | (37.8001981690709, -122.402923367646) | |||
| 177091 | 177091 | 229344 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6010247.17323 | 2103327.9648599997 | 37.755915913899 | -122.40752657540001 | (37.755915913899, -122.4075265754) | |||
| 178431 | 178431 | 229641 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 125 Elsie St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6007185.92932 | 2098552.31182 | 37.7426312248514 | -122.417774891511 | (37.7426312248514, -122.417774891511) | |||
| 185310 | 185310 | 120357 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5988110.00205 | 2114686.59406 | 37.7858395857912 | -122.484916493405 | (37.7858395857912, -122.484916493405) | |||
| 186340 | 186340 | 229298 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 500 Dolores St | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6004936.0298 | 2104485.73844 | 37.7587961690391 | -122.425976675282 | (37.7587961690391, -122.425976675282) | |||
| 187205 | 187205 | 229341 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2384 Bryant St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 6ft | 6009657.1451900005 | 2103466.25311 | 37.7562625782597 | -122.409576854282 | (37.7562625782597, -122.409576854282) | |||
| 188425 | 188425 | 130511 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3870 Washington St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 5996298.86533 | 2115600.22493 | 37.7888217253879 | -122.456651580816 | (37.7888217253879, -122.456651580816) | |||
| 188979 | 188979 | 208590 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1640 09th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 6ft | 5993420.78428 | 2104324.2280599996 | 37.757695183915104 | -122.465789652393 | (37.7576951839151, -122.465789652393) | |||
| 2241 | 2241 | 193105 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1649 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 10/28/1996 12:00:00 AM | 10 | Width 5ft | 6014582.89152 | 2095437.7386599998 | 37.734492738953 | -122.39198038730301 | (37.734492738953, -122.391980387303) | ||
| 3021 | 3021 | 230623 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1189 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 780105 | 6003227.47781 | 2101395.97858 | 37.7502157130929 | -122.431665039223 | (37.7502157130929, -122.431665039223) | |
| 23860 | 23860 | 229465 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1197 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005193.00305 | 2101433.51529 | 37.7504299954534 | -122.424870794274 | (37.7504299954534, -122.424870794274) | |||
| 24160 | 24160 | 130756 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2692 Broadway | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6000833.48042 | 2117168.28779 | 37.7933865303134 | -122.44107503251301 | (37.7933865303134, -122.441075032513) | |||
| 24990 | 24990 | 130764 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2672 Vallejo St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 6000780.4951599995 | 2117576.2259299997 | 37.794503603424 | -122.441287648428 | (37.794503603424, -122.441287648428) | |||
| 25351 | 25351 | 130916 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1528 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6006812.00456 | 2117717.94838 | 37.795234473441894 | -122.420427898738 | (37.7952344734419, -122.420427898738) | |||
| 25472 | 25472 | 249390 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 240 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6008867.778059999 | 2113219.38009 | 37.782998130413105 | -122.41299634201799 | (37.7829981304131, -122.412996342018) | |||
| 25622 | 25622 | 124115 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4200 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 5993978.55219 | 2112855.59666 | 37.781152227483204 | -122.464480113532 | (37.7811522274832, -122.464480113532) | |||
| 26150 | 26150 | 130766 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2672 Vallejo St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6000749.67266 | 2117573.07322 | 37.79449319107189 | -122.441394071498 | (37.7944931910719, -122.441394071498) | |||
| 27216 | 27216 | 230837 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 263 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6002293.27524 | 2106686.98907 | 37.7646905577465 | -122.43527398081699 | (37.7646905577465, -122.435273980817) | |||
| 28010 | 28010 | 230014 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 209 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 5997619.228630001 | 2106435.6515099998 | 37.7637339084026 | -122.451422065382 | (37.7637339084026, -122.451422065382) | |||
| 29155 | 29155 | 130828 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2209 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6003518.92457 | 2116887.9892700003 | 37.7927694946549 | -122.43176318402399 | (37.7927694946549, -122.431763184024) | |||
| 29480 | 29480 | 193151 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 529 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6013342.74556 | 2115522.4427400003 | 37.7895719901999 | -122.397676276739 | (37.7895719901999, -122.397676276739) | |||
| 29540 | 29540 | 229466 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1027 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6005143.67884 | 2102363.88846 | 37.7529817983974 | -122.425107552471 | (37.7529817983974, -122.425107552471) | |||
| 30697 | 30697 | 193144 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 555 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6012993.45562 | 2115186.29149 | 37.7886295411588 | -122.398861189298 | (37.7886295411588, -122.398861189298) | |||
| 30777 | 30777 | 230657 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 43 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6004109.43402 | 2102808.00409 | 37.7541427566091 | -122.428715825873 | (37.7541427566091, -122.428715825873) | |||
| 31657 | 31657 | 230852 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 180 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6003495.92162 | 2107200.3914799998 | 37.7661684595218 | -122.43115099392999 | (37.7661684595218, -122.43115099393) | |||
| 35590 | 35590 | 193136 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 575 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6012842.9319 | 2115039.64278 | 37.788218489829504 | -122.399371683164 | (37.7882184898295, -122.399371683164) | |||
| 36207 | 36207 | 130847 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2619 Octavia St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6004415.06873 | 2118278.49005 | 37.79663821264489 | -122.42876165712299 | (37.7966382126449, -122.428761657123) | |||
| 36483 | 36483 | 193142 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 555 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6012941.50055 | 2115135.3215799998 | 37.7884866946479 | -122.399037368286 | (37.7884866946479, -122.399037368286) |
JSON shape: default, array, newline-delimited
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");