trees

Custom SQL query returning 30 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
157 114186 4 66 2200 HAYES ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
485 251655 1 66 300x Chester Ave 1 Sidewalk: Property side : Yard Tree 1       3x3   5991691 2087193 37.7105572148468 -122.470524229297 (37.7105572148468, -122.470524229297) 9 8 4 64 24
1279 221708 1 66 222 Gates St 1 Sidewalk: Curb side : Cutout Tree 2     11 3x3   6008257.68745 2097584.33547 37.7400336302449 -122.41400058886 (37.7400336302449, -122.41400058886) 2 7 7 28859 2
3033 121390 4 66 1301x 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5993851 2106604 37.7639796518152 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
6915 116579 6 66 3000x 19TH AVE 2 Sidewalk: Property side : Cutout Tree 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
8234 121391 4 66 1301x 07th Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5993851 2106604 37.7639796518152 -122.464467327674 (37.7639796518152, -122.464467327674) 1 8 11 56 12
8510 259163 9 66 1 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9208 259164 9 66 1 Corbett Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
9498 97930 4 66 1615 Grant Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6010461.1 2120070.1 37.801897866839 -122.40796734514 (37.801897866839, -122.40796734514) 3 1 10 308 23
16349 259165 9 66 1 Corbett Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6001019 2105729 37.7619877090771 -122.439612669611 (37.7619877090771, -122.439612669611) 15 5 5 28862 3
20043 116577 6 66 3000x 19TH AVE 1 Sidewalk: Property side : Cutout Tree 3 DPW   30 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
28034 113803 7 66 806 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree 2 FUF     3x3   6007931 2103220 37.755489548438 -122.415529041662 (37.755489548438, -122.415529041662) 2 4 7 28859 19
41363 102755 4 66 61 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree 2     0 3x3   5996159.1 2114114.4 37.7847340229516 -122.457027629275 (37.7847340229516, -122.457027629275) 11 6 1 54 31
43687 117610 1 66 391 NEVADA ST 1 Unaccepted Street : Yard Landscaping 2       3x3   6008958 2096497 37.7370873514658 -122.411502385785 (37.7370873514658, -122.411502385785) 10 7 7 28859 2
48266 114185 4 66 2200 HAYES ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
75140 251667 1 66 1090x Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5988120 2094796 37.7312259936493 -122.483423232518 (37.7312259936493, -122.483423232518) 1 8 4 64 35
78880 251666 1 66 76 Denslowe Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5990680 2091936 37.7235218144923 -122.474364317808 (37.7235218144923, -122.474364317808) 9 8 4 64 40
94878 117511 1 66 2634 37TH AVE 1 Median : Yard Landscaping 1     20 3x3   5984921 2097163 37.7375384395308 -122.494657023299 (37.7375384395308, -122.494657023299) 1 8 3 29491 35
112926 251642 1 66 2253 Broderick St 4 Sidewalk: Curb side : Cutout Landscaping 2       3x3   6000298.51737 2116393.24113 37.7912279703404 -122.442870356286 (37.7912279703404, -122.442870356286) 13 6 1 29490 27
149312 104783 4 66 50 Walnut St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   5998501.2 2116298 37.790863832623 -122.449082132455 (37.790863832623, -122.449082132455) 13 6 1 54 31
150789 99672 1 66 1250X Shrader St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
154894 104034 4 66 722 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6012694 2104139 37.7582794948464 -122.39912151779 (37.7582794948464, -122.39912151779) 10 3 8 28856 29
161563 116580 6 66 3000x 19TH AVE 3 Sidewalk: Property side : Cutout Landscaping 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
105604 23896 1 66 1581 Webster St 3 Sidewalk: Curb side : Cutout Tree 1   05/24/2017 12:00:00 AM 3 3x3   6003535.3531022 2114132.0136397 37.7852032161945 -122.431509502733 (37.7852032161945, -122.431509502733) 13 9 11 29490 13
68664 94197 7 66 355 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
96160 94198 7 66 355 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
44868 37377 7 66 755 Morse St 11 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
51790 37371 7 66 755 Morse St 5 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
175412 37379 7 66 755 Morse St 13 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
14115 61098 7 66 806 Shotwell St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/24/1988 12:00:00 AM   3x3 Permit Number 25594 6007925.06671696 2103219.75918175 37.7554885536992 -122.415549543793 (37.7554885536992, -122.415549543793) 2 4 7 28859 19