Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 988 | 988 | 199496 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 4ft | 6010015.0817 | 2112492.094 | 37.781065511609604 | -122.40897579419399 | (37.7810655116096, -122.408975794194) | |||
| 3732 | 3732 | 15513 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2763 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007075.5942 | 2102308.8178 | 37.7529395319689 | -122.41842269980101 | (37.7529395319689, -122.418422699801) | |||
| 10322 | 10322 | 15786 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4840 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2013 12:00:00 AM | 12 | 3x3 | 6001077.7653 | 2090502.844 | 37.7201836118857 | -122.43831855702 | (37.7201836118857, -122.43831855702) | ||
| 10560 | 10560 | 95252 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4539 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002365.436000001 | 2092436.2557 | 37.7255654834992 | -122.434005647145 | (37.7255654834992, -122.434005647145) | |||
| 10709 | 10709 | 28542 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5036 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000555.9648 | 2089678.6918 | 37.7178909833984 | -122.44006317666401 | (37.7178909833984, -122.440063176664) | ||
| 10771 | 10771 | 28544 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5060 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000449.8979 | 2089508.0094 | 37.7174162891529 | -122.440417567822 | (37.7174162891529, -122.440417567822) | ||
| 11001 | 11001 | 15823 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 5051 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000607.6416 | 2089644.9294 | 37.717801221251 | -122.439882133799 | (37.717801221251, -122.439882133799) | ||
| 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) | ||
| 13833 | 13833 | 95855 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010497.41028 | 2112077.91159 | 37.7799552706525 | -122.407277965014 | (37.7799552706525, -122.407277965014) | |||
| 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) | ||
| 14065 | 14065 | 95854 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 185 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6010514.67057 | 2112059.04775 | 37.779904440962504 | -122.407216923546 | (37.7799044409625, -122.407216923546) | |||
| 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) | ||
| 15971 | 15971 | 21858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1830 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2000 12:00:00 AM | 6 | 3X3 | 6015621.795940001 | 2107069.76565 | 37.7664894707397 | -122.389200472218 | (37.7664894707397, -122.389200472218) | ||
| 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) | |||
| 17153 | 17153 | 15563 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2868 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007056.0095 | 2101612.1167 | 37.751025447038 | -122.418441030738 | (37.751025447038, -122.418441030738) | |||
| 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) | ||
| 17338 | 17338 | 15450 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2301 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006934.5554 | 2104894.5299 | 37.760031361018 | -122.41909383171001 | (37.760031361018, -122.41909383171) | ||
| 17343 | 17343 | 15535 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2800 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007034.0945 | 2101996.1061 | 37.752078560740706 | -122.41854404117599 | (37.7520785607407, -122.418544041176) | |||
| 17363 | 17363 | 15360 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1939 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6006819.3103 | 2107093.8027 | 37.7660635592898 | -122.41964845362699 | (37.7660635592898, -122.419648453627) | |||
| 17383 | 17383 | 15397 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2023 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006842.046 | 2106580.1715 | 37.7646545293596 | -122.41953337107799 | (37.7646545293596, -122.419533371078) | |||
| 17451 | 17451 | 28453 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2070X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993250.12022 | 2093006.3093700001 | 37.7266091892515 | -122.465557664158 | (37.7266091892515, -122.465557664158) | ||
| 17576 | 17576 | 15453 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2365 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006954.2705 | 2104542.6911 | 37.7590664034557 | -122.41900069111901 | (37.7590664034557, -122.419000691119) | ||
| 17608 | 17608 | 15472 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2480 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006923.7988 | 2103940.4395 | 37.7574110439022 | -122.419063359319 | (37.7574110439022, -122.419063359319) | ||
| 17614 | 17614 | 15444 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2243 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006909.5324 | 2105286.5572 | 37.7611063676926 | -122.41920818332599 | (37.7611063676926, -122.419208183326) | ||
| 17702 | 17702 | 15454 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2366 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006889.3715 | 2104582.8537 | 37.7591730259049 | -122.419227992101 | (37.7591730259049, -122.419227992101) | ||
| 17721 | 17721 | 15387 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006779.91 | 2106630.7221 | 37.764789829335896 | -122.41975187054399 | (37.7647898293359, -122.419751870544) | |||
| 17732 | 17732 | 15383 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1999X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006833.6968 | 2106798.1459999997 | 37.7652525658811 | -122.419577715012 | (37.7652525658811, -122.419577715012) | |||
| 17740 | 17740 | 15386 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006780.6313 | 2106653.0825 | 37.7648512663771 | -122.41975096246 | (37.7648512663771, -122.41975096246) | |||
| 18291 | 18291 | 15395 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2023 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006844.3209 | 2106537.7082 | 37.764538063234795 | -122.419522489923 | (37.7645380632348, -122.419522489923) | |||
| 18494 | 18494 | 15456 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2389 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6006956.5453 | 2104486.5788 | 37.758912460169505 | -122.418988843881 | (37.7589124601695, -122.418988843881) | |||
| 18777 | 18777 | 15489 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2663 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007048.2964 | 2102838.0926 | 37.754391262739205 | -122.41855462931801 | (37.7543912627392, -122.418554629318) | ||
| 19283 | 19283 | 15537 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2800 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007036.6354 | 2101941.4773 | 37.7519287055577 | -122.41853138097 | (37.7519287055577, -122.41853138097) | |||
| 19321 | 19321 | 15351 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1911 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006804.043 | 2107232.3827 | 37.766443207322105 | -122.419711093977 | (37.7664432073221, -122.419711093977) | |||
| 19337 | 19337 | 28465 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 20 | 3X3 | 5991890.46795 | 2094463.9111900001 | 37.7305328863621 | -122.470363994616 | (37.7305328863621, -122.470363994616) | ||
| 19380 | 19380 | 15382 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1999X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006833.1096 | 2106780.5299 | 37.7652041631326 | -122.419578496054 | (37.7652041631326, -122.419578496054) | |||
| 19517 | 19517 | 15447 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2268 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006864.2573 | 2105151.4928 | 37.7607329624144 | -122.41935518891 | (37.7607329624144, -122.41935518891) | |||
| 19704 | 19704 | 15388 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006783.5165 | 2106606.9191 | 37.764724675050104 | -122.41973770750299 | (37.7647246750501, -122.419737707503) | |||
| 19865 | 19865 | 15432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2128 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006812.3772 | 2105921.7678 | 37.7628450358121 | -122.419589270998 | (37.7628450358121, -122.419589270998) | |||
| 19883 | 19883 | 15534 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2800 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007034.0945 | 2102010.0809 | 37.7521169323545 | -122.418545032046 | (37.7521169323545, -122.418545032046) | |||
| 19958 | 19958 | 15493 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2701 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007060.4288 | 2102561.3228 | 37.75363199924939 | -122.418493048091 | (37.7536319992494, -122.418493048091) | |||
| 20054 | 20054 | 15449 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2290 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006865.6984 | 2105042.6887 | 37.7604342928211 | -122.41934248602502 | (37.7604342928211, -122.419342486025) | ||
| 20059 | 20059 | 15488 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2659 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6007044.505 | 2102886.6221 | 37.754524300175795 | -122.41857118207399 | (37.7545243001758, -122.418571182074) | ||
| 20246 | 20246 | 15531 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2799X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007089.2431 | 2102129.107 | 37.75244685546971 | -122.418362758053 | (37.7524468554697, -122.418362758053) | |||
| 20251 | 20251 | 15569 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2886 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6007059.8208 | 2101565.7457 | 37.7508983373741 | -122.41842456321301 | (37.7508983373741, -122.418424563213) | |||
| 20283 | 20283 | 15532 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2799X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007089.2431 | 2102145.7891 | 37.7524926607109 | -122.418363940776 | (37.7524926607109, -122.418363940776) | |||
| 20301 | 20301 | 15438 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006822.465 | 2105789.9059 | 37.762483542066704 | -122.419545024984 | (37.7624835420667, -122.419545024984) | ||
| 20502 | 20502 | 15536 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2800 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007035.3649 | 2101963.7099 | 37.7519896796829 | -122.418537350921 | (37.7519896796829, -122.418537350921) | |||
| 20606 | 20606 | 15451 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2337 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4x4 | 6006940.6216 | 2104730.7429 | 37.7595819815227 | -122.419061234067 | (37.7595819815227, -122.419061234067) | ||
| 20637 | 20637 | 28466 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991883.040519999 | 2094469.1856200001 | 37.7305469391855 | -122.470390056066 | (37.7305469391855, -122.470390056066) | ||
| 20791 | 20791 | 15507 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2733 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007071.0446 | 2102413.4595 | 37.753226598055 | -122.41844585243601 | (37.753226598055, -122.418445852436) | |||
| 20945 | 20945 | 15473 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2501 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6007001.2834 | 2103755.6033 | 37.7569078893914 | -122.41878227799101 | (37.7569078893914, -122.418782277991) | ||
| 20971 | 20971 | 15348 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1905X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006806.3918 | 2107279.3589 | 37.7665723252126 | -122.41970630335199 | (37.7665723252126, -122.419706303352) | |||
| 21219 | 21219 | 15384 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1999X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006831.9352 | 2106820.4597 | 37.7653137348321 | -122.41958539125 | (37.7653137348321, -122.41958539125) | |||
| 21306 | 21306 | 15355 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1924 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006751.5378 | 2107181.3028 | 37.766299996101 | -122.41988907525 | (37.766299996101, -122.41988907525) | |||
| 21352 | 21352 | 15530 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2799X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6007090.0014 | 2102107.8754 | 37.752388601025295 | -122.418358630452 | (37.7523886010253, -122.418358630452) | |||
| 21432 | 21432 | 15474 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2515 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6007000.5252 | 2103706.3156 | 37.756772514034 | -122.418781404781 | (37.756772514034, -122.418781404781) | ||
| 21517 | 21517 | 15533 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2799X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6007088.4849 | 2102162.4711 | 37.7525384229961 | -122.418367745483 | (37.7525384229961, -122.418367745483) | |||
| 21592 | 21592 | 15389 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006783.5165 | 2106591.7718 | 37.764683084119895 | -122.419736632649 | (37.7646830841199, -122.419736632649) | |||
| 21746 | 21746 | 28469 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 16 | 3x3 | 5991803.10743 | 2094513.5211900002 | 37.7306640516002 | -122.47066962200199 | (37.7306640516002, -122.470669622002) | ||
| 21933 | 21933 | 15385 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006779.1887 | 2106674.7215 | 37.7649106007235 | -122.41975748758001 | (37.7649106007235, -122.41975748758) | |||
| 22193 | 22193 | 15487 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2637 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/13/1992 12:00:00 AM | 12 | 4X4 | 6007039.9554 | 2102983.6811 | 37.7547905457997 | -122.41859379809999 | (37.7547905457997, -122.4185937981) | ||
| 22194 | 22194 | 15476 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2540 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1993 12:00:00 AM | 18 | 4X4 | 6006952.2887 | 2103573.3458 | 37.7564046935445 | -122.418938794072 | (37.7564046935445, -122.418938794072) | ||
| 26642 | 26642 | 27703 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 30 | 5X5 | 5995069.03366 | 2092243.1445 | 37.7246184644438 | -122.45921454824101 | (37.7246184644438, -122.459214548241) | ||
| 50542 | 50542 | 56949 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 87 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/27/1974 12:00:00 AM | 16 | Permit Number 14201 | 6010069.06775 | 2112529.00786 | 37.7811698923233 | -122.408791633752 | (37.7811698923233, -122.408791633752) | ||
| 70541 | 70541 | 102432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 4x4 | 6010557.78599 | 2112071.21552 | 37.779940263668706 | -122.40706862532801 | (37.7799402636687, -122.407068625328) | |||
| 77853 | 77853 | 28484 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2001 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993534.8398 | 2092775.81542 | 37.725992726912395 | -122.464556677434 | (37.7259927269124, -122.464556677434) | ||
| 77903 | 77903 | 25222 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1975 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993747.869419999 | 2092685.5092 | 37.7257570464481 | -122.463813701632 | (37.7257570464481, -122.463813701632) | ||
| 79550 | 79550 | 15486 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2619 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1992 12:00:00 AM | 12 | 3X3 | 6007061.32817 | 2103067.66688 | 37.755022354733896 | -122.418525840095 | (37.7550223547339, -122.418525840095) | ||
| 80612 | 80612 | 28634 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1001 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 25 | 5X5 | 5996752.18528 | 2091690.06821 | 37.7231964704228 | -122.453356228535 | (37.7231964704228, -122.453356228535) | ||
| 84411 | 84411 | 678 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3323X 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006894.8894879995 | 2102019.509041 | 37.7521349819704 | -122.41902709370001 | (37.7521349819704, -122.4190270937) | |||
| 85633 | 85633 | 28464 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991972.677497401 | 2094408.8386932998 | 37.7303864239 | -122.470075778183 | (37.7303864239, -122.470075778183) | ||
| 88489 | 88489 | 28433 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2425 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991953.12175 | 2094350.44875 | 37.730224969150896 | -122.470139134356 | (37.7302249691509, -122.470139134356) | ||
| 89453 | 89453 | 28583 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 89640 | 89640 | 28591 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5995836.7436481 | 2092012.5698365 | 37.7240294680883 | -122.45654402330901 | (37.7240294680883, -122.456544023309) | ||
| 90307 | 90307 | 87716 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1490 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 3x4 | 5995451.1237 | 2092197.4835700002 | 37.724515049874505 | -122.457890417782 | (37.7245150498745, -122.457890417782) | ||
| 90309 | 90309 | 26392 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1615X Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007128.16796 | 2109448.9564900002 | 37.772547648160895 | -122.418747213269 | (37.7725476481609, -122.418747213269) | |||
| 92472 | 92472 | 28425 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2390X Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992110.499009999 | 2094330.64063 | 37.7301796779751 | -122.469593623835 | (37.7301796779751, -122.469593623835) | ||
| 93041 | 93041 | 619 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3146 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 18 | 3x3 | 6008066.00463 | 2102184.1145200003 | 37.752652829489705 | -122.414988836945 | (37.7526528294897, -122.414988836945) | ||
| 94338 | 94338 | 28432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2425 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991942.44608 | 2094354.15031 | 37.730234515527 | -122.47017631066002 | (37.730234515527, -122.47017631066) | ||
| 97244 | 97244 | 87718 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1405X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4x4 | 5995623.94864 | 2092020.8189400001 | 37.724039898691004 | -122.457280214367 | (37.724039898691, -122.457280214367) | ||
| 97655 | 97655 | 87715 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1490 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 4x3 | 5995451.1237 | 2092197.4835700002 | 37.724515049874505 | -122.457890417782 | (37.7245150498745, -122.457890417782) | ||
| 97788 | 97788 | 15799 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4950 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | ||
| 99541 | 99541 | 15369 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1950X Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | |||
| 99556 | 99556 | 679 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3323X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6006894.8894879995 | 2102019.509041 | 37.7521349819704 | -122.41902709370001 | (37.7521349819704, -122.4190270937) | |||
| 100260 | 100260 | 28408 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1649 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994840.68599 | 2092241.1236 | 37.724599784912 | -122.460003765056 | (37.724599784912, -122.460003765056) | ||
| 100682 | 100682 | 28407 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1649 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994828.46401 | 2092243.5478700001 | 37.7246057384269 | -122.460046190114 | (37.7246057384269, -122.460046190114) | ||
| 101268 | 101268 | 28418 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1942 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 3X3 | 5993852.42214 | 2092713.3110099998 | 37.7258394078668 | -122.463454290216 | (37.7258394078668, -122.463454290216) | ||
| 102619 | 102619 | 28582 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1100 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 18 | 4X4 | 5996838.9416251 | 2091728.3014296002 | 37.7233064222609 | -122.453059088902 | (37.7233064222609, -122.453059088902) | ||
| 103027 | 103027 | 28483 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2001 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5993534.8398 | 2092775.81542 | 37.725992726912395 | -122.464556677434 | (37.7259927269124, -122.464556677434) | ||
| 103090 | 103090 | 15755 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4669 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2006 12:00:00 AM | 12 | 3x3 | 6001907.5344845 | 2091721.0874415 | 37.7235757956571 | -122.43553743265801 | (37.7235757956571, -122.435537432658) | ||
| 104508 | 104508 | 15364 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1950X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6006764.6486243 | 2107014.2225799 | 37.7658419717714 | -122.419831870418 | (37.7658419717714, -122.419831870418) | |||
| 104996 | 104996 | 28405 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1735 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 18 | 5X5 | 5994613.7507 | 2092228.8598200001 | 37.724553056880296 | -122.46078735712 | (37.7245530568803, -122.46078735712) |
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");