Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25103 | 25103 | 226578 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 124 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998059.2298099995 | 2106534.17954 | 37.76402962709221 | -122.44990734536199 | (37.7640296270922, -122.449907345362) | |||
| 27819 | 27819 | 207168 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 520 Judson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996915.754480001 | 2093635.86285 | 37.728548535870104 | -122.45293118715 | (37.7285485358701, -122.45293118715) | |||
| 29133 | 29133 | 207198 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 580 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997541.97184 | 2094417.04598 | 37.7307293459865 | -122.450822633076 | (37.7307293459865, -122.450822633076) | |||
| 32289 | 32289 | 207308 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 40 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996630.86084 | 2093949.68597 | 37.7293938887121 | -122.453938729108 | (37.7293938887121, -122.453938729108) | |||
| 34210 | 34210 | 177025 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 300 Hamilton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009309.80145 | 2092849.9581799998 | 37.727093081168604 | -122.410028653892 | (37.7270930811686, -122.410028653892) | |||
| 37568 | 37568 | 207302 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 65 Hazelwood Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5996572.7806400005 | 2094082.116 | 37.72975417960021 | -122.45414907781799 | (37.7297541796002, -122.454149077818) | |||
| 40805 | 40805 | 122909 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2x 12th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5992095.78801 | 2114872.2732700002 | 37.7865807540814 | -122.471140447624 | (37.7865807540814, -122.471140447624) | ||||
| 40972 | 40972 | 185610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2251 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986429.217999999 | 2100931.4203 | 37.7479736765682 | -122.48971952481001 | (37.7479736765682, -122.48971952481) | |||
| 51665 | 51665 | 185263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2157 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986253.2809 | 2097519.1429 | 37.738594203049004 | -122.4900769498 | (37.738594203049, -122.4900769498) | |||
| 53082 | 53082 | 139036 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000642.6462 | 2113889.2265 | 37.784372208438604 | -122.441499920001 | (37.7843722084386, -122.441499920001) | |||
| 54753 | 54753 | 207286 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 80 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993623.31026 | 2093437.41863 | 37.7278144273955 | -122.464298855206 | (37.7278144273955, -122.464298855206) | |||
| 59067 | 59067 | 207271 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5991354.98649 | 2102448.1922400002 | 37.752424702544296 | -122.47279716974899 | (37.7524247025443, -122.472797169749) | |||
| 59665 | 59665 | 226580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998192.72104 | 2105385.2518599997 | 37.7608825979841 | -122.44936285530599 | (37.7608825979841, -122.449362855306) | |||
| 62397 | 62397 | 207195 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 574 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997610.81771 | 2094416.06797 | 37.7307306014402 | -122.450584552831 | (37.7307306014402, -122.450584552831) | |||
| 66041 | 66041 | 129492 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999690.83284 | 2117600.09007 | 37.794506995647 | -122.445059718941 | (37.794506995647, -122.445059718941) | |||
| 67340 | 67340 | 246731 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Ripley St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6008584.453369999 | 2099107.91594 | 37.7442353941634 | -122.41297845991001 | (37.7442353941634, -122.41297845991) | |||
| 69070 | 69070 | 207341 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 538 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998515.2216 | 2095011.0330299998 | 37.7324159597185 | -122.447500710116 | (37.7324159597185, -122.447500710116) | ||||
| 70085 | 70085 | 207207 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 101 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5998074.45641 | 2093829.28565 | 37.7291459626917 | -122.44893943651199 | (37.7291459626917, -122.448939436512) | |||
| 70323 | 70323 | 207350 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 618 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997300.95019 | 2095282.96772 | 37.7330931600175 | -122.451718319154 | (37.7330931600175, -122.451718319154) | |||
| 72894 | 72894 | 207221 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 125 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5999184.61823 | 2093461.48115 | 37.7281994846941 | -122.44507509826401 | (37.7281994846941, -122.445075098264) | ||||
| 76937 | 76937 | 42890 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988984.6022 | 2098295.481 | 37.7408849467502 | -122.48069027409402 | (37.7408849467502, -122.480690274094) | |
| 91369 | 91369 | 177012 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 78 Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002642.0398 | 2094328.25695 | 37.730776185352504 | -122.433184577831 | (37.7307761853525, -122.433184577831) | |||
| 102241 | 102241 | 121608 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 99X Lamartine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002710.0 | 2094292.0 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | ||||
| 130433 | 130433 | 207283 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 84 Manor Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993642.59329 | 2093470.80397 | 37.7279072068291 | -122.464234616632 | (37.7279072068291, -122.464234616632) | |||
| 133848 | 133848 | 207319 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995627.90301 | 2100275.99182 | 37.7467068156796 | -122.45786363851299 | (37.7467068156796, -122.457863638513) | |||
| 149892 | 149892 | 119481 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.19758 | 2112999.51907 | 37.781063436855604 | -122.493323027528 | (37.7810634368556, -122.493323027528) | |||
| 152617 | 152617 | 207174 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 451 Ulloa St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5995326.26295 | 2098236.71907 | 37.741090145688894 | -122.458759060198 | (37.7410901456889, -122.458759060198) | |||
| 155540 | 155540 | 226607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 205 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997675.15136 | 2106444.92247 | 37.7637625662095 | -122.45122931550699 | (37.7637625662095, -122.451229315507) | |||
| 156575 | 156575 | 118539 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5981337.09939 | 2112389.25007 | 37.7791349496719 | -122.508177852958 | (37.7791349496719, -122.508177852958) | ||||
| 161784 | 161784 | 226591 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 793 27th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001403.92595 | 2099956.05685 | 37.7461584981302 | -122.43786786123998 | (37.7461584981302, -122.43786786124) | ||||
| 162483 | 162483 | 207356 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 247 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998447.51248 | 2093764.7485200001 | 37.7289900868122 | -122.447645112433 | (37.7289900868122, -122.447645112433) | ||||
| 163615 | 163615 | 207164 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 Laguna Honda Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995446.92636 | 2100264.89737 | 37.7466659540754 | -122.45848863046001 | (37.7466659540754, -122.45848863046) | |||
| 163785 | 163785 | 207274 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 315 Dorantes Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5993100.15501 | 2099667.06703 | 37.7448893164068 | -122.466560010732 | (37.7448893164068, -122.466560010732) | |||
| 165783 | 165783 | 207222 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5998739.609180001 | 2093444.36182 | 37.728127069498 | -122.44661227434999 | (37.728127069498, -122.44661227435) | |||
| 166192 | 166192 | 207245 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992206.61176 | 2091125.8340200002 | 37.7213856246322 | -122.469028209083 | (37.7213856246322, -122.469028209083) | |||
| 182796 | 182796 | 207336 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 114 Melrose Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5999335.46736 | 2095537.54616 | 37.7339084817781 | -122.444702769016 | (37.7339084817781, -122.444702769016) | |||
| 184253 | 184253 | 207297 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996046.36344 | 2094274.51279 | 37.730252254734104 | -122.455982853036 | (37.7302522547341, -122.455982853036) | |||
| 185589 | 185589 | 207219 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 147 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999123.85922 | 2093459.79448 | 37.728191385403704 | -122.445285022505 | (37.7281913854037, -122.445285022505) |
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");