trees
8,758 rows where qSpecies_id = 16 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8806 | 41617 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 4 | Permit Number 44542 | 6011837.54866 | 2099572.35682 | 37.7456927230357 | -122.401762530825 | (37.7456927230357, -122.401762530825) | 10 | 3 | 8 | 58 | 1 | |
9136 | 11920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
9199 | 59852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1123 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | 4x4 | Permit Number 19308 | 6017402.1303 | 2093334.4078 | 37.7288735235199 | -122.382086980049 | (37.7288735235199, -122.382086980049) | 10 | 3 | 8 | 58 | 1 |
9371 | 199999 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1450 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017702.3066 | 2092388.4628 | 37.7262927161578 | -122.380983501033 | (37.7262927161578, -122.380983501033) | 10 | 3 | 8 | 58 | 1 | |||
9540 | 83049 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 11 | 6018864.16071 | 2097578.25634 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||
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 | |||
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 |
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 | |||
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 | |
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 | |||
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 | |
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 | |||
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 | |
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 | |
12818 | 41626 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2002 12:00:00 AM | 7 | Permit Number 46000 | 6011671.24586 | 2099696.54444 | 37.7460244334925 | -122.402346314957 | (37.7460244334925, -122.402346314957) | 10 | 3 | 8 | 58 | 1 | |
13261 | 10837 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1139X Hudson Ave | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/1995 12:00:00 AM | 6 | 3X4 | 6017972.55601 | 2094607.03401 | 37.7323993935967 | -122.380203361451 | (37.7323993935967, -122.380203361451) | 10 | 3 | 8 | 58 | 1 | ||
13488 | 200023 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6017489.0598 | 2092100.1023 | 37.7254891615497 | -122.381700645666 | (37.7254891615497, -122.381700645666) | 10 | 3 | 8 | 58 | 1 | |||
13537 | 10608 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6016953.56125 | 2095500.30528 | 37.7347958653241 | -122.383788471781 | (37.7347958653241, -122.383788471781) | 10 | 3 | 8 | 58 | 1 | |||
13760 | 74588 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017904.0953 | 2092578.1569 | 37.7268247152753 | -122.380299097717 | (37.7268247152753, -122.380299097717) | 10 | 3 | 8 | 58 | 1 | |||
14134 | 10928 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1338X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017067.78489 | 2095945.48919 | 37.7360245649694 | -122.383424537716 | (37.7360245649694, -122.383424537716) | 10 | 3 | 8 | 58 | 1 | |||
14477 | 60391 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1466 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19971 | 6015630.4552 | 2094729.0488 | 37.7326049228687 | -122.388309135448 | (37.7326049228687, -122.388309135448) | 10 | 3 | 8 | 58 | 1 | |
14564 | 75201 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6017848.7148 | 2092502.4066 | 37.7266136638108 | -122.380485286019 | (37.7266136638108, -122.380485286019) | 10 | 3 | 8 | 58 | 1 | |||
14975 | 193793 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 25th St | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6014229.14205 | 2101967.67513 | 37.7524029335523 | -122.393660311891 | (37.7524029335523, -122.393660311891) | 10 | 3 | 8 | 28856 | 1 | ||||
15412 | 41620 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 7 | Permit Number 44542 | 6011764.26407 | 2099627.4064 | 37.7458397873891 | -122.402019808872 | (37.7458397873891, -122.402019808872) | 10 | 3 | 8 | 58 | 1 | |
15825 | 60408 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1438 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | 3x3 | Permit Number 19989 | 6016124.8888 | 2094009.3762 | 37.7306562300917 | -122.386549578822 | (37.7306562300917, -122.386549578822) | 10 | 3 | 8 | 58 | 1 |
16296 | 60403 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1547 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 11 | Permit Number 19984 | 6015505.1437 | 2094394.6098 | 37.7316796762211 | -122.388719033204 | (37.7316796762211, -122.388719033204) | 10 | 3 | 8 | 58 | 1 | |
16381 | 60365 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1411 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19943 | 6015862.9412 | 2094478.9752 | 37.7319311503682 | -122.387487927897 | (37.7319311503682, -122.387487927897) | 10 | 3 | 8 | 58 | 1 | |
16384 | 59855 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1195 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 14 | Permit Number 19312 | 6017044.3327 | 2093602.6185 | 37.7295902103514 | -122.383342586023 | (37.7295902103514, -122.383342586023) | 10 | 3 | 8 | 58 | 1 | |
16389 | 59849 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1271 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 16 | 6x6 | Permit Number 19304 | 6016627.7267 | 2093908.2029 | 37.7304062521082 | -122.3848041294 | (37.7304062521082, -122.3848041294) | 10 | 3 | 8 | 58 | 1 |
16433 | 60383 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1390 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 17 | Permit Number 19963 | 6016068.2256 | 2094403.79893 | 37.7317360992349 | -122.386772969112 | (37.7317360992349, -122.386772969112) | 10 | 3 | 8 | 58 | 1 | |
16540 | 200694 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1605 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015113.2701 | 2095748.5795 | 37.7353756762763 | -122.390168386322 | (37.7353756762763, -122.390168386322) | 10 | 3 | 8 | 58 | 1 | |||
16694 | 60378 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1290 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19958 | 6016574.72071 | 2094023.91948 | 37.7307210551112 | -122.384995439293 | (37.7307210551112, -122.384995439293) | 10 | 3 | 8 | 58 | 1 | |
16970 | 60371 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1443 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | 3x3 | Permit Number 19949 | 6015704.6529 | 2094599.8899 | 37.7322543895383 | -122.388043603722 | (37.7322543895383, -122.388043603722) | 10 | 3 | 8 | 58 | 1 |
17038 | 59845 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1242 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 9 | 3x3 | Permit Number 19956 | 6016795.10947 | 2093858.56743 | 37.7302792190936 | -122.38422200256 | (37.7302792190936, -122.38422200256) | 10 | 3 | 8 | 58 | 1 |
17391 | 3602 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.44706 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | 10 | 3 | 8 | 58 | 1 | ||
17493 | 60366 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1415 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 16 | Permit Number 19944 | 6015838.2087 | 2094497.6621 | 37.7319810909702 | -122.387574737396 | (37.7319810909702, -122.387574737396) | 10 | 3 | 8 | 58 | 1 | |
17523 | 11896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 603 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | 6017299.30184 | 2096353.90744 | 37.7371587926313 | -122.382652493121 | (37.7371587926313, -122.382652493121) | 10 | 3 | 8 | 58 | 1 | ||
17672 | 60374 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1481 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 8 | Permit Number 19952 | 6015496.3499 | 2094754.331 | 37.7326669109096 | -122.388774538468 | (37.7326669109096, -122.388774538468) | 10 | 3 | 8 | 58 | 1 | |
17872 | 258685 | Property Tree 8 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100x Whitney Young Cir | 2 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
18044 | 262512 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
18071 | 74888 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1335 Griffith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6017884.362 | 2092550.785 | 37.7267484685203 | -122.380365414433 | (37.7267484685203, -122.380365414433) | 10 | 3 | 8 | 58 | 1 | |||
18077 | 262510 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2230 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012281 | 2099339 | 37.74507671213 | -122.400212745638 | (37.74507671213, -122.400212745638) | 10 | 3 | 8 | 58 | 1 | ||||
18409 | 41619 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2285 Jerrold Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2002 12:00:00 AM | 6 | Permit Number 44542 | 6011782.21791 | 2099613.94885 | 37.7458038378927 | -122.401956780795 | (37.7458038378927, -122.401956780795) | 10 | 3 | 8 | 58 | 1 | |
18742 | 60351 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1151 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19929 | 6017264.1776 | 2093436.6356 | 37.7291466011683 | -122.382571007193 | (37.7291466011683, -122.382571007193) | 10 | 3 | 8 | 58 | 1 | |
18828 | 60398 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1499 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19979 | 6015809.7578 | 2094169.3658 | 37.7310780791324 | -122.387650202586 | (37.7310780791324, -122.387650202586) | 10 | 3 | 8 | 58 | 1 | |
18846 | 60396 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1437 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 12 | Permit Number 19976 | 6016099.8399 | 2093952.5449 | 37.7304987959412 | -122.386632216078 | (37.7304987959412, -122.386632216078) | 10 | 3 | 8 | 58 | 1 | |
19190 | 59857 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1227 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 15 | 4x4 | Permit Number 19314 | 6016837.6785 | 2093749.365 | 37.7299817243668 | -122.384067232705 | (37.7299817243668, -122.384067232705) | 10 | 3 | 8 | 58 | 1 |
19269 | 59844 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1235 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 14 | Permit Number 19299 | 6016800.8545 | 2093779.0441 | 37.7300611813825 | -122.384196605056 | (37.7300611813825, -122.384196605056) | 10 | 3 | 8 | 58 | 1 | |
20045 | 177652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011945.30264 | 2086766.19057 | 37.710535648564 | -122.400490543214 | (37.710535648564, -122.400490543214) | 10 | 3 | 8 | 309 | 1 | |||
20648 | 38458 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1115 Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/20/1998 12:00:00 AM | Permit Number 40472 | 6017828.60751249 | 2092672.1730279 | 37.7270786999418 | -122.380566591765 | (37.7270786999418, -122.380566591765) | 10 | 3 | 8 | 58 | 1 | ||
20655 | 194009 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1484 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6016306.86692 | 2097023.7749 | 37.7389432364405 | -122.386130508726 | (37.7389432364405, -122.386130508726) | 10 | 3 | 8 | 58 | 1 | |||
20694 | 11897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
20792 | 194005 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 900 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6019962.69863 | 2093253.82353 | 37.7287933376393 | -122.373229233067 | (37.7287933376393, -122.373229233067) | 10 | 3 | 8 | 58 | 1 | |||
21055 | 193931 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 102 Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6016668.18905 | 2095404.61694 | 37.7345173453007 | -122.384768447719 | (37.7345173453007, -122.384768447719) | 10 | 3 | 8 | 58 | 1 | |||
21204 | 56719 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1546 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 6015682.1188 | 2095740.885 | 37.7353860836846 | -122.388201110466 | (37.7353860836846, -122.388201110466) | 10 | 3 | 8 | 58 | 1 | ||||
21418 | 10896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
22233 | 11427 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 722X Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016169.29297 | 2097000.91139 | 37.7388728426442 | -122.38660458642 | (37.7388728426442, -122.38660458642) | 10 | 3 | 8 | 58 | 1 | |||
22705 | 60402 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1545 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1983 12:00:00 AM | Permit Number 19983 | 6015531.43578619 | 2094383.98110516 | 37.7316519491055 | -122.38862739374 | (37.7316519491055, -122.38862739374) | 10 | 3 | 8 | 58 | 1 | ||
22854 | 35428 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1501 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1998 12:00:00 AM | Permit Number 38876 | 6014234.60360095 | 2101971.010972 | 37.7524123965466 | -122.393641658261 | (37.7524123965466, -122.393641658261) | 10 | 3 | 8 | 28856 | 1 | ||
22996 | 11425 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 722X Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016169.29297 | 2097000.91139 | 37.7388728426442 | -122.38660458642 | (37.7388728426442, -122.38660458642) | 10 | 3 | 8 | 58 | 1 | |||
23261 | 193927 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 102 Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 6ft | 6016656.21357 | 2095327.44827 | 37.7343047932166 | -122.384804477241 | (37.7343047932166, -122.384804477241) | 10 | 3 | 8 | 58 | 1 | |||
23396 | 194011 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 720 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6016105.42018 | 2096909.14966 | 37.7386173473073 | -122.38681903327 | (37.7386173473073, -122.38681903327) | 10 | 3 | 8 | 58 | 1 | |||
23485 | 3487 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 301X Cargo Way | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018082.70776 | 2098082.14529 | 37.7419474372657 | -122.380063931104 | (37.7419474372657, -122.380063931104) | 10 | 3 | 8 | 58 | 1 | |||
23549 | 38468 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1100 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1998 12:00:00 AM | Permit Number 40474 | 6017753.62383168 | 2092443.69095596 | 37.7264471943371 | -122.380809935654 | (37.7264471943371, -122.380809935654) | 10 | 3 | 8 | 58 | 1 | ||
24159 | 10982 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1478 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016356.31002 | 2096980.69736 | 37.7388276906321 | -122.385956553763 | (37.7388276906321, -122.385956553763) | 10 | 3 | 8 | 58 | 1 | |||
25668 | 177650 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 451 Tocoloma Ave | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 5ft | 6012434.26652 | 2086449.48006 | 37.7096932805964 | -122.398778354552 | (37.7096932805964, -122.398778354552) | 10 | 3 | 8 | 309 | 1 | |||
25769 | 193993 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6017119.98315 | 2096509.53696 | 37.7375762120827 | -122.383283315377 | (37.7375762120827, -122.383283315377) | 10 | 3 | 8 | 58 | 1 | |||
25955 | 12134 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1400X La Salle Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/17/1996 12:00:00 AM | 8 | 3X3 | 6016411.87063 | 2095295.25189 | 37.7342028712732 | -122.385647014298 | (37.7342028712732, -122.385647014298) | 10 | 3 | 8 | 58 | 1 | ||
26402 | 10943 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1398X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6016847.08406 | 2096598.97391 | 37.7378067029035 | -122.384233093 | (37.7378067029035, -122.384233093) | 10 | 3 | 8 | 58 | 1 | ||
26856 | 193820 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501 Phelps St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6015466.67819 | 2098214.62302 | 37.7421665235731 | -122.389118644737 | (37.7421665235731, -122.389118644737) | 10 | 3 | 8 | 58 | 1 | |||
27410 | 193961 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1342 Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6016993.10163 | 2096343.37484 | 37.7371129515086 | -122.383710443878 | (37.7371129515086, -122.383710443878) | 10 | 3 | 8 | 58 | 1 | |||
28072 | 10607 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 22 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6016994.80167 | 2095495.89651 | 37.7347860393267 | -122.383645581171 | (37.7347860393267, -122.383645581171) | 10 | 3 | 8 | 58 | 1 | |||
28312 | 10967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1443 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016505.63953 | 2096794.13456 | 37.7383236898955 | -122.385427239795 | (37.7383236898955, -122.385427239795) | 10 | 3 | 8 | 58 | 1 | |||
28438 | 3556 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Cargo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018742.23536 | 2097565.89761 | 37.7405662870104 | -122.377747650939 | (37.7405662870104, -122.377747650939) | 10 | 3 | 8 | 58 | 1 | |||
28912 | 60362 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1367 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19940 | 6016120.25691053 | 2094294.89979422 | 37.7314399645537 | -122.386585493961 | (37.7314399645537, -122.386585493961) | 10 | 3 | 8 | 58 | 1 | ||
29203 | 60394 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1490 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19974 | 6015495.25589762 | 2094826.0117953 | 37.7328636713029 | -122.388783323056 | (37.7328636713029, -122.388783323056) | 10 | 3 | 8 | 58 | 1 | ||
29842 | 193926 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 74 Whitney Young Cir | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6016903.35372 | 2094956.13676 | 37.7332989114136 | -122.383924179463 | (37.7332989114136, -122.383924179463) | 10 | 3 | 8 | 58 | 1 | |||
30065 | 107237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 HUDSON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 6017131 | 2095773 | 37.7355544375929 | -122.383193973215 | (37.7355544375929, -122.383193973215) | 10 | 3 | 8 | 58 | 1 | ||||
30842 | 10984 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1482 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016335.01442 | 2096998.54708 | 37.7388755237906 | -122.386031428633 | (37.7388755237906, -122.386031428633) | 10 | 3 | 8 | 58 | 1 | |||
30978 | 193844 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2065 Thomas Ave | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6012352.39283 | 2095671.77619 | 37.7350112709454 | -122.399708436121 | (37.7350112709454, -122.399708436121) | 10 | 3 | 8 | 58 | 1 | |||
32145 | 60414 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1508 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1982 12:00:00 AM | 15 | Permit Number 19995 | 6015698.0576 | 2094327.0075 | 37.7315047437973 | -122.388047369513 | (37.7315047437973, -122.388047369513) | 10 | 3 | 8 | 58 | 1 | ||
32449 | 22152 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1570X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015582.155926 | 2098251.094071 | 37.7422730663447 | -122.388721900675 | (37.7422730663447, -122.388721900675) | 10 | 3 | 8 | 58 | 1 | |||
33057 | 194008 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1484 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6016322.5463 | 2097011.8333 | 37.7389113150171 | -122.386075463935 | (37.7389113150171, -122.386075463935) | 10 | 3 | 8 | 58 | 1 | |||
33186 | 3613 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.7423214758653 | -122.380345828295 | (37.7423214758653, -122.380345828295) | 10 | 3 | 8 | 58 | 1 | |||
33325 | 10615 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6016878.19389 | 2095639.30645 | 37.7351733683384 | -122.384058721653 | (37.7351733683384, -122.384058721653) | 10 | 3 | 8 | 58 | 1 | |||
33643 | 3514 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 201X Cargo Way | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018078.86698 | 2098059.01516 | 37.7418837146726 | -122.380075604504 | (37.7418837146726, -122.380075604504) | 10 | 3 | 8 | 58 | 1 | ||
33883 | 3629 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017712.66324 | 2098437.04484 | 37.7429014981049 | -122.381368111942 | (37.7429014981049, -122.381368111942) | 10 | 3 | 8 | 58 | 1 | |||
34094 | 10709 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 16 Hillview Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6016599.83487 | 2095766.29094 | 37.7355066490105 | -122.385029963356 | (37.7355066490105, -122.385029963356) | 10 | 3 | 8 | 58 | 1 | |||
34708 | 50631 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1198 Gilman Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2003 12:00:00 AM | Permit Number 47223 | 6014541.97081926 | 2090297.22948146 | 37.7203756614272 | -122.39176255443 | (37.7203756614272, -122.39176255443) | 10 | 3 | 8 | 58 | 1 | |||
34978 | 193997 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 680 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6017003.43721 | 2096541.52565 | 37.7376576052106 | -122.383688500438 | (37.7376576052106, -122.383688500438) | 10 | 3 | 8 | 58 | 1 | |||
35052 | 194013 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 720 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6016073.73139 | 2096869.54545 | 37.7385068476195 | -122.386925837662 | (37.7385068476195, -122.386925837662) | 10 | 3 | 8 | 58 | 1 | |||
35455 | 47256 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1035 Gilman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/09/2002 12:00:00 AM | 6 | 3x3 | Permit Number 45198 | 6015368.10493708 | 2089617.80548286 | 37.7185559218928 | -122.388859444456 | (37.7185559218928, -122.388859444456) | 10 | 3 | 8 | 58 | 1 |
35489 | 24105 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 105X Whitney Young Cir | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016397.2233978 | 2096041.081358 | 37.7362499588234 | -122.385749620885 | (37.7362499588234, -122.385749620885) | 10 | 3 | 8 | 58 | 1 | |||
35825 | 10986 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 713X Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016175.23791 | 2096932.62774 | 37.7386856787052 | -122.38657927131 | (37.7386856787052, -122.38657927131) | 10 | 3 | 8 | 58 | 1 | |||
35963 | 64524 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1580 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1988 12:00:00 AM | Permit Number 25406 | 6015179.7795302 | 2095406.78838863 | 37.7344408760241 | -122.389914569118 | (37.7344408760241, -122.389914569118) | 10 | 3 | 8 | 58 | 1 | ||
36310 | 29399 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2923X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6014585.06458 | 2090356.48444 | 37.7205407559713 | -122.391617732808 | (37.7205407559713, -122.391617732808) | 10 | 3 | 8 | 58 | 1 | |||
36616 | 11906 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
36676 | 22150 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1570X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015582.155926 | 2098251.094071 | 37.7422730663447 | -122.388721900675 | (37.7422730663447, -122.388721900675) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );