Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21110 | 21110 | 4447 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1361 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6004544.06336 | 2100936.2409900003 | 37.7490279200058 | -122.42707946086 | (37.7490279200058, -122.42707946086) | |||
| 25369 | 25369 | 43795 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 787 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43425 | 5989119.53165 | 2109999.14868 | 37.773027918987104 | -122.48108049667499 | (37.7730279189871, -122.481080496675) | |
| 30315 | 30315 | 32956 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1218 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 12 | 3x8 | Permit Number 37270 | 6013588.683209999 | 2106187.45016 | 37.763953908676896 | -122.39617085120301 | (37.7639539086769, -122.396170851203) |
| 36007 | 36007 | 38374 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 3805 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1998 12:00:00 AM | 5 | Permit Number 40433 | 5982188.1991 | 2102815.1083 | 37.7528972278417 | -122.504524079724 | (37.7528972278417, -122.504524079724) | |
| 38187 | 38187 | 51651 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 570 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | 16 | Permit Number 47934 | 5982889.2977 | 2111913.98983 | 37.7779213685412 | -122.502773063589 | (37.7779213685412, -122.502773063589) | ||
| 42362 | 42362 | 61510 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1237 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 23 | Permit Number 21466 | 6012274.20726 | 2102601.29078 | 37.754033879279 | -122.40046534240601 | (37.754033879279, -122.400465342406) | |
| 42825 | 42825 | 55063 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 599X 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 4 | Permit Number 10952 | 5982538.31905 | 2111794.35525 | 37.7775722542249 | -122.50397833859199 | (37.7775722542249, -122.503978338592) | ||
| 59061 | 59061 | 106254 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1900X 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 770844 | 6011963.420530001 | 2105634.8239700003 | 37.76234595501379 | -122.40175333704599 | (37.7623459550138, -122.401753337046) | |||
| 59468 | 59468 | 98817 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6011799.60927 | 2099715.83427 | 37.7460845639436 | -122.401903804432 | (37.7460845639436, -122.401903804432) | |||
| 71444 | 71444 | 45455 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 258 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Permit Number 44240 | 5997038.9938 | 2112669.4435 | 37.780817044183294 | -122.453879118533 | (37.7808170441833, -122.453879118533) | |||
| 75856 | 75856 | 57578 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1900X 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/1976 12:00:00 AM | 20 | Permit Number 16445 | 6012021.89492 | 2105637.6019900003 | 37.762356845824705 | -122.401551289982 | (37.7623568458247, -122.401551289982) | ||
| 76996 | 76996 | 37145 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 755 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1998 12:00:00 AM | 4 | Permit Number 39727 | 5981030.6614 | 2110569.17364 | 37.7741194954723 | -122.50910273769199 | (37.7741194954723, -122.509102737692) | ||
| 90674 | 90674 | 47490 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 99X LYELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 2 | 3x3 | Permit Number 45384 | 6003192.0 | 2094433.0 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | |
| 115946 | 115946 | 98813 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 6011920.40954 | 2099763.4920200002 | 37.7462221629395 | -122.40148943908702 | (37.7462221629395, -122.401489439087) | |||
| 123412 | 123412 | 38815 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 204 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1998 12:00:00 AM | 8 | Permit Number 40651 | 5994944.16478 | 2114141.25002 | 37.78473790153421 | -122.461232820546 | (37.7847379015342, -122.461232820546) | |
| 134615 | 134615 | 46635 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1571 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 3 | Permit Number 44756 | 6014716.9997 | 2093587.5042 | 37.729419814580105 | -122.39138742541799 | (37.7294198145801, -122.391387425418) | |
| 135295 | 135295 | 61786 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1453 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1985 12:00:00 AM | 5 | Permit Number 21808 | 6012048.53726 | 2101599.7362 | 37.7512712410927 | -122.40117539492701 | (37.7512712410927, -122.401175394927) | |
| 152241 | 152241 | 30689 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 529 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 12 | Permit Number 34609 | 6004554.59281 | 2110367.64108 | 37.7749248947896 | -122.427714942511 | (37.7749248947896, -122.427714942511) | |
| 153004 | 153004 | 98814 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6011900.23089 | 2099755.59596 | 37.7461993561215 | -122.401558659925 | (37.7461993561215, -122.401558659925) | |||
| 155215 | 155215 | 65394 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 290 Napoleon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/1989 12:00:00 AM | 53 | Permit Number 28237 | 6011952.10102 | 2099776.9681 | 37.746260933607104 | -122.401380800085 | (37.7462609336071, -122.401380800085) | ||
| 163577 | 163577 | 92398 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1919 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52800 | 6012329.06895 | 2103729.7014200003 | 37.757135307361295 | -122.400354868801 | (37.7571353073613, -122.400354868801) | |
| 163841 | 163841 | 57583 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 2001 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1976 12:00:00 AM | 31 | Permit Number 16451 | 6011409.07768 | 2106483.20737 | 37.764644474674 | -122.403730310432 | (37.764644474674, -122.403730310432) | ||
| 167849 | 167849 | 104212 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 1117 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 6012239.80468 | 2103199.03133 | 37.7556732255654 | -122.400626303066 | (37.7556732255654, -122.400626303066) | ||||
| 181985 | 181985 | 47839 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 4400 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 8 | Permit Number 45601 | 5981941.89951 | 2110334.18546 | 37.7735279659603 | -122.50593323432501 | (37.7735279659603, -122.505933234325) | |
| 188262 | 188262 | 32743 | Permitted Site 1 | Yucca gloriosa :: Spanish Dagger 224 | 31 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37126 | 5996349.198890001 | 2089288.18101 | 37.7165783462864 | -122.454575832225 | (37.7165783462864, -122.454575832225) |
| 4383 | 4383 | 253609 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 318 Utah St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 4ft | Permit Number 780845 | 6010580.39617 | 2106780.39752 | 37.7654141639451 | -122.40661745795299 | (37.7654141639451, -122.406617457953) | |||
| 22917 | 22917 | 137507 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1920 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 6ft | 6001011.3931599995 | 2121024.3810099997 | 37.803984475874294 | -122.44073617154801 | (37.8039844758743, -122.440736171548) | |||
| 24078 | 24078 | 243993 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 479 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003506.23365 | 2098907.96472 | 37.7434000031111 | -122.43052357739599 | (37.7434000031111, -122.430523577396) | |||
| 24210 | 24210 | 243997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 483 Valley St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6002856.13849 | 2099166.37305 | 37.7440726834043 | -122.432789895044 | (37.7440726834043, -122.432789895044) | ||||
| 24256 | 24256 | 119131 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 543 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | Width 3ft | 5981597.43697 | 2112021.89729 | 37.778141644974 | -122.50724999386298 | (37.778141644974, -122.507249993863) | |||
| 25761 | 25761 | 217537 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 89 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 18 | 5992163.635980001 | 2088434.33055 | 37.713992927605204 | -122.468980989298 | (37.7139929276052, -122.468980989298) | ||||
| 26021 | 26021 | 137509 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 85 Toledo Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.48208 | 2119936.52079 | 37.801023121670106 | -122.439100597914 | (37.8010231216701, -122.439100597914) | |||
| 26033 | 26033 | 246779 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 398 Franconia St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6009874.45509 | 2098802.1456299997 | 37.74346814475479 | -122.408496327841 | (37.7434681447548, -122.408496327841) | |||
| 26561 | 26561 | 79997 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 6 | 5981344.9471 | 2112403.2124900003 | 37.7791737487824 | -122.50815174160499 | (37.7791737487824, -122.508151741605) | ||
| 26773 | 26773 | 137516 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8 Kimball Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6007999.84688 | 2116492.3826 | 37.7919362386146 | -122.41623092103998 | (37.7919362386146, -122.41623092104) | |||
| 27760 | 27760 | 181308 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 36 Ramsell St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5992982.57261 | 2087488.7140000002 | 37.711443773193395 | -122.466081784571 | (37.7114437731934, -122.466081784571) | |||
| 27778 | 27778 | 199535 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6014327.91583 | 2106402.88098 | 37.7645865385638 | -122.393629125195 | (37.7645865385638, -122.393629125195) | ||||
| 27786 | 27786 | 243964 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 979 San Bruno Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6011092.59342 | 2103787.62329 | 37.7572253196086 | -122.40463517678002 | (37.7572253196086, -122.40463517678) | |||
| 28230 | 28230 | 243963 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3450 26th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6006727.57204 | 2100887.26512 | 37.7490166748846 | -122.419525382284 | (37.7490166748846, -122.419525382284) | |||
| 28405 | 28405 | 199554 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 10 | : Yard 23 | Tree 1 | Private 1 | 17 | 6014431.6868199995 | 2105923.15598 | 37.763275084200295 | -122.39323663496599 | (37.7632750842003, -122.393236634966) | ||||
| 29138 | 29138 | 120087 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 401 26th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5987764.76806 | 2113165.6978700003 | 37.7816435236065 | -122.48599921215299 | (37.7816435236065, -122.485999212153) | |||
| 29233 | 29233 | 243983 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 23 Juri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 1ft | 6005990.8298 | 2101226.6861 | 37.749907121539 | -122.42209715557699 | (37.749907121539, -122.422097155577) | |||
| 29361 | 29361 | 246743 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 140 Ripley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6008904.95931 | 2099075.9410099997 | 37.7441655842699 | -122.411867956365 | (37.7441655842699, -122.411867956365) | ||||
| 30342 | 30342 | 199587 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 875 Vermont St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6011307.0012300005 | 2104284.0502 | 37.7586003785102 | -122.40392860014099 | (37.7586003785102, -122.403928600141) | ||||
| 30692 | 30692 | 243988 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2766 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010155.451669999 | 2102831.44612 | 37.754547449722 | -122.407808770075 | (37.754547449722, -122.407808770075) | |||
| 31668 | 31668 | 202074 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012682.24985 | 2090663.29707 | 37.721277396617204 | -122.39821671715099 | (37.7212773966172, -122.398216717151) | ||||
| 31713 | 31713 | 217509 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 100 Gennessee St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 1ft | 5997469.91402 | 2093889.3478299999 | 37.729276287058795 | -122.45103370846 | (37.7292762870588, -122.45103370846) | |||
| 32132 | 32132 | 199530 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1091 19th St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6014489.75504 | 2105264.07428 | 37.7614686151109 | -122.39298967844499 | (37.7614686151109, -122.392989678445) | ||||
| 32324 | 32324 | 199585 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 875 Vermont St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 8ft | 6011335.71651 | 2104267.18906 | 37.7585556858141 | -122.4038281027 | (37.7585556858141, -122.4038281027) | |||
| 32691 | 32691 | 199592 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1453 Rhode Island St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6012056.44689 | 2101608.80688 | 37.751296588469295 | -122.40114867968799 | (37.7512965884693, -122.401148679688) | ||||
| 32746 | 32746 | 243960 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1485 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009591.25577 | 2100642.20365 | 37.7485046755637 | -122.40960540867201 | (37.7485046755637, -122.409605408672) | |||
| 32831 | 32831 | 243980 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 79 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6004603.12758 | 2096184.7977099998 | 37.7359848823907 | -122.426536930441 | (37.7359848823907, -122.426536930441) | ||||
| 33116 | 33116 | 137510 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 85 Toledo Way | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6001467.72221 | 2119937.0331200003 | 37.8010248834562 | -122.439079041178 | (37.8010248834562, -122.439079041178) | |||
| 33613 | 33613 | 181300 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Nueva Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | Width 4ft | 6013063.40285 | 2087533.07945 | 37.712703665812796 | -122.39667984502199 | (37.7127036658128, -122.396679845022) | |||
| 33825 | 33825 | 199536 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014326.65854 | 2106427.7746900003 | 37.7646548213741 | -122.3936352163 | (37.7646548213741, -122.3936352163) | ||||
| 33831 | 33831 | 201522 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 863 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6019436.4693599995 | 2094253.9637900002 | 37.7315105906351 | -122.375117750879 | (37.7315105906351, -122.375117750879) | |||
| 34196 | 34196 | 217490 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1219 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5991058.25824 | 2105170.14194 | 37.759881276613 | -122.47402187283501 | (37.759881276613, -122.474021872835) | |||
| 34569 | 34569 | 183314 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1298 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981216.5568 | 2106353.9637 | 37.7625567133131 | -122.50814677987101 | (37.7625567133131, -122.508146779871) | |||
| 34720 | 34720 | 244002 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1351 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 6ft | 6001401.78652 | 2099724.90862 | 37.7455236981732 | -122.437858706115 | (37.7455236981732, -122.437858706115) | |||
| 34809 | 34809 | 74063 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 12 | 6010946.7362 | 2088147.19919 | 37.714271881112296 | -122.404038948741 | (37.7142718811123, -122.404038948741) | ||
| 35089 | 35089 | 243978 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004588.46206 | 2096170.32088 | 37.7359443031923 | -122.42658660449601 | (37.7359443031923, -122.426586604496) | ||||
| 35129 | 35129 | 118620 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 498 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5981322.23843 | 2112396.05597 | 37.7791527609309 | -122.50822976748199 | (37.7791527609309, -122.508229767482) | |||
| 35442 | 35442 | 202076 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | ||||
| 36308 | 36308 | 183492 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2526 32nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986467.5023 | 2098045.3062 | 37.7400514152255 | -122.489374961874 | (37.7400514152255, -122.489374961874) | |||
| 36380 | 36380 | 243977 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 74 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6004578.54944 | 2096162.87225 | 37.73592329053071 | -122.426620346145 | (37.7359232905307, -122.426620346145) | ||||
| 36612 | 36612 | 181295 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 286 Foote Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5998268.1836 | 2088765.30253 | 37.7152525189681 | -122.447905270113 | (37.7152525189681, -122.447905270113) | |||
| 37627 | 37627 | 199566 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1512 25th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 9ft | 6014108.69485 | 2102017.7502599997 | 37.7525337354666 | -122.39408034653799 | (37.7525337354666, -122.394080346538) | |||
| 38015 | 38015 | 199539 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014306.32543 | 2106588.22491 | 37.765094252633205 | -122.393716774935 | (37.7650942526332, -122.393716774935) | ||||
| 38622 | 38622 | 199534 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6014328.93233 | 2106372.73104 | 37.7645038099161 | -122.393623499025 | (37.7645038099161, -122.393623499025) | ||||
| 38630 | 38630 | 217501 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 502 Edna St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 4ft | 5998794.71399 | 2094416.16661 | 37.73079856498921 | -122.44649166176501 | (37.7307985649892, -122.446491661765) | |||
| 38976 | 38976 | 199555 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 15 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014446.64039 | 2105914.6589900004 | 37.763252584054605 | -122.393184320496 | (37.7632525840546, -122.393184320496) | ||||
| 39448 | 39448 | 199541 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014267.9908 | 2106682.1532 | 37.7653500288033 | -122.39385594139799 | (37.7653500288033, -122.393855941398) | ||||
| 39809 | 39809 | 199605 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 651 Missouri St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6013602.02772 | 2104054.17781 | 37.758097152080204 | -122.395975193824 | (37.7580971520802, -122.395975193824) | ||||
| 40458 | 40458 | 117951 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4101 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5982854.39017 | 2110311.68646 | 37.7735198584795 | -122.50277518090799 | (37.7735198584795, -122.502775180908) | |||
| 40924 | 40924 | 217538 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2 Castenada Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994399.3644900005 | 2101801.93145 | 37.750826002039105 | -122.46222241953998 | (37.7508260020391, -122.46222241954) | |||
| 41043 | 41043 | 199551 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 7 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014408.59689 | 2105921.94262 | 37.7632704697891 | -122.39331641112899 | (37.7632704697891, -122.393316411129) | ||||
| 41169 | 41169 | 117777 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 7414 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 3ft | 5983996.528940001 | 2112514.84276 | 37.7796361445772 | -122.498987225205 | (37.7796361445772, -122.498987225205) | |||
| 41508 | 41508 | 181289 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1705 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 4ft | 5998212.96577 | 2088739.68043 | 37.715179010179 | -122.448094282435 | (37.715179010179, -122.448094282435) | |||
| 41541 | 41541 | 199595 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1441 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6012041.40362 | 2101659.26991 | 37.75143430974789 | -122.40120424698699 | (37.7514343097479, -122.401204246987) | ||||
| 41947 | 41947 | 243965 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 60 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 73 | Width 5ft | 6005189.67155 | 2107490.26222 | 37.7670602101766 | -122.42531326790501 | (37.7670602101766, -122.425313267905) | |||
| 41970 | 41970 | 137512 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3801 Webster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6002485.01335 | 2121661.73834 | 37.8058183005296 | -122.435682245137 | (37.8058183005296, -122.435682245137) | |||
| 42051 | 42051 | 217536 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 374 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 5993512.184780001 | 2088326.6424900002 | 37.7137750659299 | -122.464312118436 | (37.7137750659299, -122.464312118436) | |||
| 42086 | 42086 | 199542 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6014252.51342 | 2106695.17949 | 37.7653849359952 | -122.39391038637899 | (37.7653849359952, -122.393910386379) | ||||
| 42615 | 42615 | 184630 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1811 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5982223.7334 | 2102787.8653 | 37.752824516298496 | -122.50439917945499 | (37.7528245162985, -122.504399179455) | |||
| 42798 | 42798 | 137514 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3633 Webster St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002566.08313 | 2121090.5065099997 | 37.8042544532535 | -122.435360804076 | (37.8042544532535, -122.435360804076) | |||
| 43268 | 43268 | 199562 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 601 Wisconsin St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 6012719.76904 | 2104617.31298 | 37.75959427326811 | -122.399065969425 | (37.7595942732681, -122.399065969425) | |||
| 43540 | 43540 | 243971 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 336 Elsie St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6006473.44341 | 2097229.56707 | 37.7389591427554 | -122.420144611411 | (37.7389591427554, -122.420144611411) | |||
| 43575 | 43575 | 199537 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014323.98726 | 2106464.8847 | 37.764756568894796 | -122.393647053167 | (37.7647565688948, -122.393647053167) | ||||
| 43779 | 43779 | 182636 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1634 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988875.299 | 2102432.4985 | 37.7522377520489 | -122.481371089356 | (37.7522377520489, -122.481371089356) | |||
| 43912 | 43912 | 243991 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 285 Mullen Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6010375.28221 | 2100026.3760599997 | 37.7468576499657 | -122.40685084911199 | (37.7468576499657, -122.406850849112) | |||
| 45001 | 45001 | 243990 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3250 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008996.81508 | 2099767.79019 | 37.7460704023351 | -122.41159921015199 | (37.7460704023351, -122.411599210152) | |||
| 45295 | 45295 | 181298 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 538 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002983.65718 | 2090496.16604 | 37.7202734951152 | -122.43173005392 | (37.7202734951152, -122.43173005392) | |||
| 45620 | 45620 | 117833 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 822 39th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5983882.02568 | 2110188.1448 | 37.7732409879174 | -122.49921136383699 | (37.7732409879174, -122.499211363837) | |||
| 45652 | 45652 | 243986 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 922 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 6008569.4058300005 | 2103127.50468 | 37.755271440832296 | -122.413314689443 | (37.7552714408323, -122.413314689443) | |||
| 45987 | 45987 | 199565 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 25th St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6014128.38291 | 2101966.7218 | 37.7523947164539 | -122.39400868947399 | (37.7523947164539, -122.394008689474) | ||||
| 46449 | 46449 | 199558 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 265 Arkansas St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 2ft | 6012944.07027 | 2105820.99329 | 37.7629118111405 | -122.39837467586099 | (37.7629118111405, -122.398374675861) | |||
| 46657 | 46657 | 184419 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3715 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5981926.4298 | 2100773.5787 | 37.7472763594104 | -122.50527801414302 | (37.7472763594104, -122.505278014143) | |||
| 46784 | 46784 | 182104 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2434 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987687.8918 | 2098712.0823 | 37.7419533724178 | -122.485204320572 | (37.7419533724178, -122.485204320572) | |||
| 46921 | 46921 | 217492 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1211 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5991111.7446099995 | 2105172.65449 | 37.7598912734774 | -122.47383707471799 | (37.7598912734774, -122.473837074718) | |||
| 46972 | 46972 | 199526 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 599 Indiana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6014906.748980001 | 2105806.13827 | 37.7629801596351 | -122.39158535649901 | (37.7629801596351, -122.391585356499) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");