home / trees

Street_Tree_List

Data source: data.sfgov.org

1,886 rows where qSpecies = 91

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
685 100769 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 3701 21st St   Front Yard : Yard 4 Tree 1 Private 2     55   Street tree w/in RoW 6003717.0 2103606.0 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292) 2 4 5 28862 22
897 101037 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 1010X Portola Dr 11 Front Yard : Yard 4 Tree 1 DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
1780 102060 Private 7 Cupressus macrocarpa :: Monterey Cypress 91 115 Kensington Way 1 Back Yard : Yard 6 Tree 1 Private 2           5994908.3 2098325.8 37.741310707397396 -122.460210667073 (37.7413107073974, -122.460210667073) 1 8 4 59 40
2176 102468 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 50 Saint Germain Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5998217.7 2104179.8 37.757574157371295 -122.44918961776699 (37.7575741573713, -122.449189617767) 15 5 4 28862 38
2274 102573 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 20X Park St 1 Median : Yard 11 Tree 1 DPW 1     24     6004982.6 2096420.1 37.7366524147431 -122.425241679782 (37.7366524147431, -122.425241679782) 2 7 5 28859 2
2397 102706 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 1342 Funston Ave 1 Back Yard : Yard 6 Tree 1 Private 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
2430 102745 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 222 Moncada Way 1 Front Yard : Yard 4 Tree 1 Private 2           5992354.0 2093377.4 37.727576385896604 -122.468682482409 (37.7275763858966, -122.468682482409) 9 8 4 59 40
2989 103351 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 15X Highland Ave 1 Front Yard : Yard 4 Tree 1 DPW 1     18     6004989.3 2096795.8 37.73768438084971 -122.42524524109 (37.7376843808497, -122.42524524109) 2 7 5 28859 7
3056 103422 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 1365 Portola Dr 1 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769779 5993416.2 2097683.7 37.7394617231066 -122.46532315146601 (37.7394617231066, -122.465323151466) 1 8 4 59 40
3153 103516 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 980 Green St 1 Back Yard : Yard 6 Tree 1 Private 2           6008298.0 2118971.0 37.7987586699451 -122.415374854445 (37.7987586699451, -122.415374854445) 5 1 10 308 32
3228 103600 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 50X Hermann St 1 Front Yard : Yard 4 Tree 1 Private 2           6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982) 7 9 5 28852 10
3273 103648 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 500X Oak Park Dr 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     14 3x10   5994983.3 2103652.8 37.755941622135296 -122.460337221652 (37.7559416221353, -122.460337221652) 1 5 4 63 12
3896 104398 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 3525X Ulloa St 1 Median : Yard 11 Tree 1 DPW 1     48     5985120.1668300005 2098189.34613 37.7403681660846 -122.494044040088 (37.7403681660846, -122.494044040088) 1 8 3 29491 35
3897 104399 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 2440X 37th Ave 1 Median : Yard 11 Tree 1 DPW 1           5984875.46821 2098521.80546 37.7412666886784 -122.49491460561501 (37.7412666886784, -122.494914605615) 1 8 3 29491 35
3966 104466 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 1 Median : Yard 11 Tree 1 DPW 1     50     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
4001 104500 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 22 SATURN ST 1 Median : Yard 11 Tree 1 DPW 1     45     6000539.0 2106092.0 37.762957086281396 -122.441298844913 (37.7629570862814, -122.441298844913) 15 5 5 28862 3
4346 104888 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 146 Gonzalez Dr 1 Front Yard : Yard 4 Tree 1 Private 2           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286) 1 8 4 64 14
4450 104998 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 286X CASTENADA AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     60 4x18   5993881.0 2100258.0 37.746556897942 -122.463902900317 (37.746556897942, -122.463902900317) 1 8 4 29491 40
4630 105236 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 235X STATES ST 1 Back Yard : Yard 6 Tree 1 Private 2     30     6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423) 15 5 5 28862 3
4846 105497 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 3929 19TH ST 1 Front Yard : Yard 4 Tree 1 Private 2     60     6003450.9 2104734.8 37.7593959875427 -122.431130714429 (37.7593959875427, -122.431130714429) 2 4 5 28862 3
4995 105649 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 3 Gonzalez Dr 1 Front Yard : Yard 4 Tree 1 Private 2           5990274.6 2090665.2 37.7200090188364 -122.475672946469 (37.7200090188364, -122.475672946469) 1 8 4 64 14
5093 105764 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 1X GONZALEZ DR 1 Front Yard : Yard 4 Tree 1 Private 2           5990111.8 2090190.8 37.718696994740704 -122.476201051717 (37.7186969947407, -122.476201051717) 1 8 4 64 14
5132 105837 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 2100X SLOAT BLVD 4 Median : Yard 11 Tree 1 DPW 1     7     5984309.0 2095832.0 37.733848030924 -122.49667476772 (37.733848030924, -122.49667476772) 1 8 3 64 35
5145 105850 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 44 MENDOSA AVE 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     100 6x15   5993395.1 2101192.7 37.7490953323683 -122.465650972372 (37.7490953323683, -122.465650972372) 1 8 4 29491 40
5180 105889 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 2150X 09TH AVE 11 Median : Cutout 1 Tree 1 Private 2   03/21/2014 12:00:00 AM 40     5993666.0 2101247.0 37.7492600480712 -122.46471814740102 (37.7492600480712, -122.464718147401) 1 8 4 29491 40
5488 106278 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 2 Median : Cutout 1 Tree 1 DPW 1     60     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
5557 106363 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 101 URBANO DR 1 Front Yard : Yard 4 Tree 1 Private 2     80     5993535.8 2092458.1 37.7251204132224 -122.464530299025 (37.7251204132224, -122.464530299025) 9 8 4 59 40
5786 106642 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 4540X 17TH ST 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2     24     5999139.0 2105833.0 37.762166086231204 -122.446122313424 (37.7621660862312, -122.446122313424) 15 5 5 29492 3
5868 106757 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 999 Key Ave 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446) 10 3 8 58 1
6008 106929 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 340 SHOTWELL ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 10x8   6007766.2 2105923.3 37.7629029238803 -122.41629043085 (37.7629029238803, -122.41629043085) 8 4 7 28859 19
6041 106961 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 325 DWIGHT ST   Sidewalk: Curb side : Yard 7 Tree 1 Private 2           6010604.0 2091349.0 37.7230442144558 -122.405448941518 (37.7230442144558, -122.405448941518) 10 3 7 309 28
6042 106962 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 218 SADOWA ST 3 Sidewalk: Property side : Cutout 9 Tree 1 Private 2     22     5994814.0 2087793.9 37.7123872323548 -122.459774032106 (37.7123872323548, -122.459774032106) 9 8 6 28861 24
6192 107159 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 1000 ESMERALDA AVE   Front Yard : Yard 4 Tree 1 Private 2           6009839.0 2098688.0 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619) 10 7 7 28859 2
6971 108074 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 101 BUENA VISTA AVE EAST 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6001336.0 2108482.0 37.769564805176394 -122.438713569331 (37.7695648051764, -122.438713569331) 15 5 5 29492 9
7241 108359 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 5290 DIAMOND HEIGHTS BLVD 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2     20 3x10   6001137.6 2099182.7 37.7440198953745 -122.43873337410601 (37.7440198953745, -122.438733374106) 2 7 5 63 7
7242 108360 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 5290 DIAMOND HEIGHTS BLVD 2 Sidewalk: Property side : Cutout 9 Tree 1 Private 2     30 3x10   6001137.6 2099182.7 37.7440198953745 -122.43873337410601 (37.7440198953745, -122.438733374106) 2 7 5 63 7
7860 108958 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 1400 22ND AVE 1 Sidewalk: Property side : Cutout 9 Tree 1 Private 2       3x3   5989329.4 2105769.6 37.7614269305246 -122.48004495307501 (37.7614269305246, -122.480044953075) 1 8 3 56 35
8155 109251 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 53X DEDMAN CT 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     36     6016647.0 2096311.0 37.7370049195852 -122.384904830601 (37.7370049195852, -122.384904830601) 10 3 8 58 1
8339 109453 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 951 GILMAN AVE 1 Front Yard : Yard 4 Tree 1 Rec/Park 3   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934.0 2089205.0 37.717453787650705 -122.38687458595501 (37.7174537876507, -122.386874585955) 10 3 8 58 1
8391 109516 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 105 MIDCREST WAY   Sidewalk: Property side : Yard 5 Tree 1 Private 2     30 12x12   5998180.4 2101012.8 37.748876224655795 -122.4490904711 (37.7488762246558, -122.4490904711) 1 5 4 63 38
8503 109648 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 1 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8504 109649 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 2 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8505 109650 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 21 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8506 109651 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 22 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8507 109652 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 23 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8508 109653 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 6 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8509 109654 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 25 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8510 109655 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 26 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8511 109656 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 8 Median : Cutout 1 Tree 1 DPW 1   02/27/2015 10:16:00 AM 3     5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8512 109657 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 28 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8513 109658 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 29 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8514 109659 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 800X BROTHERHOOD WAY 30 Median : Cutout 1 Tree 1 DPW 1           5990271.4 2088582.7 37.7142908027957 -122.47553203031799 (37.7142908027957, -122.475532030318) 1 8 4 64 14
8531 109674 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 3 Median : Yard 11 Tree 1 DPW 1           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
8532 109675 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 4 Median : Yard 11 Tree 1 DPW 1           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
8533 109676 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 5 Median : Yard 11 Tree 1 DPW 1           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
8534 109677 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 6 Median : Yard 11 Tree 1 DPW 1           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
8535 109678 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 200X VIDAL DR 7 Median : Yard 11 Tree 1 DPW 1           5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298) 1 8 4 64 14
8563 109706 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 96 CRESTA VISTA DR   Back Yard : Cutout 23 Tree 1 Private 2           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037) 9 7 4 59 40
8676 109893 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 1408x SUNSET BLVD 3 Median : Cutout 1 Tree 1 DPW 1     40 3x3   5984818.0 2105324.0 37.7599402834086 -122.49561490918 (37.7599402834086, -122.49561490918) 1 8 3 56 35
8820 110120 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 507X JOOST AVE 2 Back Yard : Cutout 23 Tree 1 Private 2     45 3x3   5998608.0 2094933.0 37.7322070010706 -122.44717434081801 (37.7322070010706, -122.447174340818) 9 7 4 59 40
8937 110264 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 220x CASHMERE ST 1 Median : Cutout 1 Tree 1 DPW 1       5x40   6015982.5 2095938.0 37.735943960522796 -122.38717631599701 (37.7359439605228, -122.387176315997) 10 3 8 58 1
8949 110277 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 50 HILIRITAS AVE 22 Sidewalk: Property side : Yard 5 Tree 1 Private 2       3x3   6001414.0 2096889.0 37.7377376534528 -122.437613416201 (37.7377376534528, -122.437613416201) 2 7 5 63 7
9466 110865 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 838 34th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     60 6x9   5985433.60853 2110167.44818 37.7732750611072 -122.49384278286699 (37.7732750611072, -122.493842782867) 11 6 2 55 26
9512 110906 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 2891 Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/08/2015 12:00:00 AM 3 3x10 Permit Number 775210 5999784.0596900005 2117390.4095799997 37.7939365889551 -122.44472206489799 (37.7939365889551, -122.444722064898) 13 9 1 57 27
9891 111287 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 450 ROLPH ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3x3   6002226.0 2087613.0 37.7123139824471 -122.434143019741 (37.7123139824471, -122.434143019741) 9 7 6 28861 5
10149 111586 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 730X Lake Merced Blvd 2 Sidewalk: Property side : Yard 5 Tree 1 DPW 1     48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397) 1 8 4 64 14
10150 111587 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 730X Lake Merced Blvd 1 Sidewalk: Property side : Yard 5 Tree 1 DPW 1     48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397) 1 8 4 64 14
10151 111588 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 730X Lake Merced Blvd 4 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3   48     5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397) 1 8 4 64 14
10152 111589 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 730X Lake Merced Blvd 5 Front Yard : Yard 4 Tree 1 DPW for City Agency 5 DPW 3       Permit Number 774260 5987577.495069999 2091187.90071 37.7212874908284 -122.485034126397 (37.7212874908284, -122.485034126397) 1 8 4 64 14
10272 111763 Landmark tree 9 Cupressus macrocarpa :: Monterey Cypress 91 2626 Vallejo St 1 Back Yard : Yard 6 Tree 1 Private 2           6001000.6 2117623.4 37.7946456667745 -122.440529445268 (37.7946456667745, -122.440529445268) 13 9 1 57 27
10336 11185 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 110 Idora Ave 1 Median : Cutout 1 Tree 1 DPW 1     48 8   5995900.4612004 2099322.604417 37.744104705607704 -122.45685222203001 (37.7441047056077, -122.45685222203) 1 8 4 59 40
10393 11191 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 148 Idora Ave 1 Median : Cutout 1 Tree 1 DPW 1     48 8   5995624.0655798 2099382.6906533 37.7442538125131 -122.457812277707 (37.7442538125131, -122.457812277707) 1 8 4 59 40
10631 112187 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 301x CORBETT AVE 3 Sidewalk: Property side : Yard 5 Tree 1 DPW 1       3x3   5999677.0 2105220.0 37.760513648972996 -122.444217531177 (37.760513648973, -122.444217531177) 15 5 5 28862 3
11039 112606 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 100X Monument Way 1 Back Yard : Yard 6 Tree 1 Private 2       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076) 15 5 5 29492 9
11165 112725 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 40x BERNAL HEIGHTS BLVD 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
11166 112726 Significant Tree 4 Cupressus macrocarpa :: Monterey Cypress 91 40x BERNAL HEIGHTS BLVD 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     30 3x3   6009324.0 2098099.0 37.7415066181332 -122.41035003366801 (37.7415066181332, -122.410350033668) 10 7 7 28859 2
11178 112739 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 444 Franconia St 3 Unaccepted Street : Yard 13 Tree 1 Private 2     30     6009949.70212209 2098546.33795552 37.7427699663381 -122.40821810325701 (37.7427699663381, -122.408218103257) 10 7 7 28859 2
11457 113062 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 2X Cranleigh Dr 3 : Yard 25 Tree 1 DPW 1   08/18/2016 09:59:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
11458 113063 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 2X Cranleigh Dr 4 : Yard 25 Tree 1 DPW 1   08/18/2016 09:56:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
11459 113064 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 2X Cranleigh Dr 5 Front Yard : Yard 4 Tree 1 DPW 1   08/18/2016 09:54:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
11460 113065 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 2X Cranleigh Dr 6 Front Yard : Yard 4 Tree 1 DPW 1   08/18/2016 09:51:00 AM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
11461 113066   Cupressus macrocarpa :: Monterey Cypress 91 2X Cranleigh Dr 7 : 14 Tree 1 DPW 1   09/09/2015 01:08:00 PM 3     5991370.3 2095943.7 37.734565924896394 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
11478 113091 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 398X ARBOR ST 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2       3x3   6000747.0 2096921.0 37.7377875715629 -122.439921844785 (37.7377875715629, -122.439921844785) 2 7 5 63 7
11479 113092 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 598x ARBOR ST 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2       3x3   6000747.0 2096921.0 37.7377875715629 -122.439921844785 (37.7377875715629, -122.439921844785) 2 7 5 63 7
11480 113093 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 598x ARBOR ST 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2       3x3   6000747.0 2096921.0 37.7377875715629 -122.439921844785 (37.7377875715629, -122.439921844785) 2 7 5 63 7
11799 113440 Property Tree 5 Cupressus macrocarpa :: Monterey Cypress 91 190 BEACON ST   Back Yard : Yard 6 Tree 1 Private 2     32 3x3   6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833) 2 7 5 63 7
12049 113698 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 91 80 LINARES AVE 1 Sidewalk: Curb side : Yard 7 Tree 1 DPW 1           5994154.8 2102090.7 37.75160480205479 -122.46308908916401 (37.7516048020548, -122.463089089164) 1 8 4 29491 40
12357 114055 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 700X LAKE MERCED BLVD 1 Median : Cutout 1 Tree 1 Private 2     50     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
12358 114056 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 700X LAKE MERCED BLVD 2 Median : Cutout 1 Tree 1 Private 2     61     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
12359 114057 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 700X LAKE MERCED BLVD 3 Median : Cutout 1 Tree 1 Private 2     46     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
12360 114058 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 700X LAKE MERCED BLVD 4 Median : Cutout 1 Tree 1 Private 2     58     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
12361 114059 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 700X LAKE MERCED BLVD 5 Median : Cutout 1 Tree 1 Private 2     38     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
12363 114060 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 700X LAKE MERCED BLVD 6 Median : Cutout 1 Tree 1 Private 2     60     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
12364 114061 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 700X LAKE MERCED BLVD 7 Median : Cutout 1 Tree 1 Private 2     52     5987837.0 2092819.0 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
12369 114066 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 600x LAKE MERCED BLVD 1 Median : Cutout 1 Tree 1 Private 2     36     5987697.0 2093816.0 37.7285105386339 -122.48481373540702 (37.7285105386339, -122.484813735407) 1 8 4 64 14
12431 114125 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 1200X JUNIPERO SERRA BLVD 18 Sidewalk: Property side : Yard 5 Tree 1 Private 2     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12432 114126 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 1200X JUNIPERO SERRA BLVD 19 Sidewalk: Property side : Yard 5 Tree 1 Private 2     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12433 114127 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 1200X JUNIPERO SERRA BLVD 20 Sidewalk: Property side : Yard 5 Tree 1 Private 2     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12434 114128 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 1200X JUNIPERO SERRA BLVD 21 Sidewalk: Property side : Yard 5 Tree 1 Private 2     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14
12435 114129 Undocumented 3 Cupressus macrocarpa :: Monterey Cypress 91 1200X JUNIPERO SERRA BLVD 22 Sidewalk: Property side : Yard 5 Tree 1 Private 2     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304) 1 8 4 64 14

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 74.923ms · Data source: data.sfgov.org