Street_Tree_List

Data source: data.sfgov.org

118 rows where qSpecies = 33

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 52.627ms · Data source: data.sfgov.org