Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26604 | 26604 | 61079 | Permitted Site 1 | Nerium oleander :: Oleander 351 | 2605 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 4 | Permit Number 20916 | 5999614.0204 | 2113612.0437 | 37.7835524809627 | -122.445038661991 | (37.7835524809627, -122.445038661991) | |
31473 | 31473 | 131774 | Undocumented 2 | Nerium oleander :: Oleander 351 | 1920 Beach St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6000970.69286 | 2121018.51466 | 37.80396605054771 | -122.440876596189 | (37.8039660505477, -122.440876596189) | |||
31875 | 31875 | 232428 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3590 21st St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004408.04732 | 2103685.00061 | 37.756567678684 | -122.427745630074 | (37.756567678684, -122.427745630074) | |||
32043 | 32043 | 139851 | Undocumented 2 | Nerium oleander :: Oleander 351 | 745 GOUGH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005737.8288 | 2112306.3675 | 37.780315026191 | -122.423759752344 | (37.780315026191, -122.423759752344) | |||
46473 | 46473 | 194106 | Undocumented 2 | Nerium oleander :: Oleander 351 | 535 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014415.94841 | 2104620.80812 | 37.7596982456973 | -122.39319993362601 | (37.7596982456973, -122.393199933626) | |||
47851 | 47851 | 232425 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3590 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004459.056530001 | 2103683.49614 | 37.756566433101 | -122.427569114725 | (37.756566433101, -122.427569114725) | |||
49006 | 49006 | 232421 | Undocumented 2 | Nerium oleander :: Oleander 351 | 4412 23rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6000516.95294 | 2102297.95962 | 37.7525383228891 | -122.441102882707 | (37.7525383228891, -122.441102882707) | |||
53996 | 53996 | 232420 | Undocumented 2 | Nerium oleander :: Oleander 351 | 4443 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6001073.94489 | 2101115.72493 | 37.7493239003969 | -122.43909199051001 | (37.7493239003969, -122.43909199051) | |||
57378 | 57378 | 187519 | Undocumented 2 | Nerium oleander :: Oleander 351 | 228 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6012451.9483900005 | 2088119.4639299999 | 37.7142797106237 | -122.39883436792401 | (37.7142797106237, -122.398834367924) | |||
61271 | 61271 | 118195 | Undocumented 2 | Nerium oleander :: Oleander 351 | 858 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5985129.694569999 | 2110010.45788 | 37.7728262247758 | -122.494882469642 | (37.7728262247758, -122.494882469642) | |||
63111 | 63111 | 139856 | Undocumented 2 | Nerium oleander :: Oleander 351 | 715 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005763.0211 | 2112117.0353 | 37.7797965883541 | -122.42365913508002 | (37.7797965883541, -122.42365913508) | |||
63945 | 63945 | 194105 | Undocumented 2 | Nerium oleander :: Oleander 351 | 545 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6014417.7827 | 2104595.3243400003 | 37.759628374655705 | -122.393191806467 | (37.7596283746557, -122.393191806467) | |||
64933 | 64933 | 232422 | Undocumented 2 | Nerium oleander :: Oleander 351 | 4412 23rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6000503.77394 | 2102296.8541099997 | 37.7525345367475 | -122.441148378505 | (37.7525345367475, -122.441148378505) | |||
71893 | 71893 | 194108 | Undocumented 2 | Nerium oleander :: Oleander 351 | 368 Texas St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6013743.33639 | 2105379.84222 | 37.7617449983419 | -122.39557936170701 | (37.7617449983419, -122.395579361707) | |||
72410 | 72410 | 131770 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3161 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002794.72228 | 2119491.9933 | 37.7998783368826 | -122.434455220044 | (37.7998783368826, -122.434455220044) | |||
74129 | 74129 | 232426 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3590 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004444.4891 | 2103684.24986 | 37.7565676786584 | -122.427619547826 | (37.7565676786584, -122.427619547826) | |||
76872 | 76872 | 118194 | Undocumented 2 | Nerium oleander :: Oleander 351 | 858 35th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5985130.26203 | 2110017.353 | 37.772845190029294 | -122.494881015244 | (37.7728451900293, -122.494881015244) | |||
98153 | 98153 | 114309 | Undocumented 2 | Nerium oleander :: Oleander 351 | 595 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008020.0 | 2113749.0 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | ||||
103435 | 103435 | 92432 | Permitted Site 1 | Nerium oleander :: Oleander 351 | 534 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52822 | 6010140.0 | 2111945.0 | 37.779570317083994 | -122.40850503429701 | (37.779570317084, -122.408505034297) | ||
115277 | 115277 | 9743 | Permitted Site 1 | Nerium oleander :: Oleander 351 | 715 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4x4 | 6005764.58972 | 2112125.4972099997 | 37.7798199112352 | -122.423654310333 | (37.7798199112352, -122.423654310333) | |||
117731 | 117731 | 9762 | DPW Maintained 3 | Nerium oleander :: Oleander 351 | 745 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | |||
132503 | 132503 | 194107 | Undocumented 2 | Nerium oleander :: Oleander 351 | 1447 20th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 1ft | 6013582.3833099995 | 2104737.66515 | 37.7599727664564 | -122.396091031903 | (37.7599727664564, -122.396091031903) | |||
146334 | 146334 | 187534 | Undocumented 2 | Nerium oleander :: Oleander 351 | 96 Megan Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6012629.72487 | 2087860.6612599997 | 37.713578993957206 | -122.39820175240601 | (37.7135789939572, -122.398201752406) | |||
146759 | 146759 | 232424 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3590 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004483.72015 | 2103686.16481 | 37.7565751556437 | -122.427484009182 | (37.7565751556437, -122.427484009182) | |||
148295 | 148295 | 187537 | Undocumented 2 | Nerium oleander :: Oleander 351 | 38 Megan Dr | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 1ft | 6012599.06597 | 2088003.21705 | 37.7139687160564 | -122.398317717311 | (37.7139687160564, -122.398317717311) | |||
148933 | 148933 | 232427 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3590 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004428.1089 | 2103685.4949 | 37.7565701707031 | -122.427676285143 | (37.7565701707031, -122.427676285143) | |||
153576 | 153576 | 187539 | Undocumented 2 | Nerium oleander :: Oleander 351 | 18 Megan Dr | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 1ft | 6012576.27604 | 2088054.60024 | 37.7141085345515 | -122.398400091593 | (37.7141085345515, -122.398400091593) | |||
159562 | 159562 | 194104 | Undocumented 2 | Nerium oleander :: Oleander 351 | 801 19th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015143.45963 | 2105289.88586 | 37.761575778325295 | -122.390730569759 | (37.7615757783253, -122.390730569759) | ||||
159952 | 159952 | 131771 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3161 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002800.51817 | 2119461.63557 | 37.7997953114739 | -122.434432992409 | (37.7997953114739, -122.434432992409) | |||
161492 | 161492 | 232419 | Undocumented 2 | Nerium oleander :: Oleander 351 | 629 York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009868.938680001 | 2105140.1189099997 | 37.760870502078205 | -122.408962494142 | (37.7608705020782, -122.408962494142) | |||
163637 | 163637 | 187518 | Undocumented 2 | Nerium oleander :: Oleander 351 | 238 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6012469.15492 | 2088126.39797 | 37.714299708845296 | -122.398775381376 | (37.7142997088453, -122.398775381376) | |||
165430 | 165430 | 177852 | Undocumented 2 | Nerium oleander :: Oleander 351 | 521 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | Width 6ft | 6002035.79624 | 2090425.6768200002 | 37.720026172549794 | -122.43500145298 | (37.7200261725498, -122.43500145298) | |||
169117 | 169117 | 131772 | Undocumented 2 | Nerium oleander :: Oleander 351 | 1920 Beach St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 6001006.99118 | 2121024.03439 | 37.80398327346221 | -122.440751379974 | (37.8039832734622, -122.440751379974) | |||
170363 | 170363 | 232423 | Undocumented 2 | Nerium oleander :: Oleander 351 | 3590 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004499.74747 | 2103689.91865 | 37.7565863692953 | -122.427428848357 | (37.7565863692953, -122.427428848357) | |||
179721 | 179721 | 187540 | Undocumented 2 | Nerium oleander :: Oleander 351 | 2 Megan Dr | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 1ft | 6012559.1048 | 2088097.8051099998 | 37.7142262099584 | -122.39846247216002 | (37.7142262099584, -122.39846247216) | |||
180737 | 180737 | 57113 | Permitted Site 1 | Nerium oleander :: Oleander 351 | 531 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/1974 12:00:00 AM | 8 | Permit Number 14383 | 6001543.07582 | 2090663.01106 | 37.7206498496809 | -122.436721596137 | (37.7206498496809, -122.436721596137) | ||
184673 | 184673 | 131773 | Undocumented 2 | Nerium oleander :: Oleander 351 | 1920 Beach St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6000974.22236 | 2121019.17087 | 37.803968053338 | -122.44086442925699 | (37.803968053338, -122.440864429257) | |||
187166 | 187166 | 131775 | Undocumented 2 | Nerium oleander :: Oleander 351 | 575 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008072.74326 | 2113748.53186 | 37.784406392296795 | -122.415784324012 | (37.7844063922968, -122.415784324012) | |||
187537 | 187537 | 210578 | Undocumented 2 | Nerium oleander :: Oleander 351 | 1035 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | Width 3ft | 6000825.310219999 | 2096196.7068900003 | 37.7358032894806 | -122.43959918025601 | (37.7358032894806, -122.439599180256) |
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");