Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13206 | 13206 | 19929 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 100 STAIRWAY37 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x5 | ||||||||
| 13820 | 13820 | 19930 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 100 STAIRWAY37 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x5 | ||||||||
| 18575 | 18575 | 24589 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 627 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007837.64514 | 2097223.79022 | 37.7390200520275 | -122.41542740826799 | (37.7390200520275, -122.415427408268) | ||
| 19388 | 19388 | 4248 | Permitted Site 1 | Citrus spp :: Lemon: Orange: Lime 278 | 4042 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003611.10848 | 2100422.12603 | 37.747563479279 | -122.43026895055701 | (37.747563479279, -122.430268950557) | |||
| 20634 | 20634 | 19361 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 726 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X4 | 5992071.58242 | 2089871.4738099999 | 37.7179336551788 | -122.469403704826 | (37.7179336551788, -122.469403704826) | |||
| 20992 | 20992 | 28790 | Permitted Site 1 | Citrus spp :: Lemon: Orange: Lime 278 | 2741 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008967.4905 | 2102492.051 | 37.753548970219605 | -122.41189308700599 | (37.7535489702196, -122.411893087006) | |||
| 23650 | 23650 | 43276 | Permitted Site 1 | Citrus spp :: Lemon: Orange: Lime 278 | 693 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 6 | Permit Number 44929 | 6008720.42562 | 2090858.4005900002 | 37.7215916341374 | -122.411925450907 | (37.7215916341374, -122.411925450907) | |
| 24170 | 24170 | 206058 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 95 Marston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5998836.80822 | 2093173.9716299998 | 37.727390192897 | -122.44625681279899 | (37.727390192897, -122.446256812799) | ||||
| 24974 | 24974 | 190080 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 582 Rhode Island St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6011756.74978 | 2105674.08319 | 37.762442216649205 | -122.402470898934 | (37.7624422166492, -122.402470898934) | ||||
| 25014 | 25014 | 190083 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1301 Rhode Island St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6012013.66835 | 2102301.71899 | 37.753196787610996 | -122.40134530296001 | (37.753196787611, -122.40134530296) | |||
| 26641 | 26641 | 225255 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1320 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001957.77456 | 2100174.66464 | 37.7467902224097 | -122.43596836535801 | (37.7467902224097, -122.435968365358) | |||
| 27067 | 27067 | 225239 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 3900 22nd St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6002410.772480001 | 2102995.6148099997 | 37.7545616068455 | -122.43460362076799 | (37.7545616068455, -122.434603620768) | |||
| 28975 | 28975 | 206051 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 280 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5993961.392030001 | 2098930.02147 | 37.7429152361477 | -122.463528556201 | (37.7429152361477, -122.463528556201) | |||
| 29683 | 29683 | 225224 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1100 San Jose Ave | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6004625.78888 | 2096529.6376200002 | 37.7369330160534 | -122.426483127589 | (37.7369330160534, -122.426483127589) | ||||
| 30075 | 30075 | 225253 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010308.48538 | 2103425.73891 | 37.756187811339295 | -122.40732142926599 | (37.7561878113393, -122.407321429266) | |||
| 30743 | 30743 | 247214 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 800 Duboce Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6001844.10288 | 2108295.66302 | 37.769082062429 | -122.43694272143601 | (37.769082062429, -122.436942721436) | |||
| 31364 | 31364 | 225245 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 10 Marsily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004214.66521 | 2095536.9914099998 | 37.7341841842374 | -122.42783385625602 | (37.7341841842374, -122.427833856256) | |||
| 31701 | 31701 | 206055 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 635 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5997884.48996 | 2094964.9541099998 | 37.7322533730818 | -122.44967796786699 | (37.7322533730818, -122.449677967867) | ||||
| 31982 | 31982 | 175855 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 667 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6001081.321380001 | 2089927.90496 | 37.718605160981795 | -122.438265098081 | (37.7186051609818, -122.438265098081) | ||||
| 34804 | 34804 | 200153 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2815 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014807.9007 | 2090650.8255 | 37.721361325093206 | -122.390868013009 | (37.7213613250932, -122.390868013009) | |||
| 35739 | 35739 | 126050 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2743 Baker St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 5999540.91098 | 2118277.28381 | 37.7963578318958 | -122.44562718666799 | (37.7963578318958, -122.445627186668) | |||
| 35915 | 35915 | 124268 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 5 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5994869.20256 | 2114987.30692 | 37.7870566305859 | -122.461553523605 | (37.7870566305859, -122.461553523605) | ||||
| 37065 | 37065 | 190085 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1500 Rankin St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012534.55717 | 2096576.85892 | 37.7375065919613 | -122.399142135727 | (37.7375065919613, -122.399142135727) | ||||
| 37576 | 37576 | 175870 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 24 Tomaso Ct | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6009222.043409999 | 2086480.3970700002 | 37.7095986701246 | -122.409882595915 | (37.7095986701246, -122.409882595915) | |||
| 39889 | 39889 | 175866 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 771 London St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6000758.69857 | 2089409.69112 | 37.7171639074676 | -122.439343145965 | (37.7171639074676, -122.439343145965) | ||||
| 40196 | 40196 | 190068 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 800 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015109.8223 | 2105343.63825 | 37.7617215044683 | -122.390850665232 | (37.7617215044683, -122.390850665232) | |||
| 40862 | 40862 | 206068 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 519 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5997973.91995 | 2095235.35162 | 37.73300093634779 | -122.449388264768 | (37.7330009363478, -122.449388264768) | ||||
| 42059 | 42059 | 120881 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 38 Diana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6013306.7668699995 | 2094056.19974 | 37.7306283862811 | -122.396295606056 | (37.7306283862811, -122.396295606056) | |||
| 42064 | 42064 | 225229 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 78 Norwich St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6008929.6185 | 2099480.7047099997 | 37.745278359507296 | -122.411811285588 | (37.7452783595073, -122.411811285588) | ||||
| 43711 | 43711 | 225259 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 500 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003000.58316 | 2103896.97694 | 37.757069997691104 | -122.432628282396 | (37.7570699976911, -122.432628282396) | |||
| 44016 | 44016 | 206056 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 334 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5997879.17976 | 2093831.3311400001 | 37.7291404093781 | -122.449614668195 | (37.7291404093781, -122.449614668195) | ||||
| 47514 | 47514 | 225238 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 3911 21st St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6002335.3278 | 2103527.7741799997 | 37.7560185058709 | -122.434902583282 | (37.7560185058709, -122.434902583282) | ||||
| 48062 | 48062 | 126043 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2220 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 6ft | 5999570.11986 | 2120888.4985700003 | 37.803529195883605 | -122.44571399729999 | (37.8035291958836, -122.4457139973) | |||
| 48554 | 48554 | 225257 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 519 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007846.926580001 | 2096365.8882400002 | 37.736664963218104 | -122.415334600937 | (37.7366649632181, -122.415334600937) | |||
| 49514 | 49514 | 190071 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 760 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6012081.41801 | 2104921.5268599996 | 37.7603939837179 | -122.40129509739799 | (37.7603939837179, -122.401295097398) | |||
| 49717 | 49717 | 31828 | Permitted Site 1 | Citrus spp :: Lemon: Orange: Lime 278 | 219 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35287 | 6009577.38465 | 2109112.56676 | 37.7717615951562 | -122.41025133326 | (37.7717615951562, -122.41025133326) | |
| 50796 | 50796 | 225251 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 20 Ohlone Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 1 | Width 2ft | 6002182.75585 | 2096407.15248 | 37.736458290902796 | -122.43492101042 | (37.7364582909028, -122.43492101042) | |||
| 50799 | 50799 | 190084 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1508 Quint St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6013166.16952 | 2096317.15431 | 37.736828675801796 | -122.396940135793 | (37.7368286758018, -122.396940135793) | |||
| 51884 | 51884 | 206052 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 280 Granville Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5993969.3085 | 2098924.18478 | 37.742899666187704 | -122.463500759964 | (37.7428996661877, -122.463500759964) | |||
| 52199 | 52199 | 206073 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 277 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6000260.82951 | 2094932.6976400001 | 37.7323004714781 | -122.44146013207799 | (37.7323004714781, -122.441460132078) | |||
| 52971 | 52971 | 126040 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2390 Bay St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 4ft | 5999373.78481 | 2120164.23699 | 37.801529357251205 | -122.446341287942 | (37.8015293572512, -122.446341287942) | |||
| 53956 | 53956 | 225243 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 107 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007392.00183 | 2097678.37759 | 37.7402431902648 | -122.417000443041 | (37.7402431902648, -122.417000443041) | |||
| 54468 | 54468 | 225246 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 121 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005601.9435 | 2096425.27708 | 37.7367015997901 | -122.423100707241 | (37.7367015997901, -122.423100707241) | |||
| 55063 | 55063 | 246615 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 199 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6009291.89152 | 2099148.30675 | 37.7443859847297 | -122.41053513320601 | (37.7443859847297, -122.410535133206) | |||
| 55287 | 55287 | 225249 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 69 Levant St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000369.03811 | 2106325.1376 | 37.7635875410605 | -122.441903416934 | (37.7635875410605, -122.441903416934) | |||
| 55484 | 55484 | 175857 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 200 Concord St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5999895.81831 | 2087081.09884 | 37.7107209745665 | -122.44215864451701 | (37.7107209745665, -122.442158644517) | |||
| 55958 | 55958 | 126041 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 45 Prado St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6000916.29737 | 2121252.94807 | 37.804606643937795 | -122.44108166410601 | (37.8046066439378, -122.441081664106) | |||
| 56361 | 56361 | 206053 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 60 Paradise Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6000995.02374 | 2096057.37841 | 37.7354303837986 | -122.43900243332199 | (37.7354303837986, -122.439002433322) | |||
| 56675 | 56675 | 225254 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1320 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001957.3419 | 2100185.7696700003 | 37.746820689621 | -122.435970655938 | (37.746820689621, -122.435970655938) | |||
| 57128 | 57128 | 175868 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 775 Italy Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6000760.37333 | 2089426.49895 | 37.7172101532979 | -122.43933856122 | (37.7172101532979, -122.43933856122) | ||||
| 58167 | 58167 | 201927 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 118 Elmira St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 9ft | 6011149.33758 | 2096046.2397099999 | 37.735972330566 | -122.403894190267 | (37.735972330566, -122.403894190267) | |||
| 58465 | 58465 | 225227 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2700 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 7ft | 6009911.03097 | 2103403.5616 | 37.756104664524 | -122.408694403538 | (37.756104664524, -122.408694403538) | |||
| 60047 | 60047 | 206066 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 162 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6000346.07422 | 2095252.50722 | 37.7331834501598 | -122.441188359671 | (37.7331834501598, -122.441188359671) | |||
| 60929 | 60929 | 126039 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 99 Moulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002938.43109 | 2119403.29701 | 37.7996429564285 | -122.433951590696 | (37.7996429564285, -122.433951590696) | |||
| 61163 | 61163 | 126038 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 99 Moulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002916.41675 | 2119400.10918 | 37.799632954155996 | -122.434027540244 | (37.799632954156, -122.434027540244) | |||
| 61182 | 61182 | 248083 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 31 Montcalm St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010653.71359 | 2100266.61885 | 37.747532879848 | -122.40590497544301 | (37.747532879848, -122.405904975443) | ||||
| 61873 | 61873 | 225226 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 400 Prospect Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6006231.66625 | 2097599.69124 | 37.7399617950961 | -122.42100683908801 | (37.7399617950961, -122.421006839088) | ||||
| 62707 | 62707 | 225222 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1100 San Jose Ave | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6004726.76643 | 2096641.96785 | 37.7372471573321 | -122.426141997676 | (37.7372471573321, -122.426141997676) | ||||
| 62955 | 62955 | 190086 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1500 Rankin St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012527.48639 | 2096566.74721 | 37.73747843327921 | -122.399165873323 | (37.7374784332792, -122.399165873323) | ||||
| 63180 | 63180 | 206070 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 295 Byxbee St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5991928.73882 | 2090419.4861700002 | 37.719430107299104 | -122.469937326573 | (37.7194301072991, -122.469937326573) | |||
| 63573 | 63573 | 175867 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 775 Italy Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6000771.54844 | 2089421.64361 | 37.717197457573796 | -122.439299586413 | (37.7171974575738, -122.439299586413) | ||||
| 64326 | 64326 | 206065 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 615 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993483.713880001 | 2089945.91945 | 37.718219571255396 | -122.464528027661 | (37.7182195712554, -122.464528027661) | |||
| 65906 | 65906 | 206063 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 498 Vernon St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5992504.72929 | 2091166.3021 | 37.721513960570995 | -122.468000650902 | (37.721513960571, -122.468000650902) | |||
| 67324 | 67324 | 225232 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 4042 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6003603.90772 | 2100421.01325 | 37.7475600159783 | -122.43029377096 | (37.7475600159783, -122.43029377096) | |||
| 68545 | 68545 | 78160 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 759 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 2 | 5985680.33145 | 2110726.12873 | 37.774823470979904 | -122.49303050914499 | (37.7748234709799, -122.493030509145) | ||
| 69314 | 69314 | 225236 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1803 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6002644.30116 | 2100266.72418 | 37.747081973248 | -122.43360100350401 | (37.747081973248, -122.433601003504) | |||
| 70098 | 70098 | 124266 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1 03rd Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5994874.78871 | 2115033.3872700003 | 37.7871834762672 | -122.461537538969 | (37.7871834762672, -122.461537538969) | ||||
| 70532 | 70532 | 190081 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1700x Quesada Ave | 44 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6014340.94145 | 2095303.98967 | 37.734112055908604 | -122.392807541432 | (37.7341120559086, -122.392807541432) | ||||
| 71262 | 71262 | 225252 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1331 Stevenson St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6006271.29436 | 2108923.54997 | 37.7710567254041 | -122.421673906749 | (37.7710567254041, -122.421673906749) | |||
| 73110 | 73110 | 126046 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2100 Jefferson St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999077.01355 | 2121162.9453 | 37.804254586342 | -122.447440173138 | (37.804254586342, -122.447440173138) | ||||
| 74025 | 74025 | 190075 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2100 Thomas Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012128.4157300005 | 2095931.29338 | 37.73571136258 | -122.40050103288901 | (37.73571136258, -122.400501032889) | ||||
| 74497 | 74497 | 190073 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1700x Quesada Ave | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6014423.28579 | 2095240.49948 | 37.7339422980969 | -122.392518409417 | (37.7339422980969, -122.392518409417) | ||||
| 74735 | 74735 | 225228 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 3738 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005391.9381099995 | 2104322.40887 | 37.7583734597889 | -122.424388315175 | (37.7583734597889, -122.424388315175) | |||
| 75071 | 75071 | 51057 | Permitted Site 1 | Citrus spp :: Lemon: Orange: Lime 278 | 985 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2004 12:00:00 AM | 3 | Permit Number 47526 | 6011681.98147 | 2090386.14525 | 37.7204606269314 | -122.40165491166901 | (37.7204606269314, -122.401654911669) | ||
| 75824 | 75824 | 225260 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 519 Anderson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007845.429719999 | 2096352.85409 | 37.7366290901675 | -122.415338853806 | (37.7366290901675, -122.415338853806) | |||
| 76223 | 76223 | 190074 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2100 Thomas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6012142.29402 | 2095921.52893 | 37.735685325408504 | -122.40045236430201 | (37.7356853254085, -122.400452364302) | ||||
| 120432 | 120432 | 225258 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 127 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008308.74724 | 2097822.25905 | 37.7406897837182 | -122.41384087018 | (37.7406897837182, -122.41384087018) | |||
| 129612 | 129612 | 126048 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1206 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006555.849119999 | 2120122.9781 | 37.8018236396965 | -122.42148512554199 | (37.8018236396965, -122.421485125542) | |||
| 130637 | 130637 | 225244 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 3246 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6007871.93073 | 2105631.804 | 37.762108488138104 | -122.415904101093 | (37.7621084881381, -122.415904101093) | |||
| 132186 | 132186 | 225235 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 915 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6009422.299980001 | 2103692.31974 | 37.7568701440604 | -122.41040499501699 | (37.7568701440604, -122.410404995017) | |||
| 132962 | 132962 | 175854 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 13 Liebig St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5995905.68343 | 2086266.21958 | 37.708255296101896 | -122.455890498056 | (37.7082552961019, -122.455890498056) | |||
| 133012 | 133012 | 225225 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 400 Prospect Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6006245.45264 | 2097624.33483 | 37.7400302380064 | -122.420960920629 | (37.7400302380064, -122.420960920629) | ||||
| 133049 | 133049 | 126042 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2800 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 5999171.85712 | 2118415.39341 | 37.7967159671222 | -122.44691412908999 | (37.7967159671222, -122.44691412909) | |||
| 134673 | 134673 | 126044 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2220 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5999556.0716699995 | 2120885.8428700003 | 37.80352110196579 | -122.44576242041401 | (37.8035211019658, -122.445762420414) | |||
| 136096 | 136096 | 175853 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 190 Foote Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998657.742219999 | 2088350.87676 | 37.7141368596094 | -122.446528992614 | (37.7141368596094, -122.446528992614) | |||
| 136678 | 136678 | 190069 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 128 Texas St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 6013688.61467 | 2106365.60612 | 37.764448645507706 | -122.39583770005699 | (37.7644486455077, -122.395837700057) | |||
| 137788 | 137788 | 126037 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 99 Moulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002876.52339 | 2119394.71062 | 37.799615867029296 | -122.434165199478 | (37.7996158670293, -122.434165199478) | |||
| 139006 | 139006 | 5270 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 2035X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6001239.67806 | 2112801.7990200003 | 37.781420405732604 | -122.439356428701 | (37.7814204057326, -122.439356428701) | |||
| 146517 | 146517 | 69404 | Permitted Site 1 | Citrus spp :: Lemon: Orange: Lime 278 | 1222 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 3 | Permit Number 33508 | 6001053.3178900005 | 2087351.84237 | 37.711530275369 | -122.438177455546 | (37.711530275369, -122.438177455546) | |
| 147175 | 147175 | 225231 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 78 Norwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6008954.26866 | 2099481.98448 | 37.7452832563214 | -122.411726139547 | (37.7452832563214, -122.411726139547) | ||||
| 147232 | 147232 | 190067 | DPW Maintained 3 | Citrus spp :: Lemon: Orange: Lime 278 | 1150x Tennessee St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6015567.2875 | 2103497.11447 | 37.7566767169834 | -122.389139526978 | (37.7566767169834, -122.389139526978) | |||
| 148237 | 148237 | 206054 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 118 Ridgewood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5996816.83473 | 2094522.6364799999 | 37.730977735128995 | -122.453337151896 | (37.730977735129, -122.453337151896) | |||
| 148269 | 148269 | 175865 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 771 London St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6000753.767080001 | 2089411.77455 | 37.717169347454295 | -122.43936034100099 | (37.7171693474543, -122.439360341001) | ||||
| 150524 | 150524 | 139566 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2003 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001238.1316 | 2112803.1201 | 37.7814239450757 | -122.439361873414 | (37.7814239450757, -122.439361873414) | |||
| 151391 | 151391 | 175856 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 166 Newton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001031.73098 | 2087649.99539 | 37.712347709655 | -122.438273411393 | (37.712347709655, -122.438273411393) | |||
| 151964 | 151964 | 225248 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 310 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6003531.80374 | 2106438.35336 | 37.764078120337 | -122.430972492892 | (37.764078120337, -122.430972492892) | |||
| 152300 | 152300 | 175869 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 24 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6009229.76902 | 2086501.99732 | 37.7096584129814 | -122.409857418496 | (37.7096584129814, -122.409857418496) | |||
| 153417 | 153417 | 225247 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 4316 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001799.396240001 | 2101199.8384700003 | 37.7495961080861 | -122.43658938861601 | (37.7495961080861, -122.436589388616) | |||
| 153832 | 153832 | 126045 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 2100 Jefferson St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5999106.15864 | 2121169.1947 | 37.8042734109522 | -122.44733976473302 | (37.8042734109522, -122.447339764733) | ||||
| 154273 | 154273 | 190078 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 1700 Armstrong Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6013893.72787 | 2092886.08627 | 37.7274481362093 | -122.394184488917 | (37.7274481362093, -122.394184488917) |
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");