trees
118 rows where qSpecies_id = 196
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 |
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) );