Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94438 | 94438 | 41525 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.733693765900604 | -122.37859297315 | (37.7336937659006, -122.37859297315) | |||
| 73740 | 73740 | 200018 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1008 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6018250.1161 | 2092086.6599 | 37.7254942451327 | -122.37906877917801 | (37.7254942451327, -122.379068779178) | |||
| 29311 | 29311 | 199962 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1265 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018011.0370000005 | 2092725.2017 | 37.7272343718441 | -122.379939611903 | (37.7272343718441, -122.379939611903) | |||
| 157041 | 157041 | 199935 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1310 Griffith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6017874.9241 | 2092620.1152 | 37.726938315047896 | -122.380402857754 | (37.7269383150479, -122.380402857754) | |||
| 176691 | 176691 | 75284 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1335 Griffith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/13/1998 12:00:00 AM | 3 | 6017835.3471 | 2092484.583 | 37.7265639860027 | -122.380530259866 | (37.7265639860027, -122.380530259866) | ||
| 148569 | 148569 | 200000 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017688.3023 | 2092371.2757 | 37.726244750724 | -122.381030719301 | (37.726244750724, -122.381030719301) | |||
| 56909 | 56909 | 200009 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1435 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017676.8443 | 2092268.1534 | 37.72596096442079 | -122.381063162948 | (37.7259609644208, -122.381063162948) | |||
| 64313 | 64313 | 200002 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6017646.9261 | 2092314.6221 | 37.726086906985 | -122.381169818775 | (37.726086906985, -122.381169818775) | |||
| 59332 | 59332 | 200004 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1450 Griffith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017626.5562 | 2092285.3405 | 37.7260053809224 | -122.38123820192101 | (37.7260053809224, -122.381238201921) | |||
| 33924 | 33924 | 38574 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | |
| 183393 | 183393 | 50456 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171001 | (37.7596818177679, -122.38931576171) | ||
| 62276 | 62276 | 200097 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015067.4938 | 2092354.869 | 37.7260546913573 | -122.390089647295 | (37.7260546913573, -122.390089647295) | |||
| 159060 | 159060 | 200098 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015053.9581 | 2092365.0208 | 37.726081815437205 | -122.39013714867201 | (37.7260818154372, -122.390137148672) | |||
| 182025 | 182025 | 200099 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015044.482999999 | 2092374.4958 | 37.7261073063636 | -122.390170565448 | (37.7261073063636, -122.390170565448) | |||
| 176268 | 176268 | 200103 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014982.2186 | 2092417.8102 | 37.72622278535071 | -122.390388836652 | (37.7262227853507, -122.390388836652) | |||
| 16799 | 16799 | 57069 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | |
| 52001 | 52001 | 200104 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014963.9454 | 2092431.3459 | 37.726258938018 | -122.39045295200899 | (37.726258938018, -122.390452952009) | |||
| 64448 | 64448 | 200105 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1528 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014949.7328 | 2092444.2049 | 37.7262934578304 | -122.39050298275801 | (37.7262934578304, -122.390502982758) | |||
| 28685 | 28685 | 99380 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 89315 | 89315 | 99393 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 89862 | 89862 | 99399 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 108977 | 108977 | 99385 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 110341 | 110341 | 99386 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 112798 | 112798 | 99381 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 113044 | 113044 | 99398 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 114337 | 114337 | 99387 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 115661 | 115661 | 99395 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 142142 | 142142 | 99394 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 148905 | 148905 | 99379 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 57630 | 57630 | 191251 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.39071814833599 | (37.7618193498029, -122.390718148336) | |||
| 28130 | 28130 | 191253 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6015148.44265 | 2105367.15882 | 37.7617882296504 | -122.39071873558599 | (37.7617882296504, -122.390718735586) | |||
| 36838 | 36838 | 191250 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015147.38841 | 2105382.23529 | 37.7618295678896 | -122.390723435432 | (37.7618295678896, -122.390723435432) | |||
| 56239 | 56239 | 191252 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 654 Minnesota St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6015147.22099 | 2105373.94992 | 37.761806808764796 | -122.390723435452 | (37.7618068087648, -122.390723435452) | |||
| 166627 | 166627 | 191298 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6015180.160630001 | 2107302.1939 | 37.7671031752919 | -122.39074426644899 | (37.7671031752919, -122.390744266449) | |||
| 23772 | 23772 | 191299 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015177.82762 | 2107330.32237 | 37.767180280481895 | -122.390754301979 | (37.7671802804819, -122.390754301979) | |||
| 180507 | 180507 | 191300 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015176.682999999 | 2107358.12451 | 37.767256555574 | -122.39076020421699 | (37.767256555574, -122.390760204217) | |||
| 134947 | 134947 | 191301 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015174.991090001 | 2107387.31726 | 37.7673366186106 | -122.39076809667499 | (37.7673366186106, -122.390768096675) | |||
| 82821 | 82821 | 102559 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 106668 | 106668 | 102554 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 121400 | 121400 | 102560 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 127963 | 127963 | 102555 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 128253 | 128253 | 102557 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 144570 | 144570 | 102556 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 145327 | 145327 | 102558 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 75888 | 75888 | 191302 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015174.0673 | 2107416.87345 | 37.767417722189705 | -122.390773357708 | (37.7674177221897, -122.390773357708) | |||
| 31053 | 31053 | 191303 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015172.36775 | 2107445.68773 | 37.7674967456035 | -122.39078125017099 | (37.7674967456035, -122.390781250171) | |||
| 164417 | 164417 | 191304 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015169.51274 | 2107473.76779 | 37.767573688899496 | -122.390793087953 | (37.7675736888995, -122.390793087953) | |||
| 51582 | 51582 | 191305 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015162.58842 | 2107628.3532 | 37.767997762404 | -122.390827843133 | (37.767997762404, -122.390827843133) | |||
| 137511 | 137511 | 191306 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015160.53731 | 2107657.60104 | 37.7680779567607 | -122.39083698203899 | (37.7680779567607, -122.390836982039) | |||
| 67462 | 67462 | 191307 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015158.98774 | 2107685.52339 | 37.76815453943829 | -122.390844293528 | (37.7681545394383, -122.390844293528) | |||
| 56989 | 56989 | 191308 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015156.6298 | 2107712.6724 | 37.768228953839895 | -122.390854347073 | (37.7682289538399, -122.390854347073) | |||
| 182608 | 182608 | 191309 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015155.3814900005 | 2107742.43002 | 37.768310592479 | -122.390860744836 | (37.768310592479, -122.390860744836) | |||
| 87060 | 87060 | 102564 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 92389 | 92389 | 102561 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 101687 | 101687 | 102565 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 111006 | 111006 | 102566 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 120116 | 120116 | 102568 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 127314 | 127314 | 102562 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 127598 | 127598 | 102563 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 144534 | 144534 | 102567 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||
| 131490 | 131490 | 191310 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015152.46863 | 2107768.27489 | 37.7683813952045 | -122.390872626697 | (37.7683813952045, -122.390872626697) | |||
| 41440 | 41440 | 191311 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015151.76995 | 2107799.07376 | 37.76846592338129 | -122.39087719613501 | (37.7684659233813, -122.390877196135) | |||
| 34951 | 34951 | 191312 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601 04th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015149.38015 | 2107824.64473 | 37.768536003056504 | -122.390887249657 | (37.7685360030565, -122.390887249657) | |||
| 149816 | 149816 | 191313 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015141.50158 | 2107991.42305 | 37.76899350256671 | -122.39092615881799 | (37.7689935025667, -122.390926158818) | |||
| 183981 | 183981 | 191314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015140.28305 | 2108016.70866 | 37.7690628636861 | -122.390932141124 | (37.7690628636861, -122.390932141124) | |||
| 33465 | 33465 | 191315 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015139.91127 | 2108041.11608 | 37.7691298604716 | -122.390935133173 | (37.7691298604716, -122.390935133173) | |||
| 76125 | 76125 | 191361 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015122.97696 | 2107297.48765 | 37.767087080134395 | -122.39094172878401 | (37.7670870801344, -122.390941728784) | |||
| 56027 | 56027 | 191316 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015137.82836 | 2108066.41916 | 37.7691992215952 | -122.39094410658899 | (37.7691992215952, -122.390944106589) | |||
| 168923 | 168923 | 191360 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015121.963930001 | 2107325.3788400004 | 37.767163607031705 | -122.390947182278 | (37.7671636070317, -122.390947182278) | |||
| 179818 | 179818 | 191317 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015134.8576 | 2108090.59219 | 37.769265430583296 | -122.39095607208401 | (37.7692654305833, -122.390956072084) | |||
| 170215 | 170215 | 191359 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015119.80828 | 2107355.2560099997 | 37.7672455235927 | -122.39095672679 | (37.7672455235927, -122.39095672679) | |||
| 188877 | 188877 | 191318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015134.48609 | 2108114.99928 | 37.7693324264746 | -122.39095906320499 | (37.7693324264746, -122.390959063205) | |||
| 60379 | 60379 | 191358 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015118.78707 | 2107382.7546599996 | 37.7673209722044 | -122.390962181167 | (37.7673209722044, -122.390962181167) | |||
| 68001 | 68001 | 191319 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015133.57873 | 2108141.42692 | 37.7694049406179 | -122.390964049067 | (37.7694049406179, -122.390964049067) | |||
| 37197 | 37197 | 191320 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1505 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015132.04881 | 2108165.57051 | 37.769471148715894 | -122.39097102870701 | (37.7694711487159, -122.390971028707) | |||
| 71641 | 71641 | 191357 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015116.28501 | 2107414.99409 | 37.767409355789 | -122.390973089032 | (37.767409355789, -122.390973089032) | |||
| 43823 | 43823 | 191356 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015114.10558 | 2107443.69394 | 37.7674880383618 | -122.39098263356199 | (37.7674880383618, -122.390982633562) | |||
| 75814 | 75814 | 191355 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1780 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015114.26665 | 2107471.16871 | 37.7675634870034 | -122.39098399692699 | (37.7675634870034, -122.390983996927) | |||
| 172420 | 172420 | 200111 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1552 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014807.6076 | 2092549.7837 | 37.726575470666106 | -122.39100168241998 | (37.7265754706661, -122.39100168242) | |||
| 69127 | 69127 | 191321 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015124.1638400005 | 2108316.2837099996 | 37.769884536484206 | -122.391008838006 | (37.7698845364842, -122.391008838006) | |||
| 76702 | 76702 | 191322 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015122.40685 | 2108342.01647 | 37.769955095485 | -122.391016714258 | (37.769955095485, -122.391016714258) | |||
| 178278 | 178278 | 191323 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015122.4628099995 | 2108363.5556 | 37.7700142403001 | -122.391018026356 | (37.7700142403001, -122.391018026356) | |||
| 71788 | 71788 | 191354 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015105.755890001 | 2107627.1199 | 37.7679912225533 | -122.39102433602899 | (37.7679912225533, -122.391024336029) | |||
| 135315 | 135315 | 191324 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015118.87024 | 2108392.34888 | 37.770093100956004 | -122.391032465874 | (37.770093100956, -122.391032465874) | |||
| 37307 | 37307 | 191325 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015118.6002 | 2108416.5397200002 | 37.7701595086914 | -122.391035090994 | (37.7701595086914, -122.391035090994) | |||
| 170159 | 170159 | 191353 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015102.637619999 | 2107654.6219599997 | 37.768066564148505 | -122.39103704433501 | (37.7680665641485, -122.391037044335) | |||
| 58900 | 58900 | 191352 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015101.55033 | 2107682.6315900004 | 37.768143412117894 | -122.391042763138 | (37.7681434121179, -122.391042763138) | |||
| 55302 | 55302 | 191326 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015116.04644 | 2108440.3990700003 | 37.7702248795025 | -122.39104559238501 | (37.7702248795025, -122.391045592385) | |||
| 172600 | 172600 | 191327 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015115.08625 | 2108468.00525 | 37.770300626710295 | -122.391050843517 | (37.7703006267103, -122.391050843517) | |||
| 148210 | 148210 | 191351 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015099.52293 | 2107709.56267 | 37.7682172464566 | -122.391051658332 | (37.7682172464566, -122.391051658332) | |||
| 131229 | 131229 | 200112 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1560 Yosemite Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6014792.7183 | 2092559.9355 | 37.726602519263004 | -122.391053863847 | (37.726602519263, -122.391053863847) | |||
| 164130 | 164130 | 191350 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015098.296519999 | 2107739.7702099998 | 37.7683001216821 | -122.39105801201099 | (37.7683001216821, -122.391058012011) | |||
| 58087 | 58087 | 191328 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015112.5325 | 2108491.8646 | 37.770365997518894 | -122.391061344907 | (37.7703659975189, -122.391061344907) | |||
| 181554 | 181554 | 191329 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1507 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015112.65717 | 2108516.8034 | 37.7704344808868 | -122.39106265703501 | (37.7704344808868, -122.391062657035) | |||
| 73474 | 73474 | 191349 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015096.10016 | 2107767.4364 | 37.7683759650927 | -122.39106754304899 | (37.7683759650927, -122.391067543049) | |||
| 68569 | 68569 | 191348 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015095.009190001 | 2107795.26302 | 37.7684523103469 | -122.39107326184299 | (37.7684523103469, -122.391073261843) | |||
| 156882 | 156882 | 191347 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1750 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6015093.18746 | 2107823.28717 | 37.768529157422705 | -122.391081522115 | (37.7685291574227, -122.391081522115) | |||
| 83610 | 83610 | 105034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
| 100937 | 100937 | 105033 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
| 102467 | 102467 | 105032 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) |
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");