trees
891 rows where qSpecies_id = 75 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
544 | 259763 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
1770 | 122656 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
5536 | 122646 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
7971 | 122653 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
8221 | 122657 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
10505 | 122650 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
11819 | 122647 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
12330 | 259764 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2701 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2019 12:00:00 AM | 3 | |||||||||||||
12580 | 122655 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
13152 | 122648 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
13368 | 122658 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
13486 | 122649 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
14226 | 122645 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
14390 | 122652 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
16082 | 122660 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
16448 | 253390 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2529x Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
17571 | 122654 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
17771 | 122651 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
17800 | 122661 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
18374 | 122659 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 300x Hickory St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3x3 | ||||||||||||
52186 | 185222 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2507 34th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5985796.7937 | 2098135.752 | 37.740260579141 | -122.491700620712 | (37.740260579141, -122.491700620712) | 1 | 8 | 3 | 29491 | 35 | |||
5464 | 66327 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1231 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | 4 | Permit Number 29446 | 5987052.1054 | 2106857.6987 | 37.7642819711606 | -122.488001017639 | (37.7642819711606, -122.488001017639) | 1 | 8 | 3 | 56 | 35 | |
52317 | 88582 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 572 24th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51525 | 5988469.85698 | 2112085.5473 | 37.7787187988439 | -122.483480758311 | (37.7787187988439, -122.483480758311) | 11 | 6 | 2 | 55 | 26 | ||
89204 | 185773 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1615 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5989001.3995 | 2102380.5121 | 37.7521023420375 | -122.480931213247 | (37.7521023420375, -122.480931213247) | 1 | 8 | 3 | 29491 | 35 | |||
193555 | 123077 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 723 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5992233.23043 | 2110491.18489 | 37.774559431962 | -122.470345763786 | (37.774559431962, -122.470345763786) | 11 | 6 | 2 | 54 | 11 | |||
108339 | 1264 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3995X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/15/1992 12:00:00 AM | 3 | 3x3 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | ||
31270 | 28843 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 338 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2008 12:00:00 AM | 3 | 3X3 | 5993062.32103 | 2089859.01247 | 37.7179566445716 | -122.465978279778 | (37.7179566445716, -122.465978279778) | 9 | 8 | 6 | 64 | 24 | ||
85232 | 87436 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3726X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5993141.944866 | 2087637.371973 | 37.7118611458885 | -122.465541749955 | (37.7118611458885, -122.465541749955) | 9 | 8 | 4 | 64 | 24 | ||
77903 | 203422 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 9 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993354.86667 | 2097295.22775 | 37.738391538344 | -122.465506999949 | (37.738391538344, -122.465506999949) | 1 | 8 | 4 | 59 | 40 | |||
168258 | 203423 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | 1 | 8 | 4 | 59 | 40 | |||
107226 | 203421 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 11 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993401.40723 | 2097258.40143 | 37.738293106632 | -122.465343412368 | (37.738293106632, -122.465343412368) | 1 | 8 | 4 | 59 | 40 | |||
6716 | 208999 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 10 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5993404.32279 | 2097201.32336 | 37.7381365526709 | -122.465329186907 | (37.7381365526709, -122.465329186907) | 1 | 8 | 4 | 59 | 40 | |||
158008 | 203420 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993455.07316 | 2097218.01136 | 37.7381853004145 | -122.465154930655 | (37.7381853004145, -122.465154930655) | 1 | 8 | 4 | 59 | 40 | |||
146528 | 203402 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | 1 | 8 | 4 | 59 | 40 | |||
96718 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | 1 | 8 | 4 | 59 | 40 | ||
19089 | 203401 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 24 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993518.80789 | 2097119.92672 | 37.7379196595754 | -122.464927448042 | (37.7379196595754, -122.464927448042) | 1 | 8 | 4 | 59 | 40 | |||
90224 | 1221 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 3600X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
153741 | 203419 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 35 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993568.7451 | 2097128.90388 | 37.7379471878035 | -122.464755443717 | (37.7379471878035, -122.464755443717) | 1 | 8 | 4 | 59 | 40 | |||
149763 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584 | 2097045 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | 1 | 8 | 4 | 59 | 40 | |
177290 | 203400 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 34 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993596.06359 | 2097068.49274 | 37.7377828888614 | -122.464656605522 | (37.7377828888614, -122.464656605522) | 1 | 8 | 4 | 59 | 40 | |||
13427 | 208966 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 44 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/17/2018 12:00:00 AM | 3 | Width 6ft | Permit Number 781880 | 5993637 | 2097007 | 37.7376164050624 | -122.464510605988 | (37.7376164050624, -122.464510605988) | 1 | 8 | 4 | 59 | 40 | |
71364 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
73267 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 776540 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||
83163 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
155480 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
182457 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | ||
139444 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969 | 37.7375153061033 | -122.464313539267 | (37.7375153061033, -122.464313539267) | 1 | 8 | 4 | 59 | 40 | ||
109537 | 203418 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993705.93526 | 2097033.15738 | 37.7376922003421 | -122.464274164331 | (37.7376922003421, -122.464274164331) | 1 | 8 | 4 | 59 | 40 | |||
188463 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 776555 | 5993732.7 | 2097034 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | 1 | 8 | 4 | 59 | 40 | ||||
100678 | 94790 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | 1 | 8 | 4 | 29491 | 12 | |||
141398 | 203407 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993759.21038 | 2102270.66076 | 37.7520761325235 | -122.464470142809 | (37.7520761325235, -122.464470142809) | 1 | 8 | 4 | 29491 | 12 | |||
28362 | 203408 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993769.17892 | 2102256.91781 | 37.7520389725334 | -122.464434672649 | (37.7520389725334, -122.464434672649) | 1 | 8 | 4 | 29491 | 12 | |||
54765 | 203417 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993769.49059 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | 1 | 8 | 4 | 59 | 40 | |||
193868 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.7376129769989 | -122.464024183823 | (37.7376129769989, -122.464024183823) | 1 | 8 | 4 | 59 | 40 | ||
47342 | 203409 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993779.2225 | 2102246.74831 | 37.7520116286371 | -122.464399202454 | (37.7520116286371, -122.464399202454) | 1 | 8 | 4 | 29491 | 12 | |||
121010 | 203398 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1898 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993787.6735 | 2102657.11631 | 37.753138881175 | -122.464399769949 | (37.753138881175, -122.464399769949) | 1 | 8 | 4 | 56 | 12 | |||
50165 | 203399 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1898 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993788.70878 | 2102627.32377 | 37.7530571381766 | -122.464394026856 | (37.7530571381766, -122.464394026856) | 1 | 8 | 4 | 56 | 12 | |||
25740 | 116468 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
42049 | 116467 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
61751 | 116466 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
69264 | 116464 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
98543 | 116470 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
107853 | 116469 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
120869 | 116465 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.464351010806 | (37.751887038112, -122.464351010806) | 1 | 8 | 4 | 29491 | 12 | |
178413 | 203410 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993793.04129 | 2102233.18002 | 37.7519751701323 | -122.464350430425 | (37.7519751701323, -122.464350430425) | 1 | 8 | 4 | 29491 | 12 | |||
54288 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | 1 | 8 | 4 | 59 | 40 | ||
54520 | 203411 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993801.54167 | 2102222.78745 | 37.7519471247661 | -122.464320280662 | (37.7519471247661, -122.464320280662) | 1 | 8 | 4 | 29491 | 12 | |||
130651 | 203412 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993816.05949 | 2102205.88495 | 37.7519015516321 | -122.464268849347 | (37.7519015516321, -122.464268849347) | 1 | 8 | 4 | 29491 | 12 | |||
74820 | 203413 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1945 08th Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993820.42059 | 2102181.53499 | 37.7518349442394 | -122.464252000534 | (37.7518349442394, -122.464252000534) | 1 | 8 | 4 | 29491 | 12 | |||
42705 | 203416 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 75 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993822.50089 | 2096951.15994 | 37.7374737738828 | -122.463865194036 | (37.7374737738828, -122.463865194036) | 1 | 8 | 4 | 59 | 40 | |||
136974 | 203415 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 95 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993910.70196 | 2096889.90147 | 37.7373106557719 | -122.463555799377 | (37.7373106557719, -122.463555799377) | 1 | 8 | 4 | 59 | 40 | |||
183750 | 203414 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993945.56402 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | 1 | 8 | 4 | 59 | 40 | |||
114925 | 203427 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 101 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994083.74487 | 2096763.21793 | 37.7369727831569 | -122.462948326201 | (37.7369727831569, -122.462948326201) | 9 | 8 | 4 | 59 | 40 | |||
116051 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
177311 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | ||
179132 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 75 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | 9 | 8 | 4 | 59 | 40 | ||
99576 | 123540 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 27 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994225.0963 | 2115400.25792 | 37.7881533861032 | -122.463811955609 | (37.7881533861032, -122.463811955609) | 11 | 6 | 1 | 54 | 11 | |||
28189 | 203426 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 135 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994229.44749 | 2096660.50029 | 37.7366991374492 | -122.462437122787 | (37.7366991374492, -122.462437122787) | 9 | 8 | 4 | 59 | 40 | |||
158024 | 203425 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 135 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994247.20035 | 2096642.9024 | 37.7366518402943 | -122.462374467911 | (37.7366518402943, -122.462374467911) | 9 | 8 | 4 | 59 | 40 | |||
111084 | 203424 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 135 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994267.45762 | 2096626.89262 | 37.7366090478713 | -122.462303269505 | (37.7366090478713, -122.462303269505) | 9 | 8 | 4 | 59 | 40 | |||
190387 | 203403 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994381.0014 | 2096518.06805 | 37.736316779897 | -122.461902813967 | (37.736316779897, -122.461902813967) | 9 | 8 | 4 | 59 | 40 | |||
181942 | 203404 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994396.0657 | 2096501.56524 | 37.7362723344984 | -122.461849534529 | (37.7362723344984, -122.461849534529) | 9 | 8 | 4 | 59 | 40 | |||
37037 | 203405 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994431.87617 | 2096469.95405 | 37.7361875994652 | -122.461723432511 | (37.7361875994652, -122.461723432511) | 9 | 8 | 4 | 59 | 40 | |||
122505 | 203233 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 96 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 5994437 | 2101362 | 37.7496202288212 | -122.462060373707 | (37.7496202288212, -122.462060373707) | 1 | 8 | 4 | 29491 | 40 | |||
39683 | 203406 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 8ft | 5994466.0383 | 2096440.37443 | 37.7361083476053 | -122.461603176966 | (37.7361083476053, -122.461603176966) | 9 | 8 | 4 | 59 | 40 | |||
18211 | 49144 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 206 Lobos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2003 12:00:00 AM | Permit Number 46269 | 5994953.84956095 | 2088734.37736924 | 37.7149776031797 | -122.459358738579 | (37.7149776031797, -122.459358738579) | 9 | 8 | 6 | 28861 | 24 | |||
65478 | 1204 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3101X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.455574291439 | (37.7101888713812, -122.455574291439) | 9 | 7 | 6 | 28861 | 25 | ||
78827 | 1203 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3111X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.455574291439 | (37.7101888713812, -122.455574291439) | 9 | 7 | 6 | 28861 | 25 | ||
94294 | 1205 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 3101X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3x3 | 5996011.84693 | 2086968.20248 | 37.7101888713812 | -122.455574291439 | (37.7101888713812, -122.455574291439) | 9 | 7 | 6 | 28861 | 25 | ||
121741 | 220475 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1177 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5997354.16789 | 2106085.50223 | 37.7627573058278 | -122.452313556128 | (37.7627573058278, -122.452313556128) | 15 | 5 | 11 | 29492 | 12 | |||
107521 | 140191 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 282 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997398.2687 | 2109611.1769 | 37.7724404326656 | -122.452415461613 | (37.7724404326656, -122.452415461613) | 15 | 5 | 11 | 29492 | 16 | |||
63417 | 220476 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 849 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998017.46753 | 2107292.9322 | 37.7661105800595 | -122.450106480435 | (37.7661105800595, -122.450106480435) | 15 | 5 | 11 | 29492 | 9 | |||
147411 | 220477 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 851 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5998019.73949 | 2107271.17336 | 37.7660509658169 | -122.450097053756 | (37.7660509658169, -122.450097053756) | 15 | 5 | 11 | 29492 | 9 | |||
3977 | 262296 | Section 806 (d) 5 | Acer rubrum :: Red Maple 75 | 45 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782635 | 5998403.0154 | 2106238.4273 | 37.7632372305534 | -122.448696994498 | (37.7632372305534, -122.448696994498) | 15 | 5 | 11 | 29492 | 9 | |
154802 | 84875 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1936 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2007 12:00:00 AM | 3 | Permit No. 49244 | 5998519.2047 | 2110389.3497 | 37.7746412516506 | -122.448594107091 | (37.7746412516506, -122.448594107091) | 15 | 5 | 11 | 29492 | 16 | ||
168375 | 1128 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 2525 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/22/2008 12:00:00 AM | 3 | 3X6 | 5998741.2887 | 2088615.01895 | 37.7148669056281 | -122.446259214537 | (37.7148669056281, -122.446259214537) | 9 | 7 | 6 | 28861 | 25 | ||
49904 | 1124 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2463 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999036.51586 | 2088791.07267 | 37.715367165446 | -122.445251440001 | (37.715367165446, -122.445251440001) | 9 | 7 | 6 | 28861 | 25 | ||
49928 | 16382 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 5999194.33201 | 2088944.07211 | 37.7157962742582 | -122.444716950429 | (37.7157962742582, -122.444716950429) | 9 | 7 | 6 | 28861 | 25 | ||
175063 | 87445 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 2413X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5999221.04782 | 2088973.52313 | 37.7158786645875 | -122.444626724129 | (37.7158786645875, -122.444626724129) | 9 | 7 | 6 | 28861 | 25 | |||
44631 | 122582 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 2500X Lyon St | 2 | Median : Cutout | Tree | Private 2 | 6 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 |
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) );