Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84 | 84 | 36641 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 151 | 151 | 36617 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 2699 | 2699 | 36646 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 3744 | 3744 | 46296 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 5431 | 5431 | 36639 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 5873 | 5873 | 36615 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 6779 | 6779 | 46294 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 6865 | 6865 | 36611 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 7062 | 7062 | 36619 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 7666 | 7666 | 46298 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 7930 | 7930 | 36612 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 8174 | 8174 | 46307 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 8582 | 8582 | 46301 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10042 | 10042 | 46306 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10274 | 10274 | 36628 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 11352 | 11352 | 36626 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 11431 | 11431 | 36634 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 11478 | 11478 | 46299 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11482 | 11482 | 46287 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11512 | 11512 | 46295 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11803 | 11803 | 36638 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 11891 | 11891 | 46292 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 11947 | 11947 | 36645 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 12840 | 12840 | 46293 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 13101 | 13101 | 36633 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13115 | 13115 | 46288 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 13209 | 13209 | 46297 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 13547 | 13547 | 36637 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 14249 | 14249 | 46286 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 14257 | 14257 | 36614 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 14557 | 14557 | 36644 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 14637 | 14637 | 46290 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 14655 | 14655 | 36640 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 14793 | 14793 | 46305 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 14984 | 14984 | 46289 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 15590 | 15590 | 46300 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 15725 | 15725 | 36613 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 16039 | 16039 | 36642 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 16196 | 16196 | 46309 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 16545 | 16545 | 36647 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 17058 | 17058 | 46308 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 17064 | 17064 | 36643 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 19475 | 19475 | 35527 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 19841 | 19841 | 38990 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 300x SAN BRUNO AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1998 12:00:00 AM | 3x3 | Permit Number 40762 | 6010766.0 | 2106510.0 | 37.7646820959843 | -122.405956443868 | (37.7646820959843, -122.405956443868) | ||
| 77517 | 77517 | 35524 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 77628 | 77628 | 36000 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 131 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39149 | 6007256.30049385 | 2100148.76255182 | 37.747018680703896 | -122.417644695138 | (37.7470186807039, -122.417644695138) | ||
| 78590 | 78590 | 34418 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 64 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38166 | 6004900.21604915 | 2096164.55267564 | 37.7359460847085 | -122.42550833553801 | (37.7359460847085, -122.425508335538) | ||
| 80571 | 80571 | 46488 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 81257 | 81257 | 36074 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1698 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39188 | 6009436.87915174 | 2106885.74849241 | 37.765639390111495 | -122.41058007625799 | (37.7656393901115, -122.410580076258) | ||
| 82095 | 82095 | 46494 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 82506 | 82506 | 46489 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 82686 | 82686 | 38987 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 2222 17th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1998 12:00:00 AM | Permit Number 40762 | 6010839.10372464 | 2106501.59245712 | 37.76466309906579 | -122.405703003871 | (37.7646630990658, -122.405703003871) | |||
| 82858 | 82858 | 35525 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 85968 | 85968 | 46487 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 86554 | 86554 | 35529 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 87029 | 87029 | 46492 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 90376 | 90376 | 36041 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 301X Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 6 | 3x3 | Permit Number 39179 | 6009338.32298804 | 2106840.01874439 | 37.7655083007999 | -122.410917731606 | (37.7655083007999, -122.410917731606) |
| 91364 | 91364 | 35538 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 92152 | 92152 | 35435 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1514 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | 3x3 | Permit Number 38880 | 6014194.08885176 | 2102020.82707827 | 37.7525469295741 | -122.39378525261299 | (37.7525469295741, -122.393785252613) | |
| 92269 | 92269 | 44115 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1201 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 92418 | 92418 | 37559 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 4594 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1998 12:00:00 AM | Permit Number 39998 | 6000674.90246955 | 2104685.2740174998 | 37.759102303165605 | -122.44072789588999 | (37.7591023031656, -122.44072789589) | ||
| 93549 | 93549 | 35536 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 93901 | 93901 | 36073 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1698 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39188 | 6009436.87915174 | 2106885.74849241 | 37.765639390111495 | -122.41058007625799 | (37.7656393901115, -122.410580076258) | ||
| 93989 | 93989 | 36672 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 457 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1998 12:00:00 AM | Permit Number 39477 | 6005735.93332795 | 2107818.71066292 | 37.7679928978661 | -122.423447182489 | (37.7679928978661, -122.423447182489) | ||
| 94241 | 94241 | 35526 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 94282 | 94282 | 34775 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1145 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/1999 12:00:00 AM | Permit Number 38416 | 6008085.68416499 | 2101261.0887257 | 37.75011951465971 | -122.414855460522 | (37.7501195146597, -122.414855460522) | ||
| 96987 | 96987 | 50268 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 147 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46973 | 6005807.11718948 | 2096411.27150888 | 37.7366747197464 | -122.422390336958 | (37.7366747197464, -122.422390336958) | ||
| 97772 | 97772 | 46493 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 98021 | 98021 | 33946 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 25 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42141 | 6001858.66846753 | 2097007.25574596 | 37.73808762890771 | -122.436084445276 | (37.7380876289077, -122.436084445276) | ||
| 100313 | 100313 | 38497 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1520 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | Permit Number 40490 | 6005748.46647316 | 2118616.2123206 | 37.7976408885127 | -122.424171827672 | (37.7976408885127, -122.424171827672) | ||
| 101568 | 101568 | 35532 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 102569 | 102569 | 37003 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 828 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39617 | 6009083.10431262 | 2104329.64902172 | 37.758601085143496 | -122.411623093438 | (37.7586010851435, -122.411623093438) | ||
| 103161 | 103161 | 35528 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 103774 | 103774 | 46500 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 104544 | 104544 | 35539 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2000 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 105197 | 105197 | 46498 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 105969 | 105969 | 37558 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 4588 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1998 12:00:00 AM | Permit Number 39997 | 6000700.02346918 | 2104687.31346877 | 37.7591093335704 | -122.44064116202298 | (37.7591093335704, -122.440641162023) | ||
| 106124 | 106124 | 34440 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 301 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38184 | 6001229.40575975 | 2096509.00524046 | 37.736683779153104 | -122.438224431893 | (37.7366837791531, -122.438224431893) | ||
| 106316 | 106316 | 72639 | Undocumented 2 | Robinia x ambigua :: Locust 33 | 2440 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 6009346.21174541 | 2106892.53366488 | 37.7656529370509 | -122.41089415541 | (37.7656529370509, -122.41089415541) | ||||
| 106536 | 106536 | 46490 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 106825 | 106825 | 46497 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 108288 | 108288 | 34019 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 2435 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37953 | 6009365.21355267 | 2106841.50384937 | 37.7655138863763 | -122.410824827738 | (37.7655138863763, -122.410824827738) | ||
| 109867 | 109867 | 35540 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 110046 | 110046 | 34449 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 88 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38193 | 6004276.20004754 | 2097640.39682437 | 37.7399631396588 | -122.42777093173201 | (37.7399631396588, -122.427770931732) | ||
| 112043 | 112043 | 39564 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1051 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40985 | 6009467.03980807 | 2103058.10421431 | 37.755131238817796 | -122.41020549151699 | (37.7551312388178, -122.410205491517) | ||
| 112056 | 112056 | 46499 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 112749 | 112749 | 46501 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 113115 | 113115 | 35530 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 113319 | 113319 | 46491 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 690 Natoma St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44675 | 6009114.7502002 | 2110993.01106453 | 37.7768989104646 | -122.41198453248501 | (37.7768989104646, -122.411984532485) | |||
| 114375 | 114375 | 73792 | Undocumented 2 | Robinia x ambigua :: Locust 33 | 2440 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 6009314.1 | 2107045.9 | 37.7660722450681 | -122.411016056946 | (37.7660722450681, -122.411016056946) | ||||
| 115699 | 115699 | 36043 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 2445 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | Permit Number 39179 | 6009338.32298804 | 2106840.01874439 | 37.7655083007999 | -122.410917731606 | (37.7655083007999, -122.410917731606) | ||
| 116625 | 116625 | 34430 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 322 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38174 | 6001453.16813415 | 2096240.6433294998 | 37.735959643659704 | -122.437431578707 | (37.7359596436597, -122.437431578707) | ||
| 117735 | 117735 | 34020 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 2435 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37953 | 6009365.21355267 | 2106841.50384937 | 37.7655138863763 | -122.410824827738 | (37.7655138863763, -122.410824827738) | ||
| 118693 | 118693 | 36042 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 301X Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/1998 12:00:00 AM | 8 | 3x3 | Permit Number 39179 | 6009338.32298804 | 2106840.01874439 | 37.7655083007999 | -122.410917731606 | (37.7655083007999, -122.410917731606) |
| 119722 | 119722 | 34406 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 130 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38154 | 6004721.2924636 | 2097581.55189739 | 37.7398267330165 | -122.4262277974 | (37.7398267330165, -122.4262277974) | ||
| 119971 | 119971 | 35533 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 90 Bartlett St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 774464 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
| 120334 | 120334 | 39494 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 4063 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | Permit Number 40952 | 6003485.45647041 | 2100659.48775256 | 37.748208101214 | -122.43072038304199 | (37.748208101214, -122.430720383042) | ||
| 121212 | 121212 | 38499 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1520 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | Permit Number 40490 | 6005748.46647316 | 2118616.2123206 | 37.7976408885127 | -122.424171827672 | (37.7976408885127, -122.424171827672) | ||
| 121299 | 121299 | 38498 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1520 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | Permit Number 40490 | 6005748.46647316 | 2118616.2123206 | 37.7976408885127 | -122.424171827672 | (37.7976408885127, -122.424171827672) | ||
| 122751 | 122751 | 35424 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 1455 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | Permit Number 38874 | 6014371.26357755 | 2101978.65137619 | 37.7524409683122 | -122.393169596439 | (37.7524409683122, -122.393169596439) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");