trees

Custom SQL query returning 19 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
151 233915 1 34 998 York St 9 Sidewalk: Curb side : Yard Tree 2     1 Width 7ft   6009943.01185 2103432.65253 37.7561863328563 -122.408585854469 (37.7561863328563, -122.408585854469) 2 4 7 28859 19
26444 13357 1 34 638 Mansell St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6010007.9165631 2090278.8375457 37.7200724231428 -122.407434081538 (37.7200724231428, -122.407434081538) 10 3 7 309 28
61056 248086 1 34 64 Peralta Ave 1 Sidewalk: Property side : Yard Tree 2     16 Width 8ft   6010586.08965 2100411.89734 37.7479280005978 -122.406149049637 (37.7479280005978, -122.406149049637) 2 7 7 28859 2
66575 255607 4 34 347 San Carlos St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006753 2104097 37.7578313031701 -122.419665158689 (37.7578313031701, -122.419665158689) 2 4 7 28859 19
66903 233917 6 34 1011 South Van Ness Ave 1 Front Yard : Yard Tree 2     21 Width 3ft   6007639.59401 2103741.67603 37.756905567467 -122.416573768674 (37.756905567467, -122.416573768674) 2 4 7 28859 19
101123 256285 6 34 155x Caledonia St 1 Back Yard : Yard Tree 2       3x3   6006400 2106945 37.765631353558 -122.421088199968 (37.765631353558, -122.421088199968) 8 4 7 28853 19
131275 233913 1 34 2801 Mariposa St 4 : Tree 2     4 Width 3ft   6009155.31558 2105892.63028 37.7628967259343 -122.411483776778 (37.7628967259343, -122.411483776778) 8 4 7 28859 19
132278 233918 1 34 60 Murray St 3 Sidewalk: Property side : Yard Tree 2     17 Width 8ft   6004967.71802 2095266.36658 37.7334836807325 -122.425211061736 (37.7334836807325, -122.425211061736) 2 7 7 28861 2
139362 255610 1 34 355X San Carlos St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006938 2104061 37.7577428748963 -122.419022796788 (37.7577428748963, -122.419022796788) 2 4 7 28859 19
159885 178080 1 34 202 University St 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 4ft   6008024.94769 2092933.54254 37.7272504886183 -122.41447630234 (37.7272504886183, -122.41447630234) 9 3 7 309 28
167482 178081 1 34 913 Silliman St 4 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6008142.94596 2093501.21518 37.728815824271 -122.414108525499 (37.728815824271, -122.414108525499) 9 3 7 309 28
169065 108625 8 34 100 GENEBERN WAY 1 Front Yard : Yard Tree 2     12     6004991.8 2095242.4 37.7334192343039 -122.425126098693 (37.7334192343039, -122.425126098693) 2 7 7 28861 2
172650 255483 6 34 1295 Hampshire St 1 Front Yard : Yard Tree 2       Width 3ft   6010340.83328 2101731.71507 37.7515382084299 -122.407090155993 (37.7515382084299, -122.407090155993) 10 4 7 28859 19
179943 233916 1 34 3178 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6008600.98611 2100616.94315 37.7483797759052 -122.413027970288 (37.7483797759052, -122.413027970288) 2 4 7 28859 19
185497 246695 1 34 1 Bonview St 1 Sidewalk: Curb side : Yard Tree 2     1     6007634.96405 2098994.37065 37.7438702793061 -122.416253557858 (37.7438702793061, -122.416253557858) 2 7 7 28859 2
185503 246696 1 34 1 Bonview St 2 Sidewalk: Curb side : Yard Tree 2     1     6007645.436 2099008.47184 37.7439095868695 -122.4162183467 (37.7439095868695, -122.4162183467) 2 7 7 28859 2
186058 248211 1 34 67 Fair Ave 1 Sidewalk: Property side : Yard Tree 2     10 Width 6ft   6007036.37972 2099436.77793 37.7450513535288 -122.418354689821 (37.7450513535288, -122.418354689821) 2 7 7 28859 2
192056 233919 1 34 60 Murray St 4 Sidewalk: Property side : Yard Tree 2     16 Width 8ft   6004972.94282 2095265.21393 37.7334808109789 -122.425192916113 (37.7334808109789, -122.425192916113) 2 7 7 28861 2
193450 233912 1 34 2801 Mariposa St 2 : Tree 2     3 Width 3ft   6009119.38716 2105891.31096 37.7628910880777 -122.411607947957 (37.7628910880777, -122.411607947957) 8 4 7 28859 19