Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8008 | 8008 | 39924 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
83513 | 83513 | 102091 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
35603 | 35603 | 204716 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 155 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992699.213880001 | 2098207.72713 | 37.7408591943976 | -122.467840257748 | (37.7408591943976, -122.467840257748) | |||
18868 | 18868 | 15071 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1X Minerva St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5995959.8595900005 | 2089005.6685900001 | 37.7157802951115 | -122.45590116312201 | (37.7157802951115, -122.455901163122) | |||
116569 | 116569 | 49132 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Valdez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2003 12:00:00 AM | Permit Number 46261 | 5996360.20601003 | 2094239.45226773 | 37.7301739953755 | -122.454895331277 | (37.7301739953755, -122.454895331277) | ||
94670 | 94670 | 109400 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
53963 | 53963 | 205923 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 266 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998304.035759999 | 2093569.7761099997 | 37.7284465374612 | -122.448127087008 | (37.7284465374612, -122.448127087008) | ||||
18455 | 18455 | 51904 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | |||
53767 | 53767 | 222709 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000333.10816 | 2106866.5537099997 | 37.7650720879349 | -122.44206655213699 | (37.7650720879349, -122.442066552137) | |||
3005 | 3005 | 208852 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 42 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001113.97001 | 2095223.0116299998 | 37.733146173254205 | -122.43853142959101 | (37.7331461732542, -122.438531429591) | ||
125842 | 125842 | 37280 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | |||
62729 | 62729 | 96749 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
112126 | 112126 | 37302 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
101966 | 101966 | 37855 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 50 Ina Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | |||
173385 | 173385 | 175810 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 La Grande Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6005231.38021 | 2091782.6619 | 37.7239330883183 | -122.424051850035 | (37.7239330883183, -122.424051850035) | ||||
39239 | 39239 | 175813 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6005348.05368 | 2093155.48995 | 37.727709159929105 | -122.42374609402201 | (37.7277091599291, -122.423746094022) | ||||
75485 | 75485 | 175814 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 11 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6005376.332880001 | 2093192.89602 | 37.727813465104 | -122.423650990705 | (37.727813465104, -122.423650990705) | ||||
126150 | 126150 | 42826 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
52153 | 52153 | 125934 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1715 Taylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008711.31794 | 2118818.3670900003 | 37.7983627993626 | -122.41393383309799 | (37.7983627993626, -122.413933833098) | |||
97134 | 97134 | 122681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
81823 | 81823 | 36071 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39187 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
3511 | 3511 | 247940 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.2881400003 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | |||
45007 | 45007 | 248046 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 38 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010555.404680001 | 2099417.48898 | 37.745195855721995 | -122.406185107956 | (37.745195855722, -122.406185107956) | ||||
141053 | 141053 | 51954 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 82 Mary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2005 12:00:00 AM | Permit Number 48176 | 6010868.83737248 | 2112458.01845687 | 37.781019735711006 | -122.40601981145599 | (37.781019735711, -122.406019811456) | |||
146973 | 146973 | 187576 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 72 Bishop St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010826.85106 | 2089479.8583099998 | 37.7179243930824 | -122.40454707471301 | (37.7179243930824, -122.404547074713) | ||||
63986 | 63986 | 188409 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6011983.90541 | 2103708.46876 | 37.757057753421 | -122.40154709194799 | (37.757057753421, -122.401547091948) | |||
54560 | 54560 | 175803 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 421 Wheeler Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011997.87722 | 2086794.11576 | 37.7106152574533 | -122.400310793023 | (37.7106152574533, -122.400310793023) | |||
12503 | 12503 | 93870 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012462.01959 | 2086667.4072599998 | 37.7102932120209 | -122.398697717749 | (37.7102932120209, -122.398697717749) |
62795 | 62795 | 188412 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014026.1658 | 2105339.44297 | 37.761649798808996 | -122.394598331744 | (37.761649798809, -122.394598331744) | |||
79940 | 79940 | 37260 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) |
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");