Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType ▼ | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164218 | 164218 | 185692 | Undocumented 2 | Shrub :: Shrub 98 | 2101 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984851.9348 | 2100530.8696 | 37.746781656202295 | -122.495144090409 | (37.7467816562023, -122.495144090409) | |||
| 167803 | 167803 | 187122 | Undocumented 2 | Shrub :: Shrub 98 | 2600 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985165.8082 | 2097341.5801 | 37.7380430985113 | -122.49382377418101 | (37.7380430985113, -122.493823774181) | |||
| 172267 | 172267 | 186364 | Undocumented 2 | Shrub :: Shrub 98 | 1801 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984815.8043 | 2102571.1093 | 37.7523814800587 | -122.495419470402 | (37.7523814800587, -122.495419470402) | |||
| 176597 | 176597 | 186340 | Undocumented 2 | Shrub :: Shrub 98 | 1801 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984827.0787 | 2102831.0491 | 37.7530958632805 | -122.495399651332 | (37.7530958632805, -122.495399651332) | |||
| 177379 | 177379 | 181571 | Undocumented 2 | Shrub :: Shrub 98 | 1200 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984860.385 | 2106736.0056 | 37.7638197374851 | -122.49557246911101 | (37.7638197374851, -122.495572469111) | |||
| 179154 | 179154 | 184750 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984665.0089 | 2106100.6902 | 37.7620638971415 | -122.496201328503 | (37.7620638971415, -122.496201328503) | |||
| 179730 | 179730 | 184869 | Undocumented 2 | Shrub :: Shrub 98 | 1201 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984640.7069 | 2106821.7773 | 37.764042376179205 | -122.496338586447 | (37.7640423761792, -122.496338586447) | |||
| 181183 | 181183 | 184754 | Undocumented 2 | Shrub :: Shrub 98 | 1301 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984657.4145 | 2106082.8434 | 37.762014449980704 | -122.496226277389 | (37.7620144499807, -122.496226277389) | |||
| 182690 | 182690 | 181343 | Undocumented 2 | Shrub :: Shrub 98 | 2500 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985164.5677 | 2097705.9234 | 37.739043415002705 | -122.493854905389 | (37.7390434150027, -122.493854905389) | |||
| 183333 | 183333 | 187234 | Undocumented 2 | Shrub :: Shrub 98 | 2401 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984956.0101 | 2098625.8109 | 37.7415569740276 | -122.494643790117 | (37.7415569740276, -122.494643790117) | |||
| 184478 | 184478 | 187025 | Undocumented 2 | Shrub :: Shrub 98 | 2501 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984975.6777 | 2097882.1396 | 37.7395162040617 | -122.494520977899 | (37.7395162040617, -122.494520977899) | |||
| 185026 | 185026 | 187377 | Undocumented 2 | Shrub :: Shrub 98 | 2200 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985052.2703 | 2100029.8298 | 37.7454176637381 | -122.49441443213001 | (37.7454176637381, -122.49441443213) | |||
| 187550 | 187550 | 185258 | Undocumented 2 | Shrub :: Shrub 98 | 2101 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986433.4347 | 2097526.3066 | 37.7386243913853 | -122.489454599165 | (37.7386243913853, -122.489454599165) | |||
| 1666 | 1666 | 251642 | Undocumented 2 | Shrub :: Shrub 98 | 2253 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | ||||
| 79753 | 79753 | 107409 | Undocumented 2 | Shrub :: Shrub 98 | 125 VILLA TER | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5999028.2 | 2104385.8 | 37.758186107000796 | -122.44640141076401 | (37.7581861070008, -122.446401410764) | |||||
| 90472 | 90472 | 120871 | Undocumented 2 | Shrub :: Shrub 98 | 1387 08th Ave | 1 | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 5993606.0 | 2106068.0 | 37.762493810072606 | -122.465275766733 | (37.7624938100726, -122.465275766733) | |||||
| 92261 | 92261 | 117511 | DPW Maintained 3 | Shrub :: Shrub 98 | 2634 37TH AVE | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 20 | 3x3 | 5984921.0 | 2097163.0 | 37.737538439530795 | -122.49465702329901 | (37.7375384395308, -122.494657023299) | |||
| 94709 | 94709 | 117610 | Undocumented 2 | Shrub :: Shrub 98 | 391 NEVADA ST | 1 | Unaccepted Street : Yard 14 | Landscaping 2 | Private 1 | 3x3 | 6008958.0 | 2096497.0 | 37.737087351465796 | -122.41150238578501 | (37.7370873514658, -122.411502385785) | ||||
| 118241 | 118241 | 4313 | DPW Maintained 3 | Shrub :: Shrub 98 | 727 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | DPW 2 | 08/17/2013 12:00:00 AM | 3X3 | 6002321.2517800005 | 2095689.19659 | 37.7344948117373 | -122.434390856497 | (37.7344948117373, -122.434390856497) | |||
| 119565 | 119565 | 99732 | Undocumented 2 | Shrub :: Shrub 98 | 4150 Ocean Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 5986619.2 | 2095203.6 | 37.7322576937009 | -122.48864164528798 | (37.7322576937009, -122.488641645288) | |||||
| 119638 | 119638 | 109607 | Private 5 | Shrub :: Shrub 98 | 775 Congo St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.44111470541901 | (37.7350943222142, -122.441114705419) | |||||
| 120634 | 120634 | 116580 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 123231 | 123231 | 88829 | Permitted Site 1 | Shrub :: Shrub 98 | 4437 20th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/30/2008 12:00:00 AM | 8x1 | Permit Number 51764 | 6001659.0 | 2104076.0 | 37.757485378077604 | -122.43728079846599 | (37.7574853780776, -122.437280798466) | |||
| 128554 | 128554 | 93164 | Permitted Site 1 | Shrub :: Shrub 98 | 201 Upper Ter | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x2 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 129188 | 129188 | 105003 | Undocumented 2 | Shrub :: Shrub 98 | 607 CONGO ST | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 6000094.1 | 2095817.0 | 37.73471905904071 | -122.44210000591002 | (37.7347190590407, -122.44210000591) | ||||||
| 139298 | 139298 | 92611 | Permitted Site 1 | Shrub :: Shrub 98 | 3856 23rd St | Sidewalk: Property side : Pot 6 | Landscaping 2 | Private 1 | 08/31/2009 12:00:00 AM | Permit Number 52924 | 6004067.0 | 2102488.0 | 37.753261698893496 | -122.428839761175 | (37.7532616988935, -122.428839761175) | ||||
| 143838 | 143838 | 89015 | Permitted Site 1 | Shrub :: Shrub 98 | 4437 20th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/30/2008 12:00:00 AM | 3x1 | Permit Number 51764 | 6001659.0 | 2104076.0 | 37.757485378077604 | -122.43728079846599 | (37.7574853780776, -122.437280798466) | |||
| 143940 | 143940 | 106932 | Undocumented 2 | Shrub :: Shrub 98 | 358 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 8x10 | 6007793.2 | 2105846.4 | 37.7626932925098 | -122.416191600332 | (37.7626932925098, -122.416191600332) | ||||
| 144925 | 144925 | 93163 | Permitted Site 1 | Shrub :: Shrub 98 | 201 Upper Ter | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12/22/2009 12:00:00 AM | 1x15 | 5999670.5 | 2106448.3 | 37.763885884820205 | -122.444328283325 | (37.7638858848202, -122.444328283325) | |||
| 172552 | 172552 | 140265 | Undocumented 2 | Shrub :: Shrub 98 | 2100X Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 0 | Width 0ft | 5997671.17 | 2110272.3417 | 37.7742714515841 | -122.45151917218 | (37.7742714515841, -122.45151917218) |
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");