trees

Custom SQL query returning 41 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
42731 115967 1 33 1599x 30th Ave 4 Sidewalk: Curb side : Cutout Tree 4     4 3x3   5986812.8086 2104676.4366 37.7582788637421 -122.488668327875 (37.7582788637421, -122.488668327875) 1 8 3 56 35
49723 115970 1 33 1599x 30TH AVE 7 Sidewalk: Curb side : Cutout Tree 4     0 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
52455 117257 1 27 1570 31ST AVE 5 Sidewalk: Curb side : Cutout Tree 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
57689 117255 1 99 1570 31ST AVE 3 Sidewalk: Curb side : Cutout Tree 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
81017 117256 1 99 1570 31ST AVE 4 Sidewalk: Curb side : Cutout Tree 4           5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
91388 105784 1 99 1570 31ST AVE 1 Sidewalk: Curb side : Cutout Tree 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432) 1 8 3 56 35
92249 115964 1 33 1599x 30TH AVE 1 Sidewalk: Curb side : Cutout Tree 4     8 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
148752 115965 1 33 1599x 30th Ave 2 Sidewalk: Curb side : Cutout Tree 4     7 3x3   5986811.649 2104744.2782 37.7584650705211 -122.488677324697 (37.7584650705211, -122.488677324697) 1 8 3 56 35
152290 115971 1 33 1599x 30th Ave 8 Sidewalk: Curb side : Cutout Tree 4     4 3x3   5986813.9683 2104572.6448 37.757993947556 -122.488656688385 (37.757993947556, -122.488656688385) 1 8 3 56 35
156729 115973 1 33 1599x 30TH AVE 10 Sidewalk: Curb side : Cutout Tree 4     0 3x3   5986686 2104596 37.7580506061519 -122.489100968136 (37.7580506061519, -122.489100968136) 1 8 3 56 35
167675 115968 1 33 1599x 30th Ave 5 Sidewalk: Curb side : Cutout Tree 4     6 3x3   5986813.3885 2104648.6042 37.7582024774349 -122.488664276638 (37.7582024774349, -122.488664276638) 1 8 3 56 35
170193 115966 1 33 1599x 30th Ave 3 Sidewalk: Curb side : Cutout Tree 4     6 3x3   5986811.649 2104717.0256 37.7583902423484 -122.488675321582 (37.7583902423484, -122.488675321582) 1 8 3 56 35
178733 115972 1 33 1599x 30th Ave 9 Sidewalk: Curb side : Cutout Tree 4     8 3x3   5986817.4474 2104547.1317 37.7579240985888 -122.488642781125 (37.7579240985888, -122.488642781125) 1 8 3 56 35
178792 115969 1 9 1599x 30th Ave 6 Sidewalk: Curb side : Cutout Tree 4     2 3x3   5986813.3885 2104627.15 37.7581435700771 -122.488662699732 (37.7581435700771, -122.488662699732) 1 8 3 56 35
2028 76748 1 122 1501X 42nd Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   7 3x12   5983093.5463 2104693.1195 37.7581069307926 -122.501532189631 (37.7581069307926, -122.501532189631) 1 8 3 56 35
3628 76755 1 95 1501X 42nd Ave 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x12   5983093.5463 2104662.8676 37.758023867602 -122.501529951702 (37.758023867602, -122.501529951702) 1 8 3 56 35
5610 46958 1 16 1530 43rd Ave 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
5633 76756 1 95 1501X 42nd Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x12   5983095.0741 2104639.3384 37.757959352781 -122.501522927406 (37.757959352781, -122.501522927406) 1 8 3 56 35
11170 76785 1 42 1501X 42nd Ave 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   24 3x12   5983097.8243 2104541.5546 37.75769102754 -122.501506182606 (37.75769102754, -122.501506182606) 1 8 3 56 35
14697 76382 1 42 1501X 42nd Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   25 3x12   5983091.4072 2104771.8049 37.7583228530818 -122.501545408351 (37.7583228530818, -122.501545408351) 1 8 3 56 35
18929 76784 1 16 1501X 42nd Ave 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   1 3x12   5983097.2131 2104562.028 37.7577472058325 -122.501509810878 (37.7577472058325, -122.501509810878) 1 8 3 56 35
58717 46964 1 16 3899X Kirkham St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
59100 46948 1 16 1530 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 3 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
63621 46967 1 16 3899X Kirkham St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
65075 76344 1 16 3899X Kirkham St 12 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/14/1994 12:00:00 AM 12 3x30   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
70695 46953 1 16 1530 43rd Ave 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
72358 46950 1 16 1530 43rd Ave 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
75380 46955 1 16 1530 43rd Ave 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 4 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
78188 46960 1 16 1530 43rd Ave 13 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
79799 46957 1 16 1530 43rd Ave 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
81039 46962 1 16 1530 43rd Ave 15 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 6 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
87699 76252 1 16 3899X Kirkham St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
87796 76222 1 16 3899X Kirkham St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
97962 46965 1 16 3899X Kirkham St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
104330 46952 1 16 1530 43rd Ave 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
155449 46966 1 16 3899X Kirkham St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x20 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
157174 46961 1 16 1530 43rd Ave 14 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 7 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
162635 46949 1 16 1530 43rd Ave 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 5 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
167652 46951 1 16 1530 43rd Ave 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/01/2002 12:00:00 AM 8 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
171291 76271 1 16 3899X Kirkham St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/14/1994 12:00:00 AM 8 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35
189611 76325 1 16 3899X Kirkham St 11 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 05/14/1994 12:00:00 AM 5 3x20   5982828.25460357 2104700.39822601 37.7581113313144 -122.502450205887 (37.7581113313144, -122.502450205887) 1 8 3 56 35