Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1601 | 1601 | 102430 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010566.09371 | 2111909.33227 | 37.779496235110706 | -122.407028471514 | (37.7794962351107, -122.407028471514) | |
1602 | 1602 | 102429 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 200 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | 4x4 | Permit Number 770993 | 6010552.49087 | 2111923.99595 | 37.7795357369219 | -122.40707656363399 | (37.7795357369219, -122.407076563634) | |
1634 | 1634 | 199504 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010510.13491 | 2111932.18806 | 37.7795558601644 | -122.407223669342 | (37.7795558601644, -122.407223669342) | |
1642 | 1642 | 199503 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1009 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 770993 | 6010500.983080001 | 2111924.50305 | 37.7795342467397 | -122.40725478770099 | (37.7795342467397, -122.407254787701) | |
2853 | 2853 | 253248 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
2868 | 2868 | 253247 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
2897 | 2897 | 253249 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 570 Jessie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775513 | 6009730.1467 | 2112442.1376799997 | 37.7809123781536 | -122.40995800293301 | (37.7809123781536, -122.409958002933) | |
4287 | 4287 | 181059 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 5810 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 03:37:00 PM | 3 | Width 3ft | 5997243.54219 | 2086644.28205 | 37.7093700633606 | -122.451293980329 | (37.7093700633606, -122.451293980329) | ||
4970 | 4970 | 253749 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
5020 | 5020 | 253748 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 2x Rhode Island St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/03/2017 12:00:00 AM | 3 | 3x6 | 6011517.0 | 2108140.0 | 37.769199681039794 | -122.403473604048 | (37.7691996810398, -122.403473604048) | ||
10445 | 10445 | 24508 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5088 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1995 12:00:00 AM | 3 | 3X3 | 6000357.2418 | 2089366.5868 | 37.717022698354604 | -122.440727697577 | (37.7170226983546, -122.440727697577) | ||
10503 | 10503 | 15772 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4769 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2007 12:00:00 AM | 3 | 3x3 | 6001557.6417 | 2091157.3044 | 37.722007895755794 | -122.436706610694 | (37.7220078957558, -122.436706610694) | ||
11757 | 11757 | 15734 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4476 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1995 12:00:00 AM | 3 | 3X3 | 6002423.6538 | 2092643.0339 | 37.726136553633395 | -122.43381916618 | (37.7261365536334, -122.43381916618) | ||
21146 | 21146 | 15506 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2738 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2006 12:00:00 AM | 3 | 3x3 | 6007021.0573 | 2102399.0391 | 37.753184188782 | -122.41861769652 | (37.753184188782, -122.41861769652) | ||
22272 | 22272 | 26854 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006727.5247 | 2107586.953 | 37.76741246299579 | -122.42000092176201 | (37.7674124629958, -122.420000921762) | ||
40524 | 40524 | 246614 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 405 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6009136.11989 | 2100236.51166 | 37.7473652210349 | -122.411150613905 | (37.7473652210349, -122.411150613905) | |||
72211 | 72211 | 28774 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4626 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001950.98602 | 2092007.07057 | 37.724363508667295 | -122.43540767631 | (37.7243635086673, -122.43540767631) | |||
78467 | 78467 | 115494 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1199X OCEAN AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
79563 | 79563 | 109279 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4205 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121.0 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) |
83056 | 83056 | 108808 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 542 Moscow St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774650 | 6003656.47159 | 2090041.31767 | 37.7190626969286 | -122.42937193832199 | (37.7190626969286, -122.429371938322) | |
84834 | 84834 | 115491 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
88750 | 88750 | 115493 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
116577 | 116577 | 106315 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1199X OCEAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
126990 | 126990 | 115495 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 1199X OCEAN AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
128537 | 128537 | 109280 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4205 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121.0 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) |
129261 | 129261 | 115492 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
142429 | 142429 | 109281 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4205 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773691 | 5981200.9 | 2104121.0 | 37.7564247125175 | -122.508035196592 | (37.7564247125175, -122.508035196592) |
143786 | 143786 | 115490 | Planning Code 138.1 required 4 | Washingtonia robusta :: Mexican Fan Palm 75 | 280 BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2016 12:00:00 AM | 3 | 4x12 | Permit Number 777362 | 5996259.0 | 2091739.0 | 37.7233025441304 | -122.455064598389 | (37.7233025441304, -122.455064598389) | |
146258 | 146258 | 26855 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 3 | 3X3 | 6006730.055480001 | 2107572.9723799997 | 37.767374218099704 | -122.41999117588999 | (37.7673742180997, -122.41999117589) | ||
163853 | 163853 | 247589 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 800 Tompkins Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6008947.19059 | 2096447.5550400002 | 37.7369509800105 | -122.411536266603 | (37.7369509800105, -122.411536266603) | ||||
170054 | 170054 | 243935 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 293 Bemis St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6002891.579 | 2096165.14853 | 37.7358340238094 | -122.432453031508 | (37.7358340238094, -122.432453031508) | |||
183936 | 183936 | 244866 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 140 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6005707.387519999 | 2096634.20508 | 37.737281219162504 | -122.422750984277 | (37.7372812191625, -122.422750984277) | |||
11132 | 11132 | 1820 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 3 | 6 | 6011846.03792 | 2087600.59079 | 37.7128212089973 | -122.400892211026 | (37.7128212089973, -122.400892211026) | ||
11493 | 11493 | 15784 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 02:53:00 PM | 3 | 3X3 | 6001135.2157 | 2090596.8347 | 37.7204449566644 | -122.438126700052 | (37.7204449566644, -122.438126700052) | ||
13652 | 13652 | 21866 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015620.2045 | 2106919.86703 | 37.766077793471396 | -122.38919550889099 | (37.7660777934714, -122.389195508891) | ||
13825 | 13825 | 21872 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015641.71858 | 2106711.03714 | 37.7655055845439 | -122.38910651286601 | (37.7655055845439, -122.389106512866) | ||
13848 | 13848 | 21865 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015619.46662 | 2106949.47478 | 37.7661590490173 | -122.38920012868601 | (37.7661590490173, -122.389200128686) | ||
14545 | 14545 | 21876 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 3 | 3X3 | 6015645.96934 | 2106615.37755 | 37.7652431596794 | -122.389085130597 | (37.7652431596794, -122.389085130597) | ||
14750 | 14750 | 21878 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015649.24797 | 2106571.51851 | 37.765122914002205 | -122.389070727941 | (37.7651229140022, -122.389070727941) | ||
15167 | 15167 | 21867 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/2008 12:00:00 AM | 3 | 3X3 | 6015621.91024 | 2106888.57721 | 37.765991972979606 | -122.389187423983 | (37.7659919729796, -122.389187423983) | ||
15554 | 15554 | 21874 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015644.57338 | 2106657.85439 | 37.7653597144938 | -122.38909292500901 | (37.7653597144938, -122.389092925009) | ||
16399 | 16399 | 21870 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015638.72465 | 2106753.7729 | 37.765622761707604 | -122.38911985249399 | (37.7656227617076, -122.389119852494) | ||
16634 | 16634 | 21880 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015651.4577 | 2106526.92513 | 37.765000592730395 | -122.389059971145 | (37.7650005927304, -122.389059971145) | ||
16861 | 16861 | 21868 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015630.42851 | 2106799.74819 | 37.7657485399863 | -122.38915175774599 | (37.7657485399863, -122.389151757746) | ||
16923 | 16923 | 24346 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 95 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6006149.34547 | 2108468.08439 | 37.769799248359796 | -122.422063370746 | (37.7697992483598, -122.422063370746) | |||
17291 | 17291 | 28608 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1345 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/24/2015 09:29:00 AM | 3 | 3X3 | 5995740.3284 | 2091982.407 | 37.7239411121873 | -122.456875133176 | (37.7239411121873, -122.456875133176) | ||
21404 | 21404 | 15067 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | |||
127168 | 127168 | 28626 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1299 Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2016 08:27:00 AM | 3 | 3X | 5996084.79184 | 2091881.76593 | 37.7236845496924 | -122.455677113986 | (37.7236845496924, -122.455677113986) |
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");