Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23966 | 23966 | 221105 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009452.05657 | 2105439.4087799997 | 37.761668922891296 | -122.41042544467301 | (37.7616689228913, -122.410425444673) | |||
25164 | 25164 | 221116 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 444 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008032.554719999 | 2096752.52732 | 37.7377370207421 | -122.414720156219 | (37.7377370207421, -122.414720156219) | |||
32431 | 32431 | 204346 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1280 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995860.5873 | 2092590.7127099999 | 37.7256182793497 | -122.45650338783399 | (37.7256182793497, -122.456503387834) | |||
34327 | 34327 | 221111 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 204 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008081.346469999 | 2097637.2486099997 | 37.7401690124009 | -122.414614048819 | (37.7401690124009, -122.414614048819) | |||
36627 | 36627 | 40215 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 483 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 9 | Permit Number 41394 | 5981890.02626 | 2112509.7593099996 | 37.7794983994124 | -122.506274024618 | (37.7794983994124, -122.506274024618) | |
39176 | 39176 | 221118 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 496 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008016.22985 | 2096597.4915900002 | 37.7373104093519 | -122.414765630445 | (37.7373104093519, -122.414765630445) | |||
41519 | 41519 | 204289 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992459.80825 | 2103811.38116 | 37.7562315606514 | -122.46907574904499 | (37.7562315606514, -122.469075749045) | |||
45487 | 45487 | 221132 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2820 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008864.30785 | 2106343.82537 | 37.764119276915295 | -122.41252217085699 | (37.7641192769153, -122.412522170857) | |||
48093 | 48093 | 205530 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 144 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995914.63015 | 2093636.3873599998 | 37.728492553972394 | -122.456392145303 | (37.7284925539724, -122.456392145303) | |||
53493 | 53493 | 33102 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 375 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37343 | 6011697.96502 | 2119046.16805 | 37.799155568835 | -122.40361510367701 | (37.799155568835, -122.403615103677) | |
53893 | 53893 | 205569 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 100 Santa Monica Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5993966.5050099995 | 2097132.29462 | 37.737979422216604 | -122.46338044867201 | (37.7379794222166, -122.463380448672) | |||
55434 | 55434 | 125692 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3651 Baker St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5999123.87818 | 2121357.2001099996 | 37.8047906353434 | -122.44729198466001 | (37.8047906353434, -122.44729198466) | |||
58138 | 58138 | 33322 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 3115 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 9 | Permit Number 37465 | 6004626.67946 | 2120295.23032 | 37.8021876375982 | -122.428173235217 | (37.8021876375982, -122.428173235217) | |
59585 | 59585 | 204281 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 855 Ortega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991371.23061 | 2102452.06513 | 37.752436276838104 | -122.472741277806 | (37.7524362768381, -122.472741277806) | |||
61465 | 61465 | 221103 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009402.10993 | 2105437.04552 | 37.7616596338129 | -122.410598023702 | (37.7616596338129, -122.410598023702) | |||
64085 | 64085 | 204247 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 360 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997685.380340001 | 2093824.52357 | 37.7291106283292 | -122.450284154993 | (37.7291106283292, -122.450284154993) | |||
67082 | 67082 | 204282 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 855 Ortega St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991318.4935 | 2102451.26095 | 37.75243101579329 | -122.472923591054 | (37.7524310157933, -122.472923591054) | |||
68111 | 68111 | 221104 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009432.49535 | 2105438.1168 | 37.761664278799 | -122.41049300806101 | (37.761664278799, -122.410493008061) | |||
68660 | 68660 | 125694 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 3651 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5999115.53218 | 2121417.6212299997 | 37.8049560584444 | -122.447325218189 | (37.8049560584444, -122.447325218189) | |||
98761 | 98761 | 204293 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 124 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 5993603.8127 | 2103274.64542 | 37.754823857236204 | -122.46508043981599 | (37.7548238572362, -122.465080439816) | |||
116833 | 116833 | 107010 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 400 ALABAMA ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6008836.3 | 2106230.4 | 37.763806265083296 | -122.412611023479 | (37.7638062650833, -122.412611023479) | ||||
117024 | 117024 | 221115 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 442 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008034.6897599995 | 2096781.24622 | 37.7378159965066 | -122.414714806163 | (37.7378159965066, -122.414714806163) | |||
130310 | 130310 | 125702 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1170 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009077.34196 | 2117044.73858 | 37.7935134012698 | -122.41254183184799 | (37.7935134012698, -122.412541831848) | |||
130671 | 130671 | 33159 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2443 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 9 | Permit Number 37382 | 5985780.7157 | 2098599.2186 | 37.741532194650794 | -122.491790321831 | (37.7415321946508, -122.491790321831) | |
135058 | 135058 | 204242 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 160 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994277.66229 | 2093529.3248700001 | 37.7281044749175 | -122.462043425661 | (37.7281044749175, -122.462043425661) | |||
135339 | 135339 | 221133 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2820 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008831.47155 | 2106343.31873 | 37.7641160429416 | -122.412635706672 | (37.7641160429416, -122.412635706672) | |||
136335 | 136335 | 31160 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 401 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 9 | Permit Number 34862 | 5992970.4282599995 | 2089958.37606 | 37.7182241712773 | -122.466303127503 | (37.7182241712773, -122.466303127503) | |
137670 | 137670 | 70224 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 774 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 9 | 5991346.67049 | 2110134.70461 | 37.7735293356805 | -122.473386511602 | (37.7735293356805, -122.473386511602) | ||
148224 | 148224 | 188231 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 123 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6012859.425559999 | 2113671.68237 | 37.7844633085723 | -122.399218553795 | (37.7844633085723, -122.399218553795) | |||
155622 | 155622 | 74125 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 9 | 6007522.57983 | 2116468.5162 | 37.7918438593627 | -122.417880578935 | (37.7918438593627, -122.417880578935) | ||
156056 | 156056 | 32640 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2663 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 9 | Permit Number 37085 | 6010083.06076 | 2103949.57384 | 37.7576135254646 | -122.408137970501 | (37.7576135254646, -122.408137970501) | |
158696 | 158696 | 204316 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 184 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992299.25829 | 2097965.83058 | 37.740171904608204 | -122.469205541028 | (37.7401719046082, -122.469205541028) | |||
165173 | 165173 | 204287 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1723 12th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5992461.83589 | 2103758.6049200003 | 37.756086768014995 | -122.469064896048 | (37.756086768015, -122.469064896048) | |||
165366 | 165366 | 205592 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 30 Vasquez Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5995689.638259999 | 2100080.55801 | 37.7461737497157 | -122.457636027276 | (37.7461737497157, -122.457636027276) | |||
168364 | 168364 | 38053 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2721 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | 9 | Permit Number 40249 | 6000435.904 | 2114420.5238 | 37.785819233145205 | -122.442253327272 | (37.7858192331452, -122.442253327272) | |
168482 | 168482 | 204344 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 103 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995714.09375 | 2092731.36577 | 37.7259960674539 | -122.457019970111 | (37.7259960674539, -122.457019970111) | |||
169736 | 169736 | 40201 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 830 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 9 | Permit Number 41383 | 5983264.50092 | 2110118.09525 | 37.7730124061407 | -122.50134224763599 | (37.7730124061407, -122.501342247636) | |
173118 | 173118 | 205604 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 426 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999234.008330001 | 2095000.5896599998 | 37.732428335305 | -122.4450149543 | (37.732428335305, -122.4450149543) | ||||
174099 | 174099 | 33231 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2553 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/07/1996 12:00:00 AM | 9 | Permit Number 37417 | 5989219.0688 | 2097970.1761 | 37.7400053687963 | -122.479855786116 | (37.7400053687963, -122.479855786116) | |
185515 | 185515 | 204279 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1983 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5991574.21623 | 2101962.22104 | 37.7511030408823 | -122.47200362687799 | (37.7511030408823, -122.472003626878) | |||
187529 | 187529 | 38847 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1470 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | 9 | Permit Number 40676 | 5989942.9457 | 2105353.4021 | 37.7603197919591 | -122.47789255007099 | (37.7603197919591, -122.477892550071) |
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");