trees

161 rows where qSpecies_id = 96 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
109356 222993 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 9 Sidewalk: Curb side : Pot Tree Private 2     17     6002546.22973 2099483.20236 37.7449250410506 -122.43388413076 (37.7449250410506, -122.43388413076) 2 7 5 63 22
53512 222992 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 8 Sidewalk: Curb side : Pot Tree Private 2     22     6002556.21356 2099484.40965 37.7449289225421 -122.433849694824 (37.7449289225421, -122.433849694824) 2 7 5 63 22
358 222991 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 7 Sidewalk: Curb side : Pot Tree Private 2     24     6002568.09263 2099485.22731 37.7449318417374 -122.433808677655 (37.7449318417374, -122.433808677655) 2 7 5 63 22
138961 222990 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 6 Sidewalk: Curb side : Pot Tree Private 2     23     6002575.82203 2099485.96762 37.744934313062 -122.433782003739 (37.744934313062, -122.433782003739) 2 7 5 63 22
104238 222989 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 5 Sidewalk: Curb side : Pot Tree Private 2     24     6002586.19946 2099486.51271 37.7449363986116 -122.433746159477 (37.7449363986116, -122.433746159477) 2 7 5 63 22
25664 222988 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 4 Sidewalk: Curb side : Pot Tree Private 2     12     6002598.0607 2099487.20989 37.7449389859493 -122.433705195344 (37.7449389859493, -122.433705195344) 2 7 5 63 22
64051 222987 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 3 Sidewalk: Curb side : Pot Tree Private 2     5     6002610.5339 2099487.49124 37.7449404662242 -122.433662085451 (37.7449404662242, -122.433662085451) 2 7 5 63 22
43929 222986 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 502 28th St 1 Sidewalk: Curb side : Pot Tree Private 2     21     6002638.36895 2099488.81638 37.7449456841067 -122.433565931724 (37.7449456841067, -122.433565931724) 2 7 5 63 22
7476 246435 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 501 Duncan St 1 Front Yard : Yard Tree Private 2     5 Width 5ft   6003234.36598 2099765.52854 37.7457392692468 -122.431524834927 (37.7457392692468, -122.431524834927) 2 7 5 63 22
29884 246437 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 498 Duncan St 3 Front Yard : Yard Tree Private 2     18 Width 3ft   6003348.65362 2099794.40948 37.7458250465875 -122.431131706158 (37.7458250465875, -122.431131706158) 2 7 5 63 22
22261 246436 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 498 Duncan St 2 Front Yard : Yard Tree Private 2     16 Width 3ft   6003348.10613 2099802.17179 37.7458463290596 -122.431134153243 (37.7458463290596, -122.431134153243) 2 7 5 63 22
9896 222994 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 3 Median : Cutout Tree DPW 1     8 Width 4ft   6002676.05036 2100055.6268 37.746504150749 -122.433476134415 (37.746504150749, -122.433476134415) 2 7 5 63 22
68292 222995 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 5 Median : Cutout Tree DPW 1     6 Width 4ft   6002718.47536 2100057.70158 37.7465122545352 -122.433329581817 (37.7465122545352, -122.433329581817) 2 7 5 63 22
26158 222996 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500x 27th St 6 Median : Cutout Tree DPW 1     6 Width 4ft   6002734.51591 2100059.43623 37.7465179274696 -122.433274239339 (37.7465179274696, -122.433274239339) 2 7 5 63 22
102644 256153 Undocumented 4 Cotoneaster SPP :: Cotoneaster 96 80X Peralta Ave 2 Median : Cutout Tree Private 2       3x3   6010428 2100359 37.747773912222 -122.406691992098 (37.747773912222, -122.406691992098) 2 7 7 28859 2
148002 222984 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 4699 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6000341.30715 2101074.37399 37.7491686459265 -122.441622492977 (37.7491686459265, -122.441622492977) 2 4 5 28862 22
55033 206433 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 401x Ortega St 2 Median : Cutout Tree DPW 1     7 Width 2ft   5992711.67251 2102602.15843 37.7529258983243 -122.468116765071 (37.7529258983243, -122.468116765071) 1 8 4 56 12
9746 233891 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 255 Grand View Ave 2 Sidewalk: Property side : Yard Tree Private 2     12     6000523.6418 2102837.35853 37.7540197626178 -122.441118447281 (37.7540197626178, -122.441118447281) 2 4 5 28862 22
141062 206431 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 951 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 5ft   5990974.62554 2103115.26643 37.7542342869058 -122.474161176918 (37.7542342869058, -122.474161176918) 1 8 4 56 12
24533 223001 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3944 22nd St 7 Front Yard : Yard Tree Private 2     44     6002181.90808 2102965.21527 37.7544651419609 -122.435392918875 (37.7544651419609, -122.435392918875) 2 4 5 28862 22
68061 190918 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900x Carolina St 70 Median : Yard Tree DPW 1     21     6012519.44645 2102822.43937 37.7546547784053 -122.399632767143 (37.7546547784053, -122.399632767143) 10 3 8 28856 29
91353 190917 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900x Carolina St 68 Median : Yard Tree DPW 1     8     6012519.74637 2102837.21301 37.7546953603194 -122.399632767155 (37.7546953603194, -122.399632767155) 10 3 8 28856 29
177603 190916 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900x Carolina St 61 Median : Yard Tree DPW 1     12     6012503.64813 2102901.04205 37.7548697235729 -122.399692921016 (37.7548697235729, -122.399692921016) 10 3 8 28856 29
127398 190915 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900x Carolina St 48 Median : Yard Tree DPW 1     10     6012505.66859 2103014.14021 37.7551803790787 -122.399693874288 (37.7551803790787, -122.399693874288) 10 3 8 28856 29
26558 222998 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3955 21st St 2 Front Yard : Yard Tree Private 2     28     6002164.76896 2103518.38211 37.7559830321046 -122.435491759762 (37.7559830321046, -122.435491759762) 2 4 5 28862 22
162272 222999 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3955 21st St 3 Front Yard : Yard Tree Private 2     53     6002171.06087 2103519.51853 37.7559865097873 -122.435470081578 (37.7559865097873, -122.435470081578) 2 4 5 28862 22
180988 222997 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3955 21st St 1 Front Yard : Yard Tree Private 2     3     6002162.22875 2103520.28848 37.7559881222676 -122.435500681007 (37.7559881222676, -122.435500681007) 2 4 5 28862 22
119785 223000 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3949 21st St 2 Front Yard : Yard Tree Private 2     8     6002182.77981 2103520.33537 37.7559894181953 -122.435429612092 (37.7559894181953, -122.435429612092) 2 4 5 28862 22
97051 190914 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900x Carolina St 8 Median : Yard Tree DPW 1     12     6012455.86408 2103644.27268 37.7569078085518 -122.399910360878 (37.7569078085518, -122.399910360878) 10 3 8 28856 29
3273 190919 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 999 Kansas St 5 Side Yard : Yard Tree Private 2     20     6011651.17755 2103795.8209 37.7572790316179 -122.40270394113 (37.7572790316179, -122.40270394113) 10 3 8 28856 29
59932 222978 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 749 Dolores St 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 8ft   6005048.47497 2104094.54483 37.7577283976651 -122.425559946538 (37.7577283976651, -122.425559946538) 2 4 5 28859 19
79562 190920 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 895 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     15     6011337.392 2104186.31719 37.7583337232325 -122.403816617445 (37.7583337232325, -122.403816617445) 10 3 8 28856 29
108052 190921 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 875 Vermont St 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 2ft   6011349.18047 2104266.91512 37.7585556858022 -122.403781518727 (37.7585556858022, -122.403781518727) 10 3 8 28856 29
150537 206432 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1501 16th Ave 2 Side Yard : Yard Tree Private 2     5 Width 6ft   5991165.77974 2105142.87216 37.7598126286617 -122.473648022834 (37.7598126286617, -122.473648022834) 1 8 4 56 12
125251 223004 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 671 Church St 38 Front Yard : Yard Tree Private 2     16 Width 3ft   6004322.20484 2105083.55126 37.760402911295 -122.428142169046 (37.760402911295, -122.428142169046) 2 4 5 28862 3
106553 223003 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 198 Corbin Pl 5 Side Yard : Yard Tree Private 2     4 Width 3ft   6000086.83847 2105686.09697 37.761816809226 -122.442833562346 (37.761816809226, -122.442833562346) 15 5 5 28862 3
176244 190912 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 649 Delancey St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6015785.04565 2113121.03731 37.7831139729835 -122.389058364068 (37.7831139729835, -122.389058364068) 6 2 9 28856 6
143058 122924 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2 11th Ave 5 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   5992431.96311 2114886.35785 37.7866388652474 -122.469978400459 (37.7866388652474, -122.469978400459) 11 6 1 54 11
81196 250505 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 55 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     21     5987243.87038 2115583.56444 37.7882519230241 -122.487978957983 (37.7882519230241, -122.487978957983) 11 6 1 55 33
132532 249676 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2400 Baker St 8 Front Yard : Yard Tree Private 2     15     5999736.34659 2117174.55896 37.7933411972934 -122.444871632924 (37.7933411972934, -122.444871632924) 13 9 1 57 27
174251 126357 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 53 Priest St 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6008293.62277 2117215.49565 37.79393824372 -122.41526566339 (37.79393824372, -122.41526566339) 5 1 10 28858 21
96964 126366 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 99 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     56     6008010.57204 2119080.43937 37.7990430042822 -122.416377206564 (37.7990430042822, -122.416377206564) 5 1 10 308 32
62670 126368 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12 MacOndray Ln 4 Sidewalk: Property side : Yard Tree Private 2     10     6008550.57003 2119171.07932 37.799322230301 -122.414515043334 (37.799322230301, -122.414515043334) 5 1 10 308 32
93688 126367 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12 MacOndray Ln 2 Sidewalk: Property side : Yard Tree Private 2     6     6008558.64868 2119172.9159 37.7993277269402 -122.414487218323 (37.7993277269402, -122.414487218323) 5 1 10 308 32
165925 108733 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 12X MacOndray Ln 1 Front Yard : Yard Tree Private 2     6     6008571.72163 2119174.99094 37.7993341588901 -122.41444212811 (37.7993341588901, -122.41444212811) 5 1 10 308 32
28938 126364 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 8 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6007584.0296 2119571.97409 37.8003686400458 -122.417888052307 (37.8003686400458, -122.417888052307) 5 1 1 28858 32
48886 126363 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 6 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007594.76747 2119573.62389 37.8003737742816 -122.417851011923 (37.8003737742816, -122.417851011923) 5 1 1 28858 32
35470 126362 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   6007597.96218 2119573.74544 37.8003742878151 -122.417839965548 (37.8003742878151, -122.417839965548) 5 1 1 28858 32
114113 126361 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 3 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6007604.93039 2119574.72474 37.8003773688712 -122.417815922163 (37.8003773688712, -122.417815922163) 5 1 1 28858 32
191212 126360 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6007607.19826 2119575.42635 37.8003794229421 -122.41780812417 (37.8003794229421, -122.41780812417) 5 1 1 28858 32
20410 126359 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 Filbert St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   6007620.5753 2119577.58313 37.8003860977102 -122.417761987128 (37.8003860977102, -122.417761987128) 5 1 1 28858 32
71395 126365 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1151 Lombard St 6 Sidewalk: Property side : Yard Tree Private 2     9     6006751.38188 2120096.64647 37.8017623625961 -122.42080661943 (37.8017623625961, -122.42080661943) 5 1 1 28858 32
192482 126369 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1306x Montgomery St 30 Median : Yard Tree DPW 1     8 Width 8ft   6011435.17205 2120070.79941 37.8019542743222 -122.404596630044 (37.8019542743222, -122.404596630044) 3 1 10 308 23
52277 126370 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1306x Montgomery St 31 Median : Yard Tree DPW 1     10 Width 8ft   6011433.37611 2120083.33032 37.801988580771 -122.404603727506 (37.801988580771, -122.404603727506) 3 1 10 308 23
17076 126371 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1306x Montgomery St 37 Median : Yard Tree DPW 1     4 Width 8ft   6011427.3089 2120158.66 37.8021950785935 -122.404630029046 (37.8021950785935, -122.404630029046) 3 1 10 308 23
48088 249827 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 6 Front Yard : Yard Tree Private 2     6 Width 0ft   6011143.97494 2120350.69369 37.8027065167616 -122.405624039843 (37.8027065167616, -122.405624039843) 3 1 10 308 23
115956 249832 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 5 Front Yard : Yard Tree Private 2     8 Width 0ft   6011163.78015 2120353.28367 37.802714735662 -122.405555685946 (37.802714735662, -122.405555685946) 3 1 10 308 23
10292 249831 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 339 Greenwich St 4 Front Yard : Yard Tree Private 2     9 Width 0ft   6011175.54294 2120361.59598 37.802738216951 -122.40551556629 (37.802738216951, -122.40551556629) 3 1 10 308 23
70399 121205 Significant Tree 6 Cotoneaster SPP :: Cotoneaster 96 930 Chestnut St 1 Front Yard : Yard Tree Private 2     20 3x3   6007386.5238 2120591.43483 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145) 5 1 1 28858 32
151568 126358 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 2700 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6006530.21172 2120848.51447 37.803814332215 -122.421625403593 (37.803814332215, -122.421625403593) 5 9 1 28858 32
75124 126356 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 101 Marina Blvd 3 Front Yard : Yard Tree Private 2     8     6002934.90654 2121377.37848 37.8050630669581 -122.434104982679 (37.8050630669581, -122.434104982679) 13 9 1 57 17

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);