trees

118 rows where qSpecies_id = 196

✎ View and edit SQL

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)
1600 46288 Permitted Site 7 Robinia x ambigua :: Locust 196   15 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
2241 46289 Permitted Site 7 Robinia x ambigua :: Locust 196   14 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
2677 36640 Permitted Site 7 Robinia x ambigua :: Locust 196   14 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
3832 36644 Permitted Site 7 Robinia x ambigua :: Locust 196   10 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
4114 46287 Permitted Site 7 Robinia x ambigua :: Locust 196   16 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
4433 35537 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
4745 46309 Permitted Site 7 Robinia x ambigua :: Locust 196   18 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
4832 36642 Permitted Site 7 Robinia x ambigua :: Locust 196   12 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
4857 36617 Permitted Site 7 Robinia x ambigua :: Locust 196   8 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
5126 46308 Permitted Site 7 Robinia x ambigua :: Locust 196   11 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
5599 46306 Permitted Site 7 Robinia x ambigua :: Locust 196   19 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
5818 36637 Permitted Site 7 Robinia x ambigua :: Locust 196   17 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
6174 46305 Permitted Site 7 Robinia x ambigua :: Locust 196   8 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
6599 46295 Permitted Site 7 Robinia x ambigua :: Locust 196   7 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
6709 46301 Permitted Site 7 Robinia x ambigua :: Locust 196   1 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
7493 46307 Permitted Site 7 Robinia x ambigua :: Locust 196   20 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
7838 36619 Permitted Site 7 Robinia x ambigua :: Locust 196   1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
9187 46298 Permitted Site 7 Robinia x ambigua :: Locust 196   4 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
9681 46299 Permitted Site 7 Robinia x ambigua :: Locust 196   3 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
9888 36643 Permitted Site 7 Robinia x ambigua :: Locust 196   11 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
10321 38990 Permitted Site 7 Robinia x ambigua :: Locust 196 300x SAN BRUNO AVE 7 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1998 12:00:00 AM   3x3 Permit Number 40762 6010766 2106510 37.7646820959843 -122.405956443868 (37.7646820959843, -122.405956443868) 8 4 8 28853 19
10507 36634 Permitted Site 7 Robinia x ambigua :: Locust 196   20 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
10580 36639 Permitted Site 7 Robinia x ambigua :: Locust 196   15 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
10593 36646 Permitted Site 7 Robinia x ambigua :: Locust 196   18 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
10706 46293 Permitted Site 7 Robinia x ambigua :: Locust 196   9 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
10708 36615 Permitted Site 7 Robinia x ambigua :: Locust 196   2 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
11306 46296 Permitted Site 7 Robinia x ambigua :: Locust 196   13 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
12311 46292 Permitted Site 7 Robinia x ambigua :: Locust 196   10 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
12900 36638 Permitted Site 7 Robinia x ambigua :: Locust 196   21 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
13032 36614 Permitted Site 7 Robinia x ambigua :: Locust 196   3 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
13773 36645 Permitted Site 7 Robinia x ambigua :: Locust 196   9 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
14098 36611 Permitted Site 7 Robinia x ambigua :: Locust 196   6 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
14365 35527 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
14663 46294 Permitted Site 7 Robinia x ambigua :: Locust 196   17 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
14718 46286 Permitted Site 7 Robinia x ambigua :: Locust 196   6 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
15111 46290 Permitted Site 7 Robinia x ambigua :: Locust 196   12 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
15167 36647 Permitted Site 7 Robinia x ambigua :: Locust 196   19 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
16025 36612 Permitted Site 7 Robinia x ambigua :: Locust 196   5 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
16860 36626 Permitted Site 7 Robinia x ambigua :: Locust 196   7 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
16883 46300 Permitted Site 7 Robinia x ambigua :: Locust 196   2 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
16916 36628 Permitted Site 7 Robinia x ambigua :: Locust 196   16 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
18316 46297 Permitted Site 7 Robinia x ambigua :: Locust 196   5 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
18425 36641 Permitted Site 7 Robinia x ambigua :: Locust 196   13 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
19137 36613 Permitted Site 7 Robinia x ambigua :: Locust 196   4 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
19406 36633 Permitted Site 7 Robinia x ambigua :: Locust 196   22 Sidewalk: Curb side : Cutout Tree Private 2   05/20/1998 12:00:00 AM     Permit Number 39461                    
19953 43103 Permitted Site 7 Robinia x ambigua :: Locust 196 699 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2000 12:00:00 AM     Permit Number 42934 6007951.25806045 2114079.25416065 37.7853076453495 -122.416228053408 (37.7853076453495, -122.416228053408) 7 10 9 28858 36
25356 35524 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
36415 36039 Permitted Site 7 Robinia x ambigua :: Locust 196 301X Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM 6 3x3 Permit Number 39179 6009338.32298804 2106840.01874439 37.7655083007999 -122.410917731606 (37.7655083007999, -122.410917731606) 8 4 7 28859 19
36684 36671 Permitted Site 7 Robinia x ambigua :: Locust 196 457 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/22/1998 12:00:00 AM 10 4x4 Permit Number 39477 6005735.93332795 2107818.71066292 37.7679928978661 -122.423447182489 (37.7679928978661, -122.423447182489) 8 4 5 28853 19
38054 36000 Permitted Site 7 Robinia x ambigua :: Locust 196 131 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39149 6007256.30049385 2100148.76255182 37.7470186807039 -122.417644695138 (37.7470186807039, -122.417644695138) 2 7 7 28859 2
40716 36074 Permitted Site 7 Robinia x ambigua :: Locust 196 1698 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39188 6009436.87915174 2106885.74849241 37.7656393901115 -122.410580076258 (37.7656393901115, -122.410580076258) 8 4 7 28853 19
40831 34418 Permitted Site 7 Robinia x ambigua :: Locust 196 64 Richland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38166 6004900.21604915 2096164.55267564 37.7359460847085 -122.425508335538 (37.7359460847085, -122.425508335538) 2 7 5 28859 2
42602 46494 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
45701 46488 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 15 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
54383 46489 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 14 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
55148 38987 Permitted Site 7 Robinia x ambigua :: Locust 196 2222 17th St 11 Sidewalk: Curb side : Cutout Tree Private 2   11/17/1998 12:00:00 AM     Permit Number 40762 6010839.10372464 2106501.59245712 37.7646630990658 -122.405703003871 (37.7646630990658, -122.405703003871) 8 4 8 28853 19
55196 35525 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 16 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
61515 46492 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
66524 36041 Permitted Site 7 Robinia x ambigua :: Locust 196 301X Florida St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM 6 3x3 Permit Number 39179 6009338.32298804 2106840.01874439 37.7655083007999 -122.410917731606 (37.7655083007999, -122.410917731606) 8 4 7 28859 19
66848 35529 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
72573 46487 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
81364 35536 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
81754 35526 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
83379 44115 Permitted Site 7 Robinia x ambigua :: Locust 196 1201 Treat Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.412744337506 (37.7509254812099, -122.412744337506) 2 4 7 28859 19
84195 35538 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
86568 36073 Permitted Site 7 Robinia x ambigua :: Locust 196 1698 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1998 12:00:00 AM     Permit Number 39188 6009436.87915174 2106885.74849241 37.7656393901115 -122.410580076258 (37.7656393901115, -122.410580076258) 8 4 7 28853 19
86990 35435 Permitted Site 7 Robinia x ambigua :: Locust 196 1514 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM   3x3 Permit Number 38880 6014194.08885176 2102020.82707827 37.7525469295741 -122.393785252613 (37.7525469295741, -122.393785252613) 10 3 8 28856 29
87609 37559 Permitted Site 7 Robinia x ambigua :: Locust 196 4594 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/1998 12:00:00 AM     Permit Number 39998 6000674.90246955 2104685.2740175 37.7591023031656 -122.44072789589 (37.7591023031656, -122.44072789589) 2 4 5 28862 3
88219 50268 Permitted Site 7 Robinia x ambigua :: Locust 196 147 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/2003 12:00:00 AM     Permit Number 46973 6005807.11718948 2096411.27150888 37.7366747197464 -122.422390336958 (37.7366747197464, -122.422390336958) 2 7 7 28859 2
88878 36672 Permitted Site 7 Robinia x ambigua :: Locust 196 457 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/1998 12:00:00 AM     Permit Number 39477 6005735.93332795 2107818.71066292 37.7679928978661 -122.423447182489 (37.7679928978661, -122.423447182489) 8 4 5 28853 19
90438 34775 Permitted Site 7 Robinia x ambigua :: Locust 196 1145 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/21/1999 12:00:00 AM     Permit Number 38416 6008085.68416499 2101261.0887257 37.7501195146597 -122.414855460522 (37.7501195146597, -122.414855460522) 2 4 7 28859 19
93419 33946 Permitted Site 7 Robinia x ambigua :: Locust 196 25 Conrad St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/2000 12:00:00 AM     Permit Number 42141 6001858.66846753 2097007.25574596 37.7380876289077 -122.436084445276 (37.7380876289077, -122.436084445276) 2 7 5 63 7
97295 37003 Permitted Site 7 Robinia x ambigua :: Locust 196 828 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39617 6009083.10431262 2104329.64902172 37.7586010851435 -122.411623093438 (37.7586010851435, -122.411623093438) 2 4 7 28859 19
102726 38497 Permitted Site 7 Robinia x ambigua :: Locust 196 1520 Green St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1998 12:00:00 AM     Permit Number 40490 6005748.46647316 2118616.2123206 37.7976408885127 -122.424171827672 (37.7976408885127, -122.424171827672) 13 9 1 57 17
102785 35528 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
104216 35532 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
105312 46493 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
112643 46500 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
116694 37558 Permitted Site 7 Robinia x ambigua :: Locust 196 4588 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/25/1998 12:00:00 AM     Permit Number 39997 6000700.02346918 2104687.31346877 37.7591093335704 -122.440641162023 (37.7591093335704, -122.440641162023) 2 4 5 28862 3
119927 72639 Undocumented 4 Robinia x ambigua :: Locust 196 2440 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/15/1997 12:00:00 AM       6009346.21174541 2106892.53366488 37.7656529370509 -122.41089415541 (37.7656529370509, -122.41089415541) 8 4 7 28853 19
122420 46490 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 13 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
122543 46497 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
124345 46498 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
128422 34449 Permitted Site 7 Robinia x ambigua :: Locust 196 88 Whitney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38193 6004276.20004754 2097640.39682437 37.7399631396588 -122.427770931732 (37.7399631396588, -122.427770931732) 2 7 5 63 7
129230 35539 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/19/2000 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
131092 35540 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 11 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
131151 34019 Permitted Site 7 Robinia x ambigua :: Locust 196 2435 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/1997 12:00:00 AM     Permit Number 37953 6009365.21355267 2106841.50384937 37.7655138863763 -122.410824827738 (37.7655138863763, -122.410824827738) 8 4 7 28859 19
132612 34440 Permitted Site 7 Robinia x ambigua :: Locust 196 301 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38184 6001229.40575975 2096509.00524046 37.7366837791531 -122.438224431893 (37.7366837791531, -122.438224431893) 2 7 5 63 7
134979 46499 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
136370 46501 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
139326 36043 Permitted Site 7 Robinia x ambigua :: Locust 196 2445 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/27/1998 12:00:00 AM     Permit Number 39179 6009338.32298804 2106840.01874439 37.7655083007999 -122.410917731606 (37.7655083007999, -122.410917731606) 8 4 7 28859 19
140697 39564 Permitted Site 7 Robinia x ambigua :: Locust 196 1051 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40985 6009467.03980807 2103058.10421431 37.7551312388178 -122.410205491517 (37.7551312388178, -122.410205491517) 2 4 7 28859 19
143546 46491 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 12 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44675 6009114.7502002 2110993.01106453 37.7768989104646 -122.411984532485 (37.7768989104646, -122.411984532485) 8 2 9 28853 34
144941 35530 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
145787 73792 Undocumented 4 Robinia x ambigua :: Locust 196 2440 16TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/15/1997 12:00:00 AM       6009314.1 2107045.9 37.7660722450681 -122.411016056946 (37.7660722450681, -122.411016056946) 8 4 7 28853 19
150366 34430 Permitted Site 7 Robinia x ambigua :: Locust 196 322 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38174 6001453.16813415 2096240.6433295 37.7359596436597 -122.437431578707 (37.7359596436597, -122.437431578707) 2 7 5 63 7
153124 39494 Permitted Site 7 Robinia x ambigua :: Locust 196 4063 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/1998 12:00:00 AM     Permit Number 40952 6003485.45647041 2100659.48775256 37.748208101214 -122.430720383042 (37.748208101214, -122.430720383042) 2 4 5 63 22
153337 38498 Permitted Site 7 Robinia x ambigua :: Locust 196 1520 Green St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1998 12:00:00 AM     Permit Number 40490 6005748.46647316 2118616.2123206 37.7976408885127 -122.424171827672 (37.7976408885127, -122.424171827672) 13 9 1 57 17
153524 35533 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 774464 6006649.40506175 2103262.44015502 37.7555339585812 -122.419964211868 (37.7555339585812, -122.419964211868) 2 4 7 28859 19
160809 38499 Permitted Site 7 Robinia x ambigua :: Locust 196 1520 Green St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1998 12:00:00 AM     Permit Number 40490 6005748.46647316 2118616.2123206 37.7976408885127 -122.424171827672 (37.7976408885127, -122.424171827672) 13 9 1 57 17

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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