67 rows where Police Districts = 1 and qLegalStatus_id = 6 sorted by qLegalStatus_id

View and edit SQL

Police 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)
2008 106059 Significant Tree 6 Salix spp :: Willow 203 339 FILBERT ST 1 Front Yard : Yard Tree Private 2     6     6011263.6 2119947.8 37.801606957686 -122.405181687156 (37.801606957686, -122.405181687156) 3 1 10 308 23
4419 260950 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 2 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
5983 110477 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 131X Washington St 1 Back Yard : Yard Tree Private 2   04/16/2015 12:00:00 AM 3 10x10 Permit Number 774729 6013427.21844 2117958.83498 37.7962664536588 -122.397554954018 (37.7962664536588, -122.397554954018) 3 1 10 28860 6
6580 261206 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 2301 Leavenworth St 1 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
8743 261207 Significant Tree 6 Umbellularia californica :: California Bay 326 2301 Leavenworth St 3 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
9964 262274 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 4 Montclair Ter 1 Side Yard : Yard Tree Private 2           6007298.70359 2120216.09204 37.8021211637502 -122.418921105258 (37.8021211637502, -122.418921105258) 5 1 1 28858 32
12731 107057 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 601X Davis St 2 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 9   Permit Number 771755 6013145.32204 2118507.86888 37.7977582696821 -122.398568926718 (37.7977582696821, -122.398568926718) 3 1 10 28860 6
13002 260949 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 1 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
15016 261205 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 2301 Leavenworth St 2 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
16781 260951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 190 Jackson St 1 Sidewalk: Curb side : Yard Tree Private 2       3x3   6013038 2118237 37.7970085486816 -122.398921272101 (37.7970085486816, -122.398921272101) 3 1 10 28860 6
18276 119614 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
19052 260948 Significant Tree 6 Pinus radiata :: Monterey Pine 15 370 Drumm St 1 Side Yard : Yard Tree Private 2           6013616 2118213 37.7969748404412 -122.396919555024 (37.7969748404412, -122.396919555024) 3 1 10 28860 6
31713 107635 Significant Tree 6 Prunus cerasifera :: Cherry Plum 7 1150 Lombard St 10 Front Yard : Yard Tree Private 2   10/01/2014 12:00:00 AM 3   Permit Number 773092 6006825.00646 2120436.80144 37.8027004912885 -122.420576003873 (37.8027004912885, -122.420576003873) 5 1 1 28858 32
32951 112484 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1275 Columbus Ave 4 Front Yard : Yard Tree Private 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
34175 87149 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 4 Bellair Pl 2 Back Yard : Yard Tree Private 2           6010093 2120950 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994) 3 1 10 308 23
34754 101438 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 3 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
40158 253917 Significant Tree 6 Eriobotrya japonica :: Edible Loquat 119 1819 Mason St 1 Front Yard : Yard Tree Private 2           6009087 2119549 37.8003900283184 -122.412685532944 (37.8003900283184, -122.412685532944) 3 1 10 308 32
44600 107186 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 2 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
45867 107185 Significant Tree 6 Magnolia grandiflora :: Southern Magnolia 19 10 Florence St 1 Front Yard : Cutout Tree Private 2         Permit Number 773363 6008515.42073 2118375.20615 37.7971349853662 -122.41458032272 (37.7971349853662, -122.41458032272) 5 1 10 308 21
47218 99951 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1160 Battery St 1 Front Yard : Yard Tree Private 2   06/19/2012 12:00:00 AM     Permit Number 768993 6012314.3 2120017.7 37.8018575696458 -122.401550680127 (37.8018575696458, -122.401550680127) 3 1 10 28860 6
51973 106945 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 1150 LOMBARD ST 4 Front Yard : Yard Tree Private 2     13   Permit Number 773092 6006825 2120436.8 37.8027004869705 -122.420576026126 (37.8027004869705, -122.420576026126) 5 1 1 28858 32
61387 114840 Significant Tree 6 Acacia melanoxylon :: Blackwood Acacia 70 2455x HYDE ST   Sidewalk: Curb side : Cutout Tree PUC 8     12 3x3   6006980 2120877 37.8039178984324 -122.420070904619 (37.8039178984324, -122.420070904619) 5 1 1 28858 32
64053 96906 Significant Tree 6 Ulmus 'Frontier' :: Frontier Elm 115 1155@Sansome Battery St 1 Front Yard : Yard Tree Private 2   08/05/2011 12:00:00 AM   Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
65969 87150 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 4 Bellair Pl 2 Back Yard : Yard Tree Private 2         Permit Number 50135 6010093 2120950 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994) 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
70862 115250 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1404x Mason St 1 Front Yard : Yard Tree Private 2   01/20/2016 12:00:00 AM       6009352.6 2118074.7 37.7963568672402 -122.41166222086 (37.7963568672402, -122.41166222086) 3 1 10 308 4
71235 98244 Significant Tree 6 Taxus baccata :: Irish Yew 86 901 Bay St 1 Front Yard : Yard Tree Private 2     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489) 5 1 1 28858 32
76886 106942 Significant Tree 6 Tree(s) :: 17 1300@ Embarcadero Battery St 1 Front Yard : Yard Tree Private 2   07/02/2014 12:00:00 AM     Permit Number 772680 6012231.9986 2120618.97397 37.8035039293343 -122.401877773891 (37.8035039293343, -122.401877773891) 3 1 10 28860 6
80305 111179 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572 2121805 37.806555520543 -122.414627380808 (37.806555520543, -122.414627380808) 3 1 10 308 23
80380 114184 Significant Tree 6 Tree(s) :: 17 2454 HYDE ST 1 Front Yard : Cutout Tree Private 2   01/07/2016 12:00:00 AM   30x30 Permit Number 776893 6007060 2120781 37.8036588138585 -122.41978724304 (37.8036588138585, -122.41978724304) 5 1 1 28858 32
83429 112481 Significant Tree 6 Maytenus boaria :: Mayten 58 1275 Columbus Ave 1 Front Yard : Yard Tree Private 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
83898 112482 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1275 Columbus Ave 2 Front Yard : Yard Tree Private 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
84037 107611 Significant Tree 6 Pinus radiata :: Monterey Pine 15 470x Broadway 1 Back Yard : Yard Tree Private 2         Permit Number 774041 6011286.02608 2118707.45024 37.7982025127238 -122.40501669829 (37.7982025127238, -122.40501669829) 3 1 10 308 23
84386 99192 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1155@Sansome Battery St 3 Front Yard : Yard Tree Private 2       Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
89552 107399 Significant Tree 6 Tree(s) :: 17 1300X Sansome St 1 Front Yard : Yard Tree Private 2   09/02/2014 12:00:00 AM 3   Permit Number 772689 6012222 2120529 37.8032563246841 -122.401906046114 (37.8032563246841, -122.401906046114) 3 1 10 28860 6
93101 251659 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
93882 99191 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1155@Sansome Battery St 2 Front Yard : Yard Tree Private 2     9 Plaza Permit Number 768022 6012232.15659 2120086.23158 37.8020411569217 -122.401839756495 (37.8020411569217, -122.401839756495) 3 1 10 28860 6
97189 114476 Significant Tree 6 Pittosporum spp :: Pittosporum spp 170 299x UNION ST 1 Sidewalk: Curb side : Yard Tree Private 2   12/29/2015 12:00:00 AM       6011527 2119680 37.8008863659875 -122.40425133897 (37.8008863659875, -122.40425133897) 3 1 10 308 23
100360 107056 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 601X Davis St 1 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 12   Permit Number 771755 6013142.97136 2118525.31961 37.7978060542679 -122.39857828598 (37.7978060542679, -122.39857828598) 3 1 10 28860 6
101055 119613 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 1 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
101661 257928 Significant Tree 6 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 101 Lombard St 12 Sidewalk: Property side : Yard Tree Private 2       Width 6ft   6011760.21977 2120791.0173 37.8039499778675 -122.403522505873 (37.8039499778675, -122.403522505873) 3 1 10 28860 6
103238 121134 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 2 Front Yard : Yard Tree Private 2       3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
104435 106173 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 267 Green St 1 Front Yard : Yard Tree Private 2         Permit Number 771881 6011670.8 2119368.7 37.8000396459541 -122.403731811098 (37.8000396459541, -122.403731811098) 3 1 10 308 23
106637 101435 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 1 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
111290 106058 Significant Tree 6 Podocarpus gracilor :: Fern Pine 51 301 FILBERT ST 1 Front Yard : Yard Tree Private 2     10     6011273 2120044 37.8018716248897 -122.405155936594 (37.8018716248897, -122.405155936594) 3 1 10 308 23
115879 112485 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1275 Columbus Ave 5 Front Yard : Yard Tree Private 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
123789 112483 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1275 Columbus Ave 3 Front Yard : Yard Tree Private 2   08/03/2015 12:00:00 AM       6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
124108 258218 Significant Tree 6 Olea europaea :: Olive Tree 9 1000 North Point St 1 Sidewalk: Property side : Yard Tree Private 2           6005937.91741 2121414.48699 37.8053349315385 -122.423715341013 (37.8053349315385, -122.423715341013) 5 1 1 28858 32
126483 106838 Significant Tree 6 Lophostemon confertus :: Brisbane Box 11 735 Battery St 1 Front Yard : Pot Tree Private 2         Permit Number 773117 6012413.67639 2118682.92207 37.7981981357359 -122.401112945062 (37.7981981357359, -122.401112945062) 3 1 10 28860 6
127351 101436 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 2 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
129267 98161 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 600 Front St   Front Yard : Yard Tree Private 2   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.399449857041 (37.7974274520849, -122.399449857041) 3 1 10 28860 6
139061 118322 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 720 BATTERY ST 1 unknown : Yard Tree Private 2           6012486 2118560 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686) 3 1 10 28860 6
142994 112559 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 1735x GRANT AVE 1 Back Yard : Yard Tree Private 2           6010373 2120454 37.8029470287696 -122.408299306743 (37.8029470287696, -122.408299306743) 3 1 10 308 23
143771 251658 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
147624 121449 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 1274 Filbert St 1 Front Yard : Yard Tree Private 2     12 10x6   6006927.94593 2119481.89109 37.800084349978 -122.420151970562 (37.800084349978, -122.420151970562) 5 1 1 28858 32
150077 107187 Significant Tree 6 Pinus radiata :: Monterey Pine 15 945 Sacramento St 3 Front Yard : Yard Tree Private 2         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.408109042355 (37.7928004918921, -122.408109042355) 3 1 10 28857 4
151937 251657 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
155139 101440 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 5 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
157517 112488 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1275 Columbus Ave 8 Front Yard : Yard Tree Private 2           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
157788 251660 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
161031 101439 Significant Tree 6 Metrosideros excelsa :: New Zealand Xmas Tree 16 600X Grant Ave 4 Front Yard : Yard Tree Private 2           6010995.6 2116632 37.7924875884206 -122.405875386937 (37.7924875884206, -122.405875386937) 3 1 10 28857 4
163986 121133 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Front Yard : Yard Tree Private 2     20 3x10   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
167115 112487 Significant Tree 6 Eucalyptus Spp :: Eucalyptus 52 1275 Columbus Ave 7 Front Yard : Yard Tree Private 2           6007539.6 2121483.9 37.8056158049656 -122.418177422209 (37.8056158049656, -122.418177422209) 5 1 1 308 32
171699 121206 Significant Tree 6 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 930 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.52821 37.8031223210123 -122.418746939923 (37.8031223210123, -122.418746939923) 5 1 1 28858 32
175229 107058 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 600X Front St 2 Front Yard : Yard Tree Private 2   07/23/2014 12:00:00 AM 14   Permit Number 771755 6012887.2102 2118277.80134 37.797112176041 -122.399445910496 (37.797112176041, -122.399445910496) 3 1 10 28860 6
178107 251661 Significant Tree 6 Olea europaea :: Olive Tree 9 3200X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
191590 107016 Significant Tree 6 Tree(s) :: 17 945 SACRAMENTO ST 1 Front Yard : Yard Tree Private 2   01/24/2015 12:00:00 AM     Permit Number 773422 6010352.6 2116759.1 37.7928005931964 -122.408109164657 (37.7928005931964, -122.408109164657) 3 1 10 28857 4

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