trees
8,758 rows where qSpecies_id = 16 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7606 | 193912 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 151 Berry St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6014944.72987 | 2110876.13402 | 37.7769033583289 | -122.391808518763 | (37.7769033583289, -122.391808518763) | 6 | 2 | 9 | 28856 | 20 | |||
7630 | 24158 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 110X Whitney Young Cir | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016346.0952597 | 2096044.1423309 | 37.736255534298 | -122.385926606914 | (37.736255534298, -122.385926606914) | 10 | 3 | 8 | 58 | 1 | |||
7688 | 58773 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1185 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/1979 12:00:00 AM | 17 | Permit Number 18016 | 6011971.93292 | 2102954.59115 | 37.7549871030883 | -122.401535514949 | (37.7549871030883, -122.401535514949) | 10 | 3 | 8 | 28856 | 29 | ||
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 | |||
7914 | 193840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101 Barneveld Ave | 8 | : | Tree | Private 2 | 6 | Width 3ft | 6011575.20658 | 2099640.54229 | 37.7458653020467 | -122.402674470349 | (37.7458653020467, -122.402674470349) | 10 | 3 | 8 | 58 | 1 | |||
7957 | 231433 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001197.9223 | 2097527.04801 | 37.739477296143 | -122.438406199002 | (37.739477296143, -122.438406199002) | 2 | 7 | 5 | 63 | 7 | |||
7984 | 213195 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 66 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5995352.58216 | 2090355.50173 | 37.7194517449684 | -122.45809781389 | (37.7194517449684, -122.45809781389) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
8006 | 9157 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6000 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5988304.2257 | 2112648.9137 | 37.7802560029507 | -122.484095058697 | (37.7802560029507, -122.484095058697) | 11 | 6 | 2 | 55 | 26 | |||
8044 | 90232 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2738 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986996.67991 | 2111198.28734 | 37.7761967812113 | -122.488511755965 | (37.7761967812113, -122.488511755965) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
8148 | 7734 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 300 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | War Memorial 17 | 12 | 3x3 | 6006417.36011 | 2111247.60822 | 37.777446266458 | -122.421333726477 | (37.777446266458, -122.421333726477) | 7 | 9 | 11 | 28852 | 10 | |||
8173 | 193892 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 10 De Boom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6014902.21965 | 2113000.89074 | 37.7827351011774 | -122.392104203263 | (37.7827351011774, -122.392104203263) | 6 | 2 | 9 | 28856 | 6 | |||
8194 | 24582 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731 Cortland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2X3 | 6007975.47278 | 2097199.92125 | 37.7389622589098 | -122.414949173076 | (37.7389622589098, -122.414949173076) | 2 | 7 | 7 | 28859 | 2 | |||
8283 | 19872 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100 STAIRWAY33 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 25ST | |||||||||||||
8323 | 10894 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 1 | 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 | |||
8332 | 131472 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 280 Redwood St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006289.44845 | 2112330.99569 | 37.7804137729253 | -122.421853191093 | (37.7804137729253, -122.421853191093) | 7 | 9 | 11 | 28852 | 41 | |||
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 | ||||
8499 | 8180 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1205X Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002000.37874 | 2111170.93633 | 37.7769857283744 | -122.436608008152 | (37.7769857283744, -122.436608008152) | 15 | 5 | 11 | 29492 | 10 | |||
8514 | 250400 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 15 Seacliff Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5988097.76743 | 2115798.38338 | 37.7888915289683 | -122.485040420476 | (37.7888915289683, -122.485040420476) | 11 | 6 | 1 | 55 | 33 | |||
8676 | 34246 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38056 | |||||||||||||||
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 | |||
8762 | 97574 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 501x Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999116.8 | 2114959.9 | 37.7872249510267 | -122.4468558657 | (37.7872249510267, -122.4468558657) | 15 | 6 | 1 | 54 | 31 | |||||
8796 | 146945 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 653 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 3ft | 5982243.60068 | 2111319.85778 | 37.7762520882053 | -122.504962680002 | (37.7762520882053, -122.504962680002) | 11 | 6 | 2 | 55 | 26 | ||
8797 | 213239 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 25 Majestic Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997415.57746 | 2089795.63137 | 37.7180327919586 | -122.450926484985 | (37.7180327919586, -122.450926484985) | 9 | 8 | 6 | 28861 | 24 | |||
8940 | 119554 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 601 30th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5986557.94783 | 2112181.99105 | 37.7788721422837 | -122.490101801894 | (37.7788721422837, -122.490101801894) | 11 | 6 | 2 | 55 | 26 | |||
9011 | 6052 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1900 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2003 12:00:00 AM | 3 | 3X3 | 6001270.4508 | 2112511.2313 | 37.7806243318768 | -122.439229137442 | (37.7806243318768, -122.439229137442) | 15 | 5 | 11 | 29490 | 41 | ||
9040 | 3086 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2925 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 3X3 | 6000198.2675 | 2115085.6403 | 37.7876319239021 | -122.443123265692 | (37.7876319239021, -122.443123265692) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
9076 | 9908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1809 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 6x6 | 6005225.98494 | 2115998.17525 | 37.7904229062421 | -122.425793311632 | (37.7904229062421, -122.425793311632) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
9175 | 232785 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 311 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001794.37579 | 2104040.43503 | 37.7573954200892 | -122.436810069649 | (37.7573954200892, -122.436810069649) | 2 | 4 | 5 | 28862 | 3 | |||
9192 | 9302 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 320X Mansell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1992 12:00:00 AM | 6 | 3X100 | 6010916.2744 | 2090546.6069 | 37.7208584636334 | -122.404313017158 | (37.7208584636334, -122.404313017158) | 10 | 3 | 7 | 309 | 28 | ||
9261 | 61896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 19 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/1985 12:00:00 AM | 11 | Permit Number 21939 | 6009273.47888 | 2094140.55724 | 37.7306347561928 | -122.410245303295 | (37.7306347561928, -122.410245303295) | 9 | 3 | 7 | 309 | 28 | ||
9275 | 232510 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 810 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001254.99625 | 2101553.2012 | 37.7505354058999 | -122.438497252644 | (37.7505354058999, -122.438497252644) | 2 | 4 | 5 | 28862 | 22 | |||
9332 | 103261 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4174 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 7x15 | 6002762 | 2100662 | 37.7481739852998 | -122.433222250243 | (37.7481739852998, -122.433222250243) | 2 | 4 | 5 | 28862 | 22 | |||
9336 | 131379 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2990 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5999358.44425 | 2117025.78745 | 37.7929111360792 | -122.446168490398 | (37.7929111360792, -122.446168490398) | 13 | 9 | 1 | 57 | 27 | |||
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 | |||
9364 | 27216 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 440 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004188.32264 | 2093464.07452 | 37.7284909288141 | -122.427777281084 | (37.7284909288141, -122.427777281084) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
9393 | 210003 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 44 Lakewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993676.73838 | 2093064.62621 | 37.7267939100051 | -122.46408710354 | (37.7267939100051, -122.46408710354) | 9 | 8 | 4 | 59 | 40 | |||
9431 | 232592 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 820 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6001105.09491 | 2102035.20124 | 37.7518503343262 | -122.439050162161 | (37.7518503343262, -122.439050162161) | 2 | 4 | 5 | 28862 | 22 | |||
9461 | 98346 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1943 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997281 | 2108783 | 37.7701597533774 | -122.452761318704 | (37.7701597533774, -122.452761318704) | 15 | 5 | 11 | 29492 | 9 | ||||
9534 | 113541 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 446 HOFFMAN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000626 | 2101420 | 37.7501338681145 | -122.440662811526 | (37.7501338681145, -122.440662811526) | 2 | 4 | 5 | 28862 | 22 | |||
9535 | 124144 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4100x Geary Blvd | 6 | Median : Yard | Tree | DPW 1 | 14 | 5994110.98895 | 2112812.22704 | 37.7810407796467 | -122.464018802579 | (37.7810407796467, -122.464018802579) | 11 | 6 | 2 | 54 | 11 | ||||
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 | ||||
9631 | 35176 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
9679 | 111947 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 95 SEACLIFF AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 5987570 | 2115773 | 37.7887910778243 | -122.486864535179 | (37.7887910778243, -122.486864535179) | 11 | 6 | 1 | 55 | 33 | ||||
9763 | 111086 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 582X Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5996560.16999 | 2095740.09269 | 37.7343058616961 | -122.454312386561 | (37.7343058616961, -122.454312386561) | 9 | 7 | 4 | 59 | 40 | |||||
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 | |||
9856 | 35210 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/10/1998 12:00:00 AM | Permit Number 38712 | ||||||||||||||
9864 | 102975 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 555 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007348.4 | 2112963.4 | 37.7822098643106 | -122.41823462296 | (37.7822098643106, -122.41823462296) | 7 | 9 | 9 | 28852 | 36 | ||||
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 | |||
9881 | 213143 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 233 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5995623.80037 | 2091512.74066 | 37.7226448283785 | -122.457243989419 | (37.7226448283785, -122.457243989419) | 9 | 8 | 4 | 28861 | 24 | |||
9916 | 91389 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 165 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52087 | 5994308.9 | 2093484 | 37.7279818222938 | -122.461932151311 | (37.7279818222938, -122.461932151311) | 9 | 8 | 4 | 59 | 40 | |||
9969 | 209840 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 749 Parnassus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994752.13294 | 2106017.73198 | 37.7624218164232 | -122.461308096788 | (37.7624218164232, -122.461308096788) | 15 | 5 | 11 | 56 | 12 | |||
9999 | 187636 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 142 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5987141 | 2115018 | 37.7866930444454 | -122.488293288956 | (37.7866930444454, -122.488293288956) | 11 | 6 | 1 | 55 | 33 | ||||
10004 | 20406 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 262X Sunset Blvd | 51 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
10010 | 41581 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 291 18th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2000 12:00:00 AM | Permit Number 42092 | 5990233.66540637 | 2113445.43887164 | 37.7825551838187 | -122.477478543034 | (37.7825551838187, -122.477478543034) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||||||||||||||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||||
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 | |||
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 | |||
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 | |||
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 |
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) );