trees

Custom SQL query returning 33 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
102820 186362 1 66 1801 Sunset Blvd 29 Sidewalk: Property side : Yard Tree 2     8 Width 0ft   5984819.5753 2102574.8802 37.7523920547151 -122.495406707945 (37.7523920547151, -122.495406707945) 1 8 3 56 35
107863 182676 1 66 1715 24th Ave 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 0ft   5988712.3482 2103638.8826 37.7555406843938 -122.482022959471 (37.7555406843938, -122.482022959471) 1 8 3 56 35
112833 184750 1 66 1301 Sunset Blvd 17 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984665.0089 2106100.6902 37.7620638971415 -122.496201328503 (37.7620638971415, -122.496201328503) 1 8 3 56 35
120528 184752 1 66 1301 Sunset Blvd 20 Sidewalk: Property side : Yard Tree 2     1 Width 0ft   5984700.7025 2106093.8553 37.7620472211463 -122.496077375707 (37.7620472211463, -122.496077375707) 1 8 3 56 35
120610 181577 1 66 1200 Sunset Blvd 59 Sidewalk: Property side : Yard Tree 2     6 Width 0ft   5984846.2035 2106866.5794 37.7641774260073 -122.495631149537 (37.7641774260073, -122.495631149537) 1 8 3 56 35
133233 184755 1 66 1301 Sunset Blvd 25 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984688.1718 2106071.0721 37.7619839309054 -122.496119032944 (37.7619839309054, -122.496119032944) 1 8 3 56 35
133282 186340 1 66 1801 Sunset Blvd 7 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984827.0787 2102831.0491 37.7530958632805 -122.495399651332 (37.7530958632805, -122.495399651332) 1 8 3 56 35
140028 184206 1 66 1484 41st Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   5983432.9268 2105012.9881 37.7590051267749 -122.500382134012 (37.7590051267749, -122.500382134012) 1 8 3 56 35
144873 181567 1 66 1300 Sunset Blvd 62 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984855.7554 2106265.0899 37.7625264639896 -122.495553745896 (37.7625264639896, -122.495553745896) 1 8 3 56 35
150872 184164 1 66 1595 44th Ave 1 Sidewalk: Curb side : Yard Tree 2     1 Width 0ft   5982483.9557 2104274.5677 37.7569218843537 -122.503609385397 (37.7569218843537, -122.503609385397) 1 8 3 56 35
163645 184622 1 66 1778 40th Ave 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   5983811.7777 2103069.4322 37.7536908962098 -122.498928317229 (37.7536908962098, -122.498928317229) 1 8 3 56 35
178506 184756 1 66 1301 Sunset Blvd 29 Sidewalk: Property side : Yard Tree 2     2 Width 0ft   5984687.2225 2106057.4022 37.761946341588 -122.496121307582 (37.761946341588, -122.496121307582) 1 8 3 56 35
183891 186250 1 66 1701 Sunset Blvd 61 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984767.3503 2103112.4152 37.753864919503 -122.495626952484 (37.753864919503, -122.495626952484) 1 8 3 56 35
193173 186364 1 66 1801 Sunset Blvd 31 Sidewalk: Property side : Yard Tree 2     4 Width 0ft   5984815.8043 2102571.1093 37.7523814800587 -122.495419470402 (37.7523814800587, -122.495419470402) 1 8 3 56 35
76533 27143 1 66 1775 Silver Ave 4 Sidewalk: Curb side : Cutout Tree 1     12 2X3   6011388.84182 2095356.57174 37.7340920254878 -122.403017629645 (37.7340920254878, -122.403017629645) 10 3 8 58 1
181787 102268 1 66 100X Casitas Ave 2 Median : Cutout Tree 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
188674 102267 1 66 100X Casitas Ave 1 Median : Cutout Tree 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
187 112917 1 66 480X BEACON ST 1 Sidewalk: Property side : Yard Tree 1           6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
1437 109607 1 66 775 Congo St 1 Front Yard : Yard Landscaping 2           6000381.8 2095947.7 37.7350943222142 -122.441114705419 (37.7350943222142, -122.441114705419) 9 7 4 63 40
7615 258945 1 66 500x 27th St 33 Median : Cutout Tree 1       Width 4ft   6003013.92094 2100069.89733 37.7465624978683 -122.432308835085 (37.7465624978683, -122.432308835085) 2 7 5 63 22
94409 9382 1 66 337 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree 1     0 3X3   6001129.4629101 2097791.8544146 37.7402004981777 -122.438661870607 (37.7402004981777, -122.438661870607) 2 7 5 63 7
124791 22545 1 66 7 Topaz Way 1 Sidewalk: Curb side : Cutout Tree 1     3 2X3   6001395.6747593 2098711.0868843 37.7427396354232 -122.437807240323 (37.7427396354232, -122.437807240323) 2 7 5 63 7
155364 105003 1 66 607 CONGO ST   Sidewalk: Property side : Yard Landscaping 2           6000094.1 2095817 37.7347190590407 -122.44210000591 (37.7347190590407, -122.44210000591) 9 7 4 63 40
161681 4313 1 66 727 Chenery St 1 Sidewalk: Curb side : Cutout Landscaping 1   08/17/2013 12:00:00 AM   3X3   6002321.25178 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497) 2 7 5 63 7
485 251655 1 66 300x Chester Ave 1 Sidewalk: Property side : Yard Tree 1       3x3   5991691 2087193 37.7105572148468 -122.470524229297 (37.7105572148468, -122.470524229297) 9 8 4 64 24
6915 116579 6 66 3000x 19TH AVE 2 Sidewalk: Property side : Cutout Tree 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
20043 116577 6 66 3000x 19TH AVE 1 Sidewalk: Property side : Cutout Tree 3 DPW   30 3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
28607 19363 1 66 738 Shields St 1 Sidewalk: Curb side : Cutout Tree 1     3 3X3   5992103.0127542 2089880.5617979 37.7179604248963 -122.469295726054 (37.7179604248963, -122.469295726054) 9 8 6 64 24
75140 251667 1 66 1090x Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5988120 2094796 37.7312259936493 -122.483423232518 (37.7312259936493, -122.483423232518) 1 8 4 64 35
78880 251666 1 66 76 Denslowe Dr 1 Sidewalk: Property side : Cutout Tree 2       3x3   5990680 2091936 37.7235218144923 -122.474364317808 (37.7235218144923, -122.474364317808) 9 8 4 64 40
123486 99732 1 66 4150 Ocean Ave 1 Sidewalk: Property side : Cutout Landscaping 2           5986619.2 2095203.6 37.7322576937009 -122.488641645288 (37.7322576937009, -122.488641645288) 1 8 4 64 35
127768 30054 1 66 610X Junipero Serra Blvd 7 Median : Cutout Tree 1           5991361.953164 2093442.610307 37.7276980777014 -122.472116715696 (37.7276980777014, -122.472116715696) 9 8 4 64 40
161563 116580 6 66 3000x 19TH AVE 3 Sidewalk: Property side : Cutout Landscaping 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40