Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 808 | 808 | 193091 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1395 Fairfax Ave | 1 | : 4 | Tree 1 | DPW 2 | 01/27/2015 12:22:00 PM | 6 | Width 3ft | 6016598.40823 | 2097419.6759099998 | 37.7400464320877 | -122.38515006152201 | (37.7400464320877, -122.385150061522) | ||
| 840 | 840 | 193039 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1800 Evans Ave | 10 | : 4 | Tree 1 | DPW 2 | 05/12/2011 12:00:00 AM | 5 | Width 4ft | 6014331.82546 | 2099544.27863 | 37.7457545046729 | -122.39313565907699 | (37.7457545046729, -122.393135659077) | ||
| 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) | ||
| 24374 | 24374 | 192945 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 238 11th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008246.27864 | 2109382.4071299997 | 37.7724278093356 | -122.41487483150401 | (37.7724278093356, -122.414874831504) | |||
| 24628 | 24628 | 193040 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1890 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014266.5091 | 2099591.88048 | 37.745881580665 | -122.393364845912 | (37.745881580665, -122.393364845912) | |||
| 24639 | 24639 | 229283 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 12 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6010503.18066 | 2104324.48808 | 37.758666470594896 | -122.40671143888099 | (37.7586664705949, -122.406711438881) | |||
| 25112 | 25112 | 192821 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 674 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013431.41739 | 2113070.8325900002 | 37.782845374266 | -122.39719749747101 | (37.782845374266, -122.397197497471) | |||
| 25874 | 25874 | 192931 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1562 11th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008981.17541 | 2108615.0151400003 | 37.7703619964339 | -122.412278495049 | (37.7703619964339, -122.412278495049) | |||
| 26308 | 26308 | 192927 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 355 11th St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008730.57327 | 2108963.75547 | 37.7713054904774 | -122.413169994818 | (37.7713054904774, -122.413169994818) | |||
| 26928 | 26928 | 229277 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6010526.84052 | 2103899.06003 | 37.7574996640945 | -122.406599632462 | (37.7574996640945, -122.406599632462) | |||
| 26970 | 26970 | 229279 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 6 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6010520.0881199995 | 2103990.76889 | 37.757751098346894 | -122.406629447707 | (37.7577510983469, -122.406629447707) | |||
| 27111 | 27111 | 193054 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1998 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013745.9771300005 | 2099978.99313 | 37.7469155761867 | -122.39519189779499 | (37.7469155761867, -122.395191897795) | |||
| 27486 | 27486 | 192817 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 666 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6013574.47554 | 2113201.19226 | 37.783211275117104 | -122.39671171428101 | (37.7832112751171, -122.396711714281) | |||
| 27608 | 27608 | 193063 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 20 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6015045.87298 | 2098929.39678 | 37.7441058081384 | -122.39062360620399 | (37.7441058081384, -122.390623606204) | |||
| 27725 | 27725 | 193023 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1575 Bay Shore Blvd | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6011811.6604 | 2092165.89243 | 37.725354684447204 | -122.40133165664601 | (37.7253546844472, -122.401331656646) | |||
| 27799 | 27799 | 208686 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 207 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997054.6676199995 | 2089435.45045 | 37.7170231509855 | -122.45214801343201 | (37.7170231509855, -122.452148013432) | |||
| 28359 | 28359 | 192990 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 540 Texas St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013786.51835 | 2104548.48696 | 37.7594646800698 | -122.39537176939301 | (37.7594646800698, -122.395371769393) | |||
| 28514 | 28514 | 192895 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 345 04th St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012493.155259999 | 2112622.67802 | 37.7815625668946 | -122.40041202341699 | (37.7815625668946, -122.400412023417) | |||
| 28631 | 28631 | 192939 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1559 Howard St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6007881.70364 | 2109409.76028 | 37.7724824224706 | -122.416137872687 | (37.7724824224706, -122.416137872687) | |||
| 28771 | 28771 | 192935 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 394 12th St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6008589.10788 | 2108571.8374400004 | 37.7702214324131 | -122.41363160691002 | (37.7702214324131, -122.41363160691) | |||
| 28807 | 28807 | 192846 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 360 03rd St | 4 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6013234.4384699995 | 2113062.86242 | 37.782812522018496 | -122.39787840748501 | (37.7828125220185, -122.397878407485) | |||
| 28870 | 28870 | 193050 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1940 Evans Ave | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013815.46024 | 2099929.58477 | 37.7467837751701 | -122.39494816981701 | (37.7467837751701, -122.394948169817) | |||
| 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) | |||
| 29985 | 29985 | 193072 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 37 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015318.00876 | 2098725.46335 | 37.7435609430974 | -122.38966837242201 | (37.7435609430974, -122.389668372422) | |||
| 30402 | 30402 | 192891 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 760 Harrison St | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6012948.27406 | 2112607.17097 | 37.7815453574786 | -122.398836430965 | (37.7815453574786, -122.398836430965) | |||
| 30480 | 30480 | 193101 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1224 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6017385.96084 | 2096915.0483 | 37.7387043603066 | -122.382391900165 | (37.7387043603066, -122.382391900165) | |||
| 30636 | 30636 | 193062 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 12 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6014912.025280001 | 2099027.7617599997 | 37.7443684713257 | -122.391093299634 | (37.7443684713257, -122.391093299634) | |||
| 30830 | 30830 | 193060 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6014829.68404 | 2099091.25794 | 37.744538248958605 | -122.39138245865699 | (37.7445382489586, -122.391382458657) | |||
| 30898 | 30898 | 193032 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1995 Evans Ave | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013856.76211 | 2099814.34392 | 37.746469644669105 | -122.394797281563 | (37.7464696446691, -122.394797281563) | |||
| 31168 | 31168 | 192934 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 5 Bernice St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008547.36721 | 2108559.22108 | 37.770184446870296 | -122.41377509556101 | (37.7701844468703, -122.413775095561) | |||
| 31894 | 31894 | 193038 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1925 Evans Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013953.00674 | 2099743.1247 | 37.7462794425459 | -122.39445948992399 | (37.7462794425459, -122.394459489924) | |||
| 32187 | 32187 | 246949 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2101 15th St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6003300.7395 | 2107104.41585 | 37.7658938713298 | -122.431819236962 | (37.7658938713298, -122.431819236962) | |||
| 32262 | 32262 | 192856 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 712 Harrison St | 7 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6013211.97896 | 2112858.20915 | 37.782249340462705 | -122.39794174761101 | (37.7822493404627, -122.397941747611) | |||
| 32874 | 32874 | 192868 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Bonifacio St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012633.555480001 | 2112802.71713 | 37.7820647411425 | -122.399938949442 | (37.7820647411425, -122.399938949442) | |||
| 32923 | 32923 | 193034 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1925 Evans Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013889.059669999 | 2099790.32344 | 37.7464054852269 | -122.39468391753401 | (37.7464054852269, -122.394683917534) | |||
| 33601 | 33601 | 192932 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1562 11th St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6009014.54918 | 2108579.68008 | 37.770266847256295 | -122.412160557068 | (37.7702668472563, -122.412160557068) | |||
| 34209 | 34209 | 193080 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 45 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015444.091990001 | 2098631.34147 | 37.743309494432 | -122.389225833109 | (37.743309494432, -122.389225833109) | |||
| 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) | |||
| 34498 | 34498 | 192948 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 202 11th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6008125.57272 | 2109597.0372 | 37.7730103496868 | -122.415307562798 | (37.7730103496868, -122.415307562798) | |||
| 35416 | 35416 | 246955 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2101 15th St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003442.97283 | 2107114.24236 | 37.765928914304794 | -122.43132798319401 | (37.7659289143048, -122.431327983194) | |||
| 35435 | 35435 | 192824 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 362 03rd St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013311.51298 | 2113082.94966 | 37.7828719690123 | -122.397613169532 | (37.7828719690123, -122.397613169532) | |||
| 35588 | 35588 | 192872 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Bonifacio St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012734.45034 | 2112896.95633 | 37.7823291247251 | -122.399596515494 | (37.7823291247251, -122.399596515494) | |||
| 36180 | 36180 | 193115 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1791 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6014511.3912 | 2096886.32335 | 37.738466285485295 | -122.392328872775 | (37.7384662854853, -122.392328872775) | |||
| 36263 | 36263 | 246953 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2101 15th St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6003411.81977 | 2107112.2818299998 | 37.7659217655897 | -122.43143559517901 | (37.7659217655897, -122.431435595179) | |||
| 36494 | 36494 | 192918 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 380 10th St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6009145.73706 | 2109144.6872799997 | 37.771825585501496 | -122.41174670615601 | (37.7718255855015, -122.411746706156) | |||
| 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) | |||
| 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) | |||
| 37062 | 37062 | 192893 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 345 04th St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012513.76951 | 2112597.17547 | 37.781493692331 | -122.40033891573499 | (37.781493692331, -122.400338915735) | |||
| 37066 | 37066 | 192922 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 380 10th St | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009195.26787 | 2109094.7407 | 37.7716912222994 | -122.41157184556101 | (37.7716912222994, -122.411571845561) | |||
| 37151 | 37151 | 208700 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 144 Eucalyptus Dr | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5990998.47136 | 2094705.0168400002 | 37.731143287718 | -122.473465306694 | (37.731143287718, -122.473465306694) | |||
| 37772 | 37772 | 193096 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1498 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016240.24501 | 2097771.68412 | 37.7409931556099 | -122.386412991184 | (37.7409931556099, -122.386412991184) | |||
| 37983 | 37983 | 193061 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6014872.80659 | 2099056.97723 | 37.7444465145094 | -122.391230952554 | (37.7444465145094, -122.391230952554) | |||
| 38049 | 38049 | 193024 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1575 Bay Shore Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011805.97785 | 2092195.6553200001 | 37.725436090177496 | -122.401353391455 | (37.7254360901775, -122.401353391455) | |||
| 38205 | 38205 | 192936 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 394 12th St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008599.777980001 | 2108564.43517 | 37.770201706665794 | -122.413594175352 | (37.7702017066658, -122.413594175352) | |||
| 38375 | 38375 | 193076 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 41 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6015380.37917 | 2098678.9075 | 37.7434365686321 | -122.38944945853399 | (37.7434365686321, -122.389449458534) | |||
| 38402 | 38402 | 193084 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 51 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6015541.663790001 | 2098558.17611 | 37.7431140061022 | -122.388883345216 | (37.7431140061022, -122.388883345216) | |||
| 38470 | 38470 | 192883 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2 Rizal St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012844.29072 | 2112783.62554 | 37.7820240665994 | -122.399208556033 | (37.7820240665994, -122.399208556033) | |||
| 38758 | 38758 | 192877 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 728 Lapu-lapu St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012854.99086 | 2112916.15992 | 37.7823885717151 | -122.39918084433201 | (37.7823885717151, -122.399180844332) | |||
| 38817 | 38817 | 192889 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2 Rizal St | 10 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6012712.48304 | 2112660.3861 | 37.7816783330348 | -122.39965589769501 | (37.7816783330348, -122.399655897695) | |||
| 38874 | 38874 | 192937 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 394 12th St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008622.94883 | 2108550.9400299997 | 37.770165953233 | -122.413513072694 | (37.770165953233, -122.413513072694) | |||
| 38885 | 38885 | 192859 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 730 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013101.59987 | 2112747.6377 | 37.7819395887803 | -122.398315852113 | (37.7819395887803, -122.398315852113) | |||
| 39347 | 39347 | 202012 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 7 Wheat St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012149.04782 | 2091373.3261400003 | 37.7231972774244 | -122.400109696501 | (37.7231972774244, -122.400109696501) | |||
| 39734 | 39734 | 193027 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1995 Evans Ave | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013681.971030001 | 2099943.16659 | 37.7468136443431 | -122.395410717233 | (37.7468136443431, -122.395410717233) | |||
| 40163 | 40163 | 192887 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2 Rizal St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012749.3000300005 | 2112698.3818900003 | 37.7817847129295 | -122.39953119591699 | (37.7817847129295, -122.399531195917) | |||
| 40287 | 40287 | 193046 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1940 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013882.635980001 | 2099879.24072 | 37.7466492761534 | -122.39471235589501 | (37.7466492761534, -122.394712355895) | |||
| 40398 | 40398 | 246660 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3331 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6009064.11809 | 2099300.57362 | 37.7447913037799 | -122.41133348385401 | (37.7447913037799, -122.411333483854) | |||
| 40590 | 40590 | 208699 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 144 Eucalyptus Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5991017.2717699995 | 2094704.6203400001 | 37.731143287728706 | -122.473400282119 | (37.7311432877287, -122.473400282119) | |||
| 40763 | 40763 | 192884 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2 Rizal St | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012823.35509 | 2112766.95799 | 37.78197713458871 | -122.399279813819 | (37.7819771345887, -122.399279813819) | |||
| 41382 | 41382 | 201297 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 69 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6012679.277000001 | 2092924.5812099997 | 37.7274862575679 | -122.398385577456 | (37.7274862575679, -122.398385577456) | |||
| 41614 | 41614 | 192991 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 547 Texas St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013848.44035 | 2104541.24783 | 37.7594482467606 | -122.39515710393499 | (37.7594482467606, -122.395157103935) | |||
| 41690 | 41690 | 193051 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1998 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013798.463819999 | 2099940.4508 | 37.746812665882295 | -122.39500770316099 | (37.7468126658823, -122.395007703161) | |||
| 41834 | 41834 | 193057 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6014692.79839 | 2099188.96947 | 37.744798946214 | -122.391862616559 | (37.744798946214, -122.391862616559) | |||
| 42251 | 42251 | 192828 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 341 03rd St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6013176.42141 | 2113220.71847 | 37.7832427271154 | -122.398090201402 | (37.7832427271154, -122.398090201402) | |||
| 42390 | 42390 | 193043 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1940 Evans Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6013932.3266199995 | 2099840.86073 | 37.7465466554048 | -122.394537842462 | (37.7465466554048, -122.394537842462) | |||
| 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) | |||
| 43035 | 43035 | 89163 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 370 03rd St | 2 | : 4 | Tree 1 | Private 1 | 16 | 6013087.00779 | 2113212.8469599998 | 37.783216133267295 | -122.39839898634399 | (37.7832161332673, -122.398398986344) | ||||
| 43639 | 43639 | 192858 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 730 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6013118.62459 | 2112768.9430400003 | 37.781999036666605 | -122.39825844929301 | (37.7819990366666, -122.398258449293) | |||
| 45224 | 45224 | 229275 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6010539.7531 | 2103704.20659 | 37.7569653624673 | -122.40654124488998 | (37.7569653624673, -122.40654124489) | |||
| 45327 | 45327 | 192837 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 333 03rd St | 7 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6013024.05275 | 2113381.05786 | 37.7836744943121 | -122.398628594958 | (37.7836744943121, -122.398628594958) | |||
| 46208 | 46208 | 192862 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 50 Tandang Sora St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012647.62536 | 2112650.30778 | 37.781647044707796 | -122.399879568108 | (37.7816470447078, -122.399879568108) | |||
| 46440 | 46440 | 192815 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 666 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6013604.81597 | 2113227.2952099997 | 37.7832846364215 | -122.396608578241 | (37.7832846364215, -122.396608578241) | |||
| 46807 | 46807 | 192881 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2 Rizal St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012880.48921 | 2112819.35511 | 37.7821241890305 | -122.39908583366001 | (37.7821241890305, -122.39908583366) | |||
| 47058 | 47058 | 192845 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 360 03rd St | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6013219.84622 | 2113076.83244 | 37.7828500678048 | -122.397929871179 | (37.7828500678048, -122.397929871179) | |||
| 47135 | 47135 | 192844 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 360 03rd St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6013205.26526 | 2113091.3714900003 | 37.7828891766224 | -122.397981335797 | (37.7828891766224, -122.397981335797) | |||
| 47527 | 47527 | 208697 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 235 Garfield St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5993327.08056 | 2090460.0855900003 | 37.719622316685296 | -122.46510676208099 | (37.7196223166853, -122.465106762081) | |||
| 49315 | 49315 | 192823 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 362 03rd St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6013325.53363 | 2113068.9912799997 | 37.782834423221004 | -122.39756368431001 | (37.782834423221, -122.39756368431) | |||
| 49419 | 49419 | 192830 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 335 03rd St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6013155.18585 | 2113245.64816 | 37.7833099955036 | -122.398165418018 | (37.7833099955036, -122.398165418018) | |||
| 49567 | 49567 | 229267 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 38 Dolores St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004742.44704 | 2107952.0882599996 | 37.7683029968226 | -122.42689304397601 | (37.7683029968226, -122.426893043976) | |||
| 49789 | 49789 | 192986 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 794 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6011815.20163 | 2104707.36031 | 37.7597910737109 | -122.40220076415899 | (37.7597910737109, -122.402200764159) | |||
| 50037 | 50037 | 192933 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1562 11th St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6009029.56571 | 2108557.6713900003 | 37.7702072590867 | -122.41210705911101 | (37.7702072590867, -122.412107059111) | |||
| 50327 | 50327 | 229284 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 13 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 6010501.02754 | 2104377.47084 | 37.758811828913004 | -122.40672261926399 | (37.758811828913, -122.406722619264) | |||
| 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) | |||
| 51790 | 51790 | 193109 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 98 Flora St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6013811.82266 | 2094249.19212 | 37.7311863949379 | -122.39456304774201 | (37.7311863949379, -122.394563047742) | |||
| 52279 | 52279 | 229282 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 11 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6010506.9251 | 2104261.45738 | 37.75849361191379 | -122.40669404691499 | (37.7584936119138, -122.406694046915) | |||
| 52534 | 52534 | 193058 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1601 Evans Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6014802.29213 | 2099111.00932 | 37.7445909618204 | -122.391478555688 | (37.7445909618204, -122.391478555688) | |||
| 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) | |||
| 53305 | 53305 | 208696 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 235 Bright St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5993735.7088 | 2088773.5229599997 | 37.7150149747485 | -122.46357195568399 | (37.7150149747485, -122.463571955684) | |||
| 53486 | 53486 | 192834 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 333 03rd St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6013085.07263 | 2113314.8696 | 37.7834961560649 | -122.398412842187 | (37.7834961560649, -122.398412842187) | |||
| 54858 | 54858 | 208690 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 266 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992479.67005 | 2089630.07877 | 37.7172944179741 | -122.467975588622 | (37.7172944179741, -122.467975588622) | |||
| 55049 | 55049 | 208689 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 455 Vernon St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992461.84626 | 2090851.0446 | 37.720645863902504 | -122.468125963363 | (37.7206458639025, -122.468125963363) |
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");