trees

Custom SQL query returning 39 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
150959 215653 1 98 2348 12th Ave 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 4ft   5992661.56559 2099277.36627 37.7437939781139 -122.468048216973 (37.7437939781139, -122.468048216973) 1 8 4 29491 40
151683 215726 1 98 65 Marcela Ave 1 Sidewalk: Curb side : Yard Tree 2     23 Width 4ft   5994671.05341 2100636.37069 37.7476413066028 -122.46119842269 (37.7476413066028, -122.46119842269) 1 8 4 29491 40
152303 215689 1 98 405 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree 2     22 Width 3ft   5993745.16415 2099469.59605 37.7443843110814 -122.464315372153 (37.7443843110814, -122.464315372153) 1 8 4 29491 40
152423 215723 1 98 337 Pacheco St 2 Sidewalk: Curb side : Yard Tree 2     13 Width 3ft   5994187.72813 2101011.61319 37.7486438006744 -122.462896940751 (37.7486438006744, -122.462896940751) 1 8 4 29491 40
153464 215663 1 98 551 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 3ft   5992925.45554 2099404.24076 37.7441575794167 -122.467144978385 (37.7441575794167, -122.467144978385) 1 8 4 29491 40
157344 215709 1 98 98 Taraval St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   5993297.50718 2099210.38702 37.7436467752768 -122.465844433682 (37.7436467752768, -122.465844433682) 1 8 4 29491 40
158737 215752 1 98 1199 Bosworth St 12 Sidewalk: Property side : Yard Tree 2     15     6000481.62782 2095905.99262 37.7349854891864 -122.440766574932 (37.7349854891864, -122.440766574932) 9 7 4 63 40
158768 215699 1 98 22 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     26 Width 3ft   5993719.19331 2099246.04801 37.7437690075397 -122.464388945713 (37.7437690075397, -122.464388945713) 1 8 4 29491 40
159424 215750 1 98 1199 Bosworth St 10 Sidewalk: Property side : Yard Tree 2     10     6000479.78996 2095909.84974 37.7349959752708 -122.440773205638 (37.7349959752708, -122.440773205638) 9 7 4 63 40
161512 215473 1 98 80 Santa Ana Ave 1 Sidewalk: Curb side : Yard Tree 2     11 Width 8ft   5992586.31488 2096252.67544 37.7354845949313 -122.468088438245 (37.7354845949313, -122.468088438245) 1 8 4 59 40
162759 215704 1 98 62 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 3ft   5993453.70426 2099223.1321 37.7436907791226 -122.465305272128 (37.7436907791226, -122.465305272128) 1 8 4 29491 40
162922 215669 1 98 100 Cortes Ave 1 Sidewalk: Curb side : Cutout Tree 2   04/21/2016 12:00:00 AM 12 Width 3ft Permit Number 777819 5993202.34131 2099405.04852 37.7441757763018 -122.46618763477 (37.7441757763018, -122.46618763477) 1 8 4 29491 40
165624 106158 4 98 450 MAGELLAN AVE   Sidewalk: Curb side : Yard Tree 2     20 6x6   5993514.2 2099497.2 37.7444467889139 -122.465115996043 (37.7444467889139, -122.465115996043) 1 8 4 29491 40
165683 215738 1 98 15x San Marcos Ave 19 Median : Cutout Tree 1     17 Width 5ft   5993371.75539 2100358.30231 37.7468029424032 -122.465671084868 (37.7468029424032, -122.465671084868) 1 8 4 29491 40
167056 215745 1 98 1199 Bosworth St 5 Sidewalk: Property side : Yard Tree 2     33 Width 10ft   6000472.43959 2095925.27887 37.7350379214503 -122.440799724826 (37.7350379214503, -122.440799724826) 9 7 4 63 40
170026 215679 1 98 475 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5993351.61336 2099439.68765 37.7442794977971 -122.465674004977 (37.7442794977971, -122.465674004977) 1 8 4 29491 40
171001 215655 1 98 2348 12th Ave 5 Sidewalk: Curb side : Cutout Tree 2     18 Width 4ft   5992658.55199 2099364.68475 37.7440335584079 -122.468064987503 (37.7440335584079, -122.468064987503) 1 8 4 29491 40
171015 215717 1 98 198 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   5992710.76585 2099162.99792 37.7434827928969 -122.467869778873 (37.7434827928969, -122.467869778873) 1 8 4 29491 40
171172 215681 1 98 465 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     21 Width 3ft   5993417.18845 2099443.87726 37.7442947835944 -122.465447566463 (37.7442947835944, -122.465447566463) 1 8 4 29491 40
173674 215701 1 98 38 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     18 Width 3ft   5993601.93948 2099231.41525 37.7437220701321 -122.464793315966 (37.7437220701321, -122.464793315966) 1 8 4 29491 40
173854 215724 1 98 337 Pacheco St 3 Sidewalk: Curb side : Yard Tree 2     16 Width 3ft   5994197.80504 2100993.48118 37.7485945951844 -122.462860779902 (37.7485945951844, -122.462860779902) 1 8 4 29491 40
174689 215697 1 98 18 Taraval St 4 Sidewalk: Curb side : Cutout Tree 2     19 Width 3ft   5993786.94355 2099253.5291 37.7437934538112 -122.464155226295 (37.7437934538112, -122.464155226295) 1 8 4 29491 40
176659 215721 1 98 345 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     13 Width 4ft   5994111.22171 2099760.97057 37.7452054451668 -122.463070768016 (37.7452054451668, -122.463070768016) 1 8 4 29491 40
178179 215730 1 98 310 Pacheco St 1 Sidewalk: Curb side : Cutout Tree 2     21 Width 4ft   5994304.44088 2100856.56791 37.748224807423 -122.462482107774 (37.748224807423, -122.462482107774) 1 8 4 29491 40
178204 215714 1 98 170 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   5992837.34003 2099175.81646 37.743525297563 -122.46743305279 (37.743525297563, -122.46743305279) 1 8 4 29491 40
179407 106157 4 98 450 MAGELLAN AVE 1 Sidewalk: Curb side : Yard Tree 2     20     5993514.2 2099497.2 37.7444467889139 -122.465115996043 (37.7444467889139, -122.465115996043) 1 8 4 29491 40
180414 215756 1 98 811 Congo St 28 Sidewalk: Property side : Yard Tree 2     10     6000507.98466 2095900.86283 37.734972904964 -122.440675082413 (37.734972904964, -122.440675082413) 9 7 4 63 40
181225 215757 1 98 811 Congo St 26 Sidewalk: Property side : Yard Tree 2     35     6000510.50193 2095892.79039 37.73495088328 -122.44066580051 (37.73495088328, -122.44066580051) 9 7 4 63 40
181428 215765 1 98 811 Congo St 16 Sidewalk: Property side : Yard Tree 2     2 Width 10ft   6000567.86167 2095875.36939 37.7349063155722 -122.440466239146 (37.7349063155722, -122.440466239146) 9 7 4 63 40
181503 215656 1 98 593 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   5992672.51184 2099382.74346 37.7440839492114 -122.468018031212 (37.7440839492114, -122.468018031212) 1 8 4 29491 40
185123 215727 1 98 65 Marcela Ave 2 Sidewalk: Curb side : Yard Tree 2     10 Width 4ft   5994677.54204 2100642.18957 37.7476576571947 -122.461176407263 (37.7476576571947, -122.461176407263) 1 8 4 29491 40
185142 215658 1 98 585 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   5992725.64993 2099388.06552 37.7441016307792 -122.467834680137 (37.7441016307792, -122.467834680137) 1 8 4 29491 40
186093 215771 1 98 811 Congo St 10 Sidewalk: Property side : Yard Tree 2     29 Width 8ft   6000578.22769 2095871.70651 37.734896848405 -122.440430137662 (37.734896848405, -122.440430137662) 9 7 4 63 40
187844 215761 1 98 811 Congo St 20 Sidewalk: Property side : Yard Tree 2     1 Width 10ft   6000556.80733 2095878.65384 37.7349147044535 -122.440504693264 (37.7349147044535, -122.440504693264) 9 7 4 63 40
188986 215659 1 98 581 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 4ft   5992760.61494 2099390.2279 37.7441095870799 -122.467713937172 (37.7441095870799, -122.467713937172) 1 8 4 29491 40
189173 215675 1 98 101 Cortes Ave 4 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   5993235.56164 2099408.72436 37.7441877858384 -122.466073034138 (37.7441877858384, -122.466073034138) 1 8 4 29491 40
192095 215668 1 98 513 Magellan Ave 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   5993182.22606 2099422.72334 37.744223146296 -122.466258472572 (37.744223146296, -122.466258472572) 1 8 4 29491 40
192266 215711 1 98 120 Taraval St 1 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5993106.31705 2099196.4779 37.7435975535962 -122.466504506383 (37.7435975535962, -122.466504506383) 1 8 4 29491 40
194216 215654 1 98 2348 12th Ave 2 Sidewalk: Curb side : Cutout Tree 2     15 Width 4ft   5992660.75686 2099331.15305 37.7439416162244 -122.468054925011 (37.7439416162244, -122.468054925011) 1 8 4 29491 40