trees
11,761 rows where qSpecies_id = 17 sorted by SiteOrder descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158134 | 52698 | Permitted Site 7 | Tree(s) :: 17 | 950 Mason St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2006 12:00:00 AM | Permit Number 48765 | 6009564.39642774 | 2116599.60561075 | 37.7923184964294 | -122.410825126139 | (37.7923184964294, -122.410825126139) | 5 | 1 | 10 | 28857 | 21 | |||
163305 | 93615 | Undocumented 4 | Tree(s) :: 17 | 3865 Sacramento St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 53255 | 5996391.2 | 2114920.9 | 37.7869617823748 | -122.456282979232 | (37.7869617823748, -122.456282979232) | 11 | 6 | 1 | 54 | 31 | ||
168525 | 100786 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
172170 | 40888 | Permitted Site 7 | Tree(s) :: 17 | 296 Addison St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1999 12:00:00 AM | Permit Number 41792 | 6002404.57266151 | 2097761.95623276 | 37.740190860742 | -122.434250923896 | (37.740190860742, -122.434250923896) | 2 | 7 | 5 | 63 | 7 | |||
178130 | 38414 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
178634 | 35630 | Permitted Site 7 | Tree(s) :: 17 | 701 Hayes St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38975 | 6004496.45349332 | 2110824.80795168 | 37.7761768741411 | -122.427948642674 | (37.7761768741411, -122.427948642674) | 7 | 9 | 11 | 28852 | 10 | |||
182068 | 871 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
182157 | 41475 | Permitted Site 7 | Tree(s) :: 17 | 950 Gilman Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/2000 12:00:00 AM | Permit Number 42054 | 6015962.09659706 | 2089242.12854286 | 37.7175572910835 | -122.38678005587 | (37.7175572910835, -122.38678005587) | 10 | 3 | 8 | 58 | 1 | |||
183454 | 45672 | Permitted Site 7 | Tree(s) :: 17 | 650 Alabama St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | Permit Number 44366 | 6008969.6935687 | 2105201.49988904 | 37.7609886266628 | -122.412076935363 | (37.7609886266628, -122.412076935363) | 2 | 4 | 7 | 28859 | 19 | |||
184613 | 116137 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
185770 | 32260 | Permitted Site 7 | Tree(s) :: 17 | 1601 Mission St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/1995 12:00:00 AM | Permit Number 35559 | 6007188.44453353 | 2109602.50556833 | 37.7729726509951 | -122.41854960025 | (37.7729726509951, -122.41854960025) | 8 | 2 | 9 | 28853 | 19 | |||
185844 | 91410 | Permitted Site 7 | Tree(s) :: 17 | 1275 Indiana St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2007 12:00:00 AM | 3x3 | Permit Number 49180 | 6015357 | 2102644 | 37.754322586427 | -122.389807196723 | (37.754322586427, -122.389807196723) | 10 | 3 | 8 | 28856 | 29 | ||
187847 | 43993 | Permitted Site 7 | Tree(s) :: 17 | 141 Hampshire St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2000 12:00:00 AM | Permit Number 43551 | 6009974.46243584 | 2107504.86062599 | 37.767369454596 | -122.408764367283 | (37.767369454596, -122.408764367283) | 8 | 4 | 8 | 28853 | 19 | |||
190840 | 35651 | Permitted Site 7 | Tree(s) :: 17 | 634 Fell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38978 | 6004381.87189495 | 2110513.06412186 | 37.7753144191066 | -122.428322787793 | (37.7753144191066, -122.428322787793) | 7 | 9 | 11 | 28852 | 10 | |||
191826 | 109304 | Undocumented 4 | Tree(s) :: 17 | 251 RHODE ISLAND ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774538 | 6011759.4 | 2107238.5 | 37.7667379021668 | -122.402571748171 | (37.7667379021668, -122.402571748171) | 8 | 2 | 8 | 28853 | 20 | |
193321 | 38757 | Permitted Site 7 | Tree(s) :: 17 | 133 Shipley St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/20/1998 12:00:00 AM | Permit Number 40630 | 6012231.96307802 | 2112402.8191024 | 37.780944316304 | -122.401300174029 | (37.780944316304, -122.401300174029) | 6 | 2 | 9 | 28856 | 34 | |||
548 | 48279 | Permitted Site 7 | Tree(s) :: 17 | 89 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
11639 | 44705 | Permitted Site 7 | Tree(s) :: 17 | 89 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
12793 | 45869 | Permitted Site 7 | Tree(s) :: 17 | 89 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
15662 | 45017 | Permitted Site 7 | Tree(s) :: 17 | 89 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
2189 | 48278 | Permitted Site 7 | Tree(s) :: 17 | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
6768 | 45870 | Permitted Site 7 | Tree(s) :: 17 | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
7406 | 44704 | Permitted Site 7 | Tree(s) :: 17 | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
10277 | 45016 | Permitted Site 7 | Tree(s) :: 17 | 88 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
12641 | 45871 | Permitted Site 7 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
14379 | 48277 | Permitted Site 7 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
15278 | 45015 | Permitted Site 7 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
18725 | 44694 | Permitted Site 7 | Tree(s) :: 17 | 87 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
8343 | 44702 | Permitted Site 7 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
8899 | 48276 | Permitted Site 7 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
13352 | 45014 | Permitted Site 7 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
13851 | 45847 | Permitted Site 7 | Tree(s) :: 17 | 86 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2516 | 45863 | Permitted Site 7 | Tree(s) :: 17 | 85 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
3794 | 44711 | Permitted Site 7 | Tree(s) :: 17 | 85 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
3876 | 48275 | Permitted Site 7 | Tree(s) :: 17 | 85 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
7509 | 45013 | Permitted Site 7 | Tree(s) :: 17 | 85 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
960 | 45842 | Permitted Site 7 | Tree(s) :: 17 | 84 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
10922 | 48274 | Permitted Site 7 | Tree(s) :: 17 | 84 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
10997 | 44700 | Permitted Site 7 | Tree(s) :: 17 | 84 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
15076 | 45012 | Permitted Site 7 | Tree(s) :: 17 | 84 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
333 | 44989 | Permitted Site 7 | Tree(s) :: 17 | 83 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
6958 | 44699 | Permitted Site 7 | Tree(s) :: 17 | 83 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
7514 | 48273 | Permitted Site 7 | Tree(s) :: 17 | 83 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
14894 | 45843 | Permitted Site 7 | Tree(s) :: 17 | 83 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
2076 | 44958 | Permitted Site 7 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
5968 | 45844 | Permitted Site 7 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
15402 | 48272 | Permitted Site 7 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
18279 | 44698 | Permitted Site 7 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
1461 | 44992 | Permitted Site 7 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
3086 | 48271 | Permitted Site 7 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
15427 | 44697 | Permitted Site 7 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
17519 | 45845 | Permitted Site 7 | Tree(s) :: 17 | 81 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
121762 | 186803 | DPW Maintained 1 | Tree(s) :: 17 | 1200 Sunset Blvd | 81 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984854.4903 | 2106938.312 | 37.7643748688283 | -122.495607779566 | (37.7643748688283, -122.495607779566) | 1 | 8 | 3 | 56 | 35 | |||
5379 | 44696 | Permitted Site 7 | Tree(s) :: 17 | 80 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
6117 | 44967 | Permitted Site 7 | Tree(s) :: 17 | 80 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
9248 | 45846 | Permitted Site 7 | Tree(s) :: 17 | 80 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
17527 | 48187 | Permitted Site 7 | Tree(s) :: 17 | 80 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
521 | 100638 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
1892 | 124739 | DPW Maintained 1 | Tree(s) :: 17 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010535.71931722 | 2108464.76902983 | 37.7700365636667 | -122.406890710328 | (37.7700365636667, -122.406890710328) | 14 | 2 | 9 | 28853 | 34 | |||||
3363 | 44550 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/2001 12:00:00 AM | Permit Number 43835 | ||||||||||||||
3790 | 262255 | Undocumented 4 | Tree(s) :: 17 | 4210 Ocean Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785453 | 5986512 | 2095174 | 37.7321701636719 | -122.489010079787 | (37.7321701636719, -122.489010079787) | 1 | 8 | 4 | 64 | 35 | |
4769 | 36649 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1998 12:00:00 AM | Permit Number 39461 | ||||||||||||||
5258 | 34916 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38517 | |||||||||||||||
6983 | 48226 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | Permit Number 45761 | ||||||||||||||
8027 | 44842 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/25/2001 12:00:00 AM | Permit Number 43922 | ||||||||||||||
9217 | 48476 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 45832 | |||||||||||||||
10202 | 261492 | DPW Maintained 1 | Tree(s) :: 17 | 1100X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | 10x10 | 5995262 | 2098056 | 37.7405902419398 | -122.458968175006 | (37.7405902419398, -122.458968175006) | 1 | 7 | 4 | 59 | 40 | ||||
14935 | 212498 | DPW Maintained 1 | Tree(s) :: 17 | 51 Sotelo Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/09/2019 12:00:00 AM | 3 | Width 4ft | Permit Number 784592 | 5993879 | 2101255 | 37.7492942917049 | -122.463982175947 | (37.7492942917049, -122.463982175947) | 1 | 8 | 4 | 29491 | 40 | |
16232 | 262057 | DPW Maintained 1 | Tree(s) :: 17 | 851X Alemany Blvd | 8 | Side Yard : Yard | Tree | DPW 1 | 3x3 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | ||||
17247 | 84762 | Permitted Site 7 | Tree(s) :: 17 | 185 Berry St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | Permit No. 49299 | 6014606 | 2110554 | 37.7760000408576 | -122.392957754299 | (37.7760000408576, -122.392957754299) | 6 | 2 | 9 | 28856 | 20 | |||
17452 | 97358 | Permitted Site 7 | Tree(s) :: 17 | 8 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
18165 | 35054 | Permitted Site 7 | Tree(s) :: 17 | 700 Peninsula Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1998 12:00:00 AM | Permit Number 38613 | |||||||||||||
18934 | 45879 | Permitted Site 7 | Tree(s) :: 17 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2001 12:00:00 AM | Permit Number 44451 | ||||||||||||||
21419 | 100996 | Undocumented 4 | Tree(s) :: 17 | 1675 Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009464 | 2106858 | 37.7655647195855 | -122.410484311247 | (37.7655647195855, -122.410484311247) | 8 | 4 | 7 | 28853 | 19 | ||||
23081 | 40913 | Permitted Site 7 | Tree(s) :: 17 | 720 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1999 12:00:00 AM | Permit Number 41793 | 6012338.0511994 | 2113764.09224404 | 37.7846879743619 | -122.401028836502 | (37.7846879743619, -122.401028836502) | 12 | 2 | 9 | 28853 | 6 | |||
25549 | 88038 | Permitted Site 7 | Tree(s) :: 17 | 2301X Lyon St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51052 | 5999233.8 | 2116707.1 | 37.7920289857283 | -122.446576825179 | (37.7920289857283, -122.446576825179) | 11 | 6 | 1 | 29490 | 30 | ||
30424 | 52834 | Permitted Site 7 | Tree(s) :: 17 | 750WASHINGTON Kearny St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2006 12:00:00 AM | Permit Number 48852 | 6011321.66526904 | 2117544.92566145 | 37.7950124931599 | -122.404811486899 | (37.7950124931599, -122.404811486899) | 3 | 1 | 10 | 28857 | 4 | |||
32060 | 92507 | Permitted Site 7 | Tree(s) :: 17 | 645 05th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2009 12:00:00 AM | 3x3 | Permit Number 52871 | 6013168 | 2110572 | 37.7759694836049 | -122.39793347089 | (37.7759694836049, -122.39793347089) | 6 | 2 | 9 | 28856 | 34 | ||
37248 | 84870 | Permitted Site 7 | Tree(s) :: 17 | 1800 Van Ness Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2007 12:00:00 AM | Permit No. 49260 | 6006192 | 2116736.3 | 37.7925041547793 | -122.422503429039 | (37.7925041547793, -122.422503429039) | 13 | 9 | 10 | 28858 | 32 | |||
37691 | 53104 | Permitted Site 7 | Tree(s) :: 17 | 601@ NOE ST Duboce Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/2006 12:00:00 AM | Permit Number 49066 | 6002808.44176413 | 2108284.12633652 | 37.7691051487822 | -122.433606309272 | (37.7691051487822, -122.433606309272) | 15 | 5 | 5 | 28862 | 3 | |||
40356 | 107952 | Permitted Site 7 | Tree(s) :: 17 | 2200 JERROLD AVE | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012443.5 | 2099218.7 | 37.7447554536478 | -122.399642400815 | (37.7447554536478, -122.399642400815) | 10 | 3 | 8 | 58 | 1 | ||||
40855 | 49254 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/07/2003 12:00:00 AM | Permit Number 46305 | 6014371 | 2116872 | 37.7933347653256 | -122.394213120763 | (37.7933347653256, -122.394213120763) | 12 | 2 | 9 | 28855 | 6 | |||
41614 | 93894 | Permitted Site 7 | Tree(s) :: 17 | 425 Folsom St | 8 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6014407 | 2114805 | 37.787661263759 | -122.393943797302 | (37.787661263759, -122.393943797302) | 6 | 2 | 9 | 28855 | 6 | ||||
46702 | 107564 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
47531 | 46218 | Permitted Site 7 | Tree(s) :: 17 | 1888 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 13 | 9 | 1 | 57 | 17 | |||
49733 | 93214 | Permitted Site 7 | Tree(s) :: 17 | 655 Innes Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 3x3 | Permit Number 53208 | 6020566.8 | 2093454.3 | 37.7293769960176 | -122.371154647854 | (37.7293769960176, -122.371154647854) | 10 | 3 | 8 | 58 | 1 | ||
49914 | 93587 | Permitted Site 7 | Tree(s) :: 17 | 15 West Point Rd | 8 | Front Yard : Yard | Tree | Private 2 | Permit Number 53253 | 6017978 | 2095925.8 | 37.7360207655726 | -122.380276156788 | (37.7360207655726, -122.380276156788) | 10 | 3 | 8 | 58 | 1 | ||||
50345 | 173741 | DPW Maintained 1 | Tree(s) :: 17 | 2500X Lyon St | 8 | Median : Yard | Tree | Private 2 | 01/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779102 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |
59647 | 93614 | Undocumented 4 | Tree(s) :: 17 | 3865 Sacramento St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 53255 | 5996391.2 | 2114920.9 | 37.7869617823748 | -122.456282979232 | (37.7869617823748, -122.456282979232) | 11 | 6 | 1 | 54 | 31 | ||
61074 | 35631 | Permitted Site 7 | Tree(s) :: 17 | 701 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1998 12:00:00 AM | Permit Number 38975 | 6004496.45349332 | 2110824.80795168 | 37.7761768741411 | -122.427948642674 | (37.7761768741411, -122.427948642674) | 7 | 9 | 11 | 28852 | 10 | |||
63912 | 50970 | Permitted Site 7 | Tree(s) :: 17 | 683 REVISED Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2004 12:00:00 AM | Permit Number 47463 | 6012417.01604771 | 2110263.6615562 | 37.775081003703 | -122.40050967291 | (37.775081003703, -122.40050967291) | 14 | 2 | 9 | 28856 | 20 | |||
64321 | 92014 | Permitted Site 7 | Tree(s) :: 17 | 360 04th St | 8 | Front Yard : Yard | Tree | Private 2 | 06/02/2009 12:00:00 AM | Permit Number 52163 | 6012527 | 2112512 | 37.7812605579477 | -122.400287160132 | (37.7812605579477, -122.400287160132) | 6 | 2 | 9 | 28856 | 34 | |||
66453 | 40896 | Permitted Site 7 | Tree(s) :: 17 | 296 Addison St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/1999 12:00:00 AM | Permit Number 41792 | 6002404.57266151 | 2097761.95623276 | 37.740190860742 | -122.434250923896 | (37.740190860742, -122.434250923896) | 2 | 7 | 5 | 63 | 7 | |||
67939 | 102407 | Undocumented 4 | Tree(s) :: 17 | 95X Harriet St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010704.6 | 2111649.2 | 37.7787897224959 | -122.406530981243 | (37.7787897224959, -122.406530981243) | 14 | 2 | 9 | 28853 | 34 | |||
69791 | 52751 | Permitted Site 7 | Tree(s) :: 17 | 888 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/28/2006 12:00:00 AM | 3x3 | Permit Number 48794 | 6011250.93887813 | 2112724.08658297 | 37.7817716600744 | -122.404716662237 | (37.7817716600744, -122.404716662237) | 12 | 2 | 9 | 28853 | 34 | ||
71130 | 27443 | DPW Maintained 1 | Tree(s) :: 17 | 1690X Indiana St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2000 12:00:00 AM | 3 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | 10 | 3 | 8 | 58 | 1 | ||
75280 | 93865 | Permitted Site 7 | Tree(s) :: 17 | 3120 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/2010 12:00:00 AM | 3x3 | Permit Number 53363 | 6007934.7 | 2106418.2 | 37.7642712781273 | -122.415742690399 | (37.7642712781273, -122.415742690399) | 8 | 4 | 7 | 28859 | 19 | ||
75482 | 245449 | DPW Maintained 1 | Tree(s) :: 17 | 2798 16th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6008185.849 | 2106828.0579 | 37.7654107681137 | -122.414903044666 | (37.7654107681137, -122.414903044666) | 8 | 4 | 7 | 28853 | 19 | |||
76180 | 101544 | Permitted Site 7 | Tree(s) :: 17 | 1X Main St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46305 | 6014036.2 | 2116698.9 | 37.7928408582284 | -122.395359428861 | (37.7928408582284, -122.395359428861) | 12 | 2 | 9 | 28855 | 6 | ||||
77007 | 100345 | Permitted Site 7 | Tree(s) :: 17 | 1190 Mission St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2012 12:00:00 AM | 3x3 | Permit Number 767726 | 6008690.2 | 2111553.5 | 37.7784140515871 | -122.413492835489 | (37.7784140515871, -122.413492835489) | 8 | 2 | 9 | 28853 | 34 |
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) );