Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5098 | 5098 | 253771 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 844 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/07/2017 12:00:00 AM | 3 | 3x3 | 6008309.10382 | 2120362.6037 | 37.802580290063 | -122.41543500385 | (37.802580290063, -122.41543500385) | ||
| 4921 | 4921 | 253716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2959 21st Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x15 | 5989962.0 | 2095532.0 | 37.733353897105495 | -122.477108940264 | (37.7333538971055, -122.477108940264) | ||||
| 4864 | 4864 | 253698 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2200 Ofarrell St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Width 0ft | 6000775.0 | 2113124.0 | 37.7822786323031 | -122.440987106931 | (37.7822786323031, -122.440987106931) | ||||
| 4041 | 4041 | 253601 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4027 | 4027 | 253600 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | |||||
| 4034 | 4034 | 253599 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 865 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x9 | 5985761.0 | 2114995.0 | 37.7865492821054 | -122.49306599544501 | (37.7865492821054, -122.493065995445) | ||||
| 3753 | 3753 | 253554 | Planning Code 138.1 required 4 | Magnolia grandiflora :: Southern Magnolia 21 | 1855 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778968 | 5986885.63083 | 2102641.2721 | 37.7526951056681 | -122.48826692291901 | (37.7526951056681, -122.488266922919) | |
| 2473 | 2473 | 253095 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1201 29th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779996 | 5987047.82966 | 2107087.0186099997 | 37.7649113707945 | -122.488032657316 | (37.7649113707945, -122.488032657316) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 1337 | 1337 | 251410 | Significant Tree 6 | Magnolia grandiflora :: Southern Magnolia 21 | 2777 Pine St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 3x3 | Permit Number 779015 | 6000658.0 | 2114782.0 | 37.7868244087741 | -122.441510888069 | (37.7868244087741, -122.441510888069) | |||
| 246 | 246 | 251253 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1350 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6008544.9526 | 2110145.4696299997 | 37.774539777213995 | -122.413895673958 | (37.774539777214, -122.413895673958) | ||||
| 29201 | 29201 | 251016 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3800 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996023.96997 | 2115889.71074 | 37.7896007882834 | -122.45762362832501 | (37.7896007882834, -122.457623628325) | |||
| 67144 | 67144 | 251015 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3800 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995999.4729 | 2115885.42226 | 37.7895876060377 | -122.457708074672 | (37.7895876060377, -122.457708074672) | |||
| 46725 | 46725 | 251011 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3832 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995890.12624 | 2115872.70718 | 37.7895464116889 | -122.458085479669 | (37.7895464116889, -122.458085479669) | |||
| 31338 | 31338 | 251010 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3844 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995838.7285 | 2115864.4804700003 | 37.789520870050396 | -122.45826271355101 | (37.7895208700504, -122.458262713551) | |||
| 38166 | 38166 | 250953 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 214 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5987151.5590699995 | 2114525.01453 | 37.7853400639264 | -122.48822051678499 | (37.7853400639264, -122.488220516785) | |||
| 160658 | 160658 | 250952 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 214 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5987148.21868 | 2114512.81336 | 37.7853063681278 | -122.48823117644 | (37.7853063681278, -122.48823117644) | |||
| 174710 | 174710 | 250951 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 218 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987145.19845 | 2114497.53735 | 37.7852642483779 | -122.488240502406 | (37.7852642483779, -122.488240502406) | |||
| 184637 | 184637 | 250950 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 218 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987144.16793 | 2114485.2871 | 37.78523055258079 | -122.488243167098 | (37.7852305525808, -122.488243167098) | |||
| 171093 | 171093 | 250949 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 218 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5987142.80121 | 2114475.34494 | 37.7852031745222 | -122.488247164594 | (37.7852031745222, -122.488247164594) | |||
| 176997 | 176997 | 250946 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 230 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5987144.28423 | 2114400.14571 | 37.784996785514295 | -122.48823650582199 | (37.7849967855143, -122.488236505822) | |||
| 181498 | 181498 | 250945 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 230 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987144.48196 | 2114391.32094 | 37.7849725667609 | -122.48823517302401 | (37.7849725667609, -122.488235173024) | |||
| 69413 | 69413 | 250935 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 251 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5987103.2906 | 2114265.25445 | 37.7846240210314 | -122.488368412093 | (37.7846240210314, -122.488368412093) | |||
| 168357 | 168357 | 250929 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 267 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5987107.356430001 | 2114166.6057 | 37.7843533970412 | -122.488347093656 | (37.7843533970412, -122.488347093656) | |||
| 161085 | 161085 | 250928 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 267 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987106.15065 | 2114182.35538 | 37.7843965708009 | -122.48835242302499 | (37.7843965708009, -122.488352423025) | |||
| 156940 | 156940 | 250927 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 271 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987107.588690001 | 2114141.28905 | 37.784283898320105 | -122.48834442897 | (37.7842838983201, -122.48834442897) | |||
| 76516 | 76516 | 250926 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 271 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987106.77612 | 2114157.41359 | 37.784328124280705 | -122.488348425539 | (37.7843281242807, -122.488348425539) | |||
| 154814 | 154814 | 250916 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 291 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987112.29634 | 2114018.46462 | 37.783946932255894 | -122.48831911303499 | (37.7839469322559, -122.488319113035) | |||
| 60598 | 60598 | 250915 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 291 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5987112.557 | 2114030.73155 | 37.783980628943894 | -122.48831911304801 | (37.7839806289439, -122.488319113048) | |||
| 151618 | 151618 | 250914 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 298 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5987158.51725 | 2114000.60813 | 37.783900600070204 | -122.48815789517799 | (37.7839006000702, -122.488157895178) | |||
| 166902 | 166902 | 250906 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 278 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5986846.31945 | 2114079.72727 | 37.7840996200405 | -122.48924378877399 | (37.7840996200405, -122.489243788774) | |||
| 56721 | 56721 | 250893 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 246 29th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986838.41814 | 2114287.75861 | 37.784670353193896 | -122.48928642474701 | (37.7846703531939, -122.489286424747) | |||
| 51846 | 51846 | 250892 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 246 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986838.96798 | 2114277.39217 | 37.7846419220213 | -122.489283760055 | (37.7846419220213, -122.489283760055) | |||
| 176457 | 176457 | 250841 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 270 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5986536.41908 | 2114078.9762 | 37.784079463546 | -122.490315862507 | (37.784079463546, -122.490315862507) | |||
| 69717 | 69717 | 250840 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 270 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5986536.60415 | 2114066.29003 | 37.784044641778 | -122.490314288694 | (37.784044641778, -122.490314288694) | |||
| 180273 | 180273 | 250833 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 287 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986492.190330001 | 2114009.71145 | 37.7838866992583 | -122.49046377849501 | (37.7838866992583, -122.490463778495) | |||
| 185943 | 185943 | 250832 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 291 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986494.4269 | 2113986.56401 | 37.783823273672795 | -122.490454337414 | (37.7838232736728, -122.490454337414) | |||
| 63976 | 63976 | 250791 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 284 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985916.223259999 | 2114026.60434 | 37.7838994246524 | -122.492457627626 | (37.7838994246524, -122.492457627626) | |||
| 52635 | 52635 | 250772 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 251 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985866.25825 | 2114225.46269 | 37.784442510848706 | -122.492645136277 | (37.7844425108487, -122.492645136277) | |||
| 173278 | 173278 | 250764 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 240 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5985906.3948800005 | 2114315.3934 | 37.784691781350006 | -122.492512904459 | (37.78469178135, -122.492512904459) | |||
| 135546 | 135546 | 250763 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 234 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5985904.694069999 | 2114338.51574 | 37.7847551691681 | -122.492520492032 | (37.7847551691681, -122.492520492032) | |||
| 26191 | 26191 | 250755 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2930 Lake St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5986296.61932 | 2114541.51737 | 37.78533546029529 | -122.491179523725 | (37.7853354602953, -122.491179523725) | |||
| 49755 | 49755 | 250721 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987040.13205 | 2114480.67859 | 37.7852118286941 | -122.488602755627 | (37.7852118286941, -122.488602755627) | |||
| 154242 | 154242 | 250720 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987051.85581 | 2114484.6992099998 | 37.7852235522708 | -122.48856249118401 | (37.7852235522708, -122.488562491184) | |||
| 172501 | 172501 | 250719 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987066.08054 | 2114491.1065 | 37.7852419748774 | -122.488513749728 | (37.7852419748774, -122.488513749728) | |||
| 58916 | 58916 | 250718 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5987078.53306 | 2114500.6014799997 | 37.785268771968205 | -122.488471366481 | (37.7852687719682, -122.488471366481) | |||
| 156155 | 156155 | 250717 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987087.91132 | 2114509.55193 | 37.7852938945439 | -122.488439579031 | (37.7852938945439, -122.488439579031) | |||
| 46000 | 46000 | 250716 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987098.578919999 | 2114521.52467 | 37.7853273906816 | -122.48840355308799 | (37.7853273906816, -122.488403553088) | |||
| 45704 | 45704 | 250715 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5987106.77145 | 2114532.32994 | 37.7853575368596 | -122.488376004166 | (37.7853575368596, -122.488376004166) | |||
| 34746 | 34746 | 250714 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987112.60579 | 2114547.45542 | 37.7853994074988 | -122.48835693135099 | (37.7853994074988, -122.488356931351) | |||
| 49782 | 49782 | 250713 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2700 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987117.150780001 | 2114559.55828 | 37.785432903659796 | -122.48834209701 | (37.7854329036598, -122.48834209701) | |||
| 176006 | 176006 | 250712 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 185 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987125.01616 | 2114583.7900099996 | 37.785499895943 | -122.488316666901 | (37.785499895943, -122.488316666901) | |||
| 63635 | 63635 | 250692 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 850 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5985754.9302 | 2115039.63583 | 37.7866714841451 | -122.49309028449801 | (37.7866714841451, -122.493090284498) | |||
| 56642 | 56642 | 250691 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 850 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5985780.23123 | 2115050.10184 | 37.786701700454394 | -122.49300352150401 | (37.7867017004544, -122.493003521504) | |||
| 159556 | 159556 | 250690 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 850 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 5985788.39353 | 2115054.1604299997 | 37.786713321507705 | -122.492975581372 | (37.7867133215077, -122.492975581372) | |||
| 54520 | 54520 | 250689 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 El Camino Del Mar | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5985904.11685 | 2115059.31472 | 37.7867342406419 | -122.492575591693 | (37.7867342406419, -122.492575591693) | |||
| 153197 | 153197 | 250688 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 El Camino Del Mar | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5985944.70635 | 2115029.2449 | 37.7866540507972 | -122.492432948444 | (37.7866540507972, -122.492432948444) | |||
| 136690 | 136690 | 250687 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5985958.9263 | 2115018.3607 | 37.786624997302205 | -122.492382949739 | (37.7866249973022, -122.492382949739) | |||
| 179781 | 179781 | 250686 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5985966.41155 | 2115010.5824700003 | 37.786604078150795 | -122.49235647996599 | (37.7866040781508, -122.492356479966) | |||
| 133235 | 133235 | 250685 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 800 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5985976.517990001 | 2115006.13452 | 37.786592456216795 | -122.49232118698299 | (37.7865924562168, -122.492321186983) | |||
| 169553 | 169553 | 250660 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 610 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5986650.13885 | 2115042.16908 | 37.78673075486039 | -122.489993306266 | (37.7867307548604, -122.489993306266) | |||
| 150706 | 150706 | 250659 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 610 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5986658.453980001 | 2115053.42034 | 37.7867621331211 | -122.489965366122 | (37.7867621331211, -122.489965366122) | |||
| 41000 | 41000 | 250658 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 610 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5986669.40846 | 2115068.84822 | 37.7868051332849 | -122.489928601847 | (37.7868051332849, -122.489928601847) | |||
| 69228 | 69228 | 250657 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986677.325759999 | 2115081.37781 | 37.786839998225496 | -122.48990213208201 | (37.7868399982255, -122.489902132082) | |||
| 169511 | 169511 | 250656 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986684.519119999 | 2115099.84858 | 37.7868911336549 | -122.48987860404199 | (37.7868911336549, -122.489878604042) | |||
| 36894 | 36894 | 250655 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986693.41224 | 2115118.28322 | 37.7869422691247 | -122.48984919260799 | (37.7869422691247, -122.489849192608) | |||
| 29642 | 29642 | 250654 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986699.80995 | 2115139.3106400003 | 37.787000377908704 | -122.489828605331 | (37.7870003779087, -122.489828605331) | |||
| 34481 | 34481 | 250653 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986703.58682 | 2115157.00739 | 37.787049188603504 | -122.489816840378 | (37.7870491886035, -122.489816840378) | |||
| 186570 | 186570 | 250652 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986706.54079 | 2115175.99151 | 37.7871014859956 | -122.489808017137 | (37.7871014859956, -122.489808017137) | |||
| 166614 | 166614 | 250648 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2612 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987210.48025 | 2114649.78829 | 37.7856860942789 | -122.48802584141899 | (37.7856860942789, -122.488025841419) | |||
| 72500 | 72500 | 250647 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2612 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5987260.49857 | 2114653.43693 | 37.7856990301354 | -122.487853062789 | (37.7856990301354, -122.487853062789) | |||
| 133284 | 133284 | 250640 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Lake St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987377.820230001 | 2114657.75032 | 37.785717716240896 | -122.487447485608 | (37.7857177162409, -122.487447485608) | |||
| 162295 | 162295 | 250637 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 181 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987131.953509999 | 2114640.46335 | 37.785655909428 | -122.488296832348 | (37.785655909428, -122.488296832348) | |||
| 181534 | 181534 | 250636 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 181 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5987131.09785 | 2114655.34253 | 37.785696713464 | -122.48830088648701 | (37.785696713464, -122.488300886487) | |||
| 148726 | 148726 | 250634 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 194 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5987177.832 | 2114671.9451200003 | 37.7857450259584 | -122.488140422254 | (37.7857450259584, -122.488140422254) | |||
| 152066 | 152066 | 250633 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 194 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5987181.90233 | 2114665.57681 | 37.785727777865404 | -122.488125872127 | (37.7857277778654, -122.488125872127) | |||
| 42632 | 42632 | 250551 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 El Camino Del Mar | 6 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988203.798359999 | 2115369.62382 | 37.7877204533909 | -122.48464210894801 | (37.7877204533909, -122.484642108948) | |||
| 177086 | 177086 | 250550 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 El Camino Del Mar | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5988215.47064 | 2115370.08013 | 37.7877223860349 | -122.484601759078 | (37.7877223860349, -122.484601759078) | |||
| 184561 | 184561 | 250549 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 El Camino Del Mar | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988226.07592 | 2115370.2073 | 37.787723352804704 | -122.484565076625 | (37.7877233528047, -122.484565076625) | |||
| 36945 | 36945 | 250489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 240 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987807.77183 | 2115352.13466 | 37.7876493619664 | -122.48601098323499 | (37.7876493619664, -122.486010983235) | |||
| 165524 | 165524 | 250331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 149 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5987389.174 | 2114970.7351900004 | 37.7865777451115 | -122.487431204304 | (37.7865777451115, -122.487431204304) | |||
| 40429 | 40429 | 250319 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3800 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996038.5864 | 2115893.21942 | 37.789611261785296 | -122.457573311282 | (37.7896112617853, -122.457573311282) | |||
| 52552 | 52552 | 250318 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3800 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996010.99249 | 2115888.4189299997 | 37.7895964958364 | -122.457668435264 | (37.7895964958364, -122.457668435264) | |||
| 164334 | 164334 | 250317 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3800 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995989.814119999 | 2115885.19527 | 37.789586427918 | -122.45774147639798 | (37.789586427918, -122.457741476398) | |||
| 40928 | 40928 | 250002 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 21 Darrell Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011523.15034 | 2120119.58855 | 37.8020931539352 | -122.40429561796499 | (37.8020931539352, -122.404295617965) | |||
| 71391 | 71391 | 249961 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 271 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 0ft | 6011579.58973 | 2120083.50777 | 37.8019972385329 | -122.404097768894 | (37.8019972385329, -122.404097768894) | |||
| 31005 | 31005 | 249911 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 308 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6011263.97992 | 2120425.1096099997 | 37.802917554375895 | -122.40521400292101 | (37.8029175543759, -122.405214002921) | |||
| 32383 | 32383 | 249815 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1740 Kearny St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 6010857.72173 | 2120932.6485599997 | 37.8042884107407 | -122.406655661138 | (37.8042884107407, -122.406655661138) | |||
| 64931 | 64931 | 249814 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1740 Kearny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010861.46651 | 2120893.20029 | 37.8041803050268 | -122.40663992031901 | (37.8041803050268, -122.406639920319) | |||
| 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) | |||
| 159664 | 159664 | 249394 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 350 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008338.396319999 | 2113145.81532 | 37.7827664083955 | -122.41482258270901 | (37.7827664083955, -122.414822582709) | |||
| 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) | |||
| 57882 | 57882 | 249389 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 240 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6008887.164609999 | 2113222.80178 | 37.7830086137915 | -122.412929514295 | (37.7830086137915, -122.412929514295) | |||
| 151749 | 151749 | 249381 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 650 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6007880.04669 | 2114726.60806 | 37.7870811172514 | -122.416520295881 | (37.7870811172514, -122.416520295881) | |||
| 158414 | 158414 | 249380 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 648 Hyde St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6007883.839819999 | 2114699.11368 | 37.7870058377012 | -122.41650522414601 | (37.7870058377012, -122.416505224146) | |||
| 133318 | 133318 | 248568 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 818 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997666.7472 | 2107697.6818 | 37.767201843601605 | -122.45134874122 | (37.7672018436016, -122.45134874122) | |||
| 37313 | 37313 | 248565 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 204 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998984.3566 | 2107677.9979 | 37.7672231548201 | -122.44678992532101 | (37.7672231548201, -122.446789925321) | |||
| 154791 | 154791 | 248564 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 204 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5999003.7376 | 2107680.4205 | 37.7672309138134 | -122.44672306386299 | (37.7672309138134, -122.446723063863) |
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");