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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33815 | 33815 | 228012 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1317 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998216.16813 | 2105874.44581 | 37.762227142891504 | -122.449317008786 | (37.7622271428915, -122.449317008786) | |||
| 33972 | 33972 | 227821 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 73 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006832.17705 | 2099290.0553200003 | 37.7446369891207 | -122.419050382891 | (37.7446369891207, -122.419050382891) | |||
| 34010 | 34010 | 123582 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 82 05th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5994285.08275 | 2115071.4711700003 | 37.7872540838992 | -122.463580543309 | (37.7872540838992, -122.463580543309) | |||
| 34090 | 34090 | 200282 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 Lane St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017049.10078 | 2097031.29718 | 37.7390049434275 | -122.383564705169 | (37.7390049434275, -122.383564705169) | |||
| 34137 | 34137 | 227955 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 19 Oakwood St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005250.99369 | 2105400.57172 | 37.761325881014 | -122.42495247159901 | (37.761325881014, -122.424952471599) | |||
| 34401 | 34401 | 248476 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 757 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998566.1496 | 2107908.4508 | 37.767832020618 | -122.44825303255101 | (37.767832020618, -122.448253032551) | |||
| 34476 | 34476 | 191143 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 75 Federal St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014816.78786 | 2113152.41079 | 37.7831463971164 | -122.39241036486 | (37.7831463971164, -122.39241036486) | |||
| 34535 | 34535 | 129708 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2800 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6002098.95319 | 2117845.28879 | 37.7953173972439 | -122.43674489666 | (37.7953173972439, -122.43674489666) | |||
| 34733 | 34733 | 208139 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 15 Santa Rita Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5993922.554140001 | 2100955.0265200003 | 37.7484731507208 | -122.463809795788 | (37.7484731507208, -122.463809795788) | |||
| 34966 | 34966 | 227751 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 609 Jarboe Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6008668.3519 | 2096950.8118099999 | 37.738317168894504 | -122.412535903535 | (37.7383171688945, -122.412535903535) | |||
| 35063 | 35063 | 227915 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999880.17425 | 2106931.0988 | 37.765223490583296 | -122.443637771174 | (37.7652234905833, -122.443637771174) | |||
| 35111 | 35111 | 227862 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 21 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6004103.9626400005 | 2102911.44983 | 37.754426484617895 | -122.428742121152 | (37.7544264846179, -122.428742121152) | |||
| 35151 | 35151 | 139756 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1520 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003178.6209 | 2113599.5503 | 37.783720980906295 | -122.43270563567499 | (37.7837209809063, -122.432705635675) | |||
| 35322 | 35322 | 227855 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 165 Vicksburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6004140.81956 | 2102204.0553900003 | 37.7524862314611 | -122.428564239772 | (37.7524862314611, -122.428564239772) | |||
| 35713 | 35713 | 227830 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 262 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007763.197509999 | 2106416.55563 | 37.764257120501 | -122.416335754088 | (37.764257120501, -122.416335754088) | |||
| 35873 | 35873 | 191145 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 44 Boardman Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6011725.25965 | 2110070.9002900003 | 37.77451312312171 | -122.402889063888 | (37.7745131231217, -122.402889063888) | |||
| 35886 | 35886 | 227993 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1415 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6003948.06248 | 2100010.3566900003 | 37.7464519361185 | -122.42907442965901 | (37.7464519361185, -122.429074429659) | |||
| 35927 | 35927 | 117079 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1520 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5x5 | 6003184.5706 | 2113558.6463 | 37.7836090062437 | -122.43268212910499 | (37.7836090062437, -122.432682129105) | |||
| 35946 | 35946 | 227866 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 380 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003553.996119999 | 2106069.13806 | 37.7630656015193 | -122.430869384713 | (37.7630656015193, -122.430869384713) | |||
| 36027 | 36027 | 123795 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1550 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5993809.03734 | 2112124.4569200003 | 37.7791349418605 | -122.465013428941 | (37.7791349418605, -122.465013428941) | |||
| 36101 | 36101 | 140335 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1551 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003125.8973 | 2113652.5551 | 37.783863528484396 | -122.432891827231 | (37.7838635284844, -122.432891827231) | |||
| 36142 | 36142 | 227851 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3969 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003362.6525 | 2102409.9690099997 | 37.7530075531701 | -122.431269967934 | (37.7530075531701, -122.431269967934) | |||
| 36174 | 36174 | 140357 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1529 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003133.078 | 2113592.2375 | 37.783698318826104 | -122.432862674177 | (37.7836983188261, -122.432862674177) | |||
| 36206 | 36206 | 191526 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015996.43331 | 2107204.26168 | 37.766879529196295 | -122.387914043316 | (37.7668795291963, -122.387914043316) | |||
| 36217 | 36217 | 227899 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 41 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6003491.00028 | 2108069.42997 | 37.7685543492205 | -122.43123005333 | (37.7685543492205, -122.43123005333) | |||
| 36287 | 36287 | 227888 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 129 Henry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6002659.7336 | 2107360.61662 | 37.7665609785316 | -122.434054656597 | (37.7665609785316, -122.434054656597) | |||
| 36349 | 36349 | 227836 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1850 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008694.58559 | 2107455.21864 | 37.7671613794327 | -122.413187787894 | (37.7671613794327, -122.413187787894) | |||
| 36433 | 36433 | 191542 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 700 Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6014397.81138 | 2103651.61856 | 37.7570360527848 | -122.39319484257601 | (37.7570360527848, -122.393194842576) | |||
| 36435 | 36435 | 227741 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1234 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5997486.846 | 2105477.27302 | 37.7610948622513 | -122.451810791941 | (37.7610948622513, -122.451810791941) | |||
| 36630 | 36630 | 227914 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 107 Upper Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5999872.11976 | 2106925.98957 | 37.7652090025309 | -122.44366526256701 | (37.7652090025309, -122.443665262567) | |||
| 36745 | 36745 | 227758 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 347 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006546.26985 | 2104086.6296200003 | 37.757791181125995 | -122.42037938302 | (37.757791181126, -122.42037938302) | |||
| 36840 | 36840 | 228015 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1224 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5998227.909 | 2106103.56312 | 37.7628569129495 | -122.44929290966199 | (37.7628569129495, -122.449292909662) | |||
| 36852 | 36852 | 208036 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1780 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993763.84013 | 2103377.07875 | 37.755114339159896 | -122.46453446231199 | (37.7551143391599, -122.464534462312) | |||
| 36858 | 36858 | 227859 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6004104.47801 | 2102871.3530599996 | 37.75431641748921 | -122.428737480655 | (37.7543164174892, -122.428737480655) | |||
| 36890 | 36890 | 191535 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1150 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6014535.49417 | 2103905.68613 | 37.757741315531504 | -122.392736452724 | (37.7577413155315, -122.392736452724) | |||
| 36958 | 36958 | 218331 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 480 Castenada Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5992969.5872 | 2099943.88935 | 37.745641864594 | -122.46703160803601 | (37.745641864594, -122.467031608036) | |||
| 37037 | 37037 | 208121 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Pacheco St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5994733.18466 | 2099795.5260099997 | 37.745336133767296 | -122.46092264556499 | (37.7453361337673, -122.460922645565) | |||
| 37080 | 37080 | 250025 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Peter Yorke Way | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6005592.08729 | 2114239.19437 | 37.7856138643192 | -122.424401456086 | (37.7856138643192, -122.424401456086) | |||
| 37214 | 37214 | 191135 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 651 Arthur Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6015829.2920699995 | 2099737.9733599997 | 37.7463694242077 | -122.387971104383 | (37.7463694242077, -122.387971104383) | ||||
| 37279 | 37279 | 227906 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6000029.07257 | 2105659.56527 | 37.761740666326205 | -122.443031445545 | (37.7617406663262, -122.443031445545) | |||
| 37582 | 37582 | 208152 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 80 Nordhoff St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000435.90571 | 2095588.3603299998 | 37.7341107411125 | -122.44090187344999 | (37.7341107411125, -122.44090187345) | |||
| 37797 | 37797 | 208027 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1648 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993736.02678 | 2104273.98394 | 37.7575754059053 | -122.464695774593 | (37.7575754059053, -122.464695774593) | |||
| 37835 | 37835 | 247317 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 225 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002750.0987 | 2109384.7475 | 37.7721238731083 | -122.433886794778 | (37.7721238731083, -122.433886794778) | |||
| 37878 | 37878 | 138694 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001275.2721 | 2114538.5353 | 37.786191064717606 | -122.43935781732701 | (37.7861910647176, -122.439357817327) | |||
| 37926 | 37926 | 129692 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6000656.11857 | 2116207.7557599996 | 37.790739056615706 | -122.441619752742 | (37.7907390566157, -122.441619752742) | |||
| 38079 | 38079 | 140412 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1315 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003232.5898 | 2112885.9212 | 37.7817645952487 | -122.43246793575899 | (37.7817645952487, -122.432467935759) | |||
| 38283 | 38283 | 227736 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1248 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997502.04655 | 2105374.80245 | 37.7608143745065 | -122.45175082785101 | (37.7608143745065, -122.451750827851) | |||
| 38638 | 38638 | 227968 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 25 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009987.14395 | 2099953.044 | 37.7466345704296 | -122.408187829802 | (37.7466345704296, -122.408187829802) | |||
| 38744 | 38744 | 227771 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 464 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6002129.73865 | 2101510.34926 | 37.7504674639107 | -122.43546926501101 | (37.7504674639107, -122.435469265011) | |||
| 38974 | 38974 | 227825 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 397 Jarboe Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008200.416540001 | 2096957.1149400002 | 37.7383082035529 | -122.414154245241 | (37.7383082035529, -122.414154245241) | |||
| 39152 | 39152 | 227713 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 869 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998668.89091 | 2107167.7132099997 | 37.765804015560605 | -122.447844329357 | (37.7658040155606, -122.447844329357) | |||
| 39367 | 39367 | 191556 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011784.36003 | 2106250.86747 | 37.7640274786207 | -122.402415962926 | (37.7640274786207, -122.402415962926) | |||
| 39655 | 39655 | 142188 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1501 HAYES ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000411.8524 | 2110252.886 | 37.774374595004204 | -122.442037282737 | (37.7743745950042, -122.442037282737) | |||
| 39738 | 39738 | 191552 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 151 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012603.95366 | 2106732.49596 | 37.76539564241521 | -122.399615029827 | (37.7653956424152, -122.399615029827) | |||
| 39989 | 39989 | 227790 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 127 Roanoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003497.77442 | 2096110.61078 | 37.735718631796395 | -122.430353286268 | (37.7357186317964, -122.430353286268) | |||
| 39995 | 39995 | 129696 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2970 Washington St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6000569.369419999 | 2116197.48764 | 37.7907059201805 | -122.441919162241 | (37.7907059201805, -122.441919162241) | |||
| 40247 | 40247 | 182303 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2533 Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986913.9581 | 2105029.3143 | 37.7592536713044 | -122.488344446038 | (37.7592536713044, -122.488344446038) | |||
| 40378 | 40378 | 227910 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Mars St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5999624.8091 | 2105673.33115 | 37.761755406220395 | -122.44443061529499 | (37.7617554062204, -122.444430615295) | |||
| 40568 | 40568 | 227743 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1232 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5997480.00415 | 2105547.5565400003 | 37.7612874511878 | -122.4518395253 | (37.7612874511878, -122.4518395253) | |||
| 40593 | 40593 | 139769 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003232.168 | 2113181.5852 | 37.7825763904878 | -122.432490519559 | (37.7825763904878, -122.432490519559) | |||
| 40649 | 40649 | 227918 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 200 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003807.26174 | 2109058.8456 | 37.771288960948894 | -122.430206727358 | (37.7712889609489, -122.430206727358) | |||
| 40839 | 40839 | 208110 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 500 Cortes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 3ft | 5993194.87968 | 2099514.9753099997 | 37.744477176897504 | -122.466221422307 | (37.7444771768975, -122.466221422307) | |||
| 40953 | 40953 | 245956 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 753 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997593.1598 | 2107917.3843 | 37.76780087666 | -122.45161911748 | (37.76780087666, -122.45161911748) | |||
| 41137 | 41137 | 191119 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 239 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014052.7163 | 2105909.00339 | 37.7632151632714 | -122.39454638782301 | (37.7632151632714, -122.394546387823) | |||
| 41216 | 41216 | 227969 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Mullen Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010032.30789 | 2099922.75582 | 37.746553934526794 | -122.40802952125799 | (37.7465539345268, -122.408029521258) | |||
| 41487 | 41487 | 208150 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 210 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6000776.72095 | 2094702.6231900002 | 37.7316981172754 | -122.439660093143 | (37.7316981172754, -122.439660093143) | |||
| 41501 | 41501 | 109608 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 30 Curtis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000500.58572 | 2088469.85865 | 37.7145686465987 | -122.440167960077 | (37.7145686465987, -122.440167960077) | |||
| 41550 | 41550 | 250024 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Peter Yorke Way | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6005604.615069999 | 2114246.3062 | 37.785634099068496 | -122.42435861956301 | (37.7856340990685, -122.424358619563) | |||
| 41780 | 41780 | 208153 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 435 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5999203.01227 | 2094950.2253400001 | 37.732288277587706 | -122.445118495046 | (37.7322882775877, -122.445118495046) | |||
| 41944 | 41944 | 208039 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993764.89188 | 2103262.79505 | 37.7548006061648 | -122.464522527406 | (37.7548006061648, -122.464522527406) | |||
| 41985 | 41985 | 208040 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1800 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993765.03944 | 2103252.9034 | 37.7547734547454 | -122.464521298918 | (37.7547734547454, -122.464521298918) | |||
| 42124 | 42124 | 141441 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2920 TURK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997035.9754 | 2111593.694 | 37.77786314542929 | -122.45381185366301 | (37.7778631454293, -122.453811853663) | |||
| 42186 | 42186 | 228008 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1149 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998158.99229 | 2106286.14081 | 37.7633542830094 | -122.449544423956 | (37.7633542830094, -122.449544423956) | |||
| 42241 | 42241 | 227982 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3858 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004756.65854 | 2101362.944 | 37.7502115672126 | -122.426374681956 | (37.7502115672126, -122.426374681956) | |||
| 42466 | 42466 | 227858 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 132 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004094.70808 | 2102310.5679200003 | 37.7527760802641 | -122.428731293332 | (37.7527760802641, -122.428731293332) | |||
| 42595 | 42595 | 129690 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3498 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997573.73789 | 2116108.4846099997 | 37.7902903857379 | -122.45227741238199 | (37.7902903857379, -122.452277412382) | |||
| 42611 | 42611 | 191144 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 75 Federal St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014827.1240300005 | 2113162.01848 | 37.7831733516173 | -122.39237527782 | (37.7831733516173, -122.39237527782) | |||
| 42620 | 42620 | 227911 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2 Mars St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5999615.40288 | 2105661.25398 | 37.7617217086142 | -122.444462279533 | (37.7617217086142, -122.444462279533) | |||
| 42626 | 42626 | 227970 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 Mullen Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6010016.577930001 | 2099914.5680299997 | 37.7465305719291 | -122.40808333667101 | (37.7465305719291, -122.408083336671) | |||
| 42724 | 42724 | 227852 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 115 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004384.0702 | 2101006.82199 | 37.749212670433295 | -122.427637746503 | (37.7492126704333, -122.427637746503) | |||
| 42928 | 42928 | 227835 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1850 Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008691.15218 | 2107476.7836599997 | 37.767220399221 | -122.41320118868799 | (37.767220399221, -122.413201188688) | |||
| 43056 | 43056 | 191129 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1136 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6012185.62091 | 2103105.89638 | 37.7554144753107 | -122.400807145928 | (37.7554144753107, -122.400807145928) | |||
| 43198 | 43198 | 191533 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 201 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6016236.27796 | 2107216.03359 | 37.7669251365154 | -122.387085273085 | (37.7669251365154, -122.387085273085) | |||
| 43375 | 43375 | 208071 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 85 Marcela Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 5994586.62981 | 2100556.35867 | 37.74741675489079 | -122.46148455276399 | (37.7474167548908, -122.461484552764) | |||
| 43596 | 43596 | 129685 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3301 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5999807.325669999 | 2119912.42287 | 37.8008626943206 | -122.444822934625 | (37.8008626943206, -122.444822934625) | |||
| 43808 | 43808 | 208021 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1684 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5993741.97238 | 2104049.76533 | 37.7569601023484 | -122.464658931187 | (37.7569601023484, -122.464658931187) | |||
| 44075 | 44075 | 124022 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 301 Funston Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 3ft | 5991831.5909 | 2112929.38774 | 37.7812308417217 | -122.471912840662 | (37.7812308417217, -122.471912840662) | |||
| 44146 | 44146 | 138695 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2511 BUSH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001299.3374 | 2114542.2377 | 37.786202600035296 | -122.43927482337 | (37.7862026000353, -122.43927482337) | |||
| 44580 | 44580 | 100494 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1899X Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6008692.6 | 2107433.7 | 37.7671021827668 | -122.413193133966 | (37.7671021827668, -122.413193133966) | |||
| 44840 | 44840 | 208096 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1504 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993391.51426 | 2105173.9377900003 | 37.760026577386206 | -122.465952620345 | (37.7600265773862, -122.465952620345) | |||
| 44961 | 44961 | 208090 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 122 Ashton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5994177.92287 | 2090747.0249299998 | 37.720459209606396 | -122.46218652760099 | (37.7204592096064, -122.462186527601) | |||
| 45043 | 45043 | 227773 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1635 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002625.86544 | 2100734.86833 | 37.7483663409473 | -122.43369820581499 | (37.7483663409473, -122.433698205815) | |||
| 45180 | 45180 | 227959 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 3470 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005235.72016 | 2103729.4555900004 | 37.7567365263755 | -122.424886401099 | (37.7567365263755, -122.424886401099) | |||
| 45277 | 45277 | 208077 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 338 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995744.67706 | 2091237.28528 | 37.7218954350055 | -122.456806235434 | (37.7218954350055, -122.456806235434) | |||
| 45329 | 45329 | 227943 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 2526 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009705.19097 | 2102597.95155 | 37.753881108735705 | -122.40934942024599 | (37.7538811087357, -122.409349420246) | |||
| 45352 | 45352 | 139767 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1400 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003238.1177 | 2113143.656 | 37.7824725838131 | -122.432467226219 | (37.7824725838131, -122.432467226219) | |||
| 45629 | 45629 | 129729 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 332 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011961.72119 | 2119134.66813 | 37.7994132983523 | -122.402708639193 | (37.7994132983523, -122.402708639193) | |||
| 45673 | 45673 | 191560 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 401 Rhode Island St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011774.48817 | 2106453.32112 | 37.7645828198606 | -122.402464343748 | (37.7645828198606, -122.402464343748) | |||
| 45933 | 45933 | 227801 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1263 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5997468.36846 | 2105263.95223 | 37.7605080789056 | -122.451859307684 | (37.7605080789056, -122.451859307684) | |||
| 46247 | 46247 | 250029 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1398 Gough St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6005499.34318 | 2114400.53474 | 37.7860516273342 | -122.424733805923 | (37.7860516273342, -122.424733805923) |
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");