54 rows where qSpecies_id = 327

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)
8901 137805 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 2050 BUCHANAN ST 3 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6003886.2253 2115511.1067 37.789009738509 -122.430394024555 (37.789009738509, -122.430394024555) 13 9 11 29490 27
15853 187986 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 170 Hawthorne St 7 Sidewalk: Curb side : Pot Tree Private 2     14 Width 6ft   6013571.47207 2113396.19376 37.7837465372026 -122.396735780127 (37.7837465372026, -122.396735780127) 6 2 9 28856 6
20706 110858 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 170 Hawthorne St 2 Sidewalk: Property side : Cutout Tree Private 2     10 5x24   6013503.26461 2113462.88625 37.7839258629187 -122.396976431519 (37.7839258629187, -122.396976431519) 6 2 9 28856 6
20993 222010 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 384 Jersey St 4 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6002613.33395 2101537.05482 37.7505682446443 -122.433798866923 (37.7505682446443, -122.433798866923) 2 4 5 28862 22
21573 110859 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 170 Hawthorne St 3 Sidewalk: Property side : Cutout Tree Private 2     10 5x24   6013516.88993 2113448.7565 37.7838878243194 -122.396928301602 (37.7838878243194, -122.396928301602) 6 2 9 28856 6
21686 137806 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 2050 BUCHANAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003883.5212 2115525.078 37.7890479469892 -122.430404377623 (37.7890479469892, -122.430404377623) 13 9 11 29490 27
25258 253400 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1555 Evans Ave 3 Front Yard : Yard Tree Private 2       3x3   6015916 2098279 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434) 10 3 8 58 1
33809 187989 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1700 Bancroft Ave 5 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6013864.22175 2092546.37551 37.7265137190133 -122.394262718274 (37.7265137190133, -122.394262718274) 10 3 8 58 1
38495 204749 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 50 Vernon St 1 : Tree Private 2     12 Width 3ft   5992461.94208 2088209.51473 37.7133928684713 -122.467933597457 (37.7133928684713, -122.467933597457) 9 8 6 64 24
38614 222012 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 38 Museum Way 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6000690.92007 2106780.75327 37.7648568855542 -122.440822816714 (37.7648568855542, -122.440822816714) 15 5 5 28862 3
38904 94616 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1728 Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 3   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
47868 61061 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1912 McAllister St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/1984 12:00:00 AM 19   Permit Number 21236 5999977.7059 2111287.1191 37.777189585704 -122.44361338348 (37.777189585704, -122.44361338348) 15 5 11 29490 16
49245 187990 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1700 Bancroft Ave 6 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   6013849.15678 2092557.08437 37.7265422859756 -122.394315547119 (37.7265422859756, -122.394315547119) 10 3 8 58 1
57446 94626 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 1 Sidewalk: Property side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 9   permit 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
58333 94618 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 3 Sidewalk: Property side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 9   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
61992 104368 Undocumented 4 Alnus rhombifolia :: White Alder 327 2022 CHURCH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     25 4x5   6004010 2108570 37.7699581908925 -122.429470579495 (37.7699581908925, -122.429470579495) 7 9 5 29492 10
64184 80593 Private 9 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 7     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
66149 125568 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 2501 Jackson St 20 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001972.31004 2116669.3419 37.792081354117 -122.437098867136 (37.792081354117, -122.437098867136) 13 6 1 29490 27
66274 187985 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 170 Hawthorne St 6 Sidewalk: Curb side : Pot Tree Private 2     14 Width 6ft   6013558.69971 2113403.3796 37.7837655569784 -122.396780471936 (37.7837655569784, -122.396780471936) 6 2 9 28856 6
69853 250461 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 285 Seacliff Ave 2 : Tree Private 2     15 Width 4ft   5986857.40047 2115685.46606 37.7885091633186 -122.489323556844 (37.7885091633186, -122.489323556844) 11 6 1 55 33
70435 94610 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 8   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
72639 222009 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 384 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 5x5   6002677.75867 2101537.58482 37.7505733554865 -122.43357611926 (37.7505733554865, -122.43357611926) 2 4 5 28862 22
79763 253405 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1555 Evans Ave 8 Front Yard : Yard Tree Private 2       3x3   6015916 2098279 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434) 10 3 8 58 1
88372 187994 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1751 Armstrong Ave 23 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6013990.00173 2092736.17216 37.727041853073 -122.39384117813 (37.727041853073, -122.39384117813) 10 3 8 58 1
99626 54431 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 328 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/23/1972 12:00:00 AM 25   Permit Number 10208 6014015.54519 2105546.82969 37.7622186469892 -122.394649587711 (37.7622186469892, -122.394649587711) 10 3 8 28856 29
100293 137807 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 2050 BUCHANAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003881.2678 2115544.4576 37.7891010308213 -122.430413557372 (37.7891010308213, -122.430413557372) 13 9 11 29490 27
102402 187992 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1700 Bancroft Ave 15 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6013779.27511 2092609.89728 37.7266834147913 -122.394560823722 (37.7266834147913, -122.394560823722) 10 3 8 58 1
103435 253399 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1555 Evans Ave 2 Front Yard : Yard Tree Private 2       3x3   6015916 2098279 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434) 10 3 8 58 1
106845 187993 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1751 Armstrong Ave 22 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6013977.11905 2092745.6161 37.7270670682867 -122.393886374479 (37.7270670682867, -122.393886374479) 10 3 8 58 1
107374 110861 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 170 Hawthorne St 5 Sidewalk: Property side : Cutout Tree Private 2     15 5x24   6013543.16782 2113421.50619 37.7838144639207 -122.396835478069 (37.7838144639207, -122.396835478069) 6 2 9 28856 6
111203 253404 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1555 Evans Ave 7 Front Yard : Yard Tree Private 2       3x3   6015916 2098279 37.7423681872216 -122.387569506434 (37.7423681872216, -122.387569506434) 10 3 8 58 1
112541 255922 Significant Tree 6 Alnus rhombifolia :: White Alder 327 554 Clipper St 1 Front Yard : Yard Tree Private 2       3x3   6001599 2100911 37.7487916364102 -122.437261685392 (37.7487916364102, -122.437261685392) 2 4 5 28862 22
115898 186317 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1800 Sunset Blvd 55 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984994.9614 2102849.2293 37.7531556096401 -122.494820428843 (37.7531556096401, -122.494820428843) 1 8 3 56 35
118496 108343 Undocumented 4 Alnus rhombifolia :: White Alder 327 390x JERSEY ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002599 2101610 37.7507677214535 -122.433853648065 (37.7507677214535, -122.433853648065) 2 4 5 28862 22
128385 110860 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 170 Hawthorne St 4 Sidewalk: Property side : Cutout Tree Private 2     12 5x24   6013528.50874 2113433.67795 37.7838470688278 -122.39688704702 (37.7838470688278, -122.39688704702) 6 2 9 28856 6
131380 187988 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 351 03rd St 1 : Tree Private 2     8 Width 1ft   6013302.51753 2113231.83466 37.7832802720121 -122.397654736196 (37.7832802720121, -122.397654736196) 6 2 9 28856 6
132474 94623 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1728 Bancroft Ave 3 Sidewalk: Property side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 8   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
133340 94625 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 2 Sidewalk: Property side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 9   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
133758 94617 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1728 Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 3   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
135773 80511 Undocumented 4 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 9     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
137199 113179 Undocumented 4 Alnus rhombifolia :: White Alder 327 1701X Armstrong Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           6013992.4427 2092768.26292 37.7271301034749 -122.393834984976 (37.7271301034749, -122.393834984976) 10 3 8 58 1
138244 108340 Undocumented 4 Alnus rhombifolia :: White Alder 327 390x JERSEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002599 2101610 37.7507677214535 -122.433853648065 (37.7507677214535, -122.433853648065) 2 4 5 28862 22
139036 110857 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 170 Hawthorne St 1 Sidewalk: Property side : Cutout Tree Private 2     10 5x24   6013483.77966 2113482.08281 37.7839774876065 -122.397045189184 (37.7839774876065, -122.397045189184) 6 2 9 28856 6
141800 80510 Private 9 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   08/20/2007 12:00:00 AM 9   Permit Number 49651 6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
146933 187987 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 2 Saint Francis Pl 1 Sidewalk: Curb side : Pot Tree Private 2     12 Width 1ft   6013325.60756 2113213.70467 37.7832317769678 -122.397573581364 (37.7832317769678, -122.397573581364) 6 2 9 28856 6
146953 94614 Permitted Site 7 Alnus rhombifolia :: White Alder 327 5600@ Bancroft 03rd St 2 Sidewalk: Curb side : Tree Private 2   10/13/2010 12:00:00 AM     Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
152549 222011 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1221 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6003244.71208 2101131.50116 37.7494904970875 -122.431586562577 (37.7494904970875, -122.431586562577) 2 4 5 28862 22
154962 22381 Private 9 Alnus rhombifolia :: White Alder 327 1780 Bancroft Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6014045.0718623 2092725.5085003 37.7270156330804 -122.393650054041 (37.7270156330804, -122.393650054041) 10 3 8 58 1
169586 80512 Private 9 Alnus rhombifolia :: White Alder 327 1740 Bancroft Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   09/07/2002 12:00:00 AM 9     6014044.43135761 2092726.27645989 37.7270177061512 -122.393652321999 (37.7270177061512, -122.393652321999) 10 3 8 58 1
173945 94624 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1728 Bancroft Ave 4 Sidewalk: Property side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 9   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1
177142 187991 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1700 Bancroft Ave 11 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   6013795.39659 2092597.45894 37.7266501578712 -122.394504221286 (37.7266501578712, -122.394504221286) 10 3 8 58 1
181690 94611 DPW Maintained 1 Alnus rhombifolia :: White Alder 327 1700X Bancroft Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 6   Permit Number 53777 6013896.80495 2092522.88961 37.7264510425702 -122.394148435099 (37.7264510425702, -122.394148435099) 10 3 8 58 1
187945 113180 Undocumented 4 Alnus rhombifolia :: White Alder 327 1701X Armstrong Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           6013992.4427 2092768.26292 37.7271301034749 -122.393834984976 (37.7271301034749, -122.393834984976) 10 3 8 58 1
188251 94613 Permitted Site 7 Alnus rhombifolia :: White Alder 327 1700X Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 6   Permit Number 53777 6014054 2092727 37.7270202245482 -122.393619293726 (37.7270202245482, -122.393619293726) 10 3 8 58 1

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