Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23492 | 23492 | 202174 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013138.83373 | 2093054.0318599998 | 37.7278672922301 | -122.39680594795401 | (37.7278672922301, -122.396805947954) | |||
24106 | 24106 | 246790 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 175 Brewster St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6010136.6415 | 2098750.10917 | 37.74333994367979 | -122.40758608083901 | (37.7433399436798, -122.407586080839) | ||||
33231 | 33231 | 181999 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2474 30th Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5987078.0557 | 2098396.6732 | 37.7410517986936 | -122.487289748097 | (37.7410517986936, -122.487289748097) | |||
36738 | 36738 | 181277 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988402.74919 | 2089827.8491900002 | 37.7176011677477 | -122.482081905481 | (37.7176011677477, -122.482081905481) | ||||
38749 | 38749 | 181998 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2476 30th Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987077.3789 | 2098389.2279 | 37.7410313164056 | -122.48729154146099 | (37.7410313164056, -122.487291541461) | |||
41031 | 41031 | 182386 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1538 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5985306.5492 | 2104723.6759 | 37.758320556835606 | -122.493881037718 | (37.7583205568356, -122.493881037718) | |||
43216 | 43216 | 203186 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 25th St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014234.68411 | 2101965.33677 | 37.752396820871894 | -122.393640982742 | (37.7523968208719, -122.393640982742) | ||||
43226 | 43226 | 118483 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981073.18846 | 2112308.0171 | 37.7788963529663 | -122.50908477858499 | (37.7788963529663, -122.509084778585) | ||||
44059 | 44059 | 199443 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 625 King St | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 6012254.773469999 | 2108757.11148 | 37.7709353106325 | -122.400965034535 | (37.7709353106325, -122.400965034535) | |||
44790 | 44790 | 244846 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6006641.954969999 | 2103569.5656 | 37.75637683445171 | -122.42001177073901 | (37.7563768344517, -122.420011770739) | |||
46093 | 46093 | 181993 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2488 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987080.4247 | 2098320.1899 | 37.7408419339653 | -122.487275940676 | (37.7408419339653, -122.487275940676) | |||
50210 | 50210 | 182350 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5985255.7552 | 2104953.475 | 37.7589485494212 | -122.49407363959699 | (37.7589485494212, -122.494073639597) | |||
51895 | 51895 | 181992 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2490 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987079.071 | 2098310.7141 | 37.7408158369886 | -122.487279925369 | (37.7408158369886, -122.487279925369) | |||
53731 | 53731 | 181995 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2482 30th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987079.071 | 2098350.9862 | 37.7409264135054 | -122.487282882666 | (37.7409264135054, -122.487282882666) | |||
59002 | 59002 | 181991 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2492 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 0ft | 5987080.0862 | 2098302.9304 | 37.740794524211104 | -122.48727584365601 | (37.7407945242111, -122.487275843656) | |||
59728 | 59728 | 244843 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 9ft | 6006632.98295 | 2103729.04135 | 37.7568142125173 | -122.4200541162 | (37.7568142125173, -122.4200541162) | |||
63268 | 63268 | 181996 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2480 30th Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987079.7478 | 2098357.7547 | 37.740945037480294 | -122.487281039603 | (37.7409450374803, -122.487281039603) | |||
64107 | 64107 | 244844 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6006630.92083 | 2103720.4372 | 37.7567904713264 | -122.420060637198 | (37.7567904713264, -122.420060637198) | |||
66362 | 66362 | 202177 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 2ft | 6013132.229119999 | 2093003.70662 | 37.7277287417687 | -122.396825253678 | (37.7277287417687, -122.396825253678) | |||
66563 | 66563 | 184459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2170 45th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 0ft | 5982352.1644 | 2100338.7067 | 37.746107363854705 | -122.503773678611 | (37.7461073638547, -122.503773678611) | |||
67895 | 67895 | 203190 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1471 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012043.2307 | 2101521.0685 | 37.7510549406325 | -122.401188218373 | (37.7510549406325, -122.401188218373) | ||||
68162 | 68162 | 181989 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2850 Ulloa St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 5987109.8673 | 2098288.0398 | 37.7407553751877 | -122.48717177975 | (37.7407553751877, -122.48717177975) | |||
130131 | 130131 | 118484 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 8349 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5981049.15965 | 2112307.0389 | 37.7788922504996 | -122.50916782963499 | (37.7788922504996, -122.509167829635) | ||||
134129 | 134129 | 244845 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 90 Bartlett St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 8ft | 6006641.10837 | 2103579.2022 | 37.756403246631606 | -122.42001538241999 | (37.7564032466316, -122.42001538242) | |||
135412 | 135412 | 137503 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1142 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 3ft | 6007446.543330001 | 2119552.3525099996 | 37.8003070257165 | -122.418362418606 | (37.8003070257165, -122.418362418606) | |||
148382 | 148382 | 217471 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1440 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 5995913.41271 | 2093587.41578 | 37.728358019885505 | -122.456392814383 | (37.7283580198855, -122.456392814383) | |||
148908 | 148908 | 118014 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 472 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 5984415.81444 | 2112632.82053 | 37.779984662684704 | -122.49754547051 | (37.7799846626847, -122.49754547051) | |||
153281 | 153281 | 202068 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Hwy 101 S On Ramp | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6013001.93809 | 2090218.0162799999 | 37.7200725469917 | -122.39708043181601 | (37.7200725469917, -122.397080431816) | ||||
155468 | 155468 | 217472 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 59 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 5996579.72389 | 2094039.2232700002 | 37.729636804572394 | -122.45412197764401 | (37.7296368045724, -122.454121977644) | |||
156730 | 156730 | 181275 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988424.04089 | 2089826.4329400002 | 37.7175985174299 | -122.482008206935 | (37.7175985174299, -122.482008206935) | ||||
157013 | 157013 | 181997 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2478 30th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987077.3789 | 2098383.8132 | 37.741016449074294 | -122.487291143841 | (37.7410164490743, -122.487291143841) | |||
157429 | 157429 | 217475 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 Castenada Ave | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5994402.7024 | 2101793.398 | 37.75080276354671 | -122.462210258014 | (37.7508027635467, -122.462210258014) | |||
162871 | 162871 | 183526 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2550 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5987093.1088 | 2097910.6765 | 37.739718258195296 | -122.487202013829 | (37.7397182581953, -122.487202013829) | |||
165577 | 165577 | 243936 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 300 Virginia Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 6006941.75615 | 2098326.05055 | 37.741996218065296 | -122.41860313204599 | (37.7419962180653, -122.418603132046) | |||
168519 | 168519 | 181276 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5988413.87941 | 2089827.13064 | 37.7175998421416 | -122.482043381217 | (37.7175998421416, -122.482043381217) | ||||
169980 | 169980 | 203189 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 889 Vermont St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6011337.056059999 | 2104206.57613 | 37.758389331013205 | -122.403819204816 | (37.7583893310132, -122.403819204816) | ||||
174501 | 174501 | 217477 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 Ventura Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5994377.24851 | 2101823.40778 | 37.750883697139 | -122.462300455497 | (37.750883697139, -122.462300455497) | |||
174910 | 174910 | 181219 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 519 Lisbon St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 6002044.02941 | 2090439.9964599998 | 37.720065958565 | -122.434974017336 | (37.720065958565, -122.434974017336) | |||
180281 | 180281 | 202175 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 2ft | 6013138.4392099995 | 2093044.77183 | 37.7278418441173 | -122.396806662905 | (37.7278418441173, -122.396806662905) | |||
185076 | 185076 | 244824 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 773 Dolores St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 6005057.02214 | 2103838.7107 | 37.757026420139 | -122.42551217995701 | (37.757026420139, -122.425512179957) | |||
186670 | 186670 | 217476 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2 Castenada Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 3ft | 5994389.54518 | 2101808.84982 | 37.7508444327326 | -122.46225687706101 | (37.7508444327326, -122.462256877061) | |||
186914 | 186914 | 202176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 100 Kalmanovitz St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 2ft | 6013132.98284 | 2093010.28184 | 37.7277468379346 | -122.396823108819 | (37.7277468379346, -122.396823108819) |
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");