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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 106066 | 106066 | 9939 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 599X Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6010151.7222 | 2119175.95135 | 37.799425428685396 | -122.408974817327 | (37.7994254286854, -122.408974817327) | |||
| 84344 | 84344 | 9936 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 599X Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3x3 | 6010151.7222 | 2119175.95135 | 37.799425428685396 | -122.408974817327 | (37.7994254286854, -122.408974817327) | |||
| 119322 | 119322 | 9937 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 599X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3x3 | 6010151.7222 | 2119175.95135 | 37.799425428685396 | -122.408974817327 | (37.7994254286854, -122.408974817327) | |||
| 143455 | 143455 | 9938 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 599X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3x3 | 6010151.7222 | 2119175.95135 | 37.799425428685396 | -122.408974817327 | (37.7994254286854, -122.408974817327) | |||
| 8507 | 8507 | 13147 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1833 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6003597.2465 | 2119627.9507 | 37.8002971624487 | -122.431687899053 | (37.8002971624487, -122.431687899053) | |||
| 145310 | 145310 | 1503 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 345 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5995510.44866 | 2113974.84382 | 37.7843135680421 | -122.459261623975 | (37.7843135680421, -122.459261623975) | |||
| 87951 | 87951 | 7532 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2825 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6008387.878330001 | 2101973.43548 | 37.75209243423821 | -122.41386083575001 | (37.7520924342382, -122.41386083575) | |||
| 92204 | 92204 | 229 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2974 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5990632.173690001 | 2095387.1701099998 | 37.7329950890785 | -122.474781419889 | (37.7329950890785, -122.474781419889) | |||
| 100976 | 100976 | 1586 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 662 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5995674.24695 | 2111600.73599 | 37.7778043159194 | -122.45852302735001 | (37.7778043159194, -122.45852302735) | |||
| 11219 | 11219 | 213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.08308 | 2095701.4011400002 | 37.7338515654947 | -122.475181502731 | (37.7338515654947, -122.475181502731) | |||
| 12433 | 12433 | 211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2929 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2X3 | 5990523.61376 | 2095726.5411900003 | 37.7339206244383 | -122.475181502724 | (37.7339206244383, -122.475181502724) | |||
| 82537 | 82537 | 14726 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 879 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 5x5 | 6004991.63414 | 2111891.18106 | 37.7791328750855 | -122.426311618439 | (37.7791328750855, -122.426311618439) | |||
| 138634 | 138634 | 14551 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 836 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1992 12:00:00 AM | 45 | 3X3 | 5999328.378740001 | 2109937.85065 | 37.773447785037796 | -122.44576254599 | (37.7734477850378, -122.44576254599) | ||
| 22445 | 22445 | 21574 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1500X Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 4x4 | 6005432.88679 | 2114867.95689 | 37.7873312987381 | -122.424996996122 | (37.7873312987381, -122.424996996122) | |||
| 17374 | 17374 | 70 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 877 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003041.605930001 | 2107668.70427 | 37.7674285769945 | -122.432755839529 | (37.7674285769945, -122.432755839529) | |||
| 18204 | 18204 | 53 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 819 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6003339.25774 | 2107690.1864099996 | 37.7675044384029 | -122.431727837076 | (37.7675044384029, -122.431727837076) | |||
| 126869 | 126869 | 23688 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 850X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003163.3011918 | 2107726.7605584 | 37.7675948865493 | -122.432339059397 | (37.7675948865493, -122.432339059397) | |||
| 9572 | 9572 | 100227 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 542 Valley St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Permit Number 769993 | 6002426.0 | 2099190.0 | 37.7441131524814 | -122.434278904907 | (37.7441131524814, -122.434278904907) | |||
| 12849 | 12849 | 17560 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 636 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003292.50024 | 2090584.1150200001 | 37.720532485468205 | -122.43066875855601 | (37.7205324854682, -122.430668758556) | |||
| 17301 | 17301 | 158 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1095 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001530.2126 | 2107592.17995 | 37.7671326262835 | -122.437978050639 | (37.7671326262835, -122.437978050639) | |||
| 18933 | 18933 | 3439 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 7 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999527.47755 | 2099870.13675 | 37.745815699949006 | -122.444350187132 | (37.745815699949, -122.444350187132) | |||
| 18942 | 18942 | 117 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 975 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002386.388619999 | 2107635.87333 | 37.767301249177606 | -122.435019795532 | (37.7673012491776, -122.435019795532) | |||
| 21373 | 21373 | 212 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2930 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2X3 | 5990603.05334 | 2095685.5251099998 | 37.7338126086681 | -122.474903865842 | (37.7338126086681, -122.474903865842) | |||
| 66015 | 66015 | 14730 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 880 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | |||
| 73362 | 73362 | 231752 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 645 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 4ft | 6002226.09429 | 2102058.36889 | 37.7519776675402 | -122.435175253243 | (37.7519776675402, -122.435175253243) | |||
| 81768 | 81768 | 69 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 865 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003077.949911701 | 2107671.9727494 | 37.7674396126058 | -122.43263036424999 | (37.7674396126058, -122.43263036425) | |||
| 83027 | 83027 | 152 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1083 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001573.9456807 | 2107585.1760068 | 37.767115882088 | -122.437826283074 | (37.767115882088, -122.437826283074) | |||
| 88136 | 88136 | 9735 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 727X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6005653.63672 | 2112026.60995 | 37.779542127378605 | -122.424031111893 | (37.7795421273786, -122.424031111893) | |||
| 103225 | 103225 | 14722 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 870 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/16/2000 12:00:00 AM | 30 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | ||
| 19002 | 19002 | 7621 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3227 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 6x9 | 6008480.6465300005 | 2099830.22389 | 37.7462128639419 | -122.413388474314 | (37.7462128639419, -122.413388474314) | |||
| 79581 | 79581 | 117011 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 457X CASTRO ST | 1 | Back Yard : Cutout 16 | Tree 1 | MTA 6 | Private 3 | 27 | 3x6 | 6002348.0 | 2105584.0 | 37.7616651256499 | -122.435005811888 | (37.7616651256499, -122.435005811888) | ||
| 173745 | 173745 | 131110 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 2566 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6002453.37001 | 2116130.01702 | 37.7906278392539 | -122.435395799391 | (37.7906278392539, -122.435395799391) | |||
| 19546 | 19546 | 10081 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 630 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 2x2 | 6005564.837669999 | 2105271.62168 | 37.7609895372482 | -122.42385784647 | (37.7609895372482, -122.42385784647) | |||
| 67951 | 67951 | 231892 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 255 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 6003250.94109 | 2109214.8640099997 | 37.7716858236788 | -122.432142206896 | (37.7716858236788, -122.432142206896) | |||
| 1581 | 1581 | 111 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 955 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002518.0 | 2107623.0 | 37.767273374303706 | -122.43456365047399 | (37.7672733743037, -122.434563650474) | |||
| 9061 | 9061 | 66 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 854 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 5.5x3.5 | 6003138.2570065 | 2107725.378034 | 37.767589670380296 | -122.432425585191 | (37.7675896703803, -122.432425585191) | |||
| 12307 | 12307 | 17505 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 137 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002178.53273 | 2091331.3237299998 | 37.7225209800456 | -122.434572784827 | (37.7225209800456, -122.434572784827) | |||
| 13193 | 13193 | 17566 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 701X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/1992 12:00:00 AM | 25 | 4.5x6 | 6003419.22785 | 2090557.86639 | 37.7204675912996 | -122.43022883000201 | (37.7204675912996, -122.430228830002) | ||
| 17367 | 17367 | 4448 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1362 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6004481.19296 | 2100959.81807 | 37.7490891017952 | -122.427298546501 | (37.7490891017952, -122.427298546501) | |||
| 18669 | 18669 | 123 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1032 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3.5 | 6002070.82706 | 2107663.58495 | 37.7673594155415 | -122.436113259617 | (37.7673594155415, -122.436113259617) | |||
| 19112 | 19112 | 104 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 903 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002728.05745 | 2107652.23665 | 37.7673655732026 | -122.433839182638 | (37.7673655732026, -122.433839182638) | |||
| 19208 | 19208 | 108 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 939 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002600.95184 | 2107648.90078 | 37.7673492001289 | -122.434278584211 | (37.7673492001289, -122.434278584211) | |||
| 19313 | 19313 | 106 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 927 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002652.29309 | 2107649.54302 | 37.7673538775163 | -122.434101048134 | (37.7673538775163, -122.434101048134) | |||
| 19532 | 19532 | 134 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6001934.13073 | 2107605.43709 | 37.767191988753204 | -122.43658190982201 | (37.7671919887532, -122.436581909822) | |||
| 19565 | 19565 | 58 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 831 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003255.09688 | 2107686.06346 | 37.767488346823896 | -122.432018643671 | (37.7674883468239, -122.432018643671) | |||
| 20010 | 20010 | 142 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6002114.14587 | 2107618.20787 | 37.7672372822096 | -122.435960178842 | (37.7672372822096, -122.435960178842) | |||
| 20713 | 20713 | 112 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 955 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002510.55394 | 2107641.82471 | 37.7673246396489 | -122.43459075148 | (37.7673246396489, -122.43459075148) | |||
| 21403 | 21403 | 38 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 775 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003673.2104 | 2107707.71827 | 37.767571500863795 | -122.430573990716 | (37.7675715008638, -122.430573990716) | |||
| 21733 | 21733 | 9375 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 308 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/1992 12:00:00 AM | 25 | 2X2 | 6001095.96192 | 2097856.03064 | 37.740374805159995 | -122.43878230087 | (37.74037480516, -122.43878230087) | ||
| 22155 | 22155 | 107 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 935 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002622.320669999 | 2107648.0329400003 | 37.767348030106795 | -122.434204610458 | (37.7673480301068, -122.434204610458) | |||
| 34014 | 34014 | 209622 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 139 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 3ft | 5995252.9864 | 2107026.0049099997 | 37.7652190857026 | -122.45964887371599 | (37.7652190857026, -122.459648873716) | |||
| 100505 | 100505 | 57981 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 270 Castenada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2014 12:00:00 AM | 25 | 3x100 | Permit Number 773879 | 5994102.54415527 | 2100325.21167443 | 37.7467542089972 | -122.46314170630801 | (37.7467542089972, -122.463141706308) | |
| 102626 | 102626 | 102 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 923 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002700.4016261 | 2107651.1308054 | 37.767360967419705 | -122.43393476112301 | (37.7673609674197, -122.433934761123) | |||
| 145489 | 145489 | 14715 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 860 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | |||
| 17091 | 17091 | 5182 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 443 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X2 | 6001670.04782 | 2110029.17719 | 37.7738319666993 | -122.43766893298599 | (37.7738319666993, -122.437668932986) | |||
| 22592 | 22592 | 21577 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1500X Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4X4 | 6005423.35967 | 2114926.74841 | 37.7874921874528 | -122.42503414262899 | (37.7874921874528, -122.425034142629) | |||
| 22618 | 22618 | 21576 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1500X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4X4 | 6005427.69602 | 2114907.08129 | 37.7874384313885 | -122.42501773987101 | (37.7874384313885, -122.425017739871) | |||
| 58717 | 58717 | 14708 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 835 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5x5 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | |||
| 81039 | 81039 | 14695 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 785 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | |||
| 97615 | 97615 | 55 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 825 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6003336.0552036 | 2107686.2210378996 | 37.7674933689218 | -122.431738631065 | (37.7674933689218, -122.431738631065) | |||
| 105568 | 105568 | 14714 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 855 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | |||
| 110215 | 110215 | 104561 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 201 HEARST AVE | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x9 | 6000007.0 | 2094313.0 | 37.7305844621254 | -122.442293205182 | (37.7305844621254, -122.442293205182) | |||
| 122420 | 122420 | 14718 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 863X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 4x4 | 6005038.24694 | 2111941.52177 | 37.779273733003 | -122.426153950433 | (37.779273733003, -122.426153950433) | |||
| 126582 | 126582 | 14711 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 845 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 24 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | ||
| 138951 | 138951 | 102284 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 4434 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6000433.0 | 2102286.0 | 37.7525007023887 | -122.44139234740601 | (37.7525007023887, -122.441392347406) | |||
| 152331 | 152331 | 245130 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 104 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6000839.3289 | 2109397.2364 | 37.7720495475548 | -122.440497183801 | (37.7720495475548, -122.440497183801) | |||
| 175029 | 175029 | 209655 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 524 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 5992657.04234 | 2103925.26925 | 37.7565556619406 | -122.468401937414 | (37.7565556619406, -122.468401937414) | |||
| 186204 | 186204 | 231896 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 195 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6003308.51997 | 2108863.0218700003 | 37.7707230157931 | -122.431917910592 | (37.7707230157931, -122.431917910592) | |||
| 29436 | 29436 | 231930 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 143 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6003869.83737 | 2097512.17576 | 37.7395880782392 | -122.429166825102 | (37.7395880782392, -122.429166825102) | |||
| 31381 | 31381 | 230966 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 249 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6007043.29056 | 2097516.1274599996 | 37.7397780654169 | -122.41819464917499 | (37.7397780654169, -122.418194649175) | |||
| 63908 | 63908 | 209571 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 100 Malta Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | 5999439.63659 | 2096255.44813 | 37.7358856152333 | -122.44439420083799 | (37.7358856152333, -122.444394200838) | ||||
| 70346 | 70346 | 248444 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 57 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5999292.0309 | 2107993.2430000002 | 37.7681063099283 | -122.445748402419 | (37.7681063099283, -122.445748402419) | |||
| 73112 | 73112 | 231021 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 353 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6006227.59151 | 2101087.01833 | 37.7495369767472 | -122.421268504037 | (37.7495369767472, -122.421268504037) | |||
| 163529 | 163529 | 209719 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 130 Montalvo Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 5993708.81111 | 2099601.4699 | 37.7447443078957 | -122.46445064547399 | (37.7447443078957, -122.464450645474) | |||
| 181294 | 181294 | 231128 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 855 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6003131.23825 | 2107673.13247 | 37.7674458187972 | -122.432446130109 | (37.7674458187972, -122.432446130109) | |||
| 189050 | 189050 | 231046 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 875 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002490.77915 | 2103119.8434099997 | 37.7549072504735 | -122.434335817947 | (37.7549072504735, -122.434335817947) | |||
| 27903 | 27903 | 231769 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 4189 26th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 4ft | 6002709.32864 | 2100612.54197 | 37.7480351970786 | -122.43340085217399 | (37.7480351970786, -122.433400852174) | |||
| 45164 | 45164 | 120179 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 134 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5987741.96799 | 2115060.21005 | 37.786843985553396 | -122.486217209916 | (37.7868439855534, -122.486217209916) | |||
| 46878 | 46878 | 67329 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1977 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/20/1992 12:00:00 AM | 22 | Permit Number 30812 | 6003593.71705 | 2118268.8436 | 37.796565205678604 | -122.431603027358 | (37.7965652056786, -122.431603027358) | ||
| 57478 | 57478 | 209429 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1458 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 2ft | 5993072.36309 | 2105548.8549599997 | 37.7610375853253 | -122.46708365990101 | (37.7610375853253, -122.467083659901) | |||
| 105054 | 105054 | 104686 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 140 26TH AVE | Front Yard : Cutout 8 | Tree 1 | Private 1 | 22 | 4x4 | 5987812.9 | 2115041.6 | 37.786797021543 | -122.485970438221 | (37.786797021543, -122.485970438221) | ||||
| 139788 | 139788 | 104400 | Private 5 | Maytenus boaria :: Mayten 22 | 755 Ashbury St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 5999044.0 | 2107976.0 | 37.768044800389 | -122.44660507122101 | (37.768044800389, -122.446605071221) | ||||
| 154063 | 154063 | 131160 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1237x Robert C Levy Tunl | 16 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6007730.43085 | 2118156.7577 | 37.7964910475791 | -122.41728110074301 | (37.7964910475791, -122.417281100743) | ||||
| 147814 | 147814 | 209384 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1248 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5994567.11021 | 2107074.73575 | 37.7653134236957 | -122.462024672105 | (37.7653134236957, -122.462024672105) | |||
| 171374 | 171374 | 231648 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 111 Clifford Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5999566.14377 | 2106486.5482799998 | 37.76398495055471 | -122.444691968179 | (37.7639849505547, -122.444691968179) | |||
| 180851 | 180851 | 209579 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 201 Hearst Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 6000038.89773 | 2094344.61386 | 37.730673084383795 | -122.442185198805 | (37.7306730843838, -122.442185198805) | |||
| 180997 | 180997 | 231596 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 269 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6004145.2153 | 2099533.7900900003 | 37.7451545525451 | -122.428358736588 | (37.7451545525451, -122.428358736588) | |||
| 10501 | 10501 | 17501 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 124 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002114.94221 | 2091325.72307 | 37.722501991763004 | -122.434792202295 | (37.722501991763, -122.434792202295) | |||
| 11430 | 11430 | 214 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X3 | 5990522.122690001 | 2095686.58843 | 37.7338108378948 | -122.47518374203699 | (37.7338108378948, -122.475183742037) | |||
| 17533 | 17533 | 150 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1075 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6001650.88239 | 2107592.64256 | 37.76714075797379 | -122.437560705874 | (37.7671407579738, -122.437560705874) | |||
| 18952 | 18952 | 19182 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 809X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003410.829940001 | 2107695.40697 | 37.7675228295542 | -122.43148065121001 | (37.7675228295542, -122.43148065121) | |||
| 19135 | 19135 | 14729 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 880 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | |||
| 19437 | 19437 | 135 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6001952.83166 | 2107606.45386 | 37.7671958432489 | -122.436517298951 | (37.7671958432489, -122.436517298951) | |||
| 19949 | 19949 | 143 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6002137.11079 | 2107620.89146 | 37.7672459552646 | -122.435880938676 | (37.7672459552646, -122.435880938676) | |||
| 20804 | 20804 | 129 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1046 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001838.94694 | 2107648.51377 | 37.767304857259 | -122.436914220126 | (37.767304857259, -122.436914220126) | |||
| 21020 | 21020 | 57 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 829 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003284.96574 | 2107687.1211099997 | 37.7674929441796 | -122.43191540687 | (37.7674929441796, -122.43191540687) | |||
| 21243 | 21243 | 41 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 795 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003608.499480001 | 2107706.26027 | 37.767563831432206 | -122.43079771324601 | (37.7675638314322, -122.430797713246) | |||
| 21346 | 21346 | 43 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 797 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003580.94003 | 2107704.3456099997 | 37.7675570127652 | -122.43089290110001 | (37.7675570127652, -122.4308929011) | |||
| 25181 | 25181 | 230942 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 510 Anderson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6007792.31674 | 2095781.12645 | 37.7350562658258 | -122.4154820241 | (37.7350562658258, -122.4154820241) | |||
| 36806 | 36806 | 248478 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 753 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997595.8852 | 2107895.8834 | 37.7677419967608 | -122.451608139596 | (37.7677419967608, -122.451608139596) |
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");