Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27946 | 27946 | 201649 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6018951.64564 | 2095587.01417 | 37.735144198837794 | -122.37688633962799 | (37.7351441988378, -122.376886339628) | |||
28462 | 28462 | 201642 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6018952.658430001 | 2095598.17526 | 37.735174900789396 | -122.37688361201599 | (37.7351749007894, -122.376883612016) | |||
33423 | 33423 | 201652 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018946.92095 | 2095551.1859 | 37.735045561194205 | -122.376900190105 | (37.7350455611942, -122.376900190105) | |||
34892 | 34892 | 201651 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6018949.0123 | 2095555.4014599998 | 37.7350572514812 | -122.376893251826 | (37.7350572514812, -122.376893251826) | |||
35550 | 35550 | 201645 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6018982.720369999 | 2095633.61521 | 37.7352738675975 | -122.37678213339301 | (37.7352738675975, -122.376782133393) | |||
38569 | 38569 | 201638 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 4ft | 6018923.171519999 | 2095473.9331900002 | 37.734832132296205 | -122.37697694364401 | (37.7348321322962, -122.376976943644) | |||
40704 | 40704 | 224455 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 1201 San Jose Ave | 46 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6004472.96299 | 2096086.53305 | 37.7357077104384 | -122.426979965259 | (37.7357077104384, -122.426979965259) | ||||
41313 | 41313 | 224456 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 1201 San Jose Ave | 47 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6004484.39806 | 2096094.7868 | 37.735731019967496 | -122.42694101743 | (37.7357310199675, -122.42694101743) | ||||
57002 | 57002 | 201637 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6018946.919840001 | 2095539.74446 | 37.7350141451746 | -122.376899400488 | (37.7350141451746, -122.376899400488) | |||
62691 | 62691 | 201647 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018952.706230001 | 2095578.53847 | 37.735120984634705 | -122.376882084965 | (37.7351209846347, -122.376882084965) | |||
64633 | 64633 | 201650 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018947.62701 | 2095560.29465 | 37.7350706109287 | -122.37689838066099 | (37.7350706109287, -122.376898380661) | |||
64968 | 64968 | 201640 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6018953.49192 | 2095604.5204099999 | 37.7351923692359 | -122.376881170334 | (37.7351923692359, -122.376881170334) | |||
75131 | 75131 | 199412 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 450 Amador St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6017962.7763 | 2099598.9904099996 | 37.7461057708787 | -122.380584028138 | (37.7461057708787, -122.380584028138) | ||||
77023 | 77023 | 201648 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6018950.3933 | 2095564.6244 | 37.735082651931705 | -122.37688911676202 | (37.7350826519317, -122.376889116762) | |||
92004 | 92004 | 23601 | DPW Maintained 3 | Eucalyptus viminalis :: Manna Gum 356 | 200X Vasquez Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
92914 | 92914 | 23600 | DPW Maintained 3 | Eucalyptus viminalis :: Manna Gum 356 | 200X Vasquez Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
134546 | 134546 | 201653 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6018946.1342400005 | 2095546.77058 | 37.7350333942595 | -122.376902603873 | (37.7350333942595, -122.376902603873) | |||
136273 | 136273 | 201639 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6018953.99087 | 2095608.77642 | 37.7352040828873 | -122.376879740411 | (37.7352040828873, -122.376879740411) | |||
146685 | 146685 | 224458 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 1201 San Jose Ave | 51 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6004518.02214 | 2096105.01586 | 37.735761007849 | -122.426825494118 | (37.735761007849, -122.426825494118) | ||||
147267 | 147267 | 199411 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 1130 Connecticut St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 6013384.0629 | 2101740.31793 | 37.7517316642935 | -122.39656681910299 | (37.7517316642935, -122.396566819103) | |||
147319 | 147319 | 201646 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018949.93188 | 2095582.2358799998 | 37.7351309842009 | -122.37689193341299 | (37.7351309842009, -122.376891933413) | |||
150303 | 150303 | 224457 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 1201 San Jose Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6004475.25628 | 2096098.33584 | 37.7357402479118 | -122.42697287681999 | (37.7357402479118, -122.42697287682) | ||||
160498 | 160498 | 201643 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6018953.750080001 | 2095594.20439 | 37.735164057679704 | -122.376879562369 | (37.7351640576797, -122.376879562369) | |||
178651 | 178651 | 201636 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6018955.1601 | 2095613.4067900002 | 37.735216861374 | -122.376876019021 | (37.735216861374, -122.376876019021) | |||
183540 | 183540 | 201644 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6018951.31321 | 2095591.04744 | 37.7351552551001 | -122.376887768675 | (37.7351552551001, -122.376887768675) | |||
188467 | 188467 | 201641 | Undocumented 2 | Eucalyptus viminalis :: Manna Gum 356 | 101 Hunters Point Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6018954.75158 | 2095601.04105 | 37.7351828849697 | -122.376876573893 | (37.7351828849697, -122.376876573893) |
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");