trees
725 rows where qCaretaker_id = 6 sorted by SiteOrder
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46985 | 83041 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.7408907812923 | -122.377824564564 | (37.7408907812923, -122.377824564564) | 10 | 3 | 8 | 58 | 1 | |||
| 54162 | 3576 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 63391 | 28043 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012024.04433 | 2120930.34171 | 37.8043472614676 | -122.402619322118 | (37.8043472614676, -122.402619322118) | 3 | 1 | 10 | 28860 | 6 | ||
| 68825 | 25847 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012388.57301 | 2120483.28101 | 37.8031400863027 | -122.401326396519 | (37.8031400863027, -122.401326396519) | 3 | 1 | 10 | 28860 | 6 | ||
| 72591 | 25797 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 800X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 08/30/1996 12:00:00 AM | 36 | 10 | 6012870.34401 | 2119824.42701 | 37.8013578993624 | -122.399612917904 | (37.8013578993624, -122.399612917904) | 3 | 1 | 10 | 28860 | 6 | ||
| 86514 | 25815 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 93693 | 27838 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 112597 | 27560 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 118943 | 27974 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 132193 | 28031 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | 4 | 2 | 10 | 28860 | 6 | ||
| 133130 | 27812 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 133300 | 25625 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015102.11501 | 2116685.10401 | 37.79286220301 | -122.391670317555 | (37.79286220301, -122.391670317555) | 12 | 2 | 9 | 28855 | 6 | ||
| 135463 | 28055 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1800 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6008269.10023 | 2122669.55539 | 37.808912348093 | -122.41573688061 | (37.808912348093, -122.41573688061) | 3 | 1 | 10 | 308 | 23 | ||
| 146265 | 27698 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 801X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 24 | 10 | 6012632.1664062 | 2120088.9827256 | 37.8020710261606 | -122.400455716884 | (37.8020710261606, -122.400455716884) | 3 | 1 | 10 | 28860 | 6 | |||
| 149101 | 27917 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015864.05001 | 2112323.11701 | 37.7809274421657 | -122.38872931872 | (37.7809274421657, -122.38872931872) | 6 | 2 | 9 | 28856 | 20 | ||
| 159836 | 25658 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 174840 | 27881 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 11 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015990.277 | 2113394.1 | 37.7838751159548 | -122.388367405327 | (37.7838751159548, -122.388367405327) | 6 | 2 | 9 | 28856 | 6 | |||
| 186329 | 27794 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 199X The Embarcadero | 11 | Median : Cutout | Tree | Port 6 | 12 | 6014015.4653372 | 2118064.3876984 | 37.7965890133894 | -122.395526881953 | (37.7965890133894, -122.395526881953) | 3 | 1 | 10 | 28860 | 6 | ||||
| 80049 | 3674 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 110 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:22:00 AM | 3 | 3X3 | 6016998.30504 | 2099015.89853 | 37.7444514490906 | -122.383878484902 | (37.7444514490906, -122.383878484902) | 10 | 3 | 8 | 58 | 1 | ||
| 31430 | 3675 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 111 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6016978.81066 | 2099030.12804 | 37.7444894427423 | -122.383946883753 | (37.7444894427423, -122.383946883753) | 10 | 3 | 8 | 58 | 1 | ||
| 141397 | 3676 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 112 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:24:00 AM | 3 | 3X3 | 6016964.48751 | 2099042.50937 | 37.7445226475172 | -122.383997272761 | (37.7445226475172, -122.383997272761) | 10 | 3 | 8 | 58 | 1 | ||
| 152067 | 3677 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 113 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3x3 | 6016945.8178 | 2099054.70637 | 37.7445551058345 | -122.384062678658 | (37.7445551058345, -122.384062678658) | 10 | 3 | 8 | 58 | 1 | ||
| 34219 | 3678 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 114 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016900.55326 | 2099090.71493 | 37.7446514753884 | -122.384221703094 | (37.7446514753884, -122.384221703094) | 10 | 3 | 8 | 58 | 1 | |||
| 50873 | 3679 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 115 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6016884.1224 | 2099103.28613 | 37.7446850848489 | -122.384279393677 | (37.7446850848489, -122.384279393677) | 10 | 3 | 8 | 58 | 1 | |||
| 81887 | 3680 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 116 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016866.69606 | 2099115.15257 | 37.7447167041098 | -122.384340477447 | (37.7447167041098, -122.384340477447) | 10 | 3 | 8 | 58 | 1 | |||
| 46442 | 3681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 117 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:27:00 PM | 3 | 3X3 | 6016866.95731 | 2099120.49255 | 37.7447313810499 | -122.384339945926 | (37.7447313810499, -122.384339945926) | 10 | 3 | 8 | 58 | 1 | ||
| 66260 | 3682 | Permitted Site 7 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 118 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 182850 | 3683 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 119 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016838.58943 | 2099135.269 | 37.7447703855426 | -122.384439066524 | (37.7447703855426, -122.384439066524) | 10 | 3 | 8 | 58 | 1 | |||
| 18663 | 83040 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.377888212277 | (37.740925933998, -122.377888212277) | 10 | 3 | 8 | 58 | 1 | ||||
| 20863 | 25816 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 29819 | 27975 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 32103 | 27561 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/12/2003 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 45704 | 27839 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 47010 | 25626 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015143.78201 | 2116618.69801 | 37.7926821803134 | -122.391521501856 | (37.7926821803134, -122.391521501856) | 12 | 2 | 9 | 28855 | 6 | ||
| 50297 | 25895 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 58849 | 27813 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 60088 | 25848 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012397.68801 | 2120467.65601 | 37.8030976923846 | -122.401293754953 | (37.8030976923846, -122.401293754953) | 3 | 1 | 10 | 28860 | 6 | ||
| 62632 | 3577 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 86437 | 28032 | Permitted Site 7 | Phoenix canariensis :: Canary Island Date Palm 160 | 100 The Embarcadero | 12 | Median : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | 4 | 2 | 10 | 28860 | 6 | ||
| 86611 | 28044 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1400 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012052.65409 | 2120901.81041 | 37.8042705187194 | -122.402518307585 | (37.8042705187194, -122.402518307585) | 3 | 1 | 10 | 28860 | 6 | ||
| 101706 | 27918 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015851.02901 | 2112300.33101 | 37.7808641552493 | -122.388772773994 | (37.7808641552493, -122.388772773994) | 6 | 2 | 9 | 28856 | 20 | ||
| 114342 | 25659 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 144495 | 27882 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015988.714 | 2113369.621 | 37.7838078155273 | -122.388371103678 | (37.7838078155273, -122.388371103678) | 6 | 2 | 9 | 28856 | 6 | |||
| 172959 | 25836 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1100X The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.9996834 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | 3 | 1 | 10 | 28860 | 6 | ||
| 188165 | 28015 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 12 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014236.44501 | 2117630.19201 | 37.7954091029766 | -122.39473181516 | (37.7954091029766, -122.39473181516) | 4 | 2 | 10 | 28860 | 6 | ||
| 41537 | 3684 | DPW Maintained 1 | Eucalyptus sideroxylon :: Red Ironbark 127 | 100X Cargo Way | 120 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 18 | 3X3 | 6016817.82171 | 2099151.76391 | 37.7448145287778 | -122.384512026728 | (37.7448145287778, -122.384512026728) | 10 | 3 | 8 | 58 | 1 | |||
| 105726 | 3685 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout | Tree | Port 6 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767872 | (37.744924332395, -122.38470767872) | 10 | 3 | 8 | 58 | 1 | |||
| 3206 | 83039 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 6018611.72965 | 2097767.00037 | 37.7411112833697 | -122.378212851336 | (37.7411112833697, -122.378212851336) | 10 | 3 | 8 | 58 | 1 | ||||
| 9326 | 27814 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 9595 | 25849 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415 | 37.8022785256437 | -122.400100244504 | (37.8022785256437, -122.400100244504) | 3 | 1 | 10 | 28860 | 6 | ||
| 30201 | 27919 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015840.17801 | 2112278.62901 | 37.7808039650097 | -122.388808797741 | (37.7808039650097, -122.388808797741) | 6 | 2 | 9 | 28856 | 20 | ||
| 44615 | 27840 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 900X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715162 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | 3 | 1 | 10 | 28860 | 6 | |||
| 65056 | 28016 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014245.12601 | 2117603.06501 | 37.7953351012525 | -122.394699876607 | (37.7953351012525, -122.394699876607) | 4 | 2 | 10 | 28860 | 6 | ||
| 71164 | 25660 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 74837 | 27883 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015986.631 | 2113340.455 | 37.7837276168383 | -122.388376273801 | (37.7837276168383, -122.388376273801) | 6 | 2 | 9 | 28856 | 6 | |||
| 87349 | 25817 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 127101 | 27562 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 127393 | 3578 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 100X Cargo Way | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 135201 | 25627 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015154.19801 | 2116593.95801 | 37.7926148281307 | -122.391483731415 | (37.7926148281307, -122.391483731415) | 12 | 2 | 9 | 28855 | 6 | ||
| 154189 | 27976 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 186670 | 25896 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 13 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 23091 | 27563 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 6 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 60577 | 25818 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 65902 | 28017 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014258.14701 | 2117577.02301 | 37.7952643199629 | -122.394652996927 | (37.7952643199629, -122.394652996927) | 4 | 2 | 10 | 28860 | 6 | ||
| 78548 | 25897 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 87271 | 27884 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015985.589 | 2013289.413 | 37.5090039879895 | -122.381420145897 | (37.5090039879895, -122.381420145897) | 28590 | |||||||
| 90066 | 25661 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 126181 | 27815 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 130760 | 27977 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 176233 | 25850 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415 | 37.8022785256437 | -122.400100244504 | (37.8022785256437, -122.400100244504) | 3 | 1 | 10 | 28860 | 6 | ||
| 188675 | 27920 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 14 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015829.32701 | 2112255.84301 | 37.7807407983373 | -122.388844745731 | (37.7807407983373, -122.388844745731) | 6 | 2 | 9 | 28856 | 20 | ||
| 10036 | 83037 | DPW Maintained 1 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 5 | 6018575.81097 | 2097793.86484 | 37.7411830681528 | -122.378338911137 | (37.7411830681528, -122.378338911137) | 10 | 3 | 8 | 58 | 1 | ||||
| 14274 | 3580 | Permitted Site 7 | Quercus ilex :: Holly Oak 305 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | |||
| 66166 | 27885 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015984.548 | 2113289.413 | 37.7835873515787 | -122.388379916552 | (37.7835873515787, -122.388379916552) | 6 | 2 | 9 | 28856 | 6 | |||
| 88662 | 25662 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 94114 | 27564 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 125507 | 25851 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415 | 37.8022785256437 | -122.400100244504 | (37.8022785256437, -122.400100244504) | 3 | 1 | 10 | 28860 | 6 | ||
| 150361 | 27978 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 153960 | 28018 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014268.99801 | 2117554.23701 | 37.7952023582244 | -122.394613854051 | (37.7952023582244, -122.394613854051) | 4 | 2 | 10 | 28860 | 6 | ||
| 169275 | 27816 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 170482 | 25819 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 176402 | 27921 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015810.88101 | 2112236.31101 | 37.7806861454365 | -122.388907195889 | (37.7806861454365, -122.388907195889) | 6 | 2 | 9 | 28856 | 20 | ||
| 191772 | 25898 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 15 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 12701 | 3581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 10 | 3 | 8 | 58 | 1 | ||
| 37127 | 25820 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 40854 | 27817 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 52783 | 27922 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015798.94501 | 2112218.95001 | 37.7806378144268 | -122.388947276171 | (37.7806378144268, -122.388947276171) | 6 | 2 | 9 | 28856 | 20 | ||
| 60041 | 27886 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 280 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 01/31/2001 12:00:00 AM | 12 | 6015979.339 | 2113269.621 | 37.7835327185594 | -122.388396555982 | (37.7835327185594, -122.388396555982) | 6 | 2 | 9 | 28856 | 6 | |||
| 113062 | 25663 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 450X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | 3 | 1 | 10 | 28860 | 6 | ||
| 113760 | 28019 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014278.76301 | 2117533.62001 | 37.7951462916621 | -122.394578620953 | (37.7951462916621, -122.394578620953) | 4 | 2 | 10 | 28860 | 6 | ||
| 125130 | 27979 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 144300 | 27565 | Permitted Site 7 | Melaleuca quinquenervia :: Cajeput 10 | 1299X Illinois St | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/10/1999 12:00:00 AM | 12 | 3X3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | 10 | 3 | 8 | 28856 | 29 | ||
| 145219 | 25899 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 500X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213274 | 37.7992817461076 | -122.397567846492 | (37.7992817461076, -122.397567846492) | 3 | 1 | 10 | 28860 | 6 | ||
| 169962 | 83036 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | 10 | 3 | 8 | 58 | 1 | |||
| 183897 | 25852 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 800X The Embarcadero | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415 | 37.8022785256437 | -122.400100244504 | (37.8022785256437, -122.400100244504) | 3 | 1 | 10 | 28860 | 6 | ||
| 34314 | 25821 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1300X The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | 3 | 1 | 10 | 308 | 23 | ||
| 69243 | 27923 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015780.49901 | 2112201.58901 | 37.7805891225502 | -122.389009877789 | (37.7805891225502, -122.389009877789) | 6 | 2 | 9 | 28856 | 20 | ||
| 98309 | 27818 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 350X The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.7946449 | 2118604.8635638 | 37.7980602547356 | -122.396359500707 | (37.7980602547356, -122.396359500707) | 3 | 1 | 10 | 28860 | 6 | ||
| 132807 | 27980 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 300 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 12 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | 3 | 1 | 10 | 28860 | 6 | ||
| 148304 | 28020 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 02/05/2001 12:00:00 AM | 6 | 3X3 | 6014303.72001 | 2117502.15301 | 37.795061278092 | -122.394490060779 | (37.795061278092, -122.394490060779) | 4 | 2 | 10 | 28860 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );