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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 17951 | 17951 | 22845 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1997 12:00:00 AM | 16 | 1X1 | 5999785.45831 | 2099029.41993 | 37.7435220087408 | -122.44339775201401 | (37.7435220087408, -122.443397752014) | ||
| 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) | ||
| 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) | |
| 18701 | 18701 | 22848 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 1X1 | 5999801.2823 | 2099039.75864 | 37.743551298748 | -122.44334377921601 | (37.743551298748, -122.443343779216) | |||
| 18838 | 18838 | 43257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400 Burrows St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | Permit Number 43041 | 6010158.39254276 | 2093206.15154528 | 37.728118638728105 | -122.407120168437 | (37.7281186387281, -122.407120168437) | ||
| 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) | |||
| 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) | |||
| 19102 | 19102 | 48673 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 420 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/2002 12:00:00 AM | Permit Number 45956 | 6002102.91710872 | 2103385.70582138 | 37.7556152218159 | -122.43569617174101 | (37.7556152218159, -122.435696171741) | |||
| 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) | ||
| 19495 | 19495 | 40538 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | Permit Number 41587 | 5992631.08642927 | 2094049.19194754 | 37.7294369636011 | -122.46777343904101 | (37.7294369636011, -122.467773439041) | |||
| 19737 | 19737 | 43124 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 306 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2000 12:00:00 AM | Permit Number 42942 | 6006590.61283403 | 2097446.1617064998 | 37.7395604645493 | -122.41975485718001 | (37.7395604645493, -122.41975485718) | |||
| 19803 | 19803 | 40552 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 380 San Leandro Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41594 | 5992231.83033974 | 2094391.07598337 | 37.7303526300924 | -122.46917856626301 | (37.7303526300924, -122.469178566263) | ||
| 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) | ||
| 19854 | 19854 | 22847 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 120 Turquoise Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 1X1 | 5999792.57079 | 2099032.92975 | 37.7435320514679 | -122.44337341096 | (37.7435320514679, -122.44337341096) | |||
| 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) | |||
| 20385 | 20385 | 39056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2800X 18th St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009422.123 | 2105494.394 | 37.7618182216771 | -122.410532856099 | (37.7618182216771, -122.410532856099) | ||
| 20484 | 20484 | 39027 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 501X Florida St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009258.495 | 2105867.224 | 37.7628327529372 | -122.41112511890101 | (37.7628327529372, -122.411125118901) | ||
| 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) | ||
| 20623 | 20623 | 39050 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1900 Bryant St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40772 | 6009499.38 | 2105599.429 | 37.762110954787005 | -122.410273070025 | (37.762110954787, -122.410273070025) | ||
| 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) | ||
| 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) | |||
| 21241 | 21241 | 41670 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 500 Corbett Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42131 | 5999528.76445246 | 2104225.15584588 | 37.7577735947767 | -122.44465870166599 | (37.7577735947767, -122.444658701666) | ||
| 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) | ||
| 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) | ||
| 21899 | 21899 | 24817 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 400X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2015 12:00:00 AM | 4 | 3x3 | 6007985.05958 | 2094993.5090299998 | 37.7329044714678 | -122.41475991886101 | (37.7329044714678, -122.414759918861) | ||
| 22170 | 22170 | 17373 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1050X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5999390.9816 | 2109231.8772 | 37.771512935512796 | -122.44549522045601 | (37.7715129355128, -122.445495220456) | |||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 23672 | 23672 | 45504 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3071 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 3 | Permit Number 44274 | 5989334.51674 | 2094909.25358 | 37.731607570812294 | -122.47923275968 | (37.7316075708123, -122.47923275968) | |
| 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) | ||
| 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) | |
| 24502 | 24502 | 66601 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1111 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 9 | Permit Number 29794 | 6008473.92013 | 2115892.33746 | 37.7903153068679 | -122.414548140207 | (37.7903153068679, -122.414548140207) | |
| 24668 | 24668 | 62307 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 75 Loraine Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1985 12:00:00 AM | 12 | Permit Number 22445. Tree 1 on Anza | 5996139.53723 | 2112297.17389 | 37.7797432798479 | -122.456963823301 | (37.7797432798479, -122.456963823301) | |
| 24704 | 24704 | 50215 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 894@ CABRILLO 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 6 | Permit Number 46923 | 5986993.182990001 | 2109884.80336 | 37.7725901199359 | -122.488427298171 | (37.7725901199359, -122.488427298171) | |
| 24747 | 24747 | 32784 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 722 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 6 | Permit Number 37151 | 5999634.6045 | 2111035.6277 | 37.7764794805822 | -122.444782194549 | (37.7764794805822, -122.444782194549) | |
| 24778 | 24778 | 45056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2327 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 3 | Permit Number 43941 | 5988236.6427 | 2099455.0874 | 37.7440254200914 | -122.483361393915 | (37.7440254200914, -122.483361393915) | |
| 24803 | 24803 | 43758 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 187 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43394 | 5990518.06964 | 2114139.81459 | 37.78447824498161 | -122.47654538071698 | (37.7844782449816, -122.476545380717) | |
| 24853 | 24853 | 47834 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 891 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49787 | 5981681.239030001 | 2109702.6053299997 | 37.7717784851525 | -122.50678802713199 | (37.7717784851525, -122.506788027132) | |
| 25402 | 25402 | 52514 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 145 Naglee Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48619 | 5998354.240201401 | 2087816.66554809 | 37.7126526970659 | -122.447539577442 | (37.7126526970659, -122.447539577442) | ||
| 25423 | 25423 | 30768 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.727837721051294 | -122.391915390574 | (37.7278377210513, -122.391915390574) | |
| 25526 | 25526 | 31523 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1320 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 9 | Permit Number 35078 | 6011116.30671 | 2102174.6826400002 | 37.752797866337794 | -122.404439635397 | (37.7527978663378, -122.404439635397) | |
| 25688 | 25688 | 95116 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 67 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54043 | 6002297.43224 | 2093241.3314 | 37.727772179934 | -122.43429826136999 | (37.727772179934, -122.43429826137) |
| 25797 | 25797 | 52005 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1242 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2005 12:00:00 AM | 5 | Permit Number 48221 | 6012213.91995 | 2102588.0097 | 37.7539940500909 | -122.40067289875601 | (37.7539940500909, -122.400672898756) | ||
| 25882 | 25882 | 31929 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 450 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 5 | Permit Number 35345 | 5991716.333380001 | 2100485.7522400003 | 37.747057262589 | -122.471404605562 | (37.747057262589, -122.471404605562) | |
| 25960 | 25960 | 31277 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991087.0554599995 | 2097794.191 | 37.739630505545705 | -122.47338429037902 | (37.7396305055457, -122.473384290379) | |
| 26128 | 26128 | 31225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2491 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34912 | 5987341.6863 | 2098360.1236 | 37.740966813188 | -122.486375538404 | (37.740966813188, -122.486375538404) | |
| 26319 | 26319 | 67661 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 33 Lucy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | 5 | Permit Number 31262 | 6014174.7724 | 2093920.80707 | 37.7303048875537 | -122.39328528558201 | (37.7303048875537, -122.393285285582) | |
| 26534 | 26534 | 42234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 479 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | 1 | Permit Number 42487 | 6010475.72371 | 2112231.45093 | 37.780375639875295 | -122.407363816092 | (37.7803756398753, -122.407363816092) | |
| 26573 | 26573 | 59103 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 716 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 8 | Permit Number 18405 | 5993517.557519999 | 2110582.1522 | 37.7748833764641 | -122.465909672698 | (37.7748833764641, -122.465909672698) | ||
| 26662 | 26662 | 32409 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 111 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 6 | Permit Number 36943 | 5996512.2403 | 2113726.1656 | 37.7836883078777 | -122.455777813925 | (37.7836883078777, -122.455777813925) | ||
| 27701 | 27701 | 45499 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2963 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2001 12:00:00 AM | 2 | Permit Number 44272 | 5989310.955130001 | 2095557.4598599998 | 37.7333860107429 | -122.47936161996999 | (37.7333860107429, -122.47936161997) | |
| 27838 | 27838 | 84671 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 814 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51850 | 5987288.69807 | 2110382.68837 | 37.7739744108289 | -122.487441673839 | (37.7739744108289, -122.487441673839) | |
| 27869 | 27869 | 31273 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991084.11448 | 2097836.49496 | 37.7397464910963 | -122.473397543673 | (37.7397464910963, -122.473397543673) | |
| 27935 | 27935 | 31275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991083.96236 | 2097817.15833 | 37.739693388847606 | -122.47339665963001 | (37.7396933888476, -122.47339665963) | |
| 28003 | 28003 | 60357 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1265 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1982 12:00:00 AM | 9 | Permit Number 19935 | 6016646.4135 | 2093895.0122 | 37.7303710665679 | -122.384738607351 | (37.7303710665679, -122.384738607351) | |
| 28025 | 28025 | 67400 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 547 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 6 | Permit Number 30897 | 5990610.3412 | 2111645.1131599997 | 37.777633837418996 | -122.47604389172199 | (37.777633837419, -122.476043891722) | |
| 28083 | 28083 | 31759 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2654 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 6 | Permit Number 35245 | 5989289.1529 | 2097265.3499 | 37.7380741702289 | -122.479561911147 | (37.7380741702289, -122.479561911147) | |
| 28229 | 28229 | 43752 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 258 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 5 | Permit Number 43388 | 5991219.98047 | 2113680.3591 | 37.7832573927775 | -122.47408349916799 | (37.7832573927775, -122.474083499168) | |
| 28323 | 28323 | 43865 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2400 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 2 | Permit Number 43482 | 5985465.207 | 2096960.4516 | 37.7370141335806 | -122.49276055533998 | (37.7370141335806, -122.49276055534) | |
| 28667 | 28667 | 31457 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001233.81138 | 2102648.72464 | 37.7535422450846 | -122.43864900065701 | (37.7535422450846, -122.438649000657) | |
| 28739 | 28739 | 64507 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 848 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/21/1988 12:00:00 AM | 6 | Permit Number 25388 | 6000492.1653 | 2111922.2928 | 37.778962938676706 | -122.441879309268 | (37.7789629386767, -122.441879309268) | |
| 28784 | 28784 | 85390 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1060 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2007 12:00:00 AM | 5 | Permit Number 49660 | 6009093.49986 | 2117706.63601 | 37.7953317162473 | -122.412532734295 | (37.7953317162473, -122.412532734295) | ||
| 28785 | 28785 | 64616 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 389 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1988 12:00:00 AM | 9 | Permit Number 25521 | 6002491.9826 | 2091161.61922 | 37.7220727984055 | -122.433477138957 | (37.7220727984055, -122.433477138957) | ||
| 28837 | 28837 | 49544 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 333@ HARRISON 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2003 12:00:00 AM | 1 | Permit Number 46436 | 6008699.91285 | 2108993.64951 | 37.7713858511965 | -122.413278165268 | (37.7713858511965, -122.413278165268) | ||
| 28994 | 28994 | 38689 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1387 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1998 12:00:00 AM | 7 | Permit Number 40602 | 6001181.9349 | 2110716.5649 | 37.775691594994505 | -122.439406673557 | (37.7756915949945, -122.439406673557) | |
| 29036 | 29036 | 68188 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2503 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/1993 12:00:00 AM | 7 | Permit Number 31964 | 6004910.12814 | 2118236.0530000003 | 37.7965496977651 | -122.427045615765 | (37.7965496977651, -122.427045615765) | ||
| 29072 | 29072 | 97763 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 115 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2011 12:00:00 AM | 1 | Permit Number 768298 | 5996511.5635 | 2113681.1555 | 37.783564683267 | -122.455776900676 | (37.783564683267, -122.455776900676) | ||
| 29116 | 29116 | 50756 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1422 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2004 12:00:00 AM | 1 | 3x3 | Permit Number 47297 | 6000959.9949 | 2110735.2278 | 37.775730205601505 | -122.440175755869 | (37.7757302056015, -122.440175755869) | |
| 29236 | 29236 | 47400 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 680 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 2 | Permit Number 45311 | 5994746.17876 | 2110902.86146 | 37.7758347580225 | -122.461682901678 | (37.7758347580225, -122.461682901678) | |
| 29420 | 29420 | 31287 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34935 | 5990781.283369999 | 2097640.71217 | 37.7391913809888 | -122.474430310711 | (37.7391913809888, -122.474430310711) | |
| 29656 | 29656 | 45512 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 3060 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2001 12:00:00 AM | 4 | Permit Number 44277 | 5988861.0879999995 | 2094953.9729400002 | 37.7317028513108 | -122.48087274987101 | (37.7317028513108, -122.480872749871) | |
| 29689 | 29689 | 31744 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2435 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 5 | Permit Number 35234 | 5989813.6936 | 2098781.7399 | 37.742268240421204 | -122.47785915361601 | (37.7422682404212, -122.477859153616) | |
| 30312 | 30312 | 52936 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 385 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48922 | 6001040.8792 | 2092508.1161099998 | 37.725687536143106 | -122.438589665189 | (37.7256875361431, -122.438589665189) | |
| 30497 | 30497 | 48978 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2801 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2002 12:00:00 AM | 4 | Permit Number 46165 | 6004347.6822 | 2118813.41296 | 37.7981031596905 | -122.429032988006 | (37.7981031596905, -122.429032988006) | ||
| 30620 | 30620 | 121688 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 800 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6008462.12689 | 2120388.3747 | 37.802659650390794 | -122.414907290765 | (37.8026596503908, -122.414907290765) | ||||
| 30627 | 30627 | 38811 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 326 10th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1998 12:00:00 AM | 8 | Permit Number 40647 | 5992799.72049 | 2113267.67027 | 37.78221564478971 | -122.46858824048599 | (37.7822156447897, -122.468588240486) | |
| 30650 | 30650 | 43288 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2210 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 6 | Permit Number 43057 | 6011175.09189 | 2105117.22439 | 37.760880718387796 | -122.404443451212 | (37.7608807183878, -122.404443451212) | |
| 30675 | 30675 | 97458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 198x Venus St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | Permit Number 29234 | 6012786.54771 | 2093965.4585400003 | 37.730350268249104 | -122.398087730979 | (37.7303502682491, -122.398087730979) | ||
| 30972 | 30972 | 45468 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2211 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2001 12:00:00 AM | 3 | Permit Number 44247 | 6011982.05342 | 2101350.4265900003 | 37.750582981830895 | -122.40138778604401 | (37.7505829818309, -122.401387786044) | ||
| 31178 | 31178 | 88045 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1547 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51057 | 6015625.12405 | 2096754.45465 | 37.7381659820759 | -122.388468888121 | (37.7381659820759, -122.388468888121) | |
| 31189 | 31189 | 43857 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2784 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2000 12:00:00 AM | 4 | Permit Number 43478 | 5985281.0071 | 2096265.8928 | 37.7350962873764 | -122.493346251334 | (37.7350962873764, -122.493346251334) | |
| 31196 | 31196 | 32470 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 59 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 6 | Permit Number 36978 | 6001062.3142800005 | 2106026.41955 | 37.762806815291796 | -122.439484183958 | (37.7628068152918, -122.439484183958) | |
| 31396 | 31396 | 62715 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1941 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1986 12:00:00 AM | 6 | Permit Number 23057 | 6007704.91578 | 2119106.60942 | 37.7990976677838 | -122.417436738332 | (37.7990976677838, -122.417436738332) | |
| 31401 | 31401 | 68521 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 708 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/11/2015 12:00:00 AM | 7 | Permit Number 775425 | 5995373.47149 | 2110684.12761 | 37.775270261614104 | -122.45949710563801 | (37.7752702616141, -122.459497105638) | |
| 31472 | 31472 | 82670 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 643 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51570 | 5994382.917669999 | 2111130.5292599997 | 37.7764389559753 | -122.462956026429 | (37.7764389559753, -122.462956026429) | |
| 31628 | 31628 | 68536 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 734 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 8 | Permit Number 32418 | 5993833.0352 | 2110476.78435 | 37.7746122584416 | -122.464810724109 | (37.7746122584416, -122.464810724109) |
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");