trees
3,247 rows where qSpecies_id = 22 sorted by qLegalStatus_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16077 | 201863 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1220 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6009514.9493 | 2110197.5964 | 37.7747373334401 | -122.410543934579 | (37.7747373334401, -122.410543934579) | 8 | 2 | 9 | 28853 | 34 | |||
| 16108 | 264710 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1315 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 6012426 | 2106899 | 37.7658429041656 | -122.400242229593 | (37.7658429041656, -122.400242229593) | 14 | 3 | 8 | 28856 | 20 | |||
| 16234 | 226133 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 454 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002986.00239 | 2098632.64023 | 37.74261454154 | -122.432302743977 | (37.74261454154, -122.432302743977) | 2 | 7 | 5 | 63 | 22 | |||
| 16240 | 219098 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 446 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5992878.03249 | 2103928.21125 | 37.7565765019208 | -122.467637894993 | (37.7565765019208, -122.467637894993) | 1 | 8 | 4 | 56 | 12 | |||
| 16265 | 83806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 4x4 | 6008439.24535 | 2117330.37578 | 37.794261859346 | -122.414769927392 | (37.794261859346, -122.414769927392) | 5 | 1 | 10 | 28858 | 21 | ||
| 16311 | 71600 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Wilson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5994689.24707 | 2086354.84413 | 37.7084287474492 | -122.460101024051 | (37.7084287474492, -122.460101024051) | 9 | 8 | 6 | 28861 | 25 | |||
| 16333 | 128995 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1414 Jones St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 3ft | 6008424.44271 | 2117443.95005 | 37.7945728745903 | -122.41482918821 | (37.7945728745903, -122.41482918821) | 5 | 1 | 10 | 28858 | 21 | |||
| 16438 | 87300 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 2 | Back Yard : Yard | Tree | DPW 1 | 6 | Permit Number 50312 | 6011877.98748 | 2100898.05147 | 37.749335051069 | -122.401715863223 | (37.749335051069, -122.401715863223) | 10 | 3 | 8 | 58 | 1 | |||
| 16453 | 260924 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2019 12:00:00 AM | 3 | 5990807.95481 | 2114868.4417 | 37.7864956605801 | -122.475595709543 | (37.7864956605801, -122.475595709543) | 11 | 6 | 1 | 54 | 33 | |||
| 16572 | 19741 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 STAIRWAY15 | -14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 1OST | |||||||||||||
| 16626 | 140766 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1998 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001378.7458 | 2112872.6658 | 37.7816229009646 | -122.438880402789 | (37.7816229009646, -122.438880402789) | 15 | 5 | 11 | 29490 | 41 | |||
| 16691 | 94109 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 311X Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53481 | 6006347.81272 | 2111083.22258 | 37.7769909819764 | -122.421562636328 | (37.7769909819764, -122.421562636328) | 7 | 9 | 11 | 28852 | 10 | |
| 16697 | 5176 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1993 12:00:00 AM | 3 | 3x3 | 6001777.7698 | 2109730.6414 | 37.7730183862506 | -122.437274925638 | (37.7730183862506, -122.437274925638) | 15 | 5 | 11 | 29492 | 9 | ||
| 16796 | 70557 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 20 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6004148.34946 | 2093373.6236 | 37.7282403094269 | -122.42790902788 | (37.7282403094269, -122.42790902788) | 9 | 7 | 6 | 28861 | 5 | |||
| 16899 | 225631 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100X Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007671.81203 | 2098162.40951 | 37.741587970818 | -122.416067239037 | (37.741587970818, -122.416067239037) | 2 | 7 | 7 | 28859 | 2 | |||
| 16968 | 190389 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 707 Wisconsin St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6012743.00891 | 2104201.32754 | 37.7584533636396 | -122.398956396938 | (37.7584533636396, -122.398956396938) | 10 | 3 | 8 | 28856 | 29 | |||
| 17051 | 219086 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1330 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994278.3823 | 2106435.21824 | 37.7635408482476 | -122.462976903978 | (37.7635408482476, -122.462976903978) | 1 | 5 | 11 | 56 | 12 | |||
| 17073 | 177097 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2020 12:08:00 PM | 3 | 3x3 | Permit Number 780184 | 6000986.95239 | 2093579.83618 | 37.7286271663089 | -122.438852851774 | (37.7286271663089, -122.438852851774) | 9 | 7 | 6 | 28861 | 25 | |
| 17138 | 84246 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 583 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51830 | 5988110.57341 | 2112018.88919 | 37.7785148566216 | -122.484718753523 | (37.7785148566216, -122.484718753523) | 11 | 6 | 2 | 55 | 26 | |
| 17226 | 225679 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 590X Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008562.94043 | 2096925.54945 | 37.7382418875511 | -122.412898580305 | (37.7382418875511, -122.412898580305) | 10 | 7 | 7 | 28859 | 2 | |||
| 17303 | 201604 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 570 Innes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 6021044.33252 | 2093135.00772 | 37.7285264880895 | -122.369481698744 | (37.7285264880895, -122.369481698744) | 10 | 3 | 8 | 58 | 1 | |||
| 17344 | 192428 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 480 Bryant St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6014110.58587 | 2112833.82618 | 37.7822323954538 | -122.39483123728 | (37.7822323954538, -122.39483123728) | 6 | 2 | 9 | 28856 | 6 | |||
| 17457 | 73445 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6007755.78016 | 2114801.18136 | 37.7872788880559 | -122.416955517392 | (37.7872788880559, -122.416955517392) | 13 | 1 | 10 | 28858 | 21 | |||
| 17601 | 71793 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2125 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5997663.2948 | 2109878.311 | 37.773189094117 | -122.451517986846 | (37.773189094117, -122.451517986846) | 15 | 5 | 11 | 29492 | 16 | |||
| 17644 | 128974 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008318.90919 | 2112394.69245 | 37.7807029103535 | -122.414836823479 | (37.7807029103535, -122.414836823479) | 7 | 10 | 9 | 28852 | 36 | |||
| 17680 | 226198 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 801X Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6009018.00913 | 2096918.47715 | 37.7382480020441 | -122.411324672293 | (37.7382480020441, -122.411324672293) | 10 | 7 | 7 | 28859 | 2 | |||
| 17720 | 73608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 136 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5994710.3414 | 2086333.69481 | 37.7083718896252 | -122.460026588949 | (37.7083718896252, -122.460026588949) | 9 | 8 | 6 | 28861 | 25 | |||
| 17756 | 73719 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 86 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6001003.51582 | 2093592.54046 | 37.7286629916874 | -122.438796501163 | (37.7286629916874, -122.438796501163) | 9 | 7 | 6 | 28861 | 25 | |||
| 17842 | 72669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 203 04th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5994587.45477 | 2114094.64597 | 37.7845894043596 | -122.462463528658 | (37.7845894043596, -122.462463528658) | 11 | 6 | 2 | 54 | 11 | |||
| 17845 | 7420 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1095 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6010426.8513 | 2110979.2324 | 37.7769346055078 | -122.407444582017 | (37.7769346055078, -122.407444582017) | 14 | 2 | 9 | 28853 | 34 | |||
| 17848 | 219082 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1285 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5994528.3763 | 2106787.65407 | 37.7645229421157 | -122.462137821217 | (37.7645229421157, -122.462137821217) | 11 | 5 | 11 | 56 | 12 | |||
| 17924 | 150280 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | Width 4ft | 6012537.6236 | 2106868.09585 | 37.7657642718362 | -122.399853974275 | (37.7657642718362, -122.399853974275) | 14 | 3 | 8 | 28856 | 20 | ||
| 17962 | 37394 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 260 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 9 | Permit Number 39876 | 6000430.23445 | 2087496.65427 | 37.7118924395572 | -122.440341369156 | (37.7118924395572, -122.440341369156) | 9 | 7 | 6 | 28861 | 5 | |
| 18006 | 226054 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 109 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6005482.53946 | 2103992.30122 | 37.7574721772249 | -122.424051500188 | (37.7574721772249, -122.424051500188) | 2 | 4 | 5 | 28859 | 19 | |||
| 18037 | 7422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/1991 12:00:00 AM | 8 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | |||
| 18317 | 115576 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 900X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6015313.29826 | 2096960.63807 | 37.7387148347127 | -122.389561431329 | (37.7387148347127, -122.389561431329) | 10 | 3 | 8 | 58 | 1 | |||
| 18366 | 39267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 540 Delancey St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40880 | 6015247.62996 | 2113604.71354 | 37.7844122333873 | -122.390951435185 | (37.7844122333873, -122.390951435185) | 6 | 2 | 9 | 28856 | 6 |
| 18383 | 226290 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 428 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003776.37855 | 2096273.85299 | 37.7361826352278 | -122.429401681261 | (37.7361826352278, -122.429401681261) | 2 | 7 | 5 | 63 | 7 | |||
| 18487 | 226200 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 701X Jarboe Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008856.5351 | 2096931.6994 | 37.7382752497104 | -122.411883905831 | (37.7382752497104, -122.411883905831) | 10 | 7 | 7 | 28859 | 2 | |||
| 18490 | 34599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3200 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 4 | Permit Number 38292 | 5999320.20166 | 2116021.69073 | 37.7901519674937 | -122.446228549814 | (37.7901519674937, -122.446228549814) | 13 | 6 | 1 | 29490 | 31 | |
| 18496 | 190429 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 27 | : | Tree | Private 2 | 2 | Width 3ft | 6017626.76379 | 2097120.54655 | 37.7392819157251 | -122.381573596257 | (37.7392819157251, -122.381573596257) | 10 | 3 | 8 | 58 | 1 | |||
| 18543 | 226204 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 505X Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6008508.6766 | 2096964.50836 | 37.7383458141135 | -122.413088952416 | (37.7383458141135, -122.413088952416) | 10 | 7 | 7 | 28859 | 2 | |||
| 18555 | 24631 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 04/03/2013 12:00:00 AM | 3 | 3X3 | 6001596.3507 | 2110541.037 | 37.7752332149341 | -122.437960533637 | (37.7752332149341, -122.437960533637) | 15 | 5 | 11 | 29492 | 10 | |
| 18617 | 27422 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3X3 | 6004589.1156 | 2099049.54321 | 37.7438500301684 | -122.426789326068 | (37.7438500301684, -122.426789326068) | 2 | 7 | 5 | 63 | 22 | |||
| 18644 | 219072 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 183 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995143.85497 | 2087382.22564 | 37.7112758346919 | -122.458604178052 | (37.7112758346919, -122.458604178052) | 9 | 8 | 6 | 28861 | 24 | |||
| 18777 | 190425 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 23 | : | Tree | Private 2 | 1 | Width 3ft | 6017693.17965 | 2097070.35958 | 37.7391477791404 | -122.381340468613 | (37.7391477791404, -122.381340468613) | 10 | 3 | 8 | 58 | 1 | |||
| 18786 | 225669 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100X Ogden Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007687.015 | 2096119.00175 | 37.7359780781128 | -122.415870008714 | (37.7359780781128, -122.415870008714) | 2 | 7 | 7 | 28859 | 2 | |||
| 18798 | 71245 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1732 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006396.12471 | 2117006.83983 | 37.7932585028357 | -122.421816375523 | (37.7932585028357, -122.421816375523) | 13 | 9 | 10 | 28858 | 32 | |||
| 18848 | 54010 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1537 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/1972 12:00:00 AM | 5 | Permit Number 9729 | 6012988.89964 | 2105636.75215 | 37.7624084228186 | -122.398206698706 | (37.7624084228186, -122.398206698706) | 10 | 3 | 8 | 28856 | 29 | |
| 18882 | 140155 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 899 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999260 | 2109945 | 37.7734635109373 | -122.445999591321 | (37.7734635109373, -122.445999591321) | 15 | 5 | 11 | 29492 | 16 | |||
| 18963 | 262441 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 San Gabriel Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 18980 | 48384 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 350& 17th ST Rhode Island St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2002 12:00:00 AM | 5 | Permit Number 45774 | 6011713.07765 | 2106631.21617 | 37.7650678512362 | -122.402689258803 | (37.7650678512362, -122.402689258803) | 8 | 3 | 8 | 28853 | 20 | ||
| 19104 | 225620 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 274 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5996934.40149 | 2106700.63691 | 37.7644222522069 | -122.453809795093 | (37.7644222522069, -122.453809795093) | 15 | 5 | 11 | 29492 | 12 | |||
| 19281 | 128961 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 270 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6007843 | 2112396 | 37.7806797483911 | -122.416483319824 | (37.7806797483911, -122.416483319824) | 7 | 10 | 9 | 28852 | 36 | |||
| 19320 | 33230 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2740 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | Permit Number 37416 | 6000651.12195 | 2117750.428 | 37.7949745459919 | -122.441747802734 | (37.7949745459919, -122.441747802734) | 13 | 9 | 1 | 57 | 27 | ||
| 19360 | 80805 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 991 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6015535.39126 | 2104617.20142 | 37.7597504684343 | -122.389328050963 | (37.7597504684343, -122.389328050963) | 10 | 3 | 8 | 28856 | 29 | |||
| 19512 | 150278 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Wisconsin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | Width 4ft | 6012533.22434 | 2106945.4742 | 37.7659764902431 | -122.399874624526 | (37.7659764902431, -122.399874624526) | 14 | 3 | 8 | 28856 | 20 | ||
| 19523 | 225636 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 651 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008158.43739 | 2095854.02509 | 37.7352770017363 | -122.414221366146 | (37.7352770017363, -122.414221366146) | 2 | 7 | 7 | 28859 | 2 | |||
| 19526 | 225722 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 4372 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001470.61216 | 2101182.2984 | 37.74952925789 | -122.437725076767 | (37.74952925789, -122.437725076767) | 2 | 4 | 5 | 28862 | 22 | |||
| 19583 | 200954 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1346 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6009074.4307 | 2109779.3172 | 37.7735641303875 | -122.412038217803 | (37.7735641303875, -122.412038217803) | 8 | 2 | 9 | 28853 | 34 | |||
| 19690 | 225735 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1034 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003127.36076 | 2102230.07407 | 37.7525002671762 | -122.432070806128 | (37.7525002671762, -122.432070806128) | 2 | 4 | 5 | 28862 | 22 | |||
| 19716 | 226267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 605 Grand View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000056.99783 | 2101531.70324 | 37.7504081590076 | -122.442638467901 | (37.7504081590076, -122.442638467901) | 2 | 4 | 5 | 28862 | 22 | |||
| 19811 | 226102 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 275 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6005512.33391 | 2107434.66841 | 37.7669257867307 | -122.424193272927 | (37.7669257867307, -122.424193272927) | 8 | 4 | 5 | 28853 | 19 | |||
| 19994 | 219088 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1465 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994259.2756 | 2105567.47431 | 37.7611571483992 | -122.462980026432 | (37.7611571483992, -122.462980026432) | 1 | 5 | 11 | 56 | 12 | |||
| 20059 | 143064 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 568 GREENWICH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010191.242 | 2120275.0896 | 37.8024456055 | -122.408915655908 | (37.8024456055, -122.408915655908) | 3 | 1 | 10 | 308 | 23 | |||
| 20077 | 10681 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1145 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002358.7398 | 2110530.7348 | 37.7752482530433 | -122.435322523233 | (37.7752482530433, -122.435322523233) | 15 | 5 | 11 | 29492 | 10 | |||
| 20089 | 10729 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Ardath Ct | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017489.5110714 | 2095183.8764266 | 37.7339566260964 | -122.381913486724 | (37.7339566260964, -122.381913486724) | 10 | 3 | 8 | 58 | 1 | ||
| 20114 | 192489 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011488.83741 | 2106592.25565 | 37.7649483520018 | -122.403462113682 | (37.7649483520018, -122.403462113682) | 8 | 3 | 8 | 28853 | 20 | |||
| 20218 | 190533 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014650.94909 | 2111960.46256 | 37.7798643671721 | -122.39290068514 | (37.7798643671721, -122.39290068514) | 6 | 2 | 9 | 28856 | 6 | |||
| 20365 | 176527 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Prague St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004589.78271 | 2090506.01263 | 37.7203914438823 | -122.42617890585 | (37.7203914438823, -122.42617890585) | 9 | 7 | 6 | 28861 | 5 | |||
| 20412 | 190617 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 54 Dore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008964.74545 | 2109712.92182 | 37.7733756695717 | -122.412412942829 | (37.7733756695717, -122.412412942829) | 8 | 2 | 9 | 28853 | 34 | |||
| 20435 | 128934 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1911 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6004762.88198 | 2115822.85089 | 37.7899153288661 | -122.427383123225 | (37.7899153288661, -122.427383123225) | 13 | 9 | 1 | 28858 | 27 | |||
| 20531 | 226057 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 98 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005745.17661 | 2104047.1264 | 37.7576375391616 | -122.423147091592 | (37.7576375391616, -122.423147091592) | 2 | 4 | 5 | 28859 | 19 | |||
| 20653 | 67417 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 787 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/1992 12:00:00 AM | 4 | Permit Number 30916 | 5990669.84727 | 2110037.89934 | 37.7732243191199 | -122.475720648254 | (37.7732243191199, -122.475720648254) | 11 | 6 | 2 | 55 | 26 | ||
| 20673 | 228277 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 84 Sharon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003857.16541 | 2106629.0006 | 37.764620022115 | -122.429860761778 | (37.764620022115, -122.429860761778) | 8 | 4 | 5 | 28862 | 3 | |||
| 20683 | 226152 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 335 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6004330.10643 | 2100124.74068 | 37.7467876269666 | -122.427761513008 | (37.7467876269666, -122.427761513008) | 2 | 7 | 5 | 63 | 22 | |||
| 20722 | 140879 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 137 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5996520.7008 | 2113467.9498 | 37.7829798014331 | -122.455729872689 | (37.7829798014331, -122.455729872689) | 11 | 6 | 1 | 54 | 31 | |||
| 20966 | 228294 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2416 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001701.26685 | 2107172.88608 | 37.7659910745653 | -122.437356373592 | (37.7659910745653, -122.437356373592) | 15 | 5 | 5 | 28862 | 3 | |||
| 20976 | 49996 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 247@ 18TH ST Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2003 12:00:00 AM | 3 | Permit Number 46739 | 6013491.30508 | 2105926.86406 | 37.7632329779416 | -122.396489388368 | (37.7632329779416, -122.396489388368) | 14 | 3 | 8 | 28856 | 29 | |
| 21015 | 129025 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6012112.87485 | 2117105.88276 | 37.7938511785367 | -122.402042888167 | (37.7938511785367, -122.402042888167) | 4 | 1 | 10 | 28860 | 6 | |||
| 21059 | 30335 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1956 12:00:00 AM | 2 | Permit Number 24 | 6002625.81177 | 2098862.65496 | 37.743225678518 | -122.433564611513 | (37.743225678518, -122.433564611513) | 2 | 7 | 5 | 63 | 7 | ||
| 21076 | 226269 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 Grand View Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6000052.32454 | 2101592.71128 | 37.7505754059276 | -122.442659008402 | (37.7505754059276, -122.442659008402) | 2 | 4 | 5 | 28862 | 22 | |||
| 21196 | 95772 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 643 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767507 | 6002653.48548 | 2089890.5721 | 37.7185919472416 | -122.432828107254 | (37.7185919472416, -122.432828107254) | 9 | 7 | 6 | 28861 | 5 |
| 21460 | 219112 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 130 Brentwood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995677.34458 | 2095602.53866 | 37.7338775046316 | -122.457354631219 | (37.7338775046316, -122.457354631219) | 9 | 7 | 4 | 59 | 40 | |||
| 21479 | 190434 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 33 | : | Tree | Private 2 | 2 | Width 3ft | 6017509.45239 | 2097206.48557 | 37.7395114092301 | -122.381985187163 | (37.7395114092301, -122.381985187163) | 10 | 3 | 8 | 58 | 1 | |||
| 21504 | 7423 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 301X 07TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6010388 | 2110913 | 37.7767505721368 | -122.407574310337 | (37.7767505721368, -122.407574310337) | 14 | 2 | 9 | 28853 | 34 | |||
| 21513 | 190444 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1301 Evans Ave | 7 | : | Tree | Private 2 | 1 | Width 3ft | 6017091.55638 | 2097401.29734 | 37.7400232358798 | -122.383443661803 | (37.7400232358798, -122.383443661803) | 10 | 3 | 8 | 58 | 1 | |||
| 21557 | 226076 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 61 Norwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008975.78899 | 2099439.63684 | 37.7451681862664 | -122.411648734005 | (37.7451681862664, -122.411648734005) | 2 | 7 | 7 | 28859 | 2 | |||
| 21681 | 192451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2310 19th St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6010858.43231 | 2105104.61317 | 37.7608283895517 | -122.405537754389 | (37.7608283895517, -122.405537754389) | 10 | 3 | 8 | 28856 | 29 | |||
| 21875 | 559 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2933 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6009274.56572 | 2102151.76119 | 37.7526318334984 | -122.410807118757 | (37.7526318334984, -122.410807118757) | 2 | 4 | 7 | 28859 | 19 | |||
| 21892 | 50870 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2626 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 47381 | 6001002.60746 | 2117608.08082 | 37.7946037186291 | -122.440521399949 | (37.7946037186291, -122.440521399949) | 13 | 9 | 1 | 57 | 27 | |||
| 22123 | 14582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1157 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 5999380.4238 | 2108868.5189 | 37.7705146429615 | -122.445505607921 | (37.7705146429615, -122.445505607921) | 15 | 5 | 11 | 29492 | 9 | |||
| 22307 | 190399 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | 10 | 3 | 8 | 58 | 1 | |||
| 22319 | 190397 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 8 | : | Tree | Private 2 | 4 | Width 3ft | 6012152.10777 | 2100910.47094 | 37.7493844454379 | -122.400768815931 | (37.7493844454379, -122.400768815931) | 10 | 3 | 8 | 58 | 1 | |||
| 22386 | 247804 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 488 30th St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6003501.31638 | 2098369.19661 | 37.7419203917212 | -122.430502145662 | (37.7419203917212, -122.430502145662) | 2 | 7 | 5 | 63 | 22 | |||
| 22431 | 176546 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 225 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001153.2088 | 2093150.95928 | 37.7274590260883 | -122.438247383234 | (37.7274590260883, -122.438247383234) | 9 | 7 | 6 | 28861 | 25 | |||
| 22455 | 225710 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 220 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006137.83529 | 2101839.26877 | 37.7515974234042 | -122.421632305902 | (37.7515974234042, -122.421632305902) | 2 | 4 | 5 | 28859 | 19 | |||
| 22492 | 128946 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 880 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005803.3615 | 2112793.88056 | 37.7816573167765 | -122.423567714377 | (37.7816573167765, -122.423567714377) | 7 | 9 | 11 | 28852 | 41 | |||
| 22544 | 225698 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 3356 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005996.88961 | 2103190.09545 | 37.7552985329167 | -122.422215676322 | (37.7552985329167, -122.422215676322) | 2 | 4 | 5 | 28859 | 19 | |||
| 22637 | 192482 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1900 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6011685.81518 | 2106547.60662 | 37.7648367560319 | -122.402777672945 | (37.7648367560319, -122.402777672945) | 8 | 3 | 8 | 28853 | 20 |
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) );