Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17504 | 17504 | 15470 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2467 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1992 12:00:00 AM | 12 | 4X4 | 6006982.3266 | 2104010.3832 | 37.757606388854605 | -122.418865906959 | (37.7576063888546, -122.418865906959) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 17971 | 17971 | 15480 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2601 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1994 12:00:00 AM | 12 | 4X4 | 6007030.0978 | 2103104.2466 | 37.755121036020604 | -122.418636437773 | (37.7551210360206, -122.418636437773) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 602 | 602 | 15498 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.41865020170799 | (37.7536532168709, -122.418650201708) | |||
| 22135 | 22135 | 15500 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2710 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102497.935 | 37.7534556236904 | -122.41863150374701 | (37.7534556236904, -122.418631503747) | |||
| 21091 | 21091 | 15502 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2712 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007019.0925 | 2102444.8849 | 37.7533099602486 | -122.41862774204901 | (37.7533099602486, -122.418627742049) | |||
| 20677 | 20677 | 15503 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2721 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007064.9784 | 2102504.4523 | 37.7534761019861 | -122.418473282249 | (37.7534761019861, -122.418473282249) | |||
| 20366 | 20366 | 15504 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2729 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007071.0446 | 2102456.6811 | 37.7533452746903 | -122.418448916916 | (37.7533452746903, -122.418448916916) | |||
| 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) | ||
| 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) | |||
| 123634 | 123634 | 15508 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2737 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007147.25057 | 2102426.2072099997 | 37.753265890059794 | -122.41818321983801 | (37.7532658900598, -122.418183219838) | |||
| 20013 | 20013 | 15512 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2749 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007073.3194 | 2102357.3473 | 37.753072654833296 | -122.418434007286 | (37.7530726548333, -122.418434007286) | |||
| 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) | |||
| 18126 | 18126 | 15514 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2756 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007024.332 | 2102304.0728 | 37.752923617389705 | -122.418599638138 | (37.7529236173897, -122.418599638138) | |||
| 20675 | 20675 | 15518 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2765 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007077.869 | 2102263.3214 | 37.752814737300604 | -122.418411607402 | (37.7528147373006, -122.418411607402) | |||
| 20857 | 20857 | 15519 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2768 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007027.5439 | 2102261.5951 | 37.7528071641561 | -122.41858551881901 | (37.7528071641561, -122.418585518819) | |||
| 20577 | 20577 | 15523 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2777 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007081.6604 | 2102211.0006 | 37.7526712897583 | -122.418394786513 | (37.7526712897583, -122.418394786513) | |||
| 20000 | 20000 | 15524 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2779 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6007088.4849 | 2102183.7027 | 37.752596720125396 | -122.41836925076099 | (37.7525967201254, -122.418369250761) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 19316 | 19316 | 15543 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2830 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 18 | 3X3 | 6007038.8586 | 2101864.2983 | 37.7517169147733 | -122.418518220595 | (37.7517169147733, -122.418518220595) | ||
| 17359 | 17359 | 15544 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2831 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007105.1669 | 2101841.7215 | 37.7516586567519 | -122.418287316619 | (37.7516586567519, -122.418287316619) | |||
| 138907 | 138907 | 15546 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2834 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007035.770959999 | 2101848.49078 | 37.7516733371001 | -122.418527777286 | (37.7516733371001, -122.418527777286) | |||
| 21745 | 21745 | 15549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2840 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007044.5756 | 2101802.0469 | 37.7515463084579 | -122.41849403667 | (37.7515463084579, -122.41849403667) | |||
| 21244 | 21244 | 15551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007105.1669 | 2101800.0164 | 37.751544144042 | -122.418284359977 | (37.751544144042, -122.418284359977) | |||
| 21541 | 21541 | 15552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2846 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6007045.846 | 2101751.2294 | 37.751406846694 | -122.418486040429 | (37.751406846694, -122.418486040429) | |||
| 112457 | 112457 | 15556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2853 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007106.55999 | 2101746.86 | 37.7513982670828 | -122.41827577404 | (37.7513982670828, -122.41827577404) | |||
| 20420 | 20420 | 15557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2859 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007111.2331 | 2101709.0236 | 37.7512946399846 | -122.41825693151199 | (37.7512946399846, -122.418256931512) | |||
| 19811 | 19811 | 15562 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2869 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007115.4036 | 2101660.115 | 37.7511605828473 | -122.418239042192 | (37.7511605828473, -122.418239042192) | |||
| 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) | |||
| 18762 | 18762 | 15566 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2875 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007116.1618 | 2101613.8603 | 37.7510336206374 | -122.41823314117799 | (37.7510336206374, -122.418233141178) | |||
| 144881 | 144881 | 15568 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2884 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007053.29862 | 2101564.0899 | 37.7508934237609 | -122.418447000183 | (37.7508934237609, -122.418447000183) | |||
| 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) | |||
| 17751 | 17751 | 15573 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2899 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6007123.7446 | 2101516.8013 | 37.7507675455055 | -122.41820003848999 | (37.7507675455055, -122.41820003849) | |||
| 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) | ||
| 11995 | 11995 | 15738 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4516 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1997 12:00:00 AM | 12 | 3X3 | 6002290.9845 | 2092433.856 | 37.725554668943204 | -122.434262847922 | (37.7255546689432, -122.434262847922) | ||
| 12846 | 12846 | 15741 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4531 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2000 12:00:00 AM | 12 | 3x3 | 6002397.2069 | 2092488.3059999999 | 37.7257102048968 | -122.433899536724 | (37.7257102048968, -122.433899536724) | ||
| 12396 | 12396 | 15742 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4534 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/1999 12:00:00 AM | 12 | 3X3 | 6002267.3808 | 2092395.6017 | 37.725448291506204 | -122.43434171007601 | (37.7254482915062, -122.434341710076) | ||
| 13033 | 13033 | 15743 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4545 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2001 12:00:00 AM | 12 | 3x3 | 6002337.7208 | 2092395.6969 | 37.7254525452522 | -122.434098558087 | (37.7254525452522, -122.434098558087) | ||
| 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) | ||
| 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) | ||
| 12148 | 12148 | 15777 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4826 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2013 12:00:00 AM | 14 | 3X3 | 6001241.8395 | 2090763.6886 | 37.7209091632567 | -122.43777008073401 | (37.7209091632567, -122.437770080734) | ||
| 12884 | 12884 | 15778 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4830 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 15 | 3x3 | 6001221.4914 | 2090732.7596 | 37.7208230821415 | -122.437838203744 | (37.7208230821415, -122.437838203744) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 13075 | 13075 | 15809 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4971 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 16 | 3x3 | 6000847.9253 | 2090031.6718 | 37.7188768038041 | -122.43907928418501 | (37.7188768038041, -122.439079284185) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 82314 | 82314 | 16263 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 636X Monterey Blvd | 3 | 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) | ||
| 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) | ||
| 118455 | 118455 | 16270 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 670X Monterey Blvd | 2 | 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) | ||
| 78182 | 78182 | 16288 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | |||
| 84266 | 84266 | 16289 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 700X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997448.036427 | 2094744.2173306 | 37.7316223027997 | -122.45117096626998 | (37.7316223027997, -122.45117096627) | ||
| 11231 | 11231 | 16408 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1186X Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | TR | 6001104.60764 | 2087178.31507 | 37.7110567247495 | -122.43798776335 | (37.7110567247495, -122.43798776335) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 22032 | 22032 | 24579 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2862 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007054.1039 | 2101659.758 | 37.751156151932996 | -122.41845099825599 | (37.751156151933, -122.418450998256) | |||
| 18216 | 18216 | 24604 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1850 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2004 12:00:00 AM | 6 | 3X3 | 6006726.6671 | 2107610.9661 | 37.7674783489788 | -122.420005592363 | (37.7674783489788, -122.420005592363) | ||
| 18428 | 18428 | 25049 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 30 | 20 | 6005065.417330001 | 2102966.79857 | 37.7546328277698 | -122.425421098419 | (37.7546328277698, -122.425421098419) | ||
| 21999 | 21999 | 25056 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 900X Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005074.95095 | 2102753.03228 | 37.7540464140318 | -122.42537291722999 | (37.7540464140318, -122.42537291723) | |||
| 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) | |||
| 20631 | 20631 | 25060 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005096.113419999 | 2102391.61943 | 37.7530552540956 | -122.425274016077 | (37.7530552540956, -122.425274016077) | |||
| 17966 | 17966 | 25063 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005101.20924 | 2102268.05958 | 37.7527162753581 | -122.42524760211501 | (37.7527162753581, -122.425247602115) | |||
| 17262 | 17262 | 25065 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005108.04672 | 2102186.2977 | 37.7524921625065 | -122.42521813940901 | (37.7524921625065, -122.425218139409) | |||
| 18812 | 18812 | 25066 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005105.419480001 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | |||
| 17162 | 17162 | 25069 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640770995 | -122.42518562892599 | (37.752118640771, -122.425185628926) | |||
| 19386 | 19386 | 25103 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005223.79386 | 2100066.14764 | 37.746677257659705 | -122.424667058263 | (37.7466772576597, -122.424667058263) | |||
| 19141 | 19141 | 25104 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005230.71957 | 2100053.05302 | 37.7466416939779 | -122.424642178499 | (37.7466416939779, -122.424642178499) | |||
| 20590 | 20590 | 25105 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1400X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005226.29827 | 2100039.91633 | 37.7466053739367 | -122.424656532567 | (37.7466053739367, -122.424656532567) |
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");