Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22874 | 22874 | 179489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6009813.802999999 | 2094277.0712700002 | 37.7310398674871 | -122.40838693792801 | (37.7310398674871, -122.408386937928) | |||
35849 | 35849 | 197509 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | 6009753.46902 | 2109444.94334 | 37.7726840927246 | -122.40966570732999 | (37.7726840927246, -122.40966570733) | ||||
40850 | 40850 | 136407 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6009007.217180001 | 2119024.8122799997 | 37.798946260622294 | -122.412924532036 | (37.7989462606223, -122.412924532036) | |||
49719 | 49719 | 136405 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008967.16736 | 2119019.94772 | 37.7989306555735 | -122.413062774033 | (37.7989306555735, -122.413062774033) | |||
55609 | 55609 | 136404 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008943.49637 | 2119016.81507 | 37.7989207252599 | -122.413144462145 | (37.7989207252599, -122.413144462145) | |||
56877 | 56877 | 239719 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4818 25th St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 10ft | 5999936.15376 | 2101092.9328900003 | 37.7491965123129 | -122.44302484724199 | (37.7491965123129, -122.443024847242) | |||
59759 | 59759 | 239693 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6004448.48684 | 2103643.67064 | 37.7564564838073 | -122.427602831218 | (37.7564564838073, -122.427602831218) | |||
66375 | 66375 | 239694 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 4ft | 6004424.11255 | 2103642.04676 | 37.756450646292 | -122.427687010443 | (37.756450646292, -122.427687010443) | |||
73324 | 73324 | 239692 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 4ft | 6004466.4231900005 | 2103643.72661 | 37.7564576520127 | -122.427540804958 | (37.7564576520127, -122.427540804958) | |||
73424 | 73424 | 197511 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6009774.86658 | 2109479.2363299998 | 37.772779452333204 | -122.40959411137699 | (37.7727794523332, -122.409594111377) | ||||
74711 | 74711 | 197510 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6009757.95432 | 2109468.4994900003 | 37.7727490237764 | -122.409651855072 | (37.7727490237764, -122.409651855072) | ||||
130197 | 130197 | 239721 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 400 Clipper St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6002485.20231 | 2100944.35113 | 37.7489335487424 | -122.434199588643 | (37.7489335487424, -122.434199588643) | |||
132434 | 132434 | 197513 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | ||||
137734 | 137734 | 197516 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 11 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 6009818.3758 | 2109520.83011 | 37.772896097121894 | -122.40944654343299 | (37.7728960971219, -122.409446543433) | ||||
139881 | 139881 | 136406 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6008985.36131 | 2119021.64248 | 37.7989363302909 | -122.412999936617 | (37.7989363302909, -122.412999936617) | |||
150992 | 150992 | 239722 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 400 Clipper St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002450.40135 | 2100940.8188400003 | 37.7489218746471 | -122.434319677816 | (37.7489218746471, -122.434319677816) | |||
152764 | 152764 | 136403 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 897 Green St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6008921.12724 | 2119013.91425 | 37.7989115045253 | -122.41322166175699 | (37.7989115045253, -122.413221661757) | |||
156380 | 156380 | 197515 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6009794.12284 | 2109513.9369200002 | 37.7728758110884 | -122.409529951052 | (37.7728758110884, -122.409529951052) | ||||
160321 | 160321 | 197508 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6009725.72224 | 2109430.36659 | 37.7726425134742 | -122.409760657749 | (37.7726425134742, -122.409760657749) | ||||
168035 | 168035 | 239718 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4818 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 10ft | 5999936.3704699995 | 2101089.09136 | 37.74918597675529 | -122.44302382201401 | (37.7491859767553, -122.443023822014) | |||
169554 | 169554 | 197514 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | 6009780.84318 | 2109499.43172 | 37.7728352390743 | -122.409574863193 | (37.7728352390743, -122.409574863193) | ||||
183895 | 183895 | 197512 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6009788.18393 | 2109495.5877 | 37.7728250956205 | -122.40954919922899 | (37.7728250956205, -122.409549199229) | ||||
188316 | 188316 | 239691 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3591 21st St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 4ft | 6004486.515980001 | 2103644.80101 | 37.756461738522 | -122.427471393514 | (37.756461738522, -122.427471393514) |
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");