Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3544 | 3544 | 253465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
3567 | 3567 | 253463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
3585 | 3585 | 253464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
24102 | 24102 | 186759 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984850.1974 | 2106711.7495 | 37.7637525404811 | -122.495605915184 | (37.7637525404811, -122.495605915184) | |||
34046 | 34046 | 186310 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1800 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984966.7705 | 2102775.9332 | 37.7529527085207 | -122.49491251324899 | (37.7529527085207, -122.494912513249) | |||
36675 | 36675 | 186762 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984853.5932 | 2106716.1156 | 37.7637647274179 | -122.49559449238701 | (37.7637647274179, -122.495594492387) | |||
44625 | 44625 | 186760 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984860.8701 | 2106711.7495 | 37.7637531654529 | -122.495569002148 | (37.7637531654529, -122.495569002148) | |||
45882 | 45882 | 186748 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984868.1469 | 2106676.3356 | 37.7636563549354 | -122.495541222153 | (37.7636563549354, -122.495541222153) | |||
50007 | 50007 | 186756 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | |||
51787 | 51787 | 217831 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 Cranleigh Dr | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5991381.66969 | 2095739.8250799999 | 37.734006793868 | -122.472215938837 | (37.734006793868, -122.472215938837) | ||||
66007 | 66007 | 186752 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106688.9488 | 37.7636899929755 | -122.49560087776399 | (37.7636899929755, -122.495600877764) | |||
70133 | 70133 | 186750 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106678.2761 | 37.763660688738206 | -122.49560009051399 | (37.7636606887382, -122.495600090514) | |||
73459 | 73459 | 186747 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984869.1172 | 2106666.6331 | 37.76362977141179 | -122.495537150576 | (37.7636297714118, -122.495537150576) | |||
133677 | 133677 | 185961 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2001 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984861.3455 | 2101337.8929 | 37.74899807274279 | -122.495171051634 | (37.7489980727428, -122.495171051634) | |||
137835 | 137835 | 129468 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | ||||
151432 | 151432 | 186745 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | |||
152713 | 152713 | 129469 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1085 Vallejo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008359.28826 | 2118585.88506 | 37.7977046844857 | -122.415135501808 | (37.7977046844857, -122.415135501808) | |||
156319 | 156319 | 186749 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984860.385 | 2106678.2761 | 37.7636612284897 | -122.495568210877 | (37.7636612284897, -122.495568210877) | |||
160044 | 160044 | 186041 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1900 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 0ft | 5984992.0482 | 2102149.6578 | 37.7512346080754 | -122.494778929254 | (37.7512346080754, -122.494778929254) | |||
164300 | 164300 | 186000 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1883 47th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5981612.0444 | 2102288.7145 | 37.7514179925848 | -122.506477461595 | (37.7514179925848, -122.506477461595) | |||
171541 | 171541 | 186059 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1901 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984803.9529 | 2102180.8195 | 37.751309157700604 | -122.495431671777 | (37.7513091577006, -122.495431671777) | |||
178737 | 178737 | 186058 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1901 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984794.5256 | 2102183.7824 | 37.7513167410032 | -122.495464490464 | (37.7513167410032, -122.495464490464) | |||
184000 | 184000 | 186754 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984863.7808 | 2106693.8 | 37.763704051609004 | -122.49555761110202 | (37.763704051609, -122.495557611102) | |||
188419 | 188419 | 129470 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 45 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6008463.14234 | 2119145.61201 | 37.799247391416394 | -122.414815771241 | (37.7992473914164, -122.414815771241) |
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");