Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 11567 | 11567 | 1857 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010751.52595 | 2086559.13987 | 37.7099004816803 | -122.404601950438 | (37.7099004816803, -122.404601950438) | |||
| 11630 | 11630 | 1793 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012296.32723 | 2088174.84774 | 37.7144231111167 | -122.399376144697 | (37.7144231111167, -122.399376144697) | |||
| 12292 | 12292 | 1840 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011305.78262 | 2087356.70002 | 37.7121213835762 | -122.40274237725401 | (37.7121213835762, -122.402742377254) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 21785 | 21785 | 25131 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1600X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005285.7039 | 2098966.45887 | 37.74366125975121 | -122.42437477586901 | (37.7436612597512, -122.424374775869) | |||
| 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) | ||
| 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) | ||
| 83701 | 83701 | 16214 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 530X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5998569.7206668 | 2094722.0869743999 | 37.731625696446706 | -122.44729150596599 | (37.7316256964467, -122.447291505966) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 97172 | 97172 | 16261 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 636X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997868.038561299 | 2094745.6362508 | 37.731650237153104 | -122.449719044874 | (37.7316502371531, -122.449719044874) | ||
| 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) | ||
| 97785 | 97785 | 1774 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000X Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012375.8565272 | 2088505.2474916999 | 37.7153347551878 | -122.399124435859 | (37.7153347551878, -122.399124435859) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 106919 | 106919 | 15440 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2224 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/10/1992 12:00:00 AM | 18 | 4X4 | 6006834.95821 | 2105372.78301 | 37.7613389236012 | -122.419472221327 | (37.7613389236012, -122.419472221327) | ||
| 108446 | 108446 | 23052 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1065 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1992 12:00:00 AM | 15 | 4X4 | 6006449.25295 | 2103416.3322 | 37.7559452321174 | -122.420667325317 | (37.7559452321174, -122.420667325317) | ||
| 110388 | 110388 | 112172 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 998X MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010071.0 | 2112545.0 | 37.7812139111906 | -122.40878607767901 | (37.7812139111906, -122.408786077679) | ||||
| 111393 | 111393 | 1809 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | |||
| 113000 | 113000 | 28452 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2070X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993250.0142 | 2093008.07718 | 37.726614037109606 | -122.465558159035 | (37.7266140371096, -122.465558159035) | ||
| 115534 | 115534 | 23054 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1081 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1992 12:00:00 AM | 12 | 4X4 | 6006403.948580001 | 2103302.7071 | 37.7556306904017 | -122.420815936586 | (37.7556306904017, -122.420815936586) | ||
| 117607 | 117607 | 16269 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 670X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997650.6660656 | 2094749.4324283001 | 37.731648221723205 | -122.450470814769 | (37.7316482217232, -122.450470814769) | ||
| 123379 | 123379 | 28428 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2499 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991618.4954 | 2094538.91045 | 37.730723086818706 | -122.471309697155 | (37.7307230868187, -122.471309697155) | ||
| 128162 | 128162 | 28610 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1107 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 18 | 5X5 | 5996451.82773 | 2091748.4966099998 | 37.7233396801105 | -122.45439871889799 | (37.7233396801105, -122.454398718898) | ||
| 139686 | 139686 | 1799 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | |||
| 145369 | 145369 | 6107 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 600X El Camino Del Mar | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 15-HOA | 5986691.2678849995 | 2115146.1691739 | 37.787018710699 | -122.48985866316099 | (37.787018710699, -122.489858663161) | |||
| 146701 | 146701 | 102431 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6010575.8749400005 | 2112088.03468 | 37.7799874573922 | -122.40700723309601 | (37.7799874573922, -122.407007233096) | |||
| 148069 | 148069 | 244856 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 431x Alabama St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 6009332.074580001 | 2100182.02874 | 37.747226610324205 | -122.410469167039 | (37.7472266103242, -122.410469167039) | |||
| 150822 | 150822 | 181256 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010998.20467 | 2086964.34233 | 37.7110268699605 | -122.40377787107799 | (37.7110268699605, -122.403777871078) | |||
| 187703 | 187703 | 187521 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 100x Mary Teresa St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 6012597.41848 | 2087914.4030799998 | 37.7137247587658 | -122.398317184005 | (37.7137247587658, -122.398317184005) | |||
| 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) | |||
| 10446 | 10446 | 1841 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6011283.06964 | 2087344.7309400002 | 37.712087250691 | -122.40282003911301 | (37.712087250691, -122.402820039113) | |||
| 11400 | 11400 | 1858 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2500 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6010736.7682300005 | 2086529.19155 | 37.709817424799 | -122.404650849269 | (37.709817424799, -122.404650849269) | |||
| 11580 | 11580 | 1821 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/30/1991 12:00:00 AM | 6 | 6 | 6011817.461569999 | 2087571.87835 | 37.712740776339295 | -122.400988964593 | (37.7127407763393, -122.400988964593) | ||
| 13232 | 13232 | 1794 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6 | 6012280.2141 | 2088145.3083400002 | 37.7143411037303 | -122.399429765893 | (37.7143411037303, -122.399429765893) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 18277 | 18277 | 25059 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005094.91106 | 2102418.8508099997 | 37.7531299572042 | -122.425280111693 | (37.7531299572042, -122.425280111693) | |||
| 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) | ||
| 19459 | 19459 | 15076 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5995952.59829 | 2089005.6317099999 | 37.7157797770894 | -122.455926258705 | (37.7157797770894, -122.455926258705) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 29208 | 29208 | 181257 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010977.11587 | 2086929.96483 | 37.7109312981009 | -122.40384834192801 | (37.7109312981009, -122.403848341928) | |||
| 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) | ||
| 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) | ||
| 97318 | 97318 | 1810 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2040 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012267.4866135 | 2088237.9390645002 | 37.7145947398058 | -122.399480256716 | (37.7145947398058, -122.399480256716) | ||
| 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) | ||
| 101386 | 101386 | 1800 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2020 Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6 | 6012311.362568799 | 2088370.0571878997 | 37.7149599552833 | -122.399337871901 | (37.7149599552833, -122.399337871901) | ||
| 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) | |||
| 104786 | 104786 | 16262 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 636X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997868.038561299 | 2094745.6362508 | 37.731650237153104 | -122.449719044874 | (37.7316502371531, -122.449719044874) | ||
| 105609 | 105609 | 28635 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1001 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2003 12:00:00 AM | 21 | 5X5 | 5996764.463409999 | 2091686.23626 | 37.723186652559 | -122.45331350914 | (37.723186652559, -122.45331350914) | ||
| 106605 | 106605 | 15797 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4950 Mission St | 2 | 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) | ||
| 115639 | 115639 | 666 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 3297X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/1992 12:00:00 AM | 18 | 4x4 | 6007079.62061 | 2102029.84762 | 37.752173770171794 | -122.418388996947 | (37.7521737701718, -122.418388996947) |
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");