trees

Custom SQL query returning 27 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
7218 182129 1 54 2650 Ulloa St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5987716.6576 2098310.3756 37.7408520674665 -122.485075392772 (37.7408520674665, -122.485075392772) 1 8 3 29491 35
22527 184489 1 54 1866 40th Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5983834.6211 2102450.9664 37.7519941007524 -122.498803633975 (37.7519941007524, -122.498803633975) 1 8 3 56 35
24475 183822 1 54 2235 27th Ave 1 Sidewalk: Curb side : Yard Tree 2     4 Width 0ft   5987905.4957 2100075.9969 37.7457109948541 -122.484551945811 (37.7457109948541, -122.484551945811) 1 8 3 29491 35
29624 181932 1 54 2378 36th Ave 1 Sidewalk: Curb side : Yard Tree 2     18 Width 0ft   5985195.246 2099024.2764 37.7426650525628 -122.49384596323 (37.7426650525628, -122.49384596323) 1 8 3 29491 35
42047 97114 1 54 1345 Noriega St 5 Sidewalk: Curb side : Cutout Tree 2     7   Permit Number 18860 5989801.9904 2103085.8445 37.7540855022306 -122.478214246151 (37.7540855022306, -122.478214246151) 1 8 3 56 35
46162 183273 1 54 1251 40th Ave 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   5983646.3542 2106625.2038 37.7634443416971 -122.499763175358 (37.7634443416971, -122.499763175358) 1 8 3 56 35
46548 87369 1 54 926 Taraval St 3 Sidewalk: Curb side : Cutout Tree 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
57146 183272 1 54 1251 40th Ave 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   5983645.263 2106639.9345 37.7634847239936 -122.499768038252 (37.7634847239936, -122.499768038252) 1 8 3 56 35
60391 185225 1 54 2519 34th Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   5985800.5083 2098072.0747 37.7400859553966 -122.491683090969 (37.7400859553966, -122.491683090969) 1 8 3 29491 35
71569 181891 1 54 2362 34th Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5985808.0433 2099163.7908 37.7430839555722 -122.491737385137 (37.7430839555722, -122.491737385137) 1 8 3 29491 35
77793 62731 1 54 2307 35th Ave 1 Sidewalk: Curb side : Cutout Tree 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
79297 182039 1 54 1323 23rd Ave 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 0ft   5988935.747 2106319.8798 37.7629149697028 -122.481446720354 (37.7629149697028, -122.481446720354) 1 8 3 56 35
81633 183823 1 54 2235 27th Ave 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5987905.9224 2100064.0482 37.7456782117444 -122.484549594085 (37.7456782117444, -122.484549594085) 1 8 3 29491 35
90318 181727 1 54 2755 29th Ave 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   5987094.0342 2107004.1542 37.7646865433328 -122.487866760897 (37.7646865433328, -122.487866760897) 1 8 3 56 35
94144 181854 1 54 2318 32nd Ave 2 Sidewalk: Curb side : Yard Tree 2     6 Width 0ft   5986419.9945 2099457.4563 37.7439260290789 -122.48964304245 (37.7439260290789, -122.48964304245) 1 8 3 29491 35
115732 182109 1 54 2443 28th Ave 1 Sidewalk: Curb side : Yard Tree 2     5 Width 0ft   5987643.897 2098649.745 37.741779647709 -122.485351865276 (37.741779647709, -122.485351865276) 1 8 3 29491 35
121615 181728 1 54 2755 29th Ave 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   5987089.3098 2107026.595 37.7647478839827 -122.487884750055 (37.7647478839827, -122.487884750055) 1 8 3 56 35
123175 97312 1 54 926 Taraval St 4 Sidewalk: Curb side : Cutout Tree 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
123596 184487 1 54 1862 40th Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   5983833.6059 2102475.6712 37.7520618737382 -122.498808969569 (37.7520618737382, -122.498808969569) 1 8 3 56 35
131549 97311 1 54 926 Taraval St 1 Sidewalk: Curb side : Cutout Tree 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
140566 184648 1 54 1691 40th Ave 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   5983748.1287 2103659.9866 37.7553086603985 -122.49919205979 (37.7553086603985, -122.49919205979) 1 8 3 56 35
151219 181943 1 54 1635 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   5988119.3796 2098941.1939 37.7426075787892 -122.483729187458 (37.7426075787892, -122.483729187458) 1 8 3 29491 35
166999 182128 1 54 2650 Ulloa St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   5987739.3319 2098310.7141 37.7408543176455 -122.484997019316 (37.7408543176455, -122.484997019316) 1 8 3 29491 35
168055 181853 1 54 2318 32nd Ave 1 Sidewalk: Curb side : Yard Tree 2     4 Width 0ft   5986420.3329 2099445.95 37.7438944556176 -122.489641026377 (37.7438944556176, -122.489641026377) 1 8 3 29491 35
168247 43881 1 54 1245 47th Ave 1 Sidewalk: Curb side : Cutout Tree 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
172891 98024 1 54 1639 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   5988098.059 2098940.517 37.742604479099 -122.483802857352 (37.742604479099, -122.483802857352) 1 8 3 29491 35
179052 182246 1 54 1455 33rd Ave 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   5985863.116 2105312.6885 37.7599703705151 -122.491999577939 (37.7599703705151, -122.491999577939) 1 8 3 56 35