trees
3,247 rows where qSpecies_id = 22 sorted by Neighborhoods (old) 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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5079 | 244070 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997422 | 2109143 | 37.7711562992209 | -122.452299584321 | (37.7711562992209, -122.452299584321) | 15 | 5 | 11 | 29492 | 9 | |||
| 5434 | 244069 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5997423.6428 | 2109118.4396 | 37.7710889568013 | -122.45229212933 | (37.7710889568013, -122.45229212933) | 15 | 5 | 11 | 29492 | 9 | |||
| 6645 | 226161 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 9 | Width 4ft | Permit Number 32799 | 5997997.11826 | 2106529.02842 | 37.76401192934 | -122.450121798605 | (37.76401192934, -122.450121798605) | 15 | 5 | 11 | 29492 | 9 | |
| 8396 | 225575 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Carmelita St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6002578.23632 | 2108754.51591 | 37.7703836584071 | -122.434436211974 | (37.7703836584071, -122.434436211974) | 15 | 5 | 5 | 29492 | 9 | |||
| 12872 | 225999 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | 15 | 5 | 5 | 29492 | 9 | |||
| 13115 | 51970 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
| 14479 | 260995 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
| 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 | ||
| 17837 | 260996 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
| 18486 | 260997 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
| 19071 | 260994 | Undocumented 4 | Ginkgo biloba :: Maidenhair Tree 22 | 1639 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999105 | 2109358 | 37.771842906315 | -122.446493517614 | (37.771842906315, -122.446493517614) | 15 | 5 | 11 | 29492 | 9 | ||||
| 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 | |||
| 22697 | 247223 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 161 Divisadero St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6001877.39877 | 2108558.68003 | 37.7698061344742 | -122.436846384277 | (37.7698061344742, -122.436846384277) | 15 | 5 | 5 | 29492 | 9 | |||
| 22889 | 247266 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1015 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999307.5948 | 2109374.9253 | 37.7719009485191 | -122.445793948227 | (37.7719009485191, -122.445793948227) | 15 | 5 | 11 | 29492 | 9 | |||
| 24105 | 226170 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1050 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997695.84471 | 2106867.66337 | 37.7649244903053 | -122.451188232668 | (37.7649244903053, -122.451188232668) | 15 | 5 | 11 | 29492 | 9 | |||
| 26659 | 247350 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999192.1295 | 2109050.0804 | 37.771002413539 | -122.446169978833 | (37.771002413539, -122.446169978833) | 15 | 5 | 11 | 29492 | 9 | |||
| 31594 | 54908 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1025 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 10774 | 5997625.73992568 | 2107028.28129343 | 37.7653614921753 | -122.451442291891 | (37.7653614921753, -122.451442291891) | 15 | 5 | 11 | 29492 | 9 | ||
| 32093 | 244546 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1055 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5999338.3567 | 2109157.8829 | 37.7713067615329 | -122.445671930088 | (37.7713067615329, -122.445671930088) | 15 | 5 | 11 | 29492 | 9 | |||
| 32483 | 17374 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5999326.98506 | 2109281.57077 | 37.7716457277875 | -122.445720161424 | (37.7716457277875, -122.445720161424) | 15 | 5 | 11 | 29492 | 9 | |||
| 33763 | 247222 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Divisadero St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6001857.53471 | 2108690.91436 | 37.7701680882111 | -122.436924561446 | (37.7701680882111, -122.436924561446) | 15 | 5 | 5 | 29492 | 9 | |||
| 35687 | 226168 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 157 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2012 12:00:00 AM | 1 | Width 3ft | Permit Number 769431 | 5999386.56682 | 2107303.78218 | 37.7662186210304 | -122.445371834049 | (37.7662186210304, -122.445371834049) | 15 | 5 | 5 | 29492 | 9 | |
| 36124 | 49342 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Clifford Ter | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2003 12:00:00 AM | Permit Number 46332 | 5999646.98705896 | 2106515.41862964 | 37.7640688343052 | -122.444414431135 | (37.7640688343052, -122.444414431135) | 15 | 5 | 5 | 29492 | 9 | |||
| 41949 | 226172 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1318 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997806.19619 | 2106066.44263 | 37.7627308585759 | -122.450748783431 | (37.7627308585759, -122.450748783431) | 15 | 5 | 11 | 29492 | 9 | |||
| 47732 | 226171 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1306 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997796.8768 | 2106112.09551 | 37.7628556763806 | -122.450784307568 | (37.7628556763806, -122.450784307568) | 15 | 5 | 11 | 29492 | 9 | |||
| 48138 | 14562 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1015 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1994 12:00:00 AM | 12 | 3x3 | 5999289.72855 | 2109333.78788 | 37.7717869754873 | -122.445852789531 | (37.7717869754873, -122.445852789531) | 15 | 5 | 11 | 29492 | 9 | ||
| 51296 | 246050 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1260 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999528.5404 | 2108445.6696 | 37.76936206022 | -122.444962871278 | (37.76936206022, -122.444962871278) | 15 | 5 | 11 | 29492 | 9 | |||
| 63234 | 247349 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999140.3269 | 2109043.1665 | 37.7709804712442 | -122.446348667441 | (37.7709804712442, -122.446348667441) | 15 | 5 | 11 | 29492 | 9 | |||
| 67700 | 225624 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 Buena Vista Ave West | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5999826.28045 | 2107648.26374 | 37.7671895722601 | -122.443875706619 | (37.7671895722601, -122.443875706619) | 15 | 5 | 5 | 29492 | 9 | |||
| 68488 | 14567 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1035X Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 5999322.64051 | 2109314.43165 | 37.7717357073698 | -122.445737553038 | (37.7717357073698, -122.445737553038) | 15 | 5 | 11 | 29492 | 9 | |||
| 74968 | 14560 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1014 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/21/1997 12:00:00 AM | 6 | 3X3 | 5999375.3597 | 2109336.577 | 37.7717995227597 | -122.445556787364 | (37.7717995227597, -122.445556787364) | 15 | 5 | 11 | 29492 | 9 | ||
| 76241 | 226173 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1342 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997818.2761 | 2105970.72811 | 37.76246874215 | -122.45070010225 | (37.76246874215, -122.45070010225) | 15 | 5 | 11 | 29492 | 9 | |||
| 80242 | 108622 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 244 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | Permit Number 772819 | 6002313.92049 | 2109316.75363 | 37.7719124170473 | -122.435390704283 | (37.7719124170473, -122.435390704283) | 15 | 5 | 11 | 29492 | 9 | |
| 80430 | 38718 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 316 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 40621 | 6002284.90067424 | 2109567.58352939 | 37.7725994856416 | -122.43550903266 | (37.7725994856416, -122.43550903266) | 15 | 5 | 11 | 29492 | 9 | ||
| 80945 | 247267 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1015 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999314.858 | 2109330.4914 | 37.7717793590176 | -122.4457656283 | (37.7717793590176, -122.4457656283) | 15 | 5 | 11 | 29492 | 9 | |||
| 81964 | 14563 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1015 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999319.5578 | 2109306.1383 | 37.7717127599273 | -122.445747619764 | (37.7717127599273, -122.445747619764) | 15 | 5 | 11 | 29492 | 9 | |||
| 82384 | 5166 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 300 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 6001808.2976 | 2109504.736 | 37.7723998416689 | -122.437153148887 | (37.7723998416689, -122.437153148887) | 15 | 5 | 11 | 29492 | 9 | ||||
| 90305 | 58586 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 126 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/1993 12:00:00 AM | 4x4 | Permit Number 32799 | 5998027.55181779 | 2106540.68640664 | 37.7640456807087 | -122.450017378701 | (37.7640456807087, -122.450017378701) | 15 | 5 | 11 | 29492 | 9 | ||
| 91915 | 226169 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1044 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997689.88477 | 2106910.21396 | 37.7650409821789 | -122.451211915394 | (37.7650409821789, -122.451211915394) | 15 | 5 | 11 | 29492 | 9 | |||
| 93013 | 247473 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 838 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6002529.5119 | 2109559.0264 | 37.7725898795967 | -122.434662285947 | (37.7725898795967, -122.434662285947) | 15 | 5 | 11 | 29492 | 9 | |||
| 93462 | 226165 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 32 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5998444.26659 | 2106027.36418 | 37.7626600630298 | -122.448539119483 | (37.7626600630298, -122.448539119483) | 15 | 5 | 11 | 29492 | 9 | |||
| 97215 | 53633 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 467 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2008 12:00:00 AM | 3x3 | Permit Number 51749 | 5998520.94965543 | 2106477.50305638 | 37.7639004154905 | -122.448306317688 | (37.7639004154905, -122.448306317688) | 15 | 5 | 11 | 29492 | 9 | ||
| 100105 | 106021 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 181 Buena Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | 15 | 5 | 5 | 29492 | 9 | ||||
| 100766 | 247221 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 187 Divisadero St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6001849.33008 | 2108668.89946 | 37.7701071744218 | -122.436951364836 | (37.7701071744218, -122.436951364836) | 15 | 5 | 5 | 29492 | 9 | |||
| 102236 | 49340 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 100 Clifford Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2003 12:00:00 AM | Permit Number 46332 | 5999646.98705896 | 2106515.41862964 | 37.7640688343052 | -122.444414431135 | (37.7640688343052, -122.444414431135) | 15 | 5 | 5 | 29492 | 9 | |||
| 106213 | 226164 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 560 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5998634.48137 | 2105967.33385 | 37.762506108992 | -122.4478769154 | (37.762506108992, -122.4478769154) | 15 | 5 | 11 | 29492 | 9 | |||
| 108902 | 14602 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1260 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999494.0179 | 2108475.6497 | 37.7694424076588 | -122.445084438193 | (37.7694424076588, -122.445084438193) | 15 | 5 | 11 | 29492 | 9 | |||
| 110917 | 111020 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90x DOWNEY ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
| 114289 | 248394 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1345 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999506.8881 | 2108123.6109 | 37.768476532437 | -122.44501460966 | (37.768476532437, -122.44501460966) | 15 | 5 | 11 | 29492 | 9 | |||
| 115932 | 17089 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1637 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 4x3 | 5999143.48377 | 2109364.05455 | 37.7718617285917 | -122.446360835734 | (37.7718617285917, -122.446360835734) | 15 | 5 | 11 | 29492 | 9 | ||
| 118085 | 225998 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6002353.91965 | 2108316.37553 | 37.769167897316 | -122.435180779574 | (37.769167897316, -122.435180779574) | 15 | 5 | 5 | 29492 | 9 | |||
| 119542 | 5151 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2002 12:00:00 AM | 3 | 3X3 | 6001783.9539 | 2109206.4501 | 37.7715794389957 | -122.437215994595 | (37.7715794389957, -122.437215994595) | 15 | 5 | 11 | 29492 | 9 | ||
| 119560 | 41142 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | Permit Number 41877 | 5997416.72400274 | 2109142.90365491 | 37.7711557324301 | -122.452317827144 | (37.7711557324301, -122.452317827144) | 15 | 5 | 11 | 29492 | 9 | |||
| 119617 | 51969 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1563 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2005 12:00:00 AM | Permit Number 48189 | 5999092.74097418 | 2109030.13425564 | 37.7709419701081 | -122.446512330156 | (37.7709419701081, -122.446512330156) | 15 | 5 | 11 | 29492 | 9 | |||
| 123219 | 246049 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1260 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5999544.2875 | 2108448.0922 | 37.7693696107845 | -122.444908577153 | (37.7693696107845, -122.444908577153) | 15 | 5 | 11 | 29492 | 9 | |||
| 127238 | 17375 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1045X Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 3X3 | 5999334.9387 | 2109190.781 | 37.7713968962247 | -122.445686119272 | (37.7713968962247, -122.445686119272) | 15 | 5 | 11 | 29492 | 9 | |||
| 133809 | 89000 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 467 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2008 12:00:00 AM | 3x3 | Permit Number 51749 | 5998531 | 2106481 | 37.7639105917986 | -122.448271808545 | (37.7639105917986, -122.448271808545) | 15 | 5 | 11 | 29492 | 9 | ||
| 139099 | 31712 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 144#8 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 6 | Permit Number 35212 | 5997752.60888 | 2106811.6334 | 37.764773896114 | -122.450987860098 | (37.764773896114, -122.450987860098) | 15 | 5 | 11 | 29492 | 9 | |
| 140791 | 67112 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 141 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30529 | 5997768.54356742 | 2106764.79939492 | 37.7646462140554 | -122.450929369083 | (37.7646462140554, -122.450929369083) | 15 | 5 | 11 | 29492 | 9 | ||
| 143298 | 14569 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1040 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1992 12:00:00 AM | 3 | 3X3 | 5999387.9901 | 2109254.1467 | 37.7715739111315 | -122.445507169781 | (37.7715739111315, -122.445507169781) | 15 | 5 | 11 | 29492 | 9 | ||
| 145957 | 106020 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 181 Buena Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 771765 | 6001436.7 | 2108377.5 | 37.7692836023561 | -122.438357764726 | (37.7692836023561, -122.438357764726) | 15 | 5 | 5 | 29492 | 9 | ||||
| 149932 | 246048 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1260 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5999560.3375 | 2108450.212 | 37.7693763471978 | -122.444853213534 | (37.7693763471978, -122.444853213534) | 15 | 5 | 11 | 29492 | 9 | |||
| 150313 | 247265 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1569 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999051.8863 | 2109030.7763 | 37.7709413993737 | -122.446653693236 | (37.7709413993737, -122.446653693236) | 15 | 5 | 11 | 29492 | 9 | |||
| 151758 | 52032 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1569 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2005 12:00:00 AM | Permit Number 48244 | 5999066.25056435 | 2109026.34039487 | 37.7709300400132 | -122.446603687845 | (37.7709300400132, -122.446603687845) | 15 | 5 | 11 | 29492 | 9 | |||
| 153135 | 17091 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1637 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3X4 | 5999143 | 2109364 | 37.7718615511814 | -122.446362505197 | (37.7718615511814, -122.446362505197) | 15 | 5 | 11 | 29492 | 9 | ||
| 153161 | 247269 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1035 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999326.3938 | 2109239.9147 | 37.7715313170334 | -122.445719210419 | (37.7715313170334, -122.445719210419) | 15 | 5 | 11 | 29492 | 9 | |||
| 154713 | 107475 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1099x Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5999355.4 | 2109104.7 | 37.7711617078198 | -122.445609151717 | (37.7711617078198, -122.445609151717) | 15 | 5 | 11 | 29492 | 9 | |||
| 155027 | 41144 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 405 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1999 12:00:00 AM | Permit Number 41877 | 5997416.72400274 | 2109142.90365491 | 37.7711557324301 | -122.452317827144 | (37.7711557324301, -122.452317827144) | 15 | 5 | 11 | 29492 | 9 | |||
| 157808 | 108607 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1511 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774497 | 5999638.2 | 2107266.4 | 37.7661303401087 | -122.44449879944 | (37.7661303401087, -122.44449879944) | 15 | 5 | 5 | 29492 | 9 | |
| 158439 | 111017 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 90x DOWNEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/14/2015 12:00:00 AM | 3x3 | 5998894 | 2107683 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | 15 | 5 | 11 | 29492 | 9 | |||
| 158816 | 35707 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1581 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1998 12:00:00 AM | Permit Number 38994 | 5999843.88213258 | 2107010.45356576 | 37.7654393090201 | -122.44376899807 | (37.7654393090201, -122.44376899807) | 15 | 5 | 5 | 29492 | 9 | |||
| 162907 | 31815 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 47 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 3 | Permit Number 35282 | 6002376.91382 | 2108537.26016 | 37.7697756978145 | -122.43511704463 | (37.7697756978145, -122.43511704463) | 15 | 5 | 5 | 29492 | 9 | |
| 163620 | 225997 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 700 Duboce Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6002375.20249 | 2108318.05124 | 37.7691737069397 | -122.435107283376 | (37.7691737069397, -122.435107283376) | 15 | 5 | 5 | 29492 | 9 | |||
| 164158 | 14568 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1035X Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/13/2005 12:00:00 AM | 3 | 3X3 | 5999322.64051 | 2109314.43165 | 37.7717357073698 | -122.445737553038 | (37.7717357073698, -122.445737553038) | 15 | 5 | 11 | 29492 | 9 | ||
| 164277 | 14565 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1025 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/1999 12:00:00 AM | 22 | 3X3 | 5999322.9758 | 2109286.4848 | 37.7716589915577 | -122.445734383098 | (37.7716589915577, -122.445734383098) | 15 | 5 | 11 | 29492 | 9 | ||
| 168513 | 248452 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 733 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997923.3949 | 2107987.1864 | 37.7680114417823 | -122.450481911702 | (37.7680114417823, -122.450481911702) | 15 | 5 | 11 | 29492 | 9 | |||
| 172543 | 17090 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1637 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3X4 | 5999143 | 2109364 | 37.7718615511814 | -122.446362505197 | (37.7718615511814, -122.446362505197) | 15 | 5 | 11 | 29492 | 9 | ||
| 174593 | 226167 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 266 Upper Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 5999446.7745 | 2106130.84331 | 37.7630014609621 | -122.445079255819 | (37.7630014609621, -122.445079255819) | 15 | 5 | 5 | 29492 | 9 | |||
| 175766 | 14581 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1157 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 5999382.22391 | 2108862.87518 | 37.7704992495005 | -122.445498975466 | (37.7704992495005, -122.445498975466) | 15 | 5 | 11 | 29492 | 9 | |||
| 179647 | 226160 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 143 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997815.89337 | 2106775.03182 | 37.7646770202555 | -122.450766337324 | (37.7646770202555, -122.450766337324) | 15 | 5 | 11 | 29492 | 9 | |||
| 183095 | 225623 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 615 Buena Vista Ave West | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999830.8005 | 2107620.03218 | 37.7671123132949 | -122.443858043933 | (37.7671123132949, -122.443858043933) | 15 | 5 | 5 | 29492 | 9 | |||
| 188292 | 120948 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 1637 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3X4 | 5999143 | 2109364 | 37.7718615511814 | -122.446362505197 | (37.7718615511814, -122.446362505197) | 15 | 5 | 11 | 29492 | 9 | ||
| 188792 | 14574 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1125 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999367.196 | 2108956.8623 | 37.7707564564018 | -122.445557716473 | (37.7707564564018, -122.445557716473) | 15 | 5 | 11 | 29492 | 9 | |||
| 189120 | 225625 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1521 Piedmont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999695.53551 | 2107195.86271 | 37.7659399337052 | -122.44429541841 | (37.7659399337052, -122.44429541841) | 15 | 5 | 5 | 29492 | 9 | |||
| 193160 | 245043 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 327 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6001734.263 | 2109552.9566 | 37.7725280347604 | -122.437412694733 | (37.7725280347604, -122.437412694733) | 15 | 5 | 11 | 29492 | 9 | |||
| 193923 | 226174 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 1342 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5997819.92475 | 2105958.57143 | 37.7624354573459 | -122.45069352368 | (37.7624354573459, -122.45069352368) | 15 | 5 | 11 | 29492 | 9 | |||
| 5509 | 226294 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 410 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003702.40419 | 2096529.69179 | 37.7368809219105 | -122.429675682206 | (37.7368809219105, -122.429675682206) | 2 | 7 | 5 | 63 | 7 | |||
| 13365 | 225615 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 53 Wilder St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002593.03805 | 2095538.61045 | 37.73409676026 | -122.43344044482 | (37.73409676026, -122.43344044482) | 2 | 7 | 5 | 63 | 7 | |||
| 15669 | 226292 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 3 | Width 2ft | Permit Number 29820 | 6003335.67331 | 2095877.19361 | 37.7350685379825 | -122.430897079359 | (37.7350685379825, -122.430897079359) | 2 | 7 | 5 | 63 | 7 | |
| 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 | |||
| 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 | ||
| 24058 | 34407 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 151 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38155 | 6004576.44969274 | 2097521.36031941 | 37.7396532725762 | -122.426724317666 | (37.7396532725762, -122.426724317666) | 2 | 7 | 5 | 63 | 7 | ||
| 28883 | 34868 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 448 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2007 12:00:00 AM | 3x3 | Permit Number 49951 | 6003547.62609569 | 2096418.61112327 | 37.7365671542892 | -122.430202896046 | (37.7365671542892, -122.430202896046) | 2 | 7 | 5 | 63 | 7 | ||
| 30851 | 228335 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 61 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004305.62503 | 2097893.91637 | 37.7406609109864 | -122.427687250574 | (37.7406609109864, -122.427687250574) | 2 | 7 | 5 | 63 | 7 | |||
| 34467 | 226301 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 237 Miguel St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004214.52371 | 2096736.4573 | 37.7374776382742 | -122.427919787382 | (37.7374776382742, -122.427919787382) | 2 | 7 | 5 | 63 | 7 | |||
| 36391 | 228339 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 527 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003202.64576 | 2098317.85279 | 37.7417624896535 | -122.431531186829 | (37.7417624896535, -122.431531186829) | 2 | 7 | 5 | 63 | 7 | |||
| 37589 | 30334 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1956 12:00:00 AM | 4 | Permit Number 24 | 6002605.63749 | 2098861.8554 | 37.7432223384343 | -122.433634311668 | (37.7432223384343, -122.433634311668) | 2 | 7 | 5 | 63 | 7 | ||
| 42158 | 43568 | Section 143 10 | Ginkgo biloba :: Maidenhair Tree 22 | 601 29TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2000 12:00:00 AM | Permit Number 43230 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 | |||
| 47676 | 226300 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 237 Miguel St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004226.85436 | 2096722.26162 | 37.7374393577311 | -122.427876143295 | (37.7374393577311, -122.427876143295) | 2 | 7 | 5 | 63 | 7 | |||
| 51190 | 226298 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 595 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002933.74863 | 2095882.33376 | 37.7350598703022 | -122.432287042711 | (37.7350598703022, -122.432287042711) | 2 | 7 | 5 | 63 | 7 | |||
| 53229 | 64416 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 18 Harper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50677 | 6003642.17980217 | 2098229.65792649 | 37.7415452293262 | -122.430005134049 | (37.7415452293262, -122.430005134049) | 2 | 7 | 5 | 63 | 7 |
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) );