Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 833 | 833 | 251388 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 1658 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2017 12:00:00 AM | 3 | 6014992.0461800005 | 2094842.7959900002 | 37.732881854221894 | -122.39052423440701 | (37.7328818542219, -122.390524234407) | |||
| 1451 | 1451 | 251539 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981086.0 | 2103156.0 | 37.753768326371 | -122.50836092480499 | (37.753768326371, -122.508360924805) | ||||
| 1459 | 1459 | 251538 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2001 12:00:00 AM | 3x3 | 5981086.0 | 2103156.0 | 37.753768326371 | -122.50836092480499 | (37.753768326371, -122.508360924805) | |||
| 17101 | 17101 | 24976 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 270 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004851.39659 | 2106772.57706 | 37.7650705015285 | -122.426432203477 | (37.7650705015285, -122.426432203477) | |||
| 17207 | 17207 | 25101 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1450X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005235.8244 | 2099843.7861200003 | 37.746067383302496 | -122.424609642834 | (37.7460673833025, -122.424609642834) | |||
| 17315 | 17315 | 25086 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1250X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 20 | 6005173.10518 | 2101007.42475 | 37.7492589252724 | -122.424909291539 | (37.7492589252724, -122.424909291539) | |||
| 17546 | 17546 | 25011 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 500X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004936.76982 | 2105288.28685 | 37.7609998192165 | -122.426031247048 | (37.7609998192165, -122.426031247048) | |||
| 17780 | 17780 | 25133 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1600X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005290.85076 | 2098882.50869 | 37.743431042298106 | -122.42435100951599 | (37.7434310422981, -122.424351009516) | |||
| 18263 | 18263 | 25057 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 900X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005079.27857 | 2102722.52778 | 37.753962900284904 | -122.425355780639 | (37.7539629002849, -122.425355780639) | |||
| 18533 | 18533 | 24993 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 300 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004868.62064 | 2106470.5041400003 | 37.764242055039794 | -122.426351120609 | (37.7642420550398, -122.426351120609) | |||
| 18584 | 18584 | 25128 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1600X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005296.07948 | 2098802.5491 | 37.7432117867064 | -122.424327244027 | (37.7432117867064, -122.424327244027) | |||
| 20153 | 20153 | 25114 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1500X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005252.81807 | 2099553.25269 | 37.7452706046555 | -122.424530218307 | (37.7452706046555, -122.424530218307) | |||
| 20552 | 20552 | 24977 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 270 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004858.207769999 | 2106759.66345 | 37.765035428867606 | -122.426407725729 | (37.7650354288676, -122.426407725729) | |||
| 21480 | 21480 | 24990 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 300 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004865.2254 | 2106541.92962 | 37.7644379804469 | -122.426367949619 | (37.7644379804469, -122.426367949619) | |||
| 21506 | 21506 | 25050 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 900X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6005068.237380001 | 2102929.64641 | 37.7545309759388 | -122.425408702171 | (37.7545309759388, -122.425408702171) | |||
| 21644 | 21644 | 25132 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1600X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005290.57321 | 2098924.72185 | 37.743546934357 | -122.42435497101201 | (37.743546934357, -122.424354971012) | |||
| 21954 | 21954 | 25134 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 1600X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005292.60846 | 2098839.2697400004 | 37.7433124172319 | -122.424341857108 | (37.7433124172319, -122.424341857108) | |||
| 23981 | 23981 | 39601 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 375 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 20 | Permit Number 41004 | 6011207.62517 | 2106615.88788 | 37.76499752963429 | -122.40443642482 | (37.7649975296343, -122.40443642482) | |
| 24175 | 24175 | 221317 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6005983.198059999 | 2100540.62132 | 37.74802291412821 | -122.422074813715 | (37.7480229141282, -122.422074813715) | |||
| 24528 | 24528 | 220701 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3200x Cesar Chavez St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6008127.92361 | 2100571.71997 | 37.7482290360503 | -122.41466061482001 | (37.7482290360503, -122.41466061482) | |||
| 26272 | 26272 | 221314 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006208.09255 | 2100562.38879 | 37.7480953644201 | -122.421298681694 | (37.7480953644201, -122.421298681694) | |||
| 27382 | 27382 | 220720 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6009105.68993 | 2100578.18161 | 37.7483016643881 | -122.411279971504 | (37.7483016643881, -122.411279971504) | |||
| 32767 | 32767 | 221303 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6007015.521380001 | 2100564.44765 | 37.7481465061704 | -122.4185067616 | (37.7481465061704, -122.4185067616) | |||
| 33376 | 33376 | 221293 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 6009914.910569999 | 2100575.90442 | 37.7483407633146 | -122.408481534905 | (37.7483407633146, -122.408481534905) | |||
| 36161 | 36161 | 221291 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 2800 Mariposa St | 9 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6009015.3373 | 2105931.014 | 37.7629942663949 | -122.411970627468 | (37.7629942663949, -122.411970627468) | |||
| 37381 | 37381 | 220716 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6009255.72081 | 2100578.93816 | 37.74831215498521 | -122.410761220066 | (37.7483121549852, -122.410761220066) | |||
| 40228 | 40228 | 221294 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6009933.74132 | 2100573.95707 | 37.7483364708711 | -122.408416281006 | (37.7483364708711, -122.408416281006) | |||
| 46588 | 46588 | 220698 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3200x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008249.71012 | 2100572.75018 | 37.7482387064504 | -122.41423955223999 | (37.7482387064504, -122.41423955224) | |||
| 49560 | 49560 | 220715 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6009276.8217 | 2100578.88918 | 37.748313203588 | -122.410688249989 | (37.748313203588, -122.410688249989) | |||
| 50862 | 50862 | 221283 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 7ft | 6005964.92172 | 2109129.81976 | 37.771605811889295 | -122.422748322291 | (37.7716058118893, -122.422748322291) | |||
| 51383 | 51383 | 220726 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6008719.674819999 | 2100576.13539 | 37.7482743888655 | -122.41261466163601 | (37.7482743888655, -122.412614661636) | |||
| 52352 | 52352 | 221312 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006319.7284699995 | 2100564.13231 | 37.748106444967206 | -122.420912771811 | (37.7481064449672, -122.420912771811) | |||
| 53164 | 53164 | 221287 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005922.32152 | 2109128.4640099998 | 37.7715996856938 | -122.42289558268601 | (37.7715996856938, -122.422895582686) | |||
| 53646 | 53646 | 221315 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006188.08632 | 2100559.69525 | 37.7480868406308 | -122.42136767137501 | (37.7480868406308, -122.421367671375) | |||
| 54529 | 54529 | 220722 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6008961.02829 | 2100577.3162 | 37.7482911738142 | -122.411780148348 | (37.7482911738142, -122.411780148348) | |||
| 55805 | 55805 | 221306 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6006829.97888 | 2100561.42314 | 37.7481277543884 | -122.419148148164 | (37.7481277543884, -122.419148148164) | |||
| 55886 | 55886 | 220703 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6007996.96806 | 2100573.00592 | 37.7482252085331 | -122.415113547572 | (37.7482252085331, -122.415113547572) | |||
| 56102 | 56102 | 220729 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6008603.15351 | 2100574.46613 | 37.748263265148104 | -122.413017472476 | (37.7482632651481, -122.413017472476) | |||
| 58158 | 58158 | 221288 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 7ft | 6005916.40156 | 2109112.96669 | 37.7715567997353 | -122.422914958583 | (37.7715567997353, -122.422914958583) | |||
| 60997 | 60997 | 221307 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6006805.947430001 | 2100560.05338 | 37.748122639966795 | -122.41923115111099 | (37.7481226399668, -122.419231151111) | |||
| 61518 | 61518 | 220721 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008980.2117099995 | 2100577.3064900003 | 37.748292223309704 | -122.41171381166401 | (37.7482922233097, -122.411713811664) | |||
| 62517 | 62517 | 221313 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006298.52695 | 2100563.9468900003 | 37.7481047407526 | -122.42098607287599 | (37.7481047407526, -122.420986072876) | |||
| 62655 | 62655 | 221308 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6006729.87847 | 2100559.75105 | 37.7481175255011 | -122.41949417401699 | (37.7481175255011, -122.419494174017) | |||
| 62942 | 62942 | 220732 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 1237 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009257.4233099995 | 2101989.2398099997 | 37.7521846249245 | -122.41085492311899 | (37.7521846249245, -122.410854923119) | |||
| 64460 | 64460 | 123180 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 783 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 5992855.90755 | 2110145.86563 | 37.773647259932396 | -122.468166695245 | (37.7736472599324, -122.468166695245) | |||
| 67786 | 67786 | 220709 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3300x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6007353.87086 | 2100568.68035 | 37.7481771703365 | -122.41733705747 | (37.7481771703365, -122.41733705747) | |||
| 68185 | 68185 | 221319 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6005944.18408 | 2100538.31841 | 37.7480143903463 | -122.42220955912599 | (37.7480143903463, -122.422209559126) | |||
| 73546 | 73546 | 220727 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6008637.9480099995 | 2100575.89586 | 37.7482691440156 | -122.41289725473 | (37.7482691440156, -122.41289725473) | |||
| 74945 | 74945 | 220699 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3200x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6008223.943 | 2100572.77424 | 37.748237325104206 | -122.41432865616801 | (37.7482373251042, -122.414328656168) | |||
| 74990 | 74990 | 221301 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6010534.61794 | 2100761.75741 | 37.7488857605716 | -122.40635168490499 | (37.7488857605716, -122.406351684905) | |||
| 77153 | 77153 | 221292 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 501 Alabama St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6008997.77018 | 2105852.6052900003 | 37.76277798843729 | -122.41202584491998 | (37.7627779884373, -122.41202584492) | |||
| 78455 | 78455 | 24984 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 292 Dolores St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 79001 | 79001 | 115079 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5981053.87958296 | 2103176.2415425 | 37.7538220108937 | -122.508473505042 | (37.7538220108937, -122.508473505042) | ||||
| 86498 | 86498 | 107113 | Significant Tree 6 | Brahea edulis :: Guadalupe Palm 115 | 2100 MARKET ST | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6004034.0 | 2107672.1 | 37.767494134010896 | -122.429323526179 | (37.7674941340109, -122.429323526179) | ||||||
| 95160 | 95160 | 24983 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 292 Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 20 | 6004817.953366901 | 2106647.0197827998 | 37.7647238606763 | -122.42653893424699 | (37.7647238606763, -122.426538934247) | |||
| 99298 | 99298 | 79418 | Planning Code 138.1 required 4 | Brahea edulis :: Guadalupe Palm 115 | 1746 Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/27/2001 12:00:00 AM | 3x3 | 5981053.87958296 | 2103176.2415425 | 37.7538220108937 | -122.508473505042 | (37.7538220108937, -122.508473505042) | |||
| 101451 | 101451 | 112125 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 117 PROSPECT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5x6 | 6006924.0 | 2098775.0 | 37.7432279331325 | -122.41869635779 | (37.7432279331325, -122.41869635779) | |||
| 120537 | 120537 | 115204 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 1225X Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777371 | 6009246.038980001 | 2101881.5428 | 37.751888274647705 | -122.410886686356 | (37.7518882746477, -122.410886686356) | |||
| 124143 | 124143 | 115205 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 1225X Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | Permit Number 777371 | 6009628.2 | 2102049.6 | 37.752371143807295 | -122.40957697453199 | (37.7523711438073, -122.409576974532) | |||
| 127082 | 127082 | 25055 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 990X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | |||
| 132395 | 132395 | 220718 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6009145.58301 | 2100577.74902 | 37.7483027138982 | -122.411141991203 | (37.7483027138982, -122.411141991203) | |||
| 133406 | 133406 | 221302 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6007028.6086800005 | 2100564.17932 | 37.7481465061591 | -122.418461487031 | (37.7481465061591, -122.418461487031) | |||
| 134004 | 134004 | 220704 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 10ft | 6007823.26067 | 2100571.91799 | 37.748212457945 | -122.415714147211 | (37.748212457945, -122.415714147211) | |||
| 135570 | 135570 | 220719 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6009124.86555 | 2100577.78994 | 37.7483016643873 | -122.411213634799 | (37.7483016643873, -122.411213634799) | |||
| 136140 | 136140 | 220733 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 1237 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6009257.54901 | 2102010.66421 | 37.752243458586996 | -122.41085600141899 | (37.752243458587, -122.410856001419) | |||
| 138182 | 138182 | 39602 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 375 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1998 12:00:00 AM | 21 | Permit Number 41004 | 6011209.6144900005 | 2106581.95431 | 37.764904466879294 | -122.40442715548201 | (37.7649044668793, -122.404427155482) | |
| 142757 | 142757 | 175571 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 1145 Russia Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 6004133.69387 | 2089325.8548599998 | 37.717125198844 | -122.427671417122 | (37.717125198844, -122.427671417122) | |||
| 147060 | 147060 | 220730 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 1245 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009263.7479 | 2101886.6346299998 | 37.7519032486524 | -122.410825805761 | (37.7519032486524, -122.410825805761) | |||
| 147391 | 147391 | 220711 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6007975.24897 | 2100571.11254 | 37.748218789163104 | -122.41518851775 | (37.7482187891631, -122.41518851775) | |||
| 148961 | 148961 | 220700 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3200x Cesar Chavez St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008142.60052 | 2100572.92924 | 37.7482331810283 | -122.414609947908 | (37.7482331810283, -122.414609947908) | |||
| 149219 | 149219 | 220706 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3300x Cesar Chavez St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6007309.307569999 | 2100568.57948 | 37.748174386036 | -122.417491149123 | (37.748174386036, -122.417491149123) | |||
| 149997 | 149997 | 221282 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 7ft | 6005974.66789 | 2109113.44306 | 37.7715613952811 | -122.42271344567301 | (37.7715613952811, -122.422713445673) | |||
| 150986 | 150986 | 221299 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 6010495.09944 | 2100750.8681400004 | 37.7488536502806 | -122.406487573365 | (37.7488536502806, -122.406487573365) | |||
| 151135 | 151135 | 220731 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 1245 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009260.111740001 | 2101937.6364 | 37.7520430842361 | -122.41084198187 | (37.7520430842361, -122.41084198187) | |||
| 152431 | 152431 | 220710 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3300x Cesar Chavez St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6007335.71167 | 2100569.3305200003 | 37.748177933862 | -122.41739989758999 | (37.748177933862, -122.41739989759) | |||
| 155128 | 155128 | 220723 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6008940.31084 | 2100577.35759 | 37.7482901252064 | -122.41185179192101 | (37.7482901252064, -122.411851791921) | |||
| 155732 | 155732 | 221318 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 10ft | 6005963.52235 | 2100538.85266 | 37.7480169480361 | -122.42214272601002 | (37.7480169480361, -122.42214272601) | |||
| 158486 | 158486 | 221320 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3200x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008271.26847 | 2100572.43199 | 37.7482390437115 | -122.414164981352 | (37.7482390437115, -122.414164981352) | |||
| 159351 | 159351 | 221289 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 2800 Mariposa St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6009185.07 | 2105937.33918 | 37.7630211552339 | -122.411384024848 | (37.7630211552339, -122.411384024848) | |||
| 159604 | 159604 | 220714 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6007851.34371 | 2100572.1206099996 | 37.748214592933394 | -122.415617050982 | (37.7482145929334, -122.415617050982) | |||
| 162080 | 162080 | 221296 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 6010117.571380001 | 2100603.21353 | 37.7484270955515 | -122.407782660967 | (37.7484270955515, -122.407782660967) | |||
| 162339 | 162339 | 220708 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3300x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6007490.2712 | 2100569.40378 | 37.7481868299661 | -122.416865439509 | (37.7481868299661, -122.416865439509) | |||
| 164068 | 164068 | 221311 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006340.93025 | 2100564.31807 | 37.7481081500844 | -122.42083946986799 | (37.7481081500844, -122.420839469868) | |||
| 164285 | 164285 | 221309 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6006710.87077 | 2100560.14098 | 37.748117525522105 | -122.41955992977199 | (37.7481175255221, -122.419559929772) | |||
| 166069 | 166069 | 220702 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3200x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 10 | Width 10ft | 6008108.227030001 | 2100572.1230099997 | 37.7482290360599 | -122.414728753735 | (37.7482290360599, -122.414728753735) | |||
| 166571 | 166571 | 221295 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6009951.63524 | 2100574.2891 | 37.7483383846059 | -122.408354427415 | (37.7483383846059, -122.408354427415) | |||
| 166628 | 166628 | 221284 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 7ft | 6005955.036180001 | 2109112.17277 | 37.7715567997324 | -122.42278126266001 | (37.7715567997324, -122.42278126266) | |||
| 168563 | 168563 | 220707 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3300x Cesar Chavez St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6007513.03873 | 2100568.93739 | 37.7481868299766 | -122.416786676871 | (37.7481868299766, -122.416786676871) | |||
| 170512 | 170512 | 220717 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3050x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6009231.95113 | 2100579.80545 | 37.74831320359171 | -122.410843476569 | (37.7483132035917, -122.410843476569) | |||
| 173103 | 173103 | 221298 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010150.44695 | 2100616.45833 | 37.748465303245396 | -122.40766991113999 | (37.7484653032454, -122.40766991114) | |||
| 174200 | 174200 | 221304 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 10ft | 6006999.9222099995 | 2100563.83599 | 37.7481439484975 | -122.418560659758 | (37.7481439484975, -122.418560659758) | |||
| 176447 | 176447 | 221316 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3500x Cesar Chavez St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 10ft | 6006164.906830001 | 2100554.27339 | 37.748070646539 | -122.421447440342 | (37.748070646539, -122.421447440342) | |||
| 176706 | 176706 | 123175 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 745 10th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5992848.69959 | 2110368.8816 | 37.7742591855672 | -122.46820785517201 | (37.7742591855672, -122.468207855172) | |||
| 177078 | 177078 | 220712 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3250x Cesar Chavez St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6007959.12606 | 2100570.6784200002 | 37.748216691058005 | -122.415244239723 | (37.748216691058, -122.415244239723) | |||
| 177115 | 177115 | 220728 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008622.10298 | 2100574.90672 | 37.7482655386311 | -122.412951976664 | (37.7482655386311, -122.412951976664) | |||
| 177458 | 177458 | 221286 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 100x McCoppin St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 11 | Width 7ft | 6005932.045 | 2109110.97186 | 37.77155220509079 | -122.42286070518 | (37.7715522050908, -122.42286070518) | |||
| 177575 | 177575 | 220725 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3100x Cesar Chavez St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 10ft | 6008748.821819999 | 2100575.53964 | 37.748274388864495 | -122.412513829653 | (37.7482743888645, -122.412513829653) | |||
| 177771 | 177771 | 221305 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | Width 10ft | 6006848.39499 | 2100562.5972700003 | 37.7481320153776 | -122.419084549026 | (37.7481320153776, -122.419084549026) | |||
| 177862 | 177862 | 221290 | Undocumented 2 | Brahea edulis :: Guadalupe Palm 115 | 2800 Mariposa St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 1ft | 6009034.8485900005 | 2105927.00235 | 37.7629843459795 | -122.411902860852 | (37.7629843459795, -122.411902860852) | |||
| 178642 | 178642 | 221310 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 3400x Cesar Chavez St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 10ft | 6006690.61046 | 2100560.2464400004 | 37.748116673857396 | -122.419629996836 | (37.7481166738574, -122.419629996836) |
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");