Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3076 | 3076 | 227975 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200X 29th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 4 | Width 3ft | Permit Number 49086 | 6005200.1380900005 | 2099049.18147 | 37.7438835649874 | -122.424676525409 | (37.7438835649874, -122.424676525409) | |
5968 | 5968 | 18166 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1450 Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6005153.199 | 2114441.8923 | 37.786145628959204 | -122.42593431751101 | (37.7861456289592, -122.425934317511) | |||
16105 | 16105 | 35453 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 790 Peninsula Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/1998 12:00:00 AM | Permit Number 38883 | ||||||||
25626 | 25626 | 129738 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 6 John Maher St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6012361.066869999 | 2119691.7640299997 | 37.800965237719204 | -122.40136592529801 | (37.8009652377192, -122.401365925298) | |||
28107 | 28107 | 129718 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1087 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006845.74669 | 2120464.39586 | 37.8027774273877 | -122.42050619192699 | (37.8027774273877, -122.420506191927) | |||
28836 | 28836 | 200258 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 46 Boardman Pl | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011826.839269999 | 2109963.92529 | 37.7742250657728 | -122.40253015436501 | (37.7742250657728, -122.402530154365) | |||
29002 | 29002 | 208061 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992248.52602 | 2101024.65147 | 37.748567713538996 | -122.46960356926901 | (37.748567713539, -122.469603569269) | |||
36349 | 36349 | 227836 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1850 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008694.58559 | 2107455.21864 | 37.7671613794327 | -122.413187787894 | (37.7671613794327, -122.413187787894) | |||
39655 | 39655 | 142188 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000411.8524 | 2110252.886 | 37.774374595004204 | -122.442037282737 | (37.7743745950042, -122.442037282737) | |||
50162 | 50162 | 32664 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 750 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37093 | 6011928.74882851 | 2109868.72792778 | 37.773969364433 | -122.402170934506 | (37.773969364433, -122.402170934506) | ||
58277 | 58277 | 191531 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016181.25153 | 2107212.70143 | 37.766912939908295 | -122.387275369984 | (37.7669129399083, -122.387275369984) | |||
59133 | 59133 | 227950 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 998 York St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009943.9384 | 2103453.89323 | 37.756244706952295 | -122.408584148445 | (37.7562447069523, -122.408584148445) | |||
60865 | 60865 | 121710 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 880 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 6014421.90164 | 2103226.1823299997 | 37.7558692345973 | -122.39308176182199 | (37.7558692345973, -122.393081761822) | ||||
60910 | 60910 | 97503 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 2105 Funston Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | Permit Number 768347 | 5992229.0 | 2101082.8 | 37.7487262458818 | -122.469675321985 | (37.7487262458818, -122.469675321985) | |||
64112 | 64112 | 191115 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1201 22nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6014343.6764 | 2103848.6809400003 | 37.757574136063 | -122.39339585366001 | (37.757574136063, -122.39339585366) | |||
65638 | 65638 | 101218 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 444 De Haro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012013.595980001 | 2106263.07985 | 37.764073805372 | -122.401623956992 | (37.764073805372, -122.401623956992) | |||
68065 | 68065 | 129733 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011893.56883 | 2119123.92391 | 37.7993799919624 | -122.40294371569401 | (37.7993799919624, -122.402943715694) | |||
70250 | 70250 | 142195 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 333 BAKER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6000674.1127 | 2110102.0455 | 37.7739753669119 | -122.44111925345501 | (37.7739753669119, -122.441119253455) | |||
78478 | 78478 | 117133 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 660 Mississippi St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6014096.85518034 | 2104132.8866965002 | 37.7583407871762 | -122.394269365711 | (37.7583407871762, -122.394269365711) | ||||
80078 | 80078 | 38278 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 645 Texas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1998 12:00:00 AM | Permit Number 40367 | 6014125.41454299 | 2103884.52035605 | 37.75766041435771 | -122.394153206319 | (37.7576604143577, -122.394153206319) | |||
82830 | 82830 | 50459 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1798 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | Permit Number 47103 | 5993770.16230084 | 2103266.48951861 | 37.7548110540457 | -122.46450456921801 | (37.7548110540457, -122.464504569218) | |||
97451 | 97451 | 32933 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 17th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
100463 | 100463 | 45697 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 399 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/2001 12:00:00 AM | Permit Number 44376 | 6012660.71426976 | 2112434.35553992 | 37.7810548194134 | -122.39981911790701 | (37.7810548194134, -122.399819117907) | |||
108069 | 108069 | 53167 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 200@ DOLORES 29th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49086 | 6005262.81392251 | 2099055.78685749 | 37.7439052414634 | -122.424460276459 | (37.7439052414634, -122.424460276459) | ||
122586 | 122586 | 37995 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 650 Texas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/1998 12:00:00 AM | Permit Number 40210 | 6013817.86875392 | 2104108.88491558 | 37.758259371972706 | -122.395232549515 | (37.7582593719727, -122.395232549515) | |||
123711 | 123711 | 208032 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 245 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993439.73777 | 2104571.93456 | 37.7583764149554 | -122.46574210073601 | (37.7583764149554, -122.465742100736) | |||
125512 | 125512 | 100497 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1899X Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008692.6 | 2107433.7 | 37.7671021827668 | -122.413193133966 | (37.7671021827668, -122.413193133966) | |||
136647 | 136647 | 191541 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6014398.75245 | 2103666.33403 | 37.7570765105783 | -122.393192617642 | (37.7570765105783, -122.393192617642) | |||
136861 | 136861 | 129726 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1055 Greenwich St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007892.05327 | 2119913.90484 | 37.8013248262425 | -122.41684640354299 | (37.8013248262425, -122.416846403543) | |||
146442 | 146442 | 208131 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 55 Linares Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994041.4329 | 2102104.78116 | 37.7516369342059 | -122.463482145784 | (37.7516369342059, -122.463482145784) | |||
147758 | 147758 | 139772 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 FILLMORE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003218.7813 | 2113279.7549 | 37.7828451806991 | -122.43254384602501 | (37.7828451806991, -122.432543846025) | |||
147806 | 147806 | 208146 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 40 Garcia Ave | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5995205.6435 | 2099446.88271 | 37.7444060207274 | -122.45926372915001 | (37.7444060207274, -122.45926372915) | |||
158575 | 158575 | 51642 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 1300 @ EDDY ST Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 47930 | 6003249.3404 | 2113069.0257 | 37.782268304126795 | -122.432423068554 | (37.7822683041268, -122.432423068554) | |||
160515 | 160515 | 129697 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6000546.57197 | 2116195.20818 | 37.7906983622821 | -122.441997876317 | (37.7906983622821, -122.441997876317) | |||
162699 | 162699 | 191554 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Wisconsin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6012600.577740001 | 2106799.00837 | 37.765578082474605 | -122.399631376779 | (37.7655780824746, -122.399631376779) | |||
165115 | 165115 | 227913 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Mars St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999590.52655 | 2105633.3680000002 | 37.761643721212295 | -122.444546312179 | (37.7616437212123, -122.444546312179) | |||
173203 | 173203 | 99323 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 Vicente St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5989330.3766 | 2097681.8666 | 37.73922021170971 | -122.479449846275 | (37.7392202117097, -122.479449846275) | |||
173733 | 173733 | 138688 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001355.4899 | 2114547.7912 | 37.7862210437499 | -122.43908094903 | (37.7862210437499, -122.43908094903) | |||
173917 | 173917 | 208122 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994754.50081 | 2099786.0148400003 | 37.7453112450104 | -122.46084824916299 | (37.7453112450104, -122.460848249163) | |||
178697 | 178697 | 191124 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 601 Carolina St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6012423.59359 | 2105049.6302900002 | 37.760764811978 | -122.400120660154 | (37.760764811978, -122.400120660154) | |||
183591 | 183591 | 246071 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 7 Central Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999960.6775 | 2108354.2152 | 37.769135603145706 | -122.44346156363399 | (37.7691356031457, -122.443461563634) |
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");