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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5525 | 5525 | 19855 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100 STAIRWAY29 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
| 7347 | 7347 | 19760 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100 STAIRWAY15 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 11920 | 11920 | 19925 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100 STAIRWAY37 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 15643 | 15643 | 19759 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100 STAIRWAY15 | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
| 21360 | 21360 | 30939 | Permitted Site 1 | Malus :: Crab Apple 235 | 1106 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 2 | 3x32l | Permit Number 34749 | 5995956.73481 | 2091308.0794099998 | 37.722101993094604 | -122.456078325968 | (37.7221019930946, -122.456078325968) | |
| 21843 | 21843 | 4977 | DPW Maintained 3 | Malus :: Crab Apple 235 | 5200X Diamond Heights Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6000986.47805 | 2099376.03086 | 37.744542137604206 | -122.43926977298099 | (37.7445421376042, -122.439269772981) | |||
| 23182 | 23182 | 16982 | DPW Maintained 3 | Malus :: Crab Apple 235 | 845 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2002 12:00:00 AM | 2 | 3X3 | 6002950.3496 | 2109907.5532 | 37.7735707302623 | -122.43323147392701 | (37.7735707302623, -122.433231473927) | ||
| 23523 | 23523 | 208876 | Undocumented 2 | Malus :: Crab Apple 235 | 24 Sotelo Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993960.680430001 | 2101012.29566 | 37.7486325942246 | -122.463682112736 | (37.7486325942246, -122.463682112736) | |||
| 25314 | 25314 | 193455 | Undocumented 2 | Malus :: Crab Apple 235 | 801 Arkansas St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6013064.65639 | 2103684.54152 | 37.757052299940206 | -122.39780773965299 | (37.7570522999402, -122.397807739653) | ||||
| 26303 | 26303 | 181939 | Undocumented 2 | Malus :: Crab Apple 235 | 2435 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5986090.3717 | 2098658.1040000003 | 37.7417119717507 | -122.490723983614 | (37.7417119717507, -122.490723983614) | |||
| 26321 | 26321 | 247172 | Undocumented 2 | Malus :: Crab Apple 235 | 145 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6001372.05344 | 2108496.3443400003 | 37.7696062421579 | -122.438589890015 | (37.7696062421579, -122.438589890015) | |||
| 27503 | 27503 | 208879 | DPW Maintained 3 | Malus :: Crab Apple 235 | 100x Idora Ave | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 9ft | 5995727.40355 | 2099320.3409700003 | 37.74408855195821 | -122.457450449475 | (37.7440885519582, -122.457450449475) | |||
| 27831 | 27831 | 244062 | Undocumented 2 | Malus :: Crab Apple 235 | 1666 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998622.1807 | 2109013.5796 | 37.7708696265101 | -122.448138811863 | (37.7708696265101, -122.448138811863) | |||
| 29093 | 29093 | 231476 | Undocumented 2 | Malus :: Crab Apple 235 | 3343 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6007269.01195 | 2104967.01304 | 37.760249211764005 | -122.417942242758 | (37.760249211764, -122.417942242758) | |||
| 30566 | 30566 | 208874 | Undocumented 2 | Malus :: Crab Apple 235 | 88 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5993686.48009 | 2101413.5821599998 | 37.7497186209261 | -122.464659422191 | (37.7497186209261, -122.464659422191) | |||
| 30722 | 30722 | 208880 | Undocumented 2 | Malus :: Crab Apple 235 | 331 Kensington Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994249.09162 | 2099012.5139200003 | 37.7431583121036 | -122.462539760623 | (37.7431583121036, -122.462539760623) | |||
| 32629 | 32629 | 231482 | Undocumented 2 | Malus :: Crab Apple 235 | 60 Murray St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6004917.71249 | 2095272.0994400003 | 37.7334965967716 | -122.42538435301901 | (37.7334965967716, -122.425384353019) | |||
| 33318 | 33318 | 185383 | Undocumented 2 | Malus :: Crab Apple 235 | 2611 45th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5982402.2599 | 2097319.6826 | 37.7378209010805 | -122.503376950994 | (37.7378209010805, -122.503376950994) | |||
| 33368 | 33368 | 231493 | Undocumented 2 | Malus :: Crab Apple 235 | 339 Addison St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6002237.63018 | 2097698.28157 | 37.7400065480711 | -122.434823590441 | (37.7400065480711, -122.434823590441) | |||
| 33944 | 33944 | 208889 | Undocumented 2 | Malus :: Crab Apple 235 | 714 Detroit St | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5999450.60571 | 2095416.85302 | 37.733583656540496 | -122.44429603176201 | (37.7335836565405, -122.444296031762) | ||||
| 34351 | 34351 | 208892 | Undocumented 2 | Malus :: Crab Apple 235 | 501 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 10ft | 5998746.62253 | 2094953.78578 | 37.7322719935398 | -122.446696588498 | (37.7322719935398, -122.446696588498) | |||
| 34864 | 34864 | 246661 | Undocumented 2 | Malus :: Crab Apple 235 | 3301 Harrison St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6009058.25509 | 2099385.89739 | 37.7450252552125 | -122.41135978362699 | (37.7450252552125, -122.411359783627) | |||
| 36750 | 36750 | 208881 | Undocumented 2 | Malus :: Crab Apple 235 | 298 Staples Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5998181.94254 | 2093824.01975 | 37.7291376502845 | -122.44856747063801 | (37.7291376502845, -122.448567470638) | ||||
| 38073 | 38073 | 208890 | Undocumented 2 | Malus :: Crab Apple 235 | 843 Detroit St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 5999418.03526 | 2095622.98585 | 37.734147790474 | -122.444423445903 | (37.734147790474, -122.444423445903) | |||
| 38094 | 38094 | 231477 | DPW Maintained 3 | Malus :: Crab Apple 235 | 600x San Jose Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005974.01132 | 2099648.68915 | 37.7455733533412 | -122.422043227715 | (37.7455733533412, -122.422043227715) | |||
| 39243 | 39243 | 177477 | Undocumented 2 | Malus :: Crab Apple 235 | 87 Cora St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6009582.8430699995 | 2087291.35745 | 37.71184561634829 | -122.408692776665 | (37.7118456163483, -122.408692776665) | |||
| 39874 | 39874 | 246802 | Undocumented 2 | Malus :: Crab Apple 235 | 369 Mullen Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6010622.516969999 | 2099596.58355 | 37.7456913641809 | -122.40596565808501 | (37.7456913641809, -122.405965658085) | |||
| 40816 | 40816 | 208883 | Undocumented 2 | Malus :: Crab Apple 235 | 350 Faxon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994771.013280001 | 2090927.2671400001 | 37.7209882430054 | -122.460149470526 | (37.7209882430054, -122.460149470526) | |||
| 40892 | 40892 | 177474 | DPW Maintained 3 | Malus :: Crab Apple 235 | 700x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009738.6483 | 2090119.17864 | 37.7196189577185 | -122.408353599158 | (37.7196189577185, -122.408353599158) | |||
| 42375 | 42375 | 208894 | Undocumented 2 | Malus :: Crab Apple 235 | 279 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 5998236.0788199995 | 2093773.5994099998 | 37.7290023032069 | -122.44837668842699 | (37.7290023032069, -122.448376688427) | ||||
| 46035 | 46035 | 231483 | Undocumented 2 | Malus :: Crab Apple 235 | 1604 Diamond St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6002002.63462 | 2099363.53444 | 37.744565598238204 | -122.43575521973601 | (37.7445655982382, -122.435755219736) | |||
| 46835 | 46835 | 208873 | Undocumented 2 | Malus :: Crab Apple 235 | 1915 11th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5992820.79743 | 2102456.2527799997 | 37.7525315806908 | -122.46772878318001 | (37.7525315806908, -122.46772878318) | |||
| 47800 | 47800 | 231488 | Undocumented 2 | Malus :: Crab Apple 235 | 215 Grand View Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000742.39523 | 2103201.2606099998 | 37.7550314072854 | -122.44038804396999 | (37.7550314072854, -122.44038804397) | |||
| 49465 | 49465 | 193450 | Undocumented 2 | Malus :: Crab Apple 235 | 2000 18th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6011681.52321 | 2105621.1617 | 37.762292706176204 | -122.40272735948 | (37.7622927061762, -122.40272735948) | ||||
| 49650 | 49650 | 231486 | Undocumented 2 | Malus :: Crab Apple 235 | 404 Jersey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002461.69092 | 2101528.78881 | 37.7505369419476 | -122.43432266895901 | (37.7505369419476, -122.434322668959) | |||
| 49906 | 49906 | 131018 | Undocumented 2 | Malus :: Crab Apple 235 | 3262 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003319.94778 | 2119547.1181900003 | 37.8000594954142 | -122.432641684079 | (37.8000594954142, -122.432641684079) | |||
| 51207 | 51207 | 184211 | Undocumented 2 | Malus :: Crab Apple 235 | 1483 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5984010.2855 | 2105077.6933 | 37.7592166624085 | -122.498390165683 | (37.7592166624085, -122.498390165683) | |||
| 54042 | 54042 | 231492 | Undocumented 2 | Malus :: Crab Apple 235 | 118 Saint Marys Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003928.90104 | 2095975.3596400002 | 37.7353716742659 | -122.42885307500799 | (37.7353716742659, -122.428853075008) | |||
| 55107 | 55107 | 208887 | Undocumented 2 | Malus :: Crab Apple 235 | 747 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5999422.56432 | 2095411.3960400003 | 37.733567073059895 | -122.44439258657302 | (37.7335670730599, -122.444392586573) | ||||
| 60656 | 60656 | 193457 | Undocumented 2 | Malus :: Crab Apple 235 | 1501 Quint St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 4ft | 6013271.29091 | 2096357.05994 | 37.7369440992788 | -122.396579478874 | (37.7369440992788, -122.396579478874) | |||
| 60968 | 60968 | 193458 | Undocumented 2 | Malus :: Crab Apple 235 | 1501 Quint St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 4ft | 6013271.5788900005 | 2096363.2217700002 | 37.7369610344099 | -122.39657891500099 | (37.7369610344099, -122.396578915001) | |||
| 61142 | 61142 | 208891 | Undocumented 2 | Malus :: Crab Apple 235 | 843 Detroit St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 5999418.11372 | 2095604.85507 | 37.734098012097704 | -122.44442187207501 | (37.7340980120977, -122.444421872075) | |||
| 65124 | 65124 | 231473 | Undocumented 2 | Malus :: Crab Apple 235 | 400 Prospect Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6006235.9692 | 2097629.5715 | 37.740044082155705 | -122.420994082235 | (37.7400440821557, -122.420994082235) | ||||
| 65143 | 65143 | 193456 | Undocumented 2 | Malus :: Crab Apple 235 | 185 Hampshire St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 5ft | 6010023.67884 | 2107445.7110099997 | 37.76720979983 | -122.40858996078 | (37.76720979983, -122.40858996078) | |||
| 65440 | 65440 | 177472 | Undocumented 2 | Malus :: Crab Apple 235 | 1 Balhi Ct | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6000768.0406599995 | 2090886.53495 | 37.721219518940394 | -122.439416658362 | (37.7212195189404, -122.439416658362) | |||
| 65611 | 65611 | 208875 | Undocumented 2 | Malus :: Crab Apple 235 | 24 Sotelo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993958.96858 | 2101016.35827 | 37.7486436504797 | -122.46368832706699 | (37.7486436504797, -122.463688327067) | |||
| 68461 | 68461 | 231495 | Undocumented 2 | Malus :: Crab Apple 235 | 339 Addison St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6002243.19948 | 2097700.1689299997 | 37.7400120465212 | -122.43480446905701 | (37.7400120465212, -122.434804469057) | |||
| 68915 | 68915 | 177475 | Undocumented 2 | Malus :: Crab Apple 235 | 631 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009520.83405 | 2088792.43347 | 37.7159637900627 | -122.40901294431801 | (37.7159637900627, -122.409012944318) | |||
| 69340 | 69340 | 231470 | Undocumented 2 | Malus :: Crab Apple 235 | 200 Saint Marys Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 2ft | 6003936.80205 | 2095969.7041 | 37.7353565926307 | -122.42882535522 | (37.7353565926307, -122.42882535522) | |||
| 69729 | 69729 | 183309 | Undocumented 2 | Malus :: Crab Apple 235 | 1278 42nd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983073.9761 | 2106459.9318 | 37.7629569477354 | -122.501730586329 | (37.7629569477354, -122.501730586329) | |||
| 71301 | 71301 | 231475 | Undocumented 2 | Malus :: Crab Apple 235 | 107 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009335.06778 | 2096837.2879 | 37.7380428514016 | -122.410222705119 | (37.7380428514016, -122.410222705119) | |||
| 73226 | 73226 | 193444 | Undocumented 2 | Malus :: Crab Apple 235 | 800 19th St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6014945.20165 | 2105329.27451 | 37.7616729293835 | -122.391419022363 | (37.7616729293835, -122.391419022363) | |||
| 73762 | 73762 | 208882 | Undocumented 2 | Malus :: Crab Apple 235 | 322 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994766.7183300005 | 2090736.01345 | 37.7204628590582 | -122.46015046789199 | (37.7204628590582, -122.460150467892) | |||
| 73791 | 73791 | 44446 | Permitted Site 1 | Malus :: Crab Apple 235 | 59 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776702 | 6002663.70845 | 2086958.55404 | 37.7105418493914 | -122.432583452082 | (37.7105418493914, -122.432583452082) | |
| 74742 | 74742 | 193451 | Undocumented 2 | Malus :: Crab Apple 235 | 760 De Haro St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 9ft | 6012093.60455 | 2104911.13829 | 37.7603661389049 | -122.401252219518 | (37.7603661389049, -122.401252219518) | |||
| 76667 | 76667 | 177483 | Undocumented 2 | Malus :: Crab Apple 235 | 37 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6005099.057519999 | 2093268.21852 | 37.7280046286024 | -122.42461489396901 | (37.7280046286024, -122.424614893969) | ||||
| 87383 | 87383 | 99799 | Undocumented 2 | Malus :: Crab Apple 235 | 795-797 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001281.0 | 2102008.0 | 37.7517856535599 | -122.438439910597 | (37.7517856535599, -122.438439910597) | ||||
| 93398 | 93398 | 108273 | Undocumented 2 | Malus :: Crab Apple 235 | 1800x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 101918 | 101918 | 117297 | Undocumented 2 | Malus :: Crab Apple 235 | 801X DUBOCE AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6001906.0 | 2108188.0 | 37.76878996424529 | -122.436720915521 | (37.7687899642453, -122.436720915521) | |||
| 102336 | 102336 | 108272 | Undocumented 2 | Malus :: Crab Apple 235 | 1800x ALAMEDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 105141 | 105141 | 108271 | Undocumented 2 | Malus :: Crab Apple 235 | 1800x ALAMEDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | |||
| 106477 | 106477 | 11189 | DPW Maintained 3 | Malus :: Crab Apple 235 | 130 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995756.5668063 | 2099351.3416202 | 37.7441753471304 | -122.457351852348 | (37.7441753471304, -122.457351852348) | |||
| 110402 | 110402 | 11192 | DPW Maintained 3 | Malus :: Crab Apple 235 | 156 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995565.7362355 | 2099396.4910429 | 37.7442883537687 | -122.458014965266 | (37.7442883537687, -122.458014965266) | |||
| 114652 | 114652 | 97162 | Property Tree 7 | Malus :: Crab Apple 235 | 478 10th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | |||||
| 123744 | 123744 | 208884 | Undocumented 2 | Malus :: Crab Apple 235 | 450 Bright St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 5993793.0659300005 | 2090164.68597 | 37.7188380799952 | -122.46347460498001 | (37.7188380799952, -122.46347460498) | |||
| 125963 | 125963 | 56772 | Permitted Site 1 | Malus :: Crab Apple 235 | 4147 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | Permit Number 777832 | 6002943.47271565 | 2100629.70644343 | 37.748095607753896 | -122.43259241761801 | (37.7480956077539, -122.432592417618) | ||
| 128897 | 128897 | 111270 | DPW Maintained 3 | Malus :: Crab Apple 235 | 700X BOSWORTH ST | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 10 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 129761 | 129761 | 124516 | Undocumented 2 | Malus :: Crab Apple 235 | 2636 McAllister St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5996532.8589 | 2110816.50404 | 37.775700328056104 | -122.455496112673 | (37.7757003280561, -122.455496112673) | |||
| 130280 | 130280 | 177482 | Undocumented 2 | Malus :: Crab Apple 235 | 498 Capistrano Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6000792.34501 | 2092048.92501 | 37.7244125609655 | -122.43941592540199 | (37.7244125609655, -122.439415925402) | |||
| 130939 | 130939 | 177484 | Undocumented 2 | Malus :: Crab Apple 235 | 214 Athens St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6004659.61687 | 2092165.7536099998 | 37.7249526758206 | -122.42605560430401 | (37.7249526758206, -122.426055604304) | ||||
| 130954 | 130954 | 208877 | Undocumented 2 | Malus :: Crab Apple 235 | 136 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5995442.3244199995 | 2097008.8404400002 | 37.7377253637243 | -122.458268913495 | (37.7377253637243, -122.458268913495) | |||
| 131991 | 131991 | 193447 | Undocumented 2 | Malus :: Crab Apple 235 | 2 Coral Rd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012664.558019999 | 2102543.04273 | 37.753895703843206 | -122.39911131862699 | (37.7538957038432, -122.399111318627) | ||||
| 132099 | 132099 | 231467 | Undocumented 2 | Malus :: Crab Apple 235 | 1100 San Jose Ave | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004723.8665 | 2096633.3519400002 | 37.7372233360818 | -122.42615141086901 | (37.7372233360818, -122.426151410869) | ||||
| 132563 | 132563 | 193460 | Undocumented 2 | Malus :: Crab Apple 235 | 1501 Quint St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 4ft | 6013283.26948 | 2096377.10518 | 37.736999805981 | -122.39653946803699 | (37.736999805981, -122.396539468037) | |||
| 133629 | 133629 | 177481 | Undocumented 2 | Malus :: Crab Apple 235 | 498 Capistrano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6000793.16636 | 2092058.9058400001 | 37.7244400127919 | -122.43941380122699 | (37.7244400127919, -122.439413801227) | |||
| 134164 | 134164 | 231481 | Undocumented 2 | Malus :: Crab Apple 235 | 60 Murray St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6004906.208380001 | 2095274.16541 | 37.7335016194909 | -122.425424273006 | (37.7335016194909, -122.425424273006) | |||
| 134828 | 134828 | 114679 | Permitted Site 1 | Malus :: Crab Apple 235 | 836 Brussels St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774714 | 6011176.24092 | 2090873.36995 | 37.7217702116011 | -122.403437363447 | (37.7217702116011, -122.403437363447) | ||
| 141673 | 141673 | 117508 | Undocumented 2 | Malus :: Crab Apple 235 | 21 MOUNTAIN SPRING AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 3x10 | Permit Number 778424 | 5997487.0 | 2104391.0 | 37.758112238825206 | -122.451731896555 | (37.7581122388252, -122.451731896555) | ||
| 141804 | 141804 | 96996 | Significant Tree 6 | Malus :: Crab Apple 235 | 2451X Griffith St | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6015858.3 | 2090034.7 | 37.7197277910807 | -122.38719408923599 | (37.7197277910807, -122.387194089236) | |||||
| 144656 | 144656 | 108274 | Undocumented 2 | Malus :: Crab Apple 235 | 1800x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011533.0 | 2107928.0 | 37.7686184708296 | -122.40340334412501 | (37.7686184708296, -122.403403344125) | ||||
| 147796 | 147796 | 202162 | Undocumented 2 | Malus :: Crab Apple 235 | 10 Kalmanovitz St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6013172.6175 | 2093312.6442 | 37.728579269296205 | -122.396707277937 | (37.7285792692962, -122.396707277937) | |||
| 148264 | 148264 | 231487 | Undocumented 2 | Malus :: Crab Apple 235 | 2119 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 8ft | 6002708.75912 | 2099359.82748 | 37.7445955042953 | -122.433313320275 | (37.7445955042953, -122.433313320275) | |||
| 148440 | 148440 | 208885 | Undocumented 2 | Malus :: Crab Apple 235 | 175 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5994860.83688 | 2099398.63743 | 37.7442537214346 | -122.460452495288 | (37.7442537214346, -122.460452495288) | |||
| 148599 | 148599 | 193445 | Undocumented 2 | Malus :: Crab Apple 235 | 545 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6012707.67421 | 2104954.65178 | 37.7605198573339 | -122.399131478736 | (37.7605198573339, -122.399131478736) | |||
| 149407 | 149407 | 183310 | Undocumented 2 | Malus :: Crab Apple 235 | 1278 42nd Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983073.0612 | 2106470.9099 | 37.762987036737 | -122.501734562858 | (37.762987036737, -122.501734562858) | |||
| 150880 | 150880 | 208886 | Undocumented 2 | Malus :: Crab Apple 235 | 100 Joost Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6001302.89972 | 2094970.3961 | 37.732463294650294 | -122.43786016302799 | (37.7324632946503, -122.437860163028) | |||
| 152846 | 152846 | 244485 | Undocumented 2 | Malus :: Crab Apple 235 | 201 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001267.601 | 2109451.913 | 37.772224053014604 | -122.43901967935 | (37.7722240530146, -122.43901967935) | |||
| 153332 | 153332 | 193448 | Undocumented 2 | Malus :: Crab Apple 235 | 763 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6012158.68635 | 2104851.3982599997 | 37.760205736725794 | -122.40102293286999 | (37.7602057367258, -122.40102293287) | |||
| 153702 | 153702 | 193452 | Undocumented 2 | Malus :: Crab Apple 235 | 760 San Bruno Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6010967.34674 | 2104724.5547 | 37.7597909235418 | -122.405134303232 | (37.7597909235418, -122.405134303232) | ||||
| 154009 | 154009 | 193446 | Undocumented 2 | Malus :: Crab Apple 235 | 2 Coral Rd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6012678.27331 | 2102537.38996 | 37.753880946874204 | -122.399063490894 | (37.7538809468742, -122.399063490894) | ||||
| 155153 | 155153 | 231474 | Undocumented 2 | Malus :: Crab Apple 235 | 2044 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009525.85119 | 2105200.14517 | 37.7610160960274 | -122.410153325135 | (37.7610160960274, -122.410153325135) | |||
| 159111 | 159111 | 231479 | DPW Maintained 3 | Malus :: Crab Apple 235 | 600x San Jose Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005963.8619800005 | 2099704.0736 | 37.7457248540265 | -122.42208225650299 | (37.7457248540265, -122.422082256503) | |||
| 160472 | 160472 | 231489 | Undocumented 2 | Malus :: Crab Apple 235 | 3931 21st St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6002270.32487 | 2103522.49736 | 37.7560003260644 | -122.435127007321 | (37.7560003260644, -122.435127007321) | ||||
| 161532 | 161532 | 177473 | Undocumented 2 | Malus :: Crab Apple 235 | 661 London St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6001084.3995900005 | 2089950.75515 | 37.7186680775449 | -122.438256094064 | (37.7186680775449, -122.438256094064) | ||||
| 162237 | 162237 | 231490 | Undocumented 2 | Malus :: Crab Apple 235 | 144 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004625.22033 | 2097267.44339 | 37.7389588315807 | -122.42653761393 | (37.7389588315807, -122.42653761393) | |||
| 163164 | 163164 | 231491 | Undocumented 2 | Malus :: Crab Apple 235 | 231 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001952.57165 | 2096161.99375 | 37.735772069512294 | -122.435699318774 | (37.7357720695123, -122.435699318774) | |||
| 163384 | 163384 | 183470 | Undocumented 2 | Malus :: Crab Apple 235 | 2535 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988285.2504 | 2098036.7141 | 37.740133768750404 | -122.48308938149599 | (37.7401337687504, -122.483089381496) | |||
| 163544 | 163544 | 231468 | Undocumented 2 | Malus :: Crab Apple 235 | 1100 San Jose Ave | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004726.49867 | 2096628.95996 | 37.7372114254688 | -122.426141997667 | (37.7372114254688, -122.426141997667) | ||||
| 164168 | 164168 | 177470 | Undocumented 2 | Malus :: Crab Apple 235 | 184 Mount Vernon Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998987.4843 | 2089354.3008 | 37.7169108625194 | -122.445461389446 | (37.7169108625194, -122.445461389446) | ||||
| 167813 | 167813 | 231471 | Undocumented 2 | Malus :: Crab Apple 235 | 200 Kingston St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 8ft | 6006257.11637 | 2098029.51803 | 37.741143437710704 | -122.42094935264 | (37.7411434377107, -122.42094935264) |
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");