Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23811 | 23811 | 140094 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1652 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999863.0392 | 2110926.6558 | 37.7761933050322 | -122.44398414486 | (37.7761933050322, -122.44398414486) | |||
36032 | 36032 | 84615 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 26 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50848 | 6001974.9488 | 2119960.7519900003 | 37.8011188571965 | -122.437325522376 | (37.8011188571965, -122.437325522376) | |
46584 | 46584 | 112541 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | |||
54592 | 54592 | 32576 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1366 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37050 | 5986201.05883385 | 2105941.9596711 | 37.7617179230551 | -122.49087711798 | (37.7617179230551, -122.49087711798) | |
54735 | 54735 | 32597 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1478 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37065 | 5985606.43921528 | 2105161.9851204 | 37.759541574007 | -122.492876185531 | (37.759541574007, -122.492876185531) | |
61590 | 61590 | 137691 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | |||
62196 | 62196 | 240395 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 37 Highland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6005177.74113 | 2096695.2803099998 | 37.7374190204687 | -122.42458656083201 | (37.7374190204687, -122.424586560832) | |||
66650 | 66650 | 38870 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1551 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/12/2000 12:00:00 AM | 2 | Permit Number 43029 | 5989746.74182688 | 2105808.42580632 | 37.7615577752966 | -122.47860439661501 | (37.7615577752966, -122.478604396615) | |
66939 | 66939 | 32596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1474 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37064 | 5985605.53989408 | 2105188.12612078 | 37.759613297357895 | -122.492881221287 | (37.7596132973579, -122.492881221287) | |
68016 | 68016 | 112540 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 432 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011444.64707 | 2118714.34063 | 37.7982302977556 | -122.404468304876 | (37.7982302977556, -122.404468304876) | |||
69594 | 69594 | 214034 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.729116861544206 | -122.447089829625 | (37.7291168615442, -122.447089829625) | |||
70953 | 70953 | 41210 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3537 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/1999 12:00:00 AM | 2 | Permit Number 41919 | 6002146.81597 | 2120360.9832900004 | 37.8022275558181 | -122.436759454895 | (37.8022275558181, -122.436759454895) | |
73938 | 73938 | 240417 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 150 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001765.76464 | 2096530.8335799999 | 37.736774205667295 | -122.436371571893 | (37.7367742056673, -122.436371571893) | |||
76501 | 76501 | 240390 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 48 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005917.96775 | 2097681.76661 | 37.740169467433894 | -122.42209730935801 | (37.7401694674339, -122.422097309358) | |||
83362 | 83362 | 63013 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | |
129970 | 129970 | 214013 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1483 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5992099.86454 | 2105356.08672 | 37.760452112299795 | -122.47043304005899 | (37.7604521122998, -122.470433040059) | |||
132831 | 132831 | 201725 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1915 Quesada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6013561.8417 | 2095888.78027 | 37.735674466103795 | -122.39554210998199 | (37.7356744661038, -122.395542109982) | ||||
137736 | 137736 | 136324 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011401.0 | 2118734.0 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | |||
155541 | 155541 | 87877 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 32 Mallorca Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50849 | 6001971.5755 | 2119984.5657599997 | 37.8011840517703 | -122.43733890158998 | (37.8011840517703, -122.43733890159) | |
160254 | 160254 | 48460 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 102 Pope St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45825 | 6000209.55112 | 2088191.07942 | 37.71378660783029 | -122.44115390123999 | (37.7137866078303, -122.44115390124) | ||
162778 | 162778 | 179375 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001912.74857 | 2089301.2462099998 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | |||
169753 | 169753 | 70219 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2519 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/1993 12:00:00 AM | 2 | 5999766.96115 | 2119470.2848900002 | 37.7996463981067 | -122.444930811031 | (37.7996463981067, -122.444930811031) | ||
171218 | 171218 | 69041 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1481 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 2 | Permit Number 33048 | 5984315.00463023 | 2105104.8689211 | 37.7593091431589 | -122.497338322577 | (37.7593091431589, -122.497338322577) | |
176744 | 176744 | 32595 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1383 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 2 | Permit Number 37063 | 5985531.94877095 | 2105814.83097448 | 37.7613297510328 | -122.49318190152901 | (37.7613297510328, -122.493181901529) | |
176846 | 176846 | 112537 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011527.0722 | 2118728.8461599997 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | |||
177684 | 177684 | 112546 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 464 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011322.0 | 2118712.0 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | |||
183050 | 183050 | 69147 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2474 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50209 | 5983357.92346724 | 2098305.86052221 | 37.7405848112735 | -122.50014569422399 | (37.7405848112735, -122.500145694224) | |
188261 | 188261 | 240405 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003457.25772 | 2096114.18055 | 37.735726138447795 | -122.43049362280199 | (37.7357261384478, -122.430493622802) |
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");