trees
54 rows where qSpecies_id = 327
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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) );