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)
5657 41933 1 123 610 04th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM 6   Permit Number 42292 5994729.71498 2111330.05881 37.7770067806052 -122.461770835952 (37.7770067806052, -122.461770835952) 11 6 2 54 11
23653 90897 1 123 1145 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree 1   02/20/2008 12:00:00 AM 3 3x3   5992033.67177 2110642.90774 37.7749644818454 -122.471047125233 (37.7749644818454, -122.471047125233) 11 6 2 54 11
27091 90555 1 123 1150 Cabrillo St 2 Sidewalk: Curb side : Cutout Tree 1   02/14/2008 12:00:00 AM 3 3x3   5992035.9437 2110699.81053 37.7751208528883 -122.471043412514 (37.7751208528883, -122.471043412514) 11 6 2 54 11
34046 31982 1 123 232 03rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/30/1995 12:00:00 AM 12 3x3 Permit Number 35382 5994946.26899 2113981.48738 37.7842993574965 -122.461213955921 (37.7842993574965, -122.461213955921) 11 6 2 54 11
38813 90554 1 123 1150 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree 1   02/14/2008 12:00:00 AM 3 3x3   5992007.5751 2110699.64473 37.7751187568292 -122.471141532792 (37.7751187568292, -122.471141532792) 11 6 2 54 11
39857 8913 1 123 4455X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree 1     12 3x3   5993194.92162 2112721.50101 37.7807388335807 -122.467181309852 (37.7807388335807, -122.467181309852) 11 6 2 54 11
44084 41912 1 123 642 12th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM 8   Permit Number 42274 5992258.1025 2111064.36491 37.7761346671426 -122.470301476833 (37.7761346671426, -122.470301476833) 11 6 2 54 11
61838 90896 1 123 1145 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree 1   02/20/2008 12:00:00 AM 3 3x3   5992053.33041 2110644.47867 37.7749699321879 -122.47097923688 (37.7749699321879, -122.47097923688) 11 6 2 54 11
64123 123208 1 123 400 09th Ave 4 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5993131.19371 2112699.04699 37.7806735020779 -122.467400140372 (37.7806735020779, -122.467400140372) 11 6 2 54 11
74281 34259 1 123 164 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/29/1998 12:00:00 AM 12   Permit Number 39598 5993996.78061 2114472.4725 37.7855927810379 -122.464534489449 (37.7855927810379, -122.464534489449) 11 6 1 54 11
76553 123210 1 123 400 09th Ave 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5993133.98431 2112655.94122 37.7805553064396 -122.467387351051 (37.7805553064396, -122.467387351051) 11 6 2 54 11
87429 41913 1 123 642 12th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM 8   Permit Number 42274 5992259.32657 2111046.49076 37.7760856603427 -122.470295940533 (37.7760856603427, -122.470295940533) 11 6 2 54 11
100139 67314 1 123 666 10th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/15/1992 12:00:00 AM 7   Permit Number 30795 5992883.6827 2110925.23066 37.77578879069 -122.468127322089 (37.77578879069, -122.468127322089) 11 6 2 54 11
101968 41934 1 123 615 04th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/20/2000 12:00:00 AM 5   Permit Number 42293 5994683.51563 2111320.01316 37.7769765383201 -122.461929924013 (37.7769765383201, -122.461929924013) 11 6 2 54 11
103672 36967 1 123 381 05th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/29/1998 12:00:00 AM 9   Permit Number 39594 5994314.22367 2112999.17695 37.7815658043957 -122.463329288102 (37.7815658043957, -122.463329288102) 11 6 2 54 11
113993 36966 1 123 381 05th Ave 2 Sidewalk: Curb side : Cutout Tree 2 FUF 05/29/1998 12:00:00 AM 7   Permit Number 39594 5994314.52093 2112981.13075 37.7815162715185 -122.463326949801 (37.7815162715185, -122.463326949801) 11 6 2 54 11
116652 123211 1 123 400 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   5993134.492 2112639.50466 37.7805102054167 -122.467384399185 (37.7805102054167, -122.467384399185) 11 6 2 54 11
116896 124090 1 123 601 Funston Ave 5 Sidewalk: Property side : Yard Tree 2     12     5991893.39709 2111137.10441 37.7763132974782 -122.471568380763 (37.7763132974782, -122.471568380763) 11 6 2 54 11
123918 34257 1 123 160 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/29/1998 12:00:00 AM 9   Permit Number 39597 5993997.84726 2114498.92628 37.7856654774057 -122.464532720679 (37.7856654774057, -122.464532720679) 11 6 1 54 11
130878 123179 1 123 771 10th Ave 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5992862.96444 2110216.56004 37.7738417753505 -122.468147428182 (37.7738417753505, -122.468147428182) 11 6 2 54 11
132385 44257 1 123 122 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/15/2001 12:00:00 AM 9   Permit Number 43690 5993988.26127 2114691.75826 37.7861943888941 -122.464579892109 (37.7861943888941, -122.464579892109) 11 6 1 54 11
142722 111741 1 123 498x 11th Ave 4 Sidewalk: Curb side : Cutout Tree 2     1 3x3   5992530.71883 2112167.74428 37.7791800053719 -122.469438767189 (37.7791800053719, -122.469438767189) 11 6 2 54 11
143264 31983 1 123 252 03rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/30/1995 12:00:00 AM 7 3x3 Permit Number 35383 5994950.72464 2113855.38064 37.7839533587811 -122.461189396885 (37.7839533587811, -122.461189396885) 11 6 2 54 11
144340 43686 1 123 162 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/25/2000 12:00:00 AM 4   Permit Number 43330 5993378.79836 2114426.59889 37.785431180637 -122.46666917492 (37.785431180637, -122.46666917492) 11 6 2 54 11
150853 34256 1 123 156 06th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/29/1998 12:00:00 AM 4   Permit Number 39596 5993995.61311 2114522.39441 37.78572978571 -122.46454215478 (37.78572978571, -122.46454215478) 11 6 1 54 11
157957 88525 7 123 626x Funston Ave   Sidewalk: Curb side : Cutout Tree 2   07/21/2008 12:00:00 AM   3x3 Permit Number 51466 5991969.3 2111151 37.7763558419216 -122.471306826694 (37.7763558419216, -122.471306826694) 11 6 2 54 11
191980 123105 1 123 498 11th Ave 5 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   5992529.16869 2112181.64232 37.7792180760249 -122.469445141648 (37.7792180760249, -122.469445141648) 11 6 2 54 11