Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2524 | 2524 | 141906 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 900 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004683.4832 | 2111946.7944 | 37.7792681524686 | -122.427381601663 | (37.7792681524686, -122.427381601663) | |||
| 10212 | 10212 | 173910 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 34670 | 34670 | 185158 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2500 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5985178.5125 | 2097636.1993 | 37.7388527871834 | -122.49380155463699 | (37.7388527871834, -122.493801554637) | |||
| 46290 | 46290 | 207643 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 Funston Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992162.23499 | 2104876.45393 | 37.759138772946 | -122.47018240438899 | (37.759138772946, -122.470182404389) | |||
| 55656 | 55656 | 126560 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1005 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012009.79179 | 2119188.89054 | 37.7995648637804 | -122.402546111926 | (37.7995648637804, -122.402546111926) | |||
| 55966 | 55966 | 191103 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2041 26th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012409.65437 | 2101419.9709400004 | 37.750797784011205 | -122.399913981553 | (37.7507977840112, -122.399913981553) | |||
| 62924 | 62924 | 191663 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 535 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013137.81115 | 2110946.71833 | 37.7769966935644 | -122.398064196625 | (37.7769966935644, -122.398064196625) | |||
| 67582 | 67582 | 223634 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 Bartlett St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006707.09054 | 2102321.3371900003 | 37.752953155869605 | -122.41969794599702 | (37.7529531558696, -122.419697945997) | |||
| 75087 | 75087 | 94754 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 491 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/28/2010 12:00:00 AM | 5 | 3x3 | 6010365.49883 | 2097628.45401 | 37.7402729290463 | -122.406715716973 | (37.7402729290463, -122.406715716973) | ||
| 78498 | 78498 | 46990 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2011 26th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2002 12:00:00 AM | Permit Number 44999 | 6012426.60175733 | 2101420.79231292 | 37.7508009841444 | -122.39985543326799 | (37.7508009841444, -122.399855433268) | |||
| 82203 | 82203 | 99384 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1590 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 85361 | 85361 | 99033 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 200X Bartlett St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006692.0 | 2102600.1 | 37.7537177245237 | -122.419769910314 | (37.7537177245237, -122.419769910314) | ||
| 91184 | 91184 | 6737 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/30/2012 12:00:00 AM | 1 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 103983 | 103983 | 35074 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1541 12th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1998 12:00:00 AM | Permit Number 38627 | 5992419.71878294 | 2104964.13539049 | 37.759394405692504 | -122.46929829243 | (37.7593944056925, -122.46929829243) | ||
| 104590 | 104590 | 99025 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351X 23rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6006571.0 | 2102346.4 | 37.753014305467794 | -122.420170352411 | (37.7530143054678, -122.420170352411) | ||
| 112757 | 112757 | 117142 | Section 143 8 | Eriobotrya deflexa :: Bronze Loquat 49 | 2203x NEWCOMB AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774325 | 6011983.0 | 2098083.0 | 37.7416113834488 | -122.4011549432 | (37.7416113834488, -122.4011549432) | |
| 124753 | 124753 | 113814 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4101x 25TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 02/16/2016 06:05:00 AM | 3 | 3x3 | 6002889.0 | 2101238.0 | 37.7497627495089 | -122.43282423123999 | (37.7497627495089, -122.43282423124) | |
| 124804 | 124804 | 52807 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 25@ TEXAS Sierra St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2006 12:00:00 AM | Permit Number 48835 | 6013772.92448179 | 2104112.24559711 | 37.7582661000564 | -122.39538822301 | (37.7582661000564, -122.39538822301) | |||
| 131882 | 131882 | 114653 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2200 Post St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6001412.8316 | 2113920.3557 | 37.7845015292891 | -122.43883758329599 | (37.7845015292891, -122.438837583296) | |||
| 132755 | 132755 | 200102 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1528 Yosemite Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014998.4615 | 2092408.3352 | 37.726197669899996 | -122.39033202363899 | (37.7261976699, -122.390332023639) | |||
| 139395 | 139395 | 21343 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2592X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985018.1742183 | 2097562.094386 | 37.7386399329486 | -122.494350460592 | (37.7386399329486, -122.494350460592) | |||
| 141815 | 141815 | 98973 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 825 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 8 | 3x3 | 6008234.2 | 2102998.9 | 37.754899496003105 | -122.414464835105 | (37.7548994960031, -122.414464835105) | ||
| 157731 | 157731 | 223429 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 357 Precita Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008933.85702 | 2100227.2341400003 | 37.747328401883294 | -122.411849371861 | (37.7473284018833, -122.411849371861) | |||
| 159291 | 159291 | 223373 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 450 Bosworth St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6003068.252 | 2095170.8031799998 | 37.7331137949537 | -122.431771230282 | (37.7331137949537, -122.431771230282) | ||||
| 185693 | 185693 | 223509 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3351 23rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006634.2551 | 2102596.1896900004 | 37.7537037345613 | -122.41996932812201 | (37.7537037345613, -122.419969328122) | |||
| 186115 | 186115 | 224109 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 33 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006481.46308 | 2109309.6411099997 | 37.7721286885111 | -122.420974342101 | (37.7721286885111, -122.420974342101) |
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");