trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
77871 214162 1 91 56 Miramar Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   5995350.86908 2090273.63849 37.7192268694992 -122.458097813856 (37.7192268694992, -122.458097813856) 9 8 6 28861 24
115611 214163 1 91 274 Tara St 1 : Tree 2     8 Width 3ft   5997748.47431 2090294.62139 37.7194219549502 -122.449811751014 (37.7194219549502, -122.449811751014) 9 8 6 28861 24
176676 214164 1 91 900 Junipero Serra Blvd 99 : Tree 2     5 Width 0ft   5991142.14923 2090504.71444 37.7196186222819 -122.47266246032 (37.7196186222819, -122.47266246032) 9 8 4 64 40
139364 29613 1 91 900X Junipero Serra Blvd 22 Median : Cutout Tree 1   03/30/2006 12:00:00 AM 3 3X3   5991166.63654 2090933.64994 37.7207977908582 -122.472609073865 (37.7207977908582, -122.472609073865) 9 8 4 64 40
186600 29610 1 91 900X Junipero Serra Blvd 19 Median : Cutout Tree 1   03/30/2006 12:00:00 AM 3 3X3   5991173.75038 2091017.49654 37.7210284247022 -122.472590593675 (37.7210284247022, -122.472590593675) 9 8 4 64 40
168964 29596 1 91 900X Junipero Serra Blvd 5 Median : Cutout Tree 1   03/30/2006 12:00:00 AM 3 3X3   5991179.03639 2091124.89815 37.7213236289735 -122.472580148063 (37.7213236289735, -122.472580148063) 9 8 4 64 40
29837 214153 1 91 391 Santa Ana Ave 2 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   5992476.67943 2094212.83068 37.7298773579434 -122.46831913414 (37.7298773579434, -122.46831913414) 9 8 4 59 40
179865 214168 1 91 250 Maywood Dr 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   5994367.37708 2095058.85535 37.7323093567717 -122.46184414221 (37.7323093567717, -122.46184414221) 9 8 4 59 40
13005 40812 7 91 240 Maywood Dr 1 Sidewalk: Curb side : Cutout Tree 2   08/25/1999 12:00:00 AM     Permit Number 41757 5994290.46519005 2095120.08849436 37.732473059968 -122.462114481375 (37.732473059968, -122.462114481375) 9 8 4 59 40
149656 40810 7 91 240 Maywood Dr 3 Sidewalk: Curb side : Cutout Tree 2   08/25/1999 12:00:00 AM     Permit Number 41757 5994290.46519005 2095120.08849436 37.732473059968 -122.462114481375 (37.732473059968, -122.462114481375) 9 8 4 59 40
147452 183550 1 91 2593 23rd Ave 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   5989227.3726 2097702.4617 37.7392707770079 -122.479807490437 (37.7392707770079, -122.479807490437) 1 8 3 29491 35
76751 49937 1 91 2591 26th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/02/2003 12:00:00 AM 4   Permit Number 46696 5988296.2269 2097703.198 37.7392186595719 -122.483026991295 (37.7392186595719, -122.483026991295) 1 8 3 29491 35
59190 183549 1 91 2593 23rd Ave 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   5989226.3762 2097721.7265 37.7393236152619 -122.479812344828 (37.7393236152619, -122.479812344828) 1 8 3 29491 35
11956 72875 1 91 2506 23rd Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   4     5989254.9412 2098243.205 37.7407571191622 -122.47975172868 (37.7407571191622, -122.47975172868) 1 8 3 29491 35
59784 45068 1 91 2227 27th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 05/08/2001 12:00:00 AM 4   Permit Number 43949 5987902.9352 2100130.6194 37.7458608246267 -122.4845648054 (37.7458608246267, -122.4845648054) 1 8 3 29491 35
159362 68308 1 91 2178 47th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/09/1993 12:00:00 AM 0   Permit Number 32119 5981736.58109187 2100266.85539552 37.7458738657157 -122.505896923616 (37.7458738657157, -122.505896923616) 1 8 3 29491 35
74800 214156 1 91 495 Pacheco St 3 Sidewalk: Curb side : Yard Tree 2     7 Width 6ft   5993555.55486 2101853.98601 37.7509203085364 -122.465144146879 (37.7509203085364, -122.465144146879) 1 8 4 29491 40
161884 214154 1 91 495 Pacheco St 1 Sidewalk: Curb side : Yard Tree 2     4 Width 6ft   5993534.5206 2101855.05369 37.750922027151 -122.46521696231 (37.750922027151, -122.46521696231) 1 8 4 29491 40
62891 214155 1 91 495 Pacheco St 2 Sidewalk: Curb side : Yard Tree 2     5 Width 6ft   5993543.01566 2101855.50119 37.7509237457529 -122.46518761832 (37.7509237457529, -122.46518761832) 1 8 4 29491 40
194508 203796 1 91 460 Pacheco St 2 Sidewalk: Curb side : Yard Tree 2     1 Width 6ft   5993728.30174 2101878.83793 37.7509985054805 -122.464548580761 (37.7509985054805, -122.464548580761) 1 8 4 29491 12
119469 214167 1 91 1911 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   5993435.67173 2102452.28847 37.7525561798324 -122.465602172524 (37.7525561798324, -122.465602172524) 1 8 4 29491 12
34168 68064 7 91 1911 09th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/26/1993 12:00:00 AM     Permit Number 31801 5993434.8119843 2102472.74927138 37.7526123103472 -122.465606631992 (37.7526123103472, -122.465606631992) 1 8 4 29491 12
101688 50158 1 91 1863@ ORTEGA 33rd Ave 1 Sidewalk: Curb side : Cutout Tree 2   08/07/2003 12:00:00 AM 4   Permit Number 46871 5985958.4054 2102559.7986 37.7524172606528 -122.491467392102 (37.7524172606528, -122.491467392102) 1 8 3 56 35
92722 37473 7 91 1453 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/26/2002 12:00:00 AM     Permit Number 44951 5992709.117019 2105576.23529487 37.7610917906482 -122.468341951453 (37.7610917906482, -122.468341951453) 1 8 4 56 12
158611 214152 1 91 1414 18th Ave 1 Sidewalk: Curb side : Cutout Tree 2     9 Width 5ft   5990551.39802 2105727.60563 37.7613825499841 -122.47581554727 (37.7613825499841, -122.47581554727) 1 8 4 56 12
61023 46902 7 91 1416 18th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 04/29/2002 12:00:00 AM     Permit Number 44958 5990552.94389775 2105736.96364621 37.7614083342209 -122.47581088419 (37.7614083342209, -122.47581088419) 1 8 4 56 12