trees
3,247 rows where qSpecies_id = 22 sorted by SiteOrder 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3306 | 228286 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
| 10049 | 261052 | Private 9 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Hooper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013012.2905 | 2108046.92839 | 37.769027533769 | -122.398294909078 | (37.769027533769, -122.398294909078) | 14 | 3 | 8 | 28856 | 20 | ||||
| 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 | |||
| 27607 | 91318 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 31533 | 190515 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 649 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015672.13111 | 2113216.39507 | 37.7833695441175 | -122.389455667442 | (37.7833695441175, -122.389455667442) | 6 | 2 | 9 | 28856 | 6 | |||
| 32595 | 190599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015261.35764 | 2108269.67472 | 37.7697641703179 | -122.390531026393 | (37.7697641703179, -122.390531026393) | 14 | 3 | 9 | 310 | 20 | |||
| 37981 | 104106 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 43282 | 4044 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2014 12:00:00 AM | 3 | 2X3 | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | 10 | 3 | 8 | 58 | 1 | ||
| 44799 | 84752 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 57202 | 109123 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 62599 | 6455 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1199 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2016 12:00:00 AM | 3 | 3X3 | 6017959.51846 | 2096757.36933 | 37.7383030702171 | -122.380397832517 | (37.7383030702171, -122.380397832517) | 10 | 3 | 8 | 58 | 1 | ||
| 63527 | 190608 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015462.45363 | 2107535.18496 | 37.7677585760219 | -122.389784125064 | (37.7677585760219, -122.389784125064) | 14 | 3 | 9 | 310 | 20 | |||
| 73308 | 91304 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011733.90284 | 2106231.09001 | 37.7639703572781 | -122.40258908962 | (37.7639703572781, -122.40258908962) | 8 | 3 | 8 | 28856 | 29 | |
| 73329 | 190558 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 82 Carolina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012244.89975 | 2107163.01595 | 37.7665577328664 | -122.400887172109 | (37.7665577328664, -122.400887172109) | 14 | 3 | 8 | 28856 | 20 | |||
| 79454 | 6661 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 3 | 3X3 | 6016028.90772 | 2098318.24105 | 37.7424821883031 | -122.387181838675 | (37.7424821883031, -122.387181838675) | 10 | 3 | 8 | 58 | 1 | ||
| 79499 | 256582 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 80223 | 14501 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 401X Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/1999 12:00:00 AM | 6 | 8 | 5999062.4864 | 2111159.5057 | 37.7767869519261 | -122.446770221959 | (37.7767869519261, -122.446770221959) | 15 | 5 | 2 | 29492 | 16 | ||
| 85050 | 198739 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Main St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | 6015183.09065 | 2115200.65141 | 37.7887907329425 | -122.391286320207 | (37.7887907329425, -122.391286320207) | 6 | 2 | 9 | 28855 | 6 | ||||
| 86850 | 228326 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Rose St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006167.99201 | 2109877.54342 | 37.7736703369359 | -122.422099018072 | (37.7736703369359, -122.422099018072) | 7 | 9 | 11 | 28852 | 10 | |||
| 87053 | 139203 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2179 Post St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001987.8387 | 2113944.4405 | 37.784600356978 | -122.436849983171 | (37.784600356978, -122.436849983171) | 13 | 6 | 11 | 29490 | 13 | |||
| 87374 | 190417 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1300 Evans Ave | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6017947.81444 | 2096878.13487 | 37.7386340225323 | -122.380446690882 | (37.7386340225323, -122.380446690882) | 10 | 3 | 8 | 58 | 1 | |||
| 91593 | 190574 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6016169.13913 | 2107975.39199 | 37.769006451918 | -122.387370475084 | (37.769006451918, -122.387370475084) | 14 | 3 | 9 | 310 | 20 | |||
| 98208 | 44770 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
| 98712 | 98434 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1401X Steiner St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | ||
| 111099 | 44201 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 115675 | 39398 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 123869 | 192479 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Pennsylvania Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014497.46696 | 2101747.35421 | 37.7518128856693 | -122.392716981507 | (37.7518128856693, -122.392716981507) | 10 | 3 | 8 | 28856 | 1 | ||||
| 126967 | 6602 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/04/1997 12:00:00 AM | 6 | 3X3 | 6016545.70943 | 2097925.30543 | 37.7414318727766 | -122.385367499637 | (37.7414318727766, -122.385367499637) | 10 | 3 | 8 | 58 | 1 | ||
| 128071 | 190502 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015161.53861 | 2113681.89794 | 37.7846193868054 | -122.391254681168 | (37.7846193868054, -122.391254681168) | 6 | 2 | 9 | 28856 | 6 | |||
| 132062 | 190531 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014690.25882 | 2111926.06941 | 37.779772114735 | -122.39276228756 | (37.779772114735, -122.39276228756) | 6 | 2 | 9 | 28856 | 6 | |||
| 132945 | 128981 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008536.70915 | 2112423.0867 | 37.7807931096483 | -122.41408535538 | (37.7807931096483, -122.41408535538) | 7 | 10 | 9 | 28852 | 36 | |||
| 135097 | 219117 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Brompton Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002040.90491 | 2095107.61189 | 37.732881996497 | -122.435318519728 | (37.732881996497, -122.435318519728) | 9 | 7 | 5 | 63 | 40 | |||
| 155253 | 129011 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2200 Grant Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6010212.84483 | 2122235.52115 | 37.8078296738771 | -122.40897930247 | (37.8078296738771, -122.40897930247) | 3 | 1 | 10 | 308 | 23 | |||
| 156658 | 115628 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 100x CAROLINA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 3 | 3x3 | 6012240 | 2107486 | 37.7674443012314 | -122.400926814605 | (37.7674443012314, -122.400926814605) | 14 | 3 | 8 | 28856 | 20 | ||
| 162074 | 128925 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004651.86551 | 2116712.77467 | 37.792352555486 | -122.427830667265 | (37.792352555486, -122.427830667265) | 13 | 9 | 1 | 28858 | 27 | |||
| 170833 | 16535 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1420X Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | ||
| 176485 | 6626 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016580.82562 | 2097781.51455 | 37.7410389949512 | -122.38523606192 | (37.7410389949512, -122.38523606192) | 10 | 3 | 8 | 58 | 1 | ||
| 189680 | 190400 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 9 | : | Tree | Private 2 | 2 | Width 3ft | 6012170.1171 | 2100910.58495 | 37.7493857629599 | -122.400706546863 | (37.7493857629599, -122.400706546863) | 10 | 3 | 8 | 58 | 1 | |||
| 191858 | 226025 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006384.82585 | 2107467.885 | 37.7670662167577 | -122.421177816405 | (37.7670662167577, -122.421177816405) | 8 | 4 | 7 | 28853 | 19 | |||
| 9979 | 6601 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1400 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2000 12:00:00 AM | 18 | 3X3 | 6016563.26404 | 2097911.91125 | 37.7413960662634 | -122.385305868181 | (37.7413960662634, -122.385305868181) | 10 | 3 | 8 | 58 | 1 | ||
| 10740 | 228285 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
| 12711 | 190451 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016356.86171 | 2098066.94132 | 37.7418103263734 | -122.386030346736 | (37.7418103263734, -122.386030346736) | 10 | 3 | 8 | 58 | 1 | |||
| 19756 | 100780 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 25161 | 256581 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 2x Stillman St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014165 | 2112908 | 37.7824390851954 | -122.394648183134 | (37.7824390851954, -122.394648183134) | 6 | 2 | 9 | 28856 | 6 | ||||
| 27392 | 139202 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2179 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001936.183 | 2113940.0129 | 37.7845852639581 | -122.437028377087 | (37.7845852639581, -122.437028377087) | 13 | 6 | 11 | 29490 | 13 | |||
| 33106 | 226024 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 56 Julian Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006384.40456 | 2107484.67305 | 37.7671122890184 | -122.421180465801 | (37.7671122890184, -122.421180465801) | 8 | 4 | 7 | 28853 | 19 | |||
| 34052 | 27493 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 401X Masonic Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/1999 12:00:00 AM | 8 | 8 | 5999060.5624 | 2111177.3019 | 37.7768357058082 | -122.446778158439 | (37.7768357058082, -122.446778158439) | 15 | 5 | 2 | 29492 | 16 | ||
| 45429 | 192433 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950 Harrison St | 8 | : | Tree | Private 2 | 6 | Width 3ft | 6011659.35399 | 2111367.95244 | 37.7780708492141 | -122.403208304326 | (37.7780708492141, -122.403208304326) | 14 | 2 | 9 | 28856 | 34 | |||
| 47519 | 128908 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2699 Filbert St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000146.67214 | 2118481.01335 | 37.7969517846466 | -122.443545774121 | (37.7969517846466, -122.443545774121) | 13 | 9 | 1 | 57 | 17 | |||
| 50055 | 44778 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 938 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | Permit Number 43877 | 6011792.18948294 | 2111489.0452941 | 37.7784107598375 | -122.402757294311 | (37.7784107598375, -122.402757294311) | 14 | 2 | 9 | 28856 | 34 | |||
| 51369 | 44194 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Harrison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2000 12:00:00 AM | Permit Number 43651 | 6015694.21185643 | 2115218.20458409 | 37.7888672826794 | -122.389519124295 | (37.7888672826794, -122.389519124295) | 6 | 2 | 9 | 28855 | 6 | |||
| 52611 | 219077 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 494 Victoria St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993267.6387 | 2090426.62452 | 37.7195270128342 | -122.465309800205 | (37.7195270128342, -122.465309800205) | 9 | 8 | 6 | 64 | 24 | |||
| 56523 | 128980 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 199 McAllister St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6008492.62721 | 2112417.90621 | 37.7807764092316 | -122.414237490093 | (37.7807764092316, -122.414237490093) | 7 | 10 | 9 | 28852 | 36 | |||
| 57611 | 190598 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 526 Nelson Rising Ln | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015283.47377 | 2108274.89643 | 37.7697797348675 | -122.390454891574 | (37.7697797348675, -122.390454891574) | 14 | 3 | 9 | 310 | 20 | |||
| 61331 | 115627 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 100x CAROLINA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/2016 12:00:00 AM | 3 | 3x3 | 6012240 | 2107486 | 37.7674443012314 | -122.400926814605 | (37.7674443012314, -122.400926814605) | 14 | 3 | 8 | 28856 | 20 | ||
| 63955 | 192478 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1100 Pennsylvania Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014496.88191 | 2101756.58956 | 37.7518382114843 | -122.392719650714 | (37.7518382114843, -122.392719650714) | 10 | 3 | 8 | 28856 | 1 | ||||
| 66919 | 91303 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52049 | 6011733.09402 | 2106250.1739 | 37.7640227122069 | -122.402593229194 | (37.7640227122069, -122.402593229194) | 8 | 3 | 8 | 28856 | 29 | |
| 73399 | 129032 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6012277.41277 | 2117127.53422 | 37.7939198102919 | -122.401475090399 | (37.7939198102919, -122.401475090399) | 4 | 1 | 10 | 28860 | 6 | |||
| 74794 | 6644 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1499 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/25/2014 02:34:00 PM | 3 | 3X3 | 6016429.20834 | 2097898.03083 | 37.7413505362372 | -122.385768423283 | (37.7413505362372, -122.385768423283) | 10 | 3 | 8 | 58 | 1 | ||
| 76238 | 190550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 888 07th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6012436.95281 | 2108645.13993 | 37.7706380226612 | -122.400327001491 | (37.7706380226612, -122.400327001491) | 14 | 2 | 8 | 28856 | 20 | |||
| 87112 | 91317 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Rhode Island St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 99126 | 190573 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 550 South St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6016194.38649 | 2107976.86529 | 37.7690118955188 | -122.387283248044 | (37.7690118955188, -122.387283248044) | 14 | 3 | 9 | 310 | 20 | |||
| 102297 | 190582 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 450 South St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015829.41164 | 2107957.60094 | 37.7689387806299 | -122.38854433945 | (37.7689387806299, -122.38854433945) | 14 | 3 | 9 | 310 | 20 | |||
| 103025 | 117599 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 329x IVY ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2016 12:00:00 AM | 3 | 3x6 | 6005708 | 2111040 | 37.7768362060225 | -122.423772874681 | (37.7768362060225, -122.423772874681) | 7 | 9 | 11 | 28852 | 10 | ||
| 107263 | 16534 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1420X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2004 12:00:00 AM | 3 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | ||
| 114301 | 98806 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950x CLAY ST | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3x3 | Permit Number 768771 | 6010160 | 2117472 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | 3 | 1 | 10 | 28857 | 4 | ||
| 124366 | 228325 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 10 Rose St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006186.85777 | 2109878.68777 | 37.7736745430901 | -122.422033839708 | (37.7736745430901, -122.422033839708) | 7 | 9 | 11 | 28852 | 10 | |||
| 126583 | 109122 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 136972 | 6660 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1550 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2001 12:00:00 AM | 6 | 3X3 | 6016043.95648 | 2098306.88974 | 37.7424518532839 | -122.38712901249 | (37.7424518532839, -122.38712901249) | 10 | 3 | 8 | 58 | 1 | ||
| 138882 | 190607 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 355 Campus Way | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6015421.42625 | 2107533.65832 | 37.7677521089958 | -122.389925928363 | (37.7677521089958, -122.389925928363) | 14 | 3 | 9 | 310 | 20 | |||
| 146898 | 6625 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1415 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/24/1998 12:00:00 AM | 6 | 3x3 | 6016564.1874 | 2097795.2525 | 37.7410757961225 | -122.385294548421 | (37.7410757961225, -122.385294548421) | 10 | 3 | 8 | 58 | 1 | ||
| 147225 | 104105 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 55X Clarence Pl | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2x3 | Permit Number 768392 | 6014738.33428 | 2111855.52316 | 37.7795810807004 | -122.392591035948 | (37.7795810807004, -122.392591035948) | 6 | 2 | 9 | 28856 | 6 | |||
| 148867 | 190398 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012152.10777 | 2100910.47094 | 37.7493844454379 | -122.400768815931 | (37.7493844454379, -122.400768815931) | 10 | 3 | 8 | 58 | 1 | |||
| 153497 | 6454 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1199 Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/03/2017 02:46:00 PM | 3 | 3X3 | 6017932.4783 | 2096773.48366 | 37.7383458248849 | -122.380492444782 | (37.7383458248849, -122.380492444782) | 10 | 3 | 8 | 58 | 1 | ||
| 154982 | 14487 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 281 Masonic Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 5998916.88383 | 2112015.94131 | 37.7791301845625 | -122.447335559177 | (37.7791301845625, -122.447335559177) | 15 | 6 | 2 | 54 | 16 | |||
| 159439 | 190557 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 82 Carolina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012241.5146 | 2107184.19202 | 37.7666156887812 | -122.400900368768 | (37.7666156887812, -122.400900368768) | 14 | 3 | 8 | 28856 | 20 | |||
| 159940 | 39399 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1690 Church St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40927 | 6004593.43741133 | 2099046.93821221 | 37.7438431217943 | -122.426774196771 | (37.7438431217943, -122.426774196771) | 2 | 7 | 5 | 63 | 22 | |||
| 160807 | 190501 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 538 Delancey St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015159.193 | 2113714.53194 | 37.7847088621733 | -122.391265078242 | (37.7847088621733, -122.391265078242) | 6 | 2 | 9 | 28856 | 6 | |||
| 166472 | 190530 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014703.41916 | 2111909.48405 | 37.779727306012 | -122.392715599241 | (37.779727306012, -122.392715599241) | 6 | 2 | 9 | 28856 | 6 | |||
| 167950 | 84751 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 170993 | 128924 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2101 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004550.97852 | 2116701.91913 | 37.7923170412555 | -122.428178964795 | (37.7923170412555, -122.428178964795) | 13 | 9 | 1 | 28858 | 27 | |||
| 186514 | 4043 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 2323 Cesar Chavez St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2005 12:00:00 AM | 3 | 2X3 | 6012152.10777 | 2100910.47094 | 37.7493844454379 | -122.400768815931 | (37.7493844454379, -122.400768815931) | 10 | 3 | 8 | 58 | 1 | ||
| 187706 | 98797 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 950@Washington Clay St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 03/16/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768771 | 6010116.35805 | 2117191.91562 | 37.7939757697248 | -122.408957127878 | (37.7939757697248, -122.408957127878) | 3 | 1 | 10 | 28857 | 4 | |
| 3016 | 190529 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 21 Clarence Pl | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6014722.79424 | 2111890.37318 | 37.7796759079438 | -122.392647234607 | (37.7796759079438, -122.392647234607) | 6 | 2 | 9 | 28856 | 6 | |||
| 9176 | 176544 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Panama St | 7 | : | Tree | Private 2 | 1 | Width 3ft | 5992259.97775 | 2086836.1982 | 37.7096104062721 | -122.468531792305 | (37.7096104062721, -122.468531792305) | 9 | 8 | 4 | 64 | 24 | |||
| 9806 | 81718 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 998 Indiana St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014951.7156 | 2104031.36678 | 37.7581095159642 | -122.39130576085 | (37.7581095159642, -122.39130576085) | 10 | 3 | 8 | 28856 | 29 | |||
| 10725 | 228284 | Section 806 (d) 5 | Ginkgo biloba :: Maidenhair Tree 22 | 2036X 15th St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | |||
| 11023 | 6550 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1225X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/28/2013 12:00:00 AM | 3 | 4x4 | 6017625.4418446 | 2096995.6120179 | 37.7389387975003 | -122.381569480835 | (37.7389387975003, -122.381569480835) | 10 | 3 | 8 | 58 | 1 | ||
| 12788 | 84750 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 170 King St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/04/2007 12:00:00 AM | Permit No. 49304 | 6014851 | 2111791 | 37.7794101710037 | -122.392196759897 | (37.7794101710037, -122.392196759897) | 6 | 2 | 9 | 28856 | 6 | |||
| 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 | ||
| 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 |
| 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 | ||
| 20563 | 109121 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 2036x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12x6 | 6003817 | 2107261 | 37.7663530653237 | -122.430044770651 | (37.7663530653237, -122.430044770651) | 8 | 4 | 5 | 28862 | 3 | ||||
| 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 | |||
| 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 | |||
| 25123 | 50152 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 215 REVISED Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2003 12:00:00 AM | Permit Number 46870 | 6014159.85874387 | 2115328.34387959 | 37.7890845068427 | -122.3948355307 | (37.7890845068427, -122.3948355307) | 6 | 2 | 9 | 28855 | 6 | |||
| 27161 | 190450 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1498 Evans Ave | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6016372.9615 | 2098053.57634 | 37.7417745198736 | -122.385973747016 | (37.7417745198736, -122.385973747016) | 10 | 3 | 8 | 58 | 1 | |||
| 27537 | 6467 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1200X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/04/2004 12:00:00 AM | 3 | 3X3 | 6017673.48201 | 2097089.96001 | 37.7392005105495 | -122.381409937459 | (37.7392005105495, -122.381409937459) | 10 | 3 | 8 | 58 | 1 | ||
| 35642 | 98967 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 302x Ivy St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 |
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) );