trees

118 rows where qSpecies_id = 196 sorted by XCoord

✎ 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                    
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                    
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                    
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                    
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
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
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
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
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
186279 34435 Permitted Site 7 Robinia x ambigua :: Locust 196 80 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38179 6002420.67222172 2096648.92518291 37.7371356486651 -122.434115712112 (37.7371356486651, -122.434115712112) 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
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
166174 34406 Permitted Site 7 Robinia x ambigua :: Locust 196 130 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38154 6004721.2924636 2097581.55189739 37.7398267330165 -122.4262277974 (37.7398267330165, -122.4262277974) 2 7 5 63 7
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
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
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
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
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
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
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
182994 42031 Permitted Site 7 Robinia x ambigua :: Locust 196 81 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42353 6005882.26774937 2099037.35430724 37.7438895917791 -122.422317035839 (37.7438895917791, -122.422317035839) 2 7 7 28859 2
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
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
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
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
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
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
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
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
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
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
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
177386 35534 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 8 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
178378 35523 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 18 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
183950 35535 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 6 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
193174 35541 Permitted Site 7 Robinia x ambigua :: Locust 196 90 Bartlett St 7 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
171335 37467 Permitted Site 7 Robinia x ambigua :: Locust 196 355 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1998 12:00:00 AM     Permit Number 39938 6007114.01835891 2096301.73504967 37.73644759333 -122.417864041261 (37.73644759333, -122.417864041261) 2 7 7 28859 2
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
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
186193 43104 Permitted Site 7 Robinia x ambigua :: Locust 196 699 O'Farrell St 1 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
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
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
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
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
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
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
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
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
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
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
172707 46495 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 7 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
187268 46496 Permitted Site 7 Robinia x ambigua :: Locust 196 690 Natoma St 5 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
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

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