Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 101115 | 101115 | 109364 | Permitted Site 1 | :: 54 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 124298 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 43479 | 43479 | 122819 | Undocumented 2 | :: 54 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003309.0 | 2094407.0 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | ||||
| 28027 | 28027 | 140087 | Undocumented 2 | :: 54 | 1210 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001853.1286 | 2112643.6389 | 37.781021029267706 | -122.43722286326 | (37.7810210292677, -122.43722286326) | |||
| 25969 | 25969 | 183335 | Undocumented 2 | :: 54 | 1211 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106839.0545 | 37.7639763455704 | -122.503028028557 | (37.7639763455704, -122.503028028557) | |||
| 160327 | 160327 | 183333 | Undocumented 2 | :: 54 | 1211 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.5384 | 2106850.7636 | 37.764008470840295 | -122.503030341532 | (37.7640084708403, -122.503030341532) | |||
| 162629 | 162629 | 183334 | Undocumented 2 | :: 54 | 1211 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.9565 | 2106844.4908 | 37.7639912720976 | -122.503028431048 | (37.7639912720976, -122.503028431048) | |||
| 178886 | 178886 | 183351 | Undocumented 2 | :: 54 | 1214 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981199.8295 | 2106780.9272 | 37.7637280462203 | -122.508236325462 | (37.7637280462203, -122.508236325462) | |||
| 38433 | 38433 | 181714 | Undocumented 2 | :: 54 | 1215 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987051.5149 | 2106949.2334 | 37.764533265698 | -122.488009786224 | (37.764533265698, -122.488009786224) | |||
| 170682 | 170682 | 181751 | Undocumented 2 | :: 54 | 1215 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985811.8134 | 2106917.8782 | 37.764374776294396 | -122.49229520775299 | (37.7643747762944, -122.492295207753) | |||
| 71051 | 71051 | 183339 | Undocumented 2 | :: 54 | 1219 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983948.7419 | 2106852.4379 | 37.7640860018935 | -122.498734117688 | (37.7640860018935, -122.498734117688) | |||
| 158214 | 158214 | 183340 | Undocumented 2 | :: 54 | 1219 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983949.2875 | 2106832.797 | 37.7640321055392 | -122.498730779597 | (37.7640321055392, -122.498730779597) | |||
| 171383 | 171383 | 183348 | Undocumented 2 | :: 54 | 1222 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983373.4277 | 2106798.2891 | 37.76390356553 | -122.500719925068 | (37.76390356553, -122.500719925068) | |||
| 148856 | 148856 | 139245 | Undocumented 2 | :: 54 | 1223 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003686.6496 | 2113074.8565 | 37.7823091017787 | -122.430910590356 | (37.7823091017787, -122.430910590356) | |||
| 29815 | 29815 | 181758 | Undocumented 2 | :: 54 | 1230 36th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984924.8270000005 | 2106814.5562 | 37.764039188732205 | -122.495355380579 | (37.7640391887322, -122.495355380579) | |||
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 157121 | 157121 | 181768 | Undocumented 2 | :: 54 | 1235 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985194.4062 | 2106785.0805 | 37.7639740372115 | -122.49442082615101 | (37.7639740372115, -122.494420826151) | |||
| 53583 | 53583 | 183266 | Undocumented 2 | :: 54 | 1235 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982090.5566 | 2106669.6909 | 37.7634750727275 | -122.50514738366999 | (37.7634750727275, -122.50514738367) | |||
| 116050 | 116050 | 111759 | Permitted Site 1 | :: 54 | 1235 47th Ave | 2 | Sidewalk: Curb side : Yard 2 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x4 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 145543 | 145543 | 111758 | Permitted Site 1 | :: 54 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/23/2015 12:00:00 AM | 3 | 6x6 | 5981472.7 | 2106671.7 | 37.7634442160317 | -122.50728446314301 | (37.7634442160317, -122.507284463143) | ||
| 124217 | 124217 | 37151 | Permitted Site 1 | :: 54 | 124 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/2015 12:00:00 AM | 3 | 4.5x10 | Permit Number 775446 | 6005712.42544702 | 2100249.055732 | 37.7472070660376 | -122.42299041598 | (37.7472070660376, -122.42299041598) |
| 131382 | 131382 | 141119 | Undocumented 2 | :: 54 | 124 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998714.1818 | 2112720.5452 | 37.7810532591781 | -122.448087532266 | (37.7810532591781, -122.448087532266) | |||
| 39404 | 39404 | 181754 | Undocumented 2 | :: 54 | 1240 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987099.9397 | 2106850.6122 | 37.7642653039062 | -122.487835053811 | (37.7642653039062, -122.487835053811) | |||
| 70039 | 70039 | 181610 | Undocumented 2 | :: 54 | 1242 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984929.7396 | 2106734.1122 | 37.763818599731295 | -122.49533245658002 | (37.7638185997313, -122.49533245658) | |||
| 153241 | 153241 | 183271 | Undocumented 2 | :: 54 | 1242 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982138.4385 | 2106630.5909 | 37.7633705325139 | -122.504978880674 | (37.7633705325139, -122.504978880674) | |||
| 24606 | 24606 | 181614 | Undocumented 2 | :: 54 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.49533918573601 | (37.7637526989564, -122.495339185736) | |||
| 147521 | 147521 | 183670 | Undocumented 2 | :: 54 | 1247 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984264.9056 | 2106671.7145 | 37.7636083244569 | -122.49762727229799 | (37.7636083244569, -122.497627272298) | |||
| 103215 | 103215 | 116528 | Planning Code 138.1 required 4 | :: 54 | 125 CROWN TER | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 5998841.0 | 2104182.0 | 37.7576158290564 | -122.447034160915 | (37.7576158290564, -122.447034160915) | |||
| 62201 | 62201 | 184810 | Undocumented 2 | :: 54 | 1250 37th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984625.0742 | 2106537.48 | 37.763260859986204 | -122.49637167575001 | (37.7632608599862, -122.49637167575) | |||
| 175934 | 175934 | 140091 | Undocumented 2 | :: 54 | 1250 Scott St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001831.6388 | 2112795.421 | 37.781436562836106 | -122.43730807844801 | (37.7814365628361, -122.437308078448) | |||
| 26862 | 26862 | 245988 | Undocumented 2 | :: 54 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.76952040656629 | -122.44373466044901 | (37.7695204065663, -122.443734660449) | |||
| 36422 | 36422 | 181608 | Undocumented 2 | :: 54 | 1251 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5986743.9567 | 2106741.3672 | 37.763944576281794 | -122.489058249622 | (37.7639445762818, -122.489058249622) | |||
| 168551 | 168551 | 181616 | Undocumented 2 | :: 54 | 1251 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985196.2484 | 2106684.3721 | 37.76369762797 | -122.494407030493 | (37.76369762797, -122.494407030493) | |||
| 170057 | 170057 | 181617 | Undocumented 2 | :: 54 | 1251 35th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985198.7047 | 2106674.5469 | 37.7636707944731 | -122.494397810738 | (37.7636707944731, -122.494397810738) | |||
| 158614 | 158614 | 186842 | Undocumented 2 | :: 54 | 1251 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984888.6931 | 2106439.91 | 37.763008399663796 | -122.49545272217699 | (37.7630083996638, -122.495452722177) | |||
| 169422 | 169422 | 184811 | Undocumented 2 | :: 54 | 1251 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984734.8773 | 2106435.4128 | 37.762987043878105 | -122.495984378629 | (37.7629870438781, -122.495984378629) | |||
| 170815 | 170815 | 183268 | Undocumented 2 | :: 54 | 1254 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982139.2748 | 2106566.1909 | 37.763193757767 | -122.504971215621 | (37.763193757767, -122.504971215621) | |||
| 36846 | 36846 | 183277 | Undocumented 2 | :: 54 | 1255 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981785.9112 | 2106543.1909 | 37.7631098104891 | -122.506191655726 | (37.7631098104891, -122.506191655726) | |||
| 75313 | 75313 | 246042 | Undocumented 2 | :: 54 | 1257 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999431.9379 | 2108484.7346 | 37.7694638090143 | -122.445299822785 | (37.7694638090143, -122.445299822785) | |||
| 71799 | 71799 | 183287 | Undocumented 2 | :: 54 | 1259 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981476.8749 | 2106516.0091 | 37.7630169795519 | -122.50725847250901 | (37.7630169795519, -122.507258472509) | |||
| 9914 | 9914 | 173708 | DPW Maintained 3 | :: 54 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001214.0 | 2098705.0 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | ||||
| 81529 | 81529 | 117591 | Undocumented 2 | :: 54 | 1262 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999100.0 | 2105386.0 | 37.7609365084256 | -122.446225043361 | (37.7609365084256, -122.446225043361) | ||||
| 114902 | 114902 | 183304 | Undocumented 2 | :: 54 | 1263 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983031.5884 | 2106472.5871 | 37.762989205720295 | -122.5018781248 | (37.7629892057203, -122.5018781248) | |||
| 40193 | 40193 | 183285 | Undocumented 2 | :: 54 | 1266 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983382.4298 | 2106528.4997 | 37.763163328933295 | -122.50066883897 | (37.7631633289333, -122.50066883897) | |||
| 50143 | 50143 | 183305 | Undocumented 2 | :: 54 | 1270 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982452.2839 | 2106459.7636 | 37.7629199491975 | -122.50388075683901 | (37.7629199491975, -122.503880756839) | |||
| 23724 | 23724 | 181665 | Undocumented 2 | :: 54 | 1275 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985511.3315 | 2106531.7973 | 37.7632971348656 | -122.49330603001499 | (37.7632971348656, -122.493306030015) | |||
| 53717 | 53717 | 139776 | Undocumented 2 | :: 54 | 1275 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004800.935 | 2113296.4778 | 37.7829806915655 | -122.427071445409 | (37.7829806915655, -122.427071445409) | |||
| 32925 | 32925 | 200975 | Undocumented 2 | :: 54 | 1275 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6009315.029 | 2109918.3974 | 37.7739595082871 | -122.411215775633 | (37.7739595082871, -122.411215775633) | |||
| 130942 | 130942 | 181670 | Undocumented 2 | :: 54 | 1278 36th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984935.2663 | 2106495.8509 | 37.763164724632 | -122.495295769501 | (37.763164724632, -122.495295769501) | |||
| 160035 | 160035 | 181669 | Undocumented 2 | :: 54 | 1278 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984937.1085 | 2106485.4116 | 37.7631361691005 | -122.495288628135 | (37.7631361691005, -122.495288628135) | |||
| 110521 | 110521 | 37485 | Permitted Site 1 | :: 54 | 1279 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39954 | 5990777.53023366 | 2106701.87780849 | 37.7640707487715 | -122.47510458341002 | (37.7640707487715, -122.47510458341) | ||
| 67853 | 67853 | 181667 | Undocumented 2 | :: 54 | 1279 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985203.0032 | 2106516.7295 | 37.7632377236324 | -122.49437130988599 | (37.7632377236324, -122.494371309886) | |||
| 181442 | 181442 | 181522 | Undocumented 2 | :: 54 | 1279 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984580.8884 | 2106481.9946 | 37.7631059241302 | -122.496520402894 | (37.7631059241302, -122.496520402894) | |||
| 131636 | 131636 | 181666 | Undocumented 2 | :: 54 | 1282 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985866.1245 | 2106507.5934 | 37.7632514235254 | -122.49207715278901 | (37.7632514235254, -122.492077152789) | |||
| 129908 | 129908 | 181679 | Undocumented 2 | :: 54 | 1282 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984937.7226 | 2106471.2879 | 37.7630974253349 | -122.49528546256799 | (37.7630974253349, -122.495285462568) | |||
| 159425 | 159425 | 247892 | Undocumented 2 | :: 54 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.771551471121896 | -122.441841814274 | (37.7715514711219, -122.441841814274) | |||
| 171125 | 171125 | 181674 | Undocumented 2 | :: 54 | 1286 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985866.1245 | 2106482.2089 | 37.7631817247551 | -122.492075283673 | (37.7631817247551, -122.492075283673) | |||
| 187636 | 187636 | 183293 | Undocumented 2 | :: 54 | 1286 42nd Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983075.6533 | 2106421.6609 | 37.76285196523921 | -122.50172195396401 | (37.7628519652392, -122.501721953964) | |||
| 32195 | 32195 | 248555 | Undocumented 2 | :: 54 | 129 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997396.7751 | 2107759.6103 | 37.767356421121995 | -122.452286999337 | (37.767356421122, -122.452286999337) | |||
| 39591 | 39591 | 181680 | Undocumented 2 | :: 54 | 1290 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985868.4858 | 2106459.7761 | 37.7631202685599 | -122.492065465074 | (37.7631202685599, -122.492065465074) | |||
| 64860 | 64860 | 181678 | Undocumented 2 | :: 54 | 1295 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985204.8455 | 2106401.8973 | 37.7629225343509 | -122.49435647305 | (37.7629225343509, -122.49435647305) | |||
| 81482 | 81482 | 38110 | Permitted Site 1 | :: 54 | 1296 29th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 115960 | 115960 | 38111 | Permitted Site 1 | :: 54 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 51060 | 51060 | 183255 | Undocumented 2 | :: 54 | 1300 La Playa | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.3073 | 2106159.7216 | 37.762005388573606 | -122.509188082818 | (37.7620053885736, -122.509188082818) | |||
| 162558 | 162558 | 183254 | Undocumented 2 | :: 54 | 1300 La Playa | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5980911.6607 | 2106131.1023 | 37.76192682906861 | -122.50918473520399 | (37.7619268290686, -122.509184735204) | |||
| 164525 | 164525 | 137524 | Undocumented 2 | :: 54 | 1300 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002282.6726 | 2113052.5281 | 37.782168143964896 | -122.435766122963 | (37.7821681439649, -122.435766122963) | |||
| 183672 | 183672 | 200636 | Undocumented 2 | :: 54 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.729181036936396 | -122.384238246013 | (37.7291810369364, -122.384238246013) | |||
| 68734 | 68734 | 139765 | Undocumented 2 | :: 54 | 1306 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004663.7345 | 2113397.522 | 37.7832503745299 | -122.427553303818 | (37.7832503745299, -122.427553303818) | |||
| 36535 | 36535 | 139766 | Undocumented 2 | :: 54 | 1308 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004662.1567 | 2113418.8231 | 37.7833087728144 | -122.427560280444 | (37.7833087728144, -122.427560280444) | |||
| 129582 | 129582 | 139105 | Undocumented 2 | :: 54 | 1310 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999792.0294 | 2113376.32 | 37.782915402867495 | -122.444405875371 | (37.7829154028675, -122.444405875371) | |||
| 167560 | 167560 | 182612 | Undocumented 2 | :: 54 | 1310 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989941.9442 | 2102468.0868 | 37.752397426219396 | -122.47768510448401 | (37.7523974262194, -122.477685104484) | |||
| 71962 | 71962 | 182036 | Undocumented 2 | :: 54 | 1314 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987424.9672 | 2106327.6806 | 37.7628484313073 | -122.486672489667 | (37.7628484313073, -122.486672489667) | |||
| 89561 | 89561 | 141330 | Undocumented 2 | :: 54 | 1314 HAYES ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6001510.5734 | 2110463.2514 | 37.7750147569158 | -122.438251682494 | (37.7750147569158, -122.438251682494) | |||
| 75781 | 75781 | 245986 | Undocumented 2 | :: 54 | 1317 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999797.1498 | 2108783.9297 | 37.7703061638219 | -122.444058075462 | (37.7703061638219, -122.444058075462) | |||
| 53862 | 53862 | 182038 | Undocumented 2 | :: 54 | 1319 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987384.8091 | 2106266.2339 | 37.76267737440389 | -122.48680686823499 | (37.7626773744039, -122.486806868235) | |||
| 78123 | 78123 | 104843 | Permitted Site 1 | :: 54 | 1320 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989622.0 | 2106334.7 | 37.7629955389606 | -122.47907431964701 | (37.7629955389606, -122.479074319647) | ||||||
| 135552 | 135552 | 140125 | Undocumented 2 | :: 54 | 1321 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001271.8045 | 2112891.6174 | 37.7816688523257 | -122.43925172679899 | (37.7816688523257, -122.439251726799) | |||
| 24104 | 24104 | 248307 | Undocumented 2 | :: 54 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.44550750940901 | (37.7691713129844, -122.445507509409) | |||
| 170690 | 170690 | 182040 | Undocumented 2 | :: 54 | 1326 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987428.353999999 | 2106220.7537 | 37.762555036857 | -122.486652924271 | (37.762555036857, -122.486652924271) | |||
| 93908 | 93908 | 51029 | Permitted Site 1 | :: 54 | 133 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3x3 | Permit Number 767941 | 6007256.96585115 | 2097027.84886938 | 37.7384493854458 | -122.417421253654 | (37.7384493854458, -122.417421253654) | ||
| 49494 | 49494 | 182045 | Undocumented 2 | :: 54 | 1334 27th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987740.8439 | 2106201.6024 | 37.7625206645495 | -122.485570743348 | (37.7625206645495, -122.485570743348) | |||
| 59478 | 59478 | 183717 | Undocumented 2 | :: 54 | 1335 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983090.7026 | 2106024.057 | 37.7617611417836 | -122.501640487706 | (37.7617611417836, -122.501640487706) | |||
| 150125 | 150125 | 244876 | Undocumented 2 | :: 54 | 1337 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000144.5037 | 2109183.4156 | 37.7714228606032 | -122.442885274342 | (37.7714228606032, -122.442885274342) | |||
| 32792 | 32792 | 181569 | Undocumented 2 | :: 54 | 1349 37th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984599.7352 | 2105972.9827 | 37.7617094244752 | -122.496417657892 | (37.7617094244752, -122.496417657892) | |||
| 35204 | 35204 | 181568 | Undocumented 2 | :: 54 | 1349 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984597.8609 | 2105995.9427 | 37.7617723563961 | -122.496425834494 | (37.7617723563961, -122.496425834494) | |||
| 38023 | 38023 | 183701 | Undocumented 2 | :: 54 | 1349 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984598.3295 | 2105986.1027 | 37.7617453659671 | -122.49642348771098 | (37.7617453659671, -122.496423487711) | |||
| 55239 | 55239 | 246194 | Undocumented 2 | :: 54 | 1349 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999511.7334 | 2108091.2082 | 37.7683878393229 | -122.44499552058399 | (37.7683878393229, -122.444995520584) | |||
| 135049 | 135049 | 182043 | Undocumented 2 | :: 54 | 1354 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988055.225 | 2106072.8198 | 37.7621853748408 | -122.48447398103 | (37.7621853748408, -122.48447398103) | |||
| 61348 | 61348 | 182050 | Undocumented 2 | :: 54 | 1354 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987434.16 | 2106064.4759 | 37.762126279391495 | -122.486621368216 | (37.7621262793915, -122.486621368216) | |||
| 179181 | 179181 | 181694 | Undocumented 2 | :: 54 | 1356 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982161.9827 | 2105857.6697 | 37.7612496970921 | -122.504840173741 | (37.7612496970921, -122.504840173741) | |||
| 176810 | 176810 | 182055 | Undocumented 2 | :: 54 | 1358 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987435.6115 | 2106037.3813 | 37.76205196967079 | -122.486614358562 | (37.7620519696708, -122.486614358562) | |||
| 77255 | 77255 | 248311 | Undocumented 2 | :: 54 | 1359 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999222.9859 | 2108359.6661 | 37.7691084728164 | -122.44601357942699 | (37.7691084728164, -122.446013579427) | |||
| 85868 | 85868 | 115996 | Undocumented 2 | :: 54 | 136 DUNCAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005652.0 | 2099949.0 | 37.746379771639795 | -122.423178037621 | (37.7463797716398, -122.423178037621) | |||
| 188170 | 188170 | 181697 | Undocumented 2 | :: 54 | 1360 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982163.8853 | 2105835.7898 | 37.761189733060704 | -122.50483197223 | (37.7611897330607, -122.50483197223) | |||
| 39314 | 39314 | 140416 | Undocumented 2 | :: 54 | 1360 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003047.9047 | 2112063.8256 | 37.7794968522113 | -122.433048105114 | (37.7794968522113, -122.433048105114) |
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");