Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, PlantDate, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28357 | 28357 | 31627 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2430 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 0 | Permit Number 35144 | 5981797.10260903 | 2098537.8771738 | 37.7411301336904 | -122.50555951218399 | (37.7411301336904, -122.505559512184) | |
36904 | 36904 | 31305 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 561 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | |
134786 | 134786 | 37114 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
135660 | 135660 | 37119 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4731 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39709 | 5981101.19035238 | 2106191.54023256 | 37.762103946482505 | -122.508533725105 | (37.7621039464825, -122.508533725105) | |
150825 | 150825 | 31310 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
157476 | 157476 | 31309 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 577 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34948 | 6005032.34705274 | 2111420.35666119 | 37.777842407995294 | -122.42613724809999 | (37.7778424079953, -122.4261372481) | |
164869 | 164869 | 37115 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4540 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39707 | 5981688.69009077 | 2106263.69511954 | 37.7623366715481 | -122.506507175967 | (37.7623366715481, -122.506507175967) | |
174810 | 174810 | 31307 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
178533 | 178533 | 31308 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 569 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34947 | 6005068.91365842 | 2111425.45669453 | 37.7778584781223 | -122.42601111452801 | (37.7778584781223, -122.426011114528) | |
180771 | 180771 | 31306 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 561 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 0 | Permit Number 34946 | 6005105.48028119 | 2111430.55673025 | 37.7778745481219 | -122.425884980842 | (37.7778745481219, -122.425884980842) | |
182887 | 182887 | 37113 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 4523 IRVING ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | 0 | Permit Number 39706 | 5981665.2 | 2106185.8 | 37.7621214108202 | -122.506582640723 | (37.7621214108202, -122.506582640723) | |
187630 | 187630 | 47074 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 106 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 0 | Permit Number 45062 | 5996796.88091549 | 2112360.28017641 | 37.7799542788822 | -122.454694357616 | (37.7799542788822, -122.454694357616) |
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");