Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38028 | 38028 | 204732 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Junipero Serra Blvd | 92 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991226.61275 | 2092125.57221 | 37.7240739859998 | -122.472488607886 | (37.7240739859998, -122.472488607886) | |||
| 43676 | 43676 | 204727 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 38 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991391.65527 | 2094396.58957 | 37.73031918497 | -122.47208354153798 | (37.73031918497, -122.472083541538) | |||
| 44277 | 44277 | 188414 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 602 Arthur Ave | 36 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6015677.9579 | 2099872.41216 | 37.746730180067395 | -122.388503787217 | (37.7467301800674, -122.388503787217) | ||||
| 129974 | 129974 | 222689 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 33 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | Width 10ft | 6006609.95498 | 2098107.9290400003 | 37.7413786194175 | -122.419734923451 | (37.7413786194175, -122.419734923451) | |||
| 135308 | 135308 | 204726 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 30 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991392.43358 | 2094433.51883 | 37.7304206284982 | -122.472083541544 | (37.7304206284982, -122.472083541544) | |||
| 170450 | 170450 | 204725 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 29 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991390.23736 | 2094439.33755 | 37.730436478151496 | -122.47209155807501 | (37.7304364781515, -122.472091558075) | |||
| 162790 | 162790 | 222684 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1100 San Jose Ave | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004829.85448 | 2096667.61167 | 37.7373233955514 | -122.42578739946501 | (37.7373233955514, -122.425787399465) | ||||
| 65950 | 65950 | 222683 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1100 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6004834.7029800005 | 2096673.11166 | 37.7373387712724 | -122.425771027308 | (37.7373387712724, -122.425771027308) | ||||
| 68906 | 68906 | 204731 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 25 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991352.35851 | 2093912.8371599999 | 37.728988647895 | -122.472184145999 | (37.728988647895, -122.472184145999) | |||
| 173848 | 173848 | 188410 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1501 22nd St | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6013292.91596 | 2103788.2689099996 | 37.7573498217412 | -122.397025598364 | (37.7573498217412, -122.397025598364) | ||||
| 170368 | 170368 | 204724 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 21 | : 4 | Tree 1 | Private 1 | 8 | Width 0ft | 5991391.18592 | 2094484.3447599998 | 37.730560111554496 | -122.47209155808999 | (37.7305601115545, -122.47209155809) | |||
| 72067 | 72067 | 204730 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 20 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991365.099780001 | 2094040.0062400002 | 37.7293385597172 | -122.472149364714 | (37.7293385597172, -122.472149364714) | |||
| 172205 | 172205 | 222688 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6006604.22222 | 2098080.62198 | 37.741303317398206 | -122.419752808255 | (37.7413033173982, -122.419752808255) | ||||
| 136961 | 136961 | 205922 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 370 Monterey Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999640.50046 | 2094726.6696 | 37.7316994068856 | -122.443589949734 | (37.7316994068856, -122.443589949734) | |||
| 166591 | 166591 | 222687 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 200 Eugenia Ave | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6006597.39234 | 2098081.5973 | 37.741305610657 | -122.419776492811 | (37.741305610657, -122.419776492811) | ||||
| 28752 | 28752 | 222686 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1201 San Jose Ave | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6004284.84781 | 2095906.59844 | 37.735203011805204 | -122.427617536921 | (37.7352030118052, -122.427617536921) | ||||
| 127057 | 127057 | 116678 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Esmeralda Ave | 17 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 19241 | 19241 | 116677 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 188538 | 188538 | 204729 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 16 | : 4 | Tree 1 | Private 1 | 1 | Width 0ft | 5991368.5463 | 2094108.06034 | 37.729525618690204 | -122.47214240847 | (37.7295256186902, -122.47214240847) | |||
| 115834 | 115834 | 246707 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1 Bonview St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6007720.78655 | 2099148.69396 | 37.744298842209 | -122.415967729029 | (37.744298842209, -122.415967729029) | ||||
| 129739 | 129739 | 204728 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Junipero Serra Blvd | 13 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991366.51565 | 2094145.3724 | 37.729627950748295 | -122.47215214722401 | (37.7296279507483, -122.472152147224) | |||
| 133308 | 133308 | 222682 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2 Trainor St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008292.2753800005 | 2108046.95875 | 37.768763565716704 | -122.41462120290501 | (37.7687635657167, -122.414621202905) | |||
| 154057 | 154057 | 204723 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 300 Junipero Serra Blvd | 12 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5991397.3981 | 2094531.5501400002 | 37.7306900851772 | -122.47207352129801 | (37.7306900851772, -122.472073521298) | |||
| 61378 | 61378 | 204745 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 370 Monterey Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999685.08818 | 2094723.93815 | 37.731694449820296 | -122.44343560538799 | (37.7316944498203, -122.443435605388) | |||
| 145383 | 145383 | 37308 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 77695 | 77695 | 42820 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/29/2000 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 91704 | 91704 | 188404 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012258.41015 | 2102196.39231 | 37.7529212353325 | -122.40049153337401 | (37.7529212353325, -122.400491533374) | ||||
| 92997 | 92997 | 37307 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 99854 | 99854 | 37306 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 123571 | 123571 | 42821 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 171476 | 171476 | 188405 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012256.82794 | 2102204.54617 | 37.752943535820606 | -122.400497577699 | (37.7529435358206, -122.400497577699) | ||||
| 63474 | 63474 | 175799 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1500 San Jose Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6001536.44317 | 2094235.33238 | 37.7304582561421 | -122.43700014314 | (37.7304582561421, -122.43700014314) | |||
| 102378 | 102378 | 42822 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 109912 | 109912 | 37301 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 17688 | 17688 | 29574 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 3X3 | 5991374.696380001 | 2094208.91815 | 37.729802904883 | -122.472128495928 | (37.729802904883, -122.472128495928) | |||
| 34874 | 34874 | 175804 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 500x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6010489.90873 | 2090338.0061700002 | 37.72026185429429 | -122.40577215548402 | (37.7202618542943, -122.405772155484) | |||
| 44937 | 44937 | 222679 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 8ft | 6005046.9751 | 2104064.76222 | 37.7576465368663 | -122.425563014118 | (37.7576465368663, -122.425563014118) | |||
| 88809 | 88809 | 37303 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 109961 | 109961 | 22155 | Private 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X FAIRFAX AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3X3 | 6015579.0 | 2098247.0 | 37.74226164995721 | -122.388732527256 | (37.7422616499572, -122.388732527256) | |||
| 141381 | 141381 | 42823 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 56364 | 56364 | 204718 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1485x Northwood Dr | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995836.31697 | 2094012.72029 | 37.7295213774971 | -122.456690081702 | (37.7295213774971, -122.456690081702) | ||||
| 77758 | 77758 | 42824 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 120225 | 120225 | 37305 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 165084 | 165084 | 204743 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 280 Joost Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 7ft | 6000165.05205 | 2094974.5458099998 | 37.732409919872 | -122.441794258103 | (37.732409919872, -122.441794258103) | |||
| 185898 | 185898 | 188406 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 9ft | 6012288.20028 | 2102185.92507 | 37.75289415586 | -122.400387777694 | (37.75289415586, -122.400387777694) | |||
| 2939 | 2939 | 203654 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 42 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001070.39767 | 2095226.13763 | 37.7331522778487 | -122.438682294452 | (37.7331522778487, -122.438682294452) | ||
| 3497 | 3497 | 247942 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 5 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3 | Permit Number 775404 | 6010292.72224 | 2098904.67919 | 37.7437730949632 | -122.40705728398399 | (37.7437730949632, -122.407057283984) | |||
| 17436 | 17436 | 29576 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3X3 | 5991377.92956 | 2094240.4375599998 | 37.7298896363903 | -122.47211961513099 | (37.7298896363903, -122.472119615131) | ||
| 75225 | 75225 | 204717 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1485x Northwood Dr | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995876.20042 | 2094034.0159599998 | 37.7295821401899 | -122.456553740875 | (37.7295821401899, -122.456553740875) | ||||
| 90034 | 90034 | 42692 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2500 Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |||
| 96552 | 96552 | 36068 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39187 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
| 109099 | 109099 | 37281 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | |||
| 120509 | 120509 | 42825 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 125228 | 125228 | 109402 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 136139 | 136139 | 222692 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 York St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009835.7153900005 | 2105907.76012 | 37.7629764094606 | -122.409131567579 | (37.7629764094606, -122.409131567579) | |||
| 139508 | 139508 | 37304 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 165288 | 165288 | 188407 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1300x De Haro St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6012285.79175 | 2102196.41625 | 37.7529228280459 | -122.400396843734 | (37.7529228280459, -122.400396843734) | ||||
| 3465 | 3465 | 39926 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
| 3510 | 3510 | 247941 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.40707457072901 | (37.743786764646, -122.407074570729) | |||
| 24677 | 24677 | 111241 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 745X SANCHEZ ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | ||||
| 54760 | 54760 | 188413 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014027.478680001 | 2105319.8341099997 | 37.7615960301482 | -122.394592417822 | (37.7615960301482, -122.394592417822) | |||
| 69867 | 69867 | 222678 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 749 Dolores St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 6005045.75661 | 2104048.66592 | 37.7576022713581 | -122.425566082603 | (37.7576022713581, -122.425566082603) | |||
| 79996 | 79996 | 96750 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
| 81119 | 81119 | 22153 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | 3X3 | 6015582.155925799 | 2098251.0940713002 | 37.742273066345604 | -122.388721900676 | (37.7422730663456, -122.388721900676) | |||
| 82453 | 82453 | 42828 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2004 12:00:00 AM | Permit Number 42765 | 6006945.227660701 | 2121167.35462349 | 37.8047131790945 | -122.42021185631901 | (37.8047131790945, -122.420211856319) | ||
| 83692 | 83692 | 109401 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 89470 | 89470 | 50387 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 296 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532583998 | 37.75737018369129 | -122.427864268021 | (37.7573701836913, -122.427864268021) | |||
| 97304 | 97304 | 37262 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
| 138640 | 138640 | 37856 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 50 Ina Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | |||
| 141695 | 141695 | 37284 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 700 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39817 | 6003661.86134005 | 2104206.66341524 | 37.7579578025996 | -122.430363425655 | (37.7579578025996, -122.430363425655) | |||
| 142039 | 142039 | 36072 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39187 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
| 143101 | 143101 | 37299 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) | ||
| 148509 | 148509 | 188398 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 501 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6010694.68122 | 2105889.4054 | 37.7629740945886 | -122.406159391868 | (37.7629740945886, -122.406159391868) | |||
| 162264 | 162264 | 187573 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 73 Bishop St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010858.37792 | 2089492.3055900002 | 37.717960332674295 | -122.404438975305 | (37.7179603326743, -122.404438975305) | ||||
| 171726 | 171726 | 204714 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1484 16th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5991182.79274 | 2105342.1880099997 | 37.7603608823676 | -122.473603723127 | (37.7603608823676, -122.473603723127) | |||
| 172403 | 172403 | 204736 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 40 Vasquez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995677.52131 | 2100065.8007099996 | 37.7461325337836 | -122.457676858293 | (37.7461325337836, -122.457676858293) | |||
| 3005 | 3005 | 208852 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 42 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/14/2017 12:00:00 AM | 3 | Width 8ft | 6001113.97001 | 2095223.0116299998 | 37.733146173254205 | -122.43853142959101 | (37.7331461732542, -122.438531429591) | ||
| 3511 | 3511 | 247940 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 3 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010280.31746 | 2098909.2881400003 | 37.7437850559498 | -122.407100501782 | (37.7437850559498, -122.407100501782) | |||
| 8008 | 8008 | 39924 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 0 Arleta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/1999 12:00:00 AM | Permit Number 41198 | ||||||||
| 12503 | 12503 | 93870 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400-422X Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773818 | 6012462.01959 | 2086667.4072599998 | 37.7102932120209 | -122.398697717749 | (37.7102932120209, -122.398697717749) |
| 18455 | 18455 | 51904 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 168 Caselli Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48111 | 6000192.99372442 | 2104905.40226883 | 37.7596792654558 | -122.44241036439301 | (37.7596792654558, -122.442410364393) | |||
| 18868 | 18868 | 15071 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1X Minerva St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5995959.8595900005 | 2089005.6685900001 | 37.7157802951115 | -122.45590116312201 | (37.7157802951115, -122.455901163122) | |||
| 35603 | 35603 | 204716 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 155 Madrone Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992699.213880001 | 2098207.72713 | 37.7408591943976 | -122.467840257748 | (37.7408591943976, -122.467840257748) | |||
| 39239 | 39239 | 175813 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 15 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6005348.05368 | 2093155.48995 | 37.727709159929105 | -122.42374609402201 | (37.7277091599291, -122.423746094022) | ||||
| 45007 | 45007 | 248046 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 38 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6010555.404680001 | 2099417.48898 | 37.745195855721995 | -122.406185107956 | (37.745195855722, -122.406185107956) | ||||
| 52153 | 52153 | 125934 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1715 Taylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008711.31794 | 2118818.3670900003 | 37.7983627993626 | -122.41393383309799 | (37.7983627993626, -122.413933833098) | |||
| 53767 | 53767 | 222709 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 290 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 3ft | 6000333.10816 | 2106866.5537099997 | 37.7650720879349 | -122.44206655213699 | (37.7650720879349, -122.442066552137) | |||
| 53963 | 53963 | 205923 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 266 Judson Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998304.035759999 | 2093569.7761099997 | 37.7284465374612 | -122.448127087008 | (37.7284465374612, -122.448127087008) | ||||
| 54560 | 54560 | 175803 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 421 Wheeler Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011997.87722 | 2086794.11576 | 37.7106152574533 | -122.400310793023 | (37.7106152574533, -122.400310793023) | |||
| 62729 | 62729 | 96749 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 399X Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1.5x2 | 6003700.0 | 2103889.2 | 37.7570882837734 | -122.430208878023 | (37.7570882837734, -122.430208878023) | |||
| 62795 | 62795 | 188412 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 398 Mississippi St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014026.1658 | 2105339.44297 | 37.761649798808996 | -122.394598331744 | (37.761649798809, -122.394598331744) | |||
| 63986 | 63986 | 188409 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 2033 22nd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6011983.90541 | 2103708.46876 | 37.757057753421 | -122.40154709194799 | (37.757057753421, -122.401547091948) | |||
| 75485 | 75485 | 175814 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 11 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6005376.332880001 | 2093192.89602 | 37.727813465104 | -122.423650990705 | (37.727813465104, -122.423650990705) | ||||
| 79940 | 79940 | 37260 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 801X Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 3 | 3x3 | Permit Number 39806 | 6017074.59942826 | 2104815.9109509 | 37.7603812969624 | -122.38401847505399 | (37.7603812969624, -122.384018475054) | |
| 81823 | 81823 | 36071 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1504 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1998 12:00:00 AM | Permit Number 39187 | 6009387.99483758 | 2107777.56202059 | 37.7680853638298 | -122.410812146882 | (37.7680853638298, -122.410812146882) | ||
| 83513 | 83513 | 102091 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 27 Santa Ana Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/2012 12:00:00 AM | 3x3 | Permit Number 769734 | 5992609.4 | 2096703.2 | 37.7367229555432 | -122.468041385671 | (37.7367229555432, -122.468041385671) | |
| 94670 | 94670 | 109400 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1588 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997977.9 | 2108248.0 | 37.7687306888354 | -122.450312188331 | (37.7687306888354, -122.450312188331) | ||||
| 97134 | 97134 | 122681 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 598x Powhattan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008469.0 | 2098078.0 | 37.7414009906205 | -122.413304856031 | (37.7414009906205, -122.413304856031) | ||||
| 101966 | 101966 | 37855 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 50 Ina Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1998 12:00:00 AM | Permit Number 40144 | 6004964.50568845 | 2091639.69049004 | 37.7235254489092 | -122.42496422599702 | (37.7235254489092, -122.424964225997) | |||
| 112126 | 112126 | 37302 | Permitted Site 1 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 400 Hill St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39826 | 6003717.20570413 | 2103355.3114542 | 37.7556233268944 | -122.430111288531 | (37.7556233268944, -122.430111288531) |
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");