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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 148012 | 148012 | 185313 | Undocumented 2 | Shrub :: Shrub 98 | 2601 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984983.1747 | 2097234.3473 | 37.7377379790483 | -122.49444731702299 | (37.7377379790483, -122.494447317023) | |||
| 150729 | 150729 | 186250 | Undocumented 2 | Shrub :: Shrub 98 | 1701 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984767.3503 | 2103112.4152 | 37.753864919503 | -122.495626952484 | (37.753864919503, -122.495626952484) | |||
| 150740 | 150740 | 184164 | Undocumented 2 | Shrub :: Shrub 98 | 1595 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5982483.9557 | 2104274.5677 | 37.7569218843537 | -122.503609385397 | (37.7569218843537, -122.503609385397) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 19473 | 19473 | 61098 | Permitted Site 1 | Shrub :: Shrub 98 | 806 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1988 12:00:00 AM | 3x3 | Permit Number 25594 | 6007925.06671696 | 2103219.75918175 | 37.7554885536992 | -122.41554954379299 | (37.7554885536992, -122.415549543793) | |
| 79808 | 79808 | 37377 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 84241 | 84241 | 37371 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 125354 | 125354 | 113803 | Permitted Site 1 | Shrub :: Shrub 98 | 806 SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007931.0 | 2103220.0 | 37.755489548438 | -122.41552904166201 | (37.755489548438, -122.415529041662) | |||
| 139023 | 139023 | 37379 | Permitted Site 1 | Shrub :: Shrub 98 | 755 Morse St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | 2 | 3x3 | Permit Number 39872 | 5998400.39464019 | 2087052.25152553 | 37.7105564274343 | -122.447325069993 | (37.7105564274343, -122.447325069993) |
| 141935 | 141935 | 65625 | Permitted Site 1 | Shrub :: Shrub 98 | 238 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | Permit Number 28533 | 6004892.15539073 | 2094035.47955331 | 37.73009967019979 | -122.42538473936399 | (37.7300996701998, -122.425384739364) | ||
| 80823 | 80823 | 98972 | DPW Maintained 3 | Shrub :: Shrub 98 | 825 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 0 | 5x5 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 111245 | 111245 | 99672 | DPW Maintained 3 | Shrub :: Shrub 98 | 1250X Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | ||
| 28447 | 28447 | 116579 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 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) | |||
| 126456 | 126456 | 116577 | Significant Tree 6 | Shrub :: Shrub 98 | 3000x 19TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 30 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) |
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");