40 rows where Fire Prevention Districts = 15 and qSpecies_id = 50

View and edit SQL

Fire Prevention 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)
761 224987 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 484 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2019 12:00:00 AM 3 4x4 Permit Number 782366 6003591.74199 2105457.02251 37.7613870178149 -122.430695151865 (37.7613870178149, -122.430695151865) 15 4 5 28862 3
1985 47 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 810 14th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1998 12:00:00 AM 6 3x3   6003389.55254 2107739.47109 37.7676426129451 -122.431557393053 (37.7676426129451, -122.431557393053) 15 5 5 28862 3
3860 106 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 927 14th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3x3   6002652.29309 2107649.54302 37.7673538775163 -122.434101048134 (37.7673538775163, -122.434101048134) 15 5 5 28862 3
4536 224986 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 484 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2019 12:00:00 AM 3 4x4 Permit Number 782366 6003589.47712 2105476.68017 37.7614408647212 -122.430704387917 (37.7614408647212, -122.430704387917) 15 4 5 28862 3
6402 94573 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3978 18th St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53752 6003116 2105363 37.761101890414 -122.432333828196 (37.761101890414, -122.432333828196) 15 4 5 28862 3
6567 45 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 810 14th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/05/1990 12:00:00 AM 12 3x3   6003436.52432 2107742.06145 37.7676523876611 -122.431395108624 (37.7676523876611, -122.431395108624) 15 5 5 28862 3
6650 41645 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 146 Blake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/2000 12:00:00 AM 3 3x3 Permit Number 42118 5997898.0776 2112825.6252 37.7812950956289 -122.450918408743 (37.7812950956289, -122.450918408743) 15 6 2 54 16
8083 261467 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 810 14th St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003376.13457 2107738.85817 37.7676401694851 -122.431603760325 (37.7676401694851, -122.431603760325) 15 5 5 28862 3
10372 260929 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 925 Cole St 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5998050.49977 2107087.50026 37.7655484062222 -122.449977421621 (37.7655484062222, -122.449977421621) 15 5 11 29492 9
10488 260919 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 630 Cole St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5997903.7812 2108434.36371 37.7692381539002 -122.450581995995 (37.7692381539002, -122.450581995995) 15 5 11 29492 9
13157 253697 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 865 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003091 2107654 37.7673910038901 -122.432583941874 (37.7673910038901, -122.432583941874) 15 5 5 28862 3
13347 231129 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 821 14th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     17 3x3   6003305.97559 2107686.68734 37.7674929441754 -122.431842705671 (37.7674929441754, -122.431842705671) 15 5 5 28862 3
14543 48 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 810 14th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     4 3x3   6003376.13457 2107738.85817 37.7676401694851 -122.431603760325 (37.7676401694851, -122.431603760325) 15 5 5 28862 3
16192 50 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 811 14th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 3x3   6003361.68382 2107697.25864 37.767525128208 -122.431650773269 (37.767525128208, -122.431650773269) 15 5 5 28862 3
16507 260930 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 515 Shrader St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3     5997474.23163 2108775.61542 37.7701505477721 -122.452092402813 (37.7701505477721, -122.452092402813) 15 5 11 29492 9
24811 80400 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 847 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM 1 3x3 Permit Number 51000 6000427.8652 2111924.6617 37.7789657789093 -122.442101918526 (37.7789657789093, -122.442101918526) 15 5 11 29490 16
31892 94188 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 456 Belvedere St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/17/2014 12:00:00 AM 10 3x4 Permit Number 772961 5998552 2106546 37.7640902659836 -122.448203856901 (37.7640902659836, -122.448203856901) 15 5 11 29492 9
55010 247662 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 108 Divisadero St 1 : Tree Private 2     7 Width 3ft   6001959.68947 2108344.83823 37.7692236543626 -122.436546435187 (37.7692236543626, -122.436546435187) 15 5 5 29492 9
63895 226815 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 4132 17th St 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   6001471.84267 2105861.76416 37.7623780104526 -122.438055976903 (37.7623780104526, -122.438055976903) 15 5 5 28862 3
67281 226817 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 4430 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5999749.40261 2105767.64242 37.7620214697258 -122.444006474335 (37.7620214697258, -122.444006474335) 15 5 5 28862 3
72482 64228 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 24 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2012 12:00:00 AM     Permit Number 769264 6003122.11049357 2108174.45220479 37.7688218028269 -122.43251351352 (37.7688218028269, -122.43251351352) 15 5 5 28862 3
74231 226816 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 4132 17th St 5 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   6001458.28578 2105860.25499 37.7623730956507 -122.438102756943 (37.7623730956507, -122.438102756943) 15 5 5 28862 3
78982 50683 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 114 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2004 12:00:00 AM     Permit Number 47255 6001960.98018226 2108347.90798031 37.7692321564841 -122.436542190439 (37.7692321564841, -122.436542190439) 15 5 5 29492 9
84643 57319 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 2719 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/31/1976 12:00:00 AM 2   Permit Number 16144 5999557.8231 2113954.6853 37.7844900782456 -122.445257725615 (37.7844900782456, -122.445257725615) 15 6 11 29490 31
86588 226807 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 48 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003212.25535 2107433.99017 37.7667937860223 -122.432148823236 (37.7667937860223, -122.432148823236) 15 5 5 28862 3
93606 229881 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 130 Belgrave Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5997916.14381 2104919.64182 37.7595883251505 -122.45028584572 (37.7595883251505, -122.45028584572) 15 5 11 29492 12
97031 226818 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 272 Corbett Ave 2 Side Yard : Yard Tree Private 2     7 Width 3ft   5999639.14958 2105380.58985 37.7609524294432 -122.444359978956 (37.7609524294432, -122.444359978956) 15 5 5 28862 3
100520 226781 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 466 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 7x8   6003584.13439 2105555.33075 37.7616565176582 -122.430728478955 (37.7616565176582, -122.430728478955) 15 4 5 28862 3
108610 226808 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 26 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003130.24955 2108135.8166 37.7687161804393 -122.432482601186 (37.7687161804393, -122.432482601186) 15 5 5 28862 3
112490 226778 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3934 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6003366.66584 2105380.90028 37.761165250397 -122.431468161443 (37.761165250397, -122.431468161443) 15 4 5 28862 3
124976 226779 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3974 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6003146.24554 2105369.35546 37.76112105592 -122.432229675877 (37.76112105592, -122.432229675877) 15 4 5 28862 3
131236 226814 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 63 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6003182.02121 2107933.96626 37.7681648843321 -122.432289109354 (37.7681648843321, -122.432289109354) 15 5 5 28862 3
145866 91415 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 46 Henry St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/2009 12:00:00 AM   3x3 Permit Number 52098 6003215 2107427 37.7667747483278 -122.432138830712 (37.7667747483278, -122.432138830712) 15 5 5 28862 3
153024 105745 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 418 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2014 12:00:00 AM 2 4x4 Permit Number 771651 6002705 2109971 37.7737310181147 -122.434084710333 (37.7737310181147, -122.434084710333) 15 5 11 29492 10
157854 226806 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 190 Storrie St 8 Front Yard : Yard Tree Private 2     3 Width 3ft   6000773.9022 2105295.69732 37.7607840134024 -122.440429287805 (37.7607840134024, -122.440429287805) 15 4 5 28862 3
157868 226819 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 70 Potomac St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6003113.42277 2108740.53818 37.7703756436569 -122.432584004272 (37.7703756436569, -122.432584004272) 15 5 5 29492 9
158632 142077 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 36 ATALAYA TER 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5998850.2457 2110939.7307 37.7761713796539 -122.447488599832 (37.7761713796539, -122.447488599832) 15 6 2 29492 16
181243 226780 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 3980 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6003123.97049 2105369.10011 37.7611190917893 -122.432306697403 (37.7611190917893, -122.432306697403) 15 4 5 28862 3
183347 68748 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 3974 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/20/2010 12:00:00 AM   3x3 Permit Number 53751 6003148.31037661 2105371.6272327 37.7611274107355 -122.432222696746 (37.7611274107355, -122.432222696746) 15 4 5 28862 3
192179 105743 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 410 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2014 12:00:00 AM   4x4 Permit Number 771648 6002709 2109944 37.7736571098162 -122.434068943261 (37.7736571098162, -122.434068943261) 15 5 11 29492 10

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