trees
548 rows where qCaretaker_id = 1 and qSpecies_id = 53 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
193625 | 255507 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | ||||
193568 | 26953 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376 | (37.7859892824562, -122.43461540376) | 13 | 9 | 11 | 29490 | 27 | |||
193344 | 13225 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2265 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001602.67751 | 2119341.9386 | 37.799398588794 | -122.438569375951 | (37.799398588794, -122.438569375951) | 13 | 9 | 1 | 57 | 17 | |||
193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
192852 | 16949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 625 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003989.24409 | 2110039.43116 | 37.7739917148646 | -122.429647190447 | (37.7739917148646, -122.429647190447) | 7 | 9 | 11 | 29492 | 10 | |||
192632 | 5633 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1256 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005118.39805 | 2100997.74937 | 37.749229268656 | -122.425097781596 | (37.749229268656, -122.425097781596) | 2 | 4 | 5 | 28862 | 22 | |||
191412 | 2431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004657.78302 | 2110211.29448 | 37.7745014417711 | -122.427346845616 | (37.7745014417711, -122.427346845616) | 7 | 9 | 11 | 28852 | 10 | |||
191336 | 505 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.407649581645 | (37.7529538159215, -122.407649581645) | 2 | 4 | 7 | 28859 | 19 | |||
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
191157 | 16897 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 385 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005198.99692 | 2110159.80887 | 37.7743906686767 | -122.425471016021 | (37.7743906686767, -122.425471016021) | 7 | 9 | 11 | 28852 | 10 | |||
191064 | 21654 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1698 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004474.7477956 | 2114689.3781886 | 37.7867867977452 | -122.428299224496 | (37.7867867977452, -122.428299224496) | 13 | 9 | 11 | 28858 | 27 | |||
190628 | 7233 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1045 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003367.24511 | 2111893.72513 | 37.7790479074603 | -122.431931222001 | (37.7790479074603, -122.431931222001) | 15 | 9 | 11 | 29490 | 41 | |||
190566 | 21751 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
190383 | 17316 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
190135 | 15260 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007445.07805 | 2110006.65891 | 37.7740968045009 | -122.417690522857 | (37.7740968045009, -122.417690522857) | 8 | 2 | 9 | 28853 | 19 | |||
189695 | 21726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1942 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6003284.347 | 2114523.85502 | 37.7862648839776 | -122.432405902047 | (37.7862648839776, -122.432405902047) | 13 | 9 | 11 | 29490 | 27 | |||
189650 | 15279 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1551 MISSION ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007345 | 2109715.7 | 37.7732922684508 | -122.418016080506 | (37.7732922684508, -122.418016080506) | 8 | 2 | 9 | 28853 | 19 | |||
188563 | 10618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | |||
188552 | 17045 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
188021 | 6788 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
187641 | 17308 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 70 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006766.44916 | 2109389.93705 | 37.7723652222089 | -122.419994248937 | (37.7723652222089, -122.419994248937) | 8 | 2 | 9 | 28853 | 19 | |||
186524 | 112825 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 101X COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6011274 | 2118052 | 37.7964021326886 | -122.405012137355 | (37.7964021326886, -122.405012137355) | 3 | 1 | 10 | 308 | 4 | |||
186502 | 18393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
186277 | 13199 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
186181 | 251369 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
185861 | 18445 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | 10 | 4 | 7 | 28859 | 19 | |||
185238 | 15310 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1650 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006887.5781181 | 2109042.9003069 | 37.7714191656036 | -122.41955062575 | (37.7714191656036, -122.41955062575) | 8 | 2 | 9 | 28853 | 19 | |||
184950 | 18016 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2714 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000941.6382972 | 2114893.0059573 | 37.7871453575959 | -122.440537532879 | (37.7871453575959, -122.440537532879) | 13 | 6 | 1 | 29490 | 27 | |||
184916 | 20245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1823 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 12 | 3X3 | 6002519.5885419 | 2114476.0123893 | 37.7860901257054 | -122.435048341611 | (37.7860901257054, -122.435048341611) | 13 | 9 | 1 | 29490 | 27 | ||
184850 | 2719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003092.7695 | 2114646.14799 | 37.786589804405 | -122.433077450713 | (37.786589804405, -122.433077450713) | 13 | 9 | 11 | 29490 | 27 | |||
184329 | 173906 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6005854.79213 | 2118988.36383 | 37.7986687249765 | -122.423830387644 | (37.7986687249765, -122.423830387644) | 13 | 9 | 1 | 28858 | 32 | |||||
184105 | 112108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
184073 | 8768 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
183127 | 7232 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1045 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003365.392 | 2111902.08022 | 37.7790707434033 | -122.431938229416 | (37.7790707434033, -122.431938229416) | 15 | 9 | 11 | 29490 | 41 | |||
183120 | 17367 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
183113 | 18328 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | 8 | 4 | 8 | 28853 | 19 | |||
183075 | 17003 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 985 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 6002297.8184 | 2109825.1269 | 37.7733073694664 | -122.435482776108 | (37.7733073694664, -122.435482776108) | 15 | 5 | 11 | 29492 | 9 | |||
183025 | 26841 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | Permit Number 779930 | 6006975.88726 | 2110943.04151 | 37.7766414730488 | -122.419379980819 | (37.7766414730488, -122.419379980819) | 7 | 9 | 9 | 28852 | 36 | ||
182974 | 16988 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 879 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002804.94816 | 2109899.79468 | 37.773541177823 | -122.433733884114 | (37.773541177823, -122.433733884114) | 15 | 5 | 11 | 29492 | 9 | |||
182795 | 26424 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005277.15037 | 2111634.16402 | 37.7784433040001 | -122.425305605903 | (37.7784433040001, -122.425305605903) | 7 | 9 | 11 | 28852 | 10 | |||
182329 | 21698 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | |||
182166 | 11086 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
181935 | 17311 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 77 Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006769.4589066 | 2109244.8738273 | 37.7719670827617 | -122.419973541884 | (37.7719670827617, -122.419973541884) | 8 | 2 | 9 | 28853 | 19 | |||
181893 | 7246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6003087.664 | 2114207.65389 | 37.7853855210138 | -122.433063773672 | (37.7853855210138, -122.433063773672) | 13 | 9 | 11 | 29490 | 13 | |||
181818 | 13305 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1377X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000417.28547 | 2109565.1947 | 37.7724866778901 | -122.441969118639 | (37.7724866778901, -122.441969118639) | 15 | 5 | 11 | 29492 | 9 | |||
181736 | 5595 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1100 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3x3 | 6005095.5235026 | 2101950.1341989 | 37.7518430048639 | -122.425244643333 | (37.7518430048639, -122.425244643333) | 2 | 4 | 5 | 28862 | 22 | |||
181230 | 7271 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003011.13827 | 2114398.62455 | 37.7859055370085 | -122.433342180608 | (37.7859055370085, -122.433342180608) | 13 | 9 | 11 | 29490 | 13 | |||
180877 | 10578 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005X HARRISON ST | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x7 | 6011386 | 2111037 | 37.7771468605476 | -122.404130641378 | (37.7771468605476, -122.404130641378) | 14 | 2 | 9 | 28853 | 34 | |||
179910 | 27490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2107 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005886.29279 | 2117665.93165 | 37.7950394389183 | -122.42362731207 | (37.7950394389183, -122.42362731207) | 13 | 9 | 1 | 28858 | 27 | |||
179093 | 21930 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2347 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x5 | 6015939.39473 | 2104425.48438 | 37.7592464441674 | -122.38791741203 | (37.7592464441674, -122.38791741203) | 10 | 3 | 8 | 28856 | 29 | |||
179087 | 105657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
178363 | 5655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1332 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005148.4988519 | 2100582.0357256 | 37.7480895150856 | -122.424964119184 | (37.7480895150856, -122.424964119184) | 2 | 4 | 5 | 63 | 22 | |||
177980 | 27711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | |||
177573 | 4627 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 420 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010403.3977 | 2118996.04309 | 37.7989455393885 | -122.408091232197 | (37.7989455393885, -122.408091232197) | 3 | 1 | 10 | 308 | 23 | |||
177482 | 255340 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6003626.50122 | 2114526.01983 | 37.7862902235864 | -122.431222292272 | (37.7862902235864, -122.431222292272) | 13 | 9 | 11 | 29490 | 13 | |||||
177292 | 16729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
176898 | 8765 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
176749 | 6380 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
175894 | 13036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/04/2015 08:35:00 AM | 3 | 3X3 | 6010019.32094 | 2120615.54911 | 37.80337079145 | -122.409534633266 | (37.80337079145, -122.409534633266) | 3 | 1 | 10 | 308 | 23 | ||
175687 | 17314 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 86 OTIS ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006711 | 2109331 | 37.7722002709716 | -122.420181869556 | (37.7722002709716, -122.420181869556) | 8 | 2 | 9 | 28853 | 19 | |||
175601 | 7197 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
175319 | 11028 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1449 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6007474.68946 | 2117365.61582 | 37.7943043774737 | -122.418109907661 | (37.7943043774737, -122.418109907661) | 5 | 1 | 10 | 28858 | 32 | |||
174162 | 16730 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 19X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003888.91549 | 2113509.70556 | 37.7835145469728 | -122.430241873385 | (37.7835145469728, -122.430241873385) | 7 | 9 | 11 | 29490 | 41 | |||
174129 | 16872 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 259 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6005773.57352 | 2110239.8238 | 37.7746428175577 | -122.423489134945 | (37.7746428175577, -122.423489134945) | 7 | 9 | 11 | 28852 | 10 | |||
173835 | 17323 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
173445 | 15262 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1500 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6007448.14843 | 2109975.86864 | 37.774012434525 | -122.417677719037 | (37.774012434525, -122.417677719037) | 8 | 2 | 9 | 28853 | 19 | |||
173262 | 16934 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 534 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004202.21217 | 2110156.57626 | 37.7743254232669 | -122.428918851232 | (37.7743254232669, -122.428918851232) | 7 | 9 | 11 | 28852 | 10 | |||
173250 | 11082 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1849 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007286.9943087 | 2118635.1241552 | 37.7977795644032 | -122.418849434729 | (37.7977795644032, -122.418849434729) | 5 | 1 | 10 | 28858 | 32 | |||
172889 | 7892 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1187 Franklin St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006000.38049 | 2113895.86172 | 37.7846942050769 | -122.422964467171 | (37.7846942050769, -122.422964467171) | 13 | 9 | 11 | 28858 | 41 | |||
172812 | 18468 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.406456244122 | (37.7528257474783, -122.406456244122) | 10 | 4 | 7 | 28859 | 19 | |||
172277 | 10647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 913 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6003471.55966 | 2110689.4075 | 37.775747062973 | -122.431484357932 | (37.775747062973, -122.431484357932) | 15 | 9 | 11 | 29492 | 10 | ||
171543 | 18697 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 4 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
171101 | 17693 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1095X Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6002343.2153394 | 2112268.6379219 | 37.7800192180629 | -122.435500577793 | (37.7800192180629, -122.435500577793) | 15 | 5 | 11 | 29490 | 41 | |||
170902 | 18297 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 35X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010274.737783 | 2108072.9305947 | 37.7689460585554 | -122.407765812226 | (37.7689460585554, -122.407765812226) | 8 | 4 | 8 | 28853 | 19 | |||
170847 | 4631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 430 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010350.91598 | 2119042.69079 | 37.799070683936 | -122.408276129064 | (37.799070683936, -122.408276129064) | 3 | 1 | 10 | 308 | 23 | |||
169890 | 21652 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1697 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004490.7268551 | 2114641.118768 | 37.7866551936091 | -122.428240500008 | (37.7866551936091, -122.428240500008) | 13 | 9 | 11 | 28858 | 13 | |||
169697 | 117565 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
169622 | 6721 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
169047 | 9070 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5600 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1990 12:00:00 AM | 12 | 3X3 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | 11 | 6 | 2 | 55 | 26 | ||
169006 | 17011 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1001 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002208.6674 | 2109818.85859 | 37.7732850945599 | -122.43579071263 | (37.7732850945599, -122.43579071263) | 15 | 5 | 11 | 29492 | 9 | |||
167163 | 17304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 51X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006870.5020453 | 2109341.6908091 | 37.7722386113234 | -122.419630895813 | (37.7722386113234, -122.419630895813) | 8 | 2 | 9 | 28853 | 19 | |||
166466 | 11087 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1896 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4x4 | 6007314.6733074 | 2118798.6130291 | 37.7982300223497 | -122.418765257989 | (37.7982300223497, -122.418765257989) | 5 | 1 | 10 | 28858 | 32 | |||
166051 | 18510 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 605X Powell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6010109.02253 | 2115823.8794949 | 37.7902190622309 | -122.408885944172 | (37.7902190622309, -122.408885944172) | 5 | 1 | 10 | 28857 | 21 | |||
165633 | 23541 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6005750.94301 | 2119762.60418 | 37.8007887287045 | -122.42424483346 | (37.8007887287045, -122.42424483346) | 13 | 9 | 1 | 28858 | 32 | |||
164782 | 26423 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005252.46633 | 2111627.39845 | 37.7784233328254 | -122.425390515771 | (37.7784233328254, -122.425390515771) | 7 | 9 | 11 | 28852 | 10 | |||
164308 | 18035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2807 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000503.4629009 | 2114781.5023211 | 37.7868142369045 | -122.442045513134 | (37.7868142369045, -122.442045513134) | 13 | 6 | 1 | 29490 | 27 | |||
163969 | 18370 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 635 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4x4 | 6010438.67568 | 2105328.38433 | 37.7614193346753 | -122.407005286068 | (37.7614193346753, -122.407005286068) | 10 | 4 | 8 | 28859 | 19 | |||
163968 | 16919 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 13x6 | 6004493.27484 | 2110185.04209 | 37.7744200538695 | -122.427914040239 | (37.7744200538695, -122.427914040239) | 7 | 9 | 11 | 28852 | 10 | |||
163768 | 9696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005964.80411 | 2111186.62637 | 37.7772532999259 | -122.422894934036 | (37.7772532999259, -122.422894934036) | 7 | 9 | 11 | 28852 | 10 | |||
163000 | 20243 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
162852 | 19490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 10X Saroyan Pl | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6010944.42859 | 2118456.69114 | 37.7974948878134 | -122.406181056735 | (37.7974948878134, -122.406181056735) | 3 | 1 | 10 | 308 | 4 | |||
162520 | 10628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 805 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 6 | 3X4 | 6003942.23141 | 2110755.32974 | 37.775954734286 | -122.429860889744 | (37.775954734286, -122.429860889744) | 7 | 9 | 11 | 29492 | 10 | ||
162441 | 26666 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1015 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5992306.14573 | 2114757.6166 | 37.7862781034857 | -122.470404314824 | (37.7862781034857, -122.470404314824) | 11 | 6 | 2 | 54 | 11 | |||
162339 | 10147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 940 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x3 | 6005660.7422371 | 2103489.3240903 | 37.7561011788947 | -122.423399446987 | (37.7561011788947, -122.423399446987) | 2 | 4 | 5 | 28859 | 19 | |||
161897 | 253634 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830 Oak St | 1 | Sidewalk: Property side : Cutout | tree | DPW 1 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.432999691851 | (37.7737452502421, -122.432999691851) | 15 | 5 | 11 | 29492 | 10 | |||||
161646 | 8766 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
161591 | 21959 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2525 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x6 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | 10 | 3 | 8 | 28856 | 29 | |||
161493 | 6285 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1480 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6003867.05631 | 2113210.81806 | 37.7826926384963 | -122.43029616652 | (37.7826926384963, -122.43029616652) | 7 | 9 | 11 | 29490 | 41 | |||
161467 | 632 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3179 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
161145 | 706 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1509X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005302.49516 | 2099477.85942 | 37.7450663972586 | -122.424353081707 | (37.7450663972586, -122.424353081707) | 2 | 7 | 5 | 28859 | 22 |
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) );