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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186261 | 186261 | 214951 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 60 San Andreas Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993735.153080001 | 2095430.2439299999 | 37.7332926818073 | -122.464056818891 | (37.7332926818073, -122.464056818891) | |||
186254 | 186254 | 200591 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 26 Las Villas Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016314.8288 | 2095177.2118 | 37.733873386771606 | -122.38597429637699 | (37.7338733867716, -122.385974296377) | |||
186241 | 186241 | 218577 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3694 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990498.545530001 | 2091379.0152599998 | 37.7219819587905 | -122.474950929165 | (37.7219819587905, -122.474950929165) | |||
186238 | 186238 | 66350 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 106 Santa Ysabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50525 | 6000670.661119999 | 2093317.15683 | 37.727887909175294 | -122.439927459785 | (37.7278879091753, -122.439927459785) | |
186206 | 186206 | 187476 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4399 Mission St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003072.4067 | 2093406.5204 | 37.7282697089694 | -122.431630950625 | (37.7282697089694, -122.431630950625) | |||
186193 | 186193 | 69033 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1363 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1994 12:00:00 AM | 4 | Permit Number 33039 | 5984290.4784 | 2105907.3828 | 37.7615111837365 | -122.497482392959 | (37.7615111837365, -122.497482392959) | |
186170 | 186170 | 218601 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1248 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995838.25028 | 2106966.2602 | 37.765088679516 | -122.45762027565 | (37.765088679516, -122.45762027565) | |||
186149 | 186149 | 218589 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3658 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5990546.49635 | 2092127.2474099998 | 37.724039196633704 | -122.47483976394699 | (37.7240391966337, -122.474839763947) | |||
186132 | 186132 | 241664 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 850 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005436.15003 | 2098142.50005 | 37.7414073500724 | -122.42379599380101 | (37.7414073500724, -122.423795993801) | |||
186125 | 186125 | 59926 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1388 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52298 | 6016251.6962 | 2093569.0708 | 37.7294542580378 | -122.38608049983101 | (37.7294542580378, -122.386080499831) | |
186084 | 186084 | 241759 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 551 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6003001.76602 | 2098878.83722 | 37.7432914351439 | -122.432265816922 | (37.7432914351439, -122.432265816922) | |||
186058 | 186058 | 241712 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2948 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009397.16539 | 2104542.34722 | 37.7592027183425 | -122.41055194332199 | (37.7592027183425, -122.410551943322) | |||
186024 | 186024 | 242210 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2429 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001671.14339 | 2107151.96867 | 37.7659319279547 | -122.43745906629299 | (37.7659319279547, -122.437459066293) | |||
186008 | 186008 | 241785 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 147 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005010.93948 | 2098703.11146 | 37.742922648360896 | -122.42530610928999 | (37.7429226483609, -122.42530610929) | |||
185996 | 185996 | 142334 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 403 LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000173.3979 | 2110311.9049 | 37.7745230543144 | -122.442866377923 | (37.7745230543144, -122.442866377923) | |||
185928 | 185928 | 62125 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 857 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/31/1985 12:00:00 AM | 9 | Permit Number 22232 | 6001110.80727 | 2092000.1424099999 | 37.7242967336823 | -122.43831155435 | (37.7242967336823, -122.43831155435) | |
185924 | 185924 | 92461 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3445 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52849 | 5983517.9831 | 2104231.1385 | 37.756863379703205 | -122.500030178068 | (37.7568633797032, -122.500030178068) |
185923 | 185923 | 241999 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 858 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009357.3474 | 2104168.6233099997 | 37.758174324706104 | -122.410663261406 | (37.7581743247061, -122.410663261406) | |||
185904 | 185904 | 247801 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 462 30th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6003630.84189 | 2098375.23957 | 37.741944320889104 | -122.430054719445 | (37.7419443208891, -122.430054719445) | |||
185895 | 185895 | 242220 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 132 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001046.28525 | 2105585.24607 | 37.76159454897171 | -122.439507995319 | (37.7615945489717, -122.439507995319) | |||
185855 | 185855 | 180082 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2100x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000152.851 | 2089912.6147900003 | 37.7185103256827 | -122.441473335931 | (37.7185103256827, -122.441473335931) | |||
185791 | 185791 | 218494 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 248 Minerva St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994534.17979 | 2089038.5715 | 37.7157887100619 | -122.460831317629 | (37.7157887100619, -122.460831317629) | |||
185768 | 185768 | 187475 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4399 Mission St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003058.899 | 2093390.3112 | 37.728224436503204 | -122.43167649048401 | (37.7282244365032, -122.431676490484) | |||
185751 | 185751 | 84302 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 743 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50091 | 5986293.432130001 | 2110848.66457 | 37.77519575647779 | -122.490918714526 | (37.7751957564778, -122.490918714526) | |
185735 | 185735 | 241751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 124 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004258.5681300005 | 2109322.98446 | 37.7720397734594 | -122.428664471011 | (37.7720397734594, -122.428664471011) | |||
185712 | 185712 | 62077 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 619 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/1985 12:00:00 AM | 9 | Permit Number 22159 | 6013309.2172300005 | 2104160.9761 | 37.75837410190321 | -122.396995353258 | (37.7583741019032, -122.396995353258) | |
185668 | 185668 | 241410 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 126 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003749.89661 | 2095067.6008900001 | 37.732869040874 | -122.42940724624701 | (37.732869040874, -122.429407246247) | |||
185660 | 185660 | 218735 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 90 Ravenwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994381.26837 | 2095937.02396 | 37.7347213915808 | -122.461859771513 | (37.7347213915808, -122.461859771513) | |||
185596 | 185596 | 218580 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3678 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990518.16488 | 2091704.36213 | 37.72287641728521 | -122.474906847073 | (37.7228764172852, -122.474906847073) | |||
185585 | 185585 | 180028 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001180.14199 | 2091386.50132 | 37.7226157577852 | -122.438027939654 | (37.7226157577852, -122.438027939654) | |||
185581 | 185581 | 242237 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 10 Loma Vista Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999962.961130001 | 2106933.24517 | 37.7652341052825 | -122.443351586234 | (37.7652341052825, -122.443351586234) | |||
185562 | 185562 | 187441 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4440 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6002618.1811 | 2092953.1381 | 37.7269990666756 | -122.433168844643 | (37.7269990666756, -122.433168844643) | |||
185556 | 185556 | 218715 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 80 Linares Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994133.5852 | 2102083.00239 | 37.751582444287 | -122.463161893602 | (37.751582444287, -122.463161893602) | |||
185537 | 185537 | 241723 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 75 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010635.57479 | 2100079.2463 | 37.7470173812579 | -122.40595450110901 | (37.7470173812579, -122.405954501109) | |||
185522 | 185522 | 218454 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Staples Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5997327.84534 | 2093835.64857 | 37.7291207070307 | -122.451520978234 | (37.7291207070307, -122.451520978234) | |||
185508 | 185508 | 123922 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 301 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993058.96098 | 2113381.71582 | 37.782543754573105 | -122.467699688993 | (37.7825437545731, -122.467699688993) | |||
185476 | 185476 | 30762 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1622 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34643 | 6014646.4705 | 2094066.0889 | 37.7307299968475 | -122.391664701561 | (37.7307299968475, -122.391664701561) | |
185455 | 185455 | 136858 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 657 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007825.30735 | 2114737.29156 | 37.7871073729566 | -122.41671043953998 | (37.7871073729566, -122.41671043954) | |||
185423 | 185423 | 198190 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3308 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6013400.76782 | 2089956.3922400002 | 37.71937637370021 | -122.39568348162399 | (37.7193763737002, -122.395683481624) | |||
185409 | 185409 | 180035 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001087.26718 | 2091207.92549 | 37.722120146807896 | -122.43833619936399 | (37.7221201468079, -122.438336199364) | |||
185397 | 185397 | 201867 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 855 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6011826.1868 | 2112317.2774 | 37.7806867914539 | -122.402697944814 | (37.7806867914539, -122.402697944814) | |||
185396 | 185396 | 180066 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000525.601009999 | 2090267.6783099999 | 37.7195064786158 | -122.440210344258 | (37.7195064786158, -122.440210344258) | |||
185351 | 185351 | 138234 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 234 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998967.1521 | 2112281.6121 | 37.77986252017521 | -122.44718078660802 | (37.7798625201752, -122.447180786608) | |||
185323 | 185323 | 183910 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2290 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5988891.3694 | 2099774.2681 | 37.7449398894305 | -122.48112088975901 | (37.7449398894305, -122.481120889759) | |||
185305 | 185305 | 248418 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1757 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997316.374 | 2108092.7223 | 37.7682664550348 | -122.452589137037 | (37.7682664550348, -122.452589137037) | |||
185271 | 185271 | 198164 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 446 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010973.77024 | 2112144.81684 | 37.78016562568779 | -122.405634728269 | (37.7801656256878, -122.405634728269) | |||
185255 | 185255 | 218488 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 42 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995347.585530001 | 2090194.39725 | 37.719009103175296 | -122.458103431949 | (37.7190091031753, -122.458103431949) | |||
185229 | 185229 | 218397 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 253 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5994133.69186 | 2100284.3945299997 | 37.746643929681504 | -122.463031040447 | (37.7466439296815, -122.463031040447) | |||
185199 | 185199 | 218455 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 400 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997342.1641 | 2093834.91761 | 37.72911951994771 | -122.45147142466601 | (37.7291195199477, -122.451471424666) | |||
185189 | 185189 | 124111 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3920 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994869.45816 | 2112891.93028 | 37.78130330597929 | -122.46140067886299 | (37.7813033059793, -122.461400678863) | |||
185110 | 185110 | 241609 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 237 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008278.41085 | 2097482.23225 | 37.739754441124894 | -122.413921714713 | (37.7397544411249, -122.413921714713) | |||
185100 | 185100 | 36239 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5680 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/1998 12:00:00 AM | 5 | Permit Number 39265 | 5998053.6023 | 2087000.49619 | 37.7103944963771 | -122.448519929767 | (37.7103944963771, -122.448519929767) | ||
185065 | 185065 | 244435 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 402 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004622.8856 | 2109675.7119 | 37.773028888846 | -122.427429400254 | (37.773028888846, -122.427429400254) | |||
185009 | 185009 | 215443 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1341 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990795.117869999 | 2106264.24268 | 37.7628701392648 | -122.47501180514601 | (37.7628701392648, -122.475011805146) | |||
184996 | 184996 | 218596 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3648 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5990560.74644 | 2092329.5758599997 | 37.72459556581121 | -122.47480526506 | (37.7245955658112, -122.47480526506) | |||
184909 | 184909 | 138202 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 MASONIC AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998931.6178 | 2112562.5022 | 37.7806317412334 | -122.44732393749399 | (37.7806317412334, -122.447323937494) | |||
184908 | 184908 | 32417 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1300 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | 6 | Permit Number 36947 | 5989973.5898 | 2102472.0982 | 37.7524102768975 | -122.47757596317301 | (37.7524102768975, -122.477575963173) | ||
184870 | 184870 | 241420 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 92 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6005875.99908 | 2099086.18658 | 37.744023320528996 | -122.42234218035 | (37.744023320529, -122.42234218035) | |||
184848 | 184848 | 180252 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Still St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6003553.26198 | 2094731.05162 | 37.7319338178795 | -122.43006306247801 | (37.7319338178795, -122.430063062478) | |||
184797 | 184797 | 95523 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2944 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 23x3 | Permit Number 767315 | 5985332.6897 | 2105713.6699 | 37.7610403347331 | -122.493863589694 | (37.7610403347331, -122.493863589694) |
184794 | 184794 | 247800 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 450 30th St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6003679.98284 | 2098378.58347 | 37.741956285468504 | -122.42988504438298 | (37.7419562854685, -122.429885044383) | |||
184728 | 184728 | 46701 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1451 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/2002 12:00:00 AM | 3 | Permit Number 44831 | 5989585.2941 | 2105445.1858 | 37.76055104112721 | -122.479136200065 | (37.7605510411272, -122.479136200065) | |
184669 | 184669 | 143356 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1651 UNION ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005276.7947 | 2118850.6229 | 37.7982578772588 | -122.425820634818 | (37.7982578772588, -122.425820634818) | |||
184661 | 184661 | 180122 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 810 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6002259.34888 | 2088836.5682400002 | 37.7156755240783 | -122.434115169282 | (37.7156755240783, -122.434115169282) | |||
184644 | 184644 | 218751 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 455 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998479.52563 | 2097747.01686 | 37.7399262790815 | -122.44782101893298 | (37.7399262790815, -122.447821018933) | |||
184631 | 184631 | 241627 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 160 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008819.26701 | 2097789.25639 | 37.740627823104504 | -122.41207334890801 | (37.7406278231045, -122.412073348908) | |||
184616 | 184616 | 217586 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1608 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5995039.3832 | 2092256.6619 | 37.724653875290706 | -122.45931802382799 | (37.7246538752907, -122.459318023828) | |||
184589 | 184589 | 241709 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 217 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005456.93899 | 2102346.50293 | 37.7529517529255 | -122.42402300156601 | (37.7529517529255, -122.424023001566) | |||
184559 | 184559 | 180248 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 207 Theresa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001999.13836 | 2093837.5283400002 | 37.72939226542479 | -122.435372096859 | (37.7293922654248, -122.435372096859) | |||
184542 | 184542 | 241521 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4281 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000643.92896 | 2102847.95654 | 37.754055713006004 | -122.44070322669201 | (37.754055713006, -122.440703226692) | |||
184539 | 184539 | 242160 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4343 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001527.5914199995 | 2104651.72662 | 37.7590587126158 | -122.437776494597 | (37.7590587126158, -122.437776494597) | |||
184447 | 184447 | 180037 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001052.1769900005 | 2091141.7538400001 | 37.7219364584926 | -122.438452758712 | (37.7219364584926, -122.438452758712) | |||
184375 | 184375 | 242229 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 132 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6000546.41206 | 2105626.39917 | 37.761679083455604 | -122.441239800889 | (37.7616790834556, -122.441239800889) | |||
184371 | 184371 | 140268 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998235.1003 | 2110285.9342 | 37.7743410503874 | -122.44956942301201 | (37.7743410503874, -122.449569423012) | |||
184343 | 184343 | 241958 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1455 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008031.19855 | 2099692.17995 | 37.7458085809065 | -122.414932845889 | (37.7458085809065, -122.414932845889) | |||
184340 | 184340 | 29775 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4064 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2007 12:00:00 AM | 4 | 3x3 | 6003496.4537 | 2100416.92911 | 37.747542714836705 | -122.430665048859 | (37.7475427148367, -122.430665048859) | ||
184315 | 184315 | 180397 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1011 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002469.75801 | 2087564.3183799998 | 37.7121941450283 | -122.433297043449 | (37.7121941450283, -122.433297043449) | |||
184307 | 184307 | 217548 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 270 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5994291.0032 | 2088114.9342 | 37.7132386261164 | -122.461604915385 | (37.7132386261164, -122.461604915385) | |||
184296 | 184296 | 32438 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 171 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/1996 12:00:00 AM | 8 | Permit Number 36962 | 6010455.24101 | 2110457.3094900004 | 37.7755031157104 | -122.407309570783 | (37.7755031157104, -122.407309570783) | ||
184288 | 184288 | 184151 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1585 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5982482.7335 | 2104338.124 | 37.7570963201307 | -122.503618318652 | (37.7570963201307, -122.503618318652) | |||
184280 | 184280 | 62154 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2016 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/1985 12:00:00 AM | 12 | Permit Number 22268 | 5999531.3312099995 | 2121219.56404 | 37.804435997587206 | -122.445872051358 | (37.8044359975872, -122.445872051358) | |
184273 | 184273 | 72257 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 671 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 5 | 6002561.328430001 | 2089744.29585 | 37.718185077758896 | -122.43313621049101 | (37.7181850777589, -122.433136210491) | ||
184248 | 184248 | 241513 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4362 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6000838.93311 | 2102314.12817 | 37.7526010524124 | -122.439990582315 | (37.7526010524124, -122.439990582315) | |||
184239 | 184239 | 52953 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 263 Cotter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 5 | Permit Number 48940 | 6001495.84494 | 2094024.0402099998 | 37.7298757886149 | -122.437125374646 | (37.7298757886149, -122.437125374646) | |
184212 | 184212 | 214925 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2145 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5991708.45022 | 2095419.2985200002 | 37.7331456147813 | -122.471062825413 | (37.7331456147813, -122.471062825413) | |||
184206 | 184206 | 67401 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 543 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1992 12:00:00 AM | 9 | Permit Number 30898 | 5990607.88855 | 2111670.71644 | 37.777703994758795 | -122.476054246609 | (37.7777039947588, -122.476054246609) | |
184192 | 184192 | 180315 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001566.53867 | 2092362.21846 | 37.725316822989605 | -122.436762065623 | (37.7253168229896, -122.436762065623) | |||
184135 | 184135 | 51664 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2041 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | 6 | Permit Number 47942 | 5999393.08881 | 2115897.3984 | 37.7898148557271 | -122.445967423554 | (37.7898148557271, -122.445967423554) | ||
184132 | 184132 | 198229 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017254.927490001 | 2094491.22957 | 37.732041797678704 | -122.38267634045401 | (37.7320417976787, -122.382676340454) | |||
184113 | 184113 | 198192 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 994 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6013231.441819999 | 2089529.73255 | 37.7181954307556 | -122.39623889571699 | (37.7181954307556, -122.396238895717) | |||
184024 | 184024 | 241786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 314 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003854.692919999 | 2098683.0429700003 | 37.742802153595704 | -122.429302658685 | (37.7428021535957, -122.429302658685) | |||
183918 | 183918 | 180060 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6000687.072369999 | 2090454.3849400003 | 37.7200283246365 | -122.439665576299 | (37.7200283246365, -122.439665576299) | |||
183913 | 183913 | 242035 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 738 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005683.25395 | 2098884.8917400003 | 37.7434597360803 | -122.422994346221 | (37.7434597360803, -122.422994346221) | |||
183834 | 183834 | 35141 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 912 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 11 | Permit Number 38671 | 6001827.62914 | 2088655.8599 | 37.7151548273979 | -122.435594466837 | (37.7151548273979, -122.435594466837) | |
183778 | 183778 | 214841 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1301 Funston Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992062.26255 | 2106372.28014 | 37.7632401365395 | -122.470637103423 | (37.7632401365395, -122.470637103423) | |||
183747 | 183747 | 241821 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 198 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004722.7418599995 | 2102597.7316900003 | 37.7536000894961 | -122.426579883848 | (37.7536000894961, -122.426579883848) | |||
183736 | 183736 | 244441 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 422 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004403.3913 | 2109642.0368 | 37.772924008591104 | -122.42818625810499 | (37.7729240085911, -122.428186258105) | |||
183721 | 183721 | 198197 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017115.48652 | 2094514.63753 | 37.7320983668343 | -122.383160051612 | (37.7320983668343, -122.383160051612) | |||
183709 | 183709 | 242157 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4521 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000915.9214699995 | 2105197.3920299998 | 37.760522176675295 | -122.439931058878 | (37.7605221766753, -122.439931058878) | |||
183701 | 183701 | 218518 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 313 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992449.51413 | 2089938.14589 | 37.7181385540341 | -122.46810221944901 | (37.7181385540341, -122.468102219449) |
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");