50 rows where qSpecies_id = 258

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)
3369 159447 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 460x Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 09:24:00 AM 3 Width 0ft   5998669 2088474 37.7144755709944 -122.446498934146 (37.7144755709944, -122.446498934146) 9 7 6 28861 25
6093 45072 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 596 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3 Permit Number 770844 6012065 2105633 37.7623466149115 -122.401401881236 (37.7623466149115, -122.401401881236) 8 3 8 28856 29
6233 258390 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 642 Russia Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     5x5   6002875.15558 2090065.87943 37.7190858723969 -122.432074396816 (37.7190858723969, -122.432074396816) 9 7 6 28861 5
7223 106240 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 586 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3 Permit Number 770844 6012063 2105678 37.7624700633024 -122.401411961161 (37.7624700633024, -122.401411961161) 8 3 8 28856 29
9455 99415 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
10557 106246 Planning Code 138.1 required 2 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 560 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3 Permit Number 770844 6012026 2105714 37.7625668468002 -122.401542461625 (37.7625668468002, -122.401542461625) 8 3 8 28856 29
17232 5580 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1060 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/2017 12:00:00 AM 3 5x5 Permit Number 778117 6005065.99031 2102183.11443 37.7524810459835 -122.425363351162 (37.7524810459835, -122.425363351162) 2 4 5 28862 22
17816 258396 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 700 Russia Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     5x5   6003011.68779 2089979.87214 37.7188574551208 -122.43159632087 (37.7188574551208, -122.43159632087) 9 7 6 28861 5
18637 258393 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 700 Russia Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF     5x5   6003011.68779 2089979.87214 37.7188574551208 -122.43159632087 (37.7188574551208, -122.43159632087) 9 7 6 28861 5
19472 172015 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 622 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2 DPW   3 4x5   6008819.85723 2093756.73811 37.7295554330367 -122.411786437306 (37.7295554330367, -122.411786437306) 9 3 7 309 28
20063 99414 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
21501 83233 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 111 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/04/2017 10:33:00 AM 3 3x3 Permit Number 54417 6004063.6553 2093143.58717 37.7276038889037 -122.428185431836 (37.7276038889037, -122.428185431836) 9 7 6 28861 5
21588 159445 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 464 Huron Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 09:41:00 AM 3 Width 0ft   5998686.74184 2088513.90311 37.7145861492044 -122.446440480459 (37.7145861492044, -122.446440480459) 9 7 6 28861 25
26435 94186 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1350 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2016 12:00:00 AM   3x3 Permit Number 775032 6011110.9 2102017.1 37.7523648769007 -122.404447241627 (37.7523648769007, -122.404447241627) 10 4 8 28859 19
27034 99416 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
28297 180979 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 646 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 11:41:00 AM 3 Width 4ft   6002832.29176 2089747.08401 37.7182081004084 -122.432199805772 (37.7182081004084, -122.432199805772) 9 7 6 28861 5
30914 105673 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 201X 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3X4 Permit Number 770631 6007261.26868 2107929.29001 37.7683824966916 -122.418179043584 (37.7683824966916, -122.418179043584) 8 4 7 28853 19
31502 160855 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 605 Vienna St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2017 03:32:00 PM 3 Width 0ft   6002988.68917 2089915.90653 37.7186805160719 -122.431671253534 (37.7186805160719, -122.431671253534) 9 7 6 28861 5
31731 88627 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 240 Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2008 12:00:00 AM   3x3 Permit Number 51593 6008815.1 2113357.3 37.7833738682123 -122.413188342909 (37.7833738682123, -122.413188342909) 7 10 9 28852 36
40676 161374 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 566 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 03:36:00 PM 3 Width 0ft   6002430.61836 2090633.99378 37.7206205749503 -122.433651569691 (37.7206205749503, -122.433651569691) 9 7 6 28861 5
43293 99421 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 13 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
46631 99431 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 23 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
48442 254181 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 201 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/17/2018 12:00:00 AM 3 3x3 Permit Number 781203 6012911.4175 2106109.29412 37.7637016024008 -122.398507842407 (37.7637016024008, -122.398507842407) 14 3 8 28856 29
54215 105674 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 201X 14th St 12 Sidewalk: Curb side : Cutout Tree Private 2       3X4 Permit Number 770631 6007261.26868 2107929.29001 37.7683824966916 -122.418179043584 (37.7683824966916, -122.418179043584) 8 4 7 28853 19
73367 159446 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 464 Huron Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 09:44:00 AM 3 Width 0ft   5998674.52867 2088502.95565 37.7145553923942 -122.446481906836 (37.7145553923942, -122.446481906836) 9 7 6 28861 25
88535 87881 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1758 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50852 6002335.8 2120932.7 37.8038080776582 -122.436146416103 (37.8038080776582, -122.436146416103) 13 9 1 57 17
90847 177382 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 636 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/2018 12:00:00 AM 3 3x3 Permit Number 781328 6010900.83805 2091756.48536 37.7241796779218 -122.404451495646 (37.7241796779218, -122.404451495646) 10 3 7 309 28
91072 117590 Undocumented 4 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 241 SHIPLEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011527 2111724 37.7790410807513 -122.403691225403 (37.7790410807513, -122.403691225403) 14 2 9 28856 34
93056 99411 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
95476 124742 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 2725 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000066 2117943 37.7954699413297 -122.443786245588 (37.7954699413297, -122.443786245588) 13 9 1 57 17
97858 121014 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 2099X Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1     15 3x3   6004130 2115310 37.7884713558687 -122.429536248108 (37.7884713558687, -122.429536248108) 13 9 11 29490 27
106297 87863 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 179 Alhambra St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2008 12:00:00 AM   3x3 Permit Number 50827 6001408 2120174 37.8016721334373 -122.439302700013 (37.8016721334373, -122.439302700013) 13 9 1 57 17
110258 99409 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
119330 95133 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 450@ Wayland Somerset St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2018 12:00:00 AM 3 3x3 Permit Number 781342 6010089.84133 2092358.29057 37.725786753837 -122.407297408351 (37.725786753837, -122.407297408351) 10 3 7 309 28
123813 84544 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 698X 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2015 12:00:00 AM   3x3 Permit Number 774859 6009314.54246303 2104977.65271839 37.7603933359548 -122.410868438641 (37.7603933359548, -122.410868438641) 2 4 7 28859 19
126036 160857 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 600 Vienna St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 11:39:00 AM 3 Width 0ft   6002958.77513 2089948.27932 37.7187677089353 -122.431776964359 (37.7187677089353, -122.431776964359) 9 7 6 28861 5
129327 160856 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 600 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 11:46:00 AM 3 Width 0ft   6002966.83908 2089959.0451 37.7187977265008 -122.431749858776 (37.7187977265008, -122.431749858776) 9 7 6 28861 5
131514 99426 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 18 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
132172 160859 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 618 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/25/2017 11:55:00 AM 3 Width 0ft   6002917.16918 2089882.76457 37.7185854613346 -122.43191610384 (37.7185854613346, -122.43191610384) 9 7 6 28861 5
137215 99420 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 12 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
139634 88626 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 240 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2008 12:00:00 AM   3x3 Permit Number 51593 6008815.1 2113357.3 37.7833738682123 -122.413188342909 (37.7833738682123, -122.413188342909) 7 10 9 28852 36
140994 99425 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
142657 160854 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 605 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/2017 03:30:00 PM 3 Width 0ft   6002981.40369 2089904.86461 37.7186497844312 -122.431695648548 (37.7186497844312, -122.431695648548) 9 7 6 28861 5
144948 114956 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 3470 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/24/2015 12:00:00 AM     Permit Number 771402 6007117 2104415.1 37.7587252299116 -122.418428846982 (37.7587252299116, -122.418428846982) 2 4 7 28859 19
148529 99430 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 22 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
158300 99410 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 1501X Wallace Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6015288.5 2092477 37.7264022940106 -122.389334160631 (37.7264022940106, -122.389334160631) 10 3 8 58 1
161229 36579 Permitted Site 7 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 2970 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/22/2016 12:00:00 AM     Permit Number 774998 6009675.57743886 2101054.36494821 37.7496411039984 -122.409342906887 (37.7496411039984, -122.409342906887) 2 4 7 28859 19
172769 102798 Undocumented 4 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 547 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002828 2102678 37.7537131888076 -122.433138046686 (37.7537131888076, -122.433138046686) 2 4 5 28862 22
173454 121006 DPW Maintained 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 2099X Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     11 3x3   6004130 2115310 37.7884713558687 -122.429536248108 (37.7884713558687, -122.429536248108) 13 9 11 29490 27
174031 102797 Undocumented 4 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 258 522 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002980 2102720 37.7538371319968 -122.432615396749 (37.7538371319968, -122.432615396749) 2 4 5 28862 22

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