Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65233 | 65233 | 33556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996225.02102 | 2110420.81163 | 37.774596191384 | -122.456532373263 | (37.774596191384, -122.456532373263) | ||
| 112272 | 112272 | 1797 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2010 Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/27/1991 12:00:00 AM | 12 | 6012333.445831 | 2088436.5537268997 | 37.7151437722719 | -122.399266207491 | (37.7151437722719, -122.399266207491) | |||
| 120058 | 120058 | 33554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996192.1418699995 | 2110415.99351 | 37.7745810743751 | -122.456645759522 | (37.7745810743751, -122.456645759522) | ||
| 128606 | 128606 | 104928 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 810 Gonzalez Dr | 3 | Median : Yard 3 | Tree 1 | Private 1 | 12 | 5990385.0 | 2090588.0 | 37.7198034465129 | -122.47528570222 | (37.7198034465129, -122.47528570222) | ||||
| 153281 | 153281 | 202068 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Hwy 101 S On Ramp | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6013001.93809 | 2090218.0162799999 | 37.7200725469917 | -122.39708043181601 | (37.7200725469917, -122.397080431816) | ||||
| 181166 | 181166 | 33557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1996 12:00:00 AM | 12 | Permit Number 37664 | 5996239.10441 | 2110423.85984 | 37.774605369516394 | -122.456483876805 | (37.7746053695164, -122.456483876805) | ||
| 184842 | 184842 | 203176 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1301 Minnesota St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6015380.59839 | 2102345.27771 | 37.753503666864205 | -122.38970472391199 | (37.7535036668642, -122.389704723912) | ||||
| 186449 | 186449 | 52601 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1360WASHINGTON Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2006 12:00:00 AM | 12 | Permit Number 48694 | 6008501.73087 | 2117208.37484 | 37.7939303854283 | -122.414545082491 | (37.7939303854283, -122.414545082491) | ||
| 21082 | 21082 | 28787 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2518 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006949.0139999995 | 2103676.1713 | 37.7566868442816 | -122.418957411892 | (37.7566868442816, -122.418957411892) | |||
| 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) | |||
| 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) | ||
| 10773 | 10773 | 28540 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4754 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001487.6438 | 2091153.5571 | 37.7219936282262 | -122.43694830738701 | (37.7219936282262, -122.436948307387) | ||
| 11110 | 11110 | 28537 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4716 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001661.0091 | 2091431.1044 | 37.7227655627881 | -122.436368881923 | (37.7227655627881, -122.436368881923) | ||
| 11123 | 11123 | 28555 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4743 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001652.2787 | 2091307.3716 | 37.722425324335 | -122.436390209739 | (37.722425324335, -122.436390209739) | ||
| 11137 | 11137 | 28558 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4667 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001923.346 | 2091737.9699 | 37.723623049111296 | -122.435483982262 | (37.7236230491113, -122.435483982262) | ||
| 11198 | 11198 | 28556 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4717 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001738.1279 | 2091443.2433 | 37.7228032751332 | -122.436103167424 | (37.7228032751332, -122.436103167424) | ||
| 11469 | 11469 | 28551 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4885 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001150.501 | 2090506.6381 | 37.720198166433896 | -122.438067406183 | (37.7201981664339, -122.438067406183) | ||
| 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) | ||
| 12072 | 12072 | 28800 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4505 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002480.3523 | 2092620.1218 | 37.7260768594239 | -122.433621526187 | (37.7260768594239, -122.433621526187) | |||
| 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) | ||
| 12407 | 12407 | 28550 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4919 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001014.7517 | 2090296.9851 | 37.7196147854688 | -122.438521631633 | (37.7196147854688, -122.438521631633) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 80955 | 80955 | 28559 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4647 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6002004.69492 | 2091867.26763 | 37.7239826914316 | -122.435212017462 | (37.7239826914316, -122.435212017462) | ||
| 84329 | 84329 | 28440 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2325 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992376.3743900005 | 2094089.82777 | 37.7295338285402 | -122.46865695076099 | (37.7295338285402, -122.468656950761) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 96358 | 96358 | 28436 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2383 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992168.55554 | 2094228.20045 | 37.729901757986 | -122.46938546297702 | (37.729901757986, -122.469385462977) | ||
| 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) | ||
| 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) | ||
| 103267 | 103267 | 28470 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2295 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992499.15443 | 2093893.9061599998 | 37.729002968377294 | -122.46821824463301 | (37.7290029683773, -122.468218244633) | ||
| 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) | ||
| 108531 | 108531 | 28471 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2295 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992502.64875 | 2093884.6455400002 | 37.728977742823794 | -122.46820549121 | (37.7289777428238, -122.46820549121) | ||
| 108922 | 108922 | 28439 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2325 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992364.67777 | 2094097.6153099998 | 37.729554535492 | -122.46869795321999 | (37.729554535492, -122.46869795322) | ||
| 118654 | 118654 | 28553 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4791 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001495.20995 | 2091053.11607 | 37.7217182698376 | -122.436914966203 | (37.7217182698376, -122.436914966203) | ||
| 120677 | 120677 | 28435 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2383 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992163.8663800005 | 2094231.44033 | 37.7299103829045 | -122.469401909547 | (37.7299103829045, -122.469401909547) | ||
| 121147 | 121147 | 28431 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2439 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991850.14781 | 2094403.3644599998 | 37.7303643088426 | -122.470498978 | (37.7303643088426, -122.470498978) | ||
| 121532 | 121532 | 28775 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 4950 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000922.5163 | 2090289.03562 | 37.7195877108284 | -122.438839886053 | (37.7195877108284, -122.438839886053) | |||
| 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) | ||
| 126547 | 126547 | 28430 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2439 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991842.51952 | 2094406.3714 | 37.730372124061 | -122.47052556873001 | (37.730372124061, -122.47052556873) | ||
| 127972 | 127972 | 28557 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4681 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001872.38004 | 2091652.00525 | 37.7233841148131 | -122.43565401519 | (37.7233841148131, -122.43565401519) | ||
| 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) | |||
| 140150 | 140150 | 28545 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5098 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6000324.7175 | 2089317.7589200002 | 37.7168867757364 | -122.44083661746299 | (37.7168867757364, -122.440836617463) | ||
| 140763 | 140763 | 28541 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4760 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3X3 | 6001455.13645 | 2091107.7518200001 | 37.7218660095523 | -122.437057399169 | (37.7218660095523, -122.437057399169) | ||
| 143075 | 143075 | 28429 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2499 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5991627.582769999 | 2094536.0068700002 | 37.7307156399791 | -122.471278069527 | (37.7307156399791, -122.471278069527) | ||
| 144404 | 144404 | 28424 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2390X Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/2003 12:00:00 AM | 12 | 3X3 | 5992122.7651 | 2094324.99132 | 37.730164875296296 | -122.469550807661 | (37.7301648752963, -122.469550807661) | ||
| 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) | |||
| 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) | ||
| 10427 | 10427 | 28552 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4839 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001308.3124 | 2090760.3284 | 37.7209037164668 | -122.437540063841 | (37.7209037164668, -122.437540063841) | ||
| 10432 | 10432 | 28549 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4963 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000879.9631 | 2090072.8632 | 37.71899172902071 | -122.438971492831 | (37.7189917290207, -122.438971492831) | ||
| 10435 | 10435 | 28548 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5095 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000516.105 | 2089501.9034 | 37.7174032930481 | -122.440188283496 | (37.7174032930481, -122.440188283496) | ||
| 10447 | 10447 | 28554 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4753 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001590.7646 | 2091209.3547 | 37.722152696500004 | -122.436595837081 | (37.7221526965, -122.436595837081) | ||
| 10497 | 10497 | 28546 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5125 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000380.5163 | 2089281.6434 | 37.716790788359795 | -122.440641159733 | (37.7167907883598, -122.440641159733) | ||
| 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) | |||
| 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) | ||
| 11802 | 11802 | 28539 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4734 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6001578.802999999 | 2091300.8769999999 | 37.7224033163499 | -122.436643733228 | (37.7224033163499, -122.436643733228) | ||
| 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) | ||
| 12880 | 12880 | 28799 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4575 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002251.5336 | 2092256.7834 | 37.7250662282166 | -122.434386571875 | (37.7250662282166, -122.434386571875) | |||
| 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) | ||
| 13119 | 13119 | 28560 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 4631 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6002010.8853 | 2091868.7717 | 37.7239871728 | -122.43519072585501 | (37.7239871728, -122.435190725855) | ||
| 13149 | 13149 | 28547 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 5109 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2003 12:00:00 AM | 12 | 3x3 | 6000411.4099 | 2089335.4212 | 37.7169402093066 | -122.44053823097799 | (37.7169402093066, -122.440538230978) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 87363 | 87363 | 28422 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2012 12:00:00 AM | 12 | 3x3 | 5992640.87111 | 2093746.9102599998 | 37.728607537869294 | -122.46771763720699 | (37.7286075378693, -122.467717637207) | ||
| 89525 | 89525 | 28458 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160X Ocean Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5992795.29206 | 2093448.6567 | 37.7277975223389 | -122.467162123346 | (37.7277975223389, -122.467162123346) | ||
| 91124 | 91124 | 113402 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2032 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6006483.0 | 2117763.0 | 37.7953396281575 | -122.42156950983299 | (37.7953396281575, -122.421569509833) | ||
| 95580 | 95580 | 100555 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050X Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007651.0 | 2109542.0 | 37.7728325469688 | -122.41694527260599 | (37.7728325469688, -122.416945272606) | |||
| 102155 | 102155 | 28482 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2073 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993305.06135 | 2092906.64732 | 37.7263387103664 | -122.46536049980499 | (37.7263387103664, -122.465360499805) | ||
| 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) | ||
| 110334 | 110334 | 100554 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050X Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6007651.0 | 2109542.0 | 37.7728325469688 | -122.41694527260599 | (37.7728325469688, -122.416945272606) | |||
| 110465 | 110465 | 49637 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 63 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.772902032771505 | -122.416906845471 | (37.7729020327715, -122.416906845471) | |
| 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) | ||
| 115728 | 115728 | 474 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2790 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/1992 12:00:00 AM | 12 | 3x3 | 6008872.67231 | 2102220.8769099996 | 37.752799067118396 | -122.412201825987 | (37.7527990671184, -122.412201825987) | ||
| 126065 | 126065 | 28481 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2073 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 12 | 3x3 | 5993293.23217 | 2092912.5573200001 | 37.726354255565795 | -122.465401821504 | (37.7263542555658, -122.465401821504) | ||
| 128400 | 128400 | 28421 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2230 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2012 12:00:00 AM | 12 | 3x3 | 5992633.17801 | 2093727.0114099998 | 37.728552456339706 | -122.467742785837 | (37.7285524563397, -122.467742785837) | ||
| 139272 | 139272 | 51395 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050X Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007651.0 | 2109542.0 | 37.7728325469688 | -122.41694527260599 | (37.7728325469688, -122.416945272606) |
| 139662 | 139662 | 51396 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 63 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/13/2004 12:00:00 AM | 12 | 3x3 | Permit Number 47722 | 6007662.62246956 | 2109567.06845572 | 37.772902032771505 | -122.416906845471 | (37.7729020327715, -122.416906845471) | |
| 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) | |||
| 17051 | 17051 | 15346 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006752.3955 | 2107277.3553 | 37.766563781951106 | -122.419892925221 | (37.7665637819511, -122.419892925221) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) |
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");