trees
27 rows where Supervisor Districts = 3 and qSpecies_id = 54 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131549 | 97311 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 926 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/1984 12:00:00 AM | 7 | 3x3 | 5990303.3847 | 2099082.1466 | 37.7431214880079 | -122.476187907151 | (37.7431214880079, -122.476187907151) | 1 | 8 | 3 | 29491 | 35 | ||
46548 | 87369 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 926 Taraval St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2008 12:00:00 AM | 10 | 3x3 | Permit Number 50349 | 5990243.3148 | 2099080.9621 | 37.7431147521003 | -122.476395524083 | (37.7431147521003, -122.476395524083) | 1 | 8 | 3 | 29491 | 35 | |
123175 | 97312 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 926 Taraval St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/19/1984 12:00:00 AM | 10 | 3x3 | 5990212.18 | 2099077.2394 | 37.7431027248159 | -122.476502906842 | (37.7431027248159, -122.476502906842) | 1 | 8 | 3 | 29491 | 35 | ||
42047 | 97114 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1345 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Permit Number 18860 | 5989801.9904 | 2103085.8445 | 37.7540855022306 | -122.478214246151 | (37.7540855022306, -122.478214246151) | 1 | 8 | 3 | 56 | 35 | |||
79297 | 182039 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1323 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5988935.747 | 2106319.8798 | 37.7629149697028 | -122.481446720354 | (37.7629149697028, -122.481446720354) | 1 | 8 | 3 | 56 | 35 | |||
151219 | 181943 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1635 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5988119.3796 | 2098941.1939 | 37.7426075787892 | -122.483729187458 | (37.7426075787892, -122.483729187458) | 1 | 8 | 3 | 29491 | 35 | |||
172891 | 98024 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1639 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5988098.059 | 2098940.517 | 37.742604479099 | -122.483802857352 | (37.742604479099, -122.483802857352) | 1 | 8 | 3 | 29491 | 35 | |||
81633 | 183823 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2235 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987905.9224 | 2100064.0482 | 37.7456782117444 | -122.484549594085 | (37.7456782117444, -122.484549594085) | 1 | 8 | 3 | 29491 | 35 | |||
24475 | 183822 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2235 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5987905.4957 | 2100075.9969 | 37.7457109948541 | -122.484551945811 | (37.7457109948541, -122.484551945811) | 1 | 8 | 3 | 29491 | 35 | |||
166999 | 182128 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2650 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987739.3319 | 2098310.7141 | 37.7408543176455 | -122.484997019316 | (37.7408543176455, -122.484997019316) | 1 | 8 | 3 | 29491 | 35 | |||
7218 | 182129 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2650 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987716.6576 | 2098310.3756 | 37.7408520674665 | -122.485075392772 | (37.7408520674665, -122.485075392772) | 1 | 8 | 3 | 29491 | 35 | |||
115732 | 182109 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2443 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5987643.897 | 2098649.745 | 37.741779647709 | -122.485351865276 | (37.741779647709, -122.485351865276) | 1 | 8 | 3 | 29491 | 35 | |||
90318 | 181727 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2755 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5987094.0342 | 2107004.1542 | 37.7646865433328 | -122.487866760897 | (37.7646865433328, -122.487866760897) | 1 | 8 | 3 | 56 | 35 | |||
121615 | 181728 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2755 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987089.3098 | 2107026.595 | 37.7647478839827 | -122.487884750055 | (37.7647478839827, -122.487884750055) | 1 | 8 | 3 | 56 | 35 | |||
168055 | 181853 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2318 32nd Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5986420.3329 | 2099445.95 | 37.7438944556176 | -122.489641026377 | (37.7438944556176, -122.489641026377) | 1 | 8 | 3 | 29491 | 35 | |||
94144 | 181854 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2318 32nd Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5986419.9945 | 2099457.4563 | 37.7439260290789 | -122.48964304245 | (37.7439260290789, -122.48964304245) | 1 | 8 | 3 | 29491 | 35 | |||
60391 | 185225 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2519 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5985800.5083 | 2098072.0747 | 37.7400859553966 | -122.491683090969 | (37.7400859553966, -122.491683090969) | 1 | 8 | 3 | 29491 | 35 | |||
71569 | 181891 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2362 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5985808.0433 | 2099163.7908 | 37.7430839555722 | -122.491737385137 | (37.7430839555722, -122.491737385137) | 1 | 8 | 3 | 29491 | 35 | |||
179052 | 182246 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1455 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5985863.116 | 2105312.6885 | 37.7599703705151 | -122.491999577939 | (37.7599703705151, -122.491999577939) | 1 | 8 | 3 | 56 | 35 | |||
77793 | 62731 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2307 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/1993 12:00:00 AM | 10 | Permit Number 32015 | 5985442.2939 | 2099497.5593 | 37.7439790107491 | -122.49302661105 | (37.7439790107491, -122.49302661105) | 1 | 8 | 3 | 29491 | 35 | ||
29624 | 181932 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 2378 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 0ft | 5985195.246 | 2099024.2764 | 37.7426650525628 | -122.49384596323 | (37.7426650525628, -122.49384596323) | 1 | 8 | 3 | 29491 | 35 | |||
22527 | 184489 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1866 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983834.6211 | 2102450.9664 | 37.7519941007524 | -122.498803633975 | (37.7519941007524, -122.498803633975) | 1 | 8 | 3 | 56 | 35 | |||
123596 | 184487 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1862 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983833.6059 | 2102475.6712 | 37.7520618737382 | -122.498808969569 | (37.7520618737382, -122.498808969569) | 1 | 8 | 3 | 56 | 35 | |||
140566 | 184648 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1691 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983748.1287 | 2103659.9866 | 37.7553086603985 | -122.49919205979 | (37.7553086603985, -122.49919205979) | 1 | 8 | 3 | 56 | 35 | |||
46162 | 183273 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1251 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5983646.3542 | 2106625.2038 | 37.7634443416971 | -122.499763175358 | (37.7634443416971, -122.499763175358) | 1 | 8 | 3 | 56 | 35 | |||
57146 | 183272 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1251 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5983645.263 | 2106639.9345 | 37.7634847239936 | -122.499768038252 | (37.7634847239936, -122.499768038252) | 1 | 8 | 3 | 56 | 35 | |||
168247 | 43881 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1245 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2000 12:00:00 AM | 3 | Permit Number 43494 | 5981473.1113 | 2106617.2091 | 37.7632946239394 | -122.507278997702 | (37.7632946239394, -122.507278997702) | 1 | 8 | 3 | 56 | 35 |
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) );