Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145424 | 145424 | 809 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 111465 | 111465 | 810 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 114988 | 114988 | 812 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 105087 | 105087 | 813 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 600X 39th Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983831.1679936 | 2111715.0127262003 | 37.7774303425616 | -122.499500145383 | (37.7774303425616, -122.499500145383) | |||
| 10518 | 10518 | 820 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1407 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:29:00 PM | 3 | 3X3 | 5982131.0395 | 2105513.2639 | 37.760302236597 | -122.504921669151 | (37.760302236597, -122.504921669151) | ||
| 10681 | 10681 | 821 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1409 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:34:00 PM | 3 | 3X3 | 5982132.645 | 2105492.3927 | 37.7602450246853 | -122.504914569939 | (37.7602450246853, -122.504914569939) | ||
| 9822 | 9822 | 822 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1411 45th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2015 05:39:00 PM | 3 | 3X3 | 5982129.0913294 | 2105488.1375738997 | 37.7602331322527 | -122.50492654488 | (37.7602331322527, -122.50492654488) | ||
| 118641 | 118641 | 1413 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X5 | 5995443.6836 | 2115866.47874 | 37.7895036485155 | -122.459629661947 | (37.7895036485155, -122.459629661947) | |||
| 109370 | 109370 | 1414 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3X5 | 5995457.5707 | 2115860.24617 | 37.7894873341044 | -122.459581162818 | (37.7894873341044, -122.459581162818) | |||
| 145165 | 145165 | 1415 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X5 | 5995460.3919400005 | 2115783.72708 | 37.7892773956462 | -122.45956585741001 | (37.7892773956462, -122.45956585741) | |||
| 144317 | 144317 | 1416 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X5 | 5995444.41006 | 2115805.29588 | 37.7893356987405 | -122.459622715277 | (37.7893356987405, -122.459622715277) | |||
| 145542 | 145542 | 1417 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 5995446.00012 | 2115789.3040299998 | 37.7892918808868 | -122.459616055153 | (37.7892918808868, -122.459616055153) | |||
| 93508 | 93508 | 1418 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 15 Arguello Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5X5PL | 5995436.85306 | 2115829.92253 | 37.7894028822964 | -122.459650645871 | (37.7894028822964, -122.459650645871) | |||
| 126572 | 126572 | 1419 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 41 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5X5PL | 5995462.58605 | 2115703.1082900004 | 37.7890561644519 | -122.459552424818 | (37.7890561644519, -122.459552424818) | |||
| 103367 | 103367 | 1424 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5X5PL | 5995463.97403 | 2115644.21361 | 37.788894535419004 | -122.459543355401 | (37.788894535419, -122.459543355401) | |||
| 88395 | 88395 | 1425 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5X5PL | 5995464.3721900005 | 2115634.54937 | 37.7888680229269 | -122.45954127761101 | (37.7888680229269, -122.459541277611) | |||
| 93233 | 93233 | 1426 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5X5PL | 5995463.35217 | 2115623.5326099996 | 37.788837715235296 | -122.459544008497 | (37.7888377152353, -122.459544008497) | |||
| 144995 | 144995 | 1427 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 65 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5X5PL | 5995465.80895 | 2115602.75583 | 37.7887808090871 | -122.45953400306699 | (37.7887808090871, -122.459534003067) | |||
| 84026 | 84026 | 1450 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 151X ARGUELLO BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X5 | 5995497.0 | 2115135.0 | 37.7874982714485 | -122.459392198652 | (37.7874982714485, -122.459392198652) | |||
| 122642 | 122642 | 1452 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 151X ARGUELLO BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X5 | 5995497.0 | 2115135.0 | 37.7874982714485 | -122.459392198652 | (37.7874982714485, -122.459392198652) | |||
| 78707 | 78707 | 1453 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 151X ARGUELLO BLVD | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X5 | 5995497.0 | 2115135.0 | 37.7874982714485 | -122.459392198652 | (37.7874982714485, -122.459392198652) | |||
| 93033 | 93033 | 1454 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 151X ARGUELLO BLVD | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X5 | 5995497.0 | 2115135.0 | 37.7874982714485 | -122.459392198652 | (37.7874982714485, -122.459392198652) | |||
| 93301 | 93301 | 1757 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2606 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006953.0 | 2121208.0 | 37.804825218877895 | -122.42018784573999 | (37.8048252188779, -122.42018784574) | |||
| 121514 | 121514 | 1758 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2606 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6006953.0 | 2121208.0 | 37.804825218877895 | -122.42018784573999 | (37.8048252188779, -122.42018784574) | |||
| 128056 | 128056 | 1759 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2606X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006953.0 | 2121208.0 | 37.804825218877895 | -122.42018784573999 | (37.8048252188779, -122.42018784574) | |||
| 115850 | 115850 | 1951 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 22 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017592.1686028 | 2095111.1070948 | 37.733762484425604 | -122.38155350563 | (37.7337624844256, -122.38155350563) | ||
| 138548 | 138548 | 1957 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 28 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017599.7808961 | 2095067.264352 | 37.7336425212053 | -122.381524139501 | (37.7336425212053, -122.381524139501) | ||
| 140205 | 140205 | 1958 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 31 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017652.9680682 | 2095074.2258741 | 37.7336645725809 | -122.381340737954 | (37.7336645725809, -122.381340737954) | ||
| 81392 | 81392 | 1962 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 36 Bertha Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017618.4307655 | 2095033.1830576 | 37.733549970373105 | -122.38145729159599 | (37.7335499703731, -122.381457291596) | ||
| 110194 | 110194 | 1964 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 45 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017685.4326556 | 2095014.8991764 | 37.7335034653707 | -122.38122437355301 | (37.7335034653707, -122.381224373553) | ||
| 90950 | 90950 | 1967 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 55 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017714.6010769 | 2094983.7665226 | 37.7334195913803 | -122.381121365124 | (37.7334195913803, -122.381121365124) | ||
| 119429 | 119429 | 1980 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 96 Bertha Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017818.374320901 | 2094812.8777716998 | 37.7329560922326 | -122.38075071303601 | (37.7329560922326, -122.380750713036) | ||
| 99125 | 99125 | 1984 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 106 Bertha Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/1997 12:00:00 AM | 3 | 3X4 | 6017854.9793307 | 2094779.8205714 | 37.732867343787 | -122.38062186171699 | (37.732867343787, -122.380621861717) | ||
| 145221 | 145221 | 2000 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2004 12:00:00 AM | 12 | 3X3 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | ||
| 118160 | 118160 | 2001 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 103360 | 103360 | 2004 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 91590 | 91590 | 2005 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 78218 | 78218 | 2006 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | |||
| 120661 | 120661 | 2007 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 500X Bosworth St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | Permit Number 772999 | 6002728.1222807 | 2095276.2570246002 | 37.733384060718 | -122.432954679755 | (37.733384060718, -122.432954679755) | ||
| 17167 | 17167 | 2165 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 119X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/1997 12:00:00 AM | 12 | 3X27 | 5993658.6263 | 2088481.9826 | 37.714210032770296 | -122.46381723495199 | (37.7142100327703, -122.463817234952) | ||
| 8126 | 8126 | 2647 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1944 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004195.494 | 2115001.3607 | 37.7876276181393 | -122.42928763204901 | (37.7876276181393, -122.429287632049) | |||
| 4990 | 4990 | 3550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6018708.52549 | 2097590.55589 | 37.7406321362531 | -122.377865918974 | (37.7406321362531, -122.377865918974) | ||
| 89905 | 89905 | 3554 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | ||
| 116499 | 116499 | 3555 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018831.8 | 2097475.1 | 37.7403219094469 | -122.377431668566 | (37.7403219094469, -122.377431668566) | ||
| 13656 | 13656 | 3557 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 2 | 3X3 | 6018758.221530001 | 2097553.75967 | 37.740533839473294 | -122.377691534151 | (37.7405338394733, -122.377691534151) | ||
| 16143 | 16143 | 3559 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018791.21625 | 2097528.24687 | 37.7404656043104 | -122.377575679878 | (37.7404656043104, -122.377575679878) | ||
| 14314 | 14314 | 3560 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018809.63786 | 2097515.71259 | 37.7404322025979 | -122.377511114855 | (37.7404322025979, -122.377511114855) | ||
| 14102 | 14102 | 3562 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018842.999 | 2097491.0611 | 37.7403663524293 | -122.37739405370701 | (37.7403663524293, -122.377394053707) | ||
| 13816 | 13816 | 3563 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018859.49817 | 2097478.39151 | 37.7403324731777 | -122.37733612657401 | (37.7403324731777, -122.377336126574) | ||
| 14754 | 14754 | 3564 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101 Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 6 | 3X3 | 6018876.34975 | 2097465.88877 | 37.740299071447794 | -122.377276992562 | (37.7402990714478, -122.377276992562) | ||
| 16144 | 16144 | 3565 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018894.06666 | 2097453.02118 | 37.740264715549 | -122.37721484129601 | (37.740264715549, -122.377214841296) | ||
| 13811 | 13811 | 3566 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 101X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6018911.95106 | 2097439.80241 | 37.740229404572396 | -122.377152086609 | (37.7402294045724, -122.377152086609) | ||
| 95791 | 95791 | 3567 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 113278 | 113278 | 3568 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 138764 | 138764 | 3571 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 103648 | 103648 | 3574 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 79713 | 79713 | 3575 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 84280 | 84280 | 3576 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 13525 | 13525 | 3697 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016390.489709999 | 2099364.7540700003 | 37.7453757156112 | -122.3860045182 | (37.7453757156112, -122.3860045182) | |||
| 15044 | 15044 | 3707 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 3 | 3X3 | 6016577.539609999 | 2099225.88923 | 37.7450047713688 | -122.385348049088 | (37.7450047713688, -122.385348049088) | ||
| 16403 | 16403 | 3726 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 401X Cargo Way | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016987.22702 | 2098921.28419 | 37.744191044988 | -122.38391020401899 | (37.744191044988, -122.383910204019) | |||
| 111440 | 111440 | 4303 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 4387X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001438.745326099 | 2100261.9516565 | 37.7470003926735 | -122.43776936520399 | (37.7470003926735, -122.437769365204) | ||
| 100992 | 100992 | 4304 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 4387X Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/1995 12:00:00 AM | 3 | 3X3 | 6001438.745326099 | 2100261.9516565 | 37.7470003926735 | -122.43776936520399 | (37.7470003926735, -122.437769365204) | ||
| 19548 | 19548 | 4335 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 858 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2002 12:00:00 AM | 6 | 3X3 | 6001687.38643 | 2095877.23382 | 37.734975118199394 | -122.436595789974 | (37.7349751181994, -122.436595789974) | ||
| 6473 | 6473 | 4379 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2425X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6007005.3355 | 2120662.9996700003 | 37.803331735330204 | -122.419968034 | (37.8033317353302, -122.419968034) | |||
| 28417 | 28417 | 4380 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2421X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007006.012916099 | 2120659.6131485 | 37.8033224749672 | -122.41996544931101 | (37.8033224749672, -122.419965449311) | |||
| 118720 | 118720 | 4381 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2421X Hyde St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007006.012916099 | 2120659.6131485 | 37.8033224749672 | -122.41996544931101 | (37.8033224749672, -122.419965449311) | |||
| 77760 | 77760 | 4382 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2391X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6007031.7831469 | 2120474.7837858996 | 37.8028164322768 | -122.419863147129 | (37.8028164322768, -122.419863147129) | |||
| 110091 | 110091 | 4383 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2391X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007031.7831469 | 2120474.7837858996 | 37.8028164322768 | -122.419863147129 | (37.8028164322768, -122.419863147129) | |||
| 19951 | 19951 | 4423 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1145 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004475.83751 | 2102212.10827 | 37.7525272963192 | -122.42740626460301 | (37.7525272963192, -122.427406264603) | |||
| 124440 | 124440 | 4426 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1151 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004471.6609205995 | 2102195.0524139 | 37.7524802287033 | -122.427419493034 | (37.7524802287033, -122.427419493034) | |||
| 18726 | 18726 | 4427 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1153-1157 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6004477.3384 | 2102149.60518 | 37.752355762318395 | -122.427396622076 | (37.7523557623184, -122.427396622076) | ||
| 20047 | 20047 | 4438 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1307 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004526.51906 | 2101259.5658 | 37.749914702805206 | -122.42716315625401 | (37.7499147028052, -122.427163156254) | |||
| 104789 | 104789 | 4440 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1311 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3PL | 6004523.5006628 | 2101262.1086176997 | 37.7499215140995 | -122.42717377512301 | (37.7499215140995, -122.427173775123) | |||
| 19669 | 19669 | 4443 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1337 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/01/1999 12:00:00 AM | 8 | 3X3 | 6004533.29635 | 2101118.5652900003 | 37.7495279313912 | -122.427129678106 | (37.7495279313912, -122.427129678106) | ||
| 18831 | 18831 | 4449 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1365 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004544.3142800005 | 2100922.31022 | 37.748989683529 | -122.427077601077 | (37.748989683529, -122.427077601077) | |||
| 141878 | 141878 | 4539 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | |||
| 96618 | 96618 | 4540 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 66 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1997 12:00:00 AM | 3 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867550995 | -122.427021407244 | (37.784126867551, -122.427021407244) | ||
| 178255 | 178255 | 5125 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2741 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 6 | 3X3 | 6002497.51898 | 2095973.1425599998 | 37.735284466095 | -122.433801731284 | (37.735284466095, -122.433801731284) | ||
| 7738 | 7738 | 6091 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2004 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000795.3066 | 2112440.8396 | 37.780404005029396 | -122.44086783303801 | (37.7804040050294, -122.440867833038) | |||
| 8793 | 8793 | 6234 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1250 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/1991 12:00:00 AM | 12 | 3X3 | 6004935.7353 | 2113364.5007 | 37.7831750872989 | -122.426609937065 | (37.7831750872989, -122.426609937065) | ||
| 4914 | 4914 | 6236 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1250 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 12 | 3X3 | 6004877.1927 | 2113359.8717 | 37.78315906739 | -122.42681214119499 | (37.78315906739, -122.426812141195) | ||
| 114683 | 114683 | 6243 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1280 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | 12 | 3x3 | 6004811.27537 | 2113355.5446900004 | 37.7831434593106 | -122.42703988034701 | (37.7831434593106, -122.427039880347) | ||
| 112061 | 112061 | 6244 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1280 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 6 | 3X3 | 6004750.023080001 | 2113355.9150099996 | 37.783141012315795 | -122.42725181496 | (37.7831410123158, -122.42725181496) | ||
| 1294 | 1294 | 6921 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 425 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2010 12:00:00 AM | 3 | 3X3 | 6005385.421 | 2110602.3829 | 37.7756164008395 | -122.424857632506 | (37.7756164008395, -122.424857632506) | ||
| 112898 | 112898 | 7131 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 399X Fern St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005411.00899 | 2114942.58676 | 37.787534977947004 | -122.425078000888 | (37.787534977947, -122.425078000888) | |||
| 121427 | 121427 | 7314 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2301X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002927.5440245 | 2115118.0633563 | 37.7878761904759 | -122.433682830303 | (37.7878761904759, -122.433682830303) | |||
| 128882 | 128882 | 7706 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220418999 | (37.8042626795816, -122.41998220419) | |||
| 101172 | 101172 | 7707 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500X Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220418999 | (37.8042626795816, -122.41998220419) | |||
| 117312 | 117312 | 7709 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007008.1963938 | 2121001.9906569 | 37.8042626795816 | -122.41998220418999 | (37.8042626795816, -122.41998220419) | |||
| 124046 | 124046 | 7944 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1715X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005719.3289 | 2115506.1033 | 37.7890996659994 | -122.424051363883 | (37.7890996659994, -122.424051363883) | |||
| 111422 | 111422 | 7945 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1715X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2006 12:00:00 AM | 3 | 3x3 | 6005765.23807 | 2115513.9769599997 | 37.7891238769821 | -122.42389308392 | (37.7891238769821, -122.42389308392) | ||
| 4996 | 4996 | 7951 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1740 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/04/2010 12:00:00 AM | 12 | 3X3 | 6005752.06301 | 2116078.7697900003 | 37.790673913324795 | -122.42397884754801 | (37.7906739133248, -122.423978847548) | ||
| 89165 | 89165 | 7962 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1920X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005581.7012 | 2116251.27372 | 37.7911379463616 | -122.424580566901 | (37.7911379463616, -122.424580566901) | |||
| 129198 | 129198 | 8686 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2925 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2011 12:00:00 AM | 3 | 3x3 | 5998077.560740001 | 2113059.77812 | 37.781948291597 | -122.450314371978 | (37.781948291597, -122.450314371978) | ||
| 8344 | 8344 | 8692 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2955 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997893.1705 | 2113031.5548 | 37.781860243466 | -122.450950238487 | (37.781860243466, -122.450950238487) | |||
| 2601 | 2601 | 8737 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3250 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997009.0435 | 2113012.7724 | 37.781758017625705 | -122.454007533534 | (37.7817580176257, -122.454007533534) | |||
| 138276 | 138276 | 8747 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3301 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5996889.89707 | 2112871.05246 | 37.78136205975821 | -122.45440948154899 | (37.7813620597582, -122.454409481549) | |||
| 43176 | 43176 | 8750 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3301 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5996889.89707 | 2112871.05246 | 37.78136205975821 | -122.45440948154899 | (37.7813620597582, -122.454409481549) | |||
| 121774 | 121774 | 8751 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3301 Geary Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5996889.89707 | 2112871.05246 | 37.78136205975821 | -122.45440948154899 | (37.7813620597582, -122.454409481549) |
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");