Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3763 | 3763 | 18277 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1950 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 6 | 4X4 | 6002776.9831 | 2114109.0569 | 37.7850971709049 | -122.434131584258 | (37.7850971709049, -122.434131584258) | ||
7365 | 7365 | 8095 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 762 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 04/14/1998 12:00:00 AM | 24 | 3X3 | 6004129.5547 | 2111522.3059 | 37.778071268059996 | -122.42926759287201 | (37.77807126806, -122.429267592872) | ||
9104 | 9104 | 24127 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 140X Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016343.6401634 | 2095980.6654178002 | 37.736081103602096 | -122.38593067194799 | (37.7360811036021, -122.385930671948) | ||
14222 | 14222 | 16526 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 375 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016351.58796 | 2098272.95822 | 37.7423757148758 | -122.386062939968 | (37.7423757148758, -122.386062939968) | ||
15047 | 15047 | 30638 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34583 | 6008054.606000001 | 2108589.5131 | 37.7702399370436 | -122.415481702601 | (37.7702399370436, -122.415481702601) | |
27161 | 27161 | 197088 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1098 Pennsylvania Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6014473.69906 | 2102184.6927400003 | 37.753012404101 | -122.39282976818998 | (37.753012404101, -122.39282976819) | |||
30381 | 30381 | 197107 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1468 25th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6014386.38736 | 2102037.52751 | 37.7526034697945 | -122.393121414743 | (37.7526034697945, -122.393121414743) | |||
30856 | 30856 | 197169 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2 Baldwin Ct | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6017690.0216 | 2093651.3665 | 37.7297597257339 | -122.38111373781 | (37.7297597257339, -122.38111373781) | |||
33299 | 33299 | 239254 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 3715 26th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005705.30849 | 2100786.77225 | 37.748683110956996 | -122.423053239242 | (37.748683110957, -122.423053239242) | |||
36604 | 36604 | 213973 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1061 Capitol Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995027.24606 | 2091045.4090900002 | 37.721327367434604 | -122.459272306869 | (37.7213273674346, -122.459272306869) | |||
51010 | 51010 | 136194 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.43528810647699 | (37.7965053162169, -122.435288106477) | |||
54847 | 54847 | 197162 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 123 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016438.8167 | 2095743.2053 | 37.735434352517 | -122.385585060917 | (37.735434352517, -122.385585060917) | |||
54939 | 54939 | 42167 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 525 05th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 14 | Permit Number 42460 | 6012577.4664 | 2111216.9324 | 37.7777074143023 | -122.400021595319 | (37.7777074143023, -122.400021595319) | ||
65185 | 65185 | 141941 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1101 GOLDEN GATE AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004098.4852 | 2112152.8429 | 37.779800807673794 | -122.42942005016 | (37.7798008076738, -122.42942005016) | |||
65500 | 65500 | 182749 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1791 30th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986862.6162 | 2103130.8030000003 | 37.754037881879 | -122.488382483852 | (37.754037881879, -122.488382483852) | |||
66614 | 66614 | 136269 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 220 Joice St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010214.18023 | 2117016.1329200002 | 37.7934985921435 | -122.408606245692 | (37.7934985921435, -122.408606245692) | |||
68998 | 68998 | 137621 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2290 Turk Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999066.3943 | 2111876.2674 | 37.778755218262894 | -122.44680829044201 | (37.7787552182629, -122.446808290442) | |||
76365 | 76365 | 213967 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 621 Holloway Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994931.65056 | 2091213.50095 | 37.72178341096 | -122.45961491981701 | (37.72178341096, -122.459614919817) | |||
78062 | 78062 | 47635 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
79160 | 79160 | 49616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
84091 | 84091 | 8916 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4455X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5993207.14557 | 2112702.93338 | 37.7806885575202 | -122.467137671277 | (37.7806885575202, -122.467137671277) | |||
86559 | 86559 | 41238 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
87921 | 87921 | 88492 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
92458 | 92458 | 93817 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
107005 | 107005 | 16495 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 305X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2003 12:00:00 AM | 3 | 3x3 | 6016789.27845 | 2098277.7028 | 37.7424129566932 | -122.384549854363 | (37.7424129566932, -122.384549854363) | ||
107211 | 107211 | 100415 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 201x Linden St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 767727 | 6006435.0 | 2110776.0 | 37.7761523386864 | -122.421239206856 | (37.7761523386864, -122.421239206856) | ||||
109983 | 109983 | 112869 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
116064 | 116064 | 111487 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1745 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008026.0 | 2108277.0 | 37.7693802414943 | -122.41555852152901 | (37.7693802414943, -122.415558521529) | ||||
125944 | 125944 | 96720 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008320.0 | 2116937.0 | 37.7931750456071 | -122.41515467261601 | (37.7931750456071, -122.415154672616) | |||||
134133 | 134133 | 138456 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002949.306 | 2114858.1502 | 37.7871637698126 | -122.43358895561899 | (37.7871637698126, -122.433588955619) | |||
140317 | 140317 | 9553 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1195X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 6 | 3X3 | 6003912.3472435 | 2112132.7194564 | 37.7797350134544 | -122.43006254712499 | (37.7797350134544, -122.430062547125) | |||
147265 | 147265 | 48809 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | 3 | Permit Number 46042 | 6014468.625469999 | 2102279.9042599997 | 37.753273552832205 | -122.392853974356 | (37.7532735528322, -122.392853974356) | ||
148254 | 148254 | 123265 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 460 07th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5993761.50417 | 2112485.6321900003 | 37.780123890844706 | -122.465204105338 | (37.7801238908447, -122.465204105338) | |||
151148 | 151148 | 138428 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1901 SUTTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003441.7914 | 2114496.0219 | 37.7861973877355 | -122.431859197478 | (37.7861973877355, -122.431859197478) | |||
156662 | 156662 | 141624 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1801 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998927.5552 | 2110401.5996 | 37.7746982273973 | -122.447182428734 | (37.7746982273973, -122.447182428734) | |||
159725 | 159725 | 213957 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 360 Faxon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994771.7805 | 2091087.8520099998 | 37.7214292147603 | -122.460158446674 | (37.7214292147603, -122.460158446674) | |||
165811 | 165811 | 197143 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 67 Jennings Ct | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012876.3937800005 | 2089220.9678099998 | 37.717327861958296 | -122.397444511578 | (37.7173278619583, -122.397444511578) | |||
167380 | 167380 | 138444 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1820 POST ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003354.9599 | 2114191.1274 | 37.785355301736004 | -122.43213783008999 | (37.785355301736, -122.43213783009) | |||
170019 | 170019 | 141931 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1050 MCALLISTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004116.6344 | 2111867.0624 | 37.7790171527246 | -122.42933687953999 | (37.7790171527246, -122.42933687954) | |||
173068 | 173068 | 197158 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Whitney Young Cir | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016583.16711 | 2095682.22839 | 37.7352749081106 | -122.385081735533 | (37.7352749081106, -122.385081735533) | |||
175783 | 175783 | 200043 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1598 Lane St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015271.0088 | 2094675.4616 | 37.732437859472796 | -122.38954809856399 | (37.7324378594728, -122.389548098564) |
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");