trees
3,709 rows where qSpecies_id = 9 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
72550 | 177943 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989687.38089 | 2089641.08495 | 37.7171629928544 | -122.477627922194 | (37.7171629928544, -122.477627922194) | 1 | 8 | 4 | 64 | 14 | ||||
188212 | 177868 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 France Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002724.27928 | 2089381.75446 | 37.7171988614159 | -122.432547078085 | (37.7171988614159, -122.432547078085) | 9 | 7 | 6 | 28861 | 5 | |||
20808 | 177944 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Josepha Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5989684.83075 | 2089660.83958 | 37.717217086174 | -122.477638179862 | (37.717217086174, -122.477638179862) | 1 | 8 | 4 | 64 | 14 | ||||
53707 | 177867 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 700 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002692.71234 | 2089400.42544 | 37.7172483376296 | -122.432657522924 | (37.7172483376296, -122.432657522924) | 9 | 7 | 6 | 28861 | 5 | |||
161539 | 177950 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989537.87078 | 2089714.62637 | 37.7173562418745 | -122.478150075788 | (37.7173562418745, -122.478150075788) | 1 | 8 | 4 | 64 | 14 | ||||
141949 | 84677 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 218 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53575 | 5998816.90097 | 2089525.70767 | 37.7173717668583 | -122.44606333266 | (37.7173717668583, -122.44606333266) | 9 | 7 | 6 | 28861 | 25 | |
107379 | 177917 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989687.39355 | 2089722.56421 | 37.7173867154012 | -122.477633830752 | (37.7173867154012, -122.477633830752) | 1 | 8 | 4 | 64 | 14 | ||||
89198 | 177951 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Grijalva Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989499.70601 | 2089731.63068 | 37.7174007160611 | -122.478283234789 | (37.7174007160611, -122.478283234789) | 1 | 8 | 4 | 64 | 14 | ||||
88411 | 177916 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989586.18825 | 2089731.4345 | 37.7174051973785 | -122.477984294746 | (37.7174051973785, -122.477984294746) | 1 | 8 | 4 | 64 | 14 | ||||
70097 | 177918 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989709.79651 | 2089731.70675 | 37.7174131186015 | -122.477557062834 | (37.7174131186015, -122.477557062834) | 1 | 8 | 4 | 64 | 14 | ||||
97552 | 177915 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 5989561.17412 | 2089735.80949 | 37.7174157581119 | -122.478071075724 | (37.7174157581119, -122.478071075724) | 1 | 8 | 4 | 64 | 14 | ||||
84197 | 177919 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989736.06041 | 2089740.76738 | 37.7174395208859 | -122.477466943539 | (37.7174395208859, -122.477466943539) | 1 | 8 | 4 | 64 | 14 | ||||
109048 | 46751 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 374 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44853 | 5993270.00396137 | 2089670.22710211 | 37.7174502644102 | -122.465246711525 | (37.7174502644102, -122.465246711525) | 9 | 8 | 6 | 64 | 24 | ||
150289 | 177920 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Juan Bautista Cir | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989764.37663 | 2089755.55448 | 37.7174817656499 | -122.477370148614 | (37.7174817656499, -122.477370148614) | 1 | 8 | 4 | 64 | 14 | ||||
6162 | 46753 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/2002 12:00:00 AM | Permit Number 44855 | 5993270.29922187 | 2089695.37971007 | 37.7175193444423 | -122.465247516931 | (37.7175193444423, -122.465247516931) | 9 | 8 | 6 | 64 | 24 | ||
177977 | 210739 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 378 Victoria St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 5993261.2949 | 2089711.81841 | 37.7175639618854 | -122.465279833897 | (37.7175639618854, -122.465279833897) | 9 | 8 | 6 | 64 | 24 | |||
45497 | 177853 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 737 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6000857.68516 | 2089577.3851 | 37.7176299901137 | -122.439013008468 | (37.7176299901137, -122.439013008468) | 9 | 7 | 6 | 28861 | 5 | ||||
66870 | 177914 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Font Blvd | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989849.36693 | 2089820.74775 | 37.7176657012986 | -122.477081140675 | (37.7176657012986, -122.477081140675) | 1 | 8 | 4 | 64 | 14 | ||||
7046 | 69901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 607 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6002511.32191 | 2089559.78285 | 37.7176756091205 | -122.433295884208 | (37.7176756091205, -122.433295884208) | 9 | 7 | 6 | 28861 | 5 | |||
12517 | 83658 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 735 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001863.16562 | 2089646.83142 | 37.717877833364 | -122.435542488698 | (37.717877833364, -122.435542488698) | 9 | 7 | 6 | 28861 | 5 | |||
2530 | 69848 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 731 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6001876.24877 | 2089667.33696 | 37.7179348800801 | -122.43549873219 | (37.7179348800801, -122.43549873219) | 9 | 7 | 6 | 28861 | 5 | |||
183993 | 177854 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 701 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6000936.66084 | 2089691.6636 | 37.7179482664819 | -122.43874821026 | (37.7179482664819, -122.43874821026) | 9 | 7 | 6 | 28861 | 5 | ||||
95643 | 177871 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 627 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003164.18069 | 2089688.8677 | 37.7180670633107 | -122.431048455019 | (37.7180670633107, -122.431048455019) | 9 | 7 | 6 | 28861 | 5 | |||
72990 | 210727 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Majestic Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997384.6848 | 2089822.80773 | 37.7181056433352 | -122.451035225606 | (37.7181056433352, -122.451035225606) | 9 | 8 | 6 | 28861 | 24 | |||
163165 | 177945 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5990273.00331 | 2089979.48461 | 37.7181261218096 | -122.475628420827 | (37.7181261218096, -122.475628420827) | 1 | 8 | 4 | 64 | 14 | ||||
105921 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 0 Diaz Ave | 1 | Front Yard : Yard | Tree | Private 2 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.81974 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | 1 | 8 | 4 | 64 | 14 | ||
37488 | 55314 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1108 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 9 | 3x12 | Permit Number 11243 | 6011262.01011 | 2089590.56769 | 37.7182526888019 | -122.403050695433 | (37.7182526888019, -122.403050695433) | 10 | 7 | 8 | 309 | 39 | |
14636 | 55313 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1100 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 8 | 9x3 | Permit Number 11242 | 6011254.56702 | 2089617.4839 | 37.7183261795882 | -122.403078315405 | (37.7183261795882, -122.403078315405) | 10 | 7 | 8 | 309 | 39 | |
165522 | 210726 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Majestic Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997442.65634 | 2089908.86719 | 37.7183452613979 | -122.450841045792 | (37.7183452613979, -122.450841045792) | 9 | 8 | 6 | 28861 | 24 | |||
160079 | 60445 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Majestic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1982 12:00:00 AM | Permit Number 20029 | 5997441.1539675 | 2089913.66861403 | 37.7183583589884 | -122.450846584852 | (37.7183583589884, -122.450846584852) | 9 | 8 | 6 | 28861 | 24 | ||
106360 | 177925 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Crespi Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5989826.52584 | 2090074.03315 | 37.7183598349297 | -122.477178590321 | (37.7183598349297, -122.477178590321) | 1 | 8 | 4 | 64 | 14 | ||||
185402 | 177881 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 490 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010189.89814 | 2089698.96953 | 37.7184904092754 | -122.406764185036 | (37.7184904092754, -122.406764185036) | 10 | 7 | 8 | 309 | 39 | |||
167157 | 177882 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 490 Harkness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010170.34583 | 2089705.37121 | 37.7185068929539 | -122.406832220549 | (37.7185068929539, -122.406832220549) | 10 | 7 | 8 | 309 | 39 | |||
23181 | 102518 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 498X Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010140.7 | 2089714.5 | 37.7185302998738 | -122.406935337509 | (37.7185302998738, -122.406935337509) | 10 | 7 | 8 | 309 | 39 | |||||
146502 | 102520 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 498X Harkness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6010140.7 | 2089714.5 | 37.7185302998738 | -122.406935337509 | (37.7185302998738, -122.406935337509) | 10 | 7 | 8 | 309 | 39 | |||||
160918 | 95746 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 615 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767491 | 6001709.97913 | 2089913.5528 | 37.7186014890371 | -122.43609106166 | (37.7186014890371, -122.43609106166) | 9 | 7 | 6 | 28861 | 5 |
54899 | 194214 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1030 Le Conte Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6013004.48576 | 2089699.06872 | 37.7186477627738 | -122.397035257987 | (37.7186477627738, -122.397035257987) | 10 | 3 | 8 | 58 | 1 | |||
16998 | 109968 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 2 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 10 | 3 | 8 | 58 | 1 | ||
42155 | 109967 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1019 Hollister Ave | 1 | Front Yard : Yard | Tree | Private 2 | 03/13/2015 12:00:00 AM | 3 | 12x17 | 6014729.1 | 2089712.4 | 37.7187802209924 | -122.391074848752 | (37.7187802209924, -122.391074848752) | 10 | 3 | 8 | 58 | 1 | ||
11914 | 262434 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 634 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6002626 | 2089963 | 37.7187892592726 | -122.43292828484 | (37.7187892592726, -122.43292828484) | 9 | 7 | 6 | 28861 | 5 | ||
27942 | 43715 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 31 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | Permit Number 43356 | 5995595.90606819 | 2090114.46838183 | 37.7188039024441 | -122.457239310884 | (37.7188039024441, -122.457239310884) | 9 | 8 | 6 | 28861 | 24 | ||
138439 | 177924 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Crespi Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | 5989730.82285 | 2090240.32639 | 37.718810881792 | -122.47752153959 | (37.718810881792, -122.47752153959) | 1 | 8 | 4 | 64 | 14 | ||||
85128 | 177872 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 630 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002659.15451 | 2089974.81435 | 37.7188235793291 | -122.432814526575 | (37.7188235793291, -122.432814526575) | 9 | 7 | 6 | 28861 | 5 | |||
34785 | 22523 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6600 03rd St | 3 | Median : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012847.5284056 | 2089784.7633559 | 37.7188743244909 | -122.397583806576 | (37.7188743244909, -122.397583806576) | 10 | 3 | 8 | 58 | 1 | |||
52330 | 57138 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 543 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/1974 12:00:00 AM | 8 | Permit Number 14411 | 6003683.02162 | 2090004.97184 | 37.7189644023697 | -122.429277574812 | (37.7189644023697, -122.429277574812) | 9 | 7 | 6 | 28861 | 5 | ||
158487 | 22520 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6530 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/1992 12:00:00 AM | 6 | 3X3 | 6012891.87458 | 2089879.75625 | 37.719137625171 | -122.397437176644 | (37.719137625171, -122.397437176644) | 10 | 3 | 8 | 58 | 1 | ||
85570 | 194220 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6524 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012914.00103 | 2089890.00071 | 37.7191669863524 | -122.397361411494 | (37.7191669863524, -122.397361411494) | 10 | 3 | 8 | 58 | 1 | |||
74424 | 22518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6518 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6012926.62983 | 2089906.00338 | 37.7192116295963 | -122.397318879858 | (37.7192116295963, -122.397318879858) | 10 | 3 | 8 | 58 | 1 | |||
145738 | 12932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6540X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012937.6533 | 2089925.98182 | 37.7192671001169 | -122.39728217588 | (37.7192671001169, -122.39728217588) | 10 | 3 | 8 | 58 | 1 | |||
165879 | 12933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6540X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012937.6533 | 2089925.98182 | 37.7192671001169 | -122.39728217588 | (37.7192671001169, -122.39728217588) | 10 | 3 | 8 | 58 | 1 | |||
124015 | 210704 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 62 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995644.4301 | 2090308.82708 | 37.7193403522458 | -122.457085635021 | (37.7193403522458, -122.457085635021) | 9 | 8 | 6 | 28861 | 24 | |||
101435 | 65472 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 62 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/11/1989 12:00:00 AM | Permit Number 28353 | 5995650.86801959 | 2090309.77846046 | 37.7193433342313 | -122.457063450459 | (37.7193433342313, -122.457063450459) | 9 | 8 | 6 | 28861 | 24 | ||
173597 | 177949 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5989559.04866 | 2090448.78739 | 37.7193732944219 | -122.478130520911 | (37.7193732944219, -122.478130520911) | 1 | 8 | 4 | 64 | 14 | ||||
138217 | 22519 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 6520X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6012970.43876 | 2089969.7044 | 37.719388978809 | -122.397171912348 | (37.719388978809, -122.397171912348) | 10 | 3 | 8 | 58 | 1 | |||
128789 | 210705 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 66 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5995644.51018 | 2090335.70586 | 37.7194141596149 | -122.457087301455 | (37.7194141596149, -122.457087301455) | 9 | 8 | 6 | 28861 | 24 | |||
106545 | 210732 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 486 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992756.33333 | 2090404.7555 | 37.719437465534 | -122.467075592082 | (37.719437465534, -122.467075592082) | 9 | 8 | 6 | 64 | 24 | |||
22852 | 108395 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 311 Ordway St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 2 | 3x3 | 6011028.37272 | 2090050.89786 | 37.7195036115824 | -122.403890660433 | (37.7195036115824, -122.403890660433) | 10 | 7 | 8 | 309 | 28 | ||
58808 | 177947 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989601.96089 | 2090504.09134 | 37.7195276360688 | -122.477986231896 | (37.7195276360688, -122.477986231896) | 1 | 8 | 4 | 64 | 14 | ||||
164370 | 177948 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989566.53985 | 2090511.453 | 37.7195457933774 | -122.478109206096 | (37.7195457933774, -122.478109206096) | 1 | 8 | 4 | 64 | 14 | ||||
62809 | 194219 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6013415.40609 | 2090027.00023 | 37.7195710634281 | -122.395637826651 | (37.7195710634281, -122.395637826651) | 10 | 3 | 8 | 58 | 1 | ||||
175976 | 12928 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6481X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013096.23046 | 2090034.75353 | 37.7195745928355 | -122.396741651947 | (37.7195745928355, -122.396741651947) | 10 | 3 | 8 | 58 | 1 | |||
185332 | 12929 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6481X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6013096.23046 | 2090034.75353 | 37.7195745928355 | -122.396741651947 | (37.7195745928355, -122.396741651947) | 10 | 3 | 8 | 58 | 1 | |||
19850 | 194218 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | 6013410.02884 | 2090031.5953 | 37.7195833814573 | -122.395656735769 | (37.7195833814573, -122.395656735769) | 10 | 3 | 8 | 58 | 1 | ||||
106687 | 194217 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6013395.77535 | 2090042.77857 | 37.7196132956026 | -122.395706788434 | (37.7196132956026, -122.395706788434) | 10 | 3 | 8 | 58 | 1 | ||||
132901 | 194216 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6013384.67345 | 2090050.69381 | 37.7196344116892 | -122.395745718284 | (37.7196344116892, -122.395745718284) | 10 | 3 | 8 | 58 | 1 | ||||
171602 | 194215 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1121 Jamestown Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013366.63798 | 2090065.79888 | 37.7196748838817 | -122.395809118718 | (37.7196748838817, -122.395809118718) | 10 | 3 | 8 | 58 | 1 | ||||
60988 | 194221 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6012968.46094 | 2090076.8184 | 37.7196829822717 | -122.397186255957 | (37.7196829822717, -122.397186255957) | 10 | 3 | 8 | 58 | 1 | |||
85424 | 22513 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013017.34088 | 2090082.06317 | 37.7197001044495 | -122.39701766186 | (37.7197001044495, -122.39701766186) | 10 | 3 | 8 | 58 | 1 | |||
187048 | 194222 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012957.45228 | 2090084.12895 | 37.7197024427026 | -122.397224821584 | (37.7197024427026, -122.397224821584) | 10 | 3 | 8 | 58 | 1 | |||
79435 | 22512 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013020.80961 | 2090093.5041 | 37.719731712041 | -122.397006473368 | (37.719731712041, -122.397006473368) | 10 | 3 | 8 | 58 | 1 | |||
130480 | 194223 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1080 Key Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6012938.89979 | 2090098.87174 | 37.7197418905657 | -122.397289984657 | (37.7197418905657, -122.397289984657) | 10 | 3 | 8 | 58 | 1 | |||
192589 | 22511 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 6424 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013025.9659 | 2090108.36392 | 37.719772801157 | -122.396989691115 | (37.719772801157, -122.396989691115) | 10 | 3 | 8 | 58 | 1 | |||
124195 | 65518 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 520 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1990 12:00:00 AM | 12 | Permit Number 28405 | 6001942.8685 | 2090363.91257 | 37.7198513047749 | -122.435318256244 | (37.7198513047749, -122.435318256244) | 9 | 7 | 6 | 28861 | 5 | |
104030 | 177946 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 0 Fuente Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5989610.43005 | 2090657.90132 | 37.7199504514394 | -122.477968195982 | (37.7199504514394, -122.477968195982) | 1 | 8 | 4 | 64 | 14 | ||||
1714 | 216680 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 430 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 07:33:00 AM | 3 | Width 3ft | 5995444.86919 | 2090582.23732 | 37.7200796093562 | -122.457795211804 | (37.7200796093562, -122.457795211804) | 9 | 8 | 6 | 28861 | 24 | ||
66585 | 54165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 833 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 17 | Permit Number 9900 | 6009194.94472 | 2090308.57597 | 37.7201085414697 | -122.41024635908 | (37.7201085414697, -122.41024635908) | 9 | 3 | 7 | 309 | 28 | ||
3657 | 78310 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 542 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6002972.7622 | 2090478.24127 | 37.7202236600817 | -122.431766435094 | (37.7202236600817, -122.431766435094) | 9 | 7 | 6 | 28861 | 5 | |||
40619 | 54163 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 809 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 14 | Permit Number 9898 | 6009163.7285 | 2090404.08715 | 37.7203690453816 | -122.410361003783 | (37.7203690453816, -122.410361003783) | 9 | 3 | 7 | 309 | 28 | ||
84235 | 210703 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 118 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995358.81409 | 2090711.71511 | 37.7204301803951 | -122.458102038877 | (37.7204301803951, -122.458102038877) | 9 | 8 | 6 | 28861 | 24 | |||
66005 | 54162 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 801 Colby St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1972 12:00:00 AM | 13 | Permit Number 9897 | 6009157.09852 | 2090431.14887 | 37.7204429795508 | -122.410385831368 | (37.7204429795508, -122.410385831368) | 9 | 3 | 7 | 309 | 28 | ||
165519 | 210731 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 555 Arch St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992721.77233 | 2090849.66532 | 37.7206570847417 | -122.46722738773 | (37.7206570847417, -122.46722738773) | 9 | 8 | 6 | 64 | 24 | |||
113998 | 52972 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 355 Byxbee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | Permit Number 48953 | 5991933.5202918 | 2090897.4017579 | 37.7207426228906 | -122.46995557771 | (37.7207426228906, -122.46995557771) | 9 | 8 | 6 | 64 | 24 | ||
193295 | 39638 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 555 Arch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | Permit Number 41032 | 5992713.01716207 | 2090887.82450944 | 37.7207613551784 | -122.46726042451 | (37.7207613551784, -122.46726042451) | 9 | 8 | 6 | 64 | 24 | ||
96808 | 72248 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 471 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51334 | 6002218.571 | 2090723.27966 | 37.7208536999265 | -122.434390930208 | (37.7208536999265, -122.434390930208) | 9 | 7 | 6 | 28861 | 5 | |
15702 | 66427 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 95 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1991 12:00:00 AM | 8 | Permit Number 29569 | 6012980.71061 | 2090558.71757 | 37.7210068625643 | -122.397177686318 | (37.7210068625643, -122.397177686318) | 10 | 3 | 8 | 58 | 1 | ||
121787 | 210725 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Edgar Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997113.75654 | 2090895.52443 | 37.7210355581178 | -122.452049055632 | (37.7210355581178, -122.452049055632) | 9 | 8 | 6 | 28861 | 24 | |||
194497 | 161370 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 530 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6002550.45613 | 2090822.0233 | 37.7211436611464 | -122.433250757115 | (37.7211436611464, -122.433250757115) | 9 | 7 | 6 | 28861 | 5 | |||
183836 | 210697 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995068.3011 | 2091117.15656 | 37.7215267291452 | -122.459135584749 | (37.7215267291452, -122.459135584749) | 9 | 8 | 6 | 28861 | 24 | |||
116608 | 210730 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 599 Arch St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992718.10768 | 2091174.58463 | 37.721549022462 | -122.467263668211 | (37.721549022462, -122.467263668211) | 9 | 8 | 6 | 64 | 24 | |||
50682 | 210698 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995068.96938 | 2091128.64645 | 37.7215583160578 | -122.459134106273 | (37.7215583160578, -122.459134106273) | 9 | 8 | 6 | 28861 | 24 | |||
5371 | 210699 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995069.25472 | 2091142.27461 | 37.7215957521342 | -122.459134106263 | (37.7215957521342, -122.459134106263) | 9 | 8 | 6 | 28861 | 24 | |||
107774 | 210700 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995069.54897 | 2091156.3287 | 37.7216343582246 | -122.45913410628 | (37.7216343582246, -122.45913410628) | 9 | 8 | 6 | 28861 | 24 | |||
150625 | 210701 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1090 Capitol Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5995069.85214 | 2091170.80839 | 37.7216741334235 | -122.459134106266 | (37.7216741334235, -122.459134106266) | 9 | 8 | 6 | 28861 | 24 | |||
110806 | 47325 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 201 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45255 | 5994138.72426845 | 2091199.26813368 | 37.721698703569 | -122.462354807583 | (37.721698703569, -122.462354807583) | 9 | 8 | 4 | 28861 | 40 | ||
186622 | 252932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 66 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091179 | 37.7218154760893 | -122.451975324711 | (37.7218154760893, -122.451975324711) | 9 | 8 | 6 | 28861 | 24 | |||||
93242 | 45458 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 415 Monticello St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2001 12:00:00 AM | Permit Number 44243 | 5991715.39988027 | 2091316.49885884 | 37.7218807493286 | -122.470740056775 | (37.7218807493286, -122.470740056775) | 9 | 8 | 4 | 59 | 40 | ||
132817 | 45457 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 415 Monticello St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2001 12:00:00 AM | Permit Number 44243 | 5991715.39988027 | 2091316.49885884 | 37.7218807493286 | -122.470740056775 | (37.7218807493286, -122.470740056775) | 9 | 8 | 4 | 59 | 40 | ||
188930 | 252933 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 72 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091205 | 37.7218868659906 | -122.451977199572 | (37.7218868659906, -122.451977199572) | 9 | 8 | 6 | 28861 | 24 | |||||
9358 | 252934 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Edgar Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997141 | 2091229 | 37.7219527643602 | -122.451978930217 | (37.7219527643602, -122.451978930217) | 9 | 8 | 6 | 28861 | 24 | |||||
18381 | 78364 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 426 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6002109.01666 | 2091133.31338 | 37.721973341484 | -122.434798932837 | (37.721973341484, -122.434798932837) | 9 | 7 | 6 | 28861 | 5 |
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) );