trees
8,758 rows where qSpecies_id = 16 sorted by Fire Prevention Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3458 | 260537 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1238 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5982443.47735 | 2106679.23386 | 37.7635220339644 | -122.503927471267 | (37.7635220339644, -122.503927471267) | 1 | 8 | 3 | 56 | 35 | ||
3496 | 98500 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1670 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990941.3 | 2104038.3 | 37.7567667631156 | -122.474343775715 | (37.7567667631156, -122.474343775715) | 1 | 8 | 4 | 56 | 12 | ||||
3548 | 296 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3451X 19th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 2X3 | 5990184.74118 | 2092923.50312 | 37.7262045448252 | -122.476148412917 | (37.7262045448252, -122.476148412917) | 1 | 8 | 4 | 64 | 14 | |||
3752 | 209923 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 700 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991036.77148 | 2099253.35889 | 37.7436340939434 | -122.473664564077 | (37.7436340939434, -122.473664564077) | 1 | 8 | 4 | 29491 | 40 | |||
3801 | 183067 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2642 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | SFUSD | 8 | Width 0ft | 5983405.3697 | 2096822.8928 | 37.736515769554 | -122.499872058038 | (37.736515769554, -122.499872058038) | 1 | 8 | 3 | 29491 | 35 | ||
3811 | 32184 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 191 Lakeshore Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35516 | 5984219.12182319 | 2094256.3665376 | 37.7295164954065 | -122.49686924842 | (37.7295164954065, -122.49686924842) | 1 | 8 | 4 | 64 | 35 | ||
4197 | 262260 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
4211 | 69761 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3621 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5981890.0592 | 2100093.2822 | 37.7454063146777 | -122.50535336411 | (37.7454063146777, -122.50535336411) | 1 | 8 | 3 | 29491 | 35 | |||
4629 | 79880 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1874 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5981353.9893 | 2102319.4895 | 37.7514872949963 | -122.507372114024 | (37.7514872949963, -122.507372114024) | 1 | 8 | 3 | 56 | 35 | |||
4774 | 81182 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2119 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5982918.3441 | 2100688.6349 | 37.7471014440375 | -122.501841820419 | (37.7471014440375, -122.501841820419) | 1 | 8 | 3 | 29491 | 35 | |||
4942 | 60050 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1446 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 14 | Permit Number 19548 | 5988385.7954 | 2105465.1018 | 37.7605359907495 | -122.483286128086 | (37.7605359907495, -122.483286128086) | 1 | 8 | 3 | 56 | 35 | |
5039 | 43055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2183 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/2000 12:00:00 AM | 7 | Permit Number 42905 | 5981687.8424 | 2100251.3939 | 37.7458285438516 | -122.506064306101 | (37.7458285438516, -122.506064306101) | 1 | 8 | 3 | 29491 | 35 | |
5610 | 46958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1530 43rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/01/2002 12:00:00 AM | 7 | 3x25 | Permit Number 44987 | 5982828.25460357 | 2104700.39822601 | 37.7581113313144 | -122.502450205887 | (37.7581113313144, -122.502450205887) | 1 | 8 | 3 | 56 | 35 |
5665 | 185384 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985061.3096 | 2099023.7095 | 37.7426556588679 | -122.494309028051 | (37.7426556588679, -122.494309028051) | 1 | 8 | 3 | 29491 | 35 | |||
5681 | 60249 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1254 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 13 | Permit Number 19801 | 5988030.9455 | 2106760.2014 | 37.7640713227243 | -122.484608376536 | (37.7640713227243, -122.484608376536) | 1 | 8 | 3 | 56 | 35 | |
5819 | 37136 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4641 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 7 | 3x3 | Permit Number 39718 | 5981284.3022 | 2106878.7818 | 37.7640017042438 | -122.507951428358 | (37.7640017042438, -122.507951428358) | 1 | 8 | 3 | 56 | 35 |
5849 | 79288 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50039 | 5984227.9242 | 2106296.9995 | 37.7625772948491 | -122.49772750788 | (37.7625772948491, -122.49772750788) | 1 | 8 | 3 | 56 | 35 | |
5872 | 184336 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Sunset Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 0ft | 5984831.242 | 2105456.766 | 37.7603055972166 | -122.495578904812 | (37.7603055972166, -122.495578904812) | 1 | 8 | 3 | 56 | 35 | |||
5889 | 37810 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1746 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | Permit Number 44738 | 5981328.72954544 | 2103184.35370388 | 37.7538604793554 | -122.507523629232 | (37.7538604793554, -122.507523629232) | 1 | 8 | 3 | 56 | 35 | ||
6011 | 186520 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 Sunset Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 0ft | 5984772.6613 | 2104877.4166 | 37.7587114348302 | -122.495738769506 | (37.7587114348302, -122.495738769506) | 1 | 8 | 3 | 56 | 35 | |||
6017 | 68305 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2146 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32116 | 5981725.4073 | 2100475.4291 | 37.7464458932007 | -122.505951021438 | (37.7464458932007, -122.505951021438) | 1 | 8 | 3 | 29491 | 35 | |
6164 | 68307 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2167 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32118 | 5981682.0022594 | 2100343.28066189 | 37.7460804954734 | -122.506091311951 | (37.7460804954734, -122.506091311951) | 1 | 8 | 3 | 29491 | 35 | ||
6328 | 209930 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2445 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5992320.715 | 2098815.39655 | 37.742505836878 | -122.469193170828 | (37.742505836878, -122.469193170828) | 1 | 8 | 4 | 29491 | 40 | |||
6483 | 60247 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19799 | 5988027.8819 | 2106876.6178 | 37.7643907918226 | -122.484627512544 | (37.7643907918226, -122.484627512544) | 1 | 8 | 3 | 56 | 35 | |
6500 | 209978 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 86 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5994900.84941 | 2099819.61861 | 37.7454119322075 | -122.460344637816 | (37.7454119322075, -122.460344637816) | 1 | 8 | 4 | 59 | 40 | |||
6516 | 78525 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981839.963 | 2099470.1472 | 37.7436924112004 | -122.505480405304 | (37.7436924112004, -122.505480405304) | 1 | 8 | 3 | 29491 | 35 | |||
6685 | 68314 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3815 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 7 | Permit Number 32127 | 5981596.2993 | 2100763.5953 | 37.7472295165668 | -122.506418820774 | (37.7472295165668, -122.506418820774) | 1 | 8 | 3 | 29491 | 35 | |
6725 | 209934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2497 Funston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992330.36628 | 2098511.09323 | 37.7416708550141 | -122.469137657486 | (37.7416708550141, -122.469137657486) | 1 | 8 | 4 | 29491 | 40 | |||
6775 | 256471 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2901 Sunset Blvd | 15 | Median : Yard | Tree | Private 2 | 3x3 | 5984945 | 2095183 | 37.7321032922905 | -122.494428131787 | (37.7321032922905, -122.494428131787) | 1 | 8 | 4 | 64 | 35 | ||||
6780 | 31935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1330 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 6 | Permit Number 35351 | 5981536.6923 | 2106016.9784 | 37.7616503077312 | -122.507014568071 | (37.7616503077312, -122.507014568071) | 1 | 8 | 3 | 56 | 35 | |
6784 | 60048 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1463 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 14 | Permit Number 19546 | 5988345.982 | 2105367.5756 | 37.7602658931923 | -122.483416673161 | (37.7602658931923, -122.483416673161) | 1 | 8 | 3 | 56 | 35 | |
6824 | 185239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2519 44th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 0ft | 5982695.2777 | 2097952.3458 | 37.7395752424776 | -122.502410672836 | (37.7395752424776, -122.502410672836) | 1 | 8 | 3 | 29491 | 35 | |||
6885 | 259563 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200 Public Park | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 5x10 | 5994204 | 2098512 | 37.741781429361 | -122.462659374294 | (37.741781429361, -122.462659374294) | 1 | 8 | 4 | 59 | 40 | ||||
7005 | 60053 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1406 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/1982 12:00:00 AM | 24 | 3x3 | Permit Number 19552 | 5988377.0869 | 2105705.2719 | 37.7611949257495 | -122.483333852456 | (37.7611949257495, -122.483333852456) | 1 | 8 | 3 | 56 | 35 |
7034 | 184301 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981896.8997 | 2104553.6198 | 37.7576535496395 | -122.505660295506 | (37.7576535496395, -122.505660295506) | 1 | 8 | 3 | 56 | 35 | |||
7518 | 20555 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1305X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | 5984811.9199471 | 2106303.0061321 | 37.7626280043626 | -122.495708151398 | (37.7626280043626, -122.495708151398) | 1 | 8 | 3 | 56 | 35 | |||
7611 | 70362 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3934 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5982621.9145 | 2104937.2986 | 37.7587496661055 | -122.503181346298 | (37.7587496661055, -122.503181346298) | 1 | 8 | 3 | 56 | 35 | |||
7741 | 261484 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1000 Portola Dr | 12 | Median : Yard | Tree | DPW 1 | 10x10 | 5995664 | 2098286 | 37.741244865522 | -122.457594860017 | (37.741244865522, -122.457594860017) | 1 | 8 | 4 | 59 | 40 | ||||
7802 | 184178 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1604 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5980981.8741 | 2104106.8749 | 37.756373020872 | -122.508791602838 | (37.756373020872, -122.508791602838) | 1 | 8 | 3 | 56 | 35 | |||
7875 | 71825 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1555 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 5988675.2864 | 2104754.3629 | 37.758601337299 | -122.482232850163 | (37.758601337299, -122.482232850163) | 1 | 8 | 3 | 56 | 35 | |||
7993 | 185387 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2300 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 0ft | 5985052.013 | 2099287.3331 | 37.7433789539578 | -122.494360600593 | (37.7433789539578, -122.494360600593) | 1 | 8 | 3 | 29491 | 35 | |||
8054 | 251208 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4115 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5982071 | 2104840 | 37.7584501132023 | -122.505079418654 | (37.7584501132023, -122.505079418654) | 1 | 8 | 3 | 56 | 35 | |||
8345 | 258530 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2122 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/28/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784316 | 5981434 | 2100610 | 37.7467982300359 | -122.506968637856 | (37.7467982300359, -122.506968637856) | 1 | 8 | 3 | 29491 | 35 |
8365 | 183280 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1246 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5982138.4385 | 2106606.3363 | 37.763303936332 | -122.504977083187 | (37.763303936332, -122.504977083187) | 1 | 8 | 3 | 56 | 35 | |||
8430 | 112946 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2567 16TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5991374 | 2097953 | 37.7400831663883 | -122.472403743487 | (37.7400831663883, -122.472403743487) | 1 | 8 | 4 | 29491 | 40 | ||||
8478 | 63679 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3900 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | 11 | Permit Number 24332 | 5982744.7336 | 2104942.115 | 37.7587701092211 | -122.502756944956 | (37.7587701092211, -122.502756944956) | 1 | 8 | 3 | 56 | 35 | |
8690 | 183553 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1202 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5989150.9777 | 2097677.2182 | 37.7391970264356 | -122.480069779917 | (37.7391970264356, -122.480069779917) | 1 | 8 | 3 | 29491 | 35 | |||
8815 | 60244 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1211 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/1982 12:00:00 AM | 14 | Permit Number 19796 | 5987977.3326 | 2107012.5647 | 37.764761120752 | -122.484812320079 | (37.764761120752, -122.484812320079) | 1 | 8 | 3 | 56 | 35 | |
8839 | 60946 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1422 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1983 12:00:00 AM | Permit Number 20749 | 5990554.23882352 | 2105697.78860744 | 37.7613008451159 | -122.475803544713 | (37.7613008451159, -122.475803544713) | 1 | 8 | 4 | 56 | 12 | ||
9060 | 183028 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2550 41st Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983678.1778 | 2097913.7541 | 37.739526984806 | -122.499009432355 | (37.739526984806, -122.499009432355) | 1 | 8 | 3 | 29491 | 35 | |||
9321 | 70250 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1475 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5982457.955 | 2105055.9033 | 37.759065681929 | -122.503757167883 | (37.759065681929, -122.503757167883) | 1 | 8 | 3 | 56 | 35 | |||
9346 | 66616 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2450 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1991 12:00:00 AM | 3 | Permit Number 29819 | 5985544.9203 | 2098918.2658 | 37.742394428205 | -122.492629101957 | (37.742394428205, -122.492629101957) | 1 | 8 | 3 | 29491 | 35 | ||
9347 | 114899 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1545 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2015 12:00:00 AM | Permit Number 774413 | 5981525.9 | 2104542.4 | 37.7576009016243 | -122.506942509341 | (37.7576009016243, -122.506942509341) | 1 | 8 | 3 | 56 | 35 | |||
9777 | 184408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3930 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5981297.8113 | 2100810.2975 | 37.7473401694267 | -122.507454415813 | (37.7473401694267, -122.507454415813) | 1 | 8 | 3 | 29491 | 35 | |||
9844 | 78523 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981811.5356 | 2099469.1319 | 37.7436879505195 | -122.505578623462 | (37.7436879505195, -122.505578623462) | 1 | 8 | 3 | 29491 | 35 | |||
9878 | 186643 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1401 Sunset Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 0ft | 5984764.0775 | 2105097.6653 | 37.7593156736844 | -122.495784702365 | (37.7593156736844, -122.495784702365) | 1 | 8 | 3 | 56 | 35 | |||
9884 | 73155 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1539 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5984024.4181 | 2104677.685 | 37.7581191804023 | -122.498311745037 | (37.7581191804023, -122.498311745037) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | |
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 | |||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | |
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 | |||
12864 | 209925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2399X 17th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 5991053 | 2099414 | 37.7440761128751 | -122.473620166067 | (37.7440761128751, -122.473620166067) | 1 | 8 | 4 | 29491 | 40 | |||
13141 | 386 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3721X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2 | 5990351.3309 | 2090950.31436 | 37.7207963201663 | -122.475428522866 | (37.7207963201663, -122.475428522866) | 1 | 8 | 4 | 64 | 14 | |||
13196 | 46378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2270 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/05/2002 12:00:00 AM | 3 | Permit Number 44615 | 5982995.4513 | 2099678.43 | 37.7443322293912 | -122.501500475193 | (37.7443322293912, -122.501500475193) | 1 | 8 | 3 | 29491 | 35 | |
13207 | 210348 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 349 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991814.98108 | 2097712.03468 | 37.7394470501364 | -122.470861477093 | (37.7394470501364, -122.470861477093) | 1 | 8 | 4 | 59 | 40 | |||
13209 | 209883 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1862 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1987 12:00:00 AM | 11 | Width 3ft | Permit Number 24352 | 5993165.67031 | 2102796.35427 | 37.7534853189133 | -122.46656088218 | (37.7534853189133, -122.46656088218) | 1 | 8 | 4 | 56 | 12 | |
13254 | 74488 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2334 42nd Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5983318.4565 | 2099328.1281 | 37.7433893618735 | -122.500357715236 | (37.7433893618735, -122.500357715236) | 1 | 8 | 3 | 29491 | 35 | |||
13300 | 63559 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3655 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1987 12:00:00 AM | 7 | Permit Number 24181 | 5982862.532 | 2104209.7007 | 37.7567660283709 | -122.502295347911 | (37.7567660283709, -122.502295347911) | 1 | 8 | 3 | 56 | 35 | |
13309 | 184233 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1560 43rd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5982830.1411 | 2104513.1361 | 37.757597273235 | -122.502429822459 | (37.757597273235, -122.502429822459) | 1 | 8 | 3 | 56 | 35 | |||
13612 | 56875 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2833 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/1974 12:00:00 AM | 10 | Permit Number 14111 | 5985174.6991 | 2102919.4422 | 37.7533589143678 | -122.494204043892 | (37.7533589143678, -122.494204043892) | 1 | 8 | 3 | 56 | 35 | ||
13791 | 47886 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4737 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2002 12:00:00 AM | 6 | Permit Number 45632 | 5981014.1249 | 2106186.9276 | 37.7620861496896 | -122.508834503155 | (37.7620861496896, -122.508834503155) | 1 | 8 | 3 | 56 | 35 | |
13964 | 42655 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2535 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 7 | Permit Number 42692 | 5983937.5442 | 2098094.9316 | 37.7400396597472 | -122.498126046785 | (37.7400396597472, -122.498126046785) | 1 | 8 | 3 | 29491 | 35 | |
14019 | 18119 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400 Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | 6 | 10 | 5993139.2629046 | 2097621.4275272 | 37.7392747636088 | -122.466276146282 | (37.7392747636088, -122.466276146282) | 1 | 8 | 4 | 59 | 40 | |||
14078 | 78524 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3550 Santiago St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981824.7341 | 2099468.7935 | 37.7436877981073 | -122.50553296194 | (37.7436877981073, -122.50553296194) | 1 | 8 | 3 | 29491 | 35 | |||
14271 | 74932 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1494 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 4.5x6 | 5982503.1091 | 2104954.5575 | 37.7587900699554 | -122.503593501173 | (37.7587900699554, -122.503593501173) | 1 | 8 | 3 | 56 | 35 | ||
14348 | 31622 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/22/1995 12:00:00 AM | Permit Number 35554 | 5992052.25118753 | 2099087.40328319 | 37.7432371814309 | -122.470141233061 | (37.7432371814309, -122.470141233061) | 1 | 8 | 4 | 29491 | 40 | ||
14397 | 58813 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1234 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/1988 12:00:00 AM | 10 | Permit Number 25136 | 5989578.4419 | 2106919.1252 | 37.7645976827024 | -122.479267726224 | (37.7645976827024, -122.479267726224) | 1 | 8 | 3 | 56 | 35 | ||
14440 | 209990 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2162 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5992613.22888 | 2100719.26889 | 37.7477502828637 | -122.468320229522 | (37.7477502828637, -122.468320229522) | 1 | 8 | 4 | 29491 | 40 | |||
14487 | 79638 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1307 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982729.5509 | 2106184.5595 | 37.7621806168968 | -122.502901428306 | (37.7621806168968, -122.502901428306) | 1 | 8 | 3 | 56 | 35 | |||
14652 | 257979 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2126 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x4 | 5981719.28463 | 2100605.34561 | 37.7468022472561 | -122.5059818232 | (37.7468022472561, -122.5059818232) | 1 | 8 | 3 | 29491 | 35 | |||
15025 | 37102 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1200 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | Permit Number 39701 | 5981201.77477995 | 2106888.46207069 | 37.7640234205488 | -122.508237579769 | (37.7640234205488, -122.508237579769) | 1 | 8 | 3 | 56 | 35 | ||
15037 | 262257 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2 Everglade Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 5986312 | 2095495 | 37.7330398702545 | -122.489725113139 | (37.7330398702545, -122.489725113139) | 1 | 8 | 4 | 64 | 35 | ||||
15135 | 182891 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2701 45th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5982435.5854 | 2096557.1815 | 37.7357292403034 | -122.503205291534 | (37.7357292403034, -122.503205291534) | 1 | 8 | 3 | 29491 | 35 | |||
15225 | 210269 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1321 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1983 12:00:00 AM | 10 | Width 3ft | Permit Number 20744 | 5990716.35188 | 2105159.9942 | 37.7598336026602 | -122.475203607164 | (37.7598336026602, -122.475203607164) | 1 | 8 | 4 | 56 | 12 | |
15234 | 185663 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2101 Sunset Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 0ft | 5984920.2579 | 2100633.0273 | 37.7470661531582 | -122.494915370419 | (37.7470661531582, -122.494915370419) | 1 | 8 | 3 | 29491 | 35 | |||
15308 | 183025 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2550 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983679.4773 | 2097838.814 | 37.7393212958721 | -122.498999403907 | (37.7393212958721, -122.498999403907) | 1 | 8 | 3 | 29491 | 35 | |||
15371 | 209896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 850 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5991895.12342 | 2105938.54186 | 37.7620395398243 | -122.471183574658 | (37.7620395398243, -122.471183574658) | 1 | 8 | 11 | 56 | 12 |
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) );