Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13880 | 13880 | 3671 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 107 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017047.36981 | 2098978.83891 | 37.7443524031345 | -122.38370624765 | (37.7443524031345, -122.38370624765) | |||
| 13488 | 13488 | 3672 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 108 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6017032.375109999 | 2098991.89434 | 37.7443874218329 | -122.383759005485 | (37.7443874218329, -122.383759005485) | |||
| 4976 | 4976 | 3673 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.6203400004 | 37.7444159222737 | -122.38381923847601 | (37.7444159222737, -122.383819238476) | ||
| 4971 | 4971 | 3674 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 110 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:22:00 AM | 3 | 3X3 | 6016998.30504 | 2099015.89853 | 37.7444514490906 | -122.383878484902 | (37.7444514490906, -122.383878484902) | ||
| 15773 | 15773 | 3675 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 111 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016978.81066 | 2099030.1280400003 | 37.74448944274229 | -122.383946883753 | (37.7444894427423, -122.383946883753) | ||
| 4933 | 4933 | 3676 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 112 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:24:00 AM | 3 | 3X3 | 6016964.487509999 | 2099042.50937 | 37.74452264751721 | -122.38399727276101 | (37.7445226475172, -122.383997272761) | ||
| 16743 | 16743 | 3677 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 113 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3x3 | 6016945.8178 | 2099054.7063700003 | 37.7445551058345 | -122.38406267865801 | (37.7445551058345, -122.384062678658) | ||
| 16591 | 16591 | 3678 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 114 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016900.5532599995 | 2099090.71493 | 37.7446514753884 | -122.384221703094 | (37.7446514753884, -122.384221703094) | |||
| 14381 | 14381 | 3679 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 115 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6016884.1224 | 2099103.28613 | 37.744685084848896 | -122.384279393677 | (37.7446850848489, -122.384279393677) | |||
| 13776 | 13776 | 3680 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 116 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016866.69606 | 2099115.15257 | 37.7447167041098 | -122.384340477447 | (37.7447167041098, -122.384340477447) | |||
| 4959 | 4959 | 3681 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100X Cargo Way | 117 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/02/2017 03:27:00 PM | 3 | 3X3 | 6016866.9573099995 | 2099120.49255 | 37.7447313810499 | -122.384339945926 | (37.7447313810499, -122.384339945926) | ||
| 84902 | 84902 | 3682 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 118 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 15305 | 15305 | 3683 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 119 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016838.589430001 | 2099135.269 | 37.7447703855426 | -122.384439066524 | (37.7447703855426, -122.384439066524) | |||
| 15340 | 15340 | 3684 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 18 | 3X3 | 6016817.82171 | 2099151.7639099997 | 37.744814528777795 | -122.384512026728 | (37.7448145287778, -122.384512026728) | |||
| 13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
| 118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 99473 | 99473 | 3689 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127726 | 127726 | 3690 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127580 | 127580 | 3691 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 83650 | 83650 | 4016 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 700X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/27/2000 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.38278818869301 | (37.7506230149756, -122.382788188693) | ||
| 81407 | 81407 | 4017 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 700X Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/01/1995 12:00:00 AM | 3 | 3X3 | 6017358.6966724 | 2101256.2875006 | 37.7506230149756 | -122.38278818869301 | (37.7506230149756, -122.382788188693) | ||
| 119509 | 119509 | 15086 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | |||
| 106752 | 106752 | 15087 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | |||
| 114926 | 114926 | 15088 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | |||
| 79277 | 79277 | 15089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | |||
| 15616 | 15616 | 22077 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 3x3 | 6015962.924330001 | 2100554.9145299997 | 37.748619977641 | -122.387566000296 | (37.748619977641, -122.387566000296) | ||
| 16475 | 16475 | 22078 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015962.98615 | 2100528.59711 | 37.7485477189018 | -122.38756395072399 | (37.7485477189018, -122.387563950724) | ||
| 16832 | 16832 | 22079 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015964.59871 | 2100502.1098700003 | 37.7484750797647 | -122.38755652683201 | (37.7484750797647, -122.387556526832) | ||
| 14769 | 14769 | 22080 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015965.08966 | 2100473.24055 | 37.748395837805504 | -122.387552815329 | (37.7483958378055, -122.387552815329) | ||
| 16808 | 16808 | 22081 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 3X3 | 6015967.5851300005 | 2100424.02181 | 37.7482608315927 | -122.387540752722 | (37.7482608315927, -122.387540752722) | ||
| 16801 | 16801 | 22083 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 6015972.44529 | 2100358.98918 | 37.7480825346922 | -122.38751940998999 | (37.7480825346922, -122.38751940999) | |||
| 97953 | 97953 | 22088 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 6016008.97261 | 2099546.3179900004 | 37.7458531309618 | -122.387336417288 | (37.7458531309618, -122.387336417288) | ||||
| 80797 | 80797 | 22089 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6016009.5802 | 2099538.74144 | 37.74583236096979 | -122.387333787882 | (37.7458323609698, -122.387333787882) | |||
| 116070 | 116070 | 22090 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/03/1995 12:00:00 AM | 3 | 3X3 | 6016009.63374 | 2099530.63966 | 37.745810118120104 | -122.387333037689 | (37.7458101181201, -122.387333037689) | ||
| 89420 | 89420 | 22091 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6016010.69646 | 2099489.56952 | 37.7456974068511 | -122.387326498503 | (37.7456974068511, -122.387326498503) | ||
| 106525 | 106525 | 22092 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3 | 3X3 | 6016011.14545 | 2099476.0569599997 | 37.74566032901671 | -122.387324003523 | (37.7456603290167, -122.387324003523) | |||
| 86410 | 86410 | 22093 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 3400X 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3 | 3X3 | 6016015.959869999 | 2099423.81611 | 37.745517153053996 | -122.38730371236299 | (37.745517153054, -122.387303712363) | |||
| 83584 | 83584 | 22094 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3 | 3X3 | 6016017.00918 | 2099367.08567 | 37.745361441081705 | -122.38729612741999 | (37.7453614410817, -122.38729612742) | |||
| 122100 | 122100 | 22095 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6016014.437030001 | 2099301.1365900002 | 37.745180216060604 | -122.387300422076 | (37.7451802160606, -122.387300422076) | |||
| 104079 | 104079 | 22096 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3400X 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/16/1995 12:00:00 AM | 3 | 3X3 | 6016015.13995 | 2099327.44393 | 37.7452524895199 | -122.38729982623 | (37.7452524895199, -122.38729982623) | ||
| 85025 | 85025 | 25615 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014865.13601 | 2116922.0830099997 | 37.793499734993894 | -122.39250686670401 | (37.7934997349939, -122.392506866704) | ||
| 124827 | 124827 | 25616 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014879.459009999 | 2116905.15601 | 37.7934540527819 | -122.392456123078 | (37.7934540527819, -122.392456123078) | ||
| 141109 | 141109 | 25617 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014889.87501 | 2116893.4380099997 | 37.7934224562927 | -122.39241926264401 | (37.7934224562927, -122.392419262644) | ||
| 90808 | 90808 | 25618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014901.59401 | 2116884.32301 | 37.7933980793798 | -122.392378075877 | (37.7933980793798, -122.392378075877) | ||
| 108768 | 108768 | 25619 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014956.28201 | 2116834.8440099997 | 37.7932652581895 | -122.392185387885 | (37.7932652581895, -122.392185387885) | ||
| 111817 | 111817 | 25620 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014974.51101 | 2116817.91701 | 37.793219792707 | -122.392121129495 | (37.793219792707, -122.392121129495) | ||
| 92649 | 92649 | 25621 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014992.74001 | 2116800.99001 | 37.7931743271891 | -122.39205687118401 | (37.7931743271891, -122.392056871184) | ||
| 146287 | 146287 | 25622 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015012.27101 | 2116778.85401 | 37.7931146312154 | -122.391987743488 | (37.7931146312154, -122.391987743488) | ||
| 85287 | 85287 | 25623 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015040.91701 | 2116748.90601 | 37.793033991285796 | -122.391886530718 | (37.7930339912858, -122.391886530718) | ||
| 125945 | 125945 | 25624 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015065.65701 | 2116724.16701 | 37.7929674371429 | -122.391799197633 | (37.7929674371429, -122.391799197633) | ||
| 114066 | 114066 | 25625 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015102.11501 | 2116685.10401 | 37.792862203009996 | -122.39167031755501 | (37.79286220301, -122.391670317555) | ||
| 83992 | 83992 | 25626 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015143.78201 | 2116618.69801 | 37.7926821803134 | -122.391521501856 | (37.7926821803134, -122.391521501856) | ||
| 114711 | 114711 | 25627 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015154.1980099995 | 2116593.9580099997 | 37.7926148281307 | -122.39148373141501 | (37.7926148281307, -122.391483731415) | ||
| 2027 | 2027 | 25628 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014034.02503 | 2117986.25531 | 37.796375512586 | -122.39545718430401 | (37.796375512586, -122.395457184304) | ||
| 8064 | 8064 | 25629 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014059.75449 | 2117949.14567 | 37.79627504929729 | -122.39536555327801 | (37.7962750492973, -122.395365553278) | ||
| 8404 | 8404 | 25630 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014084.49775 | 2117912.38554 | 37.7961754907607 | -122.395277359473 | (37.7961754907607, -122.395277359473) | ||
| 6610 | 6610 | 25631 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014105.621619999 | 2117876.68788 | 37.7960786481665 | -122.395201764263 | (37.7960786481665, -122.395201764263) | ||
| 140032 | 140032 | 25632 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 117942 | 117942 | 25633 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 125804 | 125804 | 25634 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 114362 | 114362 | 25635 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 650X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 104379 | 104379 | 25636 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 80951 | 80951 | 25637 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 93489 | 93489 | 25638 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 109659 | 109659 | 25639 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 112195 | 112195 | 25640 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 99713 | 99713 | 25641 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 93341 | 93341 | 25642 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 113255 | 113255 | 25643 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 126813 | 126813 | 25644 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 138363 | 138363 | 25645 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 104738 | 104738 | 25646 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 125734 | 125734 | 25647 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 550X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 95459 | 95459 | 25648 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 114334 | 114334 | 25649 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 88104 | 88104 | 25650 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 80608 | 80608 | 25651 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90272 | 90272 | 25652 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 85455 | 85455 | 25653 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 102163 | 102163 | 25654 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 81058 | 81058 | 25655 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 138724 | 138724 | 25656 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 93827 | 93827 | 25657 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 121024 | 121024 | 25658 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 106687 | 106687 | 25659 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90157 | 90157 | 25660 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 94501 | 94501 | 25661 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 93368 | 93368 | 25662 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 98351 | 98351 | 25663 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 120964 | 120964 | 25664 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 111381 | 111381 | 25665 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 126612 | 126612 | 25666 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 113257 | 113257 | 25667 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 1379 | 1379 | 25668 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014174.0749699995 | 2117868.41683 | 37.796059744425996 | -122.394964320767 | (37.796059744426, -122.394964320767) | ||
| 89592 | 89592 | 25669 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 95406 | 95406 | 25670 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 5331 | 5331 | 25671 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014100.8579 | 2117974.29057 | 37.7963463772386 | -122.395225088169 | (37.7963463772386, -122.395225088169) | ||
| 5927 | 5927 | 25672 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 450X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 36 | 15 | 6014076.201780001 | 2118013.23421 | 37.796451936061295 | -122.39531313361799 | (37.7964519360613, -122.395313133618) |
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");