trees

Custom SQL query returning 40 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
44173 49818 1 6 1300 De Haro St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/11/2003 12:00:00 AM 7 3x3 Permit Number 46609 6012222.38132 2102319.17957 37.7532563730854 -122.400624753529 (37.7532563730854, -122.400624753529) 10 3 8 28856 29
150802 61555 1 6 1175- 1175 De Haro St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/18/2018 12:00:00 AM 3 3x3 Permit Number 781207 6012252.19835 2102963.49184 37.7550271768774 -122.400566896541 (37.7550271768774, -122.400566896541) 10 3 8 28856 29
175350 191223 1 6 1112 De Haro St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6012178.19052 2103217.19746 37.7557196692435 -122.400840661869 (37.7557196692435, -122.400840661869) 10 3 8 28856 29
17049 112023 1 6 2101x 22nd Ave 3 Sidewalk: Curb side : Cutout Tree 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
17413 112021 1 6 2101x 22nd Ave 1 Sidewalk: Curb side : Cutout Tree 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
127080 112029 1 6 2101x 22nd Ave 9 Sidewalk: Curb side : Cutout Tree 4   07/23/2015 12:00:00 AM 3 9x9   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
187598 112025 1 6 2101x 22nd Ave 5 Sidewalk: Curb side : Cutout Tree 4   07/23/2015 12:00:00 AM 3 5x5   6011761 2103726 37.75709344993 -122.402319220858 (37.75709344993, -122.402319220858) 10 3 8 28856 29
176365 68842 1 6 602 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/27/2004 12:00:00 AM 5 3x3 Permit Number 767166 6014359.28345 2104329.14494 37.7588942535933 -122.393375500204 (37.7588942535933, -122.393375500204) 10 3 8 28856 29
40165 191226 1 6 2350 20th St 3 Sidewalk: Property side : Yard Tree 2     4 Width 7ft   6011107.06002 2104648.42845 37.7595897074225 -122.404645742032 (37.7595897074225, -122.404645742032) 10 3 8 28856 29
174893 191225 1 6 2350 20th St 2 Sidewalk: Property side : Yard Tree 2     4     6011119.4005 2104649.28038 37.7595927363317 -122.404603122242 (37.7595927363317, -122.404603122242) 10 3 8 28856 29
170413 191224 1 6 2350 20th St 1 Sidewalk: Property side : Yard Tree 2     4     6011129.67031 2104650.44992 37.7595965215873 -122.404567686256 (37.7595965215873, -122.404567686256) 10 3 8 28856 29
23895 92663 7 6 791 San Bruno Ave 1 Sidewalk: Property side : Cutout Tree 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
73269 92664 7 6 791 San Bruno Ave 2 Sidewalk: Property side : Cutout Tree 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
122415 92665 7 6 791 San Bruno Ave 3 Sidewalk: Property side : Cutout Tree 2   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.7596443172001 -122.404916188138 (37.7596443172001, -122.404916188138) 10 3 8 28856 29
152989 47678 1 6 536 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/21/2002 12:00:00 AM 9   Permit Number 45462 6014348.84456 2104603.39752 37.7596467118443 -122.393430795897 (37.7596467118443, -122.393430795897) 10 3 8 28856 29
153170 191220 1 6 2300 18th St 5 Sidewalk: Curb side : Cutout Tree 2     8 Width 4ft   6010900.2167 2105543.22676 37.762035060293 -122.405424130428 (37.762035060293, -122.405424130428) 8 3 8 28856 29
12282 83440 1 6 2230 18th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   8     6011076.92464 2105580.38381 37.7621469638337 -122.404815578978 (37.7621469638337, -122.404815578978) 8 3 8 28856 29
189147 191218 1 6 477 Vermont St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6011234.32907 2106146.16371 37.7637092651804 -122.404310998169 (37.7637092651804, -122.404310998169) 8 3 8 28856 29
106294 191227 1 6 201 Texas St 1 : Tree 2     3 Width 3ft   6013759.688 2106121.42545 37.7637821327587 -122.395574766182 (37.7637821327587, -122.395574766182) 14 3 8 28856 29
174884 191222 1 6 1143 Mariposa St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6013778.51486 2106149.81223 37.7638611238173 -122.39551163825 (37.7638611238173, -122.39551163825) 14 3 8 28856 29
158624 49803 1 6 101 Mississippi St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 06/11/2003 12:00:00 AM 8   Permit Number 46598 6014016.82872 2106570.58674 37.7650297307661 -122.394716845308 (37.7650297307661, -122.394716845308) 14 3 8 28856 29
148668 49802 7 6 101 MISSISSIPPI ST 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/11/2003 12:00:00 AM     Permit Number 46598 6014071 2106574 37.765042114519 -122.394529717904 (37.765042114519, -122.394529717904) 14 3 8 28856 29
65951 191221 1 6 101 Mississippi St 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 3ft   6014015.89789 2106592.91783 37.7650909952748 -122.394721628821 (37.7650909952748, -122.394721628821) 14 3 8 28856 29
102170 39552 1 6 1101 16th St 1 Sidewalk: Curb side : Cutout Tree 2   12/28/1998 12:00:00 AM 10   Permit Number 40979 6013009.1617 2107035.865 37.7662512051775 -122.398234785624 (37.7662512051775, -122.398234785624) 14 3 8 28856 20
887 60297 1 6 1101 16th St 2 Sidewalk: Curb side : Cutout Tree 2 FUF 09/27/1982 12:00:00 AM 7   Permit Number 19862 6013032.9382 2107035.865 37.7662525295396 -122.398152546702 (37.7662525295396, -122.398152546702) 14 3 8 28856 20
120653 200835 1 6 1101 16th St 3 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6013058.6169 2107038.7182 37.7662617940431 -122.398063928568 (37.7662617940431, -122.398063928568) 14 3 8 28856 20
185726 200836 1 6 1101 16th St 4 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6013076.6871 2107039.6693 37.7662654119853 -122.398001493496 (37.7662654119853, -122.398001493496) 14 3 8 28856 20
80264 105013 7 6 330 Townsend St 2 Sidewalk: Curb side : Cutout Tree 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
92191 105012 7 6 330 Townsend St 1 Sidewalk: Curb side : Cutout Tree 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
136349 105014 7 6 330 Townsend St 3 Sidewalk: Curb side : Cutout Tree 2       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132) 6 2 9 28856 34
9840 256599 4 6 2x Stillman St 26 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
29256 256605 4 6 2x Stillman St 32 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
32904 256600 4 6 2x Stillman St 27 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
51877 256607 4 6 2x Stillman St 34 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
61590 256576 4 6 2x Stillman St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
70541 256574 4 6 2x Stillman St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
92562 256604 4 6 2x Stillman St 31 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
134706 256601 4 6 2x Stillman St 28 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
160238 256575 4 6 2x Stillman St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
183981 256606 4 6 2x Stillman St 33 Sidewalk: Curb side : Cutout Tree 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6