Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47751 | 47751 | 201529 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 718 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020227.99181 | 2093752.40727 | 37.7301769329099 | -122.372346575457 | (37.7301769329099, -122.372346575457) | |||
| 65008 | 65008 | 201531 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 724 Innes Ave | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6020190.2852300005 | 2093779.8282400002 | 37.7302501539023 | -122.37247883063101 | (37.7302501539023, -122.372478830631) | |||
| 172235 | 172235 | 201654 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 744 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6020169.84192 | 2093795.1774099998 | 37.73029117649 | -122.372550568669 | (37.73029117649, -122.372550568669) | |||
| 56527 | 56527 | 201482 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019833.06925 | 2094138.86397 | 37.731216363049704 | -122.373738644125 | (37.7312163630497, -122.373738644125) | |||
| 160233 | 160233 | 201483 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6019824.354280001 | 2094127.5426599998 | 37.731184797722705 | -122.37376798991899 | (37.7311847977227, -122.373767989919) | |||
| 153943 | 153943 | 201484 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019815.12004 | 2094115.72508 | 37.731151841174004 | -122.37379909656 | (37.731151841174, -122.37379909656) | |||
| 149821 | 149821 | 201485 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 801 Arelious Walker Dr | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6019804.87091 | 2094104.0965 | 37.7311193477698 | -122.373833724951 | (37.7311193477698, -122.373833724951) | |||
| 175526 | 175526 | 50769 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019759.98299 | 2094100.60005 | 37.7311072788765 | -122.373988670067 | (37.7311072788765, -122.373988670067) | ||
| 147101 | 147101 | 50770 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019742.9176 | 2094113.11365 | 37.7311407003688 | -122.374048535228 | (37.7311407003688, -122.374048535228) | ||
| 123411 | 123411 | 50768 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 800 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2004 12:00:00 AM | 5 | Permit Number 47301 | 6019728.52002 | 2094123.20714 | 37.7311676233867 | -122.374099009669 | (37.7311676233867, -122.374099009669) | ||
| 33756 | 33756 | 44524 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019592.367330001 | 2094224.8297299999 | 37.73143917097 | -122.37457675743799 | (37.73143917097, -122.374576757438) | ||
| 65032 | 65032 | 44522 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019580.98035 | 2094232.6652900001 | 37.731460059529795 | -122.37461666754601 | (37.7314600595298, -122.374616667546) | ||
| 61890 | 61890 | 44521 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 7 | Permit Number 43824 | 6019557.73451 | 2094250.2049099999 | 37.731506941191 | -122.37469824864999 | (37.731506941191, -122.37469824865) | ||
| 53030 | 53030 | 44523 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 828 Innes Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2001 12:00:00 AM | 6 | Permit Number 43824 | 6019546.1676 | 2094257.53708 | 37.7315264375989 | -122.37473874602101 | (37.7315264375989, -122.374738746021) | ||
| 166526 | 166526 | 39997 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 871 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41255 | 6019390.137999999 | 2094293.5520799998 | 37.731616743009795 | -122.375280672083 | (37.7316167430098, -122.375280672083) | |
| 62659 | 62659 | 201486 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 934 Innes Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6019032.21192 | 2094642.96183 | 37.7325564518085 | -122.376542332772 | (37.7325564518085, -122.376542332772) | |||
| 34589 | 34589 | 198240 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6018392.06905 | 2093389.2924400002 | 37.7290788489885 | -122.37866846500201 | (37.7290788489885, -122.378668465002) | |||
| 76727 | 76727 | 198241 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6018372.24066 | 2093404.16555 | 37.7291185945476 | -122.37873804643 | (37.7291185945476, -122.37873804643) | |||
| 169024 | 169024 | 198242 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6018274.99402 | 2093475.4315099998 | 37.729308915358295 | -122.379079187167 | (37.7293089153583, -122.379079187167) | |||
| 134975 | 134975 | 198243 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6018259.022030001 | 2093487.44362 | 37.7293410175719 | -122.379135238328 | (37.7293410175719, -122.379135238328) | |||
| 77781 | 77781 | 40025 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Middle Point Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | Permit Number 41269 | 6018237.888375901 | 2095348.52577329 | 37.7344500201686 | -122.37933752244801 | (37.7344500201686, -122.379337522448) | ||
| 66912 | 66912 | 198244 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6018235.60587 | 2093504.61605 | 37.7293868784964 | -122.37921738328001 | (37.7293868784964, -122.37921738328) | |||
| 125555 | 125555 | 198253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1000 Oakdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6018226.96048 | 2093133.1999700002 | 37.728366565251605 | -122.3792214842 | (37.7283665652516, -122.3792214842) | ||||
| 154677 | 154677 | 40024 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 201 Middle Point Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1999 12:00:00 AM | 5 | Permit Number 41269 | 6018160.1485 | 2095159.9436700002 | 37.7339279233224 | -122.379593200966 | (37.7339279233224, -122.379593200966) | ||
| 69254 | 69254 | 198245 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6018124.214919999 | 2093586.9966099998 | 37.7296069363141 | -122.37960819717199 | (37.7296069363141, -122.379608197172) | |||
| 25193 | 25193 | 198246 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6018108.95866 | 2093601.24715 | 37.72964522404521 | -122.379661929856 | (37.7296452240452, -122.379661929856) | |||
| 160121 | 160121 | 198247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6018027.1823 | 2093649.37702 | 37.7297728684077 | -122.37994798531601 | (37.7297728684077, -122.379947985316) | |||
| 147417 | 147417 | 198252 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9 Navy Rd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6018004.947869999 | 2093626.47377 | 37.729708753948 | -122.38002326218201 | (37.729708753948, -122.380023262182) | |||
| 43853 | 43853 | 198248 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6018004.07949 | 2093668.2134200002 | 37.729823314986504 | -122.380029163529 | (37.7298233149865, -122.380029163529) | |||
| 160350 | 160350 | 198251 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9 Navy Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017988.84232 | 2093636.41123 | 37.729735151757396 | -122.380079631679 | (37.7297351517574, -122.380079631679) | |||
| 54809 | 54809 | 198249 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 8 Navy Rd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017983.9946 | 2093684.20523 | 37.729866117318295 | -122.380099710848 | (37.7298661173183, -122.380099710848) | |||
| 148330 | 148330 | 198250 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 9 Navy Rd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017965.73277 | 2093650.1213599998 | 37.7297715221359 | -122.38016047714599 | (37.7297715221359, -122.380160477146) | |||
| 92247 | 92247 | 10776 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1120X Hudson Ave | 50 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 113326 | 113326 | 10773 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1120X Hudson Ave | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2014 12:00:00 AM | 3 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 113718 | 113718 | 10816 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1139X Hudson Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/2016 12:00:00 AM | 3 | 3X4 | 6017660.0560099995 | 2094705.99201 | 37.7326538662851 | -122.381290636609 | (37.7326538662851, -122.381290636609) | ||
| 55995 | 55995 | 198204 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017617.61765 | 2094076.09309 | 37.730921944794105 | -122.381393571762 | (37.7309219447941, -122.381393571762) | |||
| 165608 | 165608 | 198205 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017610.72061 | 2094103.62702 | 37.73099716678961 | -122.38141933016199 | (37.7309971667896, -122.381419330162) | |||
| 54989 | 54989 | 198206 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017603.66847 | 2094123.4590200002 | 37.7310512322275 | -122.381445089439 | (37.7310512322275, -122.381445089439) | |||
| 98892 | 98892 | 11987 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 8 | 3X3 | 6017600.71436 | 2094154.1557900002 | 37.731135356436795 | -122.381457436259 | (37.7311353564368, -122.381457436259) | ||
| 60032 | 60032 | 198207 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017596.20961 | 2094137.30678 | 37.7310888436561 | -122.38147183887699 | (37.7310888436561, -122.381471838877) | |||
| 51362 | 51362 | 198208 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017595.32178 | 2094150.16595 | 37.731124103395 | -122.381475802191 | (37.731124103395, -122.381475802191) | |||
| 76974 | 76974 | 198210 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017591.472030001 | 2094158.2336799998 | 37.7311460432509 | -122.38148967241399 | (37.7311460432509, -122.381489672414) | |||
| 40710 | 40710 | 198209 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017589.5812 | 2094149.7108200002 | 37.7311225367566 | -122.381495616943 | (37.7311225367566, -122.381495616943) | |||
| 67209 | 67209 | 198211 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017584.56283 | 2094156.6603 | 37.7311413415942 | -122.381513449601 | (37.7311413415942, -122.381513449601) | |||
| 172854 | 172854 | 198213 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017583.92738 | 2094182.07075 | 37.7312110786156 | -122.38151741292299 | (37.7312110786156, -122.381517412923) | |||
| 32374 | 32374 | 198212 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017582.254269999 | 2094170.11891 | 37.7311781688352 | -122.381522366373 | (37.7311781688352, -122.381522366373) | |||
| 133757 | 133757 | 198214 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017573.17419 | 2094188.8506 | 37.7312291010462 | -122.381555060321 | (37.7312291010462, -122.381555060321) | |||
| 68997 | 68997 | 198215 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017571.31227 | 2094196.02188 | 37.731248689170705 | -122.38156199591101 | (37.7312486891707, -122.381561995911) | |||
| 173691 | 173691 | 198216 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017566.99818 | 2094195.2528 | 37.7312463392341 | -122.381576857185 | (37.7312463392341, -122.381576857185) | |||
| 187042 | 187042 | 198217 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017560.86831 | 2094203.9369400002 | 37.7312698457244 | -122.381598653182 | (37.7312698457244, -122.381598653182) | |||
| 37415 | 37415 | 198218 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017554.24593 | 2094216.62614 | 37.7313043221245 | -122.38162243033999 | (37.7313043221245, -122.38162243034) | |||
| 390 | 390 | 251276 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/09/1998 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 391 | 391 | 251275 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175x Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 09/16/2011 12:00:00 AM | 3x3 | 6017547.0 | 2094834.0 | 37.732999109091 | -122.381690402626 | (37.732999109091, -122.381690402626) | ||
| 87348 | 87348 | 10870 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/2011 12:00:00 AM | 3 | 3x4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 102996 | 102996 | 10868 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/2011 12:00:00 AM | 3 | 3x3 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 108269 | 108269 | 10869 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1175X Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/2011 12:00:00 AM | 3 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 64074 | 64074 | 198219 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017539.02456 | 2094243.4713299999 | 37.73137719328629 | -122.381676920275 | (37.7313771932863, -122.381676920275) | |||
| 50436 | 50436 | 198220 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1189 La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017527.033969999 | 2094259.97838 | 37.7314218563182 | -122.38171952203501 | (37.7314218563182, -122.381719522035) | |||
| 147321 | 147321 | 198221 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017501.61868 | 2094293.31317 | 37.731511983695 | -122.381809706051 | (37.731511983695, -122.381809706051) | |||
| 74434 | 74434 | 198222 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017496.04751 | 2094298.34465 | 37.7315254915072 | -122.38182931668301 | (37.7315254915072, -122.381829316683) | |||
| 32341 | 32341 | 198203 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1194 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017493.49527 | 2094230.9747400002 | 37.7313403660485 | -122.38183345624901 | (37.7313403660485, -122.381833456249) | |||
| 187784 | 187784 | 198223 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017491.0802 | 2094306.0971900001 | 37.7315465041574 | -122.38184702883301 | (37.7315465041574, -122.381847028833) | |||
| 178364 | 178364 | 198224 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017481.225819999 | 2094316.49879 | 37.7315745207288 | -122.381881820907 | (37.7315745207288, -122.381881820907) | |||
| 9796 | 9796 | 11975 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:52:00 PM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 84775 | 84775 | 11984 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 94343 | 94343 | 11996 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 103682 | 103682 | 11982 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 105152 | 105152 | 11980 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 8 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 105266 | 105266 | 11994 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 106875 | 106875 | 11990 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 110214 | 110214 | 11989 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 8 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 111656 | 111656 | 11998 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 111813 | 111813 | 11986 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 117263 | 117263 | 11997 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 117964 | 117964 | 26533 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 126789 | 126789 | 11993 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/2011 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 138513 | 138513 | 11988 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 141449 | 141449 | 11981 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | |||
| 143082 | 143082 | 11983 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 3 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 150613 | 150613 | 198225 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017442.1049 | 2094354.6376599998 | 37.731677082136 | -122.38201972293699 | (37.731677082136, -122.382019722937) | |||
| 34075 | 34075 | 198202 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017386.73333 | 2094343.85008 | 37.731644403447106 | -122.38221040528 | (37.7316444034471, -122.38221040528) | |||
| 39693 | 39693 | 198201 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017349.13992 | 2094376.34522 | 37.731731552271796 | -122.38234263442101 | (37.7317315522718, -122.382342634421) | |||
| 58651 | 58651 | 198226 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017330.47755 | 2094444.8876599998 | 37.731918725448104 | -122.38241192178002 | (37.7319187254481, -122.38241192178) | |||
| 113721 | 113721 | 12066 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1225X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/2007 12:00:00 AM | 3 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.38243353641701 | (37.7317765554235, -122.382433536417) | ||
| 78892 | 78892 | 12017 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1230X La Salle Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2011 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 88371 | 88371 | 12007 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1230X La Salle Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 88880 | 88880 | 12003 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1230X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 94580 | 94580 | 12009 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1230X La Salle Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 94671 | 94671 | 12001 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1230X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 105401 | 105401 | 12005 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1230X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2011 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 116908 | 116908 | 12000 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1230X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/1997 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 65830 | 65830 | 198227 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6017315.6556400005 | 2094453.93145 | 37.7319427391711 | -122.38246379378401 | (37.7319427391711, -122.382463793784) | |||
| 36438 | 36438 | 198228 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1195 La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6017291.3126300005 | 2094471.7306099997 | 37.731990267431605 | -122.382549191609 | (37.7319902674316, -122.382549191609) | |||
| 83009 | 83009 | 10787 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1200X Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/2011 12:00:00 AM | 3 | 3x4 | 6017289.300369999 | 2095275.75897 | 37.7341978590464 | -122.38261207464399 | (37.7341978590464, -122.382612074644) | ||
| 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) | |||
| 154498 | 154498 | 198200 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017252.54934 | 2094443.2087 | 37.7319098104682 | -122.382681221984 | (37.7319098104682, -122.382681221984) | |||
| 42409 | 42409 | 198199 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1196 La Salle Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6017229.03163 | 2094455.2232599999 | 37.7319415007983 | -122.38276336425 | (37.7319415007983, -122.38276336425) | |||
| 143474 | 143474 | 82684 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1232 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 3x3 | Permit Number 52464 | 6017221.0779692 | 2093189.9141815 | 37.7284667714932 | -122.382702846182 | (37.7284667714932, -122.382702846182) | ||
| 18717 | 18717 | 12041 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250X La Salle Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
| 79725 | 79725 | 12024 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1250X La Salle Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) |
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");