Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23602 | 23602 | 221152 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1107 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997675.68991 | 2106703.68443 | 37.7644730917729 | -122.45124611571899 | (37.7644730917729, -122.451246115719) | |||
24343 | 24343 | 204238 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 318 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992991.89309 | 2103254.47145 | 37.7547331606106 | -122.467195142542 | (37.7547331606106, -122.467195142542) | |||
28594 | 28594 | 35262 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2231 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1998 12:00:00 AM | 10 | Permit Number 38747 | 6006326.183230001 | 2118540.89021 | 37.797466675306104 | -122.42216741420499 | (37.7974666753061, -122.422167414205) | |
39463 | 39463 | 205605 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 555 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998406.069490001 | 2094967.6325 | 37.732290553769204 | -122.447874949473 | (37.7322905537692, -122.447874949473) | |||
46333 | 46333 | 204239 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 121 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993619.97762 | 2103217.3793599997 | 37.7546675514915 | -122.4650203786 | (37.7546675514915, -122.4650203786) | |||
50257 | 50257 | 125705 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 68 Pleasant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008691.84445 | 2116822.80562 | 37.792882385661 | -122.41385998166001 | (37.792882385661, -122.41385998166) | |||
53922 | 53922 | 221100 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6009350.253169999 | 2105434.72135 | 37.7616503447144 | -122.41077721180599 | (37.7616503447144, -122.410777211806) | |||
57169 | 57169 | 221130 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007982.122380001 | 2102911.62209 | 37.754645686273996 | -122.415330414592 | (37.754645686274, -122.415330414592) | |||
57485 | 57485 | 73751 | Private 5 | Arbutus unedo :: Strawberry Tree 61 | 794-798 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/1996 12:00:00 AM | 10 | 3x3 | 5990095.37972 | 2109981.17843 | 37.7730352575459 | -122.477703639701 | (37.7730352575459, -122.477703639701) | |
65595 | 65595 | 205524 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 141 Greenwood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995982.8575 | 2093718.26393 | 37.7287212839559 | -122.456162198553 | (37.7287212839559, -122.456162198553) | |||
68108 | 68108 | 204309 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 12 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992950.0965599995 | 2099014.34812 | 37.7430884554677 | -122.467031435369 | (37.7430884554677, -122.467031435369) | |||
71231 | 71231 | 32716 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008229.60793 | 2115679.81731 | 37.7897180499914 | -122.41537839431801 | (37.7897180499914, -122.415378394318) |
75401 | 75401 | 221137 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 271 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006195.0549 | 2101607.37216 | 37.750963914861295 | -122.421417965991 | (37.7509639148613, -122.421417965991) | |||
89043 | 89043 | 113823 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1599x CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6002577.0 | 2101074.0 | 37.749294743689795 | -122.433891418078 | (37.7492947436898, -122.433891418078) | |||
110975 | 110975 | 68068 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 128 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 10 | Permit Number 31805 | 5993651.58024335 | 2103268.48440829 | 37.754809694989795 | -122.46491480033 | (37.7548096949898, -122.46491480033) | |
122013 | 122013 | 73893 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1501 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/13/1994 12:00:00 AM | 10 | 6007549.1868 | 2116472.92184 | 37.7918574535089 | -122.417788830994 | (37.7918574535089, -122.417788830994) | ||
126856 | 126856 | 98969 | DPW Maintained 3 | Arbutus unedo :: Strawberry Tree 61 | 825 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
133702 | 133702 | 204280 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1983 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991572.44859 | 2101946.22913 | 37.7510590289716 | -122.472008574033 | (37.7510590289716, -122.472008574033) | |||
141608 | 141608 | 114519 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 199x WESTWOOD DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5995156.0 | 2093967.0 | 37.7293567553632 | -122.45903868041599 | (37.7293567553632, -122.459038680416) | |||
146580 | 146580 | 221148 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 71 Woodland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997071.8183 | 2106141.02353 | 37.7628935738126 | -122.453294106749 | (37.7628935738126, -122.453294106749) | |||
147727 | 147727 | 221156 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 461 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008056.95305 | 2096731.8919400002 | 37.737681731314105 | -122.41463433930299 | (37.7376817313141, -122.414634339303) | |||
151192 | 151192 | 31864 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 1734 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1995 12:00:00 AM | 10 | Permit Number 35306 | 5992515.136390001 | 2103625.8443 | 37.75572532149229 | -122.468870905993 | (37.7557253214923, -122.468870905993) | ||
157325 | 157325 | 40205 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 531 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1999 12:00:00 AM | 10 | Permit Number 41387 | 5982523.74709 | 2112147.83586 | 37.7785419514891 | -122.50405493614099 | (37.7785419514891, -122.504054936141) | |
163472 | 163472 | 175556 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 675 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002319.00588 | 2089864.96187 | 37.7185026508577 | -122.43398243563499 | (37.7185026508577, -122.433982435635) | |||
169113 | 169113 | 205608 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 549 Joost Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5998524.77669 | 2094967.4645 | 37.7322968768837 | -122.447464541153 | (37.7322968768837, -122.447464541153) | |||
169483 | 169483 | 185801 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2610 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5986892.0814 | 2101684.6163 | 37.750068763852205 | -122.488174323251 | (37.7500687638522, -122.488174323251) | |||
169519 | 169519 | 204237 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 324 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5992972.45072 | 2103252.5485 | 37.7547267583567 | -122.467262239174 | (37.7547267583567, -122.467262239174) | |||
170226 | 170226 | 183539 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1410 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5988555.4867 | 2097656.6869 | 37.7391060350729 | -122.48212719150601 | (37.7391060350729, -122.482127191506) | |||
171572 | 171572 | 32717 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 930 Leavenworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 10 | 3x3 | Permit Number 37111 | 6008227.34815 | 2115705.62066 | 37.7897887726751 | -122.415388040436 | (37.7897887726751, -122.415388040436) |
175476 | 175476 | 221128 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 1179 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008087.19422 | 2101084.79616 | 37.749635539752205 | -122.414837763272 | (37.7496355397522, -122.414837763272) | |||
183923 | 183923 | 221163 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 271 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006196.26724 | 2101608.29317 | 37.750966512097705 | -122.421413838995 | (37.7509665120977, -122.421413838995) | |||
187853 | 187853 | 221145 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 116 Swiss Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001236.77877 | 2096472.5135700002 | 37.7365840008603 | -122.438196326893 | (37.7365840008603, -122.438196326893) |
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");