trees
400 rows where qSpecies_id = 43 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70486 | 38076 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000627.17901 | 2113992.97301 | 37.7846561884399 | -122.441560878475 | (37.7846561884399, -122.441560878475) | 15 | 6 | 11 | 29490 | 13 | ||
64436 | 114654 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6001378.1104 | 2113915.8269 | 37.7844871189173 | -122.438957381866 | (37.7844871189173, -122.438957381866) | 15 | 6 | 11 | 29490 | 13 | |||
71570 | 36820 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
161249 | 38075 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000624.05401 | 2114007.81601 | 37.7846967654532 | -122.441572755427 | (37.7846967654532, -122.441572755427) | 15 | 6 | 11 | 29490 | 13 | ||
86065 | 29418 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2601X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6015194.8940554 | 2091164.3100784 | 37.7227927176508 | -122.389566117231 | (37.7227927176508, -122.389566117231) | 10 | 3 | 8 | 58 | 1 | |||
98576 | 38571 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
102213 | 99920 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1740 Jones St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6008334 | 2118406 | 37.7972093435845 | -122.415210266144 | (37.7972093435845, -122.415210266144) | 5 | 1 | 10 | 308 | 21 | |||||
124971 | 36826 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
146965 | 31139 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 419 Hearst Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | ||
174203 | 37705 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
181292 | 38074 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000621.45001 | 2114020.83701 | 37.7847323694056 | -122.441582699114 | (37.7847323694056, -122.441582699114) | 15 | 6 | 11 | 29490 | 13 | ||
9053 | 38570 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
19915 | 37424 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
29030 | 37044 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
30259 | 36821 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
32928 | 37704 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
47019 | 39910 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
49379 | 38081 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000619.36701 | 2114044.53501 | 37.7847973193303 | -122.441591606798 | (37.7847973193303, -122.441591606798) | 15 | 6 | 11 | 29490 | 13 | ||
49579 | 114652 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Post St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6001448.056 | 2113923.3749 | 37.7845118231904 | -122.438715935573 | (37.7845118231904, -122.438715935573) | 15 | 6 | 11 | 29490 | 13 | |||
97659 | 36491 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
119829 | 40038 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
163727 | 184740 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1301 Sunset Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984699.9431 | 2106237.7689 | 37.7624423230543 | -122.496090619994 | (37.7624423230543, -122.496090619994) | 1 | 8 | 3 | 56 | 35 | |||
168179 | 37708 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
172638 | 126461 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000743.63592 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | 13 | 9 | 1 | 57 | 17 | |||
5387 | 38597 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1301 Revere Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.7284594450303 | -122.384664438105 | (37.7284594450303, -122.384664438105) | 10 | 3 | 8 | 58 | 1 | ||
25563 | 36489 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
44466 | 37043 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
46799 | 38320 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1810 Harrison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1998 12:00:00 AM | Permit Number 40378 | 6008623.68390919 | 2107918.42733823 | 37.7684292621485 | -122.413465790173 | (37.7684292621485, -122.413465790173) | 8 | 4 | 7 | 28853 | 19 | |||
49935 | 40037 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
67064 | 40067 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1400 Thomas Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.387554479201 | (37.7283836150635, -122.387554479201) | 10 | 3 | 8 | 58 | 1 | ||
77557 | 34660 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Kirkham St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 5 | Permit Number 38334 | 5987955.9197 | 2105118.4846 | 37.759559247409 | -122.484747425675 | (37.759559247409, -122.484747425675) | 1 | 8 | 3 | 56 | 35 | |
89942 | 38612 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
99430 | 184739 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1301 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984690.4501 | 2106251.0591 | 37.7624782581791 | -122.496124432854 | (37.7624782581791, -122.496124432854) | 1 | 8 | 3 | 56 | 35 | |||
117190 | 38569 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
126600 | 37423 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
149752 | 38073 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000616.76201 | 2114062.24301 | 37.7848457925173 | -122.441601890436 | (37.7848457925173, -122.441601890436) | 15 | 6 | 11 | 29490 | 13 | ||
160706 | 38628 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/1998 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 | |||
166564 | 37709 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 720 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40083 | 6007483.64662361 | 2105457.13704999 | 37.7616070561613 | -122.417234652367 | (37.7616070561613, -122.417234652367) | 2 | 4 | 7 | 28859 | 19 | ||
168833 | 37703 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
177763 | 255250 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 209x Willow St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
187434 | 36819 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
7624 | 246397 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999315.6516 | 2108414.4782 | 37.769264264093 | -122.445696997639 | (37.769264264093, -122.445696997639) | 15 | 5 | 11 | 29492 | 9 | |||
32117 | 183413 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2350 Wawona St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5985629.7915 | 2097026.6067 | 37.737205400625 | -122.492196390733 | (37.737205400625, -122.492196390733) | 1 | 8 | 3 | 29491 | 35 | |||
33819 | 38088 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2501 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/1999 12:00:00 AM | Permit Number 40260 | 6000614.67901 | 2114079.17001 | 37.7848921510189 | -122.441610312074 | (37.7848921510189, -122.441610312074) | 15 | 6 | 11 | 29490 | 13 | ||
39789 | 34659 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38334 | 5987972.9693 | 2105119.7321 | 37.7595636656584 | -122.484688551924 | (37.7595636656584, -122.484688551924) | 1 | 8 | 3 | 56 | 35 | |
47665 | 40058 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
54982 | 31111 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | 9 | 7 | 4 | 28861 | 40 | |||
58314 | 38629 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 | ||
63942 | 31145 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 419 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/2006 12:00:00 AM | 3x3 | Permit Number 34852 | 5998635.87955939 | 2094356.6234018 | 37.7306259997996 | -122.447036492148 | (37.7306259997996, -122.447036492148) | 9 | 7 | 4 | 28861 | 40 | |
65609 | 37589 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
71856 | 36717 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1999 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
72751 | 37286 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 699 Castro St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2002 12:00:00 AM | Permit Number 39818 | 6002432.10165251 | 2104152.77929012 | 37.757740114019 | -122.434612596377 | (37.757740114019, -122.434612596377) | 2 | 4 | 5 | 28862 | 3 | ||
82292 | 38596 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1301 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.7284594450303 | -122.384664438105 | (37.7284594450303, -122.384664438105) | 10 | 3 | 8 | 58 | 1 | ||
85527 | 40036 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
89820 | 39905 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
110816 | 37426 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
115401 | 40066 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1400 Thomas Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/2005 12:00:00 AM | Permit Number 41294 | 6015817.64770175 | 2093187.90304466 | 37.7283836150635 | -122.387554479201 | (37.7283836150635, -122.387554479201) | 10 | 3 | 8 | 58 | 1 | ||
127677 | 37042 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
128039 | 37702 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
150403 | 43108 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 405 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | Permit Number 42935 | 6009343.77596633 | 2114320.93489173 | 37.786049444672 | -122.411427426058 | (37.786049444672, -122.411427426058) | 5 | 10 | 9 | 28852 | 36 | ||
152483 | 38621 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1295 Shafter Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.7277292986583 | -122.385043230392 | (37.7277292986583, -122.385043230392) | 10 | 3 | 8 | 58 | 1 | ||
153929 | 36822 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
161625 | 126462 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.8038772290062 | -122.441595650935 | (37.8038772290062, -122.441595650935) | 13 | 9 | 1 | 57 | 17 | |||
165786 | 38568 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
173715 | 36487 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
180365 | 141254 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5996808.5286 | 2114260.026 | 37.7851711462005 | -122.454791358921 | (37.7851711462005, -122.454791358921) | 11 | 6 | 1 | 54 | 31 | |||
183262 | 38616 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
185863 | 37786 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 301 Hamilton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/1998 12:00:00 AM | Permit Number 40119 | 6009341.93324933 | 2092913.86947002 | 37.7272703689284 | -122.409922083912 | (37.7272703689284, -122.409922083912) | 10 | 3 | 7 | 309 | 28 | |||
189493 | 36335 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 44 Eastwood Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/1998 12:00:00 AM | Permit Number 39301 | 5995656.19844855 | 2092807.02452797 | 37.7262004833581 | -122.457225579924 | (37.7262004833581, -122.457225579924) | 9 | 7 | 4 | 28861 | 40 | ||
1543 | 259573 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 298 Public Park | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994238 | 2098707 | 37.7423188086517 | -122.462555955845 | (37.7423188086517, -122.462555955845) | 1 | 8 | 4 | 59 | 40 | ||||
4468 | 40059 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1298 Thomas Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41292 | 6016382.10864513 | 2092767.10585329 | 37.7272594375757 | -122.385573778693 | (37.7272594375757, -122.385573778693) | 10 | 3 | 8 | 58 | 1 | ||
8969 | 38615 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1602 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40557 | 6015083.62753499 | 2094431.96361447 | 37.7317588716397 | -122.390178919908 | (37.7317588716397, -122.390178919908) | 10 | 3 | 8 | 58 | 1 | ||
18989 | 37041 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1660 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | Permit Number 39650 | 6004584.07651504 | 2099217.83848958 | 37.7443118455047 | -122.426818732995 | (37.7443118455047, -122.426818732995) | 2 | 7 | 5 | 63 | 22 | |||
20690 | 38595 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1301 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40548 | 6016653.84193156 | 2093198.66483066 | 37.7284594450303 | -122.384664438105 | (37.7284594450303, -122.384664438105) | 10 | 3 | 8 | 58 | 1 | ||
27476 | 31110 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 415 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1995 12:00:00 AM | Permit Number 34838 | 5998740.33351858 | 2094135.45298345 | 37.7300246851321 | -122.446659473393 | (37.7300246851321, -122.446659473393) | 9 | 7 | 4 | 28861 | 40 | |||
32393 | 246393 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1318 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999383.4853 | 2108424.4716 | 37.7692955761214 | -122.445463083857 | (37.7692955761214, -122.445463083857) | 15 | 5 | 11 | 29492 | 9 | |||
37916 | 233997 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1027 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6001336.17311 | 2100800.0445 | 37.7484720346532 | -122.438162590655 | (37.7484720346532, -122.438162590655) | 2 | 4 | 5 | 28862 | 22 | |||
62613 | 37588 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2805 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40018 | 6001080.41648379 | 2105487.69270452 | 37.7613286337784 | -122.439382956636 | (37.7613286337784, -122.439382956636) | 15 | 4 | 5 | 28862 | 3 | ||
71470 | 44817 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2745 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 4 | Permit Number 43908 | 5986315.8836 | 2105009.2662 | 37.7591637116246 | -122.490411373273 | (37.7591637116246, -122.490411373273) | 1 | 8 | 3 | 56 | 35 | |
72686 | 34658 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 2200 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 2 | Permit Number 38334 | 5987988.7714 | 2105120.9797 | 37.7595680115028 | -122.484633992596 | (37.7595680115028, -122.484633992596) | 1 | 8 | 3 | 56 | 35 | |
75154 | 23668 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 315 Virginia Ave | 3 | Median : Cutout | Tree | DPW 1 | 3 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | 2 | 7 | 7 | 28859 | 2 | |||
79658 | 141253 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 45 PARKER AVE | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5996809.5439 | 2114265.4407 | 37.7851860717648 | -122.454788237668 | (37.7851860717648, -122.454788237668) | 11 | 6 | 1 | 54 | 31 | |||
80984 | 36908 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 394 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39556 | 6001774.84404362 | 2103557.93464621 | 37.7560694803843 | -122.436843078117 | (37.7560694803843, -122.436843078117) | 2 | 4 | 5 | 28862 | 3 | ||
86961 | 39907 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1600 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41187 | 6001194.58559448 | 2113861.70061497 | 37.7843280584248 | -122.439588431897 | (37.7843280584248, -122.439588431897) | 15 | 6 | 11 | 29490 | 13 | |||
90253 | 40035 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1190 Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/1999 12:00:00 AM | Permit Number 41276 | 6017092.11727915 | 2093635.28500983 | 37.7296825468656 | -122.383179660981 | (37.7296825468656, -122.383179660981) | 10 | 3 | 8 | 58 | 1 | |||
90544 | 36823 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Fitzgerald Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39534 | 6014575.87209861 | 2090621.86928293 | 37.7212689399964 | -122.391668053968 | (37.7212689399964, -122.391668053968) | 10 | 3 | 8 | 58 | 1 | ||
95507 | 36720 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1850 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/14/2004 12:00:00 AM | Permit Number 39504 | 6006730.53287232 | 2107601.56248509 | 37.767452746672 | -122.419991553753 | (37.767452746672, -122.419991553753) | 8 | 4 | 7 | 28853 | 19 | ||
96433 | 37701 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 700 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/1998 12:00:00 AM | Permit Number 40082 | 6007477.44704972 | 2105569.08555176 | 37.7619140920083 | -122.417264027542 | (37.7619140920083, -122.417264027542) | 2 | 4 | 7 | 28859 | 19 | ||
106912 | 246396 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1320 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5999332.61 | 2108417.5065 | 37.769273547251 | -122.445638557414 | (37.769273547251, -122.445638557414) | 15 | 5 | 11 | 29492 | 9 | |||
114130 | 36832 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2655 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39536 | 6015108.90537025 | 2091047.28537032 | 37.7224666226612 | -122.389855194073 | (37.7224666226612, -122.389855194073) | 10 | 3 | 8 | 58 | 1 | ||
119125 | 36493 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 95 Westwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/18/1998 12:00:00 AM | Permit Number 39377 | 5995116.30141704 | 2093273.83949404 | 37.7274512220857 | -122.459125749197 | (37.7274512220857, -122.459125749197) | 9 | 7 | 4 | 28861 | 40 | |||
125708 | 37427 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1220 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39902 | 6003190.5059195 | 2101131.09771587 | 37.7494863167503 | -122.431773980118 | (37.7494863167503, -122.431773980118) | 2 | 4 | 5 | 28862 | 22 | |||
136441 | 38176 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 5 Dwight St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | Permit Number 40311 | 6011565.07182758 | 2091659.31063556 | 37.7239499540685 | -122.402148496173 | (37.7239499540685, -122.402148496173) | 10 | 3 | 7 | 309 | 28 | ||
136572 | 37871 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 135 Colon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | Permit Number 40155 | 5996120.55604725 | 2093902.0241844 | 37.7292337486651 | -122.455699446357 | (37.7292337486651, -122.455699446357) | 9 | 7 | 4 | 28861 | 40 | ||
137180 | 38567 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1360 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40531 | 6016200.74571731 | 2094639.7722335 | 37.7323913709995 | -122.386331262014 | (37.7323913709995, -122.386331262014) | 10 | 3 | 8 | 58 | 1 | ||
137219 | 35519 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 90 Alvarado St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38920 | 6005793.71652674 | 2102887.49607432 | 37.7544562030797 | -122.422896805421 | (37.7544562030797, -122.422896805421) | 2 | 4 | 5 | 28859 | 19 | ||
140640 | 38620 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1295 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1998 12:00:00 AM | Permit Number 40560 | 6016538.96174012 | 2092935.06529127 | 37.7277292986583 | -122.385043230392 | (37.7277292986583, -122.385043230392) | 10 | 3 | 8 | 58 | 1 | ||
146257 | 37125 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 4200 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39711 | 5981854.3307572 | 2104909.94156092 | 37.7586294023629 | -122.505833929701 | (37.7586294023629, -122.505833929701) | 1 | 8 | 3 | 56 | 35 | |
148296 | 36829 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2600 Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | Permit Number 39535 | 6015154.00494247 | 2091194.79088837 | 37.7228741446414 | -122.38970959128 | (37.7228741446414, -122.38970959128) | 10 | 3 | 8 | 58 | 1 | ||
155651 | 38627 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1396 Shafter Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/2005 12:00:00 AM | Permit Number 40563 | 6016028.15247737 | 2093380.70622124 | 37.7289246716671 | -122.386840188027 | (37.7289246716671, -122.386840188027) | 10 | 3 | 8 | 58 | 1 |
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) );