trees
8,758 rows where qSpecies_id = 16
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10017 | 12125 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X La Salle Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6016501.13325 | 2095063.13765 | 37.733570470694 | -122.385322233161 | (37.733570470694, -122.385322233161) | 10 | 3 | 8 | 58 | 1 | |||
10031 | 35174 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10041 | 261145 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3425 Quintara St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5982854.31136486 | 2100808.2311864 | 37.7474260606989 | -122.502072085099 | (37.7474260606989, -122.502072085099) | 1 | 8 | 3 | 29491 | 35 | ||||
10082 | 18754 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 239 Roosevelt Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6000901.36238 | 2107203.0495 | 37.766028389215 | -122.440125236912 | (37.766028389215, -122.440125236912) | 15 | 5 | 5 | 29492 | 3 | |||
10168 | 102888 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2940 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2106758 | 37.7651615533416 | -122.418394378814 | (37.7651615533416, -122.418394378814) | 8 | 4 | 7 | 28853 | 19 | ||||
10169 | 209927 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2399X 17th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5990795 | 2099222 | 37.7435339853739 | -122.474498254377 | (37.7435339853739, -122.474498254377) | 1 | 8 | 4 | 29491 | 40 | |||
10170 | 199967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6018075.9658 | 2092814.3198 | 37.7274826544925 | -122.379721339986 | (37.7274826544925, -122.379721339986) | 10 | 3 | 8 | 58 | 1 | |||
10186 | 250045 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Daniel Burnham Ct | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6006086.73506 | 2114727.88869 | 37.7869836181338 | -122.422724857187 | (37.7869836181338, -122.422724857187) | 13 | 9 | 1 | 28858 | 41 | |||
10224 | 60401 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1537 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 20 | 4x4 | Permit Number 19982 | 6015576.0436 | 2094341.847 | 37.7315387293778 | -122.388470234454 | (37.7315387293778, -122.388470234454) | 10 | 3 | 8 | 58 | 1 |
10249 | 60355 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1219 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 15 | 3x3 | Permit Number 19933 | 6016860.2126 | 2093732.327 | 37.7299361871824 | -122.383988142876 | (37.7299361871824, -122.383988142876) | 10 | 3 | 8 | 58 | 1 |
10252 | 61567 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1109 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 12 | Permit Number 21527 | 6012849.03318 | 2102339.27738 | 37.7533464869733 | -122.398459059258 | (37.7533464869733, -122.398459059258) | 10 | 3 | 8 | 28856 | 29 | |
10286 | 193965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 603 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6017340.35978 | 2096340.01342 | 37.7371229105773 | -122.382509569261 | (37.7371229105773, -122.382509569261) | 10 | 3 | 8 | 58 | 1 | |||
10392 | 111979 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 39 SEACLIFF AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5987939 | 2115796 | 37.788875735681 | -122.485589552136 | (37.788875735681, -122.485589552136) | 11 | 6 | 1 | 55 | 33 | |||||
10423 | 259280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3891 Sacramento St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
10436 | 105254 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 130 GONZALEZ DR | Front Yard : Yard | Tree | Private 2 | 2 | 5990327 | 2090136 | 37.7185590045312 | -122.47545320092 | (37.7185590045312, -122.47545320092) | 1 | 8 | 4 | 64 | 14 | |||||
10476 | 70493 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 53 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6005304.47442 | 2091965.67161 | 37.7244397195916 | -122.423812181596 | (37.7244397195916, -122.423812181596) | 9 | 7 | 6 | 309 | 5 | |||
10514 | 213161 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 131 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 4ft | 5995315.69861 | 2090785.50252 | 37.7206303056246 | -122.458256412019 | (37.7206303056246, -122.458256412019) | 9 | 8 | 6 | 28861 | 24 | |||
10516 | 102842 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10526 | 20383 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | |||||||||||||
10539 | 8707 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3100 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997465.2361 | 2113075.7189 | 37.7819569987164 | -122.452433873123 | (37.7819569987164, -122.452433873123) | 15 | 6 | 1 | 54 | 31 | |||
10547 | 20439 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 15 | |||||||||||||
10551 | 35179 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
10554 | 90281 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4400X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5981875.06739 | 2111015.68504 | 37.7753952303043 | -122.506214955899 | (37.7753952303043, -122.506214955899) | 11 | 6 | 2 | 55 | 26 | ||
10578 | 124100 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4041 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994419.15851 | 2112768.6726 | 37.780938946355 | -122.46294953791 | (37.780938946355, -122.46294953791) | 11 | 6 | 2 | 54 | 11 | |||
10582 | 213172 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 551 Junipero Serra Blvd | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 5991456.92444 | 2093622.00243 | 37.7281961392214 | -122.471801470083 | (37.7281961392214, -122.471801470083) | 9 | 8 | 4 | 59 | 40 | |||
10584 | 60431 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 454 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1982 12:00:00 AM | Permit Number 20015 | 6003628.53966279 | 2098964.72203761 | 37.7435627733769 | -122.430104722556 | (37.7435627733769, -122.430104722556) | 2 | 7 | 5 | 63 | 22 | ||
10618 | 184243 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1560 43rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5982819.0017 | 2104840.311 | 37.758494948557 | -122.502492561108 | (37.758494948557, -122.502492561108) | 1 | 8 | 3 | 56 | 35 | |||
10630 | 117809 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3840 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5983588.39645 | 2111074.63902 | 37.7756578150189 | -122.500292603059 | (37.7756578150189, -122.500292603059) | 11 | 6 | 2 | 55 | 26 | |||
10660 | 162 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5119X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1994 12:00:00 AM | 3 | 3X3 | 5991169.13123 | 2112654.48309 | 37.7804376750562 | -122.474184536114 | (37.7804376750562, -122.474184536114) | 11 | 6 | 2 | 54 | 26 | ||
10680 | 184646 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1684 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5983168.7213 | 2103693.1775 | 37.7553657860173 | -122.501198246466 | (37.7553657860173, -122.501198246466) | 1 | 8 | 3 | 56 | 35 | |||
10702 | 60375 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1491 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19953 | 6015455.6786 | 2094782.3612 | 37.7327416219249 | -122.38891710664 | (37.7327416219249, -122.38891710664) | 10 | 3 | 8 | 58 | 1 | |
10731 | 16564 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2265X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 5999663.62849 | 2089384.1717 | 37.7170314576056 | -122.443126439495 | (37.7170314576056, -122.443126439495) | 9 | 7 | 6 | 28861 | 25 | |||
10735 | 121071 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 600x Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012133 | 2117811 | 37.7957883852557 | -122.402022845886 | (37.7957883852557, -122.402022845886) | 3 | 1 | 10 | 28860 | 4 | ||||
10785 | 71410 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1505 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6015694.2103 | 2094255.0083 | 37.7313068352663 | -122.38805564796 | (37.7313068352663, -122.38805564796) | 10 | 3 | 8 | 58 | 1 | |||
10849 | 8736 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3240 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5997038.8246 | 2113016.8335 | 37.781770875875 | -122.453904798838 | (37.781770875875, -122.453904798838) | 11 | 6 | 1 | 54 | 31 | |||
10863 | 56635 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1919 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1982 12:00:00 AM | Permit Number 20078 | 6001606.33187064 | 2112849.40553557 | 37.7815719798524 | -122.438091398042 | (37.7815719798524, -122.438091398042) | 15 | 5 | 11 | 29490 | 41 | ||
10900 | 256098 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1776 Vallejo St | 1 | Front Yard : Cutout | Tree | Private 2 | 6005064.21519 | 2118169.93221 | 37.7963768588038 | -122.426507729874 | (37.7963768588038, -122.426507729874) | 13 | 9 | 1 | 28858 | 17 | |||||
10914 | 80704 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3124 Turk Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5995997.04045 | 2111450.94518 | 37.7774115756637 | -122.457395540163 | (37.7774115756637, -122.457395540163) | 11 | 6 | 2 | 54 | 16 | |||
10943 | 210378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 52 Pinehurst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5993374.1705 | 2093389.91722 | 37.7276696365248 | -122.465156680749 | (37.7276696365248, -122.465156680749) | 9 | 8 | 4 | 59 | 40 | |||
10964 | 41622 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 4 | Permit Number 44542 | 6011727.78319 | 2099655.52277 | 37.7459149527148 | -122.402147931707 | (37.7459149527148, -122.402147931707) | 10 | 3 | 8 | 58 | 1 | |
10974 | 232164 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 45 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000009.57845 | 2106992.30486 | 37.7653989267327 | -122.443194590665 | (37.7653989267327, -122.443194590665) | 15 | 5 | 5 | 29492 | 3 | |||
10979 | 35203 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
11003 | 232475 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 799 Duncan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6001440.92645 | 2099668.37427 | 37.7453706938136 | -122.437719318387 | (37.7453706938136, -122.437719318387) | 2 | 7 | 5 | 63 | 22 | |||
11024 | 60241 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1275 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 12 | Permit Number 19793 | 5987989.2041 | 2106633.4453 | 37.763720854288 | -122.484743446939 | (37.763720854288, -122.484743446939) | 1 | 8 | 3 | 56 | 35 | |
11100 | 142139 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3059 GEARY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | Width 0ft | 5997638.0004 | 2112996.359 | 37.7817489937123 | -122.451830464257 | (37.7817489937123, -122.451830464257) | 15 | 6 | 2 | 54 | 16 | |||
11101 | 210448 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5997106.39782 | 2094677.94067 | 37.7314207564505 | -122.452347291502 | (37.7314207564505, -122.452347291502) | 9 | 7 | 4 | 59 | 40 | |||
11105 | 122972 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 190 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5993384.33935 | 2114264.28993 | 37.7849858443572 | -122.466638202804 | (37.7849858443572, -122.466638202804) | 11 | 6 | 2 | 54 | 11 | |||
11135 | 231408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008046.11593 | 2098164.93005 | 37.7416159298358 | -122.414773197351 | (37.7416159298358, -122.414773197351) | 2 | 7 | 7 | 28859 | 2 | |||
11159 | 40216 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 531 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 6 | Permit Number 41395 | 5981594.18311 | 2112099.84077 | 37.77835546311 | -122.507267034014 | (37.77835546311, -122.507267034014) | 11 | 6 | 2 | 55 | 26 | |
11198 | 141214 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3333 CALIFORNIA ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998764.522 | 2114890.4212 | 37.7870140492715 | -122.448069662403 | (37.7870140492715, -122.448069662403) | 15 | 6 | 1 | 54 | 31 | |||
11227 | 106481 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X LAWTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993233 | 2104592 | 37.7584195821345 | -122.466458543785 | (37.7584195821345, -122.466458543785) | 1 | 8 | 4 | 56 | 12 | |||||
11238 | 1253 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3802X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/2006 12:00:00 AM | 3 | 3X5 | 5992813.09767 | 2087592.82096 | 37.7117198470729 | -122.466675091581 | (37.7117198470729, -122.466675091581) | 9 | 8 | 4 | 64 | 24 | ||
11253 | 232476 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 709 27th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 4ft | 6001883.69649 | 2099993.37759 | 37.7462882424036 | -122.436211548325 | (37.7462882424036, -122.436211548325) | 2 | 7 | 5 | 63 | 22 | |||
11287 | 72312 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3839 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5995843.90542 | 2115819.74251 | 37.7893983291806 | -122.458241562721 | (37.7893983291806, -122.458241562721) | 11 | 6 | 1 | 54 | 31 | |||
11355 | 70358 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3833 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982319.9846 | 2104190.4495 | 37.7566812777905 | -122.504170218425 | (37.7566812777905, -122.504170218425) | 1 | 8 | 3 | 56 | 35 | |||
11358 | 105913 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 115 Steuart St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 771767 | 6014820.9 | 2116826.5 | 37.7932348296087 | -122.392653238457 | (37.7932348296087, -122.392653238457) | 12 | 2 | 9 | 28855 | 6 | |||
11365 | 184552 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3545 Moraga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983239.8392 | 2103540.5435 | 37.7549508717871 | -122.500941015666 | (37.7549508717871, -122.500941015666) | 1 | 8 | 3 | 56 | 35 | |||
11384 | 258014 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4222 Moraga Ave | 1 | Sidewalk: Curb side : | Tree | DPW 1 | |||||||||||||||
11411 | 209829 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 408 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994458.79503 | 2106705.86696 | 37.764294369523 | -122.46237254966 | (37.764294369523, -122.46237254966) | 11 | 5 | 11 | 56 | 12 | |||
11439 | 71820 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1262 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988034.0091 | 2106701.9931 | 37.7639116770979 | -122.484593510615 | (37.7639116770979, -122.484593510615) | 1 | 8 | 3 | 56 | 35 | |||
11443 | 8760 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3355 Geary Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5996764.5338 | 2112876.2192 | 37.7813690559217 | -122.454843548281 | (37.7813690559217, -122.454843548281) | 11 | 6 | 2 | 54 | 16 | |||
11446 | 111248 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3101x VICENTE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 5983195 | 2097379 | 37.7380303412956 | -122.50064049243 | (37.7380303412956, -122.50064049243) | 1 | 8 | 3 | 29491 | 35 | |||
11476 | 144273 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 664 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5981985.4042 | 2111277.39999 | 37.7761203177304 | -122.505852688651 | (37.7761203177304, -122.505852688651) | 11 | 6 | 2 | 55 | 26 | ||
11521 | 61583 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 693 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1984 12:00:00 AM | 16 | Permit Number 21546 | 6012739.37676 | 2104289.95716 | 37.7586965187374 | -122.398975179254 | (37.7586965187374, -122.398975179254) | 10 | 3 | 8 | 28856 | 29 | |
11528 | 213133 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 530 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 5997236.23471 | 2094134.25097 | 37.7299353516323 | -122.451859215049 | (37.7299353516323, -122.451859215049) | 9 | 7 | 4 | 28861 | 40 | ||||
11547 | 177767 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4271 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003326 | 2093704 | 37.7291008919885 | -122.430775488572 | (37.7291008919885, -122.430775488572) | 9 | 7 | 6 | 28861 | 5 | |||
11582 | 9124 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5826 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5988915.1122 | 2112672.8678 | 37.7803573214557 | -122.481983500957 | (37.7803573214557, -122.481983500957) | 11 | 6 | 2 | 55 | 26 | |||
11602 | 122483 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1295 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5983305 | 2106338 | 37.7626357248351 | -122.500922549214 | (37.7626357248351, -122.500922549214) | 1 | 8 | 3 | 56 | 35 | ||||
11624 | 10949 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016738.0241541 | 2096692.24342 | 37.7380567715564 | -122.384616664641 | (37.7380567715564, -122.384616664641) | 10 | 3 | 8 | 58 | 1 | |||
11650 | 213242 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 116 Majestic Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 5997026.98347 | 2089301.08259 | 37.7166526221889 | -122.452234013791 | (37.7166526221889, -122.452234013791) | 9 | 8 | 6 | 28861 | 24 | |||
11690 | 35212 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
11722 | 16206 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 512 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5998670.78741 | 2094729.8528 | 37.7316527941412 | -122.446942658283 | (37.7316527941412, -122.446942658283) | 9 | 7 | 4 | 59 | 40 | |||
11773 | 59839 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1201 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 3 | Permit Number 19293 | 6016946.5018 | 2093669.1216 | 37.7297674076459 | -122.383685429115 | (37.7297674076459, -122.383685429115) | 10 | 3 | 8 | 58 | 1 | |
11803 | 261486 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Portola Dr | 13 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
11807 | 70932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 14 | 5988727.46903 | 2113517.26751 | 37.7826648905872 | -122.482694534783 | (37.7826648905872, -122.482694534783) | 11 | 6 | 2 | 55 | 26 | |||
11860 | 20441 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 15 | |||||||||||||
11862 | 260530 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1790x 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
11884 | 47747 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4250 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/30/2002 12:00:00 AM | 5 | Permit Number 45528 | 5982389.08626 | 2110352.01137 | 37.7736032226209 | -122.504387696378 | (37.7736032226209, -122.504387696378) | 11 | 6 | 2 | 55 | 26 | |
11887 | 140997 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2425 GEARY BLVD | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000082.8924 | 2113275.7367 | 37.7826558182918 | -122.443392386236 | (37.7826558182918, -122.443392386236) | 15 | 5 | 1 | 29490 | 16 | |||
11925 | 193857 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 34 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6013016.42889 | 2115921.75626 | 37.7906502350671 | -122.398833341802 | (37.7906502350671, -122.398833341802) | 12 | 2 | 9 | 28855 | 6 | |||
11988 | 64663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 763 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1988 12:00:00 AM | 11 | Permit Number 25592 | 5994719.47478 | 2110406.61059 | 37.7744706476124 | -122.461739287117 | (37.7744706476124, -122.461739287117) | 11 | 6 | 2 | 54 | 11 | ||
12017 | 213228 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 180 Bright St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5993764.44098 | 2088418.41063 | 37.7140415764298 | -122.46344689056 | (37.7140415764298, -122.46344689056) | 9 | 8 | 6 | 64 | 24 | |||
12020 | 32737 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 223 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 5 | Permit Number 37120 | 5994748.23288 | 2088380.20466 | 37.7139933044225 | -122.460043789395 | (37.7139933044225, -122.460043789395) | 9 | 8 | 6 | 28861 | 24 | |
12084 | 70424 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1473 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982456.3495 | 2105108.4827 | 37.7592099556411 | -122.503766614405 | (37.7592099556411, -122.503766614405) | 1 | 8 | 3 | 56 | 35 | |||
12124 | 8617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2600 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 12 | 20 | 5999387.1761445 | 2113256.6615953 | 37.7825637442266 | -122.445797886011 | (37.7825637442266, -122.445797886011) | 15 | 5 | 1 | 29490 | 31 | |||
12135 | 41621 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 8 | Permit Number 44542 | 6011745.13959 | 2099642.07767 | 37.7458790041264 | -122.402086970256 | (37.7458790041264, -122.402086970256) | 10 | 3 | 8 | 58 | 1 | |
12185 | 30909 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 125 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 8 | Permit Number 34731 | 5994911.53291 | 2091873.96272 | 37.7235957238357 | -122.459732275923 | (37.7235957238357, -122.459732275923) | 9 | 8 | 4 | 28861 | 24 | |
12186 | 210323 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1821 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990597.81734 | 2102965.1258 | 37.7538002048324 | -122.475453298552 | (37.7538002048324, -122.475453298552) | 1 | 8 | 4 | 56 | 12 | |||
12279 | 121334 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2401x Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001103 | 2113984 | 37.7846586481563 | -122.439914057191 | (37.7846586481563, -122.439914057191) | 15 | 6 | 11 | 29490 | 13 | ||||
12303 | 37089 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 3 | Permit Number 39689 | 5981471.2295 | 2106667.1818 | 37.7634317237416 | -122.507289213813 | (37.7634317237416, -122.507289213813) | 1 | 8 | 3 | 56 | 35 | |
12320 | 24806 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 7253 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 5984468.16229 | 2112417.35948 | 37.7793961372971 | -122.497348468163 | (37.7793961372971, -122.497348468163) | 11 | 6 | 2 | 55 | 26 | |||
12386 | 73495 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 5988730.14838 | 2113498.62278 | 37.7826138532986 | -122.482683898749 | (37.7826138532986, -122.482683898749) | 11 | 6 | 2 | 55 | 26 | |||
12437 | 1235 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3645 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 5993271.90922 | 2087553.28553 | 37.7116377596374 | -122.465086457186 | (37.7116377596374, -122.465086457186) | 9 | 8 | 4 | 64 | 24 | |||
12442 | 209857 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 44 Hillway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | Permit Number 783033 | 5996120.20407 | 2106598.58834 | 37.7640953396495 | -122.45661848128 | (37.7640953396495, -122.45661848128) | 15 | 5 | 11 | 29492 | 12 | ||
12457 | 232699 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 90 Saint Marys Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004286.37545 | 2095708.10114 | 37.7346580694107 | -122.427598117859 | (37.7346580694107, -122.427598117859) | 2 | 7 | 5 | 28861 | 2 | |||
12474 | 51019 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 251 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2004 12:00:00 AM | Permit Number 47497 | 5992948.45681034 | 2088862.24435583 | 37.7152131901669 | -122.466299454682 | (37.7152131901669, -122.466299454682) | 9 | 8 | 6 | 64 | 24 | |||
12499 | 101675 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2X Daniel Burnham Ct | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6006348.55699 | 2114768.54675 | 37.7871100236423 | -122.421821900065 | (37.7871100236423, -122.421821900065) | 13 | 9 | 1 | 28858 | 41 | |||
12583 | 131471 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 280 Redwood St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006315.87363 | 2112335.20118 | 37.7804268103756 | -122.421762072675 | (37.7804268103756, -122.421762072675) | 7 | 9 | 11 | 28852 | 41 | |||
12589 | 142807 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 560 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007175.9825 | 2112820.8168 | 37.7818086588347 | -122.418820996316 | (37.7818086588347, -122.418820996316) | 7 | 9 | 9 | 28852 | 36 | |||
12623 | 182882 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3401 Wawona St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5982244.5463 | 2096704.0565 | 37.7361212874807 | -122.503876651554 | (37.7361212874807, -122.503876651554) | 1 | 8 | 3 | 29491 | 35 |
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) );