trees
40 rows where Fire Prevention Districts = 15 and qSpecies_id = 50 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | |||
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 | |
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 |
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 | |||
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 | |
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 | |||
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 | |||
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 | |||
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 | |
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 | |
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 | ||
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 | ||
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 | ||||
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 | |
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 | |||
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 | ||
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 | |||
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 | |||
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 | ||||
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 | |||
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 |
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) );