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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14751 | 14751 | 108262 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Gould St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6012679.649230001 | 2090646.14976 | 37.7212301687063 | -122.39822450437799 | (37.7212301687063, -122.398224504378) | ||||
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 32599 | 32599 | 84910 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 5546 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2007 12:00:00 AM | 18 | Permit No. 49266 | 5981366.54955 | 2111678.1896 | 37.7771843232036 | -122.50802318732 | (37.7771843232036, -122.50802318732) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 47856 | 47856 | 199568 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 680 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6012064.94705 | 2105270.6603099997 | 37.76135170774529 | -122.401376599377 | (37.7613517077453, -122.401376599377) | ||||
| 48287 | 48287 | 199590 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2150 26th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6012089.24008 | 2101393.99303 | 37.7507085856518 | -122.401020184544 | (37.7507085856518, -122.401020184544) | ||||
| 48709 | 48709 | 202079 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962062996 | -122.398009040306 | (37.721779962063, -122.398009040306) | ||||
| 50723 | 50723 | 199619 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6013984.3244 | 2092869.9258 | 37.727408798052295 | -122.393870163286 | (37.7274087980523, -122.393870163286) | ||||
| 51800 | 51800 | 74618 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2650 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1993 12:00:00 AM | 2 | 5995104.27879 | 2110288.95981 | 37.7741697532931 | -122.460399659179 | (37.7741697532931, -122.460399659179) | ||
| 53423 | 53423 | 199532 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1098 19th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6014487.32888 | 2105297.7815 | 37.761561033046604 | -122.393000428053 | (37.7615610330466, -122.393000428053) | ||||
| 55352 | 55352 | 244013 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 502 28th St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 46 | 6002533.73614 | 2099484.81655 | 37.7449287642466 | -122.43392744661001 | (37.7449287642466, -122.43392744661) | ||||
| 56464 | 56464 | 246783 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 175 Brewster St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6010050.00115 | 2098693.85293 | 37.7431806261 | -122.407881696082 | (37.7431806261, -122.407881696082) | ||||
| 57015 | 57015 | 72610 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 25th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/01/1997 12:00:00 AM | 5 | 6014116.81236 | 2101967.79317 | 37.7523970151345 | -122.39404877763201 | (37.7523970151345, -122.394048777632) | ||
| 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) | |||
| 59626 | 59626 | 217506 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 427 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | 5997927.13531 | 2094070.23257 | 37.72979911961961 | -122.449466089413 | (37.7297991196196, -122.449466089413) | ||||
| 60603 | 60603 | 247590 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 800 Tompkins Ave | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6008957.64855 | 2096444.8911599999 | 37.736944252178205 | -122.411499920492 | (37.7369442521782, -122.411499920492) | ||||
| 60978 | 60978 | 78261 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 414 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 50 | 6009735.35322 | 2092462.5528099998 | 37.7260531896995 | -122.408530204426 | (37.7260531896995, -122.408530204426) | ||
| 61040 | 61040 | 199621 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2330 Lane St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6013971.3633 | 2092946.01515 | 37.7276170037228 | -122.39392029420799 | (37.7276170037228, -122.393920294208) | ||||
| 63803 | 63803 | 199614 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1700x Quesada Ave | 53 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6014257.65945 | 2095401.98638 | 37.734376508759496 | -122.39310233021601 | (37.7343765087595, -122.393102330216) | ||||
| 64773 | 64773 | 199615 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1700x Quesada Ave | 56 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6014226.56708 | 2095397.2747900002 | 37.734361844424704 | -122.393209497917 | (37.7343618444247, -122.393209497917) | ||||
| 65838 | 65838 | 74275 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1998 12:00:00 AM | 12 | 6010944.700130001 | 2088154.7138 | 37.714292400951 | -122.40404651475401 | (37.714292400951, -122.404046514754) | ||
| 65915 | 65915 | 199602 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 628 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6013530.55815 | 2104182.03337 | 37.7584442391246 | -122.396231328824 | (37.7584442391246, -122.396231328824) | ||||
| 67603 | 67603 | 181293 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 184 Mount Vernon Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 5998992.1360599995 | 2089349.9308099998 | 37.7168991290824 | -122.44544499658998 | (37.7168991290824, -122.44544499659) | ||||
| 67624 | 67624 | 199601 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 22nd St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6013350.80583 | 2103837.53278 | 37.757488311954 | -122.396828844671 | (37.757488311954, -122.396828844671) | ||||
| 68058 | 68058 | 199525 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1301 Minnesota St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015396.88376 | 2102219.87285 | 37.7531602346611 | -122.389639647178 | (37.7531602346611, -122.389639647178) | ||||
| 68836 | 68836 | 217525 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2 Lobos St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 5996931.31529 | 2088711.9750400002 | 37.7150295887309 | -122.452522199764 | (37.7150295887309, -122.452522199764) | ||||
| 70160 | 70160 | 244009 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 4347 Cesar Chavez St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 46 | 6001613.39375 | 2100265.8497900004 | 37.7470210253004 | -122.43716572632799 | (37.7470210253004, -122.437165726328) | ||||
| 70813 | 70813 | 199550 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 6 | : Yard 23 | Tree 1 | Private 1 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | ||||
| 71157 | 71157 | 217515 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 181 Staples Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998870.21413 | 2093813.7406900001 | 37.7291487568991 | -122.4461873294 | (37.7291487568991, -122.4461873294) | ||||
| 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) | |||
| 72611 | 72611 | 217518 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 124 Marston Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5998600.75769 | 2093225.60072 | 37.727518470385796 | -122.44707655025101 | (37.7275184703858, -122.447076550251) | ||||
| 73192 | 73192 | 243975 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 220 Coso Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6007595.15715 | 2099522.63398 | 37.745318534015496 | -122.416428611787 | (37.7453185340155, -122.416428611787) | ||||
| 74483 | 74483 | 243979 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6004594.177069999 | 2096179.3802599998 | 37.735969501297 | -122.42656749031099 | (37.735969501297, -122.426567490311) | ||||
| 74843 | 74843 | 246640 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3350 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009029.3215 | 2099227.55373 | 37.744588855582 | -122.411448646563 | (37.744588855582, -122.411448646563) | ||||
| 75392 | 75392 | 199543 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6014244.475740001 | 2106692.1743099997 | 37.765376237735204 | -122.393937976682 | (37.7653762377352, -122.393937976682) | ||||
| 75698 | 75698 | 217493 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1501 15th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5991534.00074 | 2105121.21234 | 37.7597744749213 | -122.472372960446 | (37.7597744749213, -122.472372960446) | ||||
| 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) | ||
| 76538 | 76538 | 199553 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 9 | : Yard 23 | Tree 1 | Private 1 | 20 | 6014424.93308 | 2105923.01259 | 37.7632743152759 | -122.393259984074 | (37.7632743152759, -122.393259984074) | ||||
| 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) | ||
| 121246 | 121246 | 199538 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014323.6703699995 | 2106494.67035 | 37.7648383361526 | -122.39365023409401 | (37.7648383361526, -122.393650234094) | ||||
| 122228 | 122228 | 217516 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 124 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998607.55261 | 2093227.9967099999 | 37.727525437439205 | -122.44705323261499 | (37.7275254374392, -122.447053232615) | ||||
| 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) | |
| 129601 | 129601 | 199524 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1350 Indiana St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | 6015069.09228 | 2102280.3688 | 37.7533081623518 | -122.390777452343 | (37.7533081623518, -122.390777452343) | ||||
| 131815 | 131815 | 199577 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1300x De Haro St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 6012278.401269999 | 2102219.77174 | 37.7529865450046 | -122.400424041944 | (37.7529865450046, -122.400424041944) | ||||
| 133167 | 133167 | 243995 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 483 Valley St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6002806.732009999 | 2099162.00018 | 37.7440578742739 | -122.432960419114 | (37.7440578742739, -122.432960419114) | ||||
| 133882 | 133882 | 202077 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 Gould St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012700.16365 | 2090713.41208 | 37.721416000129 | -122.398158307957 | (37.721416000129, -122.398158307957) | ||||
| 134025 | 134025 | 243976 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1201 San Jose Ave | 70 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004556.64322 | 2096143.57753 | 37.735869073092395 | -122.426694711107 | (37.7358690730924, -122.426694711107) | ||||
| 134169 | 134169 | 243996 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 483 Valley St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6002809.94275 | 2099165.62414 | 37.7440680069386 | -122.432949575959 | (37.7440680069386, -122.432949575959) | ||||
| 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) | |
| 134706 | 134706 | 199544 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014223.58604 | 2106699.16409 | 37.7653942691555 | -122.394010719216 | (37.7653942691555, -122.394010719216) | ||||
| 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) | |
| 136614 | 136614 | 199597 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1400 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 65 | 6012249.4280199995 | 2101848.61895 | 37.7519658243772 | -122.40049816857099 | (37.7519658243772, -122.400498168571) | ||||
| 137043 | 137043 | 199617 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1670 Armstrong Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6013996.30242 | 2092813.5629900002 | 37.7272547028171 | -122.39382481138 | (37.7272547028171, -122.39382481138) | ||||
| 137404 | 137404 | 199620 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 2399 Lane St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6013988.45481 | 2092875.57425 | 37.7274245370974 | -122.393856279557 | (37.7274245370974, -122.393856279557) | ||||
| 138125 | 138125 | 199573 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1399 De Haro St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | 6012315.17384 | 2101950.7126 | 37.7522498176817 | -122.400277978566 | (37.7522498176817, -122.400277978566) | ||||
| 138227 | 138227 | 199545 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 1 | : Yard 23 | Tree 1 | Private 1 | 12 | 6014356.43896 | 2105915.99545 | 37.7632512422621 | -122.39349639336099 | (37.7632512422621, -122.393496393361) | ||||
| 138309 | 138309 | 119670 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 699x Missouri St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 139126 | 139126 | 199549 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 5 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014392.26095 | 2105920.87265 | 37.7632666242892 | -122.39337283731399 | (37.7632666242892, -122.393372837314) | ||||
| 147049 | 147049 | 79999 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 8250 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2002 12:00:00 AM | 3 | 5981389.70051 | 2112378.3 | 37.7791079835189 | -122.50799507452 | (37.7791079835189, -122.50799507452) | ||
| 147276 | 147276 | 199622 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1799 Revere Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6014049.74697 | 2095137.7108200002 | 37.733639310212396 | -122.393802664676 | (37.7336393102124, -122.393802664676) | ||||
| 148175 | 148175 | 199603 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 628 Missouri St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 6013523.6449 | 2104171.29494 | 37.7584143690574 | -122.39625448547501 | (37.7584143690574, -122.396254485475) | ||||
| 150454 | 150454 | 199572 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1399 De Haro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 6012303.844380001 | 2101937.88969 | 37.752213976998895 | -122.400316257304 | (37.7522139769989, -122.400316257304) | ||||
| 151769 | 151769 | 250140 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 2550x Lyon St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | 5999207.82154 | 2117620.0573299997 | 37.7945342406205 | -122.446732429154 | (37.7945342406205, -122.446732429154) | ||||
| 152029 | 152029 | 199584 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 889 Vermont St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6011329.43673 | 2104204.01823 | 37.7583818819269 | -122.40384537598699 | (37.7583818819269, -122.403845375987) | ||||
| 152195 | 152195 | 199588 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 875 Vermont St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6011303.70153 | 2104278.0888400003 | 37.75858382559029 | -122.403939592556 | (37.7585838255903, -122.403939592556) | ||||
| 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) | |
| 153067 | 153067 | 199571 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1399 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | 6012297.36216 | 2101934.2505 | 37.75220362310421 | -122.400338418383 | (37.7522036231042, -122.400338418383) | ||||
| 153276 | 153276 | 199557 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1 01st St | 18 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014448.03527 | 2105905.59327 | 37.7632277690557 | -122.393178861636 | (37.7632277690557, -122.393178861636) | ||||
| 155193 | 155193 | 243974 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 220 Coso Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6007544.45686 | 2099548.29836 | 37.7453861513651 | -122.41660574318199 | (37.7453861513651, -122.416605743182) | ||||
| 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) | ||
| 155371 | 155371 | 199533 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 101 Pennsylvania Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6014329.6983 | 2106362.34828 | 37.76447534369329 | -122.393620122984 | (37.7644753436933, -122.393620122984) |
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");