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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260 | 260 | 221893 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3164 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008601.79804 | 2101572.78068 | 37.751004337584796 | -122.41309273944599 | (37.7510043375848, -122.413092739446) | |||
3668 | 3668 | 43018 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/2000 12:00:00 AM | Permit Number 42880 | |||||||||
6607 | 6607 | 34069 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 955 Kennedy Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/05/1997 12:00:00 AM | Permit Number 37965 | ||||||||
7921 | 7921 | 29760 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 500 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6008840.5335 | 2121127.883 | 37.804711410621294 | -122.41365014448401 | (37.8047114106213, -122.413650144484) | |||
9818 | 9818 | 46930 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2016 12:00:00 AM | 3 | Permit Number 779184 | 5995168.47040897 | 2099126.50126016 | 37.743524195830396 | -122.459369067857 | (37.7435241958304, -122.459369067857) | |
9953 | 9953 | 107188 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1500 PAGE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/15/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773122 | 5999274.2 | 2109122.8 | 37.771206769657205 | -122.445891326497 | (37.7712067696572, -122.445891326497) | |
10511 | 10511 | 38233 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 0 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40352 | ||||||||
22152 | 22152 | 10132 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 899 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/1992 12:00:00 AM | 6 | 3X3 | 6005714.0796 | 2103814.39751 | 37.756996764997 | -122.42323809485599 | (37.756996764997, -122.423238094856) | ||
25801 | 25801 | 225955 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 245 Roanoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003637.7380800005 | 2095933.74555 | 37.735240927214704 | -122.42985676608299 | (37.7352409272147, -122.429856766083) | |||
31526 | 31526 | 95134 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 450@ Wayland Somerset St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6010117.366119999 | 2092259.39432 | 37.7255167458877 | -122.40719528853501 | (37.7255167458877, -122.407195288535) | |||
33404 | 33404 | 225968 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 3599 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005865.3441 | 2101966.56287 | 37.751931574603894 | -122.422583660903 | (37.7519315746039, -122.422583660903) | |||
35468 | 35468 | 49765 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 333 Schwerin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 5 | Permit Number 46559 | 6008653.27394 | 2086377.17589 | 37.7092833534188 | -122.411841080097 | (37.7092833534188, -122.411841080097) | |
38420 | 38420 | 244549 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1500 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999267.0062 | 2109103.195 | 37.7711525285338 | -122.44591479977801 | (37.7711525285338, -122.445914799778) | |||
40705 | 40705 | 192411 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 650 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011779.44506 | 2105347.31232 | 37.7615462436837 | -122.40236942660499 | (37.7615462436837, -122.402369426605) | |||
44681 | 44681 | 225910 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 99 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6005408.28506 | 2103204.3544 | 37.7553044666341 | -122.42425226303101 | (37.7553044666341, -122.424252263031) | |||
58473 | 58473 | 225900 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6009378.42208 | 2107868.1744 | 37.768333627729504 | -122.410851658572 | (37.7683336277295, -122.410851658572) | |||
59772 | 59772 | 225960 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 202 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008021.65482 | 2096973.39205 | 37.7383428544349 | -122.41477346894699 | (37.7383428544349, -122.414773468947) | |||
73386 | 73386 | 176503 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 170 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6005661.68615 | 2087270.92863 | 37.711569123398796 | -122.422243953714 | (37.7115691233988, -122.422243953714) | |||
75984 | 75984 | 225936 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1232 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008666.40255 | 2101335.6889400003 | 37.7503569633096 | -122.412852569207 | (37.7503569633096, -122.412852569207) | |||
76617 | 76617 | 32627 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 75 Boardman Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 15 | Permit Number 37080 | 6011835.142990001 | 2109991.00563 | 37.774299885758 | -122.40250333475599 | (37.774299885758, -122.402503334756) | |
83902 | 83902 | 113388 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 185 CASTENADA AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 5994493.0 | 2100782.0 | 37.7480309194949 | -122.461824674651 | (37.7480309194949, -122.461824674651) | ||||
91176 | 91176 | 32985 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 10X Sierra St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 5x9 | Permit Number 37296 | 6013812.07366772 | 2104214.5102771 | 37.7585490739971 | -122.395259990599 | (37.7585490739971, -122.395259990599) | |
95253 | 95253 | 32807 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1686 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37166 | 5999791.91343358 | 2110220.51293563 | 37.7742503589901 | -122.44417943364999 | (37.7742503589901, -122.44417943365) | ||
100066 | 100066 | 48959 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1521 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2002 12:00:00 AM | Permit Number 46145 | 6009607.60540748 | 2100518.70293664 | 37.7481664860313 | -122.40954015648 | (37.7481664860313, -122.40954015648) | |||
105535 | 105535 | 10695 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 1250 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001856.34415 | 2110522.16346 | 37.7751961745675 | -122.43705980731701 | (37.7751961745675, -122.437059807317) | |||
110666 | 110666 | 98258 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007899.1 | 2106885.5 | 37.7655523739417 | -122.41589891426099 | (37.7655523739417, -122.415898914261) | |||
121526 | 121526 | 105214 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2400X 21ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5989837.0 | 2098691.0 | 37.7420204448441 | -122.477771936587 | (37.7420204448441, -122.477771936587) | |||
121755 | 121755 | 36066 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 1398 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1998 12:00:00 AM | Permit Number 39186 | 6009394.0 | 2107812.0 | 37.76818025927739 | -122.410793808029 | (37.7681802592774, -122.410793808029) | |||
121812 | 121812 | 29765 | DPW Maintained 3 | Geijera parviflora :: Australian Willow 68 | 570 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4x4 | 6008571.0386595 | 2121096.2836166 | 37.8046095098754 | -122.414580523895 | (37.8046095098754, -122.414580523895) | |||
129299 | 129299 | 108168 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 2x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6009949.0 | 2099997.0 | 37.74675312806 | -122.40832282803001 | (37.74675312806, -122.40832282803) | ||||
131583 | 131583 | 219011 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 157 Miramar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995317.533340001 | 2090902.82075 | 37.7209525389978 | -122.458258556883 | (37.7209525389978, -122.458258556883) | |||
131668 | 131668 | 176513 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 154 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6006276.40846 | 2087403.9786200002 | 37.7119691058641 | -122.42012874286199 | (37.7119691058641, -122.420128742862) | |||
132274 | 132274 | 225962 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 200 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007966.252640001 | 2096976.9069400001 | 37.738349392503 | -122.414965271836 | (37.738349392503, -122.414965271836) | |||
133659 | 133659 | 142688 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 552 FRANCISCO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6008641.5861 | 2121102.2307 | 37.8046298022358 | -122.414336807992 | (37.8046298022358, -122.414336807992) | |||
136191 | 136191 | 192416 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1400 20th St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6013651.01145 | 2104790.61421 | 37.760121971170896 | -122.395857388933 | (37.7601219711709, -122.395857388933) | |||
154338 | 154338 | 192414 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 740 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6011806.79674 | 2104934.73644 | 37.76041492892529 | -122.40224581930799 | (37.7604149289253, -122.402245819308) | |||
164012 | 164012 | 128873 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 1270 Clay St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6008597.37413 | 2116983.75832 | 37.7933190163979 | -122.414198247271 | (37.7933190163979, -122.414198247271) | |||
171362 | 171362 | 192424 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 80 Carolina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6012214.215580001 | 2107593.00345 | 37.767736670334 | -122.40102351921401 | (37.767736670334, -122.401023519214) | |||
173461 | 173461 | 192419 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2 Sierra St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6013725.780809999 | 2104155.14731 | 37.7583812766799 | -122.39555427333299 | (37.7583812766799, -122.395554273333) | |||
174678 | 174678 | 128878 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2507 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006675.76572 | 2119877.35226 | 37.8011559740396 | -122.421052707221 | (37.8011559740396, -122.421052707221) | |||
177304 | 177304 | 176507 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 150 Brookdale Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6005719.71054 | 2087314.8851 | 37.7116930913392 | -122.422046526423 | (37.7116930913392, -122.422046526423) | |||
185659 | 185659 | 245457 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 2800 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6007865.341 | 2106811.8898 | 37.7653483594859 | -122.41601046611099 | (37.7653483594859, -122.416010466111) |
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");