161 rows where qSpecies_id = 96 sorted by TreeID

View and edit SQL

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)
112935 206487 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 18 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5994954.72324 2099244.06144 37.7438346949325 -122.46011666235 (37.7438346949325, -122.46011666235) 1 8 4 59 40
40874 206488 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 19 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5994928.93938 2099242.2168 37.7438281469548 -122.460205682656 (37.7438281469548, -122.460205682656) 1 8 4 59 40
163793 206489 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 20 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5994901.42281 2099243.38936 37.7438297837176 -122.460300912772 (37.7438297837176, -122.460300912772) 1 8 4 59 40
116071 206490 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 50 Garcia Ave 21 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5994866.12622 2099244.72495 37.743831420489 -122.460423055998 (37.743831420489, -122.460423055998) 1 8 4 59 40
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
84078 222979 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1001 San Jose Ave 23 Front Yard : Yard Tree Private 2     15     6005237.0546 2097014.53451 37.7382989702268 -122.424404187313 (37.7382989702268, -122.424404187313) 2 7 5 28859 2
60015 222980 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1100 San Jose Ave 49 Sidewalk: Property side : Yard Tree Private 2     6     6004766.24957 2096663.35836 37.737308122382 -122.426007008515 (37.737308122382, -122.426007008515) 2 7 5 63 7
145896 222981 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1101 San Jose Ave 65 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   6005028.12161 2096593.96399 37.7371323777521 -122.425096658989 (37.7371323777521, -122.425096658989) 2 7 5 28859 2
120735 222982 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1101 San Jose Ave 67 Sidewalk: Curb side : Yard Tree Private 2     8 Width 8ft   6005045.20057 2096625.52578 37.7372200041006 -122.425039854206 (37.7372200041006, -122.425039854206) 2 7 5 28859 2
188863 222983 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 90 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007949.21318 2098212.09839 37.7417399985009 -122.415111593326 (37.7417399985009, -122.415111593326) 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
5537 222985 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 517 Day St 1 Sidewalk: Curb side : Pot Tree Private 2     28 Width 10ft   6002550.62453 2098561.77605 37.7423952688291 -122.433803088343 (37.7423952688291, -122.433803088343) 2 7 5 63 7
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
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
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
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
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
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
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
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
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
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
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
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
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
73660 223002 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 256 Bemis St 1 Front Yard : Yard Tree Private 2     23     6003028.50594 2096309.11502 37.736237086475 -122.431989898622 (37.736237086475, -122.431989898622) 2 7 5 63 7
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
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
25208 223005 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 246 Bemis St 3 Sidewalk: Curb side : Yard Tree Private 2     18     6003031.63093 2096309.97053 37.7362396126721 -122.431979155322 (37.7362396126721, -122.431979155322) 2 7 5 63 7
70341 223006 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1001 San Jose Ave 12 Front Yard : Yard Tree Private 2     14     6005181.63876 2096892.75966 37.7379614744429 -122.424587128296 (37.7379614744429, -122.424587128296) 2 7 5 28859 2
52269 223007 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1200 San Jose Ave 8 Front Yard : Yard Tree Private 2     19     6004038.31137 2095943.30588 37.735289853946 -122.428472518792 (37.735289853946, -122.428472518792) 2 7 5 28861 7
120594 223008 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1201 San Jose Ave 11 Front Yard : Yard Tree Private 2     4     6004238.84554 2095923.20533 37.7352460083923 -122.427777766445 (37.7352460083923, -122.427777766445) 2 7 5 28861 2
90839 223009 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1201 San Jose Ave 25 Front Yard : Yard Tree Private 2     4     6004330.29442 2095981.98056 37.7354125646335 -122.427465779924 (37.7354125646335, -122.427465779924) 2 7 5 28861 2
15365 223010 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1201 San Jose Ave 28 Front Yard : Yard Tree Private 2     5     6004358.20734 2096003.62684 37.7354735791371 -122.427370816017 (37.7354735791371, -122.427370816017) 2 7 5 28861 2
141993 223011 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1201 San Jose Ave 40 Front Yard : Yard Tree Private 2     14     6004395.88546 2096037.52109 37.7355687759817 -122.427242962114 (37.7355687759817, -122.427242962114) 2 7 5 28861 2
92809 223012 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 1101 San Jose Ave 55 Front Yard : Yard Tree Private 2     3     6005036.06332 2096630.93294 37.7372343347918 -122.425071830505 (37.7372343347918, -122.425071830505) 2 7 5 28859 2
101689 223013 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 400 Prospect Ave 16 Sidewalk: Property side : Yard Tree Private 2     18     6006209.38075 2097598.06666 37.7399560781032 -122.421083777917 (37.7399560781032, -122.421083777917) 2 7 7 28859 2
21004 223014 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 130 Berkeley Way 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000989.36557 2097560.44411 37.7395571289679 -122.439129688289 (37.7395571289679, -122.439129688289) 2 7 5 63 7
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
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
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
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
128445 246631 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 3320 Harrison St 2 Front Yard : Yard Tree Private 2     5     6009034.5576 2099266.31462 37.7446955781356 -122.411433278945 (37.7446955781356, -122.411433278945) 2 7 7 28859 2
60282 246768 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 99 Waltham St 1 Side Yard : Yard Tree Private 2     13     6009274.77295 2098916.84453 37.7437494805599 -122.410577984112 (37.7437494805599, -122.410577984112) 2 7 7 28859 2
189006 246769 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 99 Waltham St 2 Side Yard : Yard Tree Private 2     13     6009290.58304 2098917.85967 37.7437531542765 -122.410523388038 (37.7437531542765, -122.410523388038) 2 7 7 28859 2
121991 247635 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 351 Bradford St 2 Sidewalk: Curb side : Yard Tree Private 2     6     6009489.54624 2096539.61504 37.7372341639148 -122.409667589601 (37.7372341639148, -122.409667589601) 10 7 7 28859 2
151500 247902 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 377 Mayflower St 1 Side Yard : Yard Tree Private 2     13     6009819.79405 2098407.16553 37.7423805541222 -122.408657474665 (37.7423805541222, -122.408657474665) 10 7 7 28859 2
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
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
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
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
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
75541 253981 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 433 Detroit St 3 Unaccepted Street : Yard Tree Private 2       Width 10ft   5999422.35392 2094544.1981 37.7311859389748 -122.444331015365 (37.7311859389748, -122.444331015365) 9 7 4 59 40
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
12496 259559 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 100 Public Park 2 Unaccepted Street : Yard Tree Private 2       3x3   5994005 2098340 37.7412976975938 -122.463334966929 (37.7412976975938, -122.463334966929) 1 8 4 59 40
167420 29575 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 400X Junipero Serra Blvd 4 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3X3   5991376.3613 2094248.55248 37.7299118271724 -122.472125628008 (37.7299118271724, -122.472125628008) 9 8 4 64 40
153035 29606 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 900X Junipero Serra Blvd 15 Median : Cutout Tree DPW 1   03/09/2013 12:00:00 AM 3 3X3   5991168.88017 2091040.07708 37.7210901433828 -122.472609073864 (37.7210901433828, -122.472609073864) 9 8 4 64 40
6438 29970 DPW Maintained 1 Cotoneaster SPP :: Cotoneaster 96 500X Junipero Serra Blvd 14 Median : Cutout Tree DPW 1   04/01/2007 12:00:00 AM 3 3x3   5991349.07674 2093718.94394 37.7284560756763 -122.472181363504 (37.7284560756763, -122.472181363504) 9 8 4 64 40

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