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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13011 | 13011 | 121633 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 715 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778948 | 6002248.64047 | 2088586.4317299998 | 37.7149880967002 | -122.43413431136001 | (37.7149880967002, -122.43413431136) | |
| 13496 | 13496 | 25978 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2027 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/19/1997 12:00:00 AM | 8 | 6x9 | 6012757.293869999 | 2097148.7726200002 | 37.7390893573798 | -122.39841214252701 | (37.7390893573798, -122.398412142527) | ||
| 13588 | 13588 | 26008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1625 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6014811.10476 | 2095618.3620200001 | 37.7350013613099 | -122.391203993568 | (37.7350013613099, -122.391203993568) | |||
| 13630 | 13630 | 49513 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1648@3rd ST Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | Permit Number 46418 | 6014785.81315318 | 2094304.60337815 | 37.731392643231295 | -122.391199634158 | (37.7313926432313, -122.391199634158) | |||
| 14318 | 14318 | 17462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2022 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6012632.03621 | 2096963.3752099997 | 37.7385733165067 | -122.398832221241 | (37.7385733165067, -122.398832221241) | |||
| 14764 | 14764 | 31856 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 44 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 8 | 3x3 | Permit Number 35302 | 6009920.26283 | 2110981.2883599997 | 37.7769118830094 | -122.40919717941401 | (37.7769118830094, -122.409197179414) |
| 14881 | 14881 | 33084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1996 12:00:00 AM | Permit Number 37336 | |||||||||
| 14939 | 14939 | 6391 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 16 Espanola St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 3X3 | 6018056.47068 | 2094273.68663 | 37.7314887164161 | -122.379890092347 | (37.7314887164161, -122.379890092347) | ||
| 14968 | 14968 | 26618 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1295 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011596.48977 | 2093221.8488599998 | 37.7282421152608 | -122.402149690774 | (37.7282421152608, -122.402149690774) | |||
| 15400 | 15400 | 51397 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 20 Ringold St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 5 | 2x3 | Permit Number 47723 | 6009698.00166 | 2110029.82687 | 37.77428693821211 | -122.409898870931 | (37.7742869382121, -122.409898870931) |
| 16028 | 16028 | 11414 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1486 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6016137.01095 | 2096800.6040700001 | 37.738321052161005 | -122.386702239228 | (37.738321052161, -122.386702239228) | |||
| 16482 | 16482 | 11411 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1482 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1992 12:00:00 AM | 6 | 3X4 | 6016167.7351400005 | 2096777.3502099998 | 37.738258902726 | -122.38659438804599 | (37.738258902726, -122.386594388046) | ||
| 16626 | 16626 | 39265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 540 Delancey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 8 | 3x3 | Permit Number 41406 | 6015189.334319999 | 2113651.1602 | 37.78453653049 | -122.391156367288 | (37.78453653049, -122.391156367288) |
| 16805 | 16805 | 25996 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1773 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1997 12:00:00 AM | 3 | 3X3 | 6014137.90687 | 2096120.20835 | 37.7363419456235 | -122.39356660700899 | (37.7363419456235, -122.393566607009) | ||
| 16872 | 16872 | 42242 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 546x Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 6 | 2x2 | Permit Number 42491 | 6010065.33098 | 2111880.30804 | 37.779388506222 | -122.408758782403 | (37.779388506222, -122.408758782403) | |
| 16894 | 16894 | 26124 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1439 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015892.5497 | 2094809.562 | 37.732840515342104 | -122.387408617446 | (37.7328405153421, -122.387408617446) | |||
| 16930 | 16930 | 25410 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 153 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/22/1996 12:00:00 AM | 3 | 3X3 | 6005712.73498 | 2108443.02914 | 37.769705817804606 | -122.423571815294 | (37.7697058178046, -122.423571815294) | ||
| 17119 | 17119 | 32210 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 85 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2016 12:00:00 AM | 3 | 3x6 | Permit Number 778854 | 6009682.7318 | 2099892.2355400003 | 37.746450553849705 | -122.40923616951599 | (37.7464505538497, -122.409236169516) | |
| 17368 | 17368 | 31107 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 237 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1995 12:00:00 AM | 12 | 2x9 | Permit Number 34836 | 5998741.10559 | 2093696.6729599999 | 37.7288199422639 | -122.44662524706101 | (37.7288199422639, -122.446625247061) | |
| 17392 | 17392 | 10106 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 785 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005679.329609999 | 2104414.6071 | 37.7586428391006 | -122.42340094141399 | (37.7586428391006, -122.423400941414) | |||
| 17636 | 17636 | 10167 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1021 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005764.985230001 | 2102811.5808900003 | 37.7542461363638 | -122.422990770503 | (37.7542461363638, -122.422990770503) | |||
| 17693 | 17693 | 5140 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2922 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2011 12:00:00 AM | 3 | 3x3 | 6002319.208819999 | 2095185.9682200002 | 37.7331129460068 | -122.43436195314399 | (37.7331129460068, -122.434361953144) | ||
| 17729 | 17729 | 10111 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 817 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005691.67507 | 2104204.22323 | 37.758065870971706 | -122.423343289458 | (37.7580658709717, -122.423343289458) | |||
| 17743 | 17743 | 9991 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 43 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6005443.377280001 | 2108628.68203 | 37.7702003684767 | -122.424516723968 | (37.7702003684767, -122.424516723968) | |||
| 17839 | 17839 | 45141 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1300 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/2001 12:00:00 AM | Permit Number 43998 | 6000329.1714268 | 2109256.8846269 | 37.7716351145449 | -122.442251776367 | (37.7716351145449, -122.442251776367) | ||
| 17861 | 17861 | 36571 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 193 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39434 | 6006550.67564365 | 2097394.54535781 | 37.739416487692 | -122.41988928119801 | (37.739416487692, -122.419889281198) | ||
| 17879 | 17879 | 68381 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 42 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32206 | 5999268.74613245 | 2105519.44927205 | 37.76131256253829 | -122.445651023552 | (37.7613125625383, -122.445651023552) | ||
| 18134 | 18134 | 28387 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1271 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2003 12:00:00 AM | 3 | 3X3 | 6004513.78886 | 2101505.14883 | 37.7505882968197 | -122.427224669004 | (37.7505882968197, -122.427224669004) | ||
| 18253 | 18253 | 4301 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4374 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001502.87912 | 2100307.76951 | 37.7471298441855 | -122.43755087718 | (37.7471298441855, -122.43755087718) | |||
| 18482 | 18482 | 50084 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 163 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46816 | 5992385.51984068 | 2098065.73695017 | 37.7404512063716 | -122.468914554715 | (37.7404512063716, -122.468914554715) | ||
| 18523 | 18523 | 18424 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 974 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6010455.61637 | 2103584.4912099997 | 37.7566319433297 | -122.40682378579099 | (37.7566319433297, -122.406823785791) | |||
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 18880 | 18880 | 25589 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1380X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 6009160.7320011 | 2097455.9675674997 | 37.7397318376167 | -122.410869155933 | (37.7397318376167, -122.410869155933) | |||
| 18906 | 18906 | 5095 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2611 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2004 12:00:00 AM | 6 | 3X3 | 6002301.7516 | 2096545.88638 | 37.7368459778655 | -122.43451950896099 | (37.7368459778655, -122.434519508961) | ||
| 18974 | 18974 | 10193 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1170 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2x2 | 6005736.259869999 | 2102154.58599 | 37.752440559408896 | -122.42304341594699 | (37.7524405594089, -122.423043415947) | |||
| 19048 | 19048 | 10142 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 915 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2x2 | 6005723.61297 | 2103645.6305400003 | 37.7565339082426 | -122.42319312877599 | (37.7565339082426, -122.423193128776) | |||
| 19389 | 19389 | 9994 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 102 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005389.27087 | 2108406.08421 | 37.7695861126487 | -122.424688040346 | (37.7695861126487, -122.424688040346) | |||
| 19412 | 19412 | 68594 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1776 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1993 12:00:00 AM | Permit Number 32496 | 5991255.24615708 | 2103348.30667764 | 37.754890406441895 | -122.47320772508499 | (37.7548904064419, -122.473207725085) | ||
| 19522 | 19522 | 17054 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1267 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000942.0344 | 2109636.8826 | 37.77271340359871 | -122.44015910616301 | (37.7727134035987, -122.440159106163) | |||
| 19736 | 19736 | 121676 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 65 Sotelo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993867.0 | 2101351.0 | 37.7495571916966 | -122.464030639739 | (37.7495571916966, -122.464030639739) | ||||
| 19839 | 19839 | 46807 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 San Felipe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | Permit Number 44891 | 5994047.88467272 | 2095052.68932043 | 37.7322740285646 | -122.46294824520201 | (37.7322740285646, -122.462948245202) | ||
| 19892 | 19892 | 10082 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 635 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005631.678069999 | 2105272.5638099997 | 37.7609958972634 | -122.42362674139 | (37.7609958972634, -122.42362674139) | |||
| 19926 | 19926 | 10117 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 845 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005699.222580001 | 2104067.01691 | 37.757689560440795 | -122.42330743349301 | (37.7576895604408, -122.423307433493) | |||
| 19941 | 19941 | 28386 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2749 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 9 | 3X3 | 6009842.67473 | 2101317.3868299997 | 37.750372664569504 | -122.408783629764 | (37.7503726645695, -122.408783629764) | ||
| 20053 | 20053 | 5099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2621 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002328.495730001 | 2096416.0838900001 | 37.736491088285796 | -122.434417765086 | (37.7364910882858, -122.434417765086) | |||
| 20087 | 20087 | 4439 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1302 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004459.83721 | 2101280.4453 | 37.749968261937106 | -122.42739523262699 | (37.7499682619371, -122.427395232627) | |||
| 20164 | 20164 | 8289 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 50 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995199.8326 | 2099398.11528 | 37.7442717834334 | -122.459280291049 | (37.7442717834334, -122.459280291049) | |||
| 20450 | 20450 | 10113 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005696.52511 | 2104103.91625 | 37.757790725171 | -122.423319385483 | (37.757790725171, -122.423319385483) | |||
| 20490 | 20490 | 68099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | Permit Number 31844 | 6006420.25408514 | 2099944.49896622 | 37.7464107382986 | -122.42052117977501 | (37.7464107382986, -122.420521179775) | ||
| 20643 | 20643 | 26635 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 359 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/24/1998 12:00:00 AM | 3 | 3X3 | 6005539.477000001 | 2106921.88393 | 37.7655193351826 | -122.42406291888001 | (37.7655193351826, -122.42406291888) | ||
| 20712 | 20712 | 10140 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 906 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/1991 12:00:00 AM | 8 | 2x2 | 6005653.96599 | 2103626.9979 | 37.7564788166491 | -122.423432668582 | (37.7564788166491, -122.423432668582) | ||
| 20911 | 20911 | 50946 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1134 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2014 12:00:00 AM | 3 | Permit Number 773916 | 6007565.24376916 | 2118876.40998362 | 37.7984577381814 | -122.417903725033 | (37.7984577381814, -122.417903725033) | ||
| 20981 | 20981 | 40426 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 572 Wildwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/03/1999 12:00:00 AM | Permit Number 41522 | 5994442.84312797 | 2093351.87569512 | 37.7276267513816 | -122.46145953493901 | (37.7276267513816, -122.461459534939) | ||
| 21005 | 21005 | 4464 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1467 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1992 12:00:00 AM | 6 | 3X3 | 6004576.21057 | 2100336.17551 | 37.7473820968062 | -122.42692556438801 | (37.7473820968062, -122.426925564388) | ||
| 21103 | 21103 | 10099 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 750 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1995 12:00:00 AM | 30 | 2x2 | 6005606.10854 | 2104557.89173 | 37.7590321322447 | -122.423664360924 | (37.7590321322447, -122.423664360924) | ||
| 21203 | 21203 | 47373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2002 12:00:00 AM | Permit Number 45290 | 5991938.31220881 | 2089883.64331253 | 37.7179593670507 | -122.469865242758 | (37.7179593670507, -122.469865242758) | |||
| 21320 | 21320 | 10210 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1306 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1992 12:00:00 AM | 18 | 2X2 | 6005782.73241 | 2101317.8159 | 37.7501456037461 | -122.42282324301901 | (37.7501456037461, -122.422823243019) | ||
| 21423 | 21423 | 10225 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1399 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005877.37579 | 2100867.12021 | 37.748913436323704 | -122.422463939564 | (37.7489134363237, -122.422463939564) | |||
| 21429 | 21429 | 4275 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 4215 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002481.0949 | 2100316.7179400004 | 37.7472099827631 | -122.434168929879 | (37.7472099827631, -122.434168929879) | |||
| 21476 | 21476 | 16622 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 133 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002888.88219 | 2107504.60291 | 37.766969331884 | -122.433272362446 | (37.766969331884, -122.433272362446) | |||
| 21684 | 21684 | 10064 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 512 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1991 12:00:00 AM | 30 | 3X3 | 6005527.25593 | 2105966.68025 | 37.762895882361 | -122.42403725491 | (37.762895882361, -122.42403725491) | ||
| 21692 | 21692 | 26 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1992 12:00:00 AM | 12 | 3X3 | 6003885.725319999 | 2107769.72577 | 37.7677537952191 | -122.4298433527 | (37.7677537952191, -122.4298433527) | ||
| 21743 | 21743 | 5096 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 2617 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/2005 12:00:00 AM | 15 | 4x7 | 6002321.1773 | 2096442.08451 | 37.7365620645731 | -122.43444492640499 | (37.7365620645731, -122.434444926405) | ||
| 21867 | 21867 | 4450 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1368 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6004484.29512 | 2100913.96053 | 37.748963363065 | -122.427284553034 | (37.748963363065, -122.427284553034) | |||
| 22000 | 22000 | 4189 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/1998 12:00:00 AM | 6 | 3X3 | 6004813.31142 | 2100488.37375 | 37.747813401782 | -122.426116518959 | (37.747813401782, -122.426116518959) | ||
| 22175 | 22175 | 10077 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 611 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005621.78486 | 2105416.8204099997 | 37.761391433480895 | -122.423671214664 | (37.7613914334809, -122.423671214664) | |||
| 22236 | 22236 | 4405 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 1050 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1993 12:00:00 AM | 12 | 3X3 | 6004381.0178 | 2102775.98302 | 37.7540702011025 | -122.42777434091299 | (37.7540702011025, -122.427774340913) | ||
| 22288 | 22288 | 237856 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 636 30th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6002455.57988 | 2098272.49197 | 37.7415955682714 | -122.434111048608 | (37.7415955682714, -122.434111048608) | |||
| 22376 | 22376 | 2581 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1671 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1990 12:00:00 AM | 12 | 4X4 | 6005533.42791 | 2115131.9638 | 37.7880618747142 | -122.42466793237699 | (37.7880618747142, -122.424667932377) | ||
| 22815 | 22815 | 237464 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 4255 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001532.2528099995 | 2101727.17835 | 37.7510288729044 | -122.437550937446 | (37.7510288729044, -122.437550937446) | |||
| 22845 | 22845 | 34928 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 106 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/1997 12:00:00 AM | 3 | Permit Number 38520 | 5996566.0494 | 2113710.9366 | 37.7836495810368 | -122.455590554827 | (37.7836495810368, -122.455590554827) | ||
| 22877 | 22877 | 58835 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 465 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1984 12:00:00 AM | 12 | Permit Number 21290 | 5985916.00894 | 2112750.62267 | 37.7803959336596 | -122.492364376017 | (37.7803959336596, -122.492364376017) | ||
| 23107 | 23107 | 1354 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 290 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3X3 | 5999954.53574 | 2099301.98481 | 37.7442800472965 | -122.442832694476 | (37.7442800472965, -122.442832694476) | |||
| 23254 | 23254 | 22843 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5999765.52429 | 2099012.7663 | 37.7434751450586 | -122.443465482663 | (37.7434751450586, -122.443465482663) | |||
| 23318 | 23318 | 1917 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 12 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6016599.627230001 | 2095217.01267 | 37.7339984292864 | -122.384992424754 | (37.7339984292864, -122.384992424754) | |||
| 23403 | 23403 | 236934 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 586 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008695.69019 | 2096102.34104 | 37.735988986904104 | -122.412381425157 | (37.7359889869041, -122.412381425157) | |||
| 23405 | 23405 | 237701 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 59 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004493.49891 | 2107447.38395 | 37.7669031211042 | -122.427718167486 | (37.7669031211042, -122.427718167486) | |||
| 23409 | 23409 | 218091 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 62 Eastwood Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995658.864080001 | 2092992.02847 | 37.726708612908 | -122.45722974236601 | (37.726708612908, -122.457229742366) | |||
| 23415 | 23415 | 65130 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 38 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1989 12:00:00 AM | 8 | Permit Number 27100 | 5989605.43837 | 2114945.94466 | 37.7866386771259 | -122.479761743811 | (37.7866386771259, -122.479761743811) | |
| 23427 | 23427 | 217997 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2626 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990831.30116 | 2097513.28208 | 37.738844388362295 | -122.47424807748301 | (37.7388443883623, -122.474248077483) | |||
| 23463 | 23463 | 185056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 82 Crestlake Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5988580.6885 | 2096305.5585 | 37.735397653561 | -122.481941107831 | (37.735397653561, -122.481941107831) | |||
| 23534 | 23534 | 95373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 291 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767242 | 6013500.99875 | 2105751.1740599996 | 37.7627511113032 | -122.39644354544599 | (37.7627511113032, -122.396443545446) | |
| 23540 | 23540 | 50495 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 678 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/2003 12:00:00 AM | 3 | Permit Number 47131 | 6001459.37999 | 2089596.3595900002 | 37.7177163070325 | -122.436934583487 | (37.7177163070325, -122.436934583487) | |
| 23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
| 23591 | 23591 | 237541 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 351 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004042.14499 | 2103330.47017 | 37.755573516829 | -122.428985775399 | (37.755573516829, -122.428985775399) | |||
| 23619 | 23619 | 248592 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 825 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997630.862000001 | 2107647.8664 | 37.7670630083716 | -122.45146926878701 | (37.7670630083716, -122.451469268787) | |||
| 23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
| 23723 | 23723 | 142204 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 363 LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000185.7051 | 2110200.5827 | 37.7742180933985 | -122.442815809613 | (37.7742180933985, -122.442815809613) | |||
| 23850 | 23850 | 52657 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 17 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/23/2006 12:00:00 AM | 4 | Permit Number 48738 | 5996482.1208 | 2114462.9099 | 37.785709482825204 | -122.455935294079 | (37.7857094828252, -122.455935294079) | ||
| 23857 | 23857 | 235906 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3400 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005630.30801 | 2103749.3730099997 | 37.7568134948552 | -122.423523186264 | (37.7568134948552, -122.423523186264) | |||
| 23899 | 23899 | 72385 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 686 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/1996 12:00:00 AM | 8 | 5995057.69186 | 2110887.03516 | 37.775809229939206 | -122.460604158861 | (37.7758092299392, -122.460604158861) | ||
| 23970 | 23970 | 212728 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1287 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5992976.77161 | 2106756.7423799997 | 37.764348608513 | -122.467502106342 | (37.764348608513, -122.467502106342) | |||
| 23993 | 23993 | 236308 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 480 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006778.703509999 | 2100983.33732 | 37.749283347246205 | -122.419355383451 | (37.7492833472462, -122.419355383451) | |||
| 24014 | 24014 | 236568 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 3305 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007699.57868 | 2100897.33121 | 37.7490990159066 | -122.416164880221 | (37.7490990159066, -122.416164880221) | |||
| 24057 | 24057 | 217901 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 276 Edgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996581.0878099995 | 2105554.97883 | 37.7612563049516 | -122.454949015779 | (37.7612563049516, -122.454949015779) | |||
| 24085 | 24085 | 212387 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 95 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 5991919.26492 | 2095494.2164099999 | 37.7333635115101 | -122.47033944313499 | (37.7333635115101, -122.470339443135) | |||
| 24255 | 24255 | 218067 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 230 San Fernando Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992120.89448 | 2095258.70962 | 37.7327285245033 | -122.469625221338 | (37.7327285245033, -122.469625221338) | |||
| 24290 | 24290 | 31978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 241 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | 10 | Permit Number 35377 | 5995211.0055599995 | 2113933.52562 | 37.784182899243 | -122.460294590416 | (37.784182899243, -122.460294590416) | |
| 24335 | 24335 | 236523 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 91 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008259.430819999 | 2099498.50559 | 37.74528961631629 | -122.414129949142 | (37.7452896163163, -122.414129949142) | |||
| 24413 | 24413 | 214253 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 301 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5998149.4716300005 | 2095514.47625 | 37.7337773866994 | -122.448801437339 | (37.7337773866994, -122.448801437339) |
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");