Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188845 | 188845 | 238564 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 631 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002380.966569999 | 2100028.16957 | 37.7464120134059 | -122.434494537516 | (37.7464120134059, -122.434494537516) | |||
| 188721 | 188721 | 119033 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 745 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5982267.74264 | 2110681.1609400003 | 37.7744998336605 | -122.50483182972499 | (37.7744998336605, -122.504831829725) | |||
| 188630 | 188630 | 196518 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1100 Pennsylvania Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6014492.91389 | 2101810.6998099997 | 37.7519865663454 | -122.39273715780399 | (37.7519865663454, -122.392737157804) | ||||
| 188231 | 188231 | 124235 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1 Paramount Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5996597.660180001 | 2111009.8319099997 | 37.7762348739685 | -122.455285924869 | (37.7762348739685, -122.455285924869) | |||
| 188154 | 188154 | 50352 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 658 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 3 | Permit Number 47029 | 5981670.8145 | 2111260.62712 | 37.7760557428917 | -122.506939675333 | (37.7760557428917, -122.506939675333) | ||
| 187244 | 187244 | 61219 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 179 Elmira St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1983 12:00:00 AM | 7 | Permit Number 21088 | 6011237.71128 | 2095645.3560099998 | 37.734876525537295 | -122.403560449172 | (37.7348765255373, -122.403560449172) | |
| 187141 | 187141 | 238556 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003884.876180001 | 2100253.4268400003 | 37.7471157733724 | -122.429310250782 | (37.7471157733724, -122.429310250782) | |||
| 187006 | 187006 | 181827 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2311 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986682.1022 | 2099505.6814 | 37.744073741666604 | -122.488740290538 | (37.7440737416666, -122.488740290538) | |||
| 185593 | 185593 | 84853 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1338 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 6 | Permit No. 49311 | 5994481.6608 | 2112148.58575 | 37.779239954215 | -122.462688317698 | (37.779239954215, -122.462688317698) | ||
| 184473 | 184473 | 51916 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1750 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2005 12:00:00 AM | 2 | Permit Number 48117 | 5982875.703 | 2103201.7552 | 37.753999267134105 | -122.502175211562 | (37.7539992671341, -122.502175211562) | ||
| 184116 | 184116 | 182117 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2468 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987697.3676 | 2098504.9682 | 37.7413852437695 | -122.48515636376999 | (37.7413852437695, -122.48515636377) | |||
| 183610 | 183610 | 182279 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1496 Kirkham St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5984984.0246 | 2105052.8568 | 37.7592055205034 | -122.495020725609 | (37.7592055205034, -122.495020725609) | |||
| 183555 | 183555 | 238562 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 623 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6002513.8808699995 | 2098855.53984 | 37.7431997906349 | -122.43395113024201 | (37.7431997906349, -122.433951130242) | |||
| 183161 | 183161 | 122919 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 342 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992497.476969999 | 2113139.63077 | 37.7818466194185 | -122.469624534307 | (37.7818466194185, -122.469624534307) | |||
| 181594 | 181594 | 117634 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 100 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5997551.04889 | 2115977.76508 | 37.7899301649938 | -122.45234647762301 | (37.7899301649938, -122.452346477623) | |||
| 181585 | 181585 | 238553 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 226 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6004403.59335 | 2099297.10954 | 37.74451929932229 | -122.42744845180401 | (37.7445192993223, -122.427448451804) | |||
| 181558 | 181558 | 117633 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 100 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5997552.92531 | 2115962.18049 | 37.7898874813666 | -122.452338860365 | (37.7898874813666, -122.452338860365) | |||
| 181128 | 181128 | 117637 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 100 Locust St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5997541.40632 | 2116024.0054900004 | 37.7900565763988 | -122.452383178041 | (37.7900565763988, -122.452383178041) | |||
| 180414 | 180414 | 213709 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1330 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5990679.02857 | 2105217.0718099996 | 37.759988159242894 | -122.47533685612301 | (37.7599881592429, -122.475336856123) | |||
| 179899 | 179899 | 181884 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2364 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986431.5008 | 2099166.4136 | 37.743127575482895 | -122.48958185913 | (37.7431275754829, -122.48958185913) | |||
| 179012 | 179012 | 35588 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3600 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1998 12:00:00 AM | 5 | Permit Number 38951 | 6002194.35784 | 2120633.11747 | 37.802977466289796 | -122.43661442753401 | (37.8029774662898, -122.436614427534) | ||
| 178897 | 178897 | 58883 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1831 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/1980 12:00:00 AM | 3 | Permit Number 18147 | 5984400.4624 | 2102704.4443 | 37.752723252787 | -122.49686560854401 | (37.752723252787, -122.496865608544) | ||
| 177425 | 177425 | 123559 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 131 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 7ft | 5994253.7419 | 2114658.86132 | 37.786119363696606 | -122.463659017412 | (37.7861193636966, -122.463659017412) | |||
| 177245 | 177245 | 35583 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3600 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/1998 12:00:00 AM | 7 | Permit Number 38951 | 6002198.463280001 | 2120613.57109 | 37.8029240303879 | -122.436598820686 | (37.8029240303879, -122.436598820686) | ||
| 177212 | 177212 | 196525 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 777 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011871.67435 | 2104748.04731 | 37.7599059432265 | -122.402008311954 | (37.7599059432265, -122.402008311954) | |||
| 175298 | 175298 | 179168 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 200x Mansell St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6011032.14311 | 2090534.0564299999 | 37.7208304767293 | -122.40391160924 | (37.7208304767293, -122.40391160924) | |||
| 175045 | 175045 | 136033 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1798 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002299.6939199995 | 2120568.99271 | 37.802807382008794 | -122.43624531876199 | (37.8028073820088, -122.436245318762) | |||
| 174102 | 174102 | 123200 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1310 09th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 5993097.33077 | 2112035.35395 | 37.7788492259481 | -122.46746901060699 | (37.7788492259481, -122.467469010607) | |||
| 173448 | 173448 | 196517 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1100 Pennsylvania Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6014492.802759999 | 2101818.43499 | 37.7520077993331 | -122.39273808318899 | (37.7520077993331, -122.392738083189) | ||||
| 173109 | 173109 | 218411 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 205 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5994290.425419999 | 2100613.6082200003 | 37.7475568944299 | -122.462512951805 | (37.7475568944299, -122.462512951805) | |||
| 172351 | 172351 | 139122 | DPW Maintained 3 | Prunus blireiana :: Flowering Plum 102 | 1501 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6004515.7696 | 2114102.0367 | 37.785176426027604 | -122.42811542650499 | (37.7851764260276, -122.428115426505) | |||
| 172013 | 172013 | 196516 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 948 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015218.63504 | 2104201.5553099997 | 37.758591627217704 | -122.390394521914 | (37.7585916272177, -122.390394521914) | |||
| 171536 | 171536 | 196524 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 500 De Haro St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012039.23838 | 2106001.02013 | 37.7633556787538 | -122.401516847728 | (37.7633556787538, -122.401516847728) | |||
| 171331 | 171331 | 196530 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1150 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6014129.09689 | 2105289.45573 | 37.7615182666641 | -122.394238832278 | (37.7615182666641, -122.394238832278) | |||
| 171308 | 171308 | 123146 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 560 10th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5992867.54706 | 2111680.63893 | 37.7778620058506 | -122.468238105016 | (37.7778620058506, -122.468238105016) | |||
| 170027 | 170027 | 196522 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1801 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011980.51858 | 2106049.29218 | 37.763484946400496 | -122.40172333477899 | (37.7634849464005, -122.401723334779) | |||
| 169826 | 169826 | 138763 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1508 Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000172.4842 | 2114147.0286 | 37.7850532695664 | -122.443145033749 | (37.7850532695664, -122.443145033749) | |||
| 168736 | 168736 | 118174 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 855 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5985693.27669 | 2109963.71146 | 37.7727308467676 | -122.492929558244 | (37.7727308467676, -122.492929558244) | |||
| 168597 | 168597 | 196529 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1150 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6014166.9984800005 | 2105290.36806 | 37.7615228783907 | -122.39410780914899 | (37.7615228783907, -122.394107809149) | |||
| 168466 | 168466 | 213715 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 125 Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5999200.66697 | 2093467.5999 | 37.728217201345004 | -122.445020057043 | (37.728217201345, -122.445020057043) | |||
| 168107 | 168107 | 122160 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 547 15th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5991246.04787 | 2111677.1817900003 | 37.7777587296811 | -122.473847129053 | (37.7777587296811, -122.473847129053) | |||
| 166277 | 166277 | 183468 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2531 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987663.5713 | 2098059.3859 | 37.740159823478706 | -122.485240531105 | (37.7401598234787, -122.485240531105) | |||
| 165884 | 165884 | 136032 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 100 Locust St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997540.73441 | 2116039.76442 | 37.790099807719706 | -122.45238664044201 | (37.7900998077197, -122.452386640442) | |||
| 165589 | 165589 | 118251 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 883 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5985085.519619999 | 2109878.09808 | 37.7724602164796 | -122.495025511982 | (37.7724602164796, -122.495025511982) | |||
| 165586 | 165586 | 196526 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1327 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012008.29844 | 2102189.51462 | 37.752888399289 | -122.40135598870899 | (37.752888399289, -122.401355988709) | |||
| 164331 | 164331 | 123560 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 131 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 7ft | 5994254.428119999 | 2114646.46204 | 37.786085358185794 | -122.46365574305099 | (37.7860853581858, -122.463655743051) | |||
| 164053 | 164053 | 238549 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 125 Mullen Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009831.14885 | 2099860.0052 | 37.7463703703058 | -122.408720684427 | (37.7463703703058, -122.408720684427) | |||
| 163904 | 163904 | 238546 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1550 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010196.53495 | 2100318.93034 | 37.7476509365422 | -122.407489565592 | (37.7476509365422, -122.407489565592) | |||
| 163565 | 163565 | 187550 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 15 Chicago Way | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003854.31887 | 2086791.04585 | 37.7101493555763 | -122.428456511776 | (37.7101493555763, -122.428456511776) | |||
| 163257 | 163257 | 139513 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1422 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000956.086 | 2111077.9238 | 37.7766709396845 | -122.440213858451 | (37.7766709396845, -122.440213858451) | |||
| 162890 | 162890 | 136035 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1798 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002262.2619900005 | 2120563.69941 | 37.80279072117929 | -122.43637447311701 | (37.8027907211793, -122.436374473117) | |||
| 162428 | 162428 | 238552 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 263 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004835.349169999 | 2098981.1667400002 | 37.743676202905604 | -122.425933041078 | (37.7436762029056, -122.425933041078) | |||
| 162411 | 162411 | 238565 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 625 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6002419.36541 | 2100030.8623099998 | 37.7464215867002 | -122.434361951369 | (37.7464215867002, -122.434361951369) | |||
| 161906 | 161906 | 246143 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 9 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999964.3115 | 2108327.8691 | 37.7690634706146 | -122.443447101152 | (37.7690634706146, -122.443447101152) | |||
| 161889 | 161889 | 70130 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2614 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 3 | 5990525.20475 | 2112006.61125 | 37.7786214745109 | -122.476364817556 | (37.7786214745109, -122.476364817556) | ||
| 161340 | 161340 | 71817 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1271 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/06/1982 12:00:00 AM | 4 | 5988923.2164 | 2106695.866 | 37.763946597000206 | -122.48151759670601 | (37.7639465970002, -122.481517596706) | ||
| 159516 | 159516 | 238544 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1673 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009719.770930001 | 2099951.13854 | 37.7466143635754 | -122.40911224743799 | (37.7466143635754, -122.409112247438) | |||
| 158890 | 158890 | 62805 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 15 Chicago Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/1991 12:00:00 AM | 5 | Permit Number 29952 | 6003841.76502 | 2086802.5361799998 | 37.7101801951336 | -122.428500718859 | (37.7101801951336, -122.428500718859) | ||
| 157947 | 157947 | 246650 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 3350 Harrison St | 11 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009031.0412800005 | 2099150.93712 | 37.744378579706996 | -122.411437288125 | (37.744378579707, -122.411437288125) | ||||
| 157912 | 157912 | 249614 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2350 Golden Gate Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998151.85452 | 2111390.9630299998 | 37.7773704113412 | -122.449937040973 | (37.7773704113412, -122.449937040973) | |||
| 157060 | 157060 | 61892 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/15/1985 12:00:00 AM | 5 | Permit Number 21935 | 5988700.7716 | 2104003.1782 | 37.756540268902896 | -122.482089681142 | (37.7565402689029, -122.482089681142) | |
| 156015 | 156015 | 185747 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1802 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987565.4993 | 2100345.9151 | 37.746432312985895 | -122.48574739527001 | (37.7464323129859, -122.48574739527) | |||
| 155532 | 155532 | 213713 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 125 Judson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5999159.4074800005 | 2093468.8263700001 | 37.7282182139859 | -122.445162780338 | (37.7282182139859, -122.445162780338) | |||
| 155346 | 155346 | 140280 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 100 COLE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997859.9527 | 2110252.1544 | 37.7742268312931 | -122.45086468567 | (37.7742268312931, -122.45086468567) | |||
| 154601 | 154601 | 117910 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 843 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5983532.20946 | 2110068.65579 | 37.77289237764771 | -122.500412569486 | (37.7728923776477, -122.500412569486) | |||
| 153582 | 153582 | 246193 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 755 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999885.5759 | 2108037.456 | 37.7682615787189 | -122.443698575802 | (37.7682615787189, -122.443698575802) | |||
| 152528 | 152528 | 64617 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1635 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1988 12:00:00 AM | 6 | Permit Number 25522 | 6004008.12859 | 2120059.4667700003 | 37.801505275217096 | -122.43029688889 | (37.8015052752171, -122.43029688889) | ||
| 152501 | 152501 | 213711 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 38 Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6000905.90328 | 2094365.1915400003 | 37.73077895977811 | -122.439189308837 | (37.7307789597781, -122.439189308837) | |||
| 152263 | 152263 | 238572 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 414 Collingwood St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6002097.32586 | 2103433.45375 | 37.7557460085737 | -122.43571892398899 | (37.7557460085737, -122.435718923989) | ||||
| 150147 | 150147 | 67578 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 118 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/2003 12:00:00 AM | 6 | Permit Number 31142 | 6013124.0144 | 2106441.0660900003 | 37.7646244162146 | -122.39779580382799 | (37.7646244162146, -122.397795803828) | |
| 148111 | 148111 | 196521 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1100 Pennsylvania Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6014496.49753 | 2101766.20536 | 37.751864593079205 | -122.392721652585 | (37.7518645930792, -122.392721652585) | ||||
| 147433 | 147433 | 249615 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2350 Golden Gate Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998136.14994 | 2111389.29333 | 37.7773649281729 | -122.449991247621 | (37.7773649281729, -122.449991247621) | |||
| 147421 | 147421 | 179167 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 111 Brunswick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6000723.35107 | 2087387.59269 | 37.71160966571279 | -122.439320465973 | (37.7116096657128, -122.439320465973) | |||
| 147362 | 147362 | 238554 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003916.2981 | 2099645.9415 | 37.745449538277605 | -122.429158287842 | (37.7454495382776, -122.429158287842) | |||
| 147130 | 147130 | 57241 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 2630 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1975 12:00:00 AM | 3 | Permit Number 14529 | 5987816.4921 | 2098311.7293 | 37.740861599204 | -122.484730305914 | (37.740861599204, -122.484730305914) | ||
| 147059 | 147059 | 123558 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 127 05th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 7ft | 5994253.98001 | 2114683.0877400003 | 37.7861858965782 | -122.463659952565 | (37.7861858965782, -122.463659952565) | |||
| 146116 | 146116 | 12714 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1501 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5990789.16326 | 2114722.34 | 37.7860934167472 | -122.47565005052401 | (37.7860934167472, -122.475650050524) | |||
| 145827 | 145827 | 60785 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 126 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1983 12:00:00 AM | Permit Number 20455 | 5998690.69552191 | 2112465.2130408003 | 37.780350840784294 | -122.448150392076 | (37.7803508407843, -122.448150392076) | ||
| 145767 | 145767 | 63659 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 411 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24307 | 6003836.58732035 | 2100093.87745401 | 37.7466749538841 | -122.42946585336901 | (37.7466749538841, -122.429465853369) | ||
| 145160 | 145160 | 85265 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 3000 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.73354054474329 | -122.478606721292 | (37.7335405447433, -122.478606721292) | |||
| 144617 | 144617 | 84042 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 508 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50447 | 6003026.52400311 | 2103317.18885819 | 37.7554795089619 | -122.432497158122 | (37.7554795089619, -122.432497158122) | ||
| 143472 | 143472 | 59836 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1271 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/18/1983 12:00:00 AM | Permit Number 19290 | 5995144.61588097 | 2106889.02596139 | 37.7648367447545 | -122.46001377482 | (37.7648367447545, -122.46001377482) | ||
| 142927 | 142927 | 67772 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 146 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/15/1992 12:00:00 AM | Permit Number 31403 | 6004564.19848572 | 2108804.14815363 | 37.7706324670974 | -122.427570300779 | (37.7706324670974, -122.427570300779) | ||
| 142603 | 142603 | 64262 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 159 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/1988 12:00:00 AM | Permit Number 25064 | 6010000.52253468 | 2100073.98033326 | 37.746967384183705 | -122.408150095635 | (37.7469673841837, -122.408150095635) | ||
| 142240 | 142240 | 64271 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 1627 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1988 12:00:00 AM | Permit Number 25074 | 6009690.91214732 | 2100255.03327712 | 37.747447174897296 | -122.40923347972901 | (37.7474471748973, -122.409233479729) | ||
| 142066 | 142066 | 40824 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 695 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1999 12:00:00 AM | Permit Number 41762 | 6013368.81391754 | 2110378.20910645 | 37.7754485595516 | -122.39722520599 | (37.7754485595516, -122.39722520599) | |||
| 141076 | 141076 | 60803 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 120 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1983 12:00:00 AM | Permit Number 20479 | 5998693.79228565 | 2112443.24923504 | 37.780290710903294 | -122.448138097032 | (37.7802907109033, -122.448138097032) | ||
| 139735 | 139735 | 63775 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 29 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24456 | 6004942.98585197 | 2101617.48681583 | 37.750921013660296 | -122.425748465468 | (37.7509210136603, -122.425748465468) | ||
| 139536 | 139536 | 50755 | Permitted Site 1 | Prunus blireiana :: Flowering Plum 102 | 949 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2004 12:00:00 AM | Permit Number 47296 | 6007821.20096678 | 2120247.77734731 | 37.802237570679296 | -122.417115255464 | (37.8022375706793, -122.417115255464) | |||
| 138772 | 138772 | 196519 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1100 Pennsylvania Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6014493.8282699995 | 2101802.94838 | 37.7519653333515 | -122.392733453506 | (37.7519653333515, -122.392733453506) | ||||
| 138224 | 138224 | 196531 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1150 19th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6014106.81933 | 2105287.87473 | 37.76151268727111 | -122.394315771076 | (37.7615126872711, -122.394315771076) | |||
| 137113 | 137113 | 238555 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1519 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003981.56028 | 2099428.33383 | 37.7448557321227 | -122.42891711033899 | (37.7448557321227, -122.428917110339) | |||
| 136972 | 136972 | 218234 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 363 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5991942.37249 | 2097100.2626200002 | 37.7377746456792 | -122.470376476289 | (37.7377746456792, -122.470376476289) | |||
| 136802 | 136802 | 142622 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 651 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6009763.2288 | 2120171.9265 | 37.8021383608566 | -122.410389510852 | (37.8021383608566, -122.410389510852) | |||
| 136707 | 136707 | 238545 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 1673 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009720.83243 | 2099966.9388099997 | 37.7466578071094 | -122.409109691579 | (37.7466578071094, -122.409109691579) | |||
| 135864 | 135864 | 124302 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 183 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5996217.53414 | 2113089.73746 | 37.7819239279859 | -122.45675133580099 | (37.7819239279859, -122.456751335801) | |||
| 135378 | 135378 | 123860 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 346 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994375.95206 | 2114914.31886 | 37.7868278217721 | -122.463254749485 | (37.7868278217721, -122.463254749485) | |||
| 134871 | 134871 | 238551 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 263 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004827.454580001 | 2098981.61516 | 37.7436769880021 | -122.42596037059299 | (37.7436769880021, -122.425960370593) | |||
| 134191 | 134191 | 74918 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 2650 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 4 | 5995120.86057 | 2110292.38931 | 37.774180123655796 | -122.460342548793 | (37.7741801236558, -122.460342548793) | ||
| 133986 | 133986 | 238547 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 178 Peralta Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009850.79636 | 2100052.59551 | 37.746900281436794 | -122.40866632940799 | (37.7469002814368, -122.408666329408) |
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");