trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
148 108238 4 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
197 104920 4 72 750 Gonzalez Dr 1 Median : Yard Tree 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
228 256437 4 15 3001 Sunset Blvd 25 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
230 114428 4 15 34x HIGUERA AVE 2 Median : Yard Tree 2     56     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
408 109629 4 16 200X GELLERT DR 30 Median : Cutout Tree 1       30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
451 114938 4 15 4400x OCEAN AVE 14 Front Yard : Cutout Tree 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
515 262251 4 15 4210 Ocean Ave 4 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
932 111099 4 15 480X LAKESHORE DR 20 Median : Cutout Tree 1       30x200   5984942 2095282 37.7323749444343 -122.494445798495 (37.7323749444343, -122.494445798495) 1 8 4 64 35
1588 260075 4 63 171X Gellert Dr 1 Median : Yard Tree 2       3x3   5985371 2094678 37.7307416178434 -122.492918192866 (37.7307416178434, -122.492918192866) 1 8 4 64 35
1922 260512 4 7 180 Stratford Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5990850 2091280 37.7217304489912 -122.473728831815 (37.7217304489912, -122.473728831815) 9 8 4 64 40
1969 104927 4 72 810 Gonzalez Dr 2 Median : Yard Tree 2     10     5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
2230 256764 4 17 25 Serrano Dr 1 Sidewalk: Property side : Cutout Tree 2   09/25/2019 12:00:00 AM 3 6x6 Permit Number 782398 5990027 2090605 37.7198293671123 -122.476524410241 (37.7198293671123, -122.476524410241) 1 8 4 64 14
2361 256460 4 16 2901 Sunset Blvd 9 Median : Yard Tree 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
3310 175373 4 14 10 Junipero Serra Blvd 2 Sidewalk: Curb side : Yard Tree 2     2 Width 3ft   5991419.90979 2088711.03664 37.714709696259 -122.47157171488 (37.714709696259, -122.47157171488) 9 8 6 64 24
3723 260511 4 7 199X Stratford Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5990954 2091213 37.7215525064104 -122.47336445039 (37.7215525064104, -122.47336445039) 9 8 4 64 40
3790 262255 4 17 4210 Ocean Ave 8 Sidewalk: Property side : Yard Tree 2   11/10/2020 12:00:00 AM 3 3x3 Permit Number 785453 5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
3872 262252 4 15 4210 Ocean Ave 5 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
4197 262260 4 16 2 Everglade Dr 4 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
4569 104897 4 67 303 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4918 104883 4 15 132 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2           5990322.1 2090011.1 37.7182157760013 -122.475461023549 (37.7182157760013, -122.475461023549) 1 8 4 64 14
5714 259658 4 7 239 Stonecrest Dr 1 Sidewalk: Property side : Yard Tree 2       3x3   5990787 2092898 37.7261694250404 -122.474064598028 (37.7261694250404, -122.474064598028) 9 8 4 64 40
6145 117568 4 17 2636 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree 2           5990923 2095039.4 37.7320570487265 -122.473750606168 (37.7320570487265, -122.473750606168) 1 8 4 64 40
6387 114260 4 35 800x BROTHERHOOD WAY 1 Front Yard : Cutout Tree 2     7     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
6708 256455 4 35 2901 Sunset Blvd 4 Median : Yard Tree 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
6775 256471 4 16 2901 Sunset Blvd 15 Median : Yard Tree 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
7536 262249 4 41 4210 Ocean Ave 2 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
8504 109669 4 155 200X GELLERT DR 33 Median : Cutout Tree 1   02/26/2015 01:37:00 PM 3 30x200   5985380 2094516.3 37.730298158605 -122.492875173009 (37.730298158605, -122.492875173009) 1 8 4 64 35
8736 256444 4 325 3001 Sunset Blvd 28 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
8847 110165 4 15 129x GARCES DR 1 Front Yard : Yard Tree 2     23     5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
8859 118364 4 147 226 Monticello St 1 Sidewalk: Curb side : Cutout Tree 2     15 3x3   5991730 2090049 37.7184013526744 -122.470597317131 (37.7184013526744, -122.470597317131) 9 8 6 64 24
9638 254322 4 56 220 Junipero Serra Blvd 3 Median : Cutout Tree 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
9803 262258 4 15 2 Everglade Dr 2 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
10159 262253 4 15 4210 Ocean Ave 6 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
10436 105254 4 16 130 GONZALEZ DR   Front Yard : Yard Tree 2     2     5990327 2090136 37.7185590045312 -122.47545320092 (37.7185590045312, -122.47545320092) 1 8 4 64 14
10808 262250 4 15 4210 Ocean Ave 3 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
11790 254293 4 41 110 Junipero Serra Blvd 5 Median : Yard Tree 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
11878 104919 4 15 732 Gonzalez Dr 1 Sidewalk: Curb side : Yard Tree 2           5990421 2090607 37.719857702396 -122.475162650507 (37.719857702396, -122.475162650507) 1 8 4 64 40
12565 104957 4 28 759 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree 2           5990435 2090585 37.7197981072685 -122.475112652722 (37.7197981072685, -122.475112652722) 1 8 4 64 40
13098 254290 4 41 110 Junipero Serra Blvd 2 Median : Yard Tree 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
13163 255351 4 11 700 Brotherhood Way 32 Sidewalk: Curb side : Cutout Tree 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
13253 260510 4 7 177 Stratford Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5990921 2091320 37.7218443909369 -122.473486322075 (37.7218443909369, -122.473486322075) 9 8 4 64 40
13318 262248 4 41 4210 Ocean Ave 1 Sidewalk: Property side : Yard Tree 2       3x3   5986512 2095174 37.7321701636719 -122.489010079787 (37.7321701636719, -122.489010079787) 1 8 4 64 35
13349 261323 4 9 278 Ramsell St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5993017 2089051 37.7157354224316 -122.466076249864 (37.7157354224316, -122.466076249864) 9 8 6 64 24
15037 262257 4 16 2 Everglade Dr 1 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
15991 262259 4 15 2 Everglade Dr 3 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
18034 255666 4 36 275 Bright St 1 Sidewalk: Curb side : Cutout Tree 2       4x4   5993722 2089019 37.7156882061667 -122.463637144214 (37.7156882061667, -122.463637144214) 9 8 6 64 24
19357 256415 4 382 3001 Sunset Blvd 3 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
19448 254323 4 56 220 Junipero Serra Blvd 4 Median : Cutout Tree 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
19643 105261 4 35 619 GONZALEZ DR   Sidewalk: Curb side : Yard Tree 2     3     5988914.8 2089258.8 37.7160684695332 -122.48027037241 (37.7160684695332, -122.48027037241) 1 8 4 64 14
19806 117422 4 57 50 VERNON ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5992487 2088224 37.7134340885283 -122.467848042178 (37.7134340885283, -122.467848042178) 9 8 6 64 24
21554 256452 4 41 2901 Sunset Blvd 1 Median : Yard Tree 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
21975 107666 4 349 140 STRATFORD DR 1 Front Yard : Yard Tree 2   12/17/2014 12:00:00 AM 3   Permit Number 774157 5990881.4 2091504.3 37.7223481397163 -122.473636645054 (37.7223481397163, -122.473636645054) 9 8 4 64 40
22036 254321 4 56 220 Junipero Serra Blvd 2 Median : Cutout Tree 2       10x10   5991369 2094955 37.731851128725 -122.472202551974 (37.731851128725, -122.472202551974) 1 8 4 64 40
22607 254291 4 15 110 Junipero Serra Blvd 3 Median : Yard Tree 2       3x3   5991396 2095383 37.7330278715114 -122.472140394325 (37.7330278715114, -122.472140394325) 1 8 4 64 40
23474 107219 4 17 100 WINSTON DR 2 Sidewalk: Curb side : Cutout Tree 2   12/14/2015 12:00:00 AM 36   Permit Number 776841 5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
24527 114055 4 41 700X LAKE MERCED BLVD 1 Median : Cutout Tree 2     50     5987837 2092819 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
24901 256416 4 382 3001 Sunset Blvd 4 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
26584 104941 4 15 133X Gonzalez Dr   Sidewalk: Curb side : Yard Tree 2           5990327.80869 2090136.76282 37.718561145924 -122.475450461306 (37.718561145924, -122.475450461306) 1 8 4 64 14
28156 114119 4 15 1200X JUNIPERO SERRA BLVD 12 Sidewalk: Property side : Yard Tree 2     24     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
28555 112249 4 70 133X EUCALYPTUS DR 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5991186 2094598 37.730860304248 -122.472809193365 (37.730860304248, -122.472809193365) 9 8 4 64 40
28773 114213 4 15 230 SERRANO DR 1 Sidewalk: Curb side : Yard Tree 2     60     5988981 2090766 37.7202107101289 -122.480151800691 (37.7202107101289, -122.480151800691) 1 8 4 64 14
28927 105423 4 15 2 GARFIELD ST 1 Sidewalk: Property side : Yard Tree 2   02/28/2014 12:00:00 AM 28 3x20   5993976.6 2090624.3 37.7201106425596 -122.462873531809 (37.7201106425596, -122.462873531809) 9 8 6 64 24
29963 106965 4 27 63 BELLE AVE   Sidewalk: Property side : Yard Tree 2           5991753.8 2086471.1 37.7085786821221 -122.47025464516 (37.7085786821221, -122.47025464516) 9 8 4 64 24
30007 114128 4 41 1200X JUNIPERO SERRA BLVD 21 Sidewalk: Property side : Yard Tree 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
30315 114947 4 70 146 STRATFORD DR 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5990875 2091468 37.7222480982686 -122.473656121456 (37.7222480982686, -122.473656121456) 9 8 4 64 40
30619 114927 4 15 4400x OCEAN AVE 1 Front Yard : Cutout Tree 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
32419 110166 4 15 131x GARCES DR 1 Front Yard : Yard Tree 2     28     5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
32853 99729 4 16 2645 Ocean Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5990840.1 2094977 37.7318809123737 -122.474032655501 (37.7318809123737, -122.474032655501) 1 8 4 64 40
33112 104928 4 72 810 Gonzalez Dr 3 Median : Yard Tree 2     12     5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
33460 115831 4 15 1X JUNIPERO SERRA BLVD OFF RAMP 3 Sidewalk: Curb side : Cutout Tree 2       3x3   5991168 2088425 37.713909732222 -122.472421570074 (37.713909732222, -122.472421570074) 1 8 4 64 14
33801 114265 4 41 800x BROTHERHOOD WAY 6 Front Yard : Cutout Tree 2     26     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
34411 114369 4 253 823 GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree 2     4     5988303 2089566 37.7168763935413 -122.482407513776 (37.7168763935413, -122.482407513776) 1 8 4 64 14
34737 111082 4 28 130 JUNIPERO SERRA BLVD 1 Median : Cutout Tree 2       3x3   5991393 2095322 37.7328602072681 -122.472146321186 (37.7328602072681, -122.472146321186) 1 8 4 64 40
35165 114121 4 15 1200X JUNIPERO SERRA BLVD 14 Sidewalk: Property side : Yard Tree 2     28     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
36199 255343 4 11 700 Brotherhood Way 3 Sidewalk: Curb side : Cutout Tree 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
37079 104885 4 15 134 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
37154 254306 4 41 170 Junipero Serra Blvd 3 Median : Cutout Tree 2       10x10   5991380 2095134 37.732343254282 -122.47217756607 (37.732343254282, -122.47217756607) 1 8 4 64 40
37581 114212 4 15 302 SERRANO DR 1 Sidewalk: Curb side : Yard Tree 2     64     5988825 2090618 37.7197952736455 -122.480680205506 (37.7197952736455, -122.480680205506) 1 8 4 64 14
37718 110162 4 17 123x GARCES DR 2 Front Yard : Yard Tree 2   06/06/2016 12:00:00 AM 3   Permit Number 777996 5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
39547 114133 4 41 1200X JUNIPERO SERRA BLVD 26 Sidewalk: Property side : Yard Tree 2     28     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
39787 255358 4 11 700 Brotherhood Way 39 Sidewalk: Curb side : Cutout Tree 2       3x21   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
40027 255997 4 17 119 Serrano Dr 1 Sidewalk: Curb side : Cutout Tree 2   04/12/2019 12:00:00 AM 3 3x3 Permit Number 782200 5989797 2090440 37.7193629757475 -122.477307378715 (37.7193629757475, -122.477307378715) 1 8 4 64 14
41206 210528 4 62 466 Bright St 1 : Tree 2     17 Width 3ft   5993789.40568 2090279.07412 37.7191519514685 -122.463495553783 (37.7191519514685, -122.463495553783) 9 8 6 64 24
41763 114139 4 35 1200X JUNIPERO SERRA BLVD 34 Sidewalk: Property side : Yard Tree 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
42100 114131 4 41 1200X JUNIPERO SERRA BLVD 24 Sidewalk: Property side : Yard Tree 2     30     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
42366 114061 4 41 700X LAKE MERCED BLVD 7 Median : Cutout Tree 2     52     5987837 2092819 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
42934 114111 4 15 1200X JUNIPERO SERRA BLVD 2 Sidewalk: Property side : Yard Tree 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
43481 107218 4 28 100 WINSTON DR 1 Sidewalk: Curb side : Cutout Tree 2     42     5990934.3 2093194.2 37.7269912477326 -122.473576991848 (37.7269912477326, -122.473576991848) 9 8 4 64 40
43604 114263 4 15 800x BROTHERHOOD WAY 4 Front Yard : Cutout Tree 2     29     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
44421 113145 4 70 150 BROADMOOR DR 2 Sidewalk: Property side : Cutout Tree 2       3x3   5990980 2092843 37.7260295867704 -122.473393404688 (37.7260295867704, -122.473393404688) 9 8 4 64 40
44835 105258 4 15 132 GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree 2     50     5990327 2090136 37.7185590045312 -122.47545320092 (37.7185590045312, -122.47545320092) 1 8 4 64 14
44870 256450 4 15 3001 Sunset Blvd 34 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
44944 115562 4 15 450x JUNIPERO SERRA BLVD 1 Median : Cutout Tree 2     30 3x3   5991387 2094058 37.7293892334347 -122.472074965405 (37.7293892334347, -122.472074965405) 9 8 4 64 40
45230 114939 4 15 4400x OCEAN AVE 15 Front Yard : Cutout Tree 2     36 3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
45738 109978 4 45 75 Escondido Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5986097 2096084.1 37.73464482809 -122.490511739576 (37.73464482809, -122.490511739576) 1 8 3 64 35
46185 256462 4 16 2901 Sunset Blvd 11 Median : Yard Tree 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
46292 104895 4 67 300 Gonzalez Dr   Sidewalk: Curb side : Yard Tree 2           5990401 2090562 37.7197329843514 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
47222 113141 4 17 140 BROADMOOR DR 1 Sidewalk: Property side : Yard Tree 2   11/09/2015 12:00:00 AM   3x10 Permit Number 776484 5990979 2092893 37.7261668163813 -122.473400506865 (37.7261668163813, -122.473400506865) 9 8 4 64 40
47284 111091 4 15 423 GONZALEZ DR 1 Sidewalk: Curb side : Cutout Tree 2   06/04/2015 12:00:00 AM 3 3x3 Permit Number 775595 5989758 2089186 37.715917540265 -122.477350587483 (37.715917540265, -122.477350587483) 1 8 4 64 14
48176 114926 4 15 4400x OCEAN AVE 2 Front Yard : Cutout Tree 2       3x3   5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
48591 114380 4 15 437X SERRANO DR   Sidewalk: Curb side : Cutout Tree 2     48     5988907 2090368 37.7191136019865 -122.480378474397 (37.7191136019865, -122.480378474397) 1 8 4 64 14